Node crashes after alter change column error code 1677

15 views
Skip to first unread message

Michael Mittentag

unread,
Nov 15, 2016, 11:36:17 AM11/15/16
to codership
Hi,

I have a 5 node galera cluster running:

MariaDB-Galera-server-5.5.52-1
wsrep_provider_version  25.3.17(r3619)



I changed one node to use RSU, and then ran the following:

alter table tablename change column column varchar(300);


It completed with 2 warnings, but the node crashed with the following error after trying to resync with the cluster:

161115 10:58:26 [Warning] WSREP: Failed to apply app buffer: seqno: 1387274850, status: 1
         at galera/src/trx_handle.cpp:apply():351
Retrying 4th time
161115 10:58:26 [ERROR] Slave SQL: Column 2 of table 'db.tablename' cannot be converted from type 'varchar(450)' to type 'varchar(300)', Error_code: 1677
161115 10:58:26 [ERROR] WSREP: Failed to apply trx: source: 4ad90932-81ad-11e6-bc22-6fe9f39dea34 version: 3 local: 0 state: APPLYING flags: 129 conn_id: 85651270 trx_id: 10639522253 seqnos (l: 142588, g: 1387274850, s: 1387274849, d: 1387274849, ts: 4755577161515107)
161115 10:58:26 [ERROR] WSREP: Failed to apply trx 1387274850 4 times
161115 10:58:26 [ERROR] WSREP: Node consistency compromized, aborting...
161115 10:58:26 [Note] WSREP: Closing send monitor...
161115 10:58:26 [Note] WSREP: Closed send monitor.
161115 10:58:26 [Note] WSREP: gcomm: terminating thread
161115 10:58:26 [Note] WSREP: gcomm: joining thread
161115 10:58:26 [Note] WSREP: gcomm: closing backend
161115 10:58:26 [Note] WSREP: view(view_id(NON_PRIM,2bbd4b9f,139) memb {
        e75a4bbb,0
} joined {
} left {
} partitioned {
        2bbd4b9f,0
        4ad90932,0
        9029eda8,0
        ab96b578,0
})
161115 10:58:26 [Note] WSREP: view((empty))
161115 10:58:26 [Note] WSREP: gcomm: closed
161115 10:58:26 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
161115 10:58:26 [Note] WSREP: Flow-control interval: [16, 16]
161115 10:58:26 [Note] WSREP: Received NON-PRIMARY.
161115 10:58:26 [Note] WSREP: Shifting JOINED -> OPEN (TO: 1387331192)
161115 10:58:26 [Note] WSREP: Received self-leave message.
161115 10:58:26 [Note] WSREP: Flow-control interval: [0, 0]
161115 10:58:26 [Note] WSREP: Received SELF-LEAVE. Closing connection.
161115 10:58:26 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 1387331192)
161115 10:58:26 [Note] WSREP: RECV thread exiting 0: Success
161115 10:58:26 [Note] WSREP: recv_thread() joined.
161115 10:58:26 [Note] WSREP: Closing replication queue.
161115 10:58:26 [Note] WSREP: Closing slave action queue.
161115 10:58:26 [Note] WSREP: /usr/sbin/mysqld: Terminated.


What does not make sense is the column was never set to varchar(450) but was originally varchar(100)

 column_name                   | varchar(150)        | YES  | MUL | NULL              |       |



there is not one column with varchar(450) on that table? 


Thanks


Reply all
Reply to author
Forward
0 new messages