MySQL timestamp doesn't match system time

[lgarciaac]

Hi everybody,

I have a problem and now idea how can be solved. The MySQL timestamp is frozen. Each time I run a command that should return the current date and time, it doesn't. For instance, I log in my system (Solaris) and run

root@mypc# date

I receive the correct date and time. Then I log into the mysql console and run:

mysql> select now();

And it returns always the same non real date and time, a two days ago date and time (the date when the problem started). When I repeat the operation again tomorrow, it shows again the same date and time, now 3 days backward of course.

I restarted the mysql service, and it worked again ... for couple of days only. I have this problem in more than one server (3)

I haven't found any error in the logs so far

Any help would be welcomed, the clients are driving me crazy right now.

Some data might be helpful, and steps I've followed:

Last login: Sun Jan 16 23:33:26 2011 from xxx
Sun Microsystems Inc.   SunOS 5.10      Generic January 2005

root@server-name ~ # date
[B]Monday, 17 January 2011 06:59:28 GMT[/B]
root@server-name ~ # mysql -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 23501
Server version: 5.1.25-rc-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select current_timestamp();
+---------------------+
| current_timestamp() |
+---------------------+
| [B]2011-01-13 04:23:23[/B] | 
+---------------------+
1 row in set (0.00 sec)

mysql> SHOW VARIABLES LIKE '%zone%';
+------------------+--------+
| Variable_name    | Value  |
+------------------+--------+
| system_time_zone | GMT    | 
| time_zone        | SYSTEM | 
+------------------+--------+
2 rows in set (0.00 sec)

mysql> set timestamp = default;                                                            
Query OK, 0 rows affected (0.00 sec)

mysql> select current_timestamp();
+---------------------+
| current_timestamp() |
+---------------------+
| [B]2011-01-13 04:23:23[/B] | 
+---------------------+
1 row in set (0.00 sec)

Thanks!

[JKing]

Have you tried sysdate()?