[MCOL-3413] mysqld crashing bin-log replication on UM2 is out of sync Created: 2019-08-05  Updated: 2023-03-06

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 1.2.1
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: David Hill (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

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.


Generated at Thu Feb 08 02:42:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.