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

galera_ddl_fk_conflict test failed due to timeout

Details

    Description

      galera.galera_ddl_fk_conflict test failed due to timeout:

      galera.galera_ddl_fk_conflict            w1 [ fail ]
              Test ended at 2024-11-18 05:33:32
       
      CURRENT_TEST: galera.galera_ddl_fk_conflict
      --- /home/jenkins/workspace/Source-Build-Test/src/mysql-test/suite/galera/r/galera_ddl_fk_conflict.result	2024-11-18 05:13:38.000000000 +0000
      +++ /home/jenkins/workspace/Source-Build-Test/src/mysql-test/suite/galera/r/galera_ddl_fk_conflict.reject	2024-11-18 05:33:22.021724491 +0000
      @@ -201,6 +201,14 @@
       UPDATE p1 SET f2 = 'TO DEADLOCK' WHERE pk = 1;
       COMMIT;
       connection node_1a;
      +Timeout in wait_condition.inc for SELECT VARIABLE_VALUE = 15 FROM information_schema.global_status WHERE VARIABLE_NAME = 'wsrep_local_cert_failures'
      +Id	User	Host	db	Command	Time	State	Info	Progress
      +1	system user		NULL	Sleep	236	wsrep aborter idle	NULL	0.000
      +224	system user		NULL	Sleep	30	After apply log event	NULL	0.000
      +360	root	localhost	test	Sleep	32		NULL	0.000
      +361	root	localhost:57242	test	Query	30	Waiting for certification	COMMIT	0.000
      +362	root	localhost:57252	test	Query	0	starting	show full processlist	0.000
      +363	root	localhost:57264	test	Sleep	30		NULL	0.000
       SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
       connection node_1;
       ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
       
      Result length mismatch
       
       - saving '/dev/shm/var/1/log/galera.galera_ddl_fk_conflict/' to '/dev/shm/var/log/galera.galera_ddl_fk_conflict/'

      Attachments

        Activity

          Could not reproduce, I need stdout from mtr and artifacts from Jenkins.

          janlindstrom Jan Lindström added a comment - Could not reproduce, I need stdout from mtr and artifacts from Jenkins.
          • Tested with 11.4-enterprise commit 79bfedaf1 and could not reproduce easily-
          • Also tested with 11.4 commit 9e7762e71 could not reproduce easily.

            jan@jan-ThinkPad-P1-Gen-6:~/work/mariadb/11.4-enterprise/mysql-test$ ./mtr galera.galera_ddl_fk_conflict --repeat=50 --enable-disabled
            Logging: ./mtr  galera.galera_ddl_fk_conflict --repeat=50 --enable-disabled
            VS config: 
            vardir: /home/jan/work/mariadb/11.4-enterprise/mysql-test/var
            Checking leftover processes...
            Removing old var directory...
            Creating var directory '/home/jan/work/mariadb/11.4-enterprise/mysql-test/var'...
            Checking supported features...
            MariaDB Version 11.4.4-2-MariaDB-debug
             - SSL connections supported
             - binaries are debug compiled
             - binaries built with wsrep patch
            Collecting tests...
             - galera.galera_ddl_fk_conflict will be run although it's been disabled
               due to 'MENT-2172 galera_ddl_fk_conflict test failed due to timeout'
            Installing system database...
             
            ==============================================================================
             
            TEST                                      RESULT   TIME (ms) or COMMENT
            --------------------------------------------------------------------------
             
            worker[01] Using MTR_BUILD_THREAD 300, with reserved ports 19000..19029
            galera.galera_ddl_fk_conflict            [ pass ]   2265
            galera.galera_ddl_fk_conflict            [ 2 pass ]   2275
            galera.galera_ddl_fk_conflict            [ 3 pass ]   2302
            galera.galera_ddl_fk_conflict            [ 4 pass ]   2239
            galera.galera_ddl_fk_conflict            [ 5 pass ]   2249
            galera.galera_ddl_fk_conflict            [ 6 pass ]   2287
            galera.galera_ddl_fk_conflict            [ 7 pass ]   2265
            galera.galera_ddl_fk_conflict            [ 8 pass ]   2264
            galera.galera_ddl_fk_conflict            [ 9 pass ]   2267
            galera.galera_ddl_fk_conflict            [ 10 pass ]   2272
            galera.galera_ddl_fk_conflict            [ 11 pass ]   2324
            galera.galera_ddl_fk_conflict            [ 12 pass ]   2230
            galera.galera_ddl_fk_conflict            [ 13 pass ]   2235
            galera.galera_ddl_fk_conflict            [ 14 pass ]   2315
            galera.galera_ddl_fk_conflict            [ 15 pass ]   2380
            galera.galera_ddl_fk_conflict            [ 16 pass ]   2281
            galera.galera_ddl_fk_conflict            [ 17 pass ]   2235
            galera.galera_ddl_fk_conflict            [ 18 pass ]   2265
            galera.galera_ddl_fk_conflict            [ 19 pass ]   2238
            galera.galera_ddl_fk_conflict            [ 20 pass ]   2319
            galera.galera_ddl_fk_conflict            [ 21 pass ]   2270
            galera.galera_ddl_fk_conflict            [ 22 pass ]   2257
            galera.galera_ddl_fk_conflict            [ 23 pass ]   2251
            galera.galera_ddl_fk_conflict            [ 24 pass ]   2274
            galera.galera_ddl_fk_conflict            [ 25 pass ]   2252
            galera.galera_ddl_fk_conflict            [ 26 pass ]   2233
            galera.galera_ddl_fk_conflict            [ 27 pass ]   2344
            galera.galera_ddl_fk_conflict            [ 28 pass ]   2241
            galera.galera_ddl_fk_conflict            [ 29 pass ]   2233
            galera.galera_ddl_fk_conflict            [ 30 pass ]   2232
            galera.galera_ddl_fk_conflict            [ 31 pass ]   2242
            galera.galera_ddl_fk_conflict            [ 32 pass ]   2298
            galera.galera_ddl_fk_conflict            [ 33 pass ]   2253
            galera.galera_ddl_fk_conflict            [ 34 pass ]   2390
            galera.galera_ddl_fk_conflict            [ 35 pass ]   2239
            galera.galera_ddl_fk_conflict            [ 36 pass ]   2233
            galera.galera_ddl_fk_conflict            [ 37 pass ]   2234
            galera.galera_ddl_fk_conflict            [ 38 pass ]   2227
            galera.galera_ddl_fk_conflict            [ 39 pass ]   2391
            galera.galera_ddl_fk_conflict            [ 40 pass ]   2226
            galera.galera_ddl_fk_conflict            [ 41 pass ]   2245
            galera.galera_ddl_fk_conflict            [ 42 pass ]   2232
            galera.galera_ddl_fk_conflict            [ 43 pass ]   2276
            galera.galera_ddl_fk_conflict            [ 44 pass ]   2261
            galera.galera_ddl_fk_conflict            [ 45 pass ]   2270
            galera.galera_ddl_fk_conflict            [ 46 pass ]   2214
            galera.galera_ddl_fk_conflict            [ 47 pass ]   2259
            galera.galera_ddl_fk_conflict            [ 48 pass ]   2259
            galera.galera_ddl_fk_conflict            [ 49 pass ]   2241
            galera.galera_ddl_fk_conflict            [ 50 pass ]   2231
            --------------------------------------------------------------------------
            The servers were restarted 0 times
            Spent 113.315 of 155 seconds executing testcases
             
            Completed: All 50 tests were successful.
            

          janlindstrom Jan Lindström added a comment - Tested with 11.4-enterprise commit 79bfedaf1 and could not reproduce easily- Also tested with 11.4 commit 9e7762e71 could not reproduce easily. jan@jan-ThinkPad-P1-Gen-6:~/work/mariadb/11.4-enterprise/mysql-test$ ./mtr galera.galera_ddl_fk_conflict --repeat=50 --enable-disabled Logging: ./mtr galera.galera_ddl_fk_conflict --repeat=50 --enable-disabled VS config: vardir: /home/jan/work/mariadb/11.4-enterprise/mysql-test/var Checking leftover processes... Removing old var directory... Creating var directory '/home/jan/work/mariadb/11.4-enterprise/mysql-test/var'... Checking supported features... MariaDB Version 11.4.4-2-MariaDB-debug - SSL connections supported - binaries are debug compiled - binaries built with wsrep patch Collecting tests... - galera.galera_ddl_fk_conflict will be run although it's been disabled due to 'MENT-2172 galera_ddl_fk_conflict test failed due to timeout' Installing system database...   ==============================================================================   TEST RESULT TIME (ms) or COMMENT --------------------------------------------------------------------------   worker[01] Using MTR_BUILD_THREAD 300, with reserved ports 19000..19029 galera.galera_ddl_fk_conflict [ pass ] 2265 galera.galera_ddl_fk_conflict [ 2 pass ] 2275 galera.galera_ddl_fk_conflict [ 3 pass ] 2302 galera.galera_ddl_fk_conflict [ 4 pass ] 2239 galera.galera_ddl_fk_conflict [ 5 pass ] 2249 galera.galera_ddl_fk_conflict [ 6 pass ] 2287 galera.galera_ddl_fk_conflict [ 7 pass ] 2265 galera.galera_ddl_fk_conflict [ 8 pass ] 2264 galera.galera_ddl_fk_conflict [ 9 pass ] 2267 galera.galera_ddl_fk_conflict [ 10 pass ] 2272 galera.galera_ddl_fk_conflict [ 11 pass ] 2324 galera.galera_ddl_fk_conflict [ 12 pass ] 2230 galera.galera_ddl_fk_conflict [ 13 pass ] 2235 galera.galera_ddl_fk_conflict [ 14 pass ] 2315 galera.galera_ddl_fk_conflict [ 15 pass ] 2380 galera.galera_ddl_fk_conflict [ 16 pass ] 2281 galera.galera_ddl_fk_conflict [ 17 pass ] 2235 galera.galera_ddl_fk_conflict [ 18 pass ] 2265 galera.galera_ddl_fk_conflict [ 19 pass ] 2238 galera.galera_ddl_fk_conflict [ 20 pass ] 2319 galera.galera_ddl_fk_conflict [ 21 pass ] 2270 galera.galera_ddl_fk_conflict [ 22 pass ] 2257 galera.galera_ddl_fk_conflict [ 23 pass ] 2251 galera.galera_ddl_fk_conflict [ 24 pass ] 2274 galera.galera_ddl_fk_conflict [ 25 pass ] 2252 galera.galera_ddl_fk_conflict [ 26 pass ] 2233 galera.galera_ddl_fk_conflict [ 27 pass ] 2344 galera.galera_ddl_fk_conflict [ 28 pass ] 2241 galera.galera_ddl_fk_conflict [ 29 pass ] 2233 galera.galera_ddl_fk_conflict [ 30 pass ] 2232 galera.galera_ddl_fk_conflict [ 31 pass ] 2242 galera.galera_ddl_fk_conflict [ 32 pass ] 2298 galera.galera_ddl_fk_conflict [ 33 pass ] 2253 galera.galera_ddl_fk_conflict [ 34 pass ] 2390 galera.galera_ddl_fk_conflict [ 35 pass ] 2239 galera.galera_ddl_fk_conflict [ 36 pass ] 2233 galera.galera_ddl_fk_conflict [ 37 pass ] 2234 galera.galera_ddl_fk_conflict [ 38 pass ] 2227 galera.galera_ddl_fk_conflict [ 39 pass ] 2391 galera.galera_ddl_fk_conflict [ 40 pass ] 2226 galera.galera_ddl_fk_conflict [ 41 pass ] 2245 galera.galera_ddl_fk_conflict [ 42 pass ] 2232 galera.galera_ddl_fk_conflict [ 43 pass ] 2276 galera.galera_ddl_fk_conflict [ 44 pass ] 2261 galera.galera_ddl_fk_conflict [ 45 pass ] 2270 galera.galera_ddl_fk_conflict [ 46 pass ] 2214 galera.galera_ddl_fk_conflict [ 47 pass ] 2259 galera.galera_ddl_fk_conflict [ 48 pass ] 2259 galera.galera_ddl_fk_conflict [ 49 pass ] 2241 galera.galera_ddl_fk_conflict [ 50 pass ] 2231 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 113.315 of 155 seconds executing testcases   Completed: All 50 tests were successful.
          janlindstrom Jan Lindström added a comment - https://github.com/mariadb-corporation/MariaDBEnterprise/pull/104
          janlindstrom Jan Lindström added a comment - - edited

          sysprg I do not think this is related to ES only, I will move this to CS. Please apply my PR to earliest possible version.

          janlindstrom Jan Lindström added a comment - - edited sysprg I do not think this is related to ES only, I will move this to CS. Please apply my PR to earliest possible version.
          sysprg Julius Goryavsky added a comment - - edited

          Thanks, the fix has been merged with the head revision: https://github.com/MariaDB/server/commit/e53ffdee965b8d056faa15fd4e6513577b830438

          sysprg Julius Goryavsky added a comment - - edited Thanks, the fix has been merged with the head revision: https://github.com/MariaDB/server/commit/e53ffdee965b8d056faa15fd4e6513577b830438

          People

            sysprg Julius Goryavsky
            sysprg Julius Goryavsky
            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.