Description:
I am using MySQL 8.0.17. For some reason, I need to change the date of my system to after 2038. Unfortunately, the MySQL service won't start after the year 2038:
If i change the system date to any of the dates after year 2038. I get the following error message.
2038-01-19T17:55:45.076894Z 24 [Warning] Current time has got past year 2038. Validating current time with 5 iterations before initiating the normal server shutdown process.
2038-01-19T17:55:45.076914Z 24 [Warning] Iteration 1: Current time obtained from system is greater than 2038
2038-01-19T17:55:45.076919Z 24 [Warning] Iteration 2: Current time obtained from system is greater than 2038
2038-01-19T17:55:45.076922Z 24 [Warning] Iteration 3: Current time obtained from system is greater than 2038
2038-01-19T17:55:45.076926Z 24 [Warning] Iteration 4: Current time obtained from system is greater than 2038
2038-01-19T17:55:45.076930Z 24 [Warning] Iteration 5: Current time obtained from system is greater than 2038
2038-01-19T17:55:45.076934Z 24 [ERROR] This MySQL server doesn't support dates later then 2038
2038-01-19T17:55:47.004710Z 0 [System] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.17) Source distribution.
I am using 64 bit MySQL.
Please help.
How to repeat:
To repeat please do the following restart method :
1/ Set up server date with command:
date -s "2038-12-22 $(date +%H:%M:%S)"
2/ Start service with command
service mysql restart