Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.2(EOL), 10.4(EOL)
Description
https://api.travis-ci.org/v3/job/356953121/log.txt
10.2 fc05777eac8defc15fd3cfa8ae55c7d2f2b8671a |
mysqld: /home/travis/src/storage/innobase/include/sync0rw.ic:82: ulint rw_lock_get_writer(const rw_lock_t*): Assertion `lock_word <= 0x20000000' failed.
|
180322 16:37:00 [ERROR] mysqld got signal 6 ;
|
 |
Query (0x7fb87401cdb8): /* GenTest::Transform::ExecuteAsUnion */ ( SELECT * FROM (INFORMATION_SCHEMA.`INNODB_METRICS` AS table1 INNER JOIN INFORMATION_SCHEMA.`INNODB_SYS_SEMAPHORE_WAITS` AS table2 ON ( table2.`LAST_READER_LINE` = table1.`MAX_COUNT_RESET` ) ) WHERE table2.`HOLDER_LINE` < 7 LIMIT 4 /* QNO 6777 CON_ID 18 */ ) UNION ALL ( SELECT * FROM (INFORMATION_SCHEMA.`INNODB_METRICS` AS table1 INNER JOIN INFORMATION_SCHEMA.`INNODB_SYS_SEMAPHORE_WAITS` AS table2 ON ( table2.`LAST_READER_LINE` = table1.`MAX_COUNT_RESET` ) ) WHERE table2.`HOLDER_LINE` < 7 LIMIT 0 /* QNO 6777 CON_ID 18 */ ) /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 6783 CON_ID 18 */
|
Connection ID (thread ID): 18
|
Status: NOT_KILLED
|
#6 0x00007fb8b1fcfbf6 in __assert_fail_base (fmt=0x7fb8b2124058 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x56169f0c5a4d "lock_word <= 0x20000000", file=file@entry=0x56169f0c5a18 "/home/travis/src/storage/innobase/include/sync0rw.ic", line=line@entry=82, function=function@entry=0x56169f0c6d80 <_ZZL18rw_lock_get_writerPK9rw_lock_tE19__PRETTY_FUNCTION__> "ulint rw_lock_get_writer(const rw_lock_t*)") at assert.c:92
|
#7 0x00007fb8b1fcfca2 in __GI___assert_fail (assertion=0x56169f0c5a4d "lock_word <= 0x20000000", file=0x56169f0c5a18 "/home/travis/src/storage/innobase/include/sync0rw.ic", line=82, function=0x56169f0c6d80 <_ZZL18rw_lock_get_writerPK9rw_lock_tE19__PRETTY_FUNCTION__> "ulint rw_lock_get_writer(const rw_lock_t*)") at assert.c:101
|
#8 0x000056169eac7288 in rw_lock_get_writer (lock=0x56169f828618 <srv_sys+152>) at /home/travis/src/storage/innobase/include/sync0rw.ic:82
|
#9 0x000056169eac9a77 in sync_arr_fill_sys_semphore_waits_table (thd=0x7fb87400aa60, tables=0x7fb87401e238) at /home/travis/src/storage/innobase/sync/sync0arr.cc:1369
|
#10 0x000056169e5379d9 in get_schema_tables_result (join=0x7fb87425aa30, executed_place=PROCESSED_BY_JOIN_EXEC) at /home/travis/src/sql/sql_show.cc:8343
|
#11 0x000056169e4d580d in JOIN::exec_inner (this=0x7fb87425aa30) at /home/travis/src/sql/sql_select.cc:3530
|
#12 0x000056169e4d4ec8 in JOIN::exec (this=0x7fb87425aa30) at /home/travis/src/sql/sql_select.cc:3361
|
#13 0x000056169e57316a in st_select_lex_unit::exec (this=0x7fb87400e608) at /home/travis/src/sql/sql_union.cc:1005
|
#14 0x000056169e56fbdc in mysql_union (thd=0x7fb87400aa60, lex=0x7fb87400e540, result=0x7fb87425a908, unit=0x7fb87400e608, setup_tables_done_option=0) at /home/travis/src/sql/sql_union.cc:41
|
#15 0x000056169e4ca62b in handle_select (thd=0x7fb87400aa60, lex=0x7fb87400e540, result=0x7fb87425a908, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:354
|
#16 0x000056169e496351 in execute_sqlcom_select (thd=0x7fb87400aa60, all_tables=0x7fb87401db50) at /home/travis/src/sql/sql_parse.cc:6470
|
#17 0x000056169e48c3ba in mysql_execute_command (thd=0x7fb87400aa60) at /home/travis/src/sql/sql_parse.cc:3481
|
#18 0x000056169e499d7a in mysql_parse (thd=0x7fb87400aa60, rawbuf=0x7fb87401cdb8 "/* GenTest::Transform::ExecuteAsUnion */ ( SELECT * FROM (INFORMATION_SCHEMA.`INNODB_METRICS` AS table1 INNER JOIN INFORMATION_SCHEMA.`INNODB_SYS_SEMAPHORE_WAITS` AS table2 ON ( table2.`LAST_READER_L"..., length=639, parser_state=0x7fb894279210, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7916
|
#19 0x000056169e487c4b in dispatch_command (command=COM_QUERY, thd=0x7fb87400aa60, packet=0x7fb874014541 "/* GenTest::Transform::ExecuteAsUnion */ ( SELECT * FROM (INFORMATION_SCHEMA.`INNODB_METRICS` AS table1 INNER JOIN INFORMATION_SCHEMA.`INNODB_SYS_SEMAPHORE_WAITS` AS table2 ON ( table2.`LAST_READER_L"..., packet_length=640, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1817
|
#20 0x000056169e4865ae in do_command (thd=0x7fb87400aa60) at /home/travis/src/sql/sql_parse.cc:1371
|
#21 0x000056169e5d5b76 in do_handle_one_connection (connect=0x5616a1be5880) at /home/travis/src/sql/sql_connect.cc:1335
|
#22 0x000056169e5d5903 in handle_one_connection (arg=0x5616a1be5880) at /home/travis/src/sql/sql_connect.cc:1241
|
#23 0x00007fb8b2b91184 in start_thread (arg=0x7fb89427a700) at pthread_create.c:312
|
#24 0x00007fb8b209e03d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
experimental 69312423111b0cf4cb265a01b0950234901e8764 |
perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --seed=1521736473 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice,ExecuteAsSPTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --views --vcols --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.yy --basedir=/home/travis/server --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --grammar=conf/runtime/information_schema.yy --gendata-advanced --skip-gendata --vardir=/home/travis/logs/vardir1_1
|
Attachments
Issue Links
- relates to
-
MDEV-7109 Add support for INFORMATION_SCHEMA.INNODB_SEMAPHORE_WAITS
- Closed
-
MDEV-21452 Use condition variables and normal mutexes instead of InnoDB os_event and mutex
- Closed