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

InnoDB occasionally skips the doublewrite buffer write for some pages

    XMLWordPrintable

Details

    • 5.5.59, 10.3.6-1

    Description

      https://internal.askmonty.org/buildbot/builders/win32-debug/builds/3945/steps/test/logs/stdio

      innodb.doublewrite 'innodb_plugin'       w2 [ fail ]
              Test ended at 2017-05-20 15:15:56
       
      CURRENT_TEST: innodb.doublewrite
      mysqltest: At line 220: query 'set global innodb_fil_make_page_dirty_debug = @space_id' failed: 2013: Lost connection to MySQL server during query
       
      The result from queries just before the failure was:
      < snip >
      f1	f2
      1	############
      2	++++++++++++
      3	////////////
      4	------------
      5	............
      # Test End
      # ---------------------------------------------------------------
      # Test Begin: Test if recovery works if 2nd page of user
      # tablespace is corrupted.
      select space from information_schema.innodb_sys_tables
      where name = 'test/t1' into @space_id;
      # Ensure that dirty pages of table t1 is flushed.
      flush tables t1 for export;
      unlock tables;
      begin;
      insert into t1 values (6, repeat('%', 400));
      # Make the 2nd page dirty for table t1
      set global innodb_saved_page_number_debug = 1;
      set global innodb_fil_make_page_dirty_debug = @space_id;
       
      More results from queries before failure can be found in D:\win32-debug\build\mysql-test\var\2\log\doublewrite.log
       
       
      Server [mysqld.1 - pid: 5132, winpid: 5132, exit: 768] failed during test run
      Server log from this test:
      ----------SERVER LOG START-----------
      ----------SERVER LOG END-------------
      

      Attachments

        1. case1_16k.zip
          106 kB
        2. case1.zip
          116 kB
        3. case2_8k.zip
          43 kB
        4. case3_2.zip
          162 kB
        5. doublewrite.test
          11 kB
        6. doublewrite.zip
          2.15 MB
        7. ibdata1_2.zip
          106 kB
        8. ibdata1.zip
          105 kB
        9. mysqld.1.err
          104 kB
        10. mysqld.1.err
          393 kB
        11. var.zip
          2.21 MB

        Issue Links

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.