Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.10(EOL)
Description
--source include/have_partition.inc
|
|
--let $restart_parameters= --plugin-load-add=ha_spider
|
--source include/restart_mysqld.inc
|
|
CREATE TABLE t (a INT) PARTITION BY HASH (a) PARTITIONS 2; |
ALTER TABLE t REBUILD PARTITION p0; |
10.10 d5e15424 |
mariadbd: /data/src/10.10/sql/ddl_log.cc:879: bool ddl_log_increment_phase_no_lock(uint): Assertion `0' failed.
|
231020 21:18:28 [ERROR] mysqld got signal 6 ;
|
|
#9 0x00007f5efb253df2 in __GI___assert_fail (assertion=0x558eb0416c20 "0", file=0x558eb0416160 "/data/src/10.10/sql/ddl_log.cc", line=879, function=0x558eb0417160 "bool ddl_log_increment_phase_no_lock(uint)") at ./assert/assert.c:101
|
#10 0x0000558eae6123fa in ddl_log_increment_phase_no_lock (entry_pos=1) at /data/src/10.10/sql/ddl_log.cc:879
|
#11 0x0000558eae61d1ab in ddl_log_increment_phase (entry_pos=1) at /data/src/10.10/sql/ddl_log.cc:2594
|
#12 0x0000558eaf2f5477 in ha_partition::rename_partitions (this=0x61d0004c36b8, path=0x7f5ee7b869d0 "./test/t") at /data/src/10.10/sql/ha_partition.cc:1183
|
#13 0x0000558eaebb9c13 in handler::ha_rename_partitions (this=0x61d0004c36b8, path=0x7f5ee7b869d0 "./test/t") at /data/src/10.10/sql/handler.cc:5608
|
#14 0x0000558eae311174 in mysql_rename_partitions (lpt=0x7f5ee7b86e60) at /data/src/10.10/sql/sql_partition.cc:6204
|
#15 0x0000558eae31cf03 in fast_alter_partition_table (thd=0x62c000210218, table=0x619000232d98, alter_info=0x7f5ee7b89f70, alter_ctx=0x7f5ee7b890f0, create_info=0x7f5ee7b8a120, table_list=0x629000316358) at /data/src/10.10/sql/sql_partition.cc:7863
|
#16 0x0000558eae5b7143 in mysql_alter_table (thd=0x62c000210218, new_db=0x62c000214f70, new_name=0x62c0002153c0, create_info=0x7f5ee7b8a120, table_list=0x629000316358, recreate_info=0x7f5ee7b89ed0, alter_info=0x7f5ee7b89f70, order_num=0, order=0x0, ignore=false, if_exists=false) at /data/src/10.10/sql/sql_table.cc:10596
|
#17 0x0000558eae77f19d in Sql_cmd_alter_table::execute (this=0x629000316aa8, thd=0x62c000210218) at /data/src/10.10/sql/sql_alter.cc:685
|
#18 0x0000558eae2ca4fd in mysql_execute_command (thd=0x62c000210218, is_called_from_prepared_stmt=false) at /data/src/10.10/sql/sql_parse.cc:6026
|
#19 0x0000558eae2d7898 in mysql_parse (thd=0x62c000210218, rawbuf=0x629000316238 "ALTER TABLE t REBUILD PARTITION p0", length=34, parser_state=0x7f5ee7b8b9f0) at /data/src/10.10/sql/sql_parse.cc:8054
|
#20 0x0000558eae2ad4f9 in dispatch_command (command=COM_QUERY, thd=0x62c000210218, packet=0x62900030c219 "ALTER TABLE t REBUILD PARTITION p0", packet_length=34, blocking=true) at /data/src/10.10/sql/sql_parse.cc:1894
|
#21 0x0000558eae2aa24a in do_command (thd=0x62c000210218, blocking=true) at /data/src/10.10/sql/sql_parse.cc:1407
|
#22 0x0000558eae7603ea in do_handle_one_connection (connect=0x608000007138, put_in_cache=true) at /data/src/10.10/sql/sql_connect.cc:1416
|
#23 0x0000558eae75fdab in handle_one_connection (arg=0x608000007138) at /data/src/10.10/sql/sql_connect.cc:1318
|
#24 0x0000558eaf358c14 in pfs_spawn_thread (arg=0x617000036818) at /data/src/10.10/storage/perfschema/pfs.cc:2201
|
#25 0x00007f5efb2a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#26 0x00007f5efb3285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
The failure started happening after this commit in 10.10:
commit a60cf9c7ae4ae012443a6a91db4ee265fa6e4403
|
Author: Yuchen Pei
|
Date: Thu Oct 5 16:19:10 2023 +1100
|
|
MDEV-22979 MDEV-27233 MDEV-28218 Fixing spider init bugs
|
Attachments
Issue Links
- is caused by
-
MDEV-22979 "mysqld --bootstrap" / mysql_install_db hangs when Spider is installed
- Closed
- relates to
-
MDEV-32559 Move alter table statements in spider init queries to be executed in the signal_ddl_recovery_done callback
- Closed