Details
- 
    Bug 
- 
    Status: Closed (View Workflow)
- 
    Critical 
- 
    Resolution: Fixed
- 
    10.6, 10.4(EOL), 10.5(EOL), 10.7(EOL), 10.8(EOL)
Description
Repeat till it crashes. Sporadic or delayed due to INSERT DELAYED.
| DROP DATABASE test; | 
| CREATE DATABASE test; | 
| USE test; | 
| INSTALL PLUGIN spider SONAME 'ha_spider.so'; | 
| CREATE SERVER d FOREIGN DATA WRAPPER mysql OPTIONS (HOST'',DATABASE'',USER'',PORT 10000,PASSWORD''); | 
| SET SESSION spider_same_server_link=ON; | 
| CREATE TABLE t (c INT AUTO_INCREMENT KEY,c2 INT,INDEX i (c2)) ENGINE=SPIDER ROW_FORMAT=COMPRESSED; | 
| INSERT DELAYED INTO t VALUES (0,0),(0,0),(0,0); | 
| SELECT SLEEP (3); | 
Leads to:
| 10.7.0 1bc82aaf0a7746c0921a94034aff2d51f0d75cd0 (Debug) | 
| Core was generated by `/test/MD040921-mariadb-10.7.0-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'. | 
| Program terminated with signal SIGSEGV, Segmentation fault. | 
| #0  0x000014a4b2f06e9d in spider_get_select_limit_from_select_lex ( | 
|     select_lex=0x14a484014468, select_limit=select_limit@entry=0x14a4c010ab90,  | 
|     offset_limit=offset_limit@entry=0x14a4c010ab98) | 
|     at /test/10.7_dbg/storage/spider/spd_table.cc:8967 | 
| [Current thread is 1 (Thread 0x14a4c010c700 (LWP 585154))] | 
| (gdb) bt | 
| #0  0x000014a4b2f06e9d in spider_get_select_limit_from_select_lex (select_lex=0x14a484014468, select_limit=select_limit@entry=0x14a4c010ab90, offset_limit=offset_limit@entry=0x14a4c010ab98) at /test/10.7_dbg/storage/spider/spd_table.cc:8967 | 
| #1  0x000014a4b2f06f59 in spider_get_select_limit (spider=spider@entry=0x14a430005010, select_lex=select_lex@entry=0x14a4c010ab88, select_limit=select_limit@entry=0x14a4c010ab90, offset_limit=offset_limit@entry=0x14a4c010ab98) at /test/10.7_dbg/storage/spider/spd_table.cc:8983 | 
| #2  0x000014a4b2f070d0 in spider_split_read_param (spider=spider@entry=0x14a430005010) at /test/10.7_dbg/storage/spider/spd_table.cc:9020 | 
| #3  0x000014a4b2f07903 in spider_set_result_list_param (spider=spider@entry=0x14a430005010) at /test/10.7_dbg/storage/spider/spd_table.cc:8439 | 
| #4  0x000014a4b2f554ab in ha_spider::index_init (this=this@entry=0x14a430005010, idx=0, sorted=sorted@entry=true) at /test/10.7_dbg/storage/spider/ha_spider.cc:1778 | 
| #5  0x000014a4b2f55714 in ha_spider::get_auto_increment (this=0x14a430005010, offset=<optimized out>, increment=1, nb_desired_values=1, first_value=0x14a4c010b990, nb_reserved_values=0x14a4c010b998) at /test/10.7_dbg/storage/spider/ha_spider.cc:9800 | 
| #6  0x0000555b9fd59227 in handler::update_auto_increment (this=this@entry=0x14a430005010) at /test/10.7_dbg/sql/handler.cc:3954 | 
| #7  0x000014a4b2f3b52c in ha_spider::update_auto_increment (this=this@entry=0x14a430005010) at /test/10.7_dbg/storage/spider/ha_spider.cc:9755 | 
| #8  0x000014a4b2f574f3 in ha_spider::write_row (this=0x14a430005010, buf=0x14a430004b88 <incomplete sequence \375>) at /test/10.7_dbg/storage/spider/ha_spider.cc:10014 | 
| #9  0x0000555b9fd610b5 in handler::ha_write_row (this=0x14a430005010, buf=0x14a430004b88 <incomplete sequence \375>) at /test/10.7_dbg/sql/handler.cc:7514 | 
| #10 0x0000555b9fa0533a in write_record (thd=thd@entry=0x14a48409c948, table=0x14a430001cc8, info=info@entry=0x14a4840a35e8, sink=sink@entry=0x0) at /test/10.7_dbg/sql/sql_insert.cc:2135 | 
| #11 0x0000555b9fa07e0c in Delayed_insert::handle_inserts (this=this@entry=0x14a48409c928) at /test/10.7_dbg/sql/sql_insert.cc:3576 | 
| #12 0x0000555b9fa09885 in handle_delayed_insert (arg=arg@entry=0x14a48409c928) at /test/10.7_dbg/sql/sql_insert.cc:3316 | 
| #13 0x0000555ba0033ade in pfs_spawn_thread (arg=0x555ba32c7418) at /test/10.7_dbg/storage/perfschema/pfs.cc:2201 | 
| #14 0x000014a4d64db609 in start_thread (arg=<optimized out>) at pthread_create.c:477 | 
| #15 0x000014a4d60c9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
 | 
Bug confirmed present in:
MariaDB: 10.4.22 (dbg), 10.5.13 (dbg), 10.6.5 (dbg), 10.7.0 (dbg)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.2.41 (dbg), 10.2.41 (opt), 10.3.32 (dbg), 10.3.32 (opt), 10.4.22 (opt), 10.5.13 (opt), 10.6.5 (opt), 10.7.0 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.35 (dbg), 5.7.35 (opt), 8.0.26 (dbg), 8.0.26 (opt)
Attachments
Issue Links
- relates to
- 
                    MDEV-24769 Spider crash when selecting all rows from the partitioned table -         
- Closed
 
-         
- 
                    MDEV-27231 Spider: SIGSEGV in spider_db_bulk_insert on INSERT DELAYED -         
- Closed
 
-         
- 
                    MDEV-28406 Spider: SIGSEGV in ha_spider::index_last_internal on INSERT DELAYED -         
- Closed
 
-         
- 
                    MDEV-24769 Spider crash when selecting all rows from the partitioned table -         
- Closed
 
-         
- 
                    MDEV-34735 Hang, ASANs, Assertion `len > alloc_length' failed in Binary_string::realloc_raw and SIGSEGV in spider_get_select_limit_from_select_lex -         
- Confirmed
 
-