Bug #29538 clock skew gives impossible time behind master on slave

Submitted: 4 Jul 2007 2:03 Modified: 4 Jul 2007 9:16
Reporter: River Tarnell Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.0.42-enterprise-gpl OS:Solaris (Solaris 10 11/06)
Assigned to: CPU Architecture:Any

[4 Jul 2007 2:03] River Tarnell
Description:
The MySQL replication SQL thread's running time is usually set to the lag behind the master server.  If there is clock skew between the master and the slave, and the slave gets a binlog event which appears to be in the future, it will show an impossible value instead:

*************************** 2. row ***************************
     Id: 2
   User: system user
   Host:
     db: enwiki
Command: Connect
   Time: 4294967295
  State: Reading event from the relay log
   Info: COMMIT

How to repeat:
Set up a master/slave where the master's clock is ahead of the slave's.  Start replication and run SHOW PROCESSLIST; on the slave.

Suggested fix:
Either show 0, or show the actual difference, e.g. "-2" if the master event is 2 seconds in the future.
[4 Jul 2007 9:16] Sveta Smirnova
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Duplicate of Bug #22047

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.