Error In Logs: Unable to record samples: sql_stats.ee4c8acddba503005666f1431d9619e4

[mcthornton5]

Hi All,

After we updated to Jakarta, I started seeing this error message occur every minute in the System Logs:

Unable to record samples: sql_stats.ee4c8acddba503005666f1431d9619e4: org.jrobin.core.RrdException: Bad sample timestamp 1506760766. Last update time was 1506760766, at least one second step is required: org.jrobin.core.RrdDb.store(RrdDb.java:704)

org.jrobin.core.Sample.update(Sample.java:221)

com.glide.velocious.jrobin.backend.JRobinDB.recordSamples(JRobinDB.java:60)

com.glide.velocious.jrobin.da.JRobinWriter.recordSamples(JRobinWriter.java:56)

com.glide.monitor.db.MysqlStatsMonitor.flush(MysqlStatsMonitor.java:115)

com.glide.ui.monitor.InternalMonitor.flushSingletons(InternalMonitor.java:225)

com.glide.ui.monitor.InternalMonitor.run(InternalMonitor.java:195)

Does anyone know what this means? I'm not too sure what sql_stats is, but what follows appears to be a sys_id, and it's the same one every time. Is there anywhere else I can investigate to see what the issue seems to be?

My biggest concern is that it is marked as an error and is logged every minute, and that it appears to be a repeat sys_id.

Thanks so much!

[mcthornton5]

Ah, that makes sense. Would you still recommend I ask Support to take another look?

[sergiu_panaite]

Yes, I would still be interested to find out the root cause.

[Deepak Kumar5]

Hello Sergiu,

Can we deactivate these as I don't think we check these.

Or it should be activate as base configuration?

[sergiu_panaite]

You can't deactivate them, you can the most change the collection interval. These statistics are responsible for populating the ServiceNow Performance dashboard and lots of customers are using that dashboard to check the instance health.

[Deepak Kumar5]

kindly let me know the Table name for Jrobin. Also any article about these if any.