Monitoring broken after migration from embed-db to PgSQL


I moved my Openfire DB back-end to postgresql. I have created the respective schema using database/*_postgresql.sql files (for the core and all the plugins), imported data from embedded-db/openfire.script, added and into conf/openfire.xml, and modified .

Unfortunately, OpenFire fills my logs with tons of error messages related to “monitoring” plugin. Other components seems to be OK.

Can you help me, please? Thank you.

The error message looks like this one:

2016.01.02 23:20:27 org.jivesoftware.openfire.reporting.stats.StatsEngine - Error sampling for statistic XXX The underlying backend has no canonical path

    at org.jrobin.core.RrdDb.getCanonicalPath(Unknown Source)

    at org.jrobin.core.Header.validateHeader(Unknown Source)

    at org.jrobin.core.RrdDb.<init>(Unknown Source)

    at org.jrobin.core.RrdDb.<init>(Unknown Source)

    at org.jivesoftware.openfire.reporting.stats.StatsEngine$

    at java.util.concurrent.Executors$


    at java.util.concurrent.ThreadPoolExecutor.runWorker(

    at java.util.concurrent.ThreadPoolExecutor$


where XXX is proxyTransferRate, conversations, muc_outgoing, packet_count, etc.

I am sure that ofrrds table exists:

openfire=# \d ofrrds

          Table "public.ofrrds"

Column | Type | Modifiers


id | character varying(100) | not null

updateddate | bigint | not null

bytes | bytea |


"ofrrds_pk" PRIMARY KEY, btree (id)

And it contains “something”:

openfire=# select id,updateddate from ofrrds;

    id         |  updateddate 


sessions | 1451776587083

muc_occupants | 1451776587096

server_bytes | 1451776587102

conversations | 1451776587113

packet_count | 1451776587126

muc_traffic | 1451776587141

server_sessions | 1451776587153

muc_users | 1451776587158

proxyTransferRate | 1451776587108

muc_rooms | 1451776587149

(10 rows)