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

mysqldump import fails with Streaming Replication

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.4.7
    • N/A
    • Galera
    • None

    Description

      Importing a dump into a cluster with streaming replication enabled fails with:

      ERROR 1235 (42000) at line 31: Streaming replication not supported with binlog_format=STATEMENT

      Enabling the General Log it has been found that this statement causes the problem:

      "LOCK TABLES <table_name> WRITE"

      As workaround using " --skip-add-locks " helps.

      I could not find anything related to this in the documentation.

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            claudio.nanni Claudio Nanni
            Votes:
            2 Vote for this issue
            Watchers:
            5 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.