Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
10.6
-
None
-
Can result in hang or crash
Description
--source include/have_innodb.inc
|
|
|
SET DEFAULT_STORAGE_ENGINE=INNODB; |
CREATE SEQUENCE s MINVALUE 1 MAXVALUE 10 ; |
ALTER TABLE s SEQUENCE=0; |
INSERT INTO s VALUES (0,0,20,0,1,0,0,0); |
ALTER TABLE s SEQUENCE=1; |
Leads to:
|
CS 10.6.24 e80998281aa1551f12a6b86cb3765796130d822d (Optimized, Clang 18.1.3-11) Build 31/10/2025 |
Core was generated by `/test/MD311025-mariadb-10.6.24-linux-x86_64-opt/bin/mariadbd --no-defaults --ma'.
|
Program terminated with signal SIGSEGV, Segmentation fault.
|
#0 calc_row_difference (uvect=0x7dfeb805a790, old_row=0x7dfeb8056aa0 "\377\001", new_row=0x7dfeb8056a60 "\377", table=0x7dfeb8058b48, upd_buff=<optimized out>, buff_len=154, prebuilt=0x7dfeb8059a10, auto_inc=<optimized out>)at /test/10.6_opt/storage/innobase/handler/ha_innodb.cc:8441
|
|
|
[Current thread is 1 (LWP 143195)]
|
(gdb) bt
|
#0 calc_row_difference (uvect=0x7dfeb805a790, old_row=0x7dfeb8056aa0 "\377\001", new_row=0x7dfeb8056a60 "\377", table=0x7dfeb8058b48, upd_buff=<optimized out>, buff_len=154, prebuilt=0x7dfeb8059a10, auto_inc=<optimized out>)at /test/10.6_opt/storage/innobase/handler/ha_innodb.cc:8441
|
#1 ha_innobase::update_row (this=0x7dfeb8055d18, old_row=0x7dfeb8056aa0 "\377\001", new_row=0x7dfeb8056a60 "\377")at /test/10.6_opt/storage/innobase/handler/ha_innodb.cc:8618
|
#2 0x0000561574ad4c03 in handler::update_first_row (this=0x7dfeb8055d18, new_data=0x7dfeb8056a60 "\377") at /test/10.6_opt/sql/handler.cc:7907
|
#3 0x0000561574d734f1 in ha_sequence::write_row (this=0x7dfeb8056518, buf=0x7dfeb8056a60 "\377") at /test/10.6_opt/sql/ha_sequence.cc:296
|
#4 0x0000561574ad3f8b in handler::ha_write_row (this=0x7dfeb8056518, buf=0x7dfeb8056a60 "\377") at /test/10.6_opt/sql/handler.cc:7769
|
#5 0x000056157494571f in copy_data_between_tables (thd=thd@entry=0x7dfeb8000c68, from=from@entry=0x7dfeb801a698, to=to@entry=0x7dfeb8058b48, ignore=false, order_num=<optimized out>, order=<optimized out>, copied=0x7e19c807e258, deleted=0x7e19c807e260, alter_info=0x7e19c8080ab0, alter_ctx=0x7e19c807ec80)at /test/10.6_opt/sql/sql_table.cc:11739
|
#6 0x000056157493fc61 in mysql_alter_table (thd=thd@entry=0x7dfeb8000c68, new_db=new_db@entry=0x7dfeb8005740, new_name=new_name@entry=0x7dfeb8005bb0, create_info=create_info@entry=0x7e19c8080c20, table_list=0x7dfeb8010c90, recreate_info=recreate_info@entry=0x7e19c80803a0, alter_info=0x7e19c8080ab0, order_num=0, order=0x0, ignore=<optimized out>, if_exists=<optimized out>) at /test/10.6_opt/sql/sql_table.cc:11012
|
#7 0x00005615749ad693 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x7dfeb8000c68) at /test/10.6_opt/sql/sql_alter.cc:675
|
#8 0x0000561574899ec4 in mysql_execute_command (thd=thd@entry=0x7dfeb8000c68, is_called_from_prepared_stmt=false) at /test/10.6_opt/sql/sql_parse.cc:6167
|
#9 0x0000561574895811 in mysql_parse (thd=thd@entry=0x7dfeb8000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7e19c8081490)at /test/10.6_opt/sql/sql_parse.cc:8200
|
#10 0x0000561574893ccc in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7dfeb8000c68, packet=packet@entry=0x7dfeb8008639 "ALTER TABLE s SEQUENCE=1", packet_length=packet_length@entry=24, blocking=true)at /test/10.6_opt/sql/sql_parse.cc:1908
|
#11 0x0000561574895c21 in do_command (thd=thd@entry=0x7dfeb8000c68, blocking=true) at /test/10.6_opt/sql/sql_parse.cc:1421
|
#12 0x00005615749a73ad in do_handle_one_connection (connect=<optimized out>, connect@entry=0x56159f9c0c48, put_in_cache=true)at /test/10.6_opt/sql/sql_connect.cc:1386
|
#13 0x00005615749a7173 in handle_one_connection (arg=arg@entry=0x56159f9c0c48)at /test/10.6_opt/sql/sql_connect.cc:1298
|
#14 0x0000561574d1ed4e in pfs_spawn_thread (arg=0x56159f9ee2f8)at /test/10.6_opt/storage/perfschema/pfs.cc:2201
|
#15 0x00007e19ca09caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#16 0x00007e19ca129c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
|
Bug Detection Matrix |
Rel o/d Build Commit UniqueID observed
|
CS 10.6 dbg 311025 e80998281aa1551f12a6b86cb3765796130d822d SIGSEGV|calc_row_difference|ha_innobase::update_row|handler::update_first_row|ha_sequence::write_row
|
CS 10.6 opt 311025 e80998281aa1551f12a6b86cb3765796130d822d SIGSEGV|calc_row_difference|ha_innobase::update_row|handler::update_first_row|ha_sequence::write_row
|
CS 10.11 dbg 311025 654e8440b51b1b8da09b6f72de80ba50dc0c24f9 No bug found
|
CS 10.11 opt 311025 654e8440b51b1b8da09b6f72de80ba50dc0c24f9 No bug found
|
CS 11.4 dbg 311025 75ded7d03abb4de385f97ce7cf20622882b8df05 No bug found
|
CS 11.4 opt 311025 75ded7d03abb4de385f97ce7cf20622882b8df05 No bug found
|
CS 11.8 dbg 311025 6d0be016faba4179421a5b6b46ba0cfc21d0cf92 No bug found
|
CS 11.8 opt 311025 6d0be016faba4179421a5b6b46ba0cfc21d0cf92 No bug found
|
CS 12.1 dbg 311025 4af88ced488e78458f0febb55a0ae67783330029 No bug found
|
CS 12.1 opt 311025 4af88ced488e78458f0febb55a0ae67783330029 No bug found
|
CS 12.2 dbg 311025 049ee29e7e28c1c7c3c41638adc54efa2cb10c2a No bug found
|
CS 12.2 opt 311025 049ee29e7e28c1c7c3c41638adc54efa2cb10c2a No bug found
|
ES 10.5 dbg 040825 70586522eacf09d04d49962072e14325a75d8155 SIGSEGV|calc_row_difference|ha_innobase::update_row|handler::update_first_row|ha_sequence::write_row
|
ES 10.5 opt 040825 70586522eacf09d04d49962072e14325a75d8155 SIGSEGV|calc_row_difference|ha_innobase::update_row|handler::update_first_row|ha_sequence::write_row
|
ES 10.6 dbg 040825 9b794f34b48fb7eee490b6da44edc0f33a947447 SIGSEGV|calc_row_difference|ha_innobase::update_row|handler::update_first_row|ha_sequence::write_row
|
ES 10.6 opt 040825 9b794f34b48fb7eee490b6da44edc0f33a947447 SIGSEGV|calc_row_difference|ha_innobase::update_row|handler::update_first_row|ha_sequence::write_row
|
ES 11.4 dbg 040825 a1c03ccd54b582e75506687ee19b273ca897f261 !node->table->skip_alter_undo|SIGABRT|row_upd_clust_rec|row_upd_clust_step|row_upd|row_upd_step
|
ES 11.4 opt 040825 a1c03ccd54b582e75506687ee19b273ca897f261 No bug found
|
ES 11.8 dbg 151025 780565c207e9ce0ebf7d8e3d59f223801447b619 No bug found
|
ES 11.8 opt 151025 780565c207e9ce0ebf7d8e3d59f223801447b619 No bug found
|
ES 11.4 crashes similar to MDEV-24715
Attachments
Issue Links
- duplicates
-
MDEV-36032 Check when doing ALTER TABLE table_name sequence=1 that table can be a sequence
-
- Closed
-