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

innodb.innodb-alter fails in buildbot with extra warning

Details

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64-debug/builds/4274

      10.5 ab9bd6284c0cac74affed900bd45293f

      		 
      innodb.innodb-alter 'innodb'             w1 [ fail ]  Found warnings/errors in server log file!
      		 
              Test ended at 2020-06-12 23:12:17
      		 
      line
      		 
      2020-06-12 23:12:16 3 [Warning] InnoDB: MySQL is trying to drop database `db2`.`` though there are still open handles to table `db2`.`#sql-ib230`.
      		 
      ^ Found warnings in /dev/shm/var/1/log/mysqld.1.err

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21283 InnoDB: MySQL is trying to drop database…open handles to table …`#sql-ib1148`

          • Major - Major loss of function.
          • Closed
          is part of

          Task - A task that needs to be done. MDEV-33073 always green buildbot

          • Major - Major loss of function.
          • Stalled

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova created issue -
            elenst Elena Stepanova added a comment -

            Same with innodb_fts.innodb_fts_misc:

            innodb_fts.innodb_fts_misc 'innodb'      w3 [ fail ]  Found warnings/errors in server log file!
            		 
                    Test ended at 2020-06-13 02:17:51
            		 
            line
            		 
            2020-06-13  2:17:48 3 [Warning] InnoDB: MySQL is trying to drop database `benu database`.`` though there are still open handles to table `benu database`.`#sql-ib1795`.
            		 
            ^ Found warnings in /dev/shm/var/3/log/mysqld.1.err
            		 
            ok

            elenst Elena Stepanova added a comment - Same with innodb_fts.innodb_fts_misc: innodb_fts.innodb_fts_misc 'innodb' w3 [ fail ] Found warnings/errors in server log file! Test ended at 2020-06-13 02:17:51 line 2020-06-13 2:17:48 3 [Warning] InnoDB: MySQL is trying to drop database `benu database`.`` though there are still open handles to table `benu database`.`#sql-ib1795`. ^ Found warnings in /dev/shm/var/3/log/mysqld.1.err ok
            elenst Elena Stepanova added a comment -

            http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64-debug/builds/4337

            innodb.foreign_key 'innodb'              w4 [ fail ]  Found warnings/errors in server log file!
            		 
                    Test ended at 2020-06-18 22:03:18
            		 
            line
            		 
            2020-06-18 22:03:14 3 [Warning] InnoDB: MySQL is trying to drop database `best`.`` though there are still open handles to table `best`.`#sql-ib1155`.
            		 
            ^ Found warnings in /dev/shm/var/4/log/mysqld.1.err

            elenst Elena Stepanova added a comment - http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64-debug/builds/4337 innodb.foreign_key 'innodb' w4 [ fail ] Found warnings/errors in server log file! Test ended at 2020-06-18 22:03:18 line 2020-06-18 22:03:14 3 [Warning] InnoDB: MySQL is trying to drop database `best`.`` though there are still open handles to table `best`.`#sql-ib1155`. ^ Found warnings in /dev/shm/var/4/log/mysqld.1.err
            alice Alice Sherepa made changes -
            Field Original Value New Value
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 110244 ] MariaDB v4 [ 142036 ]
            elenst Elena Stepanova added a comment -

            Still happens.

            elenst Elena Stepanova added a comment - Still happens.
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Blocker [ 1 ]
            serg Sergei Golubchik added a comment -

            https://buildbot.mariadb.org/#/builders/640/builds/362

            serg Sergei Golubchik added a comment - https://buildbot.mariadb.org/#/builders/640/builds/362
            marko Marko Mäkelä added a comment -

            This was fixed in 10.6 by removing the non-ACID "background drop table queue". This can’t be fixed other than by adding a global suppression to 10.5.

            marko Marko Mäkelä added a comment - This was fixed in 10.6 by removing the non-ACID "background drop table queue". This can’t be fixed other than by adding a global suppression to 10.5.
            serg Sergei Golubchik made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            Status Stalled [ 10000 ] In Testing [ 10301 ]
            serg Sergei Golubchik made changes -
            Assignee Marko Mäkelä [ marko ] Sergei Golubchik [ serg ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.5.25 [ 29626 ]
            Fix Version/s 10.5 [ 23123 ]
            Resolution Fixed [ 1 ]
            Status In Testing [ 10301 ] Closed [ 6 ]

            People

              serg Sergei Golubchik
              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.