[MCOL-3461] delete row not replicated with mxs_adapter Created: 2019-08-27  Updated: 2023-10-26  Resolved: 2020-03-29

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.2.5
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Kyle Joiner (Inactive) Assignee: markus makela
Resolution: Won't Fix Votes: 0
Labels: None


 Description   

The following shows the progression to re-produce this. Is this a bug or some expected behavior when not using the -z option?

MariaDB Server:
MariaDB [repl_examples]> create table z_error(a int(11), b int(11));
Query OK, 0 rows affected (0.006 sec)

MariaDB [repl_examples]> insert into z_error values(1,2),(3,4),(5,6),(7,8),(9,10);

MaxScale:
[root@usfit-scmsdev2 maxscale]# mxs_adapter -c /etc/ColumnStore.xml -u cdcuser -p cdc -h localhost -P 4001 -r 10000 -d -n -a -f tables.lst
2019-08-27 09:51:41 [main] Started thread 0x12522a0
2019-08-27 09:51:41 [main] Started 1 threads
2019-08-27 09:51:41 [repl_examples.z_error] Requesting data for table: repl_examples.z_error
2019-08-27 09:51:41 [repl_examples.z_error] Creating table: CREATE TABLE repl_examples.z_error (a int(11), b int(11)) ENGINE=ColumnStore;
2019-08-27 09:51:43 [repl_examples.z_error] Created table `repl_examples`.`z_error`
2019-08-27 09:51:43 [repl_examples.z_error] Requesting data for table: repl_examples.z_error
2019-08-27 09:51:43 [repl_examples.z_error] a: 1
2019-08-27 09:51:43 [repl_examples.z_error] b: 2
2019-08-27 09:51:43 [repl_examples.z_error] a: 3
2019-08-27 09:51:43 [repl_examples.z_error] b: 4
2019-08-27 09:51:43 [repl_examples.z_error] a: 5
2019-08-27 09:51:43 [repl_examples.z_error] b: 6
2019-08-27 09:51:43 [repl_examples.z_error] a: 7
2019-08-27 09:51:43 [repl_examples.z_error] b: 8
2019-08-27 09:51:43 [repl_examples.z_error] a: 9
2019-08-27 09:51:43 [repl_examples.z_error] b: 10
2019-08-27 09:51:53 [repl_examples.z_error] Flushing batch
2019-08-27 09:51:54 [repl_examples.z_error] 5 rows, 0 transactions inserted over 10.3971 seconds. GTID = 0-1-100:5

Columnstore:
MariaDB [repl_examples]> select * from z_error;
----------+

a b

----------+

1 2
3 4
5 6
7 8
9 10

----------+

MariaDB Server:
MariaDB [repl_examples]> delete from z_error where a=1;
Query OK, 1 row affected (0.002 sec)

Maxscale:
2019-08-27 09:53:03 [repl_examples.z_error] a: 1
2019-08-27 09:53:03 [repl_examples.z_error] b: 2
2019-08-27 09:53:04 [repl_examples.z_error] 1 rows, 0 transactions inserted over 0.239964 seconds. GTID = 0-1-101:1
2019-08-27 09:53:14 [repl_examples.z_error] Read timeout with empty batch, closing it
2019-08-27 09:53:25 [repl_examples.z_error] Read timeout
2019-08-27 09:53:35 [repl_examples.z_error] Read timeout

Columnstore:
MariaDB [repl_examples]> select * from z_error;
----------+

a b

----------+

1 2
3 4
5 6
7 8
9 10
1 2

----------+
6 rows in set (0.014 sec)

Server:
MariaDB [repl_examples]> select * from z_error;
----------+

a b

----------+

3 4
5 6
7 8
9 10

----------+

As you can see.. the deleted row from InnoDB was not deletd (because the option of -z was not specified), but it was re-inserted then into Columnstore.



 Comments   
Comment by Todd Stoffel (Inactive) [ 2020-03-29 ]

CDC adapter will be deprecated and phased out.

Generated at Thu Feb 08 02:42:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.