Hi,
I've run into trouble after upgrading to 3.9.3 via apt-source,
system is debian 6.0.3, this was not a problem with 3.9.2.
First the message during upgrade:
Setting up nav (2+3.9.3-1) ...
Installing new version of config file /etc/nav/sortedStats.conf ...
Installing new version of config file /etc/nav/smsd.conf ...
Installing new version of config file /etc/nav/report/report.conf ...
Traceback (most recent call last):
File "/usr/share/doc/nav/sql/syncdb.py", line 463, in <module>
main()
File "/usr/share/doc/nav/sql/syncdb.py", line 44, in main
sync.synchronize()
File "/usr/share/doc/nav/sql/syncdb.py", line 220, in synchronize
self.apply_changes()
File "/usr/share/doc/nav/sql/syncdb.py", line 305, in apply_changes
self.apply_change_script(version, script)
File "/usr/share/doc/nav/sql/syncdb.py", line 326, in apply_change_script
self.execute_sql_file(script)
File "/usr/share/doc/nav/sql/syncdb.py", line 352, in execute_sql_file
self.cursor.execute(sql)
psycopg2.extensions.QueryCanceledError: canceling statement due to statement timeout
CONTEXT: SQL statement "DELETE FROM ONLY "manage"."rrd_datasource" WHERE $1 OPERATOR(pg_catalog.=) "rrd_fileid""
and if I try adding a new device I get:
Something went wrong
Something went wrong while processing your request. Please try again later.
If the problems persists, contact your system administrator and/or report a bug on NAV bugtracker.
And an error when trying to delete a device:
Error: canceling statement due to statement timeout CONTEXT: SQL statement "UPDATE ONLY "manage"."cam" SET "netboxid" = NULL WHERE $1 OPERATOR(pg_catalog.=) "netboxid""
When digging into the postgres-log I find (everything from a database restart with two delete attempts):
2011-12-07 10:11:04 CET LOG: database system was shut down at 2011-12-07 10:10:55 CET
2011-12-07 10:11:04 CET LOG: database system is ready to accept connections
2011-12-07 10:11:04 CET LOG: autovacuum launcher started
2011-12-07 10:11:05 CET LOG: incomplete startup packet
2011-12-07 10:12:00 CET ERROR: canceling statement due to statement timeout
2011-12-07 10:12:00 CET CONTEXT: SQL statement "UPDATE ONLY "manage"."cam" SET "netboxid" = NULL WHERE $1 OPERATOR(pg_catalog.=) "netboxid""
2011-12-07 10:12:00 CET STATEMENT: DELETE FROM "netbox" WHERE "netboxid" IN (162)
2011-12-07 10:15:01 CET LOG: unexpected EOF on client connection
2011-12-07 10:18:22 CET ERROR: canceling statement due to statement timeout
2011-12-07 10:18:22 CET CONTEXT: SQL statement "UPDATE ONLY "manage"."cam" SET "netboxid" = NULL WHERE $1 OPERATOR(pg_catalog.=) "netboxid""
2011-12-07 10:18:22 CET STATEMENT: DELETE FROM "netbox" WHERE "netboxid" IN (162)
2011-12-07 10:20:02 CET LOG: unexpected EOF on client connection
Anyone having any idea on what's going on? Postgresql has been tuned a bit with allowing 1000 simultaneous connections, but should otherwise be standard.
Best regards,
-Sigurd