Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15653

[Draft] Assertion `lock_word <= 0x20000000' failed in rw_lock_get_writer

    XMLWordPrintable

Details

    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

        1. threads
          53 kB
          Elena Stepanova

        Issue Links

          Activity

            People

              Unassigned Unassigned
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.