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

perfschema.threads_mysql fails in buildbot (type=BACKGROUND mismatch)

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • 10.1(EOL), 10.2(EOL)
    • N/A
    • Tests
    • None

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-centos5-amd64/builds/2987/steps/test/logs/stdio

      perfschema.threads_mysql                 w2 [ fail ]
              Test ended at 2016-06-02 15:00:59
       
      CURRENT_TEST: perfschema.threads_mysql
      --- /usr/local/mariadb-10.1.15-linux-x86_64/mysql-test/suite/perfschema/r/threads_mysql.result	2016-06-02 10:52:08.000000000 +0200
      +++ /usr/local/mariadb-10.1.15-linux-x86_64/mysql-test/suite/perfschema/r/threads_mysql.reject	2016-06-02 15:00:59.000000000 +0200
      @@ -21,6 +21,16 @@
       type	FOREGROUND
       processlist_user	root
       processlist_host	localhost
      +processlist_db	mtr
      +processlist_command	Sleep
      +processlist_info	NULL
      +unified_parent_thread_id	unified parent_thread_id
      +role	NULL
      +instrumented	YES
      +name	thread/sql/one_connection
      +type	FOREGROUND
      +processlist_user	root
      +processlist_host	localhost
       processlist_db	test
       processlist_command	Query
       processlist_info	SELECT name, type, processlist_user, processlist_host, processlist_db,
      

      Attachments

        Issue Links

          Activity

            10.1 892cf2de13e1dc01ee47afc244deb861
            logs not available

            perfschema.threads_mysql                 w1 [ fail ]
                    Test ended at 2017-10-31 16:42:55
             
            CURRENT_TEST: perfschema.threads_mysql
            --- /usr/local/mariadb-10.1.29-linux-x86_64/mysql-test/suite/perfschema/r/threads_mysql.result	2017-10-31 13:50:57.000000000 +0200
            +++ /usr/local/mariadb-10.1.29-linux-x86_64/mysql-test/suite/perfschema/r/threads_mysql.reject	2017-10-31 16:42:55.019538132 +0200
            @@ -68,11 +68,11 @@
               AND thread_id NOT IN (SELECT thread_id FROM t1)
             ORDER BY name;
             name	thread/sql/event_scheduler
            -type	FOREGROUND
            +type	BACKGROUND
             processlist_user	root
             processlist_host	localhost
             processlist_db	NULL
            -processlist_command	Sleep
            +processlist_command	NULL
             processlist_info	NULL
             unified_parent_thread_id	unified parent_thread_id
             role	NULL
             
            mysqltest: Result length mismatch
            

            It appears to be a unique occurrence so far.

            elenst Elena Stepanova added a comment - 10.1 892cf2de13e1dc01ee47afc244deb861 logs not available perfschema.threads_mysql w1 [ fail ] Test ended at 2017-10-31 16:42:55   CURRENT_TEST: perfschema.threads_mysql --- /usr/local/mariadb-10.1.29-linux-x86_64/mysql-test/suite/perfschema/r/threads_mysql.result 2017-10-31 13:50:57.000000000 +0200 +++ /usr/local/mariadb-10.1.29-linux-x86_64/mysql-test/suite/perfschema/r/threads_mysql.reject 2017-10-31 16:42:55.019538132 +0200 @@ -68,11 +68,11 @@ AND thread_id NOT IN (SELECT thread_id FROM t1) ORDER BY name; name thread/sql/event_scheduler -type FOREGROUND +type BACKGROUND processlist_user root processlist_host localhost processlist_db NULL -processlist_command Sleep +processlist_command NULL processlist_info NULL unified_parent_thread_id unified parent_thread_id role NULL   mysqltest: Result length mismatch It appears to be a unique occurrence so far.

            Not unique anymore – 10.2:
            http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-trusty-x86/builds/4100/steps/test/logs/stdio

            perfschema.threads_mysql                 w2 [ fail ]
                    Test ended at 2017-12-25 05:23:04
             
            CURRENT_TEST: perfschema.threads_mysql
            --- /usr/local/mariadb-10.2.12-linux-i686/mysql-test/suite/perfschema/r/threads_mysql.result	2017-12-25 04:41:21.000000000 +0000
            +++ /usr/local/mariadb-10.2.12-linux-i686/mysql-test/suite/perfschema/r/threads_mysql.reject	2017-12-25 05:23:04.060758441 +0000
            @@ -68,11 +68,11 @@
               AND thread_id NOT IN (SELECT thread_id FROM t1)
             ORDER BY name;
             name	thread/sql/event_scheduler
            -type	FOREGROUND
            +type	BACKGROUND
             processlist_user	root
             processlist_host	localhost
             processlist_db	NULL
            -processlist_command	Sleep
            +processlist_command	NULL
             processlist_info	NULL
             unified_parent_thread_id	unified parent_thread_id
             role	NULL
             
            mysqltest: Result length mismatch
            

            elenst Elena Stepanova added a comment - Not unique anymore – 10.2: http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-trusty-x86/builds/4100/steps/test/logs/stdio perfschema.threads_mysql w2 [ fail ] Test ended at 2017-12-25 05:23:04   CURRENT_TEST: perfschema.threads_mysql --- /usr/local/mariadb-10.2.12-linux-i686/mysql-test/suite/perfschema/r/threads_mysql.result 2017-12-25 04:41:21.000000000 +0000 +++ /usr/local/mariadb-10.2.12-linux-i686/mysql-test/suite/perfschema/r/threads_mysql.reject 2017-12-25 05:23:04.060758441 +0000 @@ -68,11 +68,11 @@ AND thread_id NOT IN (SELECT thread_id FROM t1) ORDER BY name; name thread/sql/event_scheduler -type FOREGROUND +type BACKGROUND processlist_user root processlist_host localhost processlist_db NULL -processlist_command Sleep +processlist_command NULL processlist_info NULL unified_parent_thread_id unified parent_thread_id role NULL   mysqltest: Result length mismatch

            Seen on MariaDB 10.11 in https://launchpadlibrarian.net/712871094/buildlog_ubuntu-noble-ppc64el.mariadb_1%3A10.11.6-3~bpo24.04.1~1707078933.a3220971295+feature.extend.mtr.to.big_BUILDING.txt.gz

            perfschema.threads_mysql                 w1 [ fail ]
                    Test ended at 2024-02-04 21:36:09
             
            CURRENT_TEST: perfschema.threads_mysql
            --- /<<PKGBUILDDIR>>/mysql-test/suite/perfschema/r/threads_mysql.result	2023-11-08 15:46:47.000000000 +0000
            +++ /<<PKGBUILDDIR>>/mysql-test/suite/perfschema/r/threads_mysql.reject	2024-02-04 21:36:09.069412843 +0000
            @@ -72,11 +72,11 @@
               AND thread_id NOT IN (SELECT thread_id FROM t1)
             ORDER BY name;
             name	thread/sql/event_scheduler
            -type	FOREGROUND
            +type	BACKGROUND
             processlist_user	root
             processlist_host	localhost
             processlist_db	NULL
            -processlist_command	Sleep
            +processlist_command	NULL
             processlist_info	NULL
             unified_parent_thread_id	unified parent_thread_id
             role	NULL
             
            mysqltest: Result length mismatch
            

            Seems sporadic.

            otto Otto Kekäläinen added a comment - Seen on MariaDB 10.11 in https://launchpadlibrarian.net/712871094/buildlog_ubuntu-noble-ppc64el.mariadb_1%3A10.11.6-3~bpo24.04.1~1707078933.a3220971295+feature.extend.mtr.to.big_BUILDING.txt.gz perfschema.threads_mysql w1 [ fail ] Test ended at 2024-02-04 21:36:09   CURRENT_TEST: perfschema.threads_mysql --- /<<PKGBUILDDIR>>/mysql-test/suite/perfschema/r/threads_mysql.result 2023-11-08 15:46:47.000000000 +0000 +++ /<<PKGBUILDDIR>>/mysql-test/suite/perfschema/r/threads_mysql.reject 2024-02-04 21:36:09.069412843 +0000 @@ -72,11 +72,11 @@ AND thread_id NOT IN (SELECT thread_id FROM t1) ORDER BY name; name thread/sql/event_scheduler -type FOREGROUND +type BACKGROUND processlist_user root processlist_host localhost processlist_db NULL -processlist_command Sleep +processlist_command NULL processlist_info NULL unified_parent_thread_id unified parent_thread_id role NULL   mysqltest: Result length mismatch Seems sporadic.

            People

              Unassigned Unassigned
              elenst Elena Stepanova
              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.