[MDEV-32482] Server crashes in thr_upgrade_write_delay_lock upon INSERT DELAYED in OQGraph table Created: 2023-10-16  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - OQGRAPH
Affects Version/s: 10.4, 10.5, 10.6, 10.10, 10.11, 11.0, 11.1, 11.2
Fix Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: 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


Generated at Thu Feb 08 10:31:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.