Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5, 10.6, 10.7(EOL), 10.8(EOL)
Description
Another INSERT DELAYED bug/stack in combination with Spider. This one is a regression in 10.5. Does not look to be sporadic, though could be due to the DELAYED.
INSTALL PLUGIN spider SONAME 'ha_spider.so'; |
SET sql_mode=''; |
CREATE TABLE t (a INT) ENGINE=SPIDER; |
INSERT DELAYED INTO t VALUES (1); |
INSERT DELAYED INTO t VALUES (1); |
SELECT 1; # Shows server is gone |
Leads to:
10.7.2 06988bdcaa2d1af2c178c199b7f65dbafda45a2c (Debug) |
Core was generated by `/test/MD121121-mariadb-10.7.2-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
|
Program terminated with signal SIGSEGV, Segmentation fault.
|
#0 0x0000148d7c81d1e3 in spider_db_bulk_insert (
|
spider=spider@entry=0x148cf4004d70, table=0x148cf4004498,
|
copy_info=copy_info@entry=0x148cf4005160, bulk_end=bulk_end@entry=false)
|
at /test/10.7_dbg/storage/spider/spd_db_conn.cc:6714
|
[Current thread is 1 (Thread 0x148d900ea700 (LWP 2786829))]
|
(gdb) bt
|
#0 0x0000148d7c81d1e3 in spider_db_bulk_insert (spider=spider@entry=0x148cf4004d70, table=0x148cf4004498, copy_info=copy_info@entry=0x148cf4005160, bulk_end=bulk_end@entry=false) at /test/10.7_dbg/storage/spider/spd_db_conn.cc:6714
|
#1 0x0000148d7c8aa51c in ha_spider::write_row (this=0x148cf4004d70, buf=0x148cf40048e8 "\375\001") at /test/10.7_dbg/storage/spider/ha_spider.cc:10039
|
#2 0x000055d4476d2559 in handler::ha_write_row (this=0x148cf4004d70, buf=0x148cf40048e8 "\375\001") at /test/10.7_dbg/sql/handler.cc:7516
|
#3 0x000055d447371eee in write_record (thd=thd@entry=0x148d4c07c768, table=0x148cf4004498, info=info@entry=0x148d4c083508, sink=sink@entry=0x0) at /test/10.7_dbg/sql/sql_insert.cc:2156
|
#4 0x000055d4473749c0 in Delayed_insert::handle_inserts (this=this@entry=0x148d4c07c748) at /test/10.7_dbg/sql/sql_insert.cc:3597
|
#5 0x000055d447376439 in handle_delayed_insert (arg=arg@entry=0x148d4c07c748) at /test/10.7_dbg/sql/sql_insert.cc:3337
|
#6 0x000055d4479bb4ca in pfs_spawn_thread (arg=0x55d44ad00a18) at /test/10.7_dbg/storage/perfschema/pfs.cc:2201
|
#7 0x0000148d92e22609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#8 0x0000148d92a10293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 10.5.14 (dbg), 10.6.6 (dbg), 10.7.2 (dbg), 10.8.0 (dbg)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.2.42 (dbg), 10.2.42 (opt), 10.3.33 (dbg), 10.3.33 (opt), 10.4.23 (dbg), 10.4.23 (opt), 10.5.14 (opt), 10.6.6 (opt), 10.7.2 (opt), 10.8.0 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.36 (dbg), 5.7.36 (opt), 8.0.27 (dbg), 8.0.27 (opt)
Attachments
Issue Links
- relates to
-
MDEV-26582 SIGSEGV in spider_db_bulk_insert and spider_db_connect and spider_db_before_query, and hang in "End of update loop" / "Reset for next command" query states
- Closed
-
MDEV-28764 SIGSEGV in spider_db_set_names_internal on INSERT
- Open
-
MDEV-26583 SIGSEGV's in spider_get_select_limit_from_select_lex when DELAYED INSERT is used
- Closed