Error logged when running a cluster

igniterealtime / openfire-xmldebugger-plugin

Records XMPP traffic which can be useful for debugging purposes

4 stars 7 forks source link

Error logged when running a cluster #19

Open Fishbowler opened 3 years ago

Fishbowler commented 3 years ago

When running the xmldebugger plugin in an Openfire cluster (e.g. https://github.com/surevine/openfire-docker-compose) the following is logged to the console:

ERROR:  duplicate key value violates unique constraint "ofproperty_pk"
DETAIL:  Key (name)=(plugin.xmldebugger.interpretedAllowed) already exists.
STATEMENT:  INSERT INTO ofProperty(name, propValue, encrypted, iv) VALUES($1,$2,$3,$4)

This error is benign and doesn't affect the operation of the plugin on any cluster node.

guusdk commented 3 years ago

Perhaps this is a bug in the xmldebugger plugin, and not so much in this docker setup?

Fishbowler commented 3 years ago

Yeah, that's my suspicion. Specifically SystemProperties.

Monitoring plugin doesn't use them: https://github.com/igniterealtime/openfire-monitoring-plugin/blob/master/src/java/com/reucon/openfire/plugin/archive/xep0313/IQQueryHandler.java#L46