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

InnoDB occasionally skips the doublewrite buffer write for some pages

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

            Transition Time In Source Status Execution Times
            Marko Mäkelä made transition -
            Open Confirmed
            123d 20h 1
            Marko Mäkelä made transition -
            Confirmed Closed
            1310d 5h 52m 1

            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.