Hello !
I've just re-installed our NAV3 from scratch and I have a odd problem with the CAM collector cron job :
org.postgresql.util.PSQLException: ERROR: invalid message format
at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139) at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152) at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100) at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43) at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:273) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:259) at no.ntnu.nav.Database.Database.update(Database.java:987) at no.ntnu.nav.Database.Database.insert(Database.java:911) at no.ntnu.nav.netboxinfo.NetboxInfo.insertVals(NetboxInfo.java:502) at no.ntnu.nav.netboxinfo.NetboxInfo.putNoError(NetboxInfo.java:359) at no.ntnu.nav.netboxinfo.NetboxInfo.putError(NetboxInfo.java:335) at no.ntnu.nav.netboxinfo.NetboxInfo.put(NetboxInfo.java:326) at no.ntnu.nav.netboxinfo.NetboxInfo.put(NetboxInfo.java:296) at QueryBoks.processCDP(QueryBoks.java:665) at QueryBoks.run(QueryBoks.java:212) SQLException for update statement: INSERT INTO netboxinfo (netboxid,key,var,val) VALUES ('304','unrecognizedCDP','148','`?@') org.postgresql.util.PSQLException: ERROR: invalid message format
at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139) at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152) at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100) at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43) at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:273) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:259) at no.ntnu.nav.Database.Database.update(Database.java:987) at no.ntnu.nav.Database.Database.insert(Database.java:911) at no.ntnu.nav.netboxinfo.NetboxInfo.insertVals(NetboxInfo.java:502) at no.ntnu.nav.netboxinfo.NetboxInfo.putNoError(NetboxInfo.java:359) at no.ntnu.nav.netboxinfo.NetboxInfo.putError(NetboxInfo.java:335) at no.ntnu.nav.netboxinfo.NetboxInfo.put(NetboxInfo.java:326) at no.ntnu.nav.netboxinfo.NetboxInfo.put(NetboxInfo.java:296) at QueryBoks.processCDP(QueryBoks.java:665) at QueryBoks.run(QueryBoks.java:212) java.lang.RuntimeException: Got SQLException, aborting put: ERROR: invalid message format
at no.ntnu.nav.netboxinfo.NetboxInfo.putError(NetboxInfo.java:342) at no.ntnu.nav.netboxinfo.NetboxInfo.put(NetboxInfo.java:326) at no.ntnu.nav.netboxinfo.NetboxInfo.put(NetboxInfo.java:296) at QueryBoks.processCDP(QueryBoks.java:665) at QueryBoks.run(QueryBoks.java:212) SQLException for update statement: INSERT INTO netboxinfo (netboxid,key,var,val) VALUES ('305','unrecognizedCDP','148','`?@')
I'm using postgresql-7.4.9 and pg74.216.jdbc3.jar, have also tried other .jar files without luck.
Wounder what 'unrecognizedCDP' mean ?
-- Med vennlig hilsen / Regards;
Roar Pettersen Universitetet i Bergen - The University of Bergen Nygardsgt. 5 - N-5020 BERGEN - Norway Tlf: +47 55 58 40 55 VIP: 81503 fax: +47 55 58 40 70 roar.pettersen@it.uib.no - IT-Avd, UiB - http://www.uib.no
From kreide at gmail.com Tue Dec 20 09:50:47 2005
From: kreide at gmail.com (Kristian Eide) Date: Tue Dec 20 18:50:55 2005 Subject: [Nav-users] Collects cam data from switches In-Reply-To: Pine.GSO.4.61.0512201119310.15708@alf.uib.no References: Pine.GSO.4.61.0512201119310.15708@alf.uib.no Message-ID: b4c110fd0512200950l494bfce1ydf7a260e6a125ab4@mail.gmail.com
SQLException for update statement: INSERT INTO netboxinfo (netboxid,key,var,val) VALUES ('304','unrecognizedCDP','148','`?@') org.postgresql.util.PSQLException: ERROR: invalid message format Wounder what 'unrecognizedCDP' mean ?
This could be a string escaping issue, but that theory should be easy to test at least. The 'unrecognizedCDP' is a CDP neighbour string for which we were not able to find a matching name in netbox, and it is then stored in netboxinfo (there it is used for correctly dealing with HP stacks IIRC).
-- Kristian