Apart from the 100% CPU utilization/message-bomb client DoS attacks that the Yahoo plugin has been hitting me with, I have the following (occasional) errors in my event log.
org.jivesoftware.wildfire.roster.RosterItemProvider.insertGroups(RosterItemProvi der.java:358)
org.postgresql.util.PSQLException: ERROR: insert or update on table “jiverostergroups” violates foreign key constraint “jiverostergroups_rosterid_fk”
Does anyone have any advice?
Notes:
wildfire=> select * from jiveversion ;
name | version
±—
wildfire | 10
enterprise | 2
gateway | 1
asterisk-im | 0
Full Output:
2006.11.09 18:49:53 org.jivesoftware.wildfire.roster.RosterItemProvider.insertGroups(RosterItemProvi der.java:358)
org.postgresql.util.PSQLException: ERROR: insert or update on table “jiverostergroups” violates foreign key constraint “jiverostergroups_rosterid_fk”
Detail: Key (rosterid)=(17) is not present in table “jiveroster”.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl .java:1512)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java: 1297)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java :430)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2State ment.java:346)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statemen t.java:300)
at org.jivesoftware.wildfire.roster.RosterItemProvider.insertGroups(RosterItemProv ider.java:355)
at org.jivesoftware.wildfire.roster.RosterItemProvider.updateItem(RosterItemProvid er.java:156)
at org.jivesoftware.wildfire.roster.Roster.updateRosterItem(Roster.java:394)
at org.jivesoftware.wildfire.handler.PresenceSubscribeHandler.manageSub(PresenceSu bscribeHandler.java:258)
at org.jivesoftware.wildfire.handler.PresenceSubscribeHandler.process(PresenceSubs cribeHandler.java:113)
at org.jivesoftware.wildfire.PresenceRouter.handle(PresenceRouter.java:118)
at org.jivesoftware.wildfire.PresenceRouter.route(PresenceRouter.java:61)
at org.jivesoftware.wildfire.spi.PacketRouterImpl.route(PacketRouterImpl.java:75)
at org.jivesoftware.wildfire.roster.Roster.deleteRosterItem(Roster.java:433)
at org.jivesoftware.wildfire.gateway.BaseTransport.removeFromRoster(BaseTransport. java:947)
at org.jivesoftware.wildfire.gateway.BaseTransport.syncLegacyRoster(BaseTransport. java:1018)
at org.jivesoftware.wildfire.gateway.protocols.yahoo.YahooSession.syncUsers(YahooS ession.java:181)
at org.jivesoftware.wildfire.gateway.protocols.yahoo.YahooSessionListener.listRece ived(YahooSessionListener.java:159at ymsg.network.Session$FireEvent.run(Unknown Source)