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

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?

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