[MCOL-5634] mysql5.7 innodb -> Columnstore is BUG Created: 2023-12-30  Updated: 2023-12-31

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major
Reporter: hiller1 Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

MariaDB 10.6.16



 Description   

When synchronizing the front-end MySQL 5.7 InnoDB database to MariaDB 10.6.16 Columnstore, an error occurred and MariaDB crashed.

mysql 5.7 :
update sbtest1 set pad='nba' where id=2;

-> repl to mariadb columnstore is crash
---------------------------------------------------------------------------
2023-12-30 22:35:11 5 [Note] Slave SQL thread initialized, starting replica
tion in log 'mysql-bin.000004' at position 546, relay log './dbbackup-192-168-176-204-relay-bin.000002' position: 6562023-12-30 22:35:11 4 [Note] Slave I/O thread: connected to master 'repl@19
2.168.198.239:6666',replication started in log 'mysql-bin.000004' at position 995terminate called after throwing an instance of 'std::logic_error'
what(): basic_string::_S_construct null not valid
231230 22:35:12 [ERROR] mysqld got signal 6 ;
Sorry, we probably made a mistake, and this is a bug.



 Comments   
Comment by hiller1 [ 2023-12-31 ]

2023-12-31 16:46:25 5 [Note] Master 'mysql57': Slave SQL thread initialized
, starting replication in log 'mysql-bin.000001' at position 701, relay log './dbbackup-192-168-176-204-relay-bin-mysql57.000002' position: 7902023-12-31 16:46:25 4 [Note] Master 'mysql57': Slave I/O thread: connected
to master 'repl@192.168.198.239:6666',replication started in log 'mysql-bin.000001' at position 1151terminate called after throwing an instance of 'std::logic_error'
what(): basic_string::_S_construct null not valid
231231 16:46:25 [ERROR] mysqld got signal 6 ;
Sorry, we probably made a mistake, and this is a bug.

Your assistance in bug reporting will enable us to fix this for the next re
lease.To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

Server version: 10.6.16-MariaDB-log source revision: b83c379420a8846ae4b287
68d3c81fa354cca056key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=1
max_threads=153
thread_count=3
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 46800
5 K bytes of memoryHope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x7ff3780012b8
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x7ff3b8e844e0 thread_stack 0x49000
/usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x55b23a68deae]
/usr/sbin/mariadbd(handle_fatal_signal+0x2f7)[0x55b23a0e2ac7]
sigaction.c:0(__restore_rt)[0x7ff3d3f90630]
/lib64/libc.so.6(gsignal+0x37)[0x7ff3d33db387]
/lib64/libc.so.6(abort+0x148)[0x7ff3d33dca78]
/lib64/libstdc++.so.6(ZN9gnu_cxx27_verbose_terminate_handlerEv+0x165)[0
x7ff3d3ad5a95]/lib64/libstdc++.so.6(+0x5ea06)[0x7ff3d3ad3a06]
/lib64/libstdc++.so.6(+0x5ea33)[0x7ff3d3ad3a33]
/lib64/libstdc++.so.6(+0x5ec53)[0x7ff3d3ad3c53]
/lib64/libstdc++.so.6(ZSt19_throw_logic_errorPKc+0x77)[0x7ff3d3b28857]
/lib64/libstdc++.so.6(_ZNSs12_S_constructIPKcEEPcT_S3_RKSaIcESt20forward_it
erator_tag+0xa1)[0x7ff3d3b345e1]/lib64/libstdc++.so.6(_ZNSsC2EPKcRKSaIcE+0x38)[0x7ff3d3b34998]
/usr/lib64/mysql/plugin/ha_columnstore.so(_ZN6ha_mcs13impl_rnd_initEP5TABLE
RKSt6vectorIP4ItemSaIS4_EE+0xb1a)[0x7ff3d0344dda]/usr/lib64/mysql/plugin/ha_columnstore.so(_ZN6ha_mcs8rnd_initEb+0x29)[0x7ff
3d032a6b9]/usr/sbin/mariadbd(_ZN7handler22ha_rnd_init_with_errorEb+0x17)[0x55b23a0eb6
17]/usr/sbin/mariadbd(_ZN14Rows_log_event8find_rowEP14rpl_group_info+0x5e6)[0x
55b23a208906]/usr/sbin/mariadbd(_ZN21Update_rows_log_event11do_exec_rowEP14rpl_group_inf
o+0x189)[0x55b23a208f99]/usr/sbin/mariadbd(_ZN14Rows_log_event14do_apply_eventEP14rpl_group_info+0x
39d)[0x55b23a1fd25d]/usr/sbin/mariadbd(+0x7109ff)[0x55b239dfb9ff]
/usr/sbin/mariadbd(handle_slave_sql+0x1a1f)[0x55b239e0612f]
/usr/sbin/mariadbd(+0xc466ac)[0x55b23a3316ac]
pthread_create.c:0(start_thread)[0x7ff3d3f88ea5]
/lib64/libc.so.6(clone+0x6d)[0x7ff3d34a3b0d]

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