[MCOL-1092] update and delete event_types are labeled with incorrect/garbled characters Created: 2017-12-10  Updated: 2023-10-26  Resolved: 2018-03-05

Status: Closed
Project: MariaDB ColumnStore
Component/s: ?
Affects Version/s: 1.1.2
Fix Version/s: 1.1.3

Type: Bug Priority: Major
Reporter: Dipti Joshi (Inactive) Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: None


 Description   

On MariaDB Master

MariaDB [test]> insert into t1 values (0,0);
Query OK, 1 row affected (0.04 sec)
 
MariaDB [test]> select * from t1;
+------+------+
| a    | b    |
+------+------+
|    0 |    0 |
+------+------+
1 row in set (0.00 sec)
 
MariaDB [test]> update t1 set b=1 where a = 0;
Query OK, 1 row affected (0.03 sec)
Rows matched: 1  Changed: 1  Warnings: 0
 
MariaDB [test]> select * from t1;
+------+------+
| a    | b    |
+------+------+
|    0 |    1 |
+------+------+
1 row in set (0.00 sec)
MariaDB [test]> insert into t1 values (0, 2);
Query OK, 1 row affected (0.03 sec)
MariaDB [test]> delete from t1 where b = 1;
Query OK, 1 row affected (0.03 sec)

On mxs_adapter machine

[root@eb9c5aaf87f8 /]# /usr/bin/mxs_adapter -ucdcuser -pcdc -hmaxscale -P4001 test t1
1 rows and 0 transactions inserted in 5.44538 seconds. GTID = 0-1-3
1 rows and 1 transactions inserted in 0.331933 seconds. GTID = 0-1-4
1 rows and 0 transactions inserted in 5.54281 seconds. GTID = 0-1-4
1 rows and 1 transactions inserted in 0.324007 seconds. GTID = 0-1-5
1 rows and 1 transactions inserted in 0.493277 seconds. GTID = 0-1-6

on MariaDB ColumnStore

MariaDB [test]> select * from t1;
+------+------+--------+--------------+------------+----------+-----------+------------+
| a    | b    | domain | event_number | event_type | sequence | server_id | timestamp  |
+------+------+--------+--------------+------------+----------+-----------+------------+
|    0 |    0 |      0 |            1 | insert     |        3 |         1 | 1512936904 |
|    0 |    0 |      0 |            1 | _CpNoTf_   |        4 |         1 | 1512937641 |
|    0 |    1 |      0 |            2 | _CpNoTf_   |        4 |         1 | 1512937641 |
|    0 |    2 |      0 |            1 | insert     |        5 |         1 | 1512937971 |
|    0 |    1 |      0 |            1 | NULL       |        6 |         1 | 1512938047 |
+------+------+--------+--------------+------------+----------+-----------+------------+
5 rows in set (0.03 sec)

Issue: Note the event_type for update event on MariaDB ColumnStore is showing as "CpNoTf"
Issue: Note the event_type for delete event on MariaDB ColumnStore is showing as "NULL"



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2017-12-10 ]

CpNoTf indicates a a possible data corruption in the dictionary column (or a bad token). This should never happen so there is likely a bug in the API. If markus makela can figure out what bad thing is being inserted in event_type I can figure out what bad thing is happening at the API level.

Comment by markus makela [ 2018-03-05 ]

Discussed this with LinuxJedi and came to the conclusion that this was an API error.

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