[ninux-dev] [ninux-roma] Fwd: [Sentry] [Misc ninux-graph] ERROR: OperationalError: database is locked

[Nemesis]

E' un errore di sqlite3 [1], ma non lo ricevo più da almeno una settimana.
Forse è un lock che viene messo quando vengono effettuate le migrazioni
di django ( ./manage.py migrate).

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.

[1]: https://www.sqlite.org/cvstrac/wiki?p=DatabaseIsLocked

Nemesis


On 03/21/2016 08:59 AM, Alessandro Gnagni wrote:
>
> Credo sia la configurazione anti abuse sul server. Devi aumentare il
> numero di connessioni concorrenti probabilmente.
> Andrà in blocco quando arrivano troppe richieste contemporaneamente.
>
> Il 17/mar/2016 10:11, "Nemesis" <nemesis at ninux.org
> <mailto:nemesis at ninux.org>> ha scritto:
>
>     Questo è il caso di errore che vi accennavo quando menzionavo
>     "Database is locked".
>
>     Incrementando il numero di nodi che inviano la topologia dovrei
>     riuscirea ricevere più errori di questo tipo.
>
>     Una situazione del genere sarebbe favorevole perchè mi
>     permetterebbe ditrovare una soluzione più resiliente.
>
>
>     -------- Forwarded Message --------
>     Subject: 	[Sentry] [Misc ninux-graph] ERROR: OperationalError:
>     database is locked
>     Date: 	Wed, 16 Mar 2016 05:25:18 -0000
>     From: 	sentry at sentry.publicwifi.it
>     <mailto:sentry at sentry.publicwifi.it>
>     To: 	nemesis at ninux.org <mailto:nemesis at ninux.org>
>
>
>
>     New Issue on Misc ninux-graph.
>     View on Sentry
>     <https://sentry.publicwifi.it:443/openwifi/ninux-graph/issues/1231/>
>
>
>       Sentry <https://sentry.publicwifi.it:443>
>
>
>         New Issue on Misc ninux-graph
>         <https://sentry.publicwifi.it:443/openwifi/ninux-graph/>
>
>     OperationalError: database is locked
>
>     ID: 40086f3b031744a5a379c4cc8f7445d3
>     March 16, 2016, 5:25 a.m. UTC
>
>
>           Exception
>
>     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)
>
>
>           Request
>
>     URL
>     http://ninux-graph.netjson.org/api/receive/e384464c-d1d2-4af3-aae1-4e852...
>     <http://ninux-graph.netjson.org/api/receive/e384464c-d1d2-4af3-aae1-4e852a28d956/?key=XcjLQki4LLvyDkBYG0gnl74evdZ5tIkz>
>
>     Method 	POST
>     Query 	|key=XcjLQki4LLvyDkBYG0gnl74evdZ5tIkz|
>
>
>           User
>
>     IP Address: 	2001:4c00:893b:1:40::31
>
>
>           Tags
>
>       * *browser* /=/ Other
>         <https://sentry.publicwifi.it:443/openwifi/ninux-graph/?browser=Other>
>
>       * *device* /=/ Other
>         <https://sentry.publicwifi.it:443/openwifi/ninux-graph/?device=Other>
>
>       * *level* /=/ error
>         <https://sentry.publicwifi.it:443/openwifi/ninux-graph/?level=error>
>
>       * *os* /=/ Other
>         <https://sentry.publicwifi.it:443/openwifi/ninux-graph/?os=Other>
>       * *sentry:user* /=/ ip:2001:4c00:893b:1:40::31
>         <https://sentry.publicwifi.it:443/openwifi/ninux-graph/?sentry:user=ip:2001:4c00:893b:1:40::31>
>
>       * *server_name* /=/ django
>         <https://sentry.publicwifi.it:443/openwifi/ninux-graph/?server_name=django>
>
>       * *url* /=/ http://ninux-graph.netjson.org/api/receive/e384...
>
>     You are receiving this email due to matching rules: Send a
>     notification for regressions
>     <https://sentry.publicwifi.it:443/openwifi/ninux-graph/settings/rules/52/edit/>
>
>
>     Home <https://sentry.publicwifi.it:443> Notification Settings
>     <https://sentry.publicwifi.it:443/account/settings/notifications/>
>
>
>
>
>     _______________________________________________
>     Roma mailing list
>     Roma at ml.ninux.org <mailto:Roma at ml.ninux.org>
>     http://ml.ninux.org/mailman/listinfo/roma
>
>
>
> _______________________________________________
> Roma mailing list
> Roma at ml.ninux.org
> http://ml.ninux.org/mailman/listinfo/roma

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://ml.ninux.org/pipermail/ninux-dev/attachments/20160321/852388d7/attachment-0001.html>