Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.6.5
Description
origin/10.6 4690442411b75ea0fc1a6aacabe767d6fb1d1f62 2021-09-02T17:17:18+03:00
|
|
# 2021-09-03T15:40:52 [2887877] | [rr 2891843 1869221]2021-09-03 15:15:44 0x150317ab3700[rr 2891843 1869224] InnoDB: Assertion failure in file /data/Server/10.6A/storage/innobase/dict/dict0load.cc line 2126
|
# 2021-09-03T15:40:52 [2887877] | [rr 2891843 1869226]InnoDB: Failing assertion: DICT_TF_HAS_DATA_DIR(table->flags)
|
...
|
Query (0x62b000173238): CREATE OR REPLACE TABLE F LIKE `t3`
|
# 2021-09-03T15:40:52 [2887877] | Connection ID (thread ID): 23
|
# 2021-09-03T15:40:52 [2887877] | [rr 2891843 1899510]Status: KILL_TIMEOUT
|
|
pluto:/data/Results/1630674257/TBR-1165/dev/shm/vardir/1630674257/117/1/rr
|
(rr) bt
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#1 0x00007f7b9ef94859 in __GI_abort () at abort.c:79
|
#2 0x0000558dd7ef98b9 in ut_dbg_assertion_failed (expr=0x558dd912ca80 "DICT_TF_HAS_DATA_DIR(table->flags)", file=0x558dd9129e00 "/data/Server/10.6A/storage/innobase/dict/dict0load.cc", line=2126)
|
at /data/Server/10.6A/storage/innobase/ut/ut0dbg.cc:60
|
#3 0x0000558dd8077fad in dict_save_data_dir_path (table=0x6180000e1908, filepath=0x60200002a1f0 "./test/t3.ibd") at /data/Server/10.6A/storage/innobase/dict/dict0load.cc:2126
|
#4 0x0000558dd807858c in dict_get_and_save_data_dir_path (table=0x6180000e1908, dict_locked=false) at /data/Server/10.6A/storage/innobase/dict/dict0load.cc:2163
|
#5 0x0000558dd7a25577 in ha_innobase::update_create_info (this=0x61d000983ab8, create_info=0x150317aaf240) at /data/Server/10.6A/storage/innobase/handler/ha_innodb.cc:11378
|
#6 0x0000558dd6bbd4b3 in mysql_prepare_alter_table (thd=0x62b00016c218, table=0x619003314e98, create_info=0x150317aaf240, alter_info=0x150317aaf110, alter_ctx=0x150317aaf510) at /data/Server/10.6A/sql/sql_table.cc:8555
|
#7 0x0000558dd6ba528b in mysql_create_like_table (thd=0x62b00016c218, table=0x62b0001733b8, src_table=0x62b000173b10, create_info=0x150317ab0d20) at /data/Server/10.6A/sql/sql_table.cc:5121
|
#8 0x0000558dd6bd2b67 in Sql_cmd_create_table_like::execute (this=0x62b000173330, thd=0x62b00016c218) at /data/Server/10.6A/sql/sql_table.cc:11753
|
#9 0x0000558dd6959942 in mysql_execute_command (thd=0x62b00016c218, is_called_from_prepared_stmt=false) at /data/Server/10.6A/sql/sql_parse.cc:5997
|
#10 0x0000558dd6965e14 in mysql_parse (thd=0x62b00016c218, rawbuf=0x62b000173238 "CREATE OR REPLACE TABLE F LIKE `t3` /* E_R Thread10 QNO 15 CON_ID 23 */", length=71, parser_state=0x150317ab1b20) at /data/Server/10.6A/sql/sql_parse.cc:8030
|
#11 0x0000558dd693e07f in dispatch_command (command=COM_QUERY, thd=0x62b00016c218, packet=0x6290002d0219 "CREATE OR REPLACE TABLE F LIKE `t3` /* E_R Thread10 QNO 15 CON_ID 23 */ ", packet_length=72, blocking=true)
|
at /data/Server/10.6A/sql/sql_parse.cc:1896
|
#12 0x0000558dd693b457 in do_command (thd=0x62b00016c218, blocking=true) at /data/Server/10.6A/sql/sql_parse.cc:1404
|
#13 0x0000558dd6d3a81a in do_handle_one_connection (connect=0x608000003638, put_in_cache=true) at /data/Server/10.6A/sql/sql_connect.cc:1418
|
#14 0x0000558dd6d3a0a6 in handle_one_connection (arg=0x608000003638) at /data/Server/10.6A/sql/sql_connect.cc:1312
|
#15 0x0000648e56d41609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#16 0x00007f7b9f091293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
(rr) quit
|
|
RQG
|
===
|
git clone https://github.com/mleich1/rqg --branch experimental RQG
|
|
perl rqg.pl \
|
--grammar=conf/mariadb/innodb_compression_encryption.yy \
|
--gendata=conf/mariadb/innodb_compression_encryption.zz \
|
--max_gd_duration=1800 \
|
--mysqld=--loose-innodb_encryption_rotate_key_age=2 \
|
--mysqld=--loose-innodb_lock_schedule_algorithm=fcfs \
|
--mysqld=--loose-idle_write_transaction_timeout=0 \
|
--mysqld=--loose-idle_transaction_timeout=0 \
|
--mysqld=--loose-idle_readonly_transaction_timeout=0 \
|
--mysqld=--connect_timeout=60 \
|
--mysqld=--interactive_timeout=28800 \
|
--mysqld=--slave_net_timeout=60 \
|
--mysqld=--net_read_timeout=30 \
|
--mysqld=--net_write_timeout=60 \
|
--mysqld=--loose-table_lock_wait_timeout=50 \
|
--mysqld=--wait_timeout=28800 \
|
--mysqld=--lock-wait-timeout=86400 \
|
--mysqld=--innodb-lock-wait-timeout=50 \
|
--no-mask \
|
--queries=10000000 \
|
--seed=random \
|
--reporters=Backtrace \
|
--reporters=ErrorLog \
|
--reporters=Deadlock1 \
|
--validators=None \
|
--mysqld=--log_output=none \
|
--mysqld=--log_bin_trust_function_creators=1 \
|
--mysqld=--loose-debug_assert_on_not_freed_memory=0 \
|
--engine=InnoDB \
|
--restart_timeout=240 \
|
--mysqld=--plugin-load-add=file_key_management.so \
|
--mysqld=--loose-file-key-management-filename=$RQG_HOME/conf/mariadb/encryption_keys.txt \
|
--duration=300 \
|
--mysqld=--loose-innodb_fatal_semaphore_wait_threshold=300 \
|
--mysqld=--loose-innodb-sync-debug \
|
--mysqld=--innodb_stats_persistent=off \
|
--mysqld=--innodb_adaptive_hash_index=on \
|
--mysqld=--loose-innodb_evict_tables_on_commit_debug=off \
|
--mysqld=--loose-max-statement-time=30 \
|
--threads=33 \
|
--mysqld=--innodb-use-native-aio=0 \
|
--rr=Extended \
|
--rr_options=--chaos --wait \
|
--mysqld=--innodb_page_size=4K \
|
--mysqld=--innodb-buffer-pool-size=256M \
|
--no_mask \
|
--workdir=<local settings> \
|
--vardir=<local settings> \
|
--mtr-build-thread=<local settings> \
|
--basedir1=<local settings> \
|
--script_debug=_nix
|
|
Attachments
Issue Links
- is caused by
-
MDEV-24258 Merge dict_sys.mutex into dict_sys.latch
-
- Closed
-
- is duplicated by
-
MDEV-28305 Innodb assertion - DICT_TF_HAS_DATA_DIR(table->flags) (was: Falha ao tentar iniciar serviço)
-
- Closed
-
also with insert select from information_schema.tables
2021-10-21 12:06:31 0x7fe398155700 InnoDB: Assertion failure in file /10.6/storage/innobase/dict/dict0load.cc line 2139
InnoDB: Failing assertion: DICT_TF_HAS_DATA_DIR(table->flags)
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mariadbd startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
InnoDB: about forcing recovery.
211019 12:06:31 [ERROR] mysqld got signal 6 ;
linux/raise.c:51(__GI_raise)[0x7fe3c07317bb]
stdlib/abort.c:81(__GI_abort)[0x7fe3c071c535]
ut/ut0dbg.cc:60(_GLOBAL__sub_D_00099_0_ut0dbg.cc)[0x562c7e48712c]
dict/dict0load.cc:2141(dict_save_data_dir_path(dict_table_t*, char const*))[0x562c7e6067d5]
dict/dict0load.cc:2179(dict_get_and_save_data_dir_path(dict_table_t*, bool))[0x562c7e606e6a]
handler/ha_innodb.cc:11376(ha_innobase::update_create_info(HA_CREATE_INFO*))[0x562c7df8058f]
sql/sql_show.cc:5629(get_schema_tables_record(THD*, TABLE_LIST*, TABLE*, bool, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*))[0x562c7ce2bb99]
sql/sql_show.cc:4705(fill_schema_table_by_open(THD*, st_mem_root*, bool, TABLE*, st_schema_table*, st_mysql_const_lex_string*, st_mysql_const_lex_string*, Open_tables_backup*, bool))[0x562c7ce24101]
sql/sql_show.cc:5315(get_all_tables(THD*, TABLE_LIST*, Item*))[0x562c7ce27c17]
sql/sql_show.cc:8837(get_schema_tables_result(JOIN*, enum_schema_table_state))[0x562c7ce59e1d]
sql/sql_select.cc:4693(JOIN::exec_inner())[0x562c7cd2cabc]
sql/sql_select.cc:4516(JOIN::exec())[0x562c7cd2a8b4]
sql/sql_select.cc:4996(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x562c7cd2ec89]
sql/sql_select.cc:545(handle_select(THD*, LEX*, select_result*, unsigned long))[0x562c7ccff887]
sql/sql_parse.cc:4711(mysql_execute_command(THD*, bool))[0x562c7cc5ca76]
sql/sql_parse.cc:8030(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x562c7cc73742]
sql/sql_parse.cc:1898(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x562c7cc49e8c]
sql/sql_parse.cc:1404(do_command(THD*, bool))[0x562c7cc46b75]
sql/sql_connect.cc:1418(do_handle_one_connection(CONNECT*, bool))[0x562c7d097e64]
sql/sql_connect.cc:1314(handle_one_connection)[0x562c7d0976e9]
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x562c7dd6ed38]
nptl/pthread_create.c:487(start_thread)[0x7fe3c0be8fa3]
x86_64/clone.S:97(clone)[0x7fe3c07f34cf]
Query (0x62b0001812a8): insert t WITH cte1 AS ( SELECT TABLE_SCHEMA,TABLE_NAME,TABLE_TYPE,TABLE_ROWS,TABLE_COLLATION,TABLE_COMMENT FROM information_schema.tables WHERE TABLE_SCHEMA LIKE 'test%' ORDER BY 1,2 ) SELECT * FROM cte1