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

Server crashes in thr_upgrade_write_delay_lock upon INSERT DELAYED in OQGraph table

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.4(EOL), 10.5, 10.6, 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL)
    • 10.5, 10.6, 10.11
    • None

    Description

      Set to minor because the test case is meaningless, and besides OQGraph isn't used anymore

      --source include/have_innodb.inc
       
      INSTALL SONAME 'ha_oqgraph';
       
      CREATE TABLE oq_backing (origid INT UNSIGNED NOT NULL, destid INT UNSIGNED NOT NULL, PRIMARY KEY (origid, destid), KEY (destid)) ENGINE=InnoDB;
      CREATE TABLE oq (latch VARCHAR(32) NULL, origid BIGINT UNSIGNED NULL, destid BIGINT UNSIGNED NULL, weight DOUBLE NULL, seq BIGINT UNSIGNED NULL, linkid BIGINT UNSIGNED NULL, KEY (latch, origid, destid) USING HASH, KEY (latch, destid, origid) USING HASH) ENGINE=OQGRAPH data_table='oq_backing' origid='origid' destid='destid';
      INSERT DELAYED INTO oq VALUES (1,1,1,1,1,1);
       
      # Cleanup
      DROP TABLE oq;
      DROP TABLE oq_backing;
      UNINSTALL SONAME 'ha_oqgraph';
      

      10.4 c8866892

      #3  <signal handler called>
      #4  0x00005618d0aa899c in thr_upgrade_write_delay_lock (data=0xbebebebebebebebe, new_lock_type=TL_WRITE, lock_wait_timeout=31536000) at /data/src/10.4/mysys/thr_lock.c:1438
      #5  0x00005618cee3f1ce in Delayed_insert::handle_inserts (this=0x62c0000b8208) at /data/src/10.4/sql/sql_insert.cc:3386
      #6  0x00005618cee3e25d in handle_delayed_insert (arg=0x62c0000b8208) at /data/src/10.4/sql/sql_insert.cc:3255
      #7  0x00005618cff45140 in pfs_spawn_thread (arg=0x615000041d08) at /data/src/10.4/storage/perfschema/pfs.cc:1869
      #8  0x00007f5cab6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #9  0x00007f5cab7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.