[root@EMADRDB01 EM_ImmigrationDb]# tail -n 750 /var/log/mysqld.log 2024-05-09 15:11:23 2 [Note] WSREP: You have configured 'rsync' state snapshot transfer method which cannot be performed on a running server. Wsrep provider won't be able to fall back to it if other means of state transfer are unavailable. In that case you will need to restart the server. 2024-05-09 15:11:23 2 [Note] WSREP: ####### IST uuid:90650610-a141-11ee-8145-07b32e6dc917 f: 14415070, l: 14417061, STRv: 3 2024-05-09 15:11:23 2 [Note] WSREP: IST receiver addr using tcp://10.100.20.3:4568 2024-05-09 15:11:23 2 [Note] WSREP: Prepared IST receiver for 14415070-14417061, listening at: tcp://10.100.20.3:4568 2024-05-09 15:11:23 0 [Note] WSREP: Member 2.0 (EMADRDB01) requested state transfer from '*any*'. Selected 1.0 (EMDB01)(SYNCED) as donor. 2024-05-09 15:11:23 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 14417062) 2024-05-09 15:11:23 2 [Note] WSREP: Requesting state transfer: success, donor: 1 2024-05-09 15:11:23 2 [Note] WSREP: Receiving IST: 1992 writesets, seqnos 14415070-14417061 2024-05-09 15:11:23 0 [Note] WSREP: 1.0 (EMDB01): State transfer to 2.0 (EMADRDB01) complete. 2024-05-09 15:11:23 0 [Note] WSREP: ####### IST applying starts with 14415070 2024-05-09 15:11:23 0 [Note] WSREP: Member 1.0 (EMDB01) synced with group. 2024-05-09 15:11:23 0 [Note] WSREP: ####### IST current seqno initialized to 14415070 2024-05-09 15:11:23 0 [Note] WSREP: Receiving IST... 0.0% ( 0/1992 events) complete. 2024-05-09 15:11:23 0 [Note] WSREP: Service thread queue flushed. 2024-05-09 15:11:23 0 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:14415069, protocol version: 5 2024-05-09 15:11:23 0 [Note] WSREP: REPL Protocols: 10 (5) 2024-05-09 15:11:23 0 [Note] WSREP: ####### Adjusting cert position: 14415069 -> 14415075 2024-05-09 15:11:23 0 [Note] WSREP: Service thread queue flushed. 2024-05-09 15:11:23 0 [Note] WSREP: Lowest cert index boundary for CC from ist: 14415075 2024-05-09 15:11:23 0 [Note] WSREP: Min available from gcache for CC from ist: 14260997 2024-05-09 15:11:23 6 [Note] WSREP: ================================================ View: id: 90650610-a141-11ee-8145-07b32e6dc917:14415075 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: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad, EMDB02 1: bd13c561-07e3-11ef-9589-83a4a27b0ba1, EMDB01 ================================================= 2024-05-09 15:11:23 6 [Note] WSREP: Server status change joiner -> joined 2024-05-09 15:11:23 6 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-05-09 15:11:23 0 [Note] WSREP: IST preload starting at 14416943 2024-05-09 15:11:23 0 [Note] WSREP: REPL Protocols: 10 (5) 2024-05-09 15:11:23 0 [Note] WSREP: ####### Adjusting cert position: 14417060 -> 14417061 2024-05-09 15:11:23 0 [Note] WSREP: Service thread queue flushed. 2024-05-09 15:11:23 0 [Note] WSREP: Lowest cert index boundary for CC from ist: 14416943 2024-05-09 15:11:23 0 [Note] WSREP: Min available from gcache for CC from ist: 14261135 2024-05-09 15:11:23 0 [Note] WSREP: Receiving IST...100.0% (1992/1992 events) complete. 2024-05-09 15:11:23 8 [Note] WSREP: ================================================ View: id: 90650610-a141-11ee-8145-07b32e6dc917:14417061 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: 2 members(3): 0: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad, EMDB02 1: bd13c561-07e3-11ef-9589-83a4a27b0ba1, EMDB01 2: fdc0d84b-019b-11ef-8bdf-863fa6afdfb6, EMADRDB01 ================================================= 2024-05-09 15:11:23 8 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-05-09 15:11:23 2 [Note] WSREP: Draining apply monitors after IST up to 14417061 2024-05-09 15:11:23 2 [Note] WSREP: IST received: 90650610-a141-11ee-8145-07b32e6dc917:14417061 2024-05-09 15:11:23 2 [Note] WSREP: Lowest cert index boundary for CC from sst: 14416943 2024-05-09 15:11:23 2 [Note] WSREP: Min available from gcache for CC from sst: 14261135 2024-05-09 15:11:23 0 [Note] WSREP: 2.0 (EMADRDB01): State transfer from 1.0 (EMDB01) complete. 2024-05-09 15:11:23 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 14417071) 2024-05-09 15:11:23 0 [Note] WSREP: Processing event queue:... -nan% (0/0 events) complete. 2024-05-09 15:11:23 0 [Note] WSREP: Member 2.0 (EMADRDB01) synced with group. 2024-05-09 15:11:23 0 [Note] WSREP: Processing event queue:...100.0% (2/2 events) complete. 2024-05-09 15:11:23 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 14417072) 2024-05-09 15:11:23 8 [Note] WSREP: Server EMADRDB01 synced with group 2024-05-09 15:11:23 8 [Note] WSREP: Server status change joined -> synced 2024-05-09 15:11:23 8 [Note] WSREP: Synchronized with group, ready for connections 2024-05-09 15:11:23 8 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-05-09 15:11:24 0 [Note] WSREP: (fdc0d84b-8bdf, 'tcp://0.0.0.0:4567') turning message relay requesting off 2024-05-09 15:16:52 1225 [Warning] Aborted connection 1225 to db: 'EM_ImmigrationDb' user: 'root' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-09 15:32:45 1231 [Warning] Aborted connection 1231 to db: 'EM_ImmigrationDb' user: 'root' host: '192.168.251.2' (Got an error reading communication packets) 2024-05-09 15:50:44 1232 [Warning] Aborted connection 1232 to db: 'EM_SecurityDb' user: 'root' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-09 15:55:12 1236 [Warning] Aborted connection 1236 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-09 15:57:03 1235 [Warning] Aborted connection 1235 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-09 16:00:00 1227 [Warning] Aborted connection 1227 to db: 'EM_ImmigrationDb' user: 'root' host: '192.168.251.2' (Got an error reading communication packets) 2024-05-09 16:16:18 1241 [Warning] Aborted connection 1241 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-09 16:16:41 1243 [Warning] Aborted connection 1243 to db: 'EM_ImmigrationDb' user: 'root' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-09 16:18:40 1246 [Warning] Aborted connection 1246 to db: 'EM_SecurityDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-09 16:19:32 1247 [Warning] Aborted connection 1247 to db: 'EM_SecurityDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-09 16:26:58 1242 [Warning] Aborted connection 1242 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-09 16:30:40 1245 [Warning] Aborted connection 1245 to db: 'EM_ImmigrationDb' user: 'root' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-09 16:30:50 1240 [Warning] Aborted connection 1240 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-09 16:31:26 1239 [Warning] Aborted connection 1239 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-09 16:37:38 1248 [Warning] Aborted connection 1248 to db: 'EM_ImmigrationDb' user: 'root' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-09 16:48:38 1223 [Warning] Aborted connection 1223 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-09 17:02:46 1251 [Warning] Aborted connection 1251 to db: 'EM_AdministrationDb' user: 'root' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-09 17:06:07 1204 [Warning] Aborted connection 1204 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-09 17:06:07 1220 [Warning] Aborted connection 1220 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-09 17:08:18 1210 [Warning] Aborted connection 1210 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-09 17:08:18 1208 [Warning] Aborted connection 1208 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-09 17:08:18 1212 [Warning] Aborted connection 1212 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-09 17:08:18 1197 [Warning] Aborted connection 1197 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-09 17:17:17 7 [Note] InnoDB: WSREP: BF lock wait long for trx:0x268a71b query: UPDATE User SET LastLoggedInTime= SYSDATE() WHERE LoginUsername='RA5383017'▒▒ DONOR/DESYNCED (TO: 14580811) 2024-05-10 4:16:18 1339 [Note] WSREP: pause 2024-05-10 4:16:18 1339 [Note] WSREP: Provider paused at 90650610-a141-11ee-8145-07b32e6dc917:14580811 (1118126) 2024-05-10 4:16:18 1339 [Note] WSREP: Provider paused at: 14580811 2024-05-10 4:16:18 1339 [Note] WSREP: Server paused at: 14580811 2024-05-10 4:21:38 0 [Note] WSREP: Member 0.0 (EMDB02) resyncs itself to group. 2024-05-10 4:21:38 0 [Note] WSREP: Member 0.0 (EMDB02) synced with group. 2024-05-10 4:24:37 1339 [Note] WSREP: Resuming and resyncing the provider 2024-05-10 4:24:37 1339 [Note] WSREP: resume 2024-05-10 4:24:37 1339 [Note] WSREP: resuming provider at 1118126 2024-05-10 4:24:37 1339 [Note] WSREP: Provider resumed. 2024-05-10 4:24:37 0 [Note] WSREP: Member 2.0 (EMADRDB01) resyncs itself to group. 2024-05-10 4:24:37 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 14580826) 2024-05-10 4:24:37 0 [Note] WSREP: Processing event queue:... -nan% (0/0 events) complete. 2024-05-10 4:24:37 0 [Note] WSREP: Member 2.0 (EMADRDB01) synced with group. 2024-05-10 4:24:37 0 [Note] WSREP: Processing event queue:...100.0% (1/1 events) complete. 2024-05-10 4:24:37 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 14580826) 2024-05-10 4:24:37 2 [Note] WSREP: Server EMADRDB01 synced with group 2024-05-10 7:53:46 1340 [Warning] Aborted connection 1340 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 7:53:49 1342 [Warning] Aborted connection 1342 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 7:53:53 1341 [Warning] Aborted connection 1341 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 7:54:43 1344 [Note] InnoDB: Foreign Key referenced table EM_ImmigrationDb/MST_CODE not found for foreign table EM_ImmigrationDb/EMP_CAPACITY_ENHANCE_FACILITY 2024-05-10 8:13:08 1344 [Note] InnoDB: Foreign Key referenced table EM_ImmigrationDb/MST_CODE not found for foreign table EM_ImmigrationDb/EMP_CAPACITY_ENHANCE_FACILITY 2024-05-10 8:13:12 1344 [Note] InnoDB: Foreign Key referenced table EM_AdministrationDb/Location_BKP not found for foreign table EM_AdministrationDb/Currency 2024-05-10 8:26:42 1346 [Warning] Aborted connection 1346 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 8:28:56 1343 [Warning] Aborted connection 1343 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 8:31:43 1344 [Warning] Aborted connection 1344 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 8:48:12 1345 [Warning] Aborted connection 1345 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 9:38:54 1355 [Warning] Aborted connection 1355 to db: 'EM_ImmigrationDb' user: 'root' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 9:45:17 1352 [Warning] Aborted connection 1352 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 9:45:18 1354 [Warning] Aborted connection 1354 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 9:45:26 1351 [Warning] Aborted connection 1351 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 9:52:43 1356 [Warning] Aborted connection 1356 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 9:56:24 1357 [Warning] Aborted connection 1357 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 10:04:02 1359 [Warning] Aborted connection 1359 to db: 'EM_ImmigrationDb' user: 'root' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 10:06:37 1360 [Warning] Aborted connection 1360 to db: 'EM_ImmigrationDb' user: 'root' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 10:07:39 1362 [Warning] Aborted connection 1362 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 10:07:39 1363 [Warning] Aborted connection 1363 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 10:07:40 1364 [Warning] Aborted connection 1364 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 10:20:36 1350 [Warning] Aborted connection 1350 to db: 'EM_SecurityDb' user: 'root' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 10:25:05 1396 [Warning] Aborted connection 1396 to db: 'EM_AdministrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 10:25:05 1395 [Warning] Aborted connection 1395 to db: 'EM_AdministrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 10:25:05 1394 [Warning] Aborted connection 1394 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 10:25:06 1393 [Warning] Aborted connection 1393 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 10:25:06 1387 [Warning] Aborted connection 1387 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 10:27:22 1358 [Warning] Aborted connection 1358 to db: 'EM_SecurityDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 10:33:48 1366 [Warning] Aborted connection 1366 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 10:35:06 1368 [Warning] Aborted connection 1368 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 11:03:38 1399 [Warning] Aborted connection 1399 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 11:04:01 1397 [Warning] Aborted connection 1397 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 11:04:14 1398 [Warning] Aborted connection 1398 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 11:07:21 1406 [Warning] Aborted connection 1406 to db: 'EM_ImmigrationDb' user: 'root' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 11:12:19 1404 [Note] InnoDB: Foreign Key referenced table EM_AdministrationDb/Location_BKP not found for foreign table EM_AdministrationDb/Currency 2024-05-10 11:14:09 1403 [Warning] Aborted connection 1403 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 11:23:02 1365 [Warning] Aborted connection 1365 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 11:30:15 1405 [Warning] Aborted connection 1405 to db: 'EM_SecurityDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 11:30:29 1404 [Warning] Aborted connection 1404 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 11:32:52 1407 [Warning] Aborted connection 1407 to db: 'EM_AdministrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 11:33:17 1409 [Warning] Aborted connection 1409 to db: 'EM_AdministrationDb' user: 'root' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 11:37:18 1401 [Warning] Aborted connection 1401 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 11:43:07 1411 [Warning] Aborted connection 1411 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 11:43:07 1412 [Warning] Aborted connection 1412 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 11:43:08 1413 [Warning] Aborted connection 1413 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 11:43:14 1410 [Warning] Aborted connection 1410 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 11:46:50 1408 [Warning] Aborted connection 1408 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 11:54:06 1414 [Warning] Aborted connection 1414 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 11:54:07 1415 [Warning] Aborted connection 1415 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 11:54:07 1416 [Warning] Aborted connection 1416 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 11:54:08 1417 [Warning] Aborted connection 1417 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 11:58:01 1418 [Warning] Aborted connection 1418 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 11:58:02 1419 [Warning] Aborted connection 1419 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 11:58:02 1420 [Warning] Aborted connection 1420 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:00:06 1421 [Warning] Aborted connection 1421 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:00:26 1426 [Warning] Aborted connection 1426 to db: 'EM_ImmigrationDb' user: 'root' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 12:01:30 1422 [Warning] Aborted connection 1422 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:01:31 1423 [Warning] Aborted connection 1423 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:01:31 1424 [Warning] Aborted connection 1424 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:01:34 1425 [Warning] Aborted connection 1425 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:07:19 1440 [Warning] Aborted connection 1440 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:07:19 1436 [Warning] Aborted connection 1436 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:08:52 1434 [Warning] Aborted connection 1434 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 12:14:36 1427 [Warning] Aborted connection 1427 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:14:37 1428 [Warning] Aborted connection 1428 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:14:38 1429 [Warning] Aborted connection 1429 to db: 'EM_SecurityDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:14:39 1430 [Warning] Aborted connection 1430 to db: 'EM_AdministrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:15:27 1435 [Warning] Aborted connection 1435 to db: 'EM_SecurityDb' user: 'root' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 12:21:29 1431 [Warning] Aborted connection 1431 to db: 'EM_SecurityDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:24:54 1437 [Warning] Aborted connection 1437 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:24:55 1439 [Warning] Aborted connection 1439 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:26:03 1441 [Warning] Aborted connection 1441 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:28:24 1438 [Warning] Aborted connection 1438 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:41:54 1443 [Warning] Aborted connection 1443 to db: 'EM_ImmigrationDb' user: 'root' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 12:53:48 1458 [Warning] Aborted connection 1458 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:53:48 1462 [Warning] Aborted connection 1462 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:55:08 1445 [Warning] Aborted connection 1445 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:55:09 1446 [Warning] Aborted connection 1446 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:55:09 1447 [Warning] Aborted connection 1447 to db: 'EM_SecurityDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:55:10 1448 [Warning] Aborted connection 1448 to db: 'EM_AdministrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:55:35 1449 [Warning] Aborted connection 1449 to db: 'EM_SecurityDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 12:56:52 1452 [Warning] Aborted connection 1452 to db: 'EM_ImmigrationDb' user: 'root' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 12:58:22 1453 [Warning] Aborted connection 1453 to db: 'EM_ImmigrationDb' user: 'root' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 13:02:19 1459 [Note] InnoDB: Foreign Key referenced table EM_AdministrationDb/Location_BKP not found for foreign table EM_AdministrationDb/Currency 2024-05-10 13:06:19 1444 [Warning] Aborted connection 1444 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 13:08:32 1454 [Warning] Aborted connection 1454 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 13:08:32 1455 [Warning] Aborted connection 1455 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 13:08:33 1456 [Warning] Aborted connection 1456 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 13:09:48 1466 [Note] InnoDB: Foreign Key referenced table EM_ImmigrationDb/MST_CODE not found for foreign table EM_ImmigrationDb/EMP_CAPACITY_ENHANCE_FACILITY 2024-05-10 13:09:48 1466 [Note] InnoDB: Foreign Key referenced table EM_ImmigrationDb/MST_CODE not found for foreign table EM_ImmigrationDb/EMP_CAPACITY_ENHANCE_FACILITY 2024-05-10 13:10:30 1451 [Warning] Aborted connection 1451 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 13:11:45 1461 [Warning] Aborted connection 1461 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 13:20:29 1463 [Warning] Aborted connection 1463 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 13:20:31 1459 [Warning] Aborted connection 1459 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 13:21:23 1457 [Warning] Aborted connection 1457 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 13:23:24 1450 [Warning] Aborted connection 1450 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 13:23:45 1471 [Warning] Aborted connection 1471 to db: 'EM_ImmigrationDb' user: 'root' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 13:23:56 1460 [Warning] Aborted connection 1460 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 13:27:07 1472 [Warning] Aborted connection 1472 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 13:27:11 1465 [Warning] Aborted connection 1465 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 13:27:13 1467 [Warning] Aborted connection 1467 to db: 'EM_SecurityDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 13:27:13 1468 [Warning] Aborted connection 1468 to db: 'EM_AdministrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 13:27:43 1469 [Warning] Aborted connection 1469 to db: 'EM_SecurityDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 13:28:05 1466 [Warning] Aborted connection 1466 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 13:28:39 1470 [Warning] Aborted connection 1470 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 13:41:37 1474 [Warning] Aborted connection 1474 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 13:42:55 1473 [Warning] Aborted connection 1473 to db: 'EM_ImmigrationDb' user: 'root' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 13:53:37 1475 [Warning] Aborted connection 1475 to db: 'EM_ImmigrationDb' user: 'root' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 13:56:55 1480 [Warning] Aborted connection 1480 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 13:56:55 1476 [Warning] Aborted connection 1476 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 14:13:51 1477 [Note] InnoDB: Foreign Key referenced table EM_AdministrationDb/Location_BKP not found for foreign table EM_AdministrationDb/Currency 2024-05-10 14:13:51 1477 [Note] InnoDB: Foreign Key referenced table EM_ImmigrationDb/MST_CODE not found for foreign table EM_ImmigrationDb/EMP_CAPACITY_ENHANCE_FACILITY 2024-05-10 14:13:51 1477 [Note] InnoDB: Foreign Key referenced table EM_BackupDb/SecurityGroup not found for foreign table EM_BackupDb/UserSecurityGroup 2024-05-10 14:13:51 1477 [Note] InnoDB: Foreign Key referenced table EM_BackupDb/UserStatusType not found for foreign table EM_BackupDb/User 2024-05-10 14:13:51 1477 [Note] InnoDB: Foreign Key referenced table EM_BackupDb/OTP_PURPOSE_LOOKUP not found for foreign table EM_BackupDb/OTP 2024-05-10 14:14:25 1479 [Warning] Aborted connection 1479 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 14:24:35 1488 [Warning] Aborted connection 1488 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 14:24:35 1484 [Warning] Aborted connection 1484 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 14:25:38 1485 [Note] InnoDB: Foreign Key referenced table EM_AdministrationDb/Location_BKP not found for foreign table EM_AdministrationDb/Currency 2024-05-10 14:25:38 1485 [Note] InnoDB: Foreign Key referenced table EM_ImmigrationDb/MST_CODE not found for foreign table EM_ImmigrationDb/EMP_CAPACITY_ENHANCE_FACILITY 2024-05-10 14:25:38 1485 [Note] InnoDB: Foreign Key referenced table EM_BackupDb/SecurityGroup not found for foreign table EM_BackupDb/UserSecurityGroup 2024-05-10 14:25:38 1485 [Note] InnoDB: Foreign Key referenced table EM_BackupDb/UserStatusType not found for foreign table EM_BackupDb/User 2024-05-10 14:25:38 1485 [Note] InnoDB: Foreign Key referenced table EM_BackupDb/OTP_PURPOSE_LOOKUP not found for foreign table EM_BackupDb/OTP 2024-05-10 14:26:33 1483 [Warning] Aborted connection 1483 to db: 'EM_ImmigrationDb' user: 'root' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 14:42:25 1489 [Warning] Aborted connection 1489 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 14:43:26 1482 [Warning] Aborted connection 1482 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 14:43:42 1485 [Warning] Aborted connection 1485 to db: 'unconnected' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 14:44:00 1487 [Warning] Aborted connection 1487 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 14:44:55 1486 [Warning] Aborted connection 1486 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 15:15:25 1491 [Warning] Aborted connection 1491 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 15:25:55 1490 [Warning] Aborted connection 1490 to db: 'EM_ImmigrationDb' user: 'root' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 15:35:12 1493 [Warning] Aborted connection 1493 to db: 'unconnected' user: 'unauthenticated' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 15:35:12 1493 [Warning] Aborted connection 1493 to db: 'unconnected' user: 'unauthenticated' host: '192.168.250.3' (This connection closed normally without authentication) 2024-05-10 15:35:12 1494 [Warning] Aborted connection 1494 to db: 'unconnected' user: 'unauthenticated' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 15:35:12 1494 [Warning] Aborted connection 1494 to db: 'unconnected' user: 'unauthenticated' host: '192.168.250.3' (This connection closed normally without authentication) 2024-05-10 15:35:12 1495 [Warning] Aborted connection 1495 to db: 'unconnected' user: 'unauthenticated' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 15:35:12 1495 [Warning] Aborted connection 1495 to db: 'unconnected' user: 'unauthenticated' host: '192.168.250.3' (This connection closed normally without authentication) 2024-05-10 15:38:51 1497 [Warning] Aborted connection 1497 to db: 'unconnected' user: 'unauthenticated' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 15:38:51 1497 [Warning] Aborted connection 1497 to db: 'unconnected' user: 'unauthenticated' host: '192.168.250.3' (This connection closed normally without authentication) 2024-05-10 15:38:51 1498 [Warning] Aborted connection 1498 to db: 'unconnected' user: 'unauthenticated' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 15:38:51 1498 [Warning] Aborted connection 1498 to db: 'unconnected' user: 'unauthenticated' host: '192.168.250.3' (This connection closed normally without authentication) 2024-05-10 15:38:51 1499 [Warning] Aborted connection 1499 to db: 'unconnected' user: 'unauthenticated' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 15:38:51 1499 [Warning] Aborted connection 1499 to db: 'unconnected' user: 'unauthenticated' host: '192.168.250.3' (This connection closed normally without authentication) 2024-05-10 15:39:48 1492 [Warning] Aborted connection 1492 to db: 'EM_SecurityDb' user: 'root' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 15:42:12 1369 [Warning] Aborted connection 1369 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 16:15:19 1505 [Warning] Aborted connection 1505 to db: 'EM_ImmigrationDb' user: 'root' host: '192.168.250.3' (Got timeout reading communication packets) 2024-05-10 16:23:54 1506 [Warning] Aborted connection 1506 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 16:23:55 1507 [Warning] Aborted connection 1507 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 16:23:56 1508 [Warning] Aborted connection 1508 to db: 'EM_SecurityDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 16:23:57 1509 [Warning] Aborted connection 1509 to db: 'EM_AdministrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 16:23:58 1510 [Warning] Aborted connection 1510 to db: 'EM_SecurityDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 16:23:59 1511 [Warning] Aborted connection 1511 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 16:26:39 1512 [Warning] Aborted connection 1512 to db: 'EM_ImmigrationDb' user: 'emigratetrans' host: '192.168.250.3' (Got an error reading communication packets) 2024-05-10 16:29:02 1 [ERROR] Slave SQL: Error 'CREATE command denied to user ''@'connecting host' for table `EM_BackupDb`.`Missisng_ARN_cases`' on query. Default database: 'EM_ImmigrationDb'. Query: 'CREATE TABLE `EM_BackupDb`.`Missisng_ARN_cases` ( `ENC_JOB_ID` int(11) DEFAULT NULL, `EPS_PASSPORT_NUM` varchar(60) NOT NULL, `EAR_EMIGRANT_ARN` int(10) NOT NULL DEFAULT 0 )', Internal MariaDB error code: 1142 2024-05-10 16:29:02 1 [Warning] WSREP: Event 1 Query apply failed: 1, seqno 14716574 2024-05-10 16:29:02 0 [Note] WSREP: Member 2(EMADRDB01) initiates vote on 90650610-a141-11ee-8145-07b32e6dc917:14716574,f9cc0dd67d55a7e8: CREATE command denied to user ''@'connecting host' for table `EM_BackupDb`.`Missisng_ARN_cases`, Error_code: 1142; 2024-05-10 16:29:02 0 [Note] WSREP: Votes over 90650610-a141-11ee-8145-07b32e6dc917:14716574: f9cc0dd67d55a7e8: 1/3 Waiting for more votes. 2024-05-10 16:29:03 0 [Note] WSREP: Member 1(EMDB01) responds to vote on 90650610-a141-11ee-8145-07b32e6dc917:14716574,0000000000000000: Success 2024-05-10 16:29:03 0 [Note] WSREP: Votes over 90650610-a141-11ee-8145-07b32e6dc917:14716574: 0000000000000000: 1/3 f9cc0dd67d55a7e8: 1/3 Waiting for more votes. 2024-05-10 16:29:03 0 [Note] WSREP: Member 0(EMDB02) responds to vote on 90650610-a141-11ee-8145-07b32e6dc917:14716574,0000000000000000: Success 2024-05-10 16:29:03 0 [Note] WSREP: Votes over 90650610-a141-11ee-8145-07b32e6dc917:14716574: 0000000000000000: 2/3 f9cc0dd67d55a7e8: 1/3 Winner: 0000000000000000 2024-05-10 16:29:03 1 [ERROR] WSREP: Inconsistency detected: Inconsistent by consensus on 90650610-a141-11ee-8145-07b32e6dc917:14716574 at /home/buildbot/buildbot/build/galera/src/replicator_smm.cpp:process_apply_error():1342 2024-05-10 16:29:03 1 [Note] WSREP: Closing send monitor... 2024-05-10 16:29:03 1 [Note] WSREP: Closed send monitor. 2024-05-10 16:29:03 1 [Note] WSREP: gcomm: terminating thread 2024-05-10 16:29:03 1 [Note] WSREP: gcomm: joining thread 2024-05-10 16:29:03 1 [Note] WSREP: gcomm: closing backend 2024-05-10 16:29:03 1 [Note] WSREP: view(view_id(NON_PRIM,22efc2ab-a5b1,41) memb { fdc0d84b-8bdf,0 } joined { } left { } partitioned { 22efc2ab-a5b1,0 bd13c561-9589,0 }) 2024-05-10 16:29:03 1 [Note] WSREP: PC protocol downgrade 1 -> 0 2024-05-10 16:29:03 1 [Note] WSREP: view((empty)) 2024-05-10 16:29:03 1 [Note] WSREP: gcomm: closed 2024-05-10 16:29:03 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2024-05-10 16:29:03 0 [Note] WSREP: Flow-control interval: [16, 16] 2024-05-10 16:29:03 0 [Note] WSREP: Received NON-PRIMARY. 2024-05-10 16:29:03 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 14716577) 2024-05-10 16:29:03 0 [Note] WSREP: New SELF-LEAVE. 2024-05-10 16:29:03 0 [Note] WSREP: Flow-control interval: [0, 0] 2024-05-10 16:29:03 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2024-05-10 16:29:03 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 14716577) 2024-05-10 16:29:03 0 [Note] WSREP: RECV thread exiting 0: Success 2024-05-10 16:29:03 8 [Note] WSREP: ================================================ View: id: 90650610-a141-11ee-8145-07b32e6dc917:14716577 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: fdc0d84b-019b-11ef-8bdf-863fa6afdfb6, EMADRDB01 ================================================= 2024-05-10 16:29:03 8 [Note] WSREP: Non-primary view 2024-05-10 16:29:03 8 [Note] WSREP: Server status change synced -> connected 2024-05-10 16:29:03 8 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-05-10 16:29:03 1 [Note] WSREP: recv_thread() joined. 2024-05-10 16:29:03 1 [Note] WSREP: Closing replication queue. 2024-05-10 16:29:03 1 [Note] WSREP: Closing slave action queue. 2024-05-10 16:29:03 1 [ERROR] WSREP: Failed to apply write set: gtid: 90650610-a141-11ee-8145-07b32e6dc917:14716574 server_id: fdc0d84b-019b-11ef-8bdf-863fa6afdfb6 client_id: 1515 trx_id: 1730759 flags: 3 (start_transaction | commit) 2024-05-10 16:29:03 8 [Note] WSREP: ================================================ View: id: 90650610-a141-11ee-8145-07b32e6dc917:14716577 status: non-primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: yes own_index: -1 members(0): ================================================= 2024-05-10 16:29:03 1515 [ERROR] WSREP: trx_replay failed for: 7, schema: EM_ImmigrationDb, query: CREATE TABLE `EM_BackupDb`.`Missisng_ARN_cases` AS SELECT en.ENC_JOB_ID,ep.EPS_PASSPORT_NUM ,A.EAR_EMIGRANT_ARN FROM EMIGRANT_APPLICATION_RECORD A, EMIGRANT_NC en, EMIGRANT_PASSPORT ep WHERE A.EAR_EMIGRANT_ARN = en.ENC_EMIGRANT_ARN AND A.EAR_EMIGRANT_ARN = ep.`EPS_EMIGRANT_ARN` -- and ep.EPS_PASSPORT_NUM = 'R3232167' AND A.EAR_CREATED_DTTM >='2023-09-01' AND A.EAR_CREATED_DTTM <'2024-03-18' AND A.EAR_APPLICATION_STATUS_CD IN ('EAS_APPR','EAS_TRVL','EAS_ARVD') AND A.EAR_EMIGRANT_ARN IN ( SELECT EAR_EMIGRANT_ARN FROM ( SELECT A.EAR_EMIGRANT_ARN , COUNT(1) FROM EMIGRANT_APPLICATION_RECORD A INNER JOIN EMIGRANT_NC B ON B.ENC_EMIGRANT_ARN =A.EAR_EMIGRANT_ARN INNER JOIN REPORT_EC_DEPLOYED C ON C.RED_JOB_ID =B.ENC_JOB_ID WHERE A.EAR_CREATED_DTTM >='2023-09-01' AND A.EAR_CREATED_DTTM <'2024-03-18' AND A.EAR_APPLICATION_STATUS_CD IN ('EAS_APPR','EAS_TRVL','EAS_ARVD') AND C.RED_EMIGRANT_ARN IS NULL GROUP BY B.ENC_JOB_ID,A.EAR_EMIGRANT 2024-05-10 16:29:03 1515 [ERROR] Aborting 2024-05-10 16:29:03 8 [Note] WSREP: Non-primary view 2024-05-10 16:29:03 7 [Warning] Aborted connection 7 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2024-05-10 16:29:03 6 [Warning] Aborted connection 6 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2024-05-10 16:29:03 2 [Warning] Aborted connection 2 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2024-05-10 16:29:03 8 [Warning] Aborted connection 8 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2024-05-10 16:29:05 0x7fdeebe48640 InnoDB: Assertion failure in file /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.11.6/storage/innobase/trx/trx0sys.cc line 339 InnoDB: Failing assertion: trx_list.empty() InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mariadbd startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/ InnoDB: about forcing recovery. 240510 16:29:05 [ERROR] mysqld got signal 6 ; Sorry, we probably made a mistake, and this is a bug. Your assistance in bug reporting will enable us to fix this for the next release. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.11.6-MariaDB source revision: fecd78b83785d5ae96f2c6ff340375be803cd299 key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=35 max_threads=65541 thread_count=11 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 142828507 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x0 thread_stack 0x30000 /usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x55ba8b9f1d0e] /usr/sbin/mariadbd(handle_fatal_signal+0x468)[0x55ba8b4cd178] /lib64/libc.so.6(+0x54db0)[0x7fdef7a54db0] /lib64/libc.so.6(+0xa154c)[0x7fdef7aa154c] /lib64/libc.so.6(raise+0x16)[0x7fdef7a54d06] /lib64/libc.so.6(abort+0xd3)[0x7fdef7a287f3] /usr/sbin/mariadbd(+0x6a0ebb)[0x55ba8b0f9ebb] /usr/sbin/mariadbd(+0x69ebf6)[0x55ba8b0f7bf6] /usr/sbin/mariadbd(+0xe39962)[0x55ba8b892962] /usr/sbin/mariadbd(+0xd3faaf)[0x55ba8b798aaf] /usr/sbin/mariadbd(_Z22ha_finalize_handlertonP13st_plugin_int+0x46)[0x55ba8b4cfca6] /usr/sbin/mariadbd(+0x833d2d)[0x55ba8b28cd2d] /usr/sbin/mariadbd(+0x83661e)[0x55ba8b28f61e] /usr/sbin/mariadbd(_Z15plugin_shutdownv+0x8c)[0x55ba8b2903ec] /usr/sbin/mariadbd(+0x70b70f)[0x55ba8b16470f] /usr/sbin/mariadbd(unireg_abort+0x6f)[0x55ba8b167baf] /usr/sbin/mariadbd(_ZN22Wsrep_replayer_serviceD2Ev+0x28a)[0x55ba8b760f8a] /usr/sbin/mariadbd(_ZN20Wsrep_client_service6replayEv+0x10c)[0x55ba8b75f1dc] /usr/sbin/mariadbd(_ZN5wsrep11transaction6replayERSt11unique_lockINS_5mutexEE+0xbd)[0x55ba8baaa2bd] /usr/sbin/mariadbd(_ZN5wsrep11transaction15after_statementERSt11unique_lockINS_5mutexEE+0xbd)[0x55ba8baaa7ed] /usr/sbin/mariadbd(_ZN5wsrep12client_state15after_statementEv+0x6a)[0x55ba8ba8c9ba] /usr/sbin/mariadbd(+0x821cd8)[0x55ba8b27acd8] /usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x28cc)[0x55ba8b27d9cc] /usr/sbin/mariadbd(_Z10do_commandP3THDb+0x134)[0x55ba8b27e3b4] /usr/sbin/mariadbd(_Z11tp_callbackP13TP_connection+0x87)[0x55ba8b456247] /usr/sbin/mariadbd(+0xbf62fd)[0x55ba8b64f2fd] /usr/sbin/mariadbd(+0xc9a752)[0x55ba8b6f3752] /lib64/libc.so.6(+0x9f802)[0x7fdef7a9f802] /lib64/libc.so.6(+0x3f450)[0x7fdef7a3f450] The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/ contains information that should help you find out what is causing the crash. Writing a core file... Working directory at /emigrate_data/DR Resource Limits: Limit Soft Limit Hard Limit Units Max cpu time unlimited unlimited seconds Max file size unlimited unlimited bytes Max data size unlimited unlimited bytes Max stack size 8388608 unlimited bytes Max core file size 0 unlimited bytes Max resident set unlimited unlimited bytes Max processes 1027796 1027796 processes Max open files 32768 32768 files Max locked memory 8388608 8388608 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 1027796 1027796 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Max realtime timeout unlimited unlimited us Core pattern: |/usr/lib/systemd/systemd-coredump %P %u %g %s %t %c %h Kernel version: Linux version 5.14.0-362.13.1.el9_3.x86_64 (mockbuild@x86-64-01.build.eng.rdu2.redhat.com) (gcc (GCC) 11.4.1 20230605 (Red Hat 11.4.1-2), GNU ld version 2.35.2-42.el9) #1 SMP PREEMPT_DYNAMIC Fri Nov 24 01:57:57 EST 2023 2024-05-10 16:29:16 0 [Note] Starting MariaDB 10.11.6-MariaDB source revision fecd78b83785d5ae96f2c6ff340375be803cd299 as process 757420 2024-05-10 16:29:16 0 [Note] WSREP: Loading provider /usr/lib64/galera-4/libgalera_smm.so initial position: 90650610-a141-11ee-8145-07b32e6dc917:14716577 2024-05-10 16:29:16 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera-4/libgalera_smm.so' 2024-05-10 16:29:16 0 [Note] WSREP: wsrep_load(): Galera 26.4.16(r7dce5149) by Codership Oy loaded successfully. 2024-05-10 16:29:16 0 [Note] WSREP: Initializing allowlist service v1 2024-05-10 16:29:16 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration. 2024-05-10 16:29:16 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 0 2024-05-10 16:29:16 0 [Note] WSREP: GCache DEBUG: opened preamble: Version: 2 UUID: 90650610-a141-11ee-8145-07b32e6dc917 Seqno: 14494211 - 14716577 Offset: 271077208 Synced: 1 2024-05-10 16:29:16 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 90650610-a141-11ee-8145-07b32e6dc917, offset: 271077208 2024-05-10 16:29:16 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/314572824 bytes) complete. 2024-05-10 16:29:17 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (314572824/314572824 bytes) complete. 2024-05-10 16:29:17 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 14494211-14716577 2024-05-10 16:29:17 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% ( 0/300461072 bytes) complete. 2024-05-10 16:29:17 0 [Note] WSREP: Recovering GCache ring buffer: found 3/222370 locked buffers 2024-05-10 16:29:17 0 [Note] WSREP: Recovering GCache ring buffer: free space: 14111920/314572800 2024-05-10 16:29:17 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (300461072/300461072 bytes) complete. 2024-05-10 16:29:17 0 [Note] WSREP: Passing config to GCS: base_dir = /emigrate_data/DR/; base_host = 10.100.20.3; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /emigrate_data/DR/; gcache.keep_pages_size = 0; gcache.keep_plaintext_size = 300M; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 300M; gcache.recover = yes; gcache.size = 300M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.fc_single_primary = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment 2024-05-10 16:29:17 0 [Note] WSREP: Start replication 2024-05-10 16:29:17 0 [Note] WSREP: Connecting with bootstrap option: 0 2024-05-10 16:29:17 0 [Note] WSREP: Setting GCS initial position to 00000000-0000-0000-0000-000000000000:-1 2024-05-10 16:29:17 0 [Note] WSREP: protonet asio version 0 2024-05-10 16:29:17 0 [Note] WSREP: Using CRC-32C for message checksums. 2024-05-10 16:29:17 0 [Note] WSREP: backend: asio 2024-05-10 16:29:17 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2024-05-10 16:29:17 0 [Note] WSREP: access file(/emigrate_data/DR//gvwstate.dat) failed(No such file or directory) 2024-05-10 16:29:17 0 [Note] WSREP: restore pc from disk failed 2024-05-10 16:29:17 0 [Note] WSREP: GMCast version 0 2024-05-10 16:29:17 0 [Note] WSREP: (5860128d-89b3, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 2024-05-10 16:29:17 0 [Note] WSREP: (5860128d-89b3, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 2024-05-10 16:29:17 0 [Note] WSREP: EVS version 1 2024-05-10 16:29:17 0 [Note] WSREP: gcomm: connecting to group 'emigrate_galera_cluster', peer '10.40.10.5:,10.40.10.6:,10.100.20.3:' 2024-05-10 16:29:17 0 [Note] WSREP: (5860128d-89b3, 'tcp://0.0.0.0:4567') Found matching local endpoint for a connection, blacklisting address tcp://10.100.20.3:4567 2024-05-10 16:29:17 0 [Note] WSREP: (5860128d-89b3, 'tcp://0.0.0.0:4567') connection established to 22efc2ab-a5b1 tcp://10.40.10.6:4567 2024-05-10 16:29:17 0 [Note] WSREP: (5860128d-89b3, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 2024-05-10 16:29:17 0 [Note] WSREP: (5860128d-89b3, 'tcp://0.0.0.0:4567') connection established to bd13c561-9589 tcp://10.40.10.5:4567 2024-05-10 16:29:17 0 [Note] WSREP: EVS version upgrade 0 -> 1 2024-05-10 16:29:17 0 [Note] WSREP: declaring 22efc2ab-a5b1 at tcp://10.40.10.6:4567 stable 2024-05-10 16:29:17 0 [Note] WSREP: declaring bd13c561-9589 at tcp://10.40.10.5:4567 stable 2024-05-10 16:29:17 0 [Note] WSREP: PC protocol upgrade 0 -> 1 2024-05-10 16:29:17 0 [Note] WSREP: Node 22efc2ab-a5b1 state prim 2024-05-10 16:29:17 0 [Note] WSREP: view(view_id(PRIM,22efc2ab-a5b1,43) memb { 22efc2ab-a5b1,0 5860128d-89b3,0 bd13c561-9589,0 } joined { } left { } partitioned { }) 2024-05-10 16:29:17 0 [Note] WSREP: save pc into disk 2024-05-10 16:29:18 0 [Note] WSREP: gcomm: connected 2024-05-10 16:29:18 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2024-05-10 16:29:18 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2024-05-10 16:29:18 0 [Note] WSREP: Opened channel 'emigrate_galera_cluster' 2024-05-10 16:29:18 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3 2024-05-10 16:29:18 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2024-05-10 16:29:18 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 7c7d0130-0ebc-11ef-b14b-bf6699d26e97 2024-05-10 16:29:18 0 [Note] WSREP: STATE EXCHANGE: got state msg: 7c7d0130-0ebc-11ef-b14b-bf6699d26e97 from 0 (EMDB02) 2024-05-10 16:29:18 0 [Note] WSREP: STATE EXCHANGE: got state msg: 7c7d0130-0ebc-11ef-b14b-bf6699d26e97 from 2 (EMDB01) 2024-05-10 16:29:18 1 [Note] WSREP: Starting rollbacker thread 1 2024-05-10 16:29:18 2 [Note] WSREP: Starting applier thread 2 2024-05-10 16:29:18 0 [Note] WSREP: STATE EXCHANGE: got state msg: 7c7d0130-0ebc-11ef-b14b-bf6699d26e97 from 1 (EMADRDB01) 2024-05-10 16:29:18 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 39, members = 2/3 (joined/total), act_id = 14716697, last_appl. = 14716614, protocols = 2/10/4 (gcs/repl/appl), vote policy= 0, group UUID = 90650610-a141-11ee-8145-07b32e6dc917 2024-05-10 16:29:18 0 [Note] WSREP: Votes over 90650610-a141-11ee-8145-07b32e6dc917:14716574: 0000000000000000: 2/2 Winner: 0000000000000000 2024-05-10 16:29:18 0 [Note] WSREP: Flow-control interval: [28, 28] 2024-05-10 16:29:18 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 14716698) 2024-05-10 16:29:18 2 [Note] WSREP: ####### processing CC 14716698, local, ordered 2024-05-10 16:29:18 2 [Note] WSREP: Process first view: 90650610-a141-11ee-8145-07b32e6dc917 my uuid: 5860128d-0ebc-11ef-89b3-ff437bd1674a 2024-05-10 16:29:18 2 [Note] WSREP: Server EMADRDB01 connected to cluster at position 90650610-a141-11ee-8145-07b32e6dc917:14716698 with ID 5860128d-0ebc-11ef-89b3-ff437bd1674a 2024-05-10 16:29:18 2 [Note] WSREP: Server status change disconnected -> connected 2024-05-10 16:29:18 2 [Note] WSREP: ####### My UUID: 5860128d-0ebc-11ef-89b3-ff437bd1674a 2024-05-10 16:29:18 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes 2024-05-10 16:29:18 0 [Note] WSREP: Service thread queue flushed. 2024-05-10 16:29:18 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1 2024-05-10 16:29:18 2 [Note] WSREP: State transfer required: Group state: 90650610-a141-11ee-8145-07b32e6dc917:14716698 Local state: 00000000-0000-0000-0000-000000000000:-1 2024-05-10 16:29:18 2 [Note] WSREP: Server status change connected -> joiner 2024-05-10 16:29:18 0 [Note] WSREP: Joiner monitor thread started to monitor 2024-05-10 16:29:18 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '10.100.20.3' --datadir '/emigrate_data/DR/' --parent 757420 --progress 0 --mysqld-args --wsrep_start_position=90650610-a141-11ee-8145-07b32e6dc917:14716577' WSREP_SST: [INFO] rsync SST started on joiner (20240510 16:29:18.224) 2024-05-10 16:29:18 2 [Note] WSREP: ####### IST uuid:00000000-0000-0000-0000-000000000000 f: 0, l: 14716698, STRv: 3 2024-05-10 16:29:18 2 [Note] WSREP: IST receiver addr using tcp://10.100.20.3:4568 2024-05-10 16:29:18 2 [Note] WSREP: Prepared IST receiver for 0-14716698, listening at: tcp://10.100.20.3:4568 2024-05-10 16:29:18 0 [Note] WSREP: Member 1.0 (EMADRDB01) requested state transfer from '*any*'. Selected 0.0 (EMDB02)(SYNCED) as donor. 2024-05-10 16:29:18 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 14716710) 2024-05-10 16:29:18 2 [Note] WSREP: Requesting state transfer: success, donor: 0 2024-05-10 16:29:18 2 [Note] WSREP: Resetting GCache seqno map due to different histories. 2024-05-10 16:29:18 2 [Note] WSREP: GCache history reset: 90650610-a141-11ee-8145-07b32e6dc917:14716577 -> 90650610-a141-11ee-8145-07b32e6dc917:14716698 2024-05-10 16:29:18 2 [Note] WSREP: GCache DEBUG: RingBuffer::seqno_reset(): discarded 300460704 bytes 2024-05-10 16:29:18 2 [Note] WSREP: GCache DEBUG: RingBuffer::seqno_reset(): found 1/14 locked buffers 2024-05-10 16:29:20 0 [Note] WSREP: (5860128d-89b3, 'tcp://0.0.0.0:4567') turning message relay requesting off 2024-05-10 19:07:29 0 [Note] WSREP: 0.0 (EMDB02): State transfer to 1.0 (EMADRDB01) complete. WSREP_SST: [INFO] Galera co-ords from recovery: 90650610-a141-11ee-8145-07b32e6dc917:14716711 0 (20240510 19:07:30.103) WSREP_SST: [INFO] rsync SST completed on joiner (20240510 19:07:30.112) WSREP_SST: [INFO] Joiner cleanup: rsync PID=757563, stunnel PID=0 (20240510 19:07:30.118) WSREP_SST: [INFO] Joiner cleanup done. (20240510 19:07:30.730) 2024-05-10 19:07:30 3 [Note] WSREP: SST received 2024-05-10 19:07:30 3 [Note] WSREP: Server status change joiner -> initializing 2024-05-10 19:07:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2024-05-10 19:07:30 0 [Note] InnoDB: Number of transaction pools: 1 2024-05-10 19:07:30 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2024-05-10 19:07:30 0 [Note] InnoDB: Using Linux native AIO 2024-05-10 19:07:30 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000GiB, chunk size = 2.000GiB 2024-05-10 19:07:31 0 [Note] WSREP: Member 0.0 (EMDB02) synced with group. 2024-05-10 19:07:31 0 [Note] InnoDB: Completed initialization of buffer pool 2024-05-10 19:07:32 0 [Note] InnoDB: Buffered log writes (block size=512 bytes) 2024-05-10 19:07:32 0 [Note] InnoDB: End of log at LSN=2143239922946 2024-05-10 19:07:32 0 [Note] InnoDB: 128 rollback segments are active. 2024-05-10 19:07:32 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ... 2024-05-10 19:07:32 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB. 2024-05-10 19:07:32 0 [Note] InnoDB: log sequence number 2143239922946; transaction id 62741505 2024-05-10 19:07:32 0 [Note] InnoDB: Loading buffer pool(s) from /emigrate_data/DR/ib_buffer_pool 2024-05-10 19:07:32 0 [Note] Plugin 'FEEDBACK' is disabled. 2024-05-10 19:07:32 0 [Warning] 'innodb-buffer-pool-instances' was removed. It does nothing now and exists only for compatibility with old my.cnf files. 2024-05-10 19:07:32 0 [Note] Server socket created on IP: '0.0.0.0'. 2024-05-10 19:07:32 0 [Note] Server socket created on IP: '0.0.0.0'. 2024-05-10 19:07:32 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) 2024-05-10 19:07:32 0 [Note] WSREP: Server initialized 2024-05-10 19:07:32 0 [Note] WSREP: Server status change initializing -> initialized 2024-05-10 19:07:32 3 [Note] WSREP: Recovered position from storage: 90650610-a141-11ee-8145-07b32e6dc917:14716711 2024-05-10 19:07:32 3 [Note] WSREP: Server status change initialized -> joined 2024-05-10 19:07:32 5 [Note] WSREP: Starting applier thread 5 2024-05-10 19:07:32 8 [Note] WSREP: Starting applier thread 8 2024-05-10 19:07:32 7 [Note] WSREP: Starting applier thread 7 2024-05-10 19:07:32 3 [Note] WSREP: Recovered view from SST: id: 90650610-a141-11ee-8145-07b32e6dc917:14716698 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(3): 0: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad, EMDB02 1: 5860128d-0ebc-11ef-89b3-ff437bd1674a, EMADRDB01 2: bd13c561-07e3-11ef-9589-83a4a27b0ba1, EMDB01 2024-05-10 19:07:32 0 [Note] /usr/sbin/mariadbd: ready for connections. Version: '10.11.6-MariaDB' socket: '/emigrate_data/DR/mysql.sock' port: 3306 MariaDB Server 2024-05-10 19:07:32 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-05-10 19:07:32 10 [Note] WSREP: Recovered cluster id 90650610-a141-11ee-8145-07b32e6dc917 2024-05-10 19:07:32 3 [Note] WSREP: SST received: 90650610-a141-11ee-8145-07b32e6dc917:14716711 2024-05-10 19:07:32 3 [Note] WSREP: SST succeeded for position 90650610-a141-11ee-8145-07b32e6dc917:14716711 2024-05-10 19:07:32 0 [Note] WSREP: Joiner monitor thread ended with total time 9494 sec 2024-05-10 19:07:32 2 [Note] WSREP: Installed new state from SST: 90650610-a141-11ee-8145-07b32e6dc917:14716711 2024-05-10 19:07:32 2 [Note] WSREP: Cert. index preload up to 14716711 2024-05-10 19:07:32 0 [Note] WSREP: ####### IST applying starts with 14716712 2024-05-10 19:07:32 0 [Note] WSREP: ####### IST current seqno initialized to 14716615 2024-05-10 19:07:32 0 [Note] WSREP: Receiving IST... 0.0% ( 0/84 events) complete. 2024-05-10 19:07:32 0 [Note] WSREP: IST preload starting at 14716615 2024-05-10 19:07:32 0 [Note] WSREP: Service thread queue flushed. 2024-05-10 19:07:32 0 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:14716614, protocol version: 5 2024-05-10 19:07:32 0 [Note] WSREP: REPL Protocols: 10 (5) 2024-05-10 19:07:32 0 [Note] WSREP: ####### Adjusting cert position: 14716697 -> 14716698 2024-05-10 19:07:32 0 [Note] WSREP: Service thread queue flushed. 2024-05-10 19:07:32 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 14716615 2024-05-10 19:07:32 0 [Note] WSREP: Min available from gcache for CC from preload: 14716615 2024-05-10 19:07:32 0 [Note] WSREP: Receiving IST...100.0% (84/84 events) complete. 2024-05-10 19:07:32 2 [Note] WSREP: Cert. index preloaded up to 14716698 2024-05-10 19:07:32 2 [Note] WSREP: Lowest cert index boundary for CC from sst: 14716615 2024-05-10 19:07:32 2 [Note] WSREP: Min available from gcache for CC from sst: 14716615 2024-05-10 19:07:32 0 [Note] WSREP: 1.0 (EMADRDB01): State transfer from 0.0 (EMDB02) complete. 2024-05-10 19:07:32 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 14756732) 2024-05-10 19:07:32 0 [Note] WSREP: Processing event queue:... 0.0% ( 0/39978 events) complete. 2024-05-10 19:07:33 0 [Note] InnoDB: Buffer pool(s) load completed at 240510 19:07:33 2024-05-10 19:07:35 8 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2523977 trx_id: 161747219 tstamp: 25421276851831942; state: seqnos (l: 39946, g: 14756642, s: 14716711, d: 14651176) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 2 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2523999 trx_id: 161747518 tstamp: 25421276852661584; state: seqnos (l: 39947, g: 14756643, s: 14716712, d: 14651177) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 5 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2523949 trx_id: 161747061 tstamp: 25421276852697453; state: seqnos (l: 39948, g: 14756644, s: 14716712, d: 14651177) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 7 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2524470 trx_id: 161751323 tstamp: 25421276852964558; state: seqnos (l: 39949, g: 14756645, s: 14716712, d: 14651177) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 2 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2524084 trx_id: 161748137 tstamp: 25421276852987086; state: seqnos (l: 39950, g: 14756646, s: 14716712, d: 14651177) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 8 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2524517 trx_id: 161751782 tstamp: 25421276853010541; state: seqnos (l: 39951, g: 14756647, s: 14716712, d: 14651177) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 5 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2524031 trx_id: 161747680 tstamp: 25421276853028800; state: seqnos (l: 39952, g: 14756648, s: 14716712, d: 14651177) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 7 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2524321 trx_id: 161750068 tstamp: 25421276853060931; state: seqnos (l: 39953, g: 14756649, s: 14716712, d: 14651177) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 2 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2524220 trx_id: 161749042 tstamp: 25421276853089128; state: seqnos (l: 39954, g: 14756650, s: 14716713, d: 14651178) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 8 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2524356 trx_id: 161750421 tstamp: 25421276853093569; state: seqnos (l: 39955, g: 14756651, s: 14716713, d: 14651178) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 5 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2524494 trx_id: 161751486 tstamp: 25421276853126321; state: seqnos (l: 39956, g: 14756652, s: 14716715, d: 14651180) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 7 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2524221 trx_id: 161749088 tstamp: 25421276853141319; state: seqnos (l: 39957, g: 14756653, s: 14716715, d: 14651180) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 2 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2523987 trx_id: 161747420 tstamp: 25421276853184438; state: seqnos (l: 39958, g: 14756654, s: 14716715, d: 14651180) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 8 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2524504 trx_id: 161751713 tstamp: 25421276853189057; state: seqnos (l: 39959, g: 14756655, s: 14716715, d: 14651180) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 5 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2524312 trx_id: 161749813 tstamp: 25421276853218780; state: seqnos (l: 39960, g: 14756656, s: 14716715, d: 14651180) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 7 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2524497 trx_id: 161751483 tstamp: 25421276853233513; state: seqnos (l: 39961, g: 14756657, s: 14716715, d: 14651180) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 2 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2524041 trx_id: 161747875 tstamp: 25421276853259036; state: seqnos (l: 39962, g: 14756658, s: 14716715, d: 14651180) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 8 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2524268 trx_id: 161749456 tstamp: 25421276853276066; state: seqnos (l: 39963, g: 14756659, s: 14716715, d: 14651180) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 5 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2524322 trx_id: 161749901 tstamp: 25421276853285797; state: seqnos (l: 39964, g: 14756660, s: 14716715, d: 14651180) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 7 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2523990 trx_id: 161747347 tstamp: 25421276853342277; state: seqnos (l: 39965, g: 14756661, s: 14716715, d: 14651180) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 2 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2524402 trx_id: 161750798 tstamp: 25421276853506117; state: seqnos (l: 39966, g: 14756662, s: 14716719, d: 14651184) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 8 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2524136 trx_id: 161748618 tstamp: 25421276853625785; state: seqnos (l: 39967, g: 14756663, s: 14716722, d: 14651187) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 5 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2524526 trx_id: 161751899 tstamp: 25421276853745770; state: seqnos (l: 39968, g: 14756664, s: 14716722, d: 14651187) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 7 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2524099 trx_id: 161748330 tstamp: 25421276854345989; state: seqnos (l: 39969, g: 14756665, s: 14716724, d: 14651189) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 2 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2524124 trx_id: 161748455 tstamp: 25421276854630786; state: seqnos (l: 39970, g: 14756666, s: 14716724, d: 14651189) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 8 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2524351 trx_id: 161752023 tstamp: 25421276856927159; state: seqnos (l: 39971, g: 14756667, s: 14716728, d: 14651193) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 5 [Warning] WSREP: certification interval for trx source: 22efc2ab-e9f5-11ee-a5b1-639d184de0ad version: 5 local: 0 flags: 65 conn_id: 2524022 trx_id: 161747605 tstamp: 25421276869121017; state: seqnos (l: 39972, g: 14756668, s: 14716728, d: 14651193) WS pa_range: 65535; state history: REPLICATING:0->CERTIFYING:3228 exceeds the limit of 16384 2024-05-10 19:07:35 0 [Note] WSREP: Member 1.0 (EMADRDB01) synced with group. 2024-05-10 19:07:35 0 [Note] WSREP: Processing event queue:...100.0% (39984/39984 events) complete. 2024-05-10 19:07:35 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 14756737) 2024-05-10 19:07:35 5 [Note] WSREP: Server EMADRDB01 synced with group 2024-05-10 19:07:35 5 [Note] WSREP: Server status change joined -> synced 2024-05-10 19:07:35 5 [Note] WSREP: Synchronized with group, ready for connections 2024-05-10 19:07:35 5 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-05-10 19:10:09 11 [Warning] IP address '192.168.250.3' could not be resolved: Name or service not known