Jump to content

EEI and MySQL DB cleanup failing due to time zone change


Go to solution Solved by Peter Randziak,

Recommended Posts

Hello, 

In Chile we changed the hour from winter to summer time and that caused EEI to stop cleaning the MySQL DB correctly:

2020-10-23 00:00:00 03b64 Info: Database cleanup starting...

2020-10-23 00:00:00 03b64 Error: Database cleanup failed on the following SQL error: Sql error 1292. 22007 Incorrect datetime value: '2020-09-06 00:00:00' for column 'l_purge_events_until_upper_border' at row 1. Failing statement: 'CALL procOnRotateEvent( UTC_TIMESTAMP(), ?, ?, ?, ?, ?)'

As DB is full no computer is able to connect to EEI anymore:

2020-10-23 14:17:23 00b00 Error: The disk usage or memory limit reached. Can't accept more data.

We're using EEI 1.4 and MySQL 5.7. Do you know which command, query or whatever can we use in order to fix this issue?

Thank you.

Link to post
Share on other sites
Guest
This topic is now closed to further replies.
  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...