RRD won't graph every morning with MYSQL 1213 Deadlock error log

Help
1

Hi folks,

I noticed all of diagram can’t be graphed during 08:00 to 09:00 every morning.
I tried to dumped rrd file and I got NaN value during the period.

Besides, I noticed there have MYSQL error in librenms.log , and there have “1213 Deadlock” error below during same period.

Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction (SQL: UPDATE alert_log set details=XXXXXXXX

Is this kind of bug for alert log update and cause rrd graph issue?

2

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.