Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-3413

mysqld crashing bin-log replication on UM2 is out of sync

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 1.2.1
    • Icebox
    • MariaDB Server
    • None
    • 2um 3 pm system

    Description

      This issue has happened 3 times over the last month. It required having to cleanup the bin logs on both um1 and um2 to get the system back in service with both UMs.

      I don't know if this is a BUG, but thought it need to be bugged for development info.

      Issue -

      mysqld on UM2 crashes after a restartSystem is perform. restartSystem is perform just as a maintenance requirement, not due to any issue. at restart time, UM2 mysqld crashes during the process of replication of the bin-log files to catch up.
      But for some reason, the bin-log files are not insync with UM1 binary logs and the InnoDB database contained in idbdata1

      To resolved as a work-around:

      1. disabled UM2
      2. startsystem with UM1 working
      3. On UM1, run 'get master status' and check the bin-log shown there is the current one. So the bin-log repliation is update-to-date
      run 'purge binary logs before 'today-date'
      4. on UM2, move or delete the bin and replay log files
      scp idbdata1 from UM1 to UM2
      5. enable UM2

      At this time, the system is back insync and mysqld isnt crashing.

      Attachments

        Activity

          People

            Unassigned Unassigned
            hill David Hill (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.