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

innodb.mdev-14846 fails in 11.0

    XMLWordPrintable

Details

    Description

      The failure looks like this:

      CURRENT_TEST: innodb.mdev-14846
      --- /home/buildbot/buildbot/build/mariadb-11.1.4/mysql-test/suite/innodb/r/mdev-14846.result	2023-11-24 15:03:29.000000000 +0000
      +++ /home/buildbot/buildbot/build/mariadb-11.1.4/mysql-test/suite/innodb/r/mdev-14846.reject	2023-11-24 17:55:45.075140470 +0000
      @@ -38,7 +38,7 @@
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
       1	PRIMARY	alias1	ALL	NULL	NULL	NULL	NULL	#	
       1	PRIMARY	alias2	ALL	NULL	NULL	NULL	NULL	#	Using where
      -2	DEPENDENT SUBQUERY	t1	ALL	NULL	NULL	NULL	NULL	#	Using where
      +2	MATERIALIZED	t1	ALL	NULL	NULL	NULL	NULL	#	
       UPDATE t3 AS alias1 LEFT JOIN t3 AS alias2 ON ( alias1.f1 <> alias1.f2 ) SET alias1.f3 = 59 WHERE ( EXISTS ( SELECT t1.f3 FROM t1 IGNORE INDEX (f1) WHERE t1.f1 = alias1.f1 ) ) OR alias2.f1 = 'h';
       connect  con2,localhost,root,,test;
       set debug_sync='now WAIT_FOR con2_dml';
      @@ -51,8 +51,8 @@
       1	PRIMARY	t1	index	NULL	f1	12	NULL	#	Using index
       1	PRIMARY	t1	ALL	NULL	NULL	NULL	NULL	#	
       1	PRIMARY	<subquery2>	eq_ref	distinct_key	distinct_key	13	func	#	
      -2	MATERIALIZED	t3	ALL	NULL	NULL	NULL	NULL	#	
       2	MATERIALIZED	t2	ALL	NULL	NULL	NULL	NULL	#	
      +2	MATERIALIZED	t3	ALL	NULL	NULL	NULL	NULL	#	
       UPDATE v4, t1 SET t1.pk = 76 WHERE t1.f2 IN ( SELECT t2.f FROM t2 INNER JOIN t3 );
       connection default;
       ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
      

      Attachments

        1. bad-trace.log
          12 kB
          Sergei Petrunia
        2. good-trace.log
          13 kB
          Sergei Petrunia

        Issue Links

          Activity

            People

              psergei Sergei Petrunia
              psergei Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.