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

[Draft] InnoDB: Failing assertion: mysql_table

    XMLWordPrintable

Details

    Description

      Encountered during tests on bb-10.2-monty. Information in the report is related to that test run, but I couldn't reproduce it so far neither on the same tree, nor on 10.2.

      bb-10.2-monty 4ec3e60ae3734 of Jan 6

      2017-01-07 19:38:28 140022359500544 [Note] InnoDB: Read page 0 from tablespace forspace 418 name testdb_N/t1_base1_N key_id 0 encryption 0 handle 52
      2017-01-07 19:38:28 140022351107840 [ERROR] InnoDB: Failed to find tablespace for table `testdb_N`.`t1_merge2_N` in the cache. Attempting to load the tablespace with space id 474
      2017-01-07 19:38:28 140022351107840 [ERROR] InnoDB: Operating system error number 2 in a file operation.
      2017-01-07 19:38:28 140022351107840 [ERROR] InnoDB: The error means the system cannot find the path specified.
      2017-01-07 19:38:28 140022351107840 [ERROR] InnoDB: Cannot open datafile for read-only: './testdb_N/t1_merge2_N.ibd' OS error: 71
      2017-01-07 19:38:28 140022351107840 [ERROR] InnoDB: Operating system error number 2 in a file operation.
      2017-01-07 19:38:28 140022351107840 [ERROR] InnoDB: The error means the system cannot find the path specified.
      2017-01-07 19:38:28 140022351107840 [ERROR] InnoDB: Could not find a valid tablespace file for `testdb_N/t1_merge2_N`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
      2017-01-07 19:38:28 140022351107840 [Warning] InnoDB: Cannot calculate statistics for table `testdb_N`.`t1_merge2_N` because the .ibd file is missing. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.
      2017-01-07 19:38:28 0x7f597e7f9700  InnoDB: Assertion failure in file /home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc line 23607
      InnoDB: Failing assertion: mysql_table
      

      # 2017-01-07T19:38:51 [1224] #6  0x00007f59c1985df5 in ut_dbg_assertion_failed (expr=0x7f59c1ec6929 "mysql_table", file=0x7f59c1eb9718 "/home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc", line=23607) at /home/elenst/git/bb-10.2-monty/storage/innobase/ut/ut0dbg.cc:59
      # 2017-01-07T19:38:51 [1224] #7  0x00007f59c1777185 in innobase_init_vc_templ (table=0x7f597c870688) at /home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc:23607
      # 2017-01-07T19:38:51 [1224] #8  0x00007f59c18cdf26 in row_purge_parse_undo_rec (node=0x7f59be1f1688, undo_rec=0x7f597d57c630 "\035\330\016", updated_extern=0x7f597e7f8d2e, thr=0x7f59be206660) at /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0purge.cc:886
      # 2017-01-07T19:38:51 [1224] #9  0x00007f59c18ce45c in row_purge (node=0x7f59be1f1688, undo_rec=0x7f597d57c630 "\035\330\016", thr=0x7f59be206660) at /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0purge.cc:1028
      # 2017-01-07T19:38:51 [1224] #10 0x00007f59c18ce6d6 in row_purge_step (thr=0x7f59be206660) at /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0purge.cc:1110
      # 2017-01-07T19:38:51 [1224] #11 0x00007f59c1858050 in que_thr_step (thr=0x7f59be206660) at /home/elenst/git/bb-10.2-monty/storage/innobase/que/que0que.cc:1056
      # 2017-01-07T19:38:51 [1224] #12 0x00007f59c185824f in que_run_threads_low (thr=0x7f59be206660) at /home/elenst/git/bb-10.2-monty/storage/innobase/que/que0que.cc:1118
      # 2017-01-07T19:38:51 [1224] #13 0x00007f59c185840f in que_run_threads (thr=0x7f59be206660) at /home/elenst/git/bb-10.2-monty/storage/innobase/que/que0que.cc:1158
      # 2017-01-07T19:38:51 [1224] #14 0x00007f59c191de80 in srv_task_execute () at /home/elenst/git/bb-10.2-monty/storage/innobase/srv/srv0srv.cc:2721
      # 2017-01-07T19:38:51 [1224] #15 0x00007f59c191dfff in srv_worker_thread (arg=0x0) at /home/elenst/git/bb-10.2-monty/storage/innobase/srv/srv0srv.cc:2771
      # 2017-01-07T19:38:51 [1224] #16 0x00007f59bf61fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      # 2017-01-07T19:38:51 [1224] #17 0x00007f59beb36cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x0): 
      Connection ID (thread ID): 5
      Status: NOT_KILLED
      

      RQG experimental 67b190f486

      perl /home/elenst/git/rqg/runall-new.pl --no-mask --seed=1483810215 --threads=8 --duration=600 --queries=100M --validators=TransformerNoComparator --transformers=ExecuteAsPreparedTwice,DisableOptimizations,EnableOptimizations,InlineVirtualColumns,ExecuteAsTrigger --redefine=conf/mariadb/general-workarounds.yy --redefine=conf/mariadb/10.0-features-redefine.yy --mysqld=--log_output=FILE --views --grammar=conf/runtime/WL5004_sql.yy --gendata=conf/runtime/WL5004_data.zz --reporters=QueryTimeout,Backtrace,ErrorLog,Deadlock,CrashRestart --restart-timeout=20 --mtr-build-thread=72 --basedir1=/home/elenst/git/bb-10.2-monty --vardir1=/home/elenst/test_results/monty-4/current1_1
      

      Attachments

        1. threads
          37 kB
        2. mysql.err
          618 kB
        3. mysql.log.gz
          233 kB

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              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.