Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12290

Wrong timestamps in binary log causes replication issues

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 10.2.4, 10.1, 10.2, 10.0
    • Fix Version/s: 10.2.6
    • Component/s: Replication
    • Labels:

      Description

      I have configured a MariaDB 10.2.4 GTID Slave with master_delay=3600, and it seems to cause replication to lag behind more and more. Waits trigger even though Seconds_Behind_Master is > 3600.

              Seconds_Behind_Master: 21476
      Master_SSL_Verify_Server_Cert: No
                      Last_IO_Errno: 0
                      Last_IO_Error: 
                     Last_SQL_Errno: 0
                     Last_SQL_Error: 
        Replicate_Ignore_Server_Ids: 
                   Master_Server_Id: 3
                     Master_SSL_Crl: 
                 Master_SSL_Crlpath: 
                         Using_Gtid: No
                        Gtid_IO_Pos: 
            Replicate_Do_Domain_Ids: 
        Replicate_Ignore_Domain_Ids: 
                      Parallel_Mode: conservative
                          SQL_Delay: 3600
                SQL_Remaining_Delay: 3598
      

        Attachments

        1. patch
          0.6 kB
          Sachin Setiya
        2. patch
          0.4 kB
          Sachin Setiya

          Activity

            People

            Assignee:
            sachin.setiya.007 Sachin Setiya
            Reporter:
            tanj Guillaume Lefranc
            Votes:
            1 Vote for this issue
            Watchers:
            8 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: