2023-10-27 6:19:41 1 [ERROR] Slave SQL: Could not execute Write_rows_v1 event on table table1; Duplicate entry 'name1-field1-data1' for key 'unq_d', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log FIRST, end_log_pos 480, Internal MariaDB error code: 1062 2023-10-27 6:19:42 1 [Warning] WSREP: Event 3 Write_rows_v1 apply failed: 121, seqno 36005 2023-10-27 6:19:43 0 [Note] WSREP: declaring eed947b5-8acf at ssl://[::ffff:192.168.56.120]:4567 stable 2023-10-27 6:19:43 0 [Note] WSREP: Deferred close timer started for socket with remote endpoint: ssl://[::ffff:192.168.56.113]:56816 2023-10-27 6:19:43 0 [Note] WSREP: forgetting 9f1f4f98-b182 (ssl://[::ffff:192.168.56.113]:4567) 2023-10-27 6:19:43 0 [Note] WSREP: Deferred close timer handle_wait Operation aborted. for 0x7fa0b40488b0 2023-10-27 6:19:43 0 [Note] WSREP: Deferred close timer destruct 2023-10-27 6:19:43 0 [Note] WSREP: Node 3d314b90-af92 state prim 2023-10-27 6:19:43 0 [Warning] WSREP: 3d314b90-af92 sending install message failed: Resource temporarily unavailable 2023-10-27 6:19:43 0 [Note] WSREP: view(view_id(NON_PRIM,3d314b90-af92,8) memb { 3d314b90-af92,0 } joined { } left { } partitioned { 9f1f4f98-b182,0 eed947b5-8acf,0 }) 2023-10-27 6:19:43 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2023-10-27 6:19:43 0 [Note] WSREP: Deferred close timer started for socket with remote endpoint: ssl://[::ffff:192.168.56.120]:57680 2023-10-27 6:19:43 0 [Note] WSREP: forgetting eed947b5-8acf (ssl://[::ffff:192.168.56.120]:4567) 2023-10-27 6:19:43 0 [Note] WSREP: view(view_id(NON_PRIM,3d314b90-af92,9) memb { 3d314b90-af92,0 } joined { } left { } partitioned { 9f1f4f98-b182,0 eed947b5-8acf,0 }) 2023-10-27 6:19:43 0 [Note] WSREP: Deferred close timer handle_wait Operation aborted. for 0x564eaf93b2a0 2023-10-27 6:19:43 0 [Note] WSREP: Deferred close timer destruct 2023-10-27 6:19:44 0 [Note] WSREP: Flow-control interval: [16, 16] 2023-10-27 6:19:44 0 [Note] WSREP: Received NON-PRIMARY. 2023-10-27 6:19:44 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 36012) 2023-10-27 6:19:44 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2023-10-27 6:19:44 0 [Note] WSREP: Flow-control interval: [16, 16] 2023-10-27 6:19:44 0 [Note] WSREP: Received NON-PRIMARY. 2023-10-27 6:19:44 74 [Warning] WSREP: Send action {(nil), 1096, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 55 [Warning] WSREP: Send action {(nil), 912, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 59 [Warning] WSREP: Send action {(nil), 1096, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 67 [Warning] WSREP: Send action {(nil), 1096, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 38 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 58 [Warning] WSREP: Send action {(nil), 1096, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 80 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 49 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 81 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 52 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 64 [Warning] WSREP: Send action {(nil), 912, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 61 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 72 [Warning] WSREP: Send action {(nil), 1096, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 57 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 46 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 77 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 69 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 39 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 66 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 47 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 62 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 37 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 73 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 56 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 60 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 65 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 54 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 53 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 79 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 63 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 36 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 78 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 50 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 76 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 48 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 68 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 71 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 51 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 75 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 0 [Warning] WSREP: last inactive check more than PT1.5S ago (PT2.33907S), skipping check 2023-10-27 6:19:44 37 [Warning] WSREP: Send action {(nil), 912, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:44 58 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 54 [Warning] WSREP: Send action {(nil), 1096, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 79 [Warning] WSREP: Send action {(nil), 1096, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 46 [Warning] WSREP: Send action {(nil), 912, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 39 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 66 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 47 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 61 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 56 [Warning] WSREP: Send action {(nil), 912, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 50 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 76 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 57 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 48 [Warning] WSREP: Send action {(nil), 1096, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 65 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 62 [Warning] WSREP: Send action {(nil), 1096, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 69 [Warning] WSREP: Send action {(nil), 1096, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 60 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 78 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 71 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 68 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 51 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 81 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 75 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 77 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 53 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 36 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 73 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 63 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:45 72 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:46 37 [Warning] WSREP: Send action {(nil), 912, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:46 1 [ERROR] WSREP: Failed to apply write set: gtid: 30e77cb7-7472-11ee-bf12-3a00c5beca29:36005 server_id: 9f1f4f98-739e-11ee-b182-8f6dc21e74b0 client_id: 54 trx_id: 674276 flags: 3 (start_transaction | commit) 2023-10-27 6:19:46 58 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:46 79 [Warning] WSREP: Send action {(nil), 912, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:46 54 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:46 39 [Warning] WSREP: Send action {(nil), 912, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:46 66 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:46 47 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:46 50 [Warning] WSREP: Send action {(nil), 1048, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:46 76 [Warning] WSREP: Send action {(nil), 928, WRITESET} returned -107 (Transport endpoint is not connected) 2023-10-27 6:19:47 1 [Note] WSREP: Closing send monitor... 2023-10-27 6:19:47 1 [Note] WSREP: Closed send monitor. 2023-10-27 6:19:47 1 [Note] WSREP: gcomm: terminating thread 2023-10-27 6:19:47 1 [Note] WSREP: gcomm: joining thread 2023-10-27 6:19:47 1 [Note] WSREP: gcomm: closing backend 2023-10-27 6:19:47 1 [Note] WSREP: PC protocol downgrade 1 -> 0 2023-10-27 6:19:47 1 [Note] WSREP: view((empty)) 2023-10-27 6:19:47 1 [Note] WSREP: gcomm: closed 2023-10-27 6:19:47 0 [Note] WSREP: New SELF-LEAVE. 2023-10-27 6:19:47 0 [Note] WSREP: Flow-control interval: [0, 0] 2023-10-27 6:19:47 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2023-10-27 6:19:47 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 36012) 2023-10-27 6:19:47 0 [Note] WSREP: RECV thread exiting 0: Success 2023-10-27 6:19:47 1 [Note] WSREP: recv_thread() joined. 2023-10-27 6:19:47 1 [Note] WSREP: Closing replication queue. 2023-10-27 6:19:47 1 [Note] WSREP: Closing slave action queue. 2023-10-27 6:19:47 1 [Note] WSREP: ================================================ View: id: 30e77cb7-7472-11ee-bf12-3a00c5beca29:36012 status: non-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: 3d314b90-7476-11ee-af92-63205e8792ff, node_192.168.56.119 ================================================= 2023-10-27 6:19:47 1 [Note] WSREP: Non-primary view 2023-10-27 6:19:47 1 [Note] WSREP: Server status change synced -> connected