Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
N/A
Description
It's still unclear which versions are affected. I was able to reproduce it on bb-main-atomic (MDEV-25292 branch, with the new behavior) and on its current baseline, 5ed3668890390060526434b92271756392d77869); but couldn't reproduce it on the main branch.
It is possible that the failure on the atomic CoR and on the baseline are different bugs, e.g. on the baseline it can be a variation of MDEV-38479, only without sequences involved.
For now, I will tentatively attribute it to atomic CREATE OR REPLACE, but it can change after the analysis.
|
bb-main-atomic 24da629079767d736ab50d9fcf7c45e31062540f |
mysqld: /data/bld/preview-12.3/bb-main-atomic-debug/sql/sql_error.cc:357: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed.
|
260116 11:21:41 [ERROR] /data/bld/preview-12.3/bb-main-atomic-debug/sql/mysqld got signal 6 ;
|
 |
#8 0x00007f7d54e45395 in __assert_fail_base (fmt=0x7f7d54fb9a90 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5555781b8b28 "!is_se
|
t() || (m_status == DA_OK_BULK && is_bulk_op())", file=file@entry=0x5555781b8988 "/data/bld/preview-12.3/bb-main-atomic-debug/sql/sql_error.cc", line=line@ent
|
ry=357, function=function@entry=0x5555781b8b60 "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at ./assert/assert.c:92
|
#9 0x00007f7d54e53eb2 in __GI___assert_fail (assertion=0x5555781b8b28 "!is_set() || (m_status == DA_OK_BULK && is_bulk_op())", file=0x5555781b8988 "/data/bld
|
/preview-12.3/bb-main-atomic-debug/sql/sql_error.cc", line=357, function=0x5555781b8b60 "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char
|
*)") at ./assert/assert.c:101
|
#10 0x000055557713e53d in Diagnostics_area::set_ok_status (this=0x7f7cf00071f0, affected_rows=0, last_insert_id=0, message=0x7f7d3c2a4b70 "Records: 0 Duplica
|
tes: 0 Warnings: 1") at /data/bld/preview-12.3/bb-main-atomic-debug/sql/sql_error.cc:357
|
#11 0x00005555770c9138 in my_ok (thd=0x7f7cf0000dc8, affected_rows_arg=0, id=0, message=0x7f7d3c2a4b70 "Records: 0 Duplicates: 0 Warnings: 1") at /data/bld/
|
preview-12.3/bb-main-atomic-debug/sql/sql_class.h:6345
|
#12 0x00005555771536e7 in select_insert::send_ok_packet (this=0x7f7cf0019048) at /data/bld/preview-12.3/bb-main-atomic-debug/sql/sql_insert.cc:4746
|
#13 0x0000555577156367 in select_create::send_eof (this=0x7f7cf0019048) at /data/bld/preview-12.3/bb-main-atomic-debug/sql/sql_insert.cc:5582
|
#14 0x0000555577246555 in return_zero_rows (join=0x7f7cf0019190, result=0x7f7cf0019048, tables=0x7f7cf00178b0, fields=0x7f7cf0017950, send_row=false, select_o
|
ptions=2201187781376, info=0x5555781e4390 "no matching row in const table", having=0x0, all_fields=0x7f7cf0019538) at /data/bld/preview-12.3/bb-main-atomic-de
|
bug/sql/sql_select.cc:17951
|
#15 0x0000555577222366 in JOIN::exec_inner (this=0x7f7cf0019190) at /data/bld/preview-12.3/bb-main-atomic-debug/sql/sql_select.cc:5060
|
#16 0x00005555772218d8 in JOIN::exec (this=0x7f7cf0019190) at /data/bld/preview-12.3/bb-main-atomic-debug/sql/sql_select.cc:4923
|
#17 0x0000555577223297 in mysql_select (thd=0x7f7cf0000dc8, tables=0x7f7cf0017da0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_par
|
am=0x0, select_options=2201187781376, result=0x7f7cf0019048, unit=0x7f7cf00053e8, select_lex=0x7f7cf0017698) at /data/bld/preview-12.3/bb-main-atomic-debug/sq
|
l/sql_select.cc:5451
|
#18 0x0000555577210d4a in handle_select (thd=0x7f7cf0000dc8, lex=0x7f7cf0005308, result=0x7f7cf0019048, setup_tables_done_option=0) at /data/bld/preview-12.3/
|
bb-main-atomic-debug/sql/sql_select.cc:637
|
#19 0x000055557730167f in Sql_cmd_create_table_like::execute (this=0x7f7cf0016e80, thd=0x7f7cf0000dc8) at /data/bld/preview-12.3/bb-main-atomic-debug/sql/sql_
|
table.cc:14074
|
#20 0x00005555771b0ecc in mysql_execute_command (thd=0x7f7cf0000dc8, is_called_from_prepared_stmt=false) at /data/bld/preview-12.3/bb-main-atomic-debug/sql/sq
|
l_parse.cc:5861
|
#21 0x00005555771b7297 in mysql_parse (thd=0x7f7cf0000dc8, rawbuf=0x7f7cf0016d10 "/* WRK-3 QNO 3614 */ CREATE OR REPLACE TABLE `CreateOrReplaceTable` AS SELE
|
CT * FROM `advanced_db`.`CreateOrReplaceTable3991313` LIMIT 9", length=137, parser_state=0x7f7d3c2a62c0) at /data/bld/preview-12.3/bb-main-atomic-debug/sql/sq
|
l_parse.cc:7895
|
#22 0x00005555771a3341 in dispatch_command (command=COM_QUERY, thd=0x7f7cf0000dc8, packet=0x7f7cf000c0e9 "/* WRK-3 QNO 3614 */ CREATE OR REPLACE TABLE `Creat
|
eOrReplaceTable` AS SELECT * FROM `advanced_db`.`CreateOrReplaceTable3991313` LIMIT 9", packet_length=137, blocking=true) at /data/bld/preview-12.3/bb-main-at
|
omic-debug/sql/sql_parse.cc:1878
|
#23 0x00005555771a1c9a in do_command (thd=0x7f7cf0000dc8, blocking=true) at /data/bld/preview-12.3/bb-main-atomic-debug/sql/sql_parse.cc:1417
|
#24 0x00005555773b6c31 in do_handle_one_connection (connect=0x555593fe27d8, put_in_cache=true) at /data/bld/preview-12.3/bb-main-atomic-debug/sql/sql_connect.
|
cc:1503
|
#25 0x00005555773b69b2 in handle_one_connection (arg=0x555593fe27d8) at /data/bld/preview-12.3/bb-main-atomic-debug/sql/sql_connect.cc:1415
|
#26 0x00005555779962ae in pfs_spawn_thread (arg=0x555593fe28b8) at /data/bld/preview-12.3/bb-main-atomic-debug/storage/perfschema/pfs.cc:2198
|
#27 0x00007f7d54ea81c4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#28 0x00007f7d54f2885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
rr profile will be provided.