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

innodb.innodb_bug14676111 fails in buildbot due to InnoDB purge failing to start when there is work to do

Details

    • 10.2.4-1, 10.2.4-2

    Description

      http://buildbot.askmonty.org/buildbot/builders/p8-rhel7-bintar-debug/builds/2018/steps/test/logs/stdio

      innodb.innodb_bug14676111 'innodb_plugin' w1 [ fail ]
      		 
              Test ended at 2017-01-05 22:06:59
      		 
       
      		 
      CURRENT_TEST: innodb.innodb_bug14676111
      		 
      --- /home/buildbot/maria-slave/power8-vlp03-bintar-debug/build/mysql-test/suite/innodb/r/innodb_bug14676111.result	2017-01-05 19:54:53.473261302 -0500
      		 
      +++ /home/buildbot/maria-slave/power8-vlp03-bintar-debug/build/mysql-test/suite/innodb/r/innodb_bug14676111.reject	2017-01-05 22:06:58.634010067 -0500
      		 
      @@ -22,7 +22,7 @@
      		 
       test.t1	analyze	status	OK
      		 
       select CLUST_INDEX_SIZE from information_schema.INNODB_SYS_TABLESTATS where NAME = 'test/t1';
      		 
       CLUST_INDEX_SIZE
      		 
      -8
      		 
      +10
      		 
       delete from t1 where a=5;
      		 
       set global innodb_purge_stop_now=ON;
      		 
       set global innodb_purge_run_now=ON;
      		 
       
      		 
      mysqltest: Result length mismatch

      Started happening quite regularly in buildbot on 10.1 tree since January 5, 2017.
      Observed on win32-debug, winx64-debug, p8-rhel7-bintar-debug.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12708 innodb.truncate_purge_debug fails sporadically in buildbot

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13603 innodb_fast_shutdown=0 may fail to purge all history

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-4396 Fix innodb.innodb_bug14676111 test

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11947 InnoDB purge workers fail to shut down

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12708 innodb.truncate_purge_debug fails sporadically in buildbot

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13603 innodb_fast_shutdown=0 may fail to purge all history

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13779 InnoDB fails to shut down purge workers, causing hang

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-16159 Use atomic memory access for purge_sys

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17745 innodb.innodb_stats_persistent failed in buildbot with wrong result

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18878 Purge is slow due to repeatedly looking up missing or discarded table

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24402 CHECK TABLE may miss some cases of index inconsistencies

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26193 Skip check to invoke purge if the transaction is read-only

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30671 innodb_undo_log_truncate=ON fails to wait for purge of transaction history

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-7069 Fix buildbot failures in main server trees

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-8139 Fix scrubbing

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-11024 Make number of purge threads variable dynamic

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12463 Unable to find a record to delete-mark just after upgrading from 10.2.4 to 10.2.5

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13603 innodb_fast_shutdown=0 may fail to purge all history

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14080 InnoDB shutdown sometimes hangs

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14445 innodb.table_flags failed in buildbot with wrong result

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15826 Purge attempts to free BLOB page after BEGIN;INSERT;UPDATE;ROLLBACK

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-16260 Scale the purge effort according to the workload

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-16264 Implement a common work queue for InnoDB background tasks

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              marko Marko Mäkelä
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.