|
Reproducible sporadically (currently within 3-5 attempts on 10.11).
Needs simplification to avoid other failures, and then converting to MTR etc. Otherwise tends to fail with other, probably already known, issues.
|
randgen d831012c29cddf19e038345ae7d82fe78d927b4a
|
perl ./run.pl --compatibility=101199 --threads=4 --duration=250 --mysqld=--max-statement-time=25 --mysqld=--lock-wait-timeout=12 --mysqld=--innodb-lock-wait-timeout=10 --gendata=simple --gendata=conf/zz/oltp.zz --variator=OrderBy --variator=ExecuteAsInsertReturning --variator=Distinct --mysqld=--standard_compliant_cte=OFF --mysqld=--flush_time=3 --mysqld=--optimizer_extra_pruning_depth=62 --scenario=Standard --mysqld=--character-set-server=utf8 --mysqld=--collation-server=utf8_general_ci --engine=InnoDB --mysqld=--default-tmp-storage-engine=MyISAM --grammar=conf/yy/partition_by_list.yy --grammar=conf/yy/dbt3-joins.yy --gendata=data/dbt3/dbt3-s0.0001.dump --grammar=conf/yy/all_selects.yy:0.0001 --grammar=conf/yy/sequences.yy --grammar=conf/yy/optimizer_subquery_semijoin.yy --gendata=simple --grammar=conf/yy/alter_table.yy --grammar=conf/yy/foreign_keys.yy --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--aria_group_commit=soft --queries=1000000 --reporters=Backtrace,Deadlock,MemoryUsage,FeatureUsage --mysqld=--plugin-maturity=experimental --base-port=14000 --basedir=/data/bld/10.11-asan --vardir=/dev/shm/var2 --seed=1705014515 --trials=10 --output="table->s->db_options_in_use == part_table->s->db_options_in_use"
|
|
10.11 d0c80c211c1fe3370b68be540bb9113028c6746f
|
mysqld: /data/bld/10.11-asan/sql/sql_partition_admin.cc:270: bool compare_table_with_partition(THD*, TABLE*, TABLE*, partition_element*, uint): Assertion
|
`table->s->db_options_in_use == part_table->s->db_options_in_use' failed.
|
|
#9 0x00007fab9ce53e32 in __GI___assert_fail (assertion=0x55fd829a9180 "table->s->db_options_in_use == part_table->s->db_options_in_use", file=0x55fd829a8ce0 "/data/bld/10.11-asan/sql/sql_partition_admin.cc", line=270, function=0x55fd829a91e0 "bool compare_table_with_partition(THD*, TABLE*, TABLE*, partition_element*, uint)") at ./assert/assert.c:101
|
#10 0x000055fd80c2b2b6 in compare_table_with_partition (thd=0x62c000290218, table=0x619000380998, part_table=0x6190003f5c98, part_elem=0x61f0001da4b8, part_id=1) at /data/bld/10.11-asan/sql/sql_partition_admin.cc:270
|
#11 0x000055fd80c2e567 in Sql_cmd_alter_table_exchange_partition::exchange_partition (this=0x6290006a0368, thd=0x62c000290218, table_list=0x62900069f440, alter_info=0x7fab736d06c0) at /data/bld/10.11-asan/sql/sql_partition_admin.cc:683
|
#12 0x000055fd80c29d1c in Sql_cmd_alter_table_exchange_partition::execute (this=0x6290006a0368, thd=0x62c000290218) at /data/bld/10.11-asan/sql/sql_partition_admin.cc:111
|
#13 0x000055fd8078c28d in mysql_execute_command (thd=0x62c000290218, is_called_from_prepared_stmt=false) at /data/bld/10.11-asan/sql/sql_parse.cc:6075
|
#14 0x000055fd80799357 in mysql_parse (thd=0x62c000290218, rawbuf=0x62900069f238 "/* WRK-2 QNO 10212 */ ALTER TABLE `tlist_3_3` EXCHANGE PARTITION p1 WITH TABLE tp_exchange /* 110400 WITH VALIDATION */", length=120, parser_state=0x7fab736d19e0) at /data/bld/10.11-asan/sql/sql_parse.cc:8080
|
#15 0x000055fd8076efe9 in dispatch_command (command=COM_QUERY, thd=0x62c000290218, packet=0x6290006a9219 "/* WRK-2 QNO 10212 */ ALTER TABLE `tlist_3_3` EXCHANGE PARTITION p1 WITH TABLE tp_exchange /*!110400 WITH VALIDATION */", packet_length=120, blocking=true) at /data/bld/10.11-asan/sql/sql_parse.cc:1894
|
#16 0x000055fd8076bd16 in do_command (thd=0x62c000290218, blocking=true) at /data/bld/10.11-asan/sql/sql_parse.cc:1407
|
#17 0x000055fd80c26a87 in do_handle_one_connection (connect=0x608000002eb8, put_in_cache=true) at /data/bld/10.11-asan/sql/sql_connect.cc:1415
|
#18 0x000055fd80c26448 in handle_one_connection (arg=0x608000002eb8) at /data/bld/10.11-asan/sql/sql_connect.cc:1317
|
#19 0x000055fd81814fe6 in pfs_spawn_thread (arg=0x617000007b18) at /data/bld/10.11-asan/storage/perfschema/pfs.cc:2201
|
#20 0x00007fab9cea8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#21 0x00007fab9cf2861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|