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

Hang in galera_bf_abort_lock_table test

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 10.6, 10.11
    • 10.6, 10.11
    • Galera
    • None

    Description

      galera.galera_bf_abort_lock_table        w4 [ fail ]
              Test ended at 2025-04-10 04:44:18
      CURRENT_TEST: galera.galera_bf_abort_lock_table
      --- /home/buildbot/amd64-fedora-39/build/mysql-test/suite/galera/r/galera_bf_abort_lock_table.result	2025-04-10 04:03:16.000000000 +0000
      +++ /home/buildbot/amd64-fedora-39/build/mysql-test/suite/galera/r/galera_bf_abort_lock_table.reject	2025-04-10 04:44:07.824536421 +0000
      @@ -8,11 +8,17 @@
       INSERT INTO t1 VALUES (2);
       connection node_2;
       SET SESSION wsrep_sync_wait = 0;
      +Timeout in wait_condition.inc for SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND (STATE LIKE 'Waiting for table metadata lock%' OR STATE LIKE 'Waiting to execute in isolation%');
      +SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
      +ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO	TIME_MS	STAGE	MAX_STAGE	PROGRESS	MEMORY_USED	MAX_MEMORY_USED	EXAMINED_ROWS	QUERY_ID	INFO_BINARY	TID
      +82	root	localhost:57240	test	Query	0	Filling schema table	SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST	0.517	0	0	0.000	159088	293320	0	1505	SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST	206097
      +2	system user		NULL	Sleep	30	wsrep applier committed	NULL	30496.920	0	0	0.000	65712	87168	0	1205	NULL	201881
      +1	system user		NULL	Sleep	68	wsrep aborter idle	NULL	68251.212	0	0	0.000	66784	66784	0	0	NULL	201880
       UNLOCK TABLES;
       COMMIT;
       SELECT COUNT(*) = 1 FROM t1;
       COUNT(*) = 1
       1
       wsrep_local_aborts_increment
      -1
      +0
       DROP TABLE t1;
      Result length mismatch
       - saving '/home/buildbot/amd64-fedora-39/build/mysql-test/var/4/log/galera.galera_bf_abort_lock_table/' to '/home/buildbot/amd64-fedora-39/build/mysql-test/var/log/galera.galera_bf_abort_lock_table/'
      Retrying test galera.galera_bf_abort_lock_table, attempt(2/3)...
      worker[04] > Restart  - not started

      Attachments

        Activity

          People

            Lampio Pekka
            sysprg Julius Goryavsky
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.