Mysql Out of range value

[Domi 0]

Hello again,

 

At the moment we are working on 40k files from speedi with vanilla core 2.4.1 Hotfix 2 and we found an error occurre in our syserr which looks like this:

SYSERR: Nov 23 21:20:37 :: pid_init: 
Start of pid: 958
SYSERR: Nov 23 21:20:37 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'time' at row 1 (query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'auth_test', 1) errno: 1264)
SYSERR: Nov 23 21:22:40 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Nov 23 21:22:40 :: pid_deinit: 
End of pid

MySQL 5.6 with no special changes.

 

 - .Domii

[Domi 0]

Found a solution by myself. The Problem was that:

 

time column was INT instead of DATE in the Database and the second error which occurred right after we fixed this issue was that the hostname column was also INT instead of VARCHAR. Simply ALTER TABLE on bootlog fixed this issue for us.

 

Thanks