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

recurrently we got LOST_EVENTS on slave

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0(EOL)
    • N/A
    • Documentation, Replication
    • Ubuntu 12.04.5 LTS
      Master slave relication, without GTID, parallell replication and row_based replication

    Description

      After we upgraded to 10.0.19-MariaDB-1~precise-log our replication stopped weekly.

      We got on slave

      The incident LOST_EVENTS occured on the master. Message: error writing to the binary log

      We use paralell replication without GTID

      Relay_Log_File: mysqld-relay-bin.002349
                      Relay_Log_Pos: 588779

      #150612 22:47:09 server id 1  end_log_pos 804903        Query   thread_id=292902        exec_time=0     error_code=0
      SET TIMESTAMP=1434142029/*!*/;
      COMMIT
      /*!*/;
      # at 805188
      #150612 22:19:29 server id 1  end_log_pos 804956
      # Incident: LOST_EVENTS
      RELOAD DATABASE; # Shall generate syntax error
      # at 805241

      Attachments

        1. dump.txt
          515 kB
        2. my.cnf
          8 kB

        Activity

          People

            greenman Ian Gilfillan
            bulepage bulepage
            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.