INSTALL PLUGIN Spider SONAME 'ha_spider.so';

CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET'../socket.sock',DATABASE'',USER'',PASSWORD '');  # Socket location must be valid. Other values not.

CREATE TABLE t (a INT KEY,b INT UNIQUE) ENGINE=InnoDB;

CREATE TABLE t2 (id INT,id2 INT,UNIQUE (id,id2),CONSTRAINT t_id_fk FOREIGN KEY(id2,id) REFERENCES t (id,id2)) ENGINE=Spider COMMENT='WRAPPER "mysql",srv "srv",TABLE "t"';

LOCK TABLES t WRITE,t2 WRITE;

10.11.1-dbg>show processlist;

+----+-------------+-----------+------+---------+------+----------------------------------------------------+------------------------------+----------+

| Id | User        | Host      | db   | Command | Time | State                                              | Info                         | Progress |

+----+-------------+-----------+------+---------+------+----------------------------------------------------+------------------------------+----------+

|  4 | root        | localhost | test | Query   |  129 | System lock                                        | LOCK TABLES t WRITE,t2 WRITE |    0.000 |

|  5 | system user |           | NULL | Sleep   |  129 | Reset for next command                             | NULL                         |    0.000 |

|  6 | system user |           | NULL | Daemon  | NULL | Spider table background statistics action handler  | NULL                         |    0.000 |

|  7 | system user |           | NULL | Daemon  | NULL | Spider table background statistics action handler  | NULL                         |    0.000 |

|  8 | system user |           | NULL | Daemon  | NULL | Spider table background statistics action handler  | NULL                         |    0.000 |

|  9 | system user |           | NULL | Daemon  | NULL | Spider table background statistics action handler  | NULL                         |    0.000 |

| 10 | system user |           | NULL | Daemon  | NULL | Spider table background statistics action handler  | NULL                         |    0.000 |

| 11 | system user |           | NULL | Daemon  | NULL | Spider table background statistics action handler  | NULL                         |    0.000 |

| 12 | system user |           | NULL | Daemon  | NULL | Spider table background statistics action handler  | NULL                         |    0.000 |

| 13 | system user |           | NULL | Daemon  | NULL | Spider table background statistics action handler  | NULL                         |    0.000 |

| 14 | system user |           | NULL | Daemon  | NULL | Spider table background statistics action handler  | NULL                         |    0.000 |

| 15 | system user |           | NULL | Daemon  | NULL | Spider table background cardinality action handler | NULL                         |    0.000 |

| 16 | system user |           | NULL | Daemon  | NULL | Spider table background cardinality action handler | NULL                         |    0.000 |

| 17 | system user |           | NULL | Daemon  | NULL | Spider table background cardinality action handler | NULL                         |    0.000 |

| 18 | system user |           | NULL | Daemon  | NULL | Spider table background cardinality action handler | NULL                         |    0.000 |

| 19 | system user |           | NULL | Daemon  | NULL | Spider table background cardinality action handler | NULL                         |    0.000 |

| 20 | system user |           | NULL | Daemon  | NULL | Spider table background cardinality action handler | NULL                         |    0.000 |

| 21 | system user |           | NULL | Daemon  | NULL | Spider table background cardinality action handler | NULL                         |    0.000 |

| 22 | system user |           | NULL | Daemon  | NULL | Spider table background cardinality action handler | NULL                         |    0.000 |

| 23 | system user |           | NULL | Daemon  | NULL | Spider table background cardinality action handler | NULL                         |    0.000 |

| 24 | system user |           | NULL | Daemon  | NULL | Spider table background cardinality action handler | NULL                         |    0.000 |

| 25 |             | localhost | test | Query   |  129 | Waiting for table metadata lock                    | lock tables `test`.`t` write |    0.000 |

| 26 | root        | localhost | test | Query   |    0 | starting                                           | show processlist             |    0.000 |

+----+-------------+-----------+------+---------+------+----------------------------------------------------+------------------------------+----------+

23 rows in set (0.000 sec)

INSTALL PLUGIN Spider SONAME 'ha_spider.so';

CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET'',DATABASE'',USER'',PASSWORD '');

CREATE TABLE t (a INT) ENGINE=Spider;

CREATE TABLE t2 (b INT) ENGINE=Spider COMMENT='WRAPPER "mysql",srv "srv",TABLE "t"';

LOCK TABLES t AS a READ,t2 AS b WRITE;

DROP TABLE t2;

CREATE TABLE t2 (c INT) ENGINE=Spider COMMENT='WRAPPER "mysql",srv "srv",TABLE "t"';

LOCK TABLES t2 WRITE;

Core was generated by `/test/MD221022-mariadb-10.11.1-linux-x86_64-dbg/bin/mysqld --no-defaults --core'.

Program terminated with signal SIGSEGV, Segmentation fault.

#0  spider_string::length (this=0x2) at /test/10.11_dbg/sql/sql_string.h:278

278	  inline uint32 length() const { return str_length;}

[Current thread is 1 (Thread 0x14ebf40e5700 (LWP 2669643))]

(gdb) bt

#0  spider_string::length (this=0x2) at /test/10.11_dbg/sql/sql_string.h:278

#1  0x000014ebe814292a in spider_link_get_key (link_for_hash=0x14eb840c4638, length=0x14ebf40e38f8, not_used=<optimized out>) at /test/10.11_dbg/storage/spider/spd_table.cc:385

#2  0x000055fdabd7937c in my_hash_key (first=1 '\001', length=0x14ebf40e38f8, record=<optimized out>, hash=0x14eb840c5308) at /test/10.11_dbg/mysys/hash.c:196

#3  hashcmp (hash=hash@entry=0x14eb840c5308, pos=pos@entry=0x14eb840c53c8, key=key@entry=0x14eb84057d38 "`test`.`t`", length=length@entry=10) at /test/10.11_dbg/mysys/hash.c:379

#4  0x000055fdabd795aa in my_hash_first_from_hash_value (hash=hash@entry=0x14eb840c5308, hash_value=<optimized out>, key=0x14eb84057d38 "`test`.`t`", length=length@entry=10, current_record=current_record@entry=0x14ebf40e399c) at /test/10.11_dbg/mysys/hash.c:290

#5  0x000055fdabd795fb in my_hash_search_using_hash_value (hash=hash@entry=0x14eb840c5308, hash_value=<optimized out>, key=<optimized out>, length=length@entry=10) at /test/10.11_dbg/mysys/hash.c:244

#6  0x000014ebe81a0324 in spider_mbase_handler::append_lock_tables_list (this=0x14eb840c4190, conn=0x14eb840c4698, link_idx=0, appended=0x14ebf40e3a1c) at /test/10.11_dbg/storage/spider/spd_db_mysql.cc:13130

#7  0x000014ebe818da6e in ha_spider::append_lock_tables_list (this=this@entry=0x14eb840c8080) at /test/10.11_dbg/storage/spider/ha_spider.cc:12081

#8  0x000014ebe818deac in ha_spider::store_lock (this=0x14eb840c8080, thd=0x14eb84000d48, to=0x14eb840c2b88, lock_type=TL_WRITE) at /test/10.11_dbg/storage/spider/ha_spider.cc:775

#9  0x000055fdab7e5d40 in get_lock_data (thd=thd@entry=0x14eb84000d48, table_ptr=table_ptr@entry=0x14eb84013bc8, count=count@entry=1, flags=flags@entry=1) at /test/10.11_dbg/sql/sql_string.h:655

#10 0x000055fdab7e6160 in mysql_lock_tables (thd=thd@entry=0x14eb84000d48, tables=tables@entry=0x14eb84013bc8, count=count@entry=1, flags=flags@entry=0) at /test/10.11_dbg/sql/lock.cc:301

#11 0x000055fdab316af1 in lock_tables (thd=thd@entry=0x14eb84000d48, tables=0x14eb840132f0, count=<optimized out>, flags=flags@entry=0) at /test/10.11_dbg/sql/sql_base.cc:5821

#12 0x000055fdab392240 in lock_tables_open_and_lock_tables (thd=thd@entry=0x14eb84000d48, tables=<optimized out>) at /test/10.11_dbg/sql/sql_parse.cc:2958

#13 0x000055fdab39dd2e in mysql_execute_command (thd=thd@entry=0x14eb84000d48, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.11_dbg/sql/sql_parse.cc:5124

#14 0x000055fdab388f90 in mysql_parse (thd=thd@entry=0x14eb84000d48, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14ebf40e4300) at /test/10.11_dbg/sql/sql_parse.cc:8023

#15 0x000055fdab3964ac in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14eb84000d48, packet=packet@entry=0x14eb8400af09 "LOCK TABLES t2 WRITE", packet_length=packet_length@entry=20, blocking=blocking@entry=true) at /test/10.11_dbg/sql/sql_class.h:1346

#16 0x000055fdab3988f4 in do_command (thd=0x14eb84000d48, blocking=blocking@entry=true) at /test/10.11_dbg/sql/sql_parse.cc:1407

#17 0x000055fdab4f5067 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55fdadcf08d8, put_in_cache=put_in_cache@entry=true) at /test/10.11_dbg/sql/sql_connect.cc:1416

#18 0x000055fdab4f5536 in handle_one_connection (arg=0x55fdadcf08d8) at /test/10.11_dbg/sql/sql_connect.cc:1318

#19 0x000014ec0df61609 in start_thread (arg=<optimized out>) at pthread_create.c:477

#20 0x000014ec0db4d133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95