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

The relay-log is not flushed after the slave-relay-log.999999 showed

Details

    Description

      I am using MariaDB 10.0.14 at CentOS 6.5.
      And, as I mentioned at the title of this question, the relay-log is not
      flushed after the slave-relay-log.999999 showed when using
      "Salve_parallel_threads:10" setting. like showed blow.

      • binlog_format: ROW
      • Slave_parallel_threads:10

      Everything are working fine except the "slave-relay-log.******" files
      continue to exist at the disk which will finally cause the disk full.
      If I change the value of Slave_parallel_threads setting from 10 to 0,
      the log will be flushed. Howevery "PK duplicate warning" error logs come
      next.

      Is there any setting should be used with Slave_parallel_threads setting?
      Any help will be great.

      Best regareds,

      Attachments

        Issue Links

          Activity

            irani ilhwan Kim created issue -
            ratzpo Rasmus Johansson (Inactive) made changes -
            Field Original Value New Value
            Workflow MariaDB v2 [ 60901 ] MariaDB v3 [ 62884 ]
            elenst Elena Stepanova made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            elenst Elena Stepanova made changes -
            Status Confirmed [ 10101 ] Open [ 1 ]
            elenst Elena Stepanova made changes -
            Labels need_feedback
            irani ilhwan Kim made changes -
            Comment [ A comment with security level 'Users' was removed. ]
            elenst Elena Stepanova made changes -
            Labels need_feedback
            elenst Elena Stepanova made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            elenst Elena Stepanova made changes -
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.0 [ 16000 ]
            Affects Version/s 10.1 [ 16100 ]
            Affects Version/s 10.0 [ 16000 ]
            Assignee Kristian Nielsen [ knielsen ]
            Priority Critical [ 2 ] Major [ 3 ]
            serg Sergei Golubchik made changes -
            Summary The relay-log is not fluashed after the slave-relay-log.999999 showed The relay-log is not flushed after the slave-relay-log.999999 showed
            DZW David Zhao made changes -
            Attachment 999999.diff [ 47989 ]
            julien.fritsch Julien Fritsch made changes -
            Assignee Kristian Nielsen [ knielsen ] Andrei Elkin [ elkin ]
            julien.fritsch Julien Fritsch made changes -
            Labels need_feedback
            Elkin Andrei Elkin made changes -
            Labels need_feedback contribution
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.2 [ 14601 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.0 [ 16000 ]
            Fix Version/s 10.1 [ 16100 ]
            Elkin Andrei Elkin made changes -
            Assignee Andrei Elkin [ elkin ] Sujatha Sivakumar [ sujatha.sivakumar ]
            Elkin Andrei Elkin made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            sujatha.sivakumar Sujatha Sivakumar (Inactive) made changes -
            Status Confirmed [ 10101 ] In Progress [ 3 ]
            sujatha.sivakumar Sujatha Sivakumar (Inactive) made changes -
            Assignee Sujatha Sivakumar [ sujatha.sivakumar ] Andrei Elkin [ elkin ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            Elkin Andrei Elkin made changes -
            Assignee Andrei Elkin [ elkin ] Sachin Setiya [ sachin.setiya.007 ]
            sachin.setiya.007 Sachin Setiya (Inactive) made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            sachin.setiya.007 Sachin Setiya (Inactive) made changes -
            Assignee Sachin Setiya [ sachin.setiya.007 ] Sujatha Sivakumar [ sujatha.sivakumar ]
            sujatha.sivakumar Sujatha Sivakumar (Inactive) made changes -
            issue.field.resolutiondate 2021-01-21 07:38:26.0 2021-01-21 07:38:26.901
            sujatha.sivakumar Sujatha Sivakumar (Inactive) made changes -
            Fix Version/s 10.2.37 [ 25112 ]
            Fix Version/s 10.3.28 [ 25111 ]
            Fix Version/s 10.4.18 [ 25110 ]
            Fix Version/s 10.5.9 [ 25109 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            Elkin Andrei Elkin made changes -
            Labels contribution contribution slave-relay-log
            rob.schwyzer@mariadb.com Rob Schwyzer (Inactive) made changes -
            rob.schwyzer@mariadb.com Rob Schwyzer (Inactive) made changes -
            rob.schwyzer@mariadb.com Rob Schwyzer (Inactive) made changes -
            rob.schwyzer@mariadb.com Rob Schwyzer (Inactive) made changes -
            Labels contribution slave-relay-log ServiceNow contribution slave-relay-log
            rob.schwyzer@mariadb.com Rob Schwyzer (Inactive) made changes -
            Labels ServiceNow contribution slave-relay-log 76qDvLB8Gju6Hs7nk3VY3EX42G795W5z contribution slave-relay-log
            serg Sergei Golubchik made changes -
            Labels 76qDvLB8Gju6Hs7nk3VY3EX42G795W5z contribution slave-relay-log contribution slave-relay-log
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 62884 ] MariaDB v4 [ 149150 ]
            rob.schwyzer@mariadb.com Rob Schwyzer (Inactive) made changes -
            rob.schwyzer@mariadb.com Rob Schwyzer (Inactive) made changes -
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 201658 200242
            Zendesk active tickets 201658

            People

              sujatha.sivakumar Sujatha Sivakumar (Inactive)
              irani ilhwan Kim
              Votes:
              5 Vote for this issue
              Watchers:
              12 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.