[MDEV-18250] [Draft] Server crashed in dirname_length / innobase_basename / sync_arr_fill_sys_semphore_waits_table - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Cannot Reproduce
Affects Version/s: 10.3(EOL), 10.4(EOL)
Fix Version/s: N/A
Component/s: Server, Storage Engine - InnoDB
Labels:
- not-10.6

Description

http://buildbot.askmonty.org/buildbot/builders/qa-win-rel/builds/5683/steps/result_summary/logs/stdio

10.3 69290ce3ebe6290c4816905f38d408a0ebbaf4a0
mysqld.exe!strrchr()[strrchr.c:195]
mysqld.exe!dirname_length()[mf_dirname.c:28]
mysqld.exe!innobase_basename()[ha_innodb.cc:2234]
mysqld.exe!sync_arr_fill_sys_semphore_waits_table()[sync0arr.cc:1385]
mysqld.exe!get_schema_tables_result()[sql_show.cc:8802]
mysqld.exe!JOIN::exec_inner()[sql_select.cc:4002]
mysqld.exe!JOIN::exec()[sql_select.cc:3835]
mysqld.exe!mysql_select()[sql_select.cc:4241]
mysqld.exe!handle_select()[sql_select.cc:373]
mysqld.exe!execute_sqlcom_select()[sql_parse.cc:6548]
mysqld.exe!mysql_execute_command()[sql_parse.cc:3769]
mysqld.exe!mysql_parse()[sql_parse.cc:8097]
mysqld.exe!dispatch_command()[sql_parse.cc:1853]
mysqld.exe!do_command()[sql_parse.cc:1395]
mysqld.exe!threadpool_process_request()[threadpool_common.cc:358]
mysqld.exe!tp_callback()[threadpool_common.cc:186]
ntdll.dll!RtlFreeUnicodeString()
ntdll.dll!RtlFreeUnicodeString()
KERNEL32.DLL!BaseThreadInitThunk()
ntdll.dll!RtlUserThreadStart()

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x937f2fa90): SELECT * FROM INFORMATION_SCHEMA.`INNODB_SYS_SEMAPHORE_WAITS` AS table1 WHERE ( ( ( table1.`WAIT_TYPE` IN ( 8, 7, 3 ) AND table1.`FILE` > '2021-09-03 03:48:43.040178') OR table1.`LOCK_WORD` IN ( 7, 3, 1 )) OR table1.`WAIT_TIME` >= table1.`WAIT_TIME`) HAVING table1.`RESERVATION_MODE` = '1985-01-01 06:43:20.021406' IS NULL ORDER BY table1.`THREAD_ID` LIMIT 60 /* QNO 3107 CON_ID 21 */
Connection ID (thread ID): 21
Status: NOT_KILLED

dmp file is available, but exe/pdb are unfortunately not.
exception_analysis is attached.

github.com/elenst/rqg --branch=master 13b38fc3422c0a89a74ebde9856377be3b99df32

perl E:\buildbot\rqg/runall-new.pl --grammar=conf/runtime/performance_schema.yy --mysqld=--performance-schema --gendata-advanced --skip-gendata --no-mask --queries=100M --duration=350 --threads=6 --seed=1547467538 --views --vcols --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice,ExecuteAsSPTwice --redefine=conf/mariadb/general-workarounds.yy --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/xa.yy --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/sequences.yy --mysqld=--log_output=FILE --mysqld=--log-bin --mysqld=--log_bin_trust_function_creators=1 --mysqld=--loose-max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --engine=InnoDB --mysqld=--innodb-buffer-pool-size=256M --mtr-build-thread=140 --basedir1=D:\qa-win-rel\install --vardir1=E:\buildbot\vardirs\qa-win-rel\10.3-5683\optim-combo/current1_1

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

exception_analysis
2019-01-15 15:57
104 kB
Elena Stepanova
mysql.err
2019-01-15 15:55
6 kB
Elena Stepanova
mysql.log
2019-01-15 15:55
3.60 MB
Elena Stepanova
mysqld.dmp
2019-01-15 15:55
253 kB
Elena Stepanova

Issue Links

is caused by

MDEV-7109 Add support for INFORMATION_SCHEMA.INNODB_SEMAPHORE_WAITS

Closed

relates to

MDEV-21452 Use condition variables and normal mutexes instead of InnoDB os_event and mutex

Closed

Activity

Ascending order - Click to sort in descending order

Elena Stepanova added a comment - 2019-05-24 21:04 - edited

On 10.4:
https://travis-ci.org/elenst/travis-tests/jobs/535884880 [3451 2 3]

10.4 5d2619b
190524 19:47:39 [ERROR] mysqld got signal 11 ;

/home/travis/server/bin/mysqld(my_print_stacktrace+0x40)[0x55a0830c7383]
/home/travis/server/bin/mysqld(handle_fatal_signal+0x3ae)[0x55a0828f3cff]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f27a67c3390]
/home/travis/server/bin/mysqld(dirname_length+0x34)[0x55a08309e4c0]
/home/travis/server/bin/mysqld(+0xd4b8a6)[0x55a082b228a6]
/home/travis/server/bin/mysqld(+0xf2f72c)[0x55a082d0672c]
/home/travis/server/bin/mysqld(_Z24get_schema_tables_resultP4JOIN23enum_schema_table_state+0x3c7)[0x55a0826786c6]
mysys/mf_dirname.c:33(dirname_length)[0x55a08260d6ea]
handler/ha_innodb.cc:2232(innobase_basename(char const*))[0x55a08260cb76]
sync/sync0arr.cc:1385(sync_arr_fill_sys_semphore_waits_table(THD, TABLE_LIST, Item*))[0x55a0826bd04d]
sql/sql_show.cc:8880(get_schema_tables_result(JOIN*, enum_schema_table_state))[0x55a0826b7c34]
sql/sql_select.cc:4346(JOIN::exec_inner())[0x55a0825fe6fe]
sql/sql_select.cc:4173(JOIN::exec())[0x55a0825c7f51]
sql/sql_union.cc:1515(st_select_lex_unit::exec())[0x55a0825bd1d2]
sql/sql_union.cc:41(mysql_union(THD, LEX, select_result, st_select_lex_unit, unsigned long))[0x55a0825ea22d]
sql/sql_select.cc:402(handle_select(THD, LEX, select_result*, unsigned long))[0x55a0825e880a]
sql/sql_parse.cc:6605(execute_sqlcom_select(THD, TABLE_LIST))[0x55a0825e605e]
sql/sql_parse.cc:3884(mysql_execute_command(THD*))[0x55a0825e5bf7]
sql/sql_prepare.cc:4760(Prepared_statement::execute(String*, bool))[0x55a0825b6e83]
sql/sql_prepare.cc:4246(Prepared_statement::execute_loop(String, bool, unsigned char, unsigned char*))[0x55a0825b5b5d]
sql/sql_prepare.cc:3255(mysql_stmt_execute_common(THD, unsigned long, unsigned char, unsigned char*, unsigned long, bool, bool))[0x55a08272e903]
sql/sql_prepare.cc:3153(mysqld_stmt_execute(THD, char, unsigned int))[0x55a08272e641]
sql/sql_parse.cc:1753(dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool))[0x55a08305ec0d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f27a67b96ba]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f27a5a4a41d]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7f274816ca00): ( SELECT * FROM (INFORMATION_SCHEMA.`INNODB_SYS_SEMAPHORE_WAITS` AS table1 INNER JOIN test.`view_BB` AS table2 ON ( table2.`col_date_nokey` = table1.`READERS` ) ) ORDER BY table2.`col_date_key` LIMIT 175 /* QNO 3122 CON_ID 15 / ) INTERSECT ( SELECT FROM (INFORMATION_SCHEMA.`INNODB_SYS_SEMAPHORE_WAITS` AS table1 INNER JOIN test.`view_BB` AS table2 ON ( table2.`col_date_nokey` = table1.`READERS` ) ) ORDER BY table2.`col_date_key` LIMIT 0 /* QNO 3122 CON_ID 15 / ) / TRANSFORM_OUTCOME_EMPTY_RESULT / / QNO 3124 CON_ID 15 */
Connection ID (thread ID): 15
Status: NOT_KILLED
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on

elenst-jira-refs ca49dd1 Toolbox: 6cd775a

perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1558727190 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --filter=conf/mariadb/10.4-combo-filter.ff --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/modules/alter_table_columns.yy --redefine=conf/mariadb/sp.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/modules/admin.yy --redefine=conf/mariadb/modules/userstat.yy --redefine=conf/mariadb/modules/foreign_keys.yy -redefine=conf/mariadb/modules/locks.yy --redefine=conf/mariadb/modules/sql_mode.yy --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/sequences.yy --redefine=conf/mariadb/modules/locks-10.4-extra.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=30 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --grammar=conf/runtime/performance_schema.yy --mysqld=--performance-schema --ps-protocol --transformers=ExecuteAsIntersect,ExecuteAsExcept,ExecuteAsCTE,ExecuteAsExecuteImmediate,ExecuteAsDeleteReturning,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView

Elena Stepanova added a comment - 2019-05-24 21:04 - edited On 10.4: https://travis-ci.org/elenst/travis-tests/jobs/535884880 [3451 2 3] 10.4 5d2619b 190524 19:47:39 [ERROR] mysqld got signal 11 ; /home/travis/server/bin/mysqld(my_print_stacktrace+0x40)[0x55a0830c7383] /home/travis/server/bin/mysqld(handle_fatal_signal+0x3ae)[0x55a0828f3cff] /lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f27a67c3390] /home/travis/server/bin/mysqld(dirname_length+0x34)[0x55a08309e4c0] /home/travis/server/bin/mysqld(+0xd4b8a6)[0x55a082b228a6] /home/travis/server/bin/mysqld(+0xf2f72c)[0x55a082d0672c] /home/travis/server/bin/mysqld(_Z24get_schema_tables_resultP4JOIN23enum_schema_table_state+0x3c7)[0x55a0826786c6] mysys/mf_dirname.c:33(dirname_length)[0x55a08260d6ea] handler/ha_innodb.cc:2232(innobase_basename(char const*))[0x55a08260cb76] sync/sync0arr.cc:1385(sync_arr_fill_sys_semphore_waits_table(THD*, TABLE_LIST*, Item*))[0x55a0826bd04d] sql/sql_show.cc:8880(get_schema_tables_result(JOIN*, enum_schema_table_state))[0x55a0826b7c34] sql/sql_select.cc:4346(JOIN::exec_inner())[0x55a0825fe6fe] sql/sql_select.cc:4173(JOIN::exec())[0x55a0825c7f51] sql/sql_union.cc:1515(st_select_lex_unit::exec())[0x55a0825bd1d2] sql/sql_union.cc:41(mysql_union(THD*, LEX*, select_result*, st_select_lex_unit*, unsigned long))[0x55a0825ea22d] sql/sql_select.cc:402(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55a0825e880a] sql/sql_parse.cc:6605(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55a0825e605e] sql/sql_parse.cc:3884(mysql_execute_command(THD*))[0x55a0825e5bf7] sql/sql_prepare.cc:4760(Prepared_statement::execute(String*, bool))[0x55a0825b6e83] sql/sql_prepare.cc:4246(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x55a0825b5b5d] sql/sql_prepare.cc:3255(mysql_stmt_execute_common(THD*, unsigned long, unsigned char*, unsigned char*, unsigned long, bool, bool))[0x55a08272e903] sql/sql_prepare.cc:3153(mysqld_stmt_execute(THD*, char*, unsigned int))[0x55a08272e641] sql/sql_parse.cc:1753(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55a08305ec0d] /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f27a67b96ba] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f27a5a4a41d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f274816ca00): ( SELECT * FROM (INFORMATION_SCHEMA.`INNODB_SYS_SEMAPHORE_WAITS` AS table1 INNER JOIN test.`view_BB` AS table2 ON ( table2.`col_date_nokey` = table1.`READERS` ) ) ORDER BY table2.`col_date_key` LIMIT 175 /* QNO 3122 CON_ID 15 */ ) INTERSECT ( SELECT * FROM (INFORMATION_SCHEMA.`INNODB_SYS_SEMAPHORE_WAITS` AS table1 INNER JOIN test.`view_BB` AS table2 ON ( table2.`col_date_nokey` = table1.`READERS` ) ) ORDER BY table2.`col_date_key` LIMIT 0 /* QNO 3122 CON_ID 15 */ ) /* TRANSFORM_OUTCOME_EMPTY_RESULT */ /* QNO 3124 CON_ID 15 */ Connection ID (thread ID): 15 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on elenst-jira-refs ca49dd1 Toolbox: 6cd775a perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1558727190 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --filter=conf/mariadb/10.4-combo-filter.ff --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/modules/alter_table_columns.yy --redefine=conf/mariadb/sp.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/modules/admin.yy --redefine=conf/mariadb/modules/userstat.yy --redefine=conf/mariadb/modules/foreign_keys.yy -redefine=conf/mariadb/modules/locks.yy --redefine=conf/mariadb/modules/sql_mode.yy --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/sequences.yy --redefine=conf/mariadb/modules/locks-10.4-extra.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=30 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --grammar=conf/runtime/performance_schema.yy --mysqld=--performance-schema --ps-protocol --transformers=ExecuteAsIntersect,ExecuteAsExcept,ExecuteAsCTE,ExecuteAsExecuteImmediate,ExecuteAsDeleteReturning,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView

Marko Mäkelä added a comment - 2020-12-17 19:35

The view INFORMATION_SCHEMA.INNODB_SEMAPHORE_WAITS was removed as part of ~~MDEV-21452~~ in MariaDB Server 10.6.0.

Marko Mäkelä added a comment - 2020-12-17 19:35 The view INFORMATION_SCHEMA.INNODB_SEMAPHORE_WAITS was removed as part of MDEV-21452 in MariaDB Server 10.6.0.

MariaDB Server

[Draft] Server crashed in dirname_length / innobase_basename / sync_arr_fill_sys_semphore_waits_table

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates

Git Integration