"PSQLException: The column name prefixid not found" in gDD

[Morten Brekkevold]

The following occurs many times over in our getDeviceData-stderr.log:
---
Detected duplicate vlan(48:11) on same gw, deleting ...
org.postgresql.util.PSQLException: The column name prefixid not found.
        at
org.postgresql.jdbc1.AbstractJdbc1ResultSet.findColumn(AbstractJdbc1ResultS
et.java:678)
        at
org.postgresql.jdbc1.AbstractJdbc1ResultSet.getString(AbstractJdbc1ResultSe
t.java:480)
        at
no.ntnu.nav.getDeviceData.dataplugins.Gwport.GwportHandler.handleData(Gwpor
tHandler.java:148)
        at DataContainersImpl.callDataHandlers(DataContainersImpl.java:69)
        at QueryNetbox.run(QueryNetbox.java:806)
---

Seems the GwportHandler doesn't select the prefixid column in it's SQL
statement.

[http://sourceforge.net/tracker/index.php?func=detail&aid=1716297&group_id=107608&atid=648170]

[Morten Brekkevold (mbrekkevold)]

Originator: YES

Fixed by Jostein Gogstad in changeset d8b34f5d67a9. Is already in 3.4.0
RC1

[Morten Brekkevold (mbrekkevold)]

Originator: YES

Complaints from NTNU lead to further study of the code. A quick grokking
of the code suggests that this exception prevents the GwportHandler from
saving any changes in a router's VLAN setup to the database.