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

innodb.purge_thread_shutdown failed in buildbot with wrong result (sporadic)

Details

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/9567/steps/test_2/logs/stdio

      innodb.purge_thread_shutdown 'innodb'    w4 [ fail ]
              Test ended at 2017-09-13 01:37:34
       
      CURRENT_TEST: innodb.purge_thread_shutdown
      --- /mnt/buildbot/build/mariadb-10.2.9/mysql-test/suite/innodb/r/purge_thread_shutdown.result	2017-09-13 00:04:28.000000000 +0300
      +++ /mnt/buildbot/build/mariadb-10.2.9/mysql-test/suite/innodb/r/purge_thread_shutdown.reject	2017-09-13 01:37:33.000000000 +0300
      @@ -5,11 +5,11 @@
       select user,state from information_schema.processlist order by 2;
       user	state
       root	
      +system user	closing tables
       root	Filling schema table
       system user	InnoDB purge coordinator
       system user	InnoDB purge worker
       system user	InnoDB purge worker
      -system user	InnoDB purge worker
       system user	InnoDB shutdown handler
       set global debug_dbug='+d,only_kill_system_threads';
       set global innodb_fast_shutdown=0;
       
      mysqltest: Result length mismatch
      

      Attachments

        Activity

          alice Alice Sherepa created issue -
          karlsson Anders Karlsson made changes -
          Field Original Value New Value
          Assignee Anders Karlsson [ karlsson ]
          serg Sergei Golubchik made changes -
          Assignee Anders Karlsson [ karlsson ]
          elenst Elena Stepanova made changes -
          Summary innodb.purge_thread_shutdown failed in buildbot(sporadic) innodb.purge_thread_shutdown failed in buildbot with wrong result (sporadic)
          marko Marko Mäkelä made changes -
          Affects Version/s 10.3 [ 22126 ]
          marko Marko Mäkelä made changes -
          Fix Version/s 10.3 [ 22126 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.4 [ 22408 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 82551 ] MariaDB v4 [ 140412 ]
          ralf.gebhardt Ralf Gebhardt made changes -
          Fix Version/s 10.2 [ 14601 ]
          julien.fritsch Julien Fritsch made changes -
          Fix Version/s 10.3 [ 22126 ]

          From Zulip discussions:

          The test wants to show the list of running processes, to show which system threads and connection threads are running.

          The problem is that using the state to identify the thread doesn't work, as it changes as the thread is doing stuff (enter_state()). I would suggest to change the query to SELECT user FROM information_schema.processlist order by 1, this way the user-vs-system threads can be seen which I think is good enough.

          Or alternatively, include/wait_condition.inc with some condition that counts each kind of thread and compares with expected count. That would be equivalent, but not sure if that complexity is needed

          knielsen Kristian Nielsen added a comment - From Zulip discussions: The test wants to show the list of running processes, to show which system threads and connection threads are running. The problem is that using the state to identify the thread doesn't work, as it changes as the thread is doing stuff (enter_state()). I would suggest to change the query to SELECT user FROM information_schema.processlist order by 1, this way the user-vs-system threads can be seen which I think is good enough. Or alternatively, include/wait_condition.inc with some condition that counts each kind of thread and compares with expected count. That would be equivalent, but not sure if that complexity is needed
          knielsen Kristian Nielsen made changes -
          Assignee Kristian Nielsen [ knielsen ]
          knielsen Kristian Nielsen made changes -
          Status Open [ 1 ] In Progress [ 3 ]

          Pushed to 10.4.
          (Marko removed the test from 10.5, as it is no longer meaningful there.)

          knielsen Kristian Nielsen added a comment - Pushed to 10.4. (Marko removed the test from 10.5, as it is no longer meaningful there.)
          knielsen Kristian Nielsen made changes -
          Fix Version/s 10.4.33 [ 29516 ]
          Fix Version/s 10.4 [ 22408 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          julien.fritsch Julien Fritsch made changes -
          Fix Version/s 10.5.24 [ 29517 ]
          Fix Version/s 10.6.17 [ 29518 ]
          Fix Version/s 10.11.7 [ 29519 ]
          Fix Version/s 11.0.5 [ 29520 ]
          Fix Version/s 11.1.4 [ 29024 ]
          Fix Version/s 11.2.3 [ 29521 ]

          People

            knielsen Kristian Nielsen
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.