PSQLException: This statement has been closed. about nav HOT 3 CLOSED

(by mbrekkevold)
Originator: YES

The stacktrace looks ugly/unreadable when displayed on sf.net using a
non-monospaced font. Re-iterating the stacktrace example in this comment:

SQLException for update statement: INSERT INTO netbox_vtpvlan
(netboxid,vtpvlan) VALUES ('379','921')
org.postgresql.util.PSQLException: This statement has been closed.
at
org.postgresql.jdbc2.AbstractJdbc2Statement.checkClosed(AbstractJdbc2Statement.java:2409)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.getUpdateCount(AbstractJdbc2Statement.java:480)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:288)
at no.ntnu.nav.Database.Database.update(Database.java:1004)
at no.ntnu.nav.Database.Database.insert(Database.java:928)
at
no.ntnu.nav.getDeviceData.dataplugins.Netbox.NetboxHandler.handleData(NetboxHandler.java:225)
at
DataContainersImpl.callDataHandlers(DataContainersImpl.java:69)
at QueryNetbox.run(QueryNetbox.java:808)

from nav.

(by mbrekkevold)
Originator: YES

getDeviceData, eventEngine and getBoksMacs are multi-threaded processes
that access the NAV database by means of a common NAV Database API
(no.ntnu.nav.Database). It is uncertain why this error seems to occur more
often while using a PostgreSQL 8.1 JDBC driver, as the JDBC API itself is
unchanged, and so is the NAV code. I cannot remember seeing the exception
while using a 7.4 driver, until the 8.1 problem became apparent and I went
back and checked old logs.

Upon closer inspection, the Database code seems to have a race condition
which should occur all the time, not just when using a 8.1 driver. I will
attempt to fix this race condition.

from nav.

(by mbrekkevold)
Originator: YES

Fixed in r4215. Will be merged with the final version of NAV 3.3.0.

from nav.