[MDEV-12290] Wrong timestamps in binary log causes replication issues - Jira

XML

Word

Printable

Details

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

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

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

patch
0.6 kB
2017-05-02 11:53
patch
0.4 kB
2017-05-02 11:31

Activity

People

Assignee:: Sachin Setiya (Inactive)

Reporter:: Guillaume Lefranc

Votes:: 1 Vote for this issue

Watchers:: 8 Start watching this issue

Dates

Created:: 2017-03-17 09:01

Updated:: 2017-09-21 08:00

Resolved:: 2017-05-09 11:41

Git Integration

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