Todd Stoffel (Inactive) added a comment - 2021-01-27 21:03 The temporary workaround is to SET [SESSION] sql_log_bin = 0 ; before doing: INSERT INTO columnstore_table_2 SELECT * FROM columstore_table_1;

Alexander Barkov added a comment - 2021-02-02 13:45 - edited select_handler::execute() got stuck in the following loop: │ >142 while (!(err= next_row())) │ │ 143 { │ │ 144 if (thd->check_killed() || send_data()) │ │ 145 { │ │ 146 end_scan(); │ │ 147 DBUG_RETURN(-1); │ │ 148 } │ │ 149 } This patch seems to fix the problem: diff --git a/dbcon/mysql/ha_mcs_impl.cpp b/dbcon/mysql/ha_mcs_impl.cpp index 622636cc..6fca51a0 100644 --- a/dbcon/mysql/ha_mcs_impl.cpp +++ b/dbcon/mysql/ha_mcs_impl.cpp @@ -5407,7 +5407,7 @@ int ha_mcs_impl_select_next(uchar* buf, TABLE* table) thd->lex->sql_command == SQLCOM_DELETE_MULTI || thd->lex->sql_command == SQLCOM_TRUNCATE || thd->lex->sql_command == SQLCOM_LOAD)) - return 0; + return HA_ERR_END_OF_FILE; if (((thd->lex)->sql_command == SQLCOM_UPDATE) || ((thd->lex)->sql_command == SQLCOM_DELETE) || ((thd->lex)->sql_command == SQLCOM_DELETE_MULTI) || ((thd->lex)->sql_command == SQLCOM_UPDATE_MULTI))

Gagan Goel (Inactive) added a comment - 2021-02-04 07:46 For QA: Set up a 2-node CS cluster, with 1 master and 1 slave, with shared storage (dbroots) between the nodes. Instructions to set up replication: https://mariadb.com/kb/en/setting-up-replication/ Set columnstore_replication_slave=OFF(default), binlog_format=MIXED (default) in the .cnf files for both master and slave. Run the following commands on master: CREATE TABLE cs1 (a INT )engine=columnstore; -- the DDL will be replicated on the slave. Verify this by running SELECT * FROM cs1; on the slave node. INSERT INTO cs1 VALUES (123); INSERT INTO cs1 SELECT * FROM cs1; Now run show slave status; . Observe the value of Seconds_Behind_Master field. You will notice this value will keep on increasing indefinitely. Run show processlist; , and observe the value of Slave_SQL command. This will stay in the Executing state. Any subsequent queries performed on the slave node will not respond. With the fix, run the above SQL queries again, and you will notice show slave status; and show processlist; outputs showing the slave is caught up with the master, and subsequent queries on the slave will now execute as expected.

Daniel Lee (Inactive) added a comment - 2021-02-19 22:49 Build verified: 5.5.2 (Drone #1685) Reproduced the issue in 5.5.1 setting up a 2-node cluster described in the last comment. Observed the issue that Seconds_Behind_Master value keeps increasing (from 142 to 497), and "show process" show Slave_SQL stays in Executing state. But rows inserted in the master did get replicated to the slave. MariaDB [mytest] > show slave status\G 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: s1pm1 Master_User: replication_user Master_Port: 3306 Connect_Retry: 10 Master_Log_File: master1-bin.000001 Read_Master_Log_Pos: 1404 Relay_Log_File: centos-8-relay-bin.000002 Relay_Log_Pos: 924 Relay_Master_Log_File: master1-bin.000001 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 1185 Relay_Log_Space: 1455 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 142 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: No Gtid_IO_Pos: Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Executing Slave_DDL_Groups: 1 Slave_Non_Transactional_Groups: 0 Slave_Transactional_Groups: 2 1 row in set (0.000 sec) MariaDB [mytest] > show slave status\G 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: s1pm1 Master_User: replication_user Master_Port: 3306 Connect_Retry: 10 Master_Log_File: master1-bin.000001 Read_Master_Log_Pos: 2056 Relay_Log_File: centos-8-relay-bin.000002 Relay_Log_Pos: 924 Relay_Master_Log_File: master1-bin.000001 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 1185 Relay_Log_Space: 2107 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 497 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: No Gtid_IO_Pos: Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Executing Slave_DDL_Groups: 1 Slave_Non_Transactional_Groups: 0 Slave_Transactional_Groups: 2 1 row in set (0.000 sec) MariaDB [mytest] > show processlist; --- ----------- -------------- ------ --------- ---- -------------------------------- --------------------------------- --------- Id User Host db Command Time State Info Progress --- ----------- -------------- ------ --------- ---- -------------------------------- --------------------------------- --------- 4 mxs maxscale:46084 NULL Sleep 0   NULL 0.000 11 root localhost mytest Query 0 starting show processlist 0.000 12 system user   NULL Slave_IO 300 Waiting for master to send event NULL 0.000 13 system user   mytest Slave_SQL 108 Executing INSERT INTO cs1 SELECT * FROM cs1 0.000 --- ----------- -------------- ------ --------- ---- -------------------------------- --------------------------------- --------- 4 rows in set (0.000 sec) With 5.5.2 MariaDB [mytest] > show slave status \G 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: s2pm1 Master_User: replication_user Master_Port: 3306 Connect_Retry: 10 Master_Log_File: master1-bin.000001 Read_Master_Log_Pos: 1135 Relay_Log_File: centos-8-relay-bin.000002 Relay_Log_Pos: 1362 Relay_Master_Log_File: master1-bin.000001 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 1135 Relay_Log_Space: 1674 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: No Gtid_IO_Pos: Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 1 Slave_Non_Transactional_Groups: 0 Slave_Transactional_Groups: 3 1 row in set (0.000 sec) MariaDB [mytest] > show processlist; --- ----------- --------- ------ --------- ---- ------------------------------------------------------ ---------------- --------- Id User Host db Command Time State Info Progress --- ----------- --------- ------ --------- ---- ------------------------------------------------------ ---------------- --------- 8 root localhost mytest Query 0 starting show processlist 0.000 9 system user   NULL Slave_IO 123 Waiting for master to send event NULL 0.000 10 system user   NULL Slave_SQL 20 Slave has read all relay log; waiting for more updates NULL 0.000 --- ----------- --------- ------ --------- ---- ------------------------------------------------------ ---------------- --------- 3 rows in set (0.000 sec)