On 2011-12-07 10:29, Sigurd Mytting wrote:
Hi,
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) ...
I did a little digging and found the statement timeout was due to a 30 second time limit on transactions in postgresql.conf, changed that to the default value of 0 (wait forever). After then trying to run syncdb.py for seven hours I terminated it. Some more digging showed the statement "DELETE FROM rrd_file WHERE netboxid IS NULL;" did not terminate, but "select *" gave over 7700 lines. Deleting them one by one using the rrd_fileid and "netboxid IS NULL" cleaned up the database in a few minutes.
After adjusting the timeout value I can delete devices, but still get errors when adding devices - however bulk import seems to work.
Don't know if it's related, but the postgres-log contains a lot of "LOG: unexpected EOF on client connection".
cheers,
-Sigurd