Pozdrav svima,
Nakon restartovanja linux hosta, mysql se podize i radi bez problema. Medjutim, mysql server pokazuje nenormalno uptime vreme - stotine (hiljada) godina? Uptime na linux hostu pokazuje ispravno vreme (~30min).
U error logu nema nekih posebnih poruka. Da li je neko imao iskustva sa ovakvim ponasanjem mysql-a?
Nakon restartovanja linux hosta, mysql se podize i radi bez problema. Medjutim, mysql server pokazuje nenormalno uptime vreme - stotine (hiljada) godina? Uptime na linux hostu pokazuje ispravno vreme (~30min).
Code:
mysql> status;
--------------
mysql Ver 14.14 Distrib 5.1.52, for redhat-linux-gnu (x86_64) using readline 5.1
.....
.....
Uptime: --------------
mysql> show global status like 'uptime';
+---------------+----------------------+
| Variable_name | Value |
+---------------+----------------------+
| Uptime | 18446744073709549338 |
+---------------+----------------------+
1 row in set (0.00 sec)
[root@retc]# mysqladmin -u root -p version
Enter password:
mysqladmin Ver 8.42 Distrib 5.1.52, for redhat-linux-gnu on x86_64
Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 5.1.52
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime:
[root@retc]# mysqladmin -u root -p status
Enter password:
Uptime: 18446744073709549593 Threads: 12 Questions: 3342 Slow queries: 0 Opens: 136 Flush tables: 1 Open tables: 64 Queries per second avg: 0.0
[root@retc]# mysqladmin -u root -p extended-status | grep Uptime
Enter password:
| Uptime | 18446744073709549412 |
mysql> status;
--------------
mysql Ver 14.14 Distrib 5.1.52, for redhat-linux-gnu (x86_64) using readline 5.1
.....
.....
Uptime: --------------
mysql> show global status like 'uptime';
+---------------+----------------------+
| Variable_name | Value |
+---------------+----------------------+
| Uptime | 18446744073709549338 |
+---------------+----------------------+
1 row in set (0.00 sec)
[root@retc]# mysqladmin -u root -p version
Enter password:
mysqladmin Ver 8.42 Distrib 5.1.52, for redhat-linux-gnu on x86_64
Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 5.1.52
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime:
[root@retc]# mysqladmin -u root -p status
Enter password:
Uptime: 18446744073709549593 Threads: 12 Questions: 3342 Slow queries: 0 Opens: 136 Flush tables: 1 Open tables: 64 Queries per second avg: 0.0
[root@retc]# mysqladmin -u root -p extended-status | grep Uptime
Enter password:
| Uptime | 18446744073709549412 |
U error logu nema nekih posebnih poruka. Da li je neko imao iskustva sa ovakvim ponasanjem mysql-a?