kjartan.malde@uis.no wrote:
I get these errors every hour past two days:
org.postgresql.util.PSQLException: ERROR: invalid message format
[...]
SQLException for update statement: INSERT INTO netboxinfo (netboxid,key,var,val) VALUES ('50','unrecognizedCDP','102','W java.lang.RuntimeException: Got SQLException, aborting put: ERROR: invalid message format
Is it be because HP does not support cdp i newest sw, and if so how do I get rid of these errors?
If this occurred after upgrading the software on the device in question (netboxid=50), then it is likely (your traceback looks like it comes from getBoksMacs, it would be helpful to include the subject linje from e-mail that NAV produces)
The error you are seeing, though, is a result of a protocol error in the communication between the PostgreSQL JDBC driver and the PostgreSQL server. There could be several reasons for this:
* There could be a version mismatch between the JDBC driver and your server.
* There could be a bug in the JDBC driver which makes it fail to properly escape/format certain data from an SQL statement in a protocol message (e.g. if your HP device returned some binary garbage on SNMP requests for CDP data).
Unless you've recently upgraded your PostgreSQL server or driver, I'd say the second theory is the most likely suspect. Can you please tell me what the actual version numbers of your server and your driver are?
You might want to upgrade your driver to the newest one available at http://jdbc.postgresql.org/download.html .