191007 8:30:49 [ERROR] Slave SQL: Column 9 of table 'plato_db.ch_newdata' cannot be converted from type 'datetime' to type 'enum('mobile','plato')', Internal MariaDB error code: 1677 191007 8:30:49 [Warning] WSREP: RBR event 69 Update_rows_v1 apply warning: 3, 18170887 191007 8:30:49 [Warning] WSREP: Failed to apply app buffer: seqno: 18170887, status: 1 at galera/src/trx_handle.cpp:apply():353 Retrying 2th time 191007 8:30:49 [ERROR] Slave SQL: Column 9 of table 'plato_db.ch_newdata' cannot be converted from type 'datetime' to type 'enum('mobile','plato')', Internal MariaDB error code: 1677 191007 8:30:49 [Warning] WSREP: RBR event 69 Update_rows_v1 apply warning: 3, 18170887 191007 8:30:49 [Warning] WSREP: Failed to apply app buffer: seqno: 18170887, status: 1 at galera/src/trx_handle.cpp:apply():353 Retrying 3th time 191007 8:30:49 [ERROR] Slave SQL: Column 9 of table 'plato_db.ch_newdata' cannot be converted from type 'datetime' to type 'enum('mobile','plato')', Internal MariaDB error code: 1677 191007 8:30:49 [Warning] WSREP: RBR event 69 Update_rows_v1 apply warning: 3, 18170887 191007 8:30:49 [Warning] WSREP: Failed to apply app buffer: seqno: 18170887, status: 1 at galera/src/trx_handle.cpp:apply():353 Retrying 4th time 191007 8:30:49 [ERROR] Slave SQL: Column 9 of table 'plato_db.ch_newdata' cannot be converted from type 'datetime' to type 'enum('mobile','plato')', Internal MariaDB error code: 1677 191007 8:30:49 [Warning] WSREP: RBR event 69 Update_rows_v1 apply warning: 3, 18170887 191007 8:30:49 [ERROR] WSREP: Failed to apply trx: source: 35b70612-6a00-11e9-991c-4e3fd08964ff version: 4 local: 0 state: APPLYING flags: 1 conn_id: 26317908 trx_id: 11124490860 seqnos (l: 1457211, g: 18170887, s: 18170884, d: 18170752, ts: 14086860886139882) 191007 8:30:49 [ERROR] WSREP: Failed to apply trx 18170887 4 times 191007 8:30:49 [ERROR] WSREP: Node consistency compromised, aborting... 191007 8:30:49 [Note] WSREP: Closing send monitor... 191007 8:30:49 [Note] WSREP: Closed send monitor. 191007 8:30:49 [Note] WSREP: gcomm: terminating thread 191007 8:30:49 [Note] WSREP: gcomm: joining thread 191007 8:30:49 [Note] WSREP: gcomm: closing backend 191007 8:30:49 [Note] WSREP: view(view_id(NON_PRIM,35b70612,44) memb { 5ddd2dad,0 } joined { } left { } partitioned { 35b70612,0 b585b0d7,0 }) 191007 8:30:49 [Note] WSREP: view((empty)) 191007 8:30:49 [Note] WSREP: gcomm: closed 191007 8:30:49 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 191007 8:30:49 [Note] WSREP: Flow-control interval: [16, 16] 191007 8:30:49 [Note] WSREP: Trying to continue unpaused monitor 191007 8:30:49 [Note] WSREP: Received NON-PRIMARY. 191007 8:30:49 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 18170887) 191007 8:30:49 [Note] WSREP: Received self-leave message. 191007 8:30:49 [Note] WSREP: Flow-control interval: [0, 0] 191007 8:30:49 [Note] WSREP: Trying to continue unpaused monitor 191007 8:30:49 [Note] WSREP: Received SELF-LEAVE. Closing connection. 191007 8:30:49 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 18170887) 191007 8:30:49 [Note] WSREP: RECV thread exiting 0: Success 191007 8:30:49 [Note] WSREP: recv_thread() joined. 191007 8:30:49 [Note] WSREP: Closing replication queue. 191007 8:30:49 [Note] WSREP: Closing slave action queue. 191007 8:30:49 [Note] WSREP: /usr/sbin/mysqld: Terminated. 191007 08:30:49 mysqld_safe Number of processes running now: 0 191007 08:30:49 mysqld_safe WSREP: not restarting wsrep node automatically 191007 08:30:49 mysqld_safe mysqld from pid file /var/lib/mysql/ip-172-31-21-2.ap-south-1.compute.internal.pid ended 191007 08:39:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 191007 08:39:47 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.5Ck9ED' --pid-file='/var/lib/mysql/ip-172-31-21-2.ap-south-1.compute.internal-recover.pid' 191007 8:39:47 [Note] /usr/sbin/mysqld (mysqld 10.0.38-MariaDB-wsrep) starting as process 17289 ... 191007 08:39:51 mysqld_safe WSREP: Recovered position d7d97fae-52b8-11e9-86bb-5611caffc126:18170886 191007 8:39:51 [Note] /usr/sbin/mysqld (mysqld 10.0.38-MariaDB-wsrep) starting as process 17334 ... 191007 8:39:51 [Note] WSREP: Read nil XID from storage engines, skipping position init 191007 8:39:51 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so' 191007 8:39:51 [Note] WSREP: wsrep_load(): Galera 25.3.25(r3836) by Codership Oy loaded successfully. 191007 8:39:51 [Note] WSREP: CRC-32C: using hardware acceleration. 191007 8:39:51 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 0 191007 8:39:51 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 172.31.21.2; 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 = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.recover = no; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = 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 = 0; gmcast.version = 0; pc.announce_timeout = PT3S; 191007 8:39:51 [Note] WSREP: GCache history reset: d7d97fae-52b8-11e9-86bb-5611caffc126:0 -> 00000000-0000-0000-0000-000000000000:-1 191007 8:39:51 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1 191007 8:39:51 [Note] WSREP: wsrep_sst_grab() 191007 8:39:51 [Note] WSREP: Start replication 191007 8:39:51 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 191007 8:39:51 [Note] WSREP: protonet asio version 0 191007 8:39:51 [Note] WSREP: Using CRC-32C for message checksums. 191007 8:39:51 [Note] WSREP: backend: asio 191007 8:39:51 [Note] WSREP: gcomm thread scheduling priority set to other:0 191007 8:39:51 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory) 191007 8:39:51 [Note] WSREP: restore pc from disk failed 191007 8:39:51 [Note] WSREP: GMCast version 0 191007 8:39:51 [Note] WSREP: (076a3c3e, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 191007 8:39:51 [Note] WSREP: (076a3c3e, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 191007 8:39:51 [Note] WSREP: EVS version 0 191007 8:39:51 [Note] WSREP: gcomm: connecting to group 'galera_cluster', peer '172.31.19.249:,172.31.21.2:,172.31.23.67:' 191007 8:39:51 [Note] WSREP: (076a3c3e, 'tcp://0.0.0.0:4567') connection established to 076a3c3e tcp://172.31.21.2:4567 191007 8:39:51 [Warning] WSREP: (076a3c3e, 'tcp://0.0.0.0:4567') address 'tcp://172.31.21.2:4567' points to own listening address, blacklisting 191007 8:39:51 [Note] WSREP: (076a3c3e, 'tcp://0.0.0.0:4567') connection established to b585b0d7 tcp://172.31.23.67:4567 191007 8:39:51 [Note] WSREP: (076a3c3e, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 191007 8:39:52 [Note] WSREP: declaring b585b0d7 at tcp://172.31.23.67:4567 stable 191007 8:39:52 [Note] WSREP: Node b585b0d7 state prim 191007 8:39:52 [Note] WSREP: view(view_id(PRIM,076a3c3e,47) memb { 076a3c3e,0 b585b0d7,0 } joined { } left { } partitioned { }) 191007 8:39:52 [Note] WSREP: save pc into disk 191007 8:39:52 [Note] WSREP: discarding pending addr without UUID: tcp://172.31.19.249:4567 191007 8:39:52 [Note] WSREP: gcomm: connected 191007 8:39:52 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 191007 8:39:52 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 191007 8:39:52 [Note] WSREP: Opened channel 'galera_cluster' 191007 8:39:52 [Note] WSREP: Waiting for SST to complete. 191007 8:39:52 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 191007 8:39:52 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 0803103d-e8de-11e9-b91b-ba933c2075d3 191007 8:39:52 [Note] WSREP: STATE EXCHANGE: sent state msg: 0803103d-e8de-11e9-b91b-ba933c2075d3 191007 8:39:52 [Note] WSREP: STATE EXCHANGE: got state msg: 0803103d-e8de-11e9-b91b-ba933c2075d3 from 0 ( node2) 191007 8:39:52 [Note] WSREP: STATE EXCHANGE: got state msg: 0803103d-e8de-11e9-b91b-ba933c2075d3 from 1 (garb) 191007 8:39:52 [Note] WSREP: Quorum results: version = 4, component = PRIMARY, conf_id = 40, members = 1/2 (joined/total), act_id = 18170887, last_appl. = -1, protocols = 0/9/3 (gcs/repl/appl), group UUID = d7d97fae-52b8-11e9-86bb-5611caffc126 191007 8:39:52 [Note] WSREP: Flow-control interval: [23, 23] 191007 8:39:52 [Note] WSREP: Trying to continue unpaused monitor 191007 8:39:52 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 18170887) 191007 8:39:52 [Note] WSREP: State transfer required: Group state: d7d97fae-52b8-11e9-86bb-5611caffc126:18170887 Local state: 00000000-0000-0000-0000-000000000000:-1 191007 8:39:52 [Note] WSREP: New cluster view: global state: d7d97fae-52b8-11e9-86bb-5611caffc126:18170887, view# 41: Primary, number of nodes: 2, my index: 0, protocol version 3 191007 8:39:52 [Warning] WSREP: Gap in state sequence. Need state transfer. 191007 8:39:52 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '172.31.21.2' --datadir '/var/lib/mysql/' --parent '17334' '' ' 191007 8:39:52 [Note] WSREP: Prepared SST request: rsync|172.31.21.2:4444/rsync_sst 191007 8:39:52 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 191007 8:39:52 [Note] WSREP: REPL Protocols: 9 (4, 2) 191007 8:39:52 [Note] WSREP: Assign initial position for certification: 18170887, protocol version: 4 191007 8:39:52 [Note] WSREP: Service thread queue flushed. 191007 8:39:52 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (d7d97fae-52b8-11e9-86bb-5611caffc126): 1 (Operation not permitted) at galera/src/replicator_str.cpp:prepare_for_IST():482. IST will be unavailable. 191007 8:39:52 [Warning] WSREP: Member 0.0 ( node2) requested state transfer from '*any*', but it is impossible to select State Transfer donor: Resource temporarily unavailable 191007 8:39:52 [Note] WSREP: Requesting state transfer failed: -11(Resource temporarily unavailable). Will keep retrying every 1 second(s) 191007 8:39:53 [Warning] WSREP: Member 0.0 ( node2) requested state transfer from '*any*', but it is impossible to select State Transfer donor: Resource temporarily unavailable 191007 8:39:54 [Note] WSREP: (076a3c3e, 'tcp://0.0.0.0:4567') connection to peer 076a3c3e with addr tcp://172.31.21.2:4567 timed out, no messages seen in PT3S 191007 8:39:54 [Warning] WSREP: Member 0.0 ( node2) requested state transfer from '*any*', but it is impossible to select State Transfer donor: Resource temporarily unavailable 191007 8:39:55 [Note] WSREP: (076a3c3e, 'tcp://0.0.0.0:4567') turning message relay requesting off 191007 8:39:55 [Warning] WSREP: Member 0.0 ( node2) requested state transfer from '*any*', but it is impossible to select State Transfer donor: Resource temporarily unavailable 191007 8:39:56 [Warning] WSREP: Member 0.0 ( node2) requested state transfer from '*any*', but it is impossible to select State Transfer donor: Resource temporarily unavailable 191007 8:39:57 [Warning] WSREP: Member 0.0 ( node2) requested state transfer from '*any*', but it is impossible to select State Transfer donor: Resource temporarily unavailable 191007 8:39:58 [Warning] WSREP: Member 0.0 ( node2) requested state transfer from '*any*', but it is impossible to select State Transfer donor: Resource temporarily unavailable 191007 8:39:59 [Warning] WSREP: Member 0.0 ( node2) requested state transfer from '*any*', but it is impossible to select State Transfer donor: Resource temporarily unavailable 191007 8:40:00 [Warning] WSREP: Member 0.0 ( node2) requested state transfer from '*any*', but it is impossible to select State Transfer donor: Resource temporarily unavailable 191007 8:40:01 [Warning] WSREP: Member 0.0 ( node2) requested state transfer from '*any*', but it is impossible to select State Transfer donor: Resource temporarily unavailable 191007 8:40:02 [Warning] WSREP: Member 0.0 ( node2) requested state transfer from '*any*', but it is impossible to select State Transfer donor: Resource temporarily unavailable