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