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

Undo log purge thread stops in replication slave

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.3.10
    • Fix Version/s: 10.3
    • Component/s: Replication
    • Labels:
    • Environment:
      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

            Assignee:
            Elkin Andrei Elkin
            Reporter:
            mis-naka naka sig
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: