MySQL

Last_SQL_Error: Error Table is marked as crashed and should be repaired

Today we had an issue with our Master-Master replication. Master2 was throwing the below error and the replication was stopped Last_SQL_Errno: 145 Last_SQL_Error: Error ‘Table ‘./exampledb/exampletable’ is marked as crashed and should be repaired’ on query. Default database: ‘livewbmy_db’. Query: ‘INSERT INTO `exampletable` (`challenge`, `response`, `hashkey`, `expiration`) VALUES (‘XBUL’, ‘xbul’, ‘a9e0f4e3dxxxxxccccccc0c8f8f1’, ‘2016-09-29 21:10:03′)’ Since its …

Last_SQL_Error: Error Table is marked as crashed and should be repaired Read More »

Got fatal error 1236 from master – MySQL – Broken Master – Master Replication

Scenario You have a MySQL Master-Master replication setup, Lets say Master1 (LIVE) and Master2 (DR Warm Standby) Master2 server has been restarted for some reason. Now Master1 LIVE (the slave of DR) slave status is stopped with the below error. Last_IO_Errno: 1236 Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘Could not …

Got fatal error 1236 from master – MySQL – Broken Master – Master Replication Read More »

Scroll to Top