Skip to content

Instantly share code, notes, and snippets.

@josephglanville
Created July 28, 2016 12:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save josephglanville/e87ae96b9be9125427b58cd3a43d5c1e to your computer and use it in GitHub Desktop.
Save josephglanville/e87ae96b9be9125427b58cd3a43d5c1e to your computer and use it in GitHub Desktop.
MariaDB hang
2016-07-28T12:49:59.135827Z app[mariadb.host2-34df8696-457d-47a8-9014-f67ce6ebbd9b]: 2016-07-28 12:49:59 139690207103744 [Note] ReplSemiSyncMaster::updateSyncHeader: server(1684293900), (mariadb-bin.000005, 105654222) sync(1), repl(1)
2016-07-28T12:49:59.135934Z app[mariadb.host2-34df8696-457d-47a8-9014-f67ce6ebbd9b]: 2016-07-28 12:49:59 139690207103744 [Note] ReplSemiSyncMaster::readSlaveReply: Wait for replica's reply
2016-07-28T12:49:59.135897Z app[mariadb.host0-42aa03f8-a07d-497d-9534-074b8af0bf46]: 2016-07-28 12:49:59 140201364466432 [Note] ReplSemiSyncSlave::slaveReadSyncHeader: reply - 0
2016-07-28T12:49:59.401808Z app[mariadb.host2-34df8696-457d-47a8-9014-f67ce6ebbd9b]: 2016-07-28 12:49:59 139690207103744 [Note] ReplSemiSyncMaster::readSlaveReply: Got reply (mariadb-bin.000005, 105654222)
2016-07-28T12:49:59.401857Z app[mariadb.host2-34df8696-457d-47a8-9014-f67ce6ebbd9b]: 2016-07-28 12:49:59 139690207103744 [Note] ActiveTranx::::clear_active_tranx_nodes: cleared all nodes
2016-07-28T12:49:59.401667Z app[mariadb.host0-42aa03f8-a07d-497d-9534-074b8af0bf46]: 2016-07-28 12:49:59 140201364466432 [Note] ReplSemiSyncSlave::slaveReadSyncHeader: reply - 1
2016-07-28T12:49:59.401777Z app[mariadb.host0-42aa03f8-a07d-497d-9534-074b8af0bf46]: 2016-07-28 12:49:59 140201364466432 [Note] ReplSemiSyncSlave::slaveReply: reply (mariadb-bin.000005, 105654222)
2016-07-28T12:49:59.402029Z app[mariadb.host2-34df8696-457d-47a8-9014-f67ce6ebbd9b]: 2016-07-28 12:49:59 139690207103744 [Note] ReplSemiSyncMaster::reportReplyBinlog: Got reply at (mariadb-bin.000005, 105654222)
2016-07-28T12:49:59.402085Z app[mariadb.host2-34df8696-457d-47a8-9014-f67ce6ebbd9b]: 2016-07-28 12:49:59 139690207103744 [Note] ActiveTranx::is_tranx_end_pos: probe (mariadb-bin.000005, 105654267) in entry(174)
2016-07-28T12:49:59.402256Z app[mariadb.host2-34df8696-457d-47a8-9014-f67ce6ebbd9b]: 2016-07-28 12:49:59 139690207103744 [Note] ReplSemiSyncMaster::updateSyncHeader: server(1684293900), (mariadb-bin.000005, 105654267) sync(0), repl(1)
2016-07-28T12:49:59.502920Z app[mariadb.host2-34df8696-457d-47a8-9014-f67ce6ebbd9b]: 2016-07-28 12:49:59 139690206497536 [Note] ReplSemiSyncMaster::commitTrx: wait pos (mariadb-bin.000006, 105654222), repl(1)
2016-07-28T12:49:59.503140Z app[mariadb.host0-42aa03f8-a07d-497d-9534-074b8af0bf46]: 2016-07-28 12:49:59 140201364466432 [Note] ReplSemiSyncSlave::slaveReadSyncHeader: reply - 0
2016-07-28T12:49:59.502979Z app[mariadb.host2-34df8696-457d-47a8-9014-f67ce6ebbd9b]:
2016-07-28T12:49:59.503066Z app[mariadb.host2-34df8696-457d-47a8-9014-f67ce6ebbd9b]: 2016-07-28 12:49:59 139690206497536 [Note] ReplSemiSyncMaster::commitTrx: init wait position (mariadb-bin.000006, 105654222),
2016-07-28T12:49:59.503104Z app[mariadb.host2-34df8696-457d-47a8-9014-f67ce6ebbd9b]: 2016-07-28 12:49:59 139690206497536 [Note] ReplSemiSyncMaster::commitTrx: wait 18446744073709551615 ms for binlog sent (mariadb-bin.000006, 105654222)
2016-07-28T12:49:59.503115Z app[mariadb.host2-34df8696-457d-47a8-9014-f67ce6ebbd9b]: 2016-07-28 12:49:59 139690207103744 [Note] ReplSemiSyncMaster::updateSyncHeader: server(1684293900), (mariadb-bin.000006, 288) sync(0), repl(1)
2016-07-28T12:49:59.503219Z app[mariadb.host2-34df8696-457d-47a8-9014-f67ce6ebbd9b]: 2016-07-28 12:49:59 139690207103744 [Note] ReplSemiSyncMaster::updateSyncHeader: server(1684293900), (mariadb-bin.000006, 329) sync(0), repl(1)
2016-07-28T12:49:59.926225Z app[mariadb.host0-42aa03f8-a07d-497d-9534-074b8af0bf46]: 2016-07-28 12:49:59 140201364466432 [Note] ReplSemiSyncSlave::slaveReadSyncHeader: reply - 0
2016-07-28T12:50:00.191146Z app[mariadb.host0-42aa03f8-a07d-497d-9534-074b8af0bf46]: 2016-07-28 12:50:00 140201364466432 [Note] ReplSemiSyncSlave::slaveReadSyncHeader: reply - 0
2016-07-28T12:50:00.191243Z app[mariadb.host0-42aa03f8-a07d-497d-9534-074b8af0bf46]: 2016-07-28 12:50:00 140201364466432 [Note] ReplSemiSyncSlave::slaveReadSyncHeader: reply - 0
2016-07-28T12:50:00.191418Z app[mariadb.host0-42aa03f8-a07d-497d-9534-074b8af0bf46]: 2016-07-28 12:50:00 140201364466432 [Note] ReplSemiSyncSlave::slaveReadSyncHeader: reply - 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment