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

Wrong timestamps in binary log causes replication issues

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.0, 10.1, 10.2.4, 10.2
    • 10.2.6
    • Replication

    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
        2. patch
          0.4 kB

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.