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

[Draft] Server crashed in dirname_length / innobase_basename / sync_arr_fill_sys_semphore_waits_table

    XMLWordPrintable

    Details

      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

        1. exception_analysis
          104 kB
        2. mysql.err
          6 kB
        3. mysql.log
          3.60 MB
        4. mysqld.dmp
          253 kB

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:

                  Git Integration