[MDEV-15653] [Draft] Assertion `lock_word <= 0x20000000' failed in rw_lock_get_writer Created: 2018-03-24  Updated: 2023-11-26  Resolved: 2023-11-26

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.2, 10.4
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: not-10.6

Attachments: HTML File threads    
Issue Links:
Relates
relates to MDEV-7109 Add support for INFORMATION_SCHEMA.IN... Closed
relates to MDEV-21452 Use condition variables and normal mu... Closed

 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



 Comments   
Comment by Elena Stepanova [ 2018-07-17 ]

New occurrence on 10.2:
https://travis-ci.org/elenst/travis-tests/jobs/404972071
1311,2,3 / 1311.2.3
Server: 10.2 1cc1d0429da14a041a6240c6fce17e0d31cad8e2
Tests: master 22a15d6a9a42af4902b95a763d3b764f5ba7983f

Comment by Elena Stepanova [ 2018-10-02 ]

New occurrence on 10.4:
https://travis-ci.org/elenst/travis-tests/jobs/435289303

Rarely happening and not reproducible locally so far.

Comment by Elena Stepanova [ 2019-01-07 ]

New occurrence on 10.2: https://travis-ci.org/elenst/travis-tests/jobs/473070130

Comment by Marko Mäkelä [ 2020-12-17 ]

The view INFORMATION_SCHEMA.INNODB_SEMAPHORE_WAITS that was introduced in MDEV-7109 was removed in MDEV-21452 (MariaDB Server 10.6.0) along with the sync_array.

Generated at Thu Feb 08 08:23:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.