Problem with Monitoring Plugin

We’re running OpenFire 3.5.1 and I upgraded to the latest Monitoring plugin yesterday. It shows it as loaded, however, the statsitics tab has disappeared. Here’s a large chunk of the ERROR log file after I restart the plugin. Below that is the WARN log. Any help would be much appreciated.

2008.08.29 11:00:24 [org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngi ne.java:373)
] Error sampling for statistic server_bytes_in
org.jrobin.core.RrdException: Bad sample timestamp 1220025600. Last update time was 1220025600, at least one second step is required
at org.jrobin.core.RrdDb.store(Unknown Source)
at org.jrobin.core.Sample.update(Unknown Source)
at org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngin e.java:367)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2008.08.29 11:00:24 [org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngi ne.java:373)
] Error sampling for statistic muc_users
org.jrobin.core.RrdException: Bad sample timestamp 1220025600. Last update time was 1220025600, at least one second step is required
at org.jrobin.core.RrdDb.store(Unknown Source)
at org.jrobin.core.Sample.update(Unknown Source)
at org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngin e.java:367)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2008.08.29 11:00:24 [org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngi ne.java:373)
] Error sampling for statistic sessions
org.jrobin.core.RrdException: Bad sample timestamp 1220025600. Last update time was 1220025600, at least one second step is required
at org.jrobin.core.RrdDb.store(Unknown Source)
at org.jrobin.core.Sample.update(Unknown Source)
at org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngin e.java:367)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2008.08.29 11:00:24 [org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngi ne.java:373)
] Error sampling for statistic packet_count
org.jrobin.core.RrdException: Bad sample timestamp 1220025600. Last update time was 1220025600, at least one second step is required
at org.jrobin.core.RrdDb.store(Unknown Source)
at org.jrobin.core.Sample.update(Unknown Source)
at org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngin e.java:367)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2008.08.29 11:00:24 [org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngi ne.java:373)
] Error sampling for statistic proxyTransferRate
org.jrobin.core.RrdException: Bad sample timestamp 1220025600. Last update time was 1220025600, at least one second step is required
at org.jrobin.core.RrdDb.store(Unknown Source)
at org.jrobin.core.Sample.update(Unknown Source)
at org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngin e.java:367)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2008.08.29 11:00:24 [org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngi ne.java:373)
] Error sampling for statistic muc_occupants
org.jrobin.core.RrdException: Bad sample timestamp 1220025600. Last update time was 1220025600, at least one second step is required
at org.jrobin.core.RrdDb.store(Unknown Source)
at org.jrobin.core.Sample.update(Unknown Source)
at org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngin e.java:367)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

2008.08.29 11:02:22 Sample time of 1220025720 for statistic muc_rooms is invalid.
2008.08.29 11:02:22 Sample time of 1220025720 for statistic conversations is invalid.
2008.08.29 11:02:22 Sample time of 1220025720 for statistic server_bytes_in is invalid.
2008.08.29 11:02:22 Sample time of 1220025720 for statistic muc_users is invalid.
2008.08.29 11:02:22 Sample time of 1220025720 for statistic sessions is invalid.
2008.08.29 11:02:22 Sample time of 1220025720 for statistic packet_count is invalid.
2008.08.29 11:02:22 Sample time of 1220025720 for statistic proxyTransferRate is invalid.
2008.08.29 11:02:22 Sample time of 1220025720 for statistic muc_occupants is invalid.
2008.08.29 11:02:24 Sample time of 1220025720 for statistic muc_outgoing is invalid.
2008.08.29 11:02:24 Sample time of 1220025720 for statistic server_sessions is invalid.
2008.08.29 11:02:24 Sample time of 1220025720 for statistic muc_rooms is invalid.
2008.08.29 11:02:24 Sample time of 1220025720 for statistic conversations is invalid.
2008.08.29 11:02:24 Sample time of 1220025720 for statistic server_bytes_in is invalid.
2008.08.29 11:02:24 Sample time of 1220025720 for statistic muc_users is invalid.
2008.08.29 11:02:24 Sample time of 1220025720 for statistic sessions is invalid.
2008.08.29 11:02:24 Sample time of 1220025720 for statistic packet_count is invalid.
2008.08.29 11:02:24 Sample time of 1220025720 for statistic proxyTransferRate is invalid.
2008.08.29 11:02:24 Sample time of 1220025720 for statistic muc_occupants is invalid.

have you tried stopping the server deleting the plugin and its specific folder, then starting the server and reinstalling the plugin?

I ran into the same problem and couldn’t fix it… tried removing the plugin via Admin interface, tried stopping server and manually deleting the folders + plugin, etc and then reinstalling it both manually or through the Admin interface. Other posts suggested it might mysteriously fix itself after a few weeks but it was filling up my log files.

Since I just redeployed the server and it was working fine in my verf environmen. I decided to just blow it away and reinstall the server from scratch. I used the import/export plugin to get the user list and imported it back in again (had to set up all the options, groups and Fastpath etc, but that just took 30 mins).

Sorry I can’t be of any help in determining why it’s doing that.

I have the same problem

I think the transformation of the date field in the DB from bigint to date or char should be the problem.

So is there a declared fix for this yet?

The latest version of the monitoring plugin requires openfire 3.6.x to work properly. You need an older version for openfire 3.5.x. Try the plugin in my doc: http://www.igniterealtime.org/community/docs/DOC-1632

Thanks This worked for me.