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

Undo log purge thread stops in replication slave

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 10.3.10
    • N/A
    • Replication
    • OS:RHEL7.5

    Description

      Currently, it operates with the configuration of mariaDB (master / slave) + maxscale.

      About once a week, the undo log purge thread stops on the slave side,
      There is a phenomenon that ibdata1 is enlarged.
      (the master side is normal)

      Contents of SHOW ENGINE INNODB STATUS when the phenomenon occurs:
      [Attached file]

      History list length becomes large, and "1 read views open inside InnoDB" occurs.
      It seems that the purge thread has stopped.

      This phenomenon can be solved by stopping replication with "stop slave".

      Where is the cause?
      There may be a problem in the operation between master and slave.

      Attachments

        Activity

          People

            Elkin Andrei Elkin
            mis-naka naka sig
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.