<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">E' un errore di sqlite3 [1], ma non lo
ricevo più da almeno una settimana.<br>
Forse è un lock che viene messo quando vengono effettuate le
migrazioni di django ( ./manage.py migrate).<br>
<br>
Tra l'altro devo ancora provare a far girare django-netjsongraph
con postgresql e vedere se ci sono problemi simili quando arrivano
più richieste HTTP che modificano la stessa topologia.<br>
<br>
[1]: <a class="moz-txt-link-freetext" href="https://www.sqlite.org/cvstrac/wiki?p=DatabaseIsLocked">https://www.sqlite.org/cvstrac/wiki?p=DatabaseIsLocked</a><br>
<br>
Nemesis<br>
<br>
<br>
On 03/21/2016 08:59 AM, Alessandro Gnagni wrote:<br>
</div>
<blockquote
cite="mid:CAE4HSS9CETZMt-Q0ePvSvtaPzOTA1ajbMLAGqemerTX+oF+XaQ@mail.gmail.com"
type="cite">
<p dir="ltr">Credo sia la configurazione anti abuse sul server.
Devi aumentare il numero di connessioni concorrenti
probabilmente.<br>
Andrà in blocco quando arrivano troppe richieste
contemporaneamente.</p>
<div class="gmail_quote">Il 17/mar/2016 10:11, "Nemesis" <<a
moz-do-not-send="true" href="mailto:nemesis@ninux.org"><a class="moz-txt-link-abbreviated" href="mailto:nemesis@ninux.org">nemesis@ninux.org</a></a>>
ha scritto:<br type="attribution">
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> <font face="Helvetica,
Arial, sans-serif">Questo è il <font face="Helvetica,
Arial, sans-serif">caso di errore <font
face="Helvetica, Arial, sans-serif">che vi accennavo <font
face="Helvetica, Arial, sans-serif">quando
menzionavo "<font face="Helvetica, Arial,
sans-serif">Database is locked".<br>
<br>
<font face="Helvetica, Arial, sans-serif">Incrementando
il numero di nodi che inviano la topologia
dovrei riuscirea riceve<font face="Helvetica,
Arial, sans-serif">re pi<font face="Helvetica,
Arial, sans-serif">ù errori di questo tipo.<br>
<br>
<font face="Helvetica, Arial, sans-serif"><font
face="Helvetica, Arial, sans-serif"><font
face="Helvetica, Arial, sans-serif">Una
situa<font face="Helvetica, Arial,
sans-serif">zio<font
face="Helvetica, Arial,
sans-serif">ne del gener<font
face="Helvetica, Arial,
sans-serif">e sarebbe favore<font
face="Helvetica, Arial,
sans-serif">vole perchè mi
permetterebbe di<font
face="Helvetica, Arial,
sans-serif"> <font
face="Helvetica, Arial,
sans-serif">trovare una
soluzione più res<font
face="Helvetica, Arial,
sans-serif">iliente.<br>
</font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font>
<div><br>
<br>
-------- Forwarded Message --------
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<th align="RIGHT" nowrap="nowrap" valign="BASELINE">Subject:
</th>
<td>[Sentry] [Misc ninux-graph] ERROR:
OperationalError: database is locked</td>
</tr>
<tr>
<th align="RIGHT" nowrap="nowrap" valign="BASELINE">Date:
</th>
<td>Wed, 16 Mar 2016 05:25:18 -0000</td>
</tr>
<tr>
<th align="RIGHT" nowrap="nowrap" valign="BASELINE">From:
</th>
<td><a moz-do-not-send="true"
href="mailto:sentry@sentry.publicwifi.it"
target="_blank">sentry@sentry.publicwifi.it</a></td>
</tr>
<tr>
<th align="RIGHT" nowrap="nowrap" valign="BASELINE">To:
</th>
<td><a moz-do-not-send="true"
href="mailto:nemesis@ninux.org" target="_blank">nemesis@ninux.org</a></td>
</tr>
</tbody>
</table>
<br>
<br>
<div
style="max-height:0;padding:0;font-size:0;font-weight:300;line-height:0">
New Issue on Misc ninux-graph. </div>
<table
style="border-radius:4px;font-size:16px;color:#3d4649;border-collapse:separate;border-spacing:0;max-width:700px;font-family:"Lato","Helvetica
Neue",helvetica,sans-serif;border:1px solid
#c7d0d4;padding:0;margin-bottom:20px;width:100%;font-weight:300;margin:10px
auto;background-color:#fff">
<tbody>
<tr style="font-weight:300">
<td
style="padding:0;font-weight:300;margin:0;text-align:center">
<div style="padding:23px
0;font-size:14px;font-weight:300;border-bottom:1px
solid #dee7eb">
<div style="max-width:600px;padding:0
20px;font-weight:300;margin:0
auto;text-align:left"> <a
moz-do-not-send="true"
href="https://sentry.publicwifi.it:443/openwifi/ninux-graph/issues/1231/"
style="border-radius:4px;line-height:18px;color:#fff;float:right;text-decoration:none;padding:8px
15px;background:#15a7f6;font-weight:normal;display:inline-block"
target="_blank">View on Sentry</a>
<h1
style="font-size:38px;color:#000;letter-spacing:-1px;padding:0;font-weight:normal;margin:0;line-height:42px">
<a moz-do-not-send="true"
href="https://sentry.publicwifi.it:443"
style="color:#15a7f6;font-weight:500;text-decoration:none"
target="_blank"><img
moz-do-not-send="true"
src="https://sentry.publicwifi.it:443/_static/1648538aef9e844bd2fa1d620ebf03b048fa76e0/sentry/images/email/sentry_logo_full.png"
alt="Sentry" style="font-weight:300"
height="29px" width="125px"></a> </h1>
</div>
</div>
</td>
</tr>
<tr style="font-weight:300">
<td
style="padding:0;font-weight:300;margin:0;text-align:center">
<div style="max-width:600px;padding:0
20px;font-weight:300;margin:0
auto;text-align:left">
<div style="padding:30px 0
20px;font-weight:300;background:#fff">
<h2
style="font-size:24px;font-weight:700;margin:0
0 20px;margin-bottom:15px"> New Issue on <a
moz-do-not-send="true"
href="https://sentry.publicwifi.it:443/openwifi/ninux-graph/"
style="color:#15a7f6;font-weight:inherit;text-decoration:none"
target="_blank">Misc ninux-graph</a> </h2>
<div
style="font-weight:300;margin-bottom:30px">
<pre style="border-radius:4px;font-size:14px;font-family:Menlo,Monaco,"Courier New",monospace;color:#3d4649;margin-bottom:20px;padding:15px;background:#f4f5f6;white-space:pre-wrap;font-weight:normal;margin:0 0 10px!important">OperationalError: database is locked</pre>
<div
style="color:#889092;float:right;font-weight:300">ID:
40086f3b031744a5a379c4cc8f7445d3</div>
<div style="color:#889092;font-weight:300">March
16, 2016, 5:25 a.m. UTC</div>
</div>
<div
style="font-weight:300;margin-bottom:30px">
<h3
style="font-size:22px;font-weight:700;margin:0
0 20px;margin-bottom:15px">Exception</h3>
<pre style="border-radius:4px;font-size:14px;font-family:Menlo,Monaco,"Courier New",monospace;color:#3d4649;margin-bottom:20px;padding:15px;background:#f4f5f6;white-space:pre-wrap;font-weight:normal;margin:0 0 15px">OperationalError: database is locked
(13 additional frame(s) were not displayed)
...
File "rest_framework/views.py", line 466, in dispatch
response = self.handle_exception(exc)
File "rest_framework/views.py", line 463, in dispatch
response = handler(request, *args, **kwargs)
File "django_netjsongraph/api/views.py", line 49, in post
topology = get_topology_or_404(pk, strategy='receive')
File "django_netjsongraph/utils.py", line 63, in get_topology_or_404
return get_object_or_404(Topology, **kwargs)</pre>
</div>
<div
style="font-weight:300;margin-bottom:30px">
<h3
style="font-size:22px;font-weight:700;margin:0
0 20px;margin-bottom:15px">Request</h3>
<table
style="border-collapse:separate;margin-bottom:20px;border-spacing:5px;width:100%;font-weight:300">
<colgroup style="font-weight:300"><col
style="width:130px;font-weight:300"></colgroup><tbody
style="font-weight:300">
<tr style="font-weight:300">
<th style="padding:5px
0;color:#889092;font-weight:500;min-width:60px;text-align:left">URL</th>
<td style="padding:5px
10px;border-radius:3px;margin-bottom:5px;background:#f4f5f6;font-weight:400;margin:0;text-align:left"><a
moz-do-not-send="true"
href="http://ninux-graph.netjson.org/api/receive/e384464c-d1d2-4af3-aae1-4e852a28d956/?key=XcjLQki4LLvyDkBYG0gnl74evdZ5tIkz"
style="color:#15a7f6;font-weight:500;text-decoration:none"
target="_blank"><a class="moz-txt-link-freetext" href="http://ninux-graph.netjson.org/api/receive/e384464c-d1d2-4af3-aae1-4e852">http://ninux-graph.netjson.org/api/receive/e384464c-d1d2-4af3-aae1-4e852</a>...</a></td>
</tr>
<tr style="font-weight:300">
<th style="padding:5px
0;color:#889092;font-weight:500;min-width:60px;text-align:left">Method</th>
<td style="padding:5px
10px;border-radius:3px;margin-bottom:5px;background:#f4f5f6;font-weight:400;margin:0;text-align:left">POST</td>
</tr>
<tr style="font-weight:300">
<th style="padding:5px
0;color:#889092;font-weight:500;min-width:60px;text-align:left">Query</th>
<td style="padding:5px
10px;border-radius:3px;margin-bottom:5px;background:#f4f5f6;font-weight:400;margin:0;text-align:left">
<code
style="font-size:14px;font-weight:normal;word-break:break-word;font-family:Menlo,Monaco,"Courier
New",monospace">key=XcjLQki4LLvyDkBYG0gnl74evdZ5tIkz</code>
</td>
</tr>
</tbody>
</table>
</div>
<div
style="font-weight:300;margin-bottom:30px">
<h3
style="font-size:22px;font-weight:700;margin:0
0 20px;margin-bottom:15px">User</h3>
<table
style="border-spacing:5px;width:100%;border-collapse:separate;font-weight:300;margin-bottom:20px">
<tbody>
<tr style="font-weight:300">
<td
style="padding:0;border-radius:3px;margin-bottom:5px;background:#fff;padding-top:0;font-weight:400;margin:0;text-align:left">
<table
style="border-collapse:separate;margin-bottom:20px;border-spacing:5px;width:100%;font-weight:300">
<colgroup style="font-weight:300"><col
style="width:130px;font-weight:300"></colgroup><tbody
style="font-weight:300">
<tr style="font-weight:300">
<th style="padding:5px
0;color:#889092;font-weight:500;min-width:60px;text-align:left">IP
Address:</th>
<td style="padding:5px
10px;border-radius:3px;margin-bottom:5px;background:#f4f5f6;font-weight:400;margin:0;text-align:left">2001:4c00:893b:1:40::31</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
<h3
style="font-size:22px;font-weight:700;margin:0
0 20px">Tags</h3>
<ul
style="padding:0;list-style:none;font-weight:300;margin:0
0 20px">
<li style="border-radius:3px;padding:5px
10px
6px;background:#f4f5f6;margin-right:5px;font-weight:300;display:inline-block;margin-bottom:10px">
<strong style="font-weight:200">browser</strong>
<em style="font-weight:300">=</em> <span
style="font-weight:300"><a
moz-do-not-send="true"
href="https://sentry.publicwifi.it:443/openwifi/ninux-graph/?browser=Other"
style="color:#15a7f6;font-weight:500;text-decoration:none"
target="_blank">Other</a> </span> </li>
<li style="border-radius:3px;padding:5px
10px
6px;background:#f4f5f6;margin-right:5px;font-weight:300;display:inline-block;margin-bottom:10px">
<strong style="font-weight:200">device</strong>
<em style="font-weight:300">=</em> <span
style="font-weight:300"><a
moz-do-not-send="true"
href="https://sentry.publicwifi.it:443/openwifi/ninux-graph/?device=Other"
style="color:#15a7f6;font-weight:500;text-decoration:none"
target="_blank">Other</a> </span> </li>
<li style="border-radius:3px;padding:5px
10px
6px;background:#f4f5f6;margin-right:5px;font-weight:300;display:inline-block;margin-bottom:10px">
<strong style="font-weight:200">level</strong>
<em style="font-weight:300">=</em> <span
style="font-weight:300"><a
moz-do-not-send="true"
href="https://sentry.publicwifi.it:443/openwifi/ninux-graph/?level=error"
style="color:#15a7f6;font-weight:500;text-decoration:none"
target="_blank">error</a> </span> </li>
<li style="border-radius:3px;padding:5px
10px
6px;background:#f4f5f6;margin-right:5px;font-weight:300;display:inline-block;margin-bottom:10px">
<strong style="font-weight:200">os</strong>
<em style="font-weight:300">=</em> <span
style="font-weight:300"><a
moz-do-not-send="true"
href="https://sentry.publicwifi.it:443/openwifi/ninux-graph/?os=Other"
style="color:#15a7f6;font-weight:500;text-decoration:none"
target="_blank">Other</a> </span> </li>
<li style="border-radius:3px;padding:5px
10px
6px;background:#f4f5f6;margin-right:5px;font-weight:300;display:inline-block;margin-bottom:10px">
<strong style="font-weight:200">sentry:user</strong>
<em style="font-weight:300">=</em> <span
style="font-weight:300"><a
moz-do-not-send="true"
href="https://sentry.publicwifi.it:443/openwifi/ninux-graph/?sentry:user=ip:2001:4c00:893b:1:40::31"
style="color:#15a7f6;font-weight:500;text-decoration:none"
target="_blank">ip:2001:4c00:893b:1:40::31</a>
</span> </li>
<li style="border-radius:3px;padding:5px
10px
6px;background:#f4f5f6;margin-right:5px;font-weight:300;display:inline-block;margin-bottom:10px">
<strong style="font-weight:200">server_name</strong>
<em style="font-weight:300">=</em> <span
style="font-weight:300"><a
moz-do-not-send="true"
href="https://sentry.publicwifi.it:443/openwifi/ninux-graph/?server_name=django"
style="color:#15a7f6;font-weight:500;text-decoration:none"
target="_blank">django</a> </span> </li>
<li style="border-radius:3px;padding:5px
10px
6px;background:#f4f5f6;margin-right:5px;font-weight:300;display:inline-block;margin-bottom:10px">
<strong style="font-weight:200">url</strong>
<em style="font-weight:300">=</em> <span
style="font-weight:300"><a
moz-do-not-send="true"
href="http://ninux-graph.netjson.org/api/receive/e384"
target="_blank"><a class="moz-txt-link-freetext" href="http://ninux-graph.netjson.org/api/receive/e384">http://ninux-graph.netjson.org/api/receive/e384</a></a>...
</span> </li>
</ul>
<p
style="border-radius:3px;font-size:16px;margin:0
0
15px;padding:15px;font-weight:300;border:1px
solid
#cfd9de;line-height:24px;text-align:center">
You are receiving this email due to matching
rules: <a moz-do-not-send="true"
href="https://sentry.publicwifi.it:443/openwifi/ninux-graph/settings/rules/52/edit/"
style="color:#15a7f6;font-weight:500;text-decoration:none"
target="_blank">Send a notification for
regressions</a> </p>
<div style="font-weight:300">
<div style="font-weight:300"> </div>
<div style="font-weight:300"> </div>
</div>
</div>
<div style="padding:35px 0;border-top:1px solid
#e7ebee;font-weight:300"> <a
moz-do-not-send="true"
href="https://sentry.publicwifi.it:443"
style="color:#687276;float:right;font-weight:500;text-decoration:none"
target="_blank">Home</a> <a
moz-do-not-send="true"
href="https://sentry.publicwifi.it:443/account/settings/notifications/"
style="color:#687276;font-weight:500;text-decoration:none"
target="_blank">Notification Settings</a> </div>
</div>
</td>
</tr>
</tbody>
</table>
<br>
</div>
<br>
</div>
<br>
_______________________________________________<br>
Roma mailing list<br>
<a moz-do-not-send="true" href="mailto:Roma@ml.ninux.org">Roma@ml.ninux.org</a><br>
<a moz-do-not-send="true"
href="http://ml.ninux.org/mailman/listinfo/roma"
rel="noreferrer" target="_blank">http://ml.ninux.org/mailman/listinfo/roma</a><br>
<br>
</blockquote>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Roma mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Roma@ml.ninux.org">Roma@ml.ninux.org</a>
<a class="moz-txt-link-freetext" href="http://ml.ninux.org/mailman/listinfo/roma">http://ml.ninux.org/mailman/listinfo/roma</a>
</pre>
</blockquote>
<br>
</body>
</html>