Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
None
-
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
- is blocked by
-
-
- Closed
-
- relates to
-
-
- Closed
-
- mentioned in
-
Page Failed to load
-
Page Failed to load
-
Page Failed to load
-
Page Loading...
-
-
-
-
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Rank | Ranked higher |
| Rank | Ranked lower |
| Priority | Major [ 3 ] | Blocker [ 1 ] |
| Assignee | Alan Mologorsky [ JIRAUSER49150 ] |
| Rank | Ranked higher |
| Sprint | 2022-22 [ 672 ] |
| Rank | Ranked lower |
| Fix Version/s | 22.11.01 [ 28458 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Summary | Replication not working after failover | Replication not working after failover -restart pm1 |
| Fix Version/s | 22.11.1 [ 28458 ] | |
| Resolution | Duplicate [ 3 ] | |
| Status | In Review [ 10002 ] | Closed [ 6 ] |
| Resolution | Duplicate [ 3 ] | |
| Status | Closed [ 6 ] | Stalled [ 10000 ] |
| Assignee | Alan Mologorsky [ JIRAUSER49150 ] | Todd Stoffel [ toddstoffel ] |
| Fix Version/s | 22.11.1 [ 28458 ] |
| Assignee | Todd Stoffel [ toddstoffel ] | Roman [ drrtuy ] |
| Fix Version/s | 23.02 [ 28209 ] | |
| Fix Version/s | 23.03.1 [ 28458 ] |
| Fix Version/s | 22.08.6 [ 28542 ] | |
| Fix Version/s | 23.02 [ 28209 ] |
| Attachment | yes_mxs.log [ 67353 ] |
| Assigned for Testing | Daniel Lee [ dleeyh ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | In Testing [ 10301 ] |
| Resolution | Fixed [ 1 ] | |
| Status | In Testing [ 10301 ] | Closed [ 6 ] |
| Attachment | a0001_failover.result [ 67439 ] |
| Labels | cluster |
| Remote Link | This issue links to "Page (MariaDB Confluence)" [ 36766 ] |
| Remote Link | This issue links to "Page (MariaDB Confluence)" [ 36859 ] |
| Remote Link | This issue links to "Page (MariaDB Confluence)" [ 36894 ] |
| Remote Link | This issue links to "Page (MariaDB Confluence)" [ 36924 ] |
| Remote Link | This issue links to "Page (MariaDB Confluence)" [ 36946 ] |
| Remote Link | This issue links to "Page (MariaDB Confluence)" [ 37006 ] |
| Remote Link | This issue links to "Page (MariaDB Confluence)" [ 37032 ] |
| Remote Link | This issue links to "Page (MariaDB Confluence)" [ 37062 ] |
| Remote Link | This issue links to "Page (MariaDB Confluence)" [ 37093 ] |