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

main.mdl_sync extra test.t2 row in I_S.metadata_lock_info

    XMLWordPrintable

Details

    Description

      Test failure:

      main.mdl_sync                            w3 [ fail ]
              Test ended at 2025-04-19 06:40:48
      CURRENT_TEST: main.mdl_sync
      Warning: /home/buildbot/amd64-debian-12-debug-embedded/build/libmysqld/examples/mariadb-test-embedded: unknown option '--loose-disable-ssl-verify-server-cert'
      Warning: /home/buildbot/amd64-debian-12-debug-embedded/build/libmysqld/examples/mariadb-test-embedded: unknown variable 'loose-ssl-ca=/home/buildbot/amd64-debian-12-debug-embedded/build/mysql-test/std_data/cacert.pem'
      Warning: /home/buildbot/amd64-debian-12-debug-embedded/build/libmysqld/examples/mariadb-test-embedded: unknown variable 'loose-ssl-cert=/home/buildbot/amd64-debian-12-debug-embedded/build/mysql-test/std_data/client-cert.pem'
      Warning: /home/buildbot/amd64-debian-12-debug-embedded/build/libmysqld/examples/mariadb-test-embedded: unknown variable 'loose-ssl-key=/home/buildbot/amd64-debian-12-debug-embedded/build/mysql-test/std_data/client-key.pem'
      Warning: /home/buildbot/amd64-debian-12-debug-embedded/build/libmysqld/examples/mariadb-test-embedded: unknown option '--loose-skip-ssl'
      Got ERROR: "Failed to write to mysql.general_log: Wait on a lock was aborted due to a pending exclusive lock" errno: 2000
      --- /home/buildbot/amd64-debian-12-debug-embedded/build/mysql-test/main/mdl_sync.result	2025-04-19 06:35:23.000000000 +0000
      +++ /home/buildbot/amd64-debian-12-debug-embedded/build/mysql-test/main/mdl_sync.reject	2025-04-19 06:40:47.527987500 +0000
      @@ -2459,6 +2459,7 @@
       SELECT LOCK_MODE, LOCK_TYPE, TABLE_SCHEMA, TABLE_NAME FROM information_schema.metadata_lock_info;
       LOCK_MODE	LOCK_TYPE	TABLE_SCHEMA	TABLE_NAME
       MDL_BACKUP_FTWRL2	Backup lock		
      +MDL_SHARED	Table metadata lock	test	t2
       unlock tables;
       connection default;
       # Reaping UPDATE
      

      Another variant of this failure (--ps-protocol):

      mysqltest: At line 3161: The result of the 1st execution does not match with 
      the result of the 2nd execution of ps-protocol:
       1st:
      LOCK_MODE	LOCK_TYPE	TABLE_SCHEMA	TABLE_NAME
      MDL_BACKUP_FTWRL2	Backup lock		
      MDL_SHARED	Table metadata lock	test	t2
       
       2nd:
       LOCK_MODE	LOCK_TYPE	TABLE_SCHEMA	TABLE_NAME
      MDL_BACKUP_FTWRL2	Backup lock		
      

      Reported basing on this build.
      Cross reference shows more failures.

      Attachments

        Issue Links

          Activity

            People

              svoj Sergey Vojtovich
              svoj Sergey Vojtovich
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.