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

Replication not working after failover -restart pm1

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • None
    • 22.08.7
    • cmapi
    • 2022-22

    Description

      Build tested: 22.08.2, latest build from drone (#5838)

      Steps:

      1. Create a 3PM docker cluster
      2. Check cluster status on PM1. master=PM1, slave=PM2, PM3
      3. Create a database and a table, insert a row in PM1
      4. Verify table gets replicated to PM2
      5. Execute "docker container stop mcs1", wait 90 seconds
      6. Execute "docker container start mcs1", wait 60 seconds
      7. Check cluster status on PM1. master=PM1, slave=PM2, PM3
      Yesterday, I noticed MaxScale had PM2 sat as the master
      Today, MaxScale also set PM1 as the master (I don't know why such behavior today)

      For this test, PM2 was expected to take over as the master

      8. Create another table and inserted a row on PM1
      9. The table did not get replicated to PM2 or PM3
      10. "show slave status" on PM2 returned nothing
      11. "show slave status" on PM3 did return status, and no error

      PM3 slave status showed master log mariadb-bin.000002, position 4684
      PM1 master status showed master log mariadb-bin.000004, position 568

      Attachments

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Alan Mologorsky made transition -
            Open In Progress
            1d 13h 15m 1
            Alan Mologorsky made transition -
            In Progress In Review
            2d 16h 17m 1
            alexey vorovich (Inactive) made transition -
            In Review Closed
            1d 14h 8m 1
            alexey vorovich (Inactive) made transition -
            Closed Stalled
            5h 1m 1
            alexey vorovich (Inactive) made transition -
            Stalled In Progress
            29d 2h 41m 1
            alexey vorovich (Inactive) made transition -
            In Progress In Testing
            3s 1
            Daniel Lee (Inactive) made transition -
            In Testing Closed
            5d 23h 31m 1

            People

              drrtuy Roman
              dleeyh Daniel Lee (Inactive)
              Daniel Lee Daniel Lee (Inactive)
              Votes:
              0 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.