Below are the errors in the logs. The other logs don't have errors. One noticeable bug is that I can only add two instances of the "Cisco Catalyst 6000 MSFC2" with SysObjectID=1.3.6.1.4.1.9.1.301

If I delete those two I can add two other of those, but can never add more than two. This is not a problem with other switches. Trying to add a third gives me an error:

Mod_python error: "PythonHandler editdb"

Traceback (most recent call last):

File "/usr/lib/python2.3/site-packages/mod_python/apache.py", line 299, in HandlerDispatch result = object(req)

File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 156, in handler output = editPage(req,pageList[table](),request,unicodeError)

File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 463, in editPage outputForm,action)

File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 2435, in add disabled=True))

TypeError: __init__() takes at least 2 non-keyword arguments (1 given) ------------------

eventEngine.log:

Jul 15 06:41:16 2005 eventEngine EVENTQ_MONITOR_TASK-3-RUN SQLException when fetching from eventq: Operation requires a scrollable ResultSet, but this ResultSet is FORWARD_ONLY. ------------------

networkDiscovery-stderr.log:

SQLException: Operation requires a scrollable ResultSet, but this ResultSet is FORWARD_ONLY. org.postgresql.util.PSQLException: Operation requires a scrollable ResultSet, but this ResultSet is FORWARD_ONLY. at org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkScrollable(AbstractJdbc 2ResultSet.java:179) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.beforeFirst(AbstractJdbc2Res ultSet.java:251) at networkDiscovery.avledVlan(networkDiscovery.java:1113) at networkDiscovery.main(networkDiscovery.java:93) ------------------

getDeviceData-stderr.log has a lot of similar errors, this is the last:

SQLException for update statement: INSERT INTO swport (swportid,moduleid,ifindex,speed) VALUES ('441','32','63','1000') org.postgresql.util.PSQLException: This statement has been closed. at org.postgresql.jdbc2.AbstractJdbc2Statement.checkClosed(AbstractJdbc2Sta tement.java:2304) at org.postgresql.jdbc2.AbstractJdbc2Statement.getUpdateCount(AbstractJdbc2 Statement.java:432) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2S tatement.java:268) at no.ntnu.nav.Database.Database.update(Database.java:999) at no.ntnu.nav.Database.Database.insert(Database.java:923) at no.ntnu.nav.getDeviceData.dataplugins.Swport.SwportHandler.handleData(Sw portHandler.java:239) at DataContainersImpl.callDataHandlers(DataContainersImpl.java:64) at QueryNetbox.run(QueryNetbox.java:791)

---------------- Aditya Rajgarhia 305 Kemp Hall x2042 arajgarh@iwu.edu

From kreide at gmail.com Fri Jul 15 11:22:36 2005

From: kreide at gmail.com (Kristian Eide) Date: Fri Jul 15 19:22:46 2005 Subject: [Nav-users] Error adding particular switch In-Reply-To: 7113539.1121446237565.JavaMail.arajgarh@iwu.edu References: 7113539.1121446237565.JavaMail.arajgarh@iwu.edu Message-ID: b4c110fd0507151022207f8eb2@mail.gmail.com

when fetching from eventq: Operation requires a scrollable ResultSet, but this ResultSet is FORWARD_ONLY.

The cause of this error is that there was a change in newer JDBC drivers for Postgre which create non-scrollable resultsets by default. We will provide a fix for this in our next RC (expected next week).

SQLException for update statement: INSERT INTO swport (swportid,moduleid,ifindex,speed) VALUES ('441','32','63','1000') org.postgresql.util.PSQLException: This statement has been closed.

This might be related to the above problem, but I will look into it as well.