-- 5.6.26 source build -- Downloaded https://github.com/xiezhenye/mysql-plugin-spider-engine -- extracted files into storage/spider [umshastr@hod03]/export/umesh/server/source/mysql-5.6.26:cmake . -DBUILD_CONFIG=mysql_release -DCMAKE_INSTALL_PREFIX=/export/umesh/server/source/mysql-5.6.26 [umshastr@hod03]/export/umesh/server/source/mysql-5.6.26:make [umshastr@hod03]/export/umesh/server/source/mysql-5.6.26:make install [umshastr@hod03]/export/umesh/server/source/mysql-5.6.26:scripts/mysql_install_db --basedir=/export/umesh/server/source/mysql-5.6.26 --datadir=/export/umesh/server/source/mysql-5.6.26/bug78050 [umshastr@hod03]/export/umesh/server/source/mysql-5.6.26:bin/mysqld --no-defaults --basedir=/export/umesh/server/source/mysql-5.6.26 --datadir=/export/umesh/server/source/mysql-5.6.26/bug78050 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/source/mysql-5.6.26/bug78050/log.err 2>&1 & [umshastr@hod03]/export/umesh/server/source/mysql-5.6.26:bin/mysql -uroot -S /tmp/mysql_ushastry.sock < share/install_spider.sql [umshastr@hod03]/export/umesh/server/source/mysql-5.6.26: bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.6.26 MySQL Community Server (GPL) Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show plugins; +----------------------------+----------+--------------------+--------------+---------+ | Name | Status | Type | Library | License | +----------------------------+----------+--------------------+--------------+---------+ | binlog | ACTIVE | STORAGE ENGINE | NULL | GPL | . | partition | ACTIVE | STORAGE ENGINE | NULL | GPL | | SPIDER | ACTIVE | STORAGE ENGINE | ha_spider.so | GPL | | SPIDER_ALLOC_MEM | ACTIVE | INFORMATION SCHEMA | ha_spider.so | GPL | +----------------------------+----------+--------------------+--------------+---------+ 44 rows in set (0.00 sec) mysql> drop database if exists spider_innodb; create database spider_innodb; use spider_innodb; create table t_spider ( i int not null auto_increment, primary key (i), f varchar (128) ) engine = SPIDER; create table t_inno ( i int not null auto_increment, primary key (i), f varchar (128) ) engine = innodb; start transaction; insert into t_spider (f) values ( 'abc'), ('def' ); insert into t_inno (f) values ( 'abc'), ('def' ); commit; -- [umshastr@hod03]/export/umesh/server/source/mysql-5.6.26: bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.26 MySQL Community Server (GPL) Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> drop database if exists spider_innodb; Query OK, 2 rows affected (0.01 sec) mysql> create database spider_innodb; Query OK, 1 row affected (0.00 sec) mysql> use spider_innodb; Database changed mysql> create table t_spider ( i int not null auto_increment, primary key (i), f varchar (128) ) engine = SPIDER; Query OK, 0 rows affected (0.00 sec) mysql> create table t_inno ( i int not null auto_increment, primary key (i), f varchar (128) ) engine = innodb; Query OK, 0 rows affected (0.00 sec) mysql> start transaction; Query OK, 0 rows affected (0.00 sec) mysql> insert into t_spider (f) values ( 'abc'), ('def' ); insert into t_inno (f) values ( 'abc'), ('def' ); commit; ERROR 1429 (HY000): Unable to connect to foreign data source: localhost mysql> insert into t_inno (f) values ( 'abc'), ('def' ); Query OK, 2 rows affected (0.00 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> commit; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> \q Bye [1]+ Segmentation fault (core dumped) bin/mysqld --no-defaults --basedir=/export/umesh/server/source/mysql-5.6.26 --datadir=/export/umesh/server/source/mysql-5.6.26/bug78050 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/source/mysql-5.6.26/bug78050/log.err 2>&1 [umshastr@hod03]/export/umesh/server/source/mysql-5.6.26: [umshastr@hod03]/export/umesh/server/source/mysql-5.6.26: gdb bin/mysqld bug78050/core.24476 [umshastr@hod03]/export/umesh/server/source/mysql-5.6.26: gdb bin/mysqld bug78050/core.24476 GNU gdb (GDB) Red Hat Enterprise Linux 7.6.1-51.el7 Copyright (C) 2013 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "x86_64-redhat-linux-gnu". For bug reporting instructions, please see: ... Reading symbols from /export/umesh/server/source/mysql-5.6.26/bin/mysqld...done. [New LWP 24499] [New LWP 24489] [New LWP 24483] [New LWP 24480] [New LWP 24495] [New LWP 24494] [New LWP 24479] [New LWP 24476] [New LWP 24496] [New LWP 24491] [New LWP 24486] [New LWP 24497] [New LWP 24490] [New LWP 24484] [New LWP 24493] [New LWP 24485] [New LWP 24478] [New LWP 24477] [New LWP 24482] [New LWP 24481] [New LWP 24492] [New LWP 24488] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `bin/mysqld --no-defaults --basedir=/export/umesh/server/source/mysql-5.6.26 --d'. Program terminated with signal 11, Segmentation fault. #0 0x00007fc7bb495771 in pthread_kill () from /lib64/libpthread.so.0 Missing separate debuginfos, use: debuginfo-install glibc-2.17-55.0.4.el7_0.1.x86_64 libaio-0.3.109-12.el7.x86_64 libgcc-4.8.2-16.2.el7_0.x86_64 libstdc++-4.8.2-16.2.el7_0.x86_64 nss-softokn-freebl-3.16.2-1.el7_0.x86_64 (gdb) bt #0 0x00007fc7bb495771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x000000000066d80d in handle_fatal_signal (sig=11) at /export/umesh/server/source/mysql-5.6.26/sql/signal_handler.cc:230 #2 #3 0x000000000065d45c in TC_LOG_MMAP::log_xid (this=this@entry=0x132dea0 , thd=thd@entry=0x3012ce0, xid=13) at /export/umesh/server/source/mysql-5.6.26/sql/log.cc:2744 #4 0x000000000065da8d in TC_LOG_MMAP::commit (this=0x132dea0 , thd=0x3012ce0, all=) at /export/umesh/server/source/mysql-5.6.26/sql/log.cc:2677 #5 0x00000000005b5504 in ha_commit_trans (thd=thd@entry=0x3012ce0, all=all@entry=true, ignore_global_read_lock=ignore_global_read_lock@entry=false) at /export/umesh/server/source/mysql-5.6.26/sql/handler.cc:1436 #6 0x000000000076ac6e in trans_commit (thd=thd@entry=0x3012ce0) at /export/umesh/server/source/mysql-5.6.26/sql/transaction.cc:228 #7 0x00000000006e96dc in mysql_execute_command (thd=thd@entry=0x3012ce0) at /export/umesh/server/source/mysql-5.6.26/sql/sql_parse.cc:4280 #8 0x00000000006ecbd8 in mysql_parse (thd=thd@entry=0x3012ce0, rawbuf=, length=, parser_state=parser_state@entry=0x7fc790edd730) at /export/umesh/server/source/mysql-5.6.26/sql/sql_parse.cc:6386 #9 0x00000000006ee3d7 in dispatch_command (command=COM_QUERY, thd=0x3012ce0, packet=, packet_length=) at /export/umesh/server/source/mysql-5.6.26/sql/sql_parse.cc:1340 #10 0x00000000006f00c4 in do_command (thd=) at /export/umesh/server/source/mysql-5.6.26/sql/sql_parse.cc:1037 #11 0x00000000006bbfb2 in do_handle_one_connection (thd_arg=thd_arg@entry=0x3012ce0) at /export/umesh/server/source/mysql-5.6.26/sql/sql_connect.cc:982 #12 0x00000000006bc060 in handle_one_connection (arg=arg@entry=0x3012ce0) at /export/umesh/server/source/mysql-5.6.26/sql/sql_connect.cc:898 #13 0x0000000000aca763 in pfs_spawn_thread (arg=0x311e860) at /export/umesh/server/source/mysql-5.6.26/storage/perfschema/pfs.cc:1860 #14 0x00007fc7bb490df3 in start_thread () from /lib64/libpthread.so.0 #15 0x00007fc7ba36447d in clone () from /lib64/libc.so.6 (gdb)