2021-02-27 10:59:51 540352 [Note] WSREP: MDL conflict schema: cinder request: (540352 seqno 5462710 wsrep (toi, exec, aborted) cmd 3 9 DROP TABLE IF EXISTS `workers`) granted: (537212 seqno 5462711 wsrep (local, exec, committing) cmd 3 54 COMMIT) 2021-02-27 10:59:51 540352 [Note] WSREP: MDL ticket: type: MDL_SHARED_READ space: TABLE db: cinder name: workers (Waiting for table metadata lock) 2021-02-27 10:59:51 540352 [Note] WSREP: DROP caused BF abort, conf committing 2021-02-27 10:59:51 540352 [Note] WSREP: MDL ticket: type: MDL_SHARED_READ space: TABLE db: cinder name: workers (Waiting for table metadata lock) 2021-02-27 10:59:51 540352 [Note] WSREP: wsrep_abort_thd, by: 139741928355584, victim: 139755027998464 2021-02-27 10:59:51 540352 [Note] WSREP: abort transaction: BF: DROP TABLE IF EXISTS `workers` victim: COMMIT victim conf: committing 2021-02-27 10:59:51 540352 [Note] WSREP: wsrep_thd_set_wsrep_aborter called 2021-02-27 10:59:51 540352 [Note] WSREP: wsrep_bf_abort BF aborter before thd: 540352 thd_ptr: 0x7f19480b7e18 client_mode: toi client_state: exec trx_state: aborted next_trx_id: 44600026 trx_id: -1 seqno: 5462710 is_streaming: 0 fragments: 0 sql_errno: 0 message: command: 9 query: DROP TABLE IF EXISTS `workers` 2021-02-27 10:59:51 540352 [Note] WSREP: wsrep_bf_abort victim before thd: 537212 thd_ptr: 0x7f19a8000c08 client_mode: local client_state: exec trx_state: committing next_trx_id: 44600027 trx_id: 44599986 seqno: 5462711 is_streaming: 0 fragments: 0 sql_errno: 0 message: command: 54 query: COMMIT 2021-02-27 10:59:51 537212 [Note] WSREP: COMMIT failed, MDL released: 537212 2021-02-27 10:59:51 537212 [Note] WSREP: overriding error: 0 with DEADLOCK 2021-02-27 10:59:51 1 [Note] WSREP: wsrep_commit_empty(1) 2021-02-27 10:59:51 1 [Note] WSREP: assigned new next trx id: 44600028 2021-02-27 10:59:51 1 [Note] WSREP: MDL conflict schema: cinder request: (1 seqno 5462711 wsrep (high priority, exec, replaying) cmd 0 161 UPDATE services SET updated_at='2021-02-27 02:59:51.238384', report_count=645795 WHERE services.deleted = false AND services.id = 7ยงยต9`^S^A) granted: (540352 seqno 5462710 wsrep (toi, exec, aborted) cmd 3 9 DROP TABLE IF EXISTS `workers`) 2021-02-27 10:59:51 1 [Note] WSREP: MDL ticket: type: MDL_EXCLUSIVE space: TABLE db: cinder name: workers (Waiting for table metadata lock) 2021-02-27 10:59:51 1 [Note] WSREP: BF thread waiting for SR in aborting state 2021-02-27 10:59:51 1 [Note] WSREP: MDL ticket: type: MDL_EXCLUSIVE space: TABLE db: cinder name: workers (Waiting for table metadata lock) 2021-02-27 10:59:51 86 [Note] WSREP: assigned new next trx id: 44600029 2021-02-27 10:59:51 86 [Note] WSREP: assigned new next trx id: 44600030 2021-02-27 10:59:51 86 [Note] WSREP: wsrep_commit_empty(86) 2021-02-27 10:59:51 540352 [Note] WSREP: avoiding binlog rotate due to TO isolation: 1 2021-02-27 10:59:51 540352 [Note] WSREP: TO END: 5462710: DROP TABLE IF EXISTS `workers` 2021-02-27 10:59:51 540352 [Note] WSREP: Set WSREPXid for InnoDB: 4dc279af-5d29-11ea-a98a-daac555b18ae:5462710 2021-02-27 10:59:51 1 [Note] WSREP: wsrep_before_prepare: 1 2021-02-27 10:59:51 1 [Note] WSREP: wsrep_after_prepare: 1 2021-02-27 10:59:51 1 [Note] WSREP: wsrep_before_commit: 1, 5462711 2021-02-27 10:59:51 1 [Note] WSREP: wsrep_ordered_commit: 1 2021-02-27 10:59:51 1 [Note] WSREP: wsrep_after_commit: 1, 1, 5462711, 0 2021-02-27 10:59:51 1 [Note] WSREP: wsrep_after_apply 1 2021-02-27 10:59:51 537212 [Note] WSREP: assigned new next trx id: 44600031 2021-02-27 10:59:51 540352 [Note] WSREP: TO END: -1 2021-02-27 10:59:51 540352 [Note] WSREP: assigned new next trx id: 44600032 2021-02-27 10:59:51 540352 [Note] WSREP: assigned new next trx id: 44600033 2021-02-27 10:59:51 540352 [Note] WSREP: assigned new next trx id: 44600034 2021-02-27 10:59:51 540352 [Note] WSREP: TOI Begin 2021-02-27 10:59:51 102 [Note] WSREP: assigned new next trx id: 44600035 2021-02-27 10:59:51 102 [Note] WSREP: assigned new next trx id: 44600036 2021-02-27 10:59:51 102 [Note] WSREP: wsrep_commit_empty(102) 2021-02-27 10:59:51 82 [Note] WSREP: assigned new next trx id: 44600037 2021-02-27 10:59:51 82 [Note] WSREP: assigned new next trx id: 44600038 2021-02-27 10:59:51 82 [Note] WSREP: wsrep_commit_empty(82) 2021-02-27 10:59:51 119 [Note] WSREP: assigned new next trx id: 44600039 2021-02-27 10:59:51 119 [Note] WSREP: assigned new next trx id: 44600040 2021-02-27 10:59:51 119 [Note] WSREP: wsrep_commit_empty(119) 2021-02-27 10:59:51 85 [Note] WSREP: assigned new next trx id: 44600041 2021-02-27 10:59:51 85 [Note] WSREP: assigned new next trx id: 44600042 2021-02-27 10:59:51 85 [Note] WSREP: wsrep_commit_empty(85) 2021-02-27 10:59:51 145 [Note] WSREP: assigned new next trx id: 44600043 2021-02-27 10:59:51 147 [Note] WSREP: assigned new next trx id: 44600044 2021-02-27 10:59:51 145 [Note] WSREP: assigned new next trx id: 44600045 2021-02-27 10:59:51 147 [Note] WSREP: assigned new next trx id: 44600046 2021-02-27 10:59:51 145 [Note] WSREP: assigned new next trx id: 44600047 2021-02-27 10:59:51 147 [Note] WSREP: assigned new next trx id: 44600048 2021-02-27 10:59:51 133 [Note] WSREP: assigned new next trx id: 44600049 2021-02-27 10:59:51 127 [Note] WSREP: assigned new next trx id: 44600050 2021-02-27 10:59:51 137 [Note] WSREP: assigned new next trx id: 44600051 2021-02-27 10:59:51 133 [Note] WSREP: assigned new next trx id: 44600052 2021-02-27 10:59:51 127 [Note] WSREP: assigned new next trx id: 44600053 2021-02-27 10:59:51 137 [Note] WSREP: assigned new next trx id: 44600054 2021-02-27 10:59:51 127 [Note] WSREP: assigned new next trx id: 44600055 2021-02-27 10:59:51 133 [Note] WSREP: assigned new next trx id: 44600056 2021-02-27 10:59:51 137 [Note] WSREP: assigned new next trx id: 44600057 2021-02-27 10:59:51 131 [Note] WSREP: assigned new next trx id: 44600058 2021-02-27 10:59:51 131 [Note] WSREP: assigned new next trx id: 44600059 2021-02-27 10:59:51 131 [Note] WSREP: assigned new next trx id: 44600060 2021-02-27 10:59:51 120 [Note] WSREP: assigned new next trx id: 44600061 2021-02-27 10:59:51 120 [Note] WSREP: assigned new next trx id: 44600062 2021-02-27 10:59:51 143 [Note] WSREP: assigned new next trx id: 44600063 2021-02-27 10:59:51 120 [Note] WSREP: assigned new next trx id: 44600064 2021-02-27 10:59:51 143 [Note] WSREP: assigned new next trx id: 44600065 2021-02-27 10:59:51 143 [Note] WSREP: assigned new next trx id: 44600066 2021-02-27 10:59:51 148 [Note] WSREP: assigned new next trx id: 44600067 2021-02-27 10:59:51 148 [Note] WSREP: assigned new next trx id: 44600068 2021-02-27 10:59:51 139 [Note] WSREP: assigned new next trx id: 44600069 2021-02-27 10:59:51 148 [Note] WSREP: assigned new next trx id: 44600070 2021-02-27 10:59:51 141 [Note] WSREP: assigned new next trx id: 44600071 2021-02-27 10:59:51 135 [Note] WSREP: assigned new next trx id: 44600072 2021-02-27 10:59:51 139 [Note] WSREP: assigned new next trx id: 44600073 2021-02-27 10:59:51 144 [Note] WSREP: assigned new next trx id: 44600074 2021-02-27 10:59:51 141 [Note] WSREP: assigned new next trx id: 44600075 2021-02-27 10:59:51 105 [Note] WSREP: assigned new next trx id: 44600076 2021-02-27 10:59:51 139 [Note] WSREP: assigned new next trx id: 44600077 2021-02-27 10:59:51 110 [Note] WSREP: assigned new next trx id: 44600078 2021-02-27 10:59:51 141 [Note] WSREP: assigned new next trx id: 44600079 2021-02-27 10:59:51 105 [Note] WSREP: assigned new next trx id: 44600080 2021-02-27 10:59:51 135 [Note] WSREP: assigned new next trx id: 44600081 2021-02-27 10:59:51 132 [Note] WSREP: assigned new next trx id: 44600082 2021-02-27 10:59:51 105 [Note] WSREP: assigned new next trx id: 44600083 2021-02-27 10:59:51 110 [Note] WSREP: assigned new next trx id: 44600084 2021-02-27 10:59:51 135 [Note] WSREP: assigned new next trx id: 44600086 2021-02-27 10:59:51 132 [Note] WSREP: assigned new next trx id: 44600087 2021-02-27 10:59:51 144 [Note] WSREP: assigned new next trx id: 44600085 2021-02-27 10:59:51 110 [Note] WSREP: assigned new next trx id: 44600088 2021-02-27 10:59:51 132 [Note] WSREP: assigned new next trx id: 44600089 2021-02-27 10:59:51 144 [Note] WSREP: assigned new next trx id: 44600090 2021-02-27 10:59:51 134 [Note] WSREP: assigned new next trx id: 44600091 2021-02-27 10:59:51 134 [Note] WSREP: assigned new next trx id: 44600092 2021-02-27 10:59:51 134 [Note] WSREP: assigned new next trx id: 44600093 2021-02-27 10:59:51 108 [Note] WSREP: assigned new next trx id: 44600094 2021-02-27 10:59:51 108 [Note] WSREP: assigned new next trx id: 44600095 2021-02-27 10:59:51 108 [Note] WSREP: assigned new next trx id: 44600096 2021-02-27 10:59:51 140 [Note] WSREP: assigned new next trx id: 44600098 2021-02-27 10:59:51 129 [Note] WSREP: assigned new next trx id: 44600097 2021-02-27 10:59:51 140 [Note] WSREP: assigned new next trx id: 44600099 2021-02-27 10:59:51 129 [Note] WSREP: assigned new next trx id: 44600100 2021-02-27 10:59:51 140 [Note] WSREP: assigned new next trx id: 44600101 2021-02-27 10:59:51 129 [Note] WSREP: assigned new next trx id: 44600102 2021-02-27 10:59:51 541426 [Note] WSREP: assigned new next trx id: 44600103 2021-02-27 10:59:51 541426 [Note] WSREP: wsrep_commit_empty(541426) 2021-02-27 10:59:51 541426 [Note] WSREP: assigned new next trx id: 44600104 2021-02-27 10:59:51 541426 [Note] WSREP: assigned new next trx id: 44600105 2021-02-27 10:59:51 109 [Note] WSREP: assigned new next trx id: 44600106 2021-02-27 10:59:51 109 [Note] WSREP: assigned new next trx id: 44600107 2021-02-27 10:59:51 113 [Note] WSREP: assigned new next trx id: 44600108 2021-02-27 10:59:51 109 [Note] WSREP: wsrep_commit_empty(109) 2021-02-27 10:59:52 113 [Note] WSREP: assigned new next trx id: 44600109 2021-02-27 10:59:52 113 [Note] WSREP: wsrep_commit_empty(113) 2021-02-27 10:59:52 104 [Note] WSREP: assigned new next trx id: 44600110 2021-02-27 10:59:52 104 [Note] WSREP: assigned new next trx id: 44600111 2021-02-27 10:59:52 104 [Note] WSREP: wsrep_commit_empty(104) 2021-02-27 10:59:52 536943 [Note] WSREP: assigned new next trx id: 44600112 2021-02-27 10:59:52 536943 [Note] WSREP: wsrep_commit_empty(536943) 2021-02-27 10:59:52 536943 [Note] WSREP: assigned new next trx id: 44600113 2021-02-27 10:59:52 536943 [Note] WSREP: assigned new next trx id: 44600114 2021-02-27 10:59:52 536943 [Note] WSREP: wsrep_commit_empty(536943) 2021-02-27 10:59:52 536943 [Note] WSREP: assigned new next trx id: 44600115 2021-02-27 10:59:52 83 [Note] WSREP: assigned new next trx id: 44600116 2021-02-27 10:59:52 83 [Note] WSREP: assigned new next trx id: 44600117 2021-02-27 10:59:52 83 [Note] WSREP: wsrep_commit_empty(83) 2021-02-27 10:59:52 74 [Note] WSREP: assigned new next trx id: 44600118 2021-02-27 10:59:52 74 [Note] WSREP: assigned new next trx id: 44600119 2021-02-27 10:59:52 74 [Note] WSREP: wsrep_commit_empty(74) 2021-02-27 10:59:52 126 [Note] WSREP: assigned new next trx id: 44600120 2021-02-27 10:59:52 126 [Note] WSREP: assigned new next trx id: 44600121 2021-02-27 10:59:52 126 [Note] WSREP: wsrep_commit_empty(126) 2021-02-27 10:59:52 542487 [Note] WSREP: assigned new next trx id: 44600122 2021-02-27 10:59:52 542487 [Note] WSREP: assigned new next trx id: 44600123 2021-02-27 10:59:52 542487 [Note] WSREP: assigned new next trx id: 44600124 2021-02-27 10:59:52 542487 [Note] WSREP: wsrep_commit_empty(542487) 2021-02-27 10:59:52 542487 [Note] WSREP: assigned new next trx id: 44600125 2021-02-27 10:59:52 541078 [Note] WSREP: assigned new next trx id: 44600126 2021-02-27 10:59:52 0 [Note] WSREP: Deferred close timer started for socket with remote endpoint: tcp://192.168.0.219:55485 2021-02-27 10:59:52 0 [Note] WSREP: forgetting 4de4e72d-8337 (tcp://192.168.0.219:4567) 2021-02-27 10:59:52 0 [Note] WSREP: Node d543627f-b7eb state prim 2021-02-27 10:59:52 0 [Note] WSREP: view(view_id(PRIM,d543627f-b7eb,9) memb { d543627f-b7eb,0 } joined { } left { } partitioned { 4de4e72d-8337,0 }) 2021-02-27 10:59:52 0 [Note] WSREP: save pc into disk 2021-02-27 10:59:52 86 [Note] WSREP: assigned new next trx id: 44600127 2021-02-27 10:59:52 86 [Note] WSREP: assigned new next trx id: 44600128 2021-02-27 10:59:52 86 [Note] WSREP: wsrep_commit_empty(86) 2021-02-27 10:59:52 0 [Note] WSREP: forgetting 4de4e72d-8337 (tcp://192.168.0.219:4567) 2021-02-27 10:59:52 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 2021-02-27 10:59:52 0 [Note] WSREP: Deferred close timer handle_wait asio.system:125 for 0x5639291ff910 2021-02-27 10:59:52 0 [Note] WSREP: Deferred close timer destruct 2021-02-27 10:59:52 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: dd0910a0-78a7-11eb-932b-2a54a99e6270 2021-02-27 10:59:52 0 [Note] WSREP: STATE EXCHANGE: sent state msg: dd0910a0-78a7-11eb-932b-2a54a99e6270 2021-02-27 10:59:52 0 [Note] WSREP: STATE EXCHANGE: got state msg: dd0910a0-78a7-11eb-932b-2a54a99e6270 from 0 (host-192-168-0-220) 2021-02-27 10:59:52 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 8, members = 1/1 (joined/total), act_id = 5462711, last_appl. = 5462692, protocols = 2/10/4 (gcs/repl/appl), vote policy= 0, group UUID = 4dc279af-5d29-11ea-a98a-daac555b18ae 2021-02-27 10:59:52 0 [Note] WSREP: Flow-control interval: [16, 16] 2021-02-27 10:59:52 13 [Note] WSREP: ####### processing CC 5462712, local, ordered 2021-02-27 10:59:52 13 [Note] WSREP: ####### My UUID: d543627f-759b-11eb-b7eb-7fc842ce415c 2021-02-27 10:59:52 13 [Note] WSREP: Skipping cert index reset 2021-02-27 10:59:52 13 [Note] WSREP: REPL Protocols: 10 (5) 2021-02-27 10:59:52 13 [Note] WSREP: ####### Adjusting cert position: 5462711 -> 5462712 2021-02-27 10:59:52 0 [Note] WSREP: Service thread queue flushed. 2021-02-27 10:59:52 536952 [Note] WSREP: assigned new next trx id: 44600129 2021-02-27 10:59:52 536952 [Note] WSREP: wsrep_commit_empty(536952) 2021-02-27 10:59:52 536952 [Note] WSREP: assigned new next trx id: 44600130 2021-02-27 10:59:52 536952 [Note] WSREP: assigned new next trx id: 44600131 2021-02-27 10:59:52 536952 [Note] WSREP: wsrep_commit_empty(536952) 2021-02-27 10:59:52 536952 [Note] WSREP: assigned new next trx id: 44600132 2021-02-27 10:59:52 542275 [Note] WSREP: assigned new next trx id: 44600133 2021-02-27 10:59:52 542275 [Note] WSREP: wsrep_commit_empty(542275) 2021-02-27 10:59:52 542275 [Note] WSREP: assigned new next trx id: 44600134 2021-02-27 10:59:52 542275 [Note] WSREP: assigned new next trx id: 44600135 2021-02-27 10:59:52 102 [Note] WSREP: assigned new next trx id: 44600136 2021-02-27 10:59:52 102 [Note] WSREP: assigned new next trx id: 44600137 2021-02-27 10:59:52 102 [Note] WSREP: wsrep_commit_empty(102) 2021-02-27 10:59:52 13 [Note] WSREP: ================================================ View: id: 4dc279af-5d29-11ea-a98a-daac555b18ae:5462712 status: primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: no own_index: 0 members(1): 0: d543627f-759b-11eb-b7eb-7fc842ce415c, host-192-168-0-220 ================================================= 2021-02-27 10:59:52 13 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2021-02-27 10:59:52 13 [Note] WSREP: Restored cluster view: id: 4dc279af-5d29-11ea-a98a-daac555b18ae:5321401 status: primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: no own_index: -1 members(2): 0: 4de4e72d-7811-11eb-8337-dea31e70a73a, host-192-168-0-219 1: d543627f-759b-11eb-b7eb-7fc842ce415c, host-192-168-0-220 2021-02-27 10:59:52 13 [Note] WSREP: Storing cluster view: id: 4dc279af-5d29-11ea-a98a-daac555b18ae:5462712 status: primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: no own_index: 0 members(1): 0: d543627f-759b-11eb-b7eb-7fc842ce415c, host-192-168-0-220 2021-02-27 10:59:52 13 [Note] WSREP: SQL: 31 DELETE FROM mysql.wsrep_cluster thd: 13 2021-02-27 10:59:52 13 [Note] WSREP: SQL: 39 DELETE FROM mysql.wsrep_cluster_members thd: 13 2021-02-27 10:59:52 82 [Note] WSREP: assigned new next trx id: 44600140 2021-02-27 10:59:52 13 [Note] WSREP: Set WSREPXid for InnoDB: 4dc279af-5d29-11ea-a98a-daac555b18ae:5462712 2021-02-27 10:59:52 82 [Note] WSREP: assigned new next trx id: 44600141 2021-02-27 10:59:52 82 [Note] WSREP: wsrep_commit_empty(82) 2021-02-27 10:59:52 119 [Note] WSREP: assigned new next trx id: 44600142 2021-02-27 10:59:52 119 [Note] WSREP: assigned new next trx id: 44600143 2021-02-27 10:59:52 119 [Note] WSREP: wsrep_commit_empty(119) 2021-02-27 10:59:52 85 [Note] WSREP: assigned new next trx id: 44600144 2021-02-27 10:59:52 85 [Note] WSREP: assigned new next trx id: 44600145 2021-02-27 10:59:52 85 [Note] WSREP: wsrep_commit_empty(85) 2021-02-27 10:59:52 13 [Note] WSREP: Lowest cert index boundary for CC from group: 5462693 2021-02-27 10:59:52 13 [Note] WSREP: Min available from gcache for CC from group: 5446202