Details

    • Technical task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.2
    • N/A
    • Tests
    • None

    Description

      test from mysql 5.7, here https://github.com/MariaDB/server/tree/bb-10.2-alice/mysql-test/suite/innodb/t/innodb_deadlock_with_autoinc.test

      innodb.innodb_deadlock_with_autoinc 'innodb' [ fail ]
              Test ended at 2017-11-10 14:00:05
       
      CURRENT_TEST: innodb.innodb_deadlock_with_autoinc
      mysqltest: At line 44: query 'reap' failed: 1213: Deadlock found when trying to get lock; try restarting transaction
       
      The result from queries just before the failure was:
      < snip >
      # Bug #21983865  UNEXPECTED DEADLOCK WITH INNODB_AUTOINC_LOCK_MODE=0
      #
      create table t1(f1 int not null auto_increment primary key) engine=innodb;
      # Hold autoinc_lock on table t1 from connection con1
      connect  con1, localhost, root;
      set debug_sync='ib_after_row_insert SIGNAL others WAIT_FOR continue_others';
      insert into t1 values(NULL);
      connection default;
      # Create 40 connections and make it to wait for autoinc_lock on table t1.
      # Release the auto_inc lock on table t1 for connection con1
      set debug_sync='now SIGNAL continue_others';
      # Now all 40 connections can finish the insert operation on t1.
      connection default;
      disconnect con40;
      connection con1;
      connection default;
      disconnect con1;
      connection con2;
      
      

      Attachments

        Activity

          People

            marko Marko Mäkelä
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.