|
Thanks for taking a look, Daniel!
Each of the items you requested follows.
CREATE TABLE statements:
MariaDB [(none)]> show create table onsite_assessment.mmic_focuses;
|
+--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| mmic_focuses | CREATE TABLE `mmic_focuses` (
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
|
`onsite_consult_id` int(10) unsigned NOT NULL,
|
`created_at` timestamp NULL DEFAULT NULL,
|
`updated_at` timestamp NULL DEFAULT NULL,
|
`deleted_at` timestamp NULL DEFAULT NULL,
|
PRIMARY KEY (`id`),
|
KEY `fk_ltc_focuses_rt_onsite_consults_consult_id` (`onsite_consult_id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |
|
+--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.00 sec)
|
|
MariaDB [(none)]> show create table onsite_assessment.mmic_sub_focuses;
|
+------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| mmic_sub_focuses | CREATE TABLE `mmic_sub_focuses` (
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
|
`focus_id` int(10) unsigned NOT NULL,
|
`created_at` timestamp NULL DEFAULT NULL,
|
`updated_at` timestamp NULL DEFAULT NULL,
|
`deleted_at` timestamp NULL DEFAULT NULL,
|
PRIMARY KEY (`id`),
|
KEY `fk_ltc_subfocuses_ltc_focus_ltc_focus_id` (`focus_id`),
|
CONSTRAINT `fk_ltc_subfocuses_ltc_focus_ltc_focus_id` FOREIGN KEY (`focus_id`) REFERENCES `mmic_focuses` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
|
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |
|
+------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.00 sec)
|
Indexes:
MariaDB [(none)]> show index from onsite_assessment.mmic_focuses;
|
+--------------+------------+----------------------------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
|
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
|
+--------------+------------+----------------------------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
|
| mmic_focuses | 0 | PRIMARY | 1 | id | A | 30 | NULL | NULL | | BTREE | | |
|
| mmic_focuses | 1 | fk_ltc_focuses_rt_onsite_consults_consult_id | 1 | onsite_consult_id | A | 10 | NULL | NULL | | BTREE | | |
|
+--------------+------------+----------------------------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
|
2 rows in set (0.00 sec)
|
|
MariaDB [(none)]> show index from onsite_assessment.mmic_sub_focuses;
|
+------------------+------------+------------------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
|
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
|
+------------------+------------+------------------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
|
| mmic_sub_focuses | 0 | PRIMARY | 1 | id | A | 95 | NULL | NULL | | BTREE | | |
|
| mmic_sub_focuses | 1 | fk_ltc_subfocuses_ltc_focus_ltc_focus_id | 1 | focus_id | A | 47 | NULL | NULL | | BTREE | | |
|
+------------------+------------+------------------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
|
2 rows in set (0.01 sec)
|
EXPLAIN for query noted in segfault message:
+------+--------------+------------------+--------+------------------------------------------------------+--------------+---------+------+------+-------------+
|
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|
+------+--------------+------------------+--------+------------------------------------------------------+--------------+---------+------+------+-------------+
|
| 1 | PRIMARY | mmic_focuses | ALL | PRIMARY,fk_ltc_focuses_rt_onsite_consults_consult_id | NULL | NULL | NULL | 30 | Using where |
|
| 1 | PRIMARY | <subquery10> | eq_ref | distinct_key | distinct_key | 4 | func | 1 | |
|
| 1 | PRIMARY | <subquery9> | eq_ref | distinct_key | distinct_key | 4 | func | 1 | |
|
| 1 | PRIMARY | <subquery8> | eq_ref | distinct_key | distinct_key | 4 | func | 1 | |
|
| 1 | PRIMARY | <subquery7> | eq_ref | distinct_key | distinct_key | 4 | func | 1 | |
|
| 1 | PRIMARY | <subquery6> | eq_ref | distinct_key | distinct_key | 4 | func | 1 | |
|
| 1 | PRIMARY | <subquery5> | eq_ref | distinct_key | distinct_key | 4 | func | 1 | |
|
| 1 | PRIMARY | <subquery4> | eq_ref | distinct_key | distinct_key | 4 | func | 1 | |
|
| 1 | PRIMARY | <subquery3> | eq_ref | distinct_key | distinct_key | 4 | func | 1 | |
|
| 1 | PRIMARY | <subquery2> | eq_ref | distinct_key | distinct_key | 4 | func | 1 | |
|
| 10 | MATERIALIZED | mmic_sub_focuses | range | PRIMARY,fk_ltc_subfocuses_ltc_focus_ltc_focus_id | PRIMARY | 4 | NULL | 94 | Using where |
|
| 9 | MATERIALIZED | mmic_sub_focuses | range | PRIMARY,fk_ltc_subfocuses_ltc_focus_ltc_focus_id | PRIMARY | 4 | NULL | 94 | Using where |
|
| 8 | MATERIALIZED | mmic_sub_focuses | range | PRIMARY,fk_ltc_subfocuses_ltc_focus_ltc_focus_id | PRIMARY | 4 | NULL | 95 | Using where |
|
| 7 | MATERIALIZED | mmic_sub_focuses | range | PRIMARY,fk_ltc_subfocuses_ltc_focus_ltc_focus_id | PRIMARY | 4 | NULL | 94 | Using where |
|
| 6 | MATERIALIZED | mmic_sub_focuses | range | PRIMARY,fk_ltc_subfocuses_ltc_focus_ltc_focus_id | PRIMARY | 4 | NULL | 94 | Using where |
|
| 5 | MATERIALIZED | mmic_sub_focuses | range | PRIMARY,fk_ltc_subfocuses_ltc_focus_ltc_focus_id | PRIMARY | 4 | NULL | 94 | Using where |
|
| 4 | MATERIALIZED | mmic_sub_focuses | range | PRIMARY,fk_ltc_subfocuses_ltc_focus_ltc_focus_id | PRIMARY | 4 | NULL | 94 | Using where |
|
| 3 | MATERIALIZED | mmic_sub_focuses | range | PRIMARY,fk_ltc_subfocuses_ltc_focus_ltc_focus_id | PRIMARY | 4 | NULL | 94 | Using where |
|
| 2 | MATERIALIZED | mmic_sub_focuses | range | PRIMARY,fk_ltc_subfocuses_ltc_focus_ltc_focus_id | PRIMARY | 4 | NULL | 94 | Using where |
|
+------+--------------+------------------+--------+------------------------------------------------------+--------------+---------+------+------+-------------+
|
19 rows in set (0.31 sec)
|
Please let me know if further info would be helpful.
|
|
Thanks for all your help so far, Alice. I really appreciate it.
Frustratingly, no, the segfault does not occur every time the PHP script is executed. It seems random-ish in that the query needs to be executed several times before mysqld segfaults, but after it has crashed once, it seems to crash nearly every time the query is executed. Not terribly helpful, I know.
In my PHP script, the query is being executed through a framework, but I'll work to reproduce the issue in a bare-bones PHP script that I can send to you. After all, the framework is simply using the "mysqli" driver via PDO, so I expect the failure to occur without the framework layer in the mix. I'll get that over to you shortly.
I'm also going to test whether the segfault occurs across PHP versions. I'm using 7.1 currently, but I'll try it with 7.2 as well.
Finally, I will test whether it happens in MySQL, too.
More soon...
|
|
Yes, the bindings are causing the crash.
I noticed earlier that the "id" values in the WHERE clauses are supplied as quoted strings within the raw query, but didn't think it to be a "problem", no less capable of causing a segfault.
If I change the binding types for those values from string to integer, the crash does not occur, e.g.:
$stmt->bind_param("isssssssss", $one, $two, $three, $four, $five, $six, $seven, $eight, $nine, $ten);
|
to:
$stmt->bind_param("iiiiiiiiii", $one, $two, $three, $four, $five, $six, $seven, $eight, $nine, $ten);
|
|
|
I reproduced the case on MariaDB 10.2,10.3
it looks like the problem is reproducible, while general_log is ON.
--source include/have_innodb.inc
|
|
CREATE TABLE t1 (
|
id int NOT NULL ,
|
a1 int ,
|
d1 timestamp NULL DEFAULT NULL,
|
PRIMARY KEY (id),
|
KEY f1 (a1)
|
) ENGINE=Innodb ;
|
INSERT INTO `t1` VALUES (1,58,NULL),(2,58,NULL),(3,56,NULL),(4,58,NULL),(5,56,NULL),(6,58,NULL),(7,57,NULL),(8,55,NULL),(9,58,NULL),(10,56,NULL);
|
|
CREATE TABLE t2 (
|
id int NOT NULL ,
|
b1 int ,
|
d1 timestamp NULL DEFAULT NULL,
|
PRIMARY KEY (id),
|
KEY f2 (b1)
|
) ENGINE=Innodb ;
|
INSERT INTO `t2` VALUES (1,1,NULL),(2,2,NULL),(3,3,NULL),(4,4,NULL),(5,5,NULL),(6,6,NULL),(7,7,NULL),(8,8,NULL),(9,9,NULL),(10,10,NULL);
|
|
prepare stmt1 from "
|
SELECT count(*) FROM t1
|
WHERE a1 = '58'
|
AND EXISTS (SELECT * FROM t2 WHERE t1.id = t2.b1 AND id != '8' AND t2.d1 IS NULL)
|
AND EXISTS (SELECT * FROM t2 WHERE t1.id = t2.b1 AND id != '7' AND t2.d1 IS NULL)
|
AND EXISTS (SELECT * FROM t2 WHERE t1.id = t2.b1 AND id != '6' AND t2.d1 IS NULL)
|
AND EXISTS (SELECT * FROM t2 WHERE t1.id = t2.b1 AND id != '2' AND t2.d1 IS NULL)
|
AND EXISTS (SELECT * FROM t2 WHERE t1.id = t2.b1 AND id != '1' AND t2.d1 IS NULL)
|
AND EXISTS (SELECT * FROM t2 WHERE t1.id = t2.b1 AND id != '4' AND t2.d1 IS NULL)
|
AND EXISTS (SELECT * FROM t2 WHERE t1.id = t2.b1 AND id != '5' AND t2.d1 IS NULL)
|
AND EXISTS (SELECT * FROM t2 WHERE t1.id = t2.b1 AND id != '9' AND t2.d1 IS NULL)
|
AND EXISTS (SELECT * FROM t2 WHERE t1.id = t2.b1 AND id != '3' AND t2.d1 IS NULL)";
|
|
execute stmt1;
|
execute stmt1;
|
2018-05-25 17:09:51 140361822512896 [ERROR] mysqld: Table 'general_log' is marked as crashed and should be repaired
|
180525 17:09:52 [ERROR] mysqld got signal 11 ;
|
|
Server version: 10.2.14-MariaDB-log
|
|
Thread pointer: 0x7fa82c0009a8
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x7fa888921ec8 thread_stack 0x49000
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(my_print_stacktrace+0x2e)[0xddebae]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(handle_fatal_signal+0x471)[0x7df981]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7fa89fcb6390]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld[0x638983]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld[0x64960c]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_ZN4JOIN14optimize_innerEv+0x1540)[0x64bc10]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_ZN4JOIN8optimizeEv+0x56)[0x64e2d6]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xa2)[0x64e502]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x254)[0x650274]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld[0x5e7cf4]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_Z21mysql_execute_commandP3THD+0x1327)[0x5eb287]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_ZN18Prepared_statement7executeEP6Stringb+0x4dd)[0x604c5d]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_ZN18Prepared_statement12execute_loopEP6StringbPhS2_+0x9e)[0x60a81e]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_Z22mysql_sql_stmt_executeP3THD+0x156)[0x60b0d6]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_Z21mysql_execute_commandP3THD+0x2df9)[0x5ecd59]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x3a2)[0x5f4ee2]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x26ef)[0x5f7d5f]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_Z10do_commandP3THD+0x1c2)[0x5f8702]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x235)[0x6ddc35]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(handle_one_connection+0x3f)[0x6dddff]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fa89fcac6ba]
|
x86_64/clone.S:111(clone)[0x7fa89eb1141d]
|
180525 17:02:22 [ERROR] mysqld got signal 6 ;
|
|
Server version: 10.2.14-MariaDB-log
|
Thread pointer: 0x7fc1ec0009a8
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x7fc2580c0ec8 thread_stack 0x49000
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(my_print_stacktrace+0x2e)[0xddebae]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(handle_fatal_signal+0x471)[0x7df981]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7fc25cce9390]
|
linux/raise.c:54(__GI_raise)[0x7fc25ba72428]
|
stdlib/abort.c:91(__GI_abort)[0x7fc25ba7402a]
|
posix/libc_fatal.c:175(__fsetlocking)[0x7fc25bab47ea]
|
malloc/malloc.c:4105(_int_free)[0x7fc25babd37a]
|
malloc/malloc.c:2969(__GI___libc_free)[0x7fc25bac153c]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(delete_dynamic+0x1f)[0xdc1ccf]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_ZN4JOIN7destroyEv+0x1b3)[0x627233]
|
sql/gcalc_tools.cc:502(Gcalc_result_receiver::add_point(double, double))[0x694edc]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x151)[0x64e5b1]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x254)[0x650274]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld[0x5e7cf4]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_Z21mysql_execute_commandP3THD+0x1327)[0x5eb287]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_ZN18Prepared_statement7executeEP6Stringb+0x4dd)[0x604c5d]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_ZN18Prepared_statement12execute_loopEP6StringbPhS2_+0x9e)[0x60a81e]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_Z22mysql_sql_stmt_executeP3THD+0x156)[0x60b0d6]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_Z21mysql_execute_commandP3THD+0x2df9)[0x5ecd59]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x3a2)[0x5f4ee2]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x26ef)[0x5f7d5f]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_Z10do_commandP3THD+0x1c2)[0x5f8702]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x235)[0x6ddc35]
|
/alice/m4-10.2.14/../_depot/m-tar/10.2.14/bin/mysqld(handle_one_connection+0x3f)[0x6dddff]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fc25ccdf6ba]
|
x86_64/clone.S:111(clone)[0x7fc25bb4441d]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7fc1ec00f0c8): SELECT 1 FROM t1 WHERE a1 = '58' AND EXISTS (SELECT * FROM t2 WHERE t1.id = t2.b1 AND id != '8' AND t2.d1 IS NULL) AND EXISTS (SELECT * FROM t2 WHERE t1.id = t2.b1 AND id != '7' AND t2.d1 IS NULL) AND EXISTS (SELECT * FROM t2 WHERE t1.id = t2.b1 AND id != '6' AND t2.d1 IS NULL) AND EXISTS (SELECT * FROM t2 WHERE t1.id = t2.b1 AND id != '2' AND t2.d1 IS NULL) AND EXISTS (SELECT * FROM t2 WHERE t1.id = t2.b1 AND id != '1' AND t2.d1 IS NULL) AND EXISTS (SELECT * FROM t2 WHERE t1.id = t2.b1 AND id != '4' AND t2.d1 IS NULL) AND EXISTS (SELECT * FROM t2 WHERE t1.id = t2.b1 AND id != '5' AND t2.d1 IS NULL) AND EXISTS (SELECT * FROM t2 WHERE t1.id = t2.b1 AND id != '9' AND t2.d1 IS NULL) AND EXISTS (SELECT * FROM t2 WHERE t1.id = t2.b1 AND id != '3' AND t2.d1 IS NULL)
|
Connection ID (thread ID): 10
|
Status: NOT_KILLED
|
on 10.2
Thread 1 (Thread 0x7f7bf4576700 (LWP 6364)):
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
|
#1 0x00005647ce075faa in my_write_core (sig=sig@entry=6) at /home/alice/git/10.2/mysys/stacktrace.c:477
|
#2 0x00005647cdb8be14 in handle_fatal_signal (sig=6) at /home/alice/git/10.2/sql/signal_handler.cc:305
|
#3 <signal handler called>
|
#4 0x00007f7c01926428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
|
#5 0x00007f7c0192802a in __GI_abort () at abort.c:89
|
#6 0x00007f7c019687ea in __libc_message (do_abort=do_abort@entry=2, fmt=fmt@entry=0x7f7c01a81ed8 "*** Error in `%s': %s: 0x%s ***\n") at ../sysdeps/posix/libc_fatal.c:175
|
#7 0x00007f7c0197137a in malloc_printerr (ar_ptr=<optimized out>, ptr=<optimized out>, str=0x7f7c01a81fe8 "double free or corruption (out)", action=3) at malloc.c:5006
|
#8 _int_free (av=<optimized out>, p=<optimized out>, have_lock=0) at malloc.c:3867
|
#9 0x00007f7c0197553c in __GI___libc_free (mem=<optimized out>) at malloc.c:2968
|
#10 0x00005647ce072910 in my_free (ptr=<optimized out>) at /home/alice/git/10.2/mysys/my_malloc.c:217
|
#11 0x00005647ce06b80d in free_root (root=0x7f7bb0005a90, MyFlags=MyFlags@entry=1) at /home/alice/git/10.2/mysys/my_alloc.c:392
|
#12 0x00005647cda0d7d0 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f7bb00009a8, packet=<optimized out>, packet@entry=0x7f7bb0006a09 "", packet_length=<optimized out>, packet_length@entry=13, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/alice/git/10.2/sql/sql_parse.cc:2414
|
#13 0x00005647cda0f8bf in do_command (thd=0x7f7bb00009a8) at /home/alice/git/10.2/sql/sql_parse.cc:1375
|
#14 0x00005647cdacd484 in do_handle_one_connection (connect=connect@entry=0x5647d0e214c8) at /home/alice/git/10.2/sql/sql_connect.cc:1335
|
#15 0x00005647cdacd5f4 in handle_one_connection (arg=arg@entry=0x5647d0e214c8) at /home/alice/git/10.2/sql/sql_connect.cc:1241
|
#16 0x00005647cdd16534 in pfs_spawn_thread (arg=0x5647d0dbeb58) at /home/alice/git/10.2/storage/perfschema/pfs.cc:1862
|
#17 0x00007f7c025636ba in start_thread (arg=0x7f7bf4576700) at pthread_create.c:333
|
#18 0x00007f7c019f841d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
once I got this stacktrace (maybe somehow related with MDEV-15509?)
10.2 52df8040264cc6
|
Thread 1 (Thread 0x7efd7055f700 (LWP 26451)):
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
|
#1 0x00005555a169ad9a in my_write_core (sig=sig@entry=11) at /home/alice/git/10.2/mysys/stacktrace.c:477
|
#2 0x00005555a11da7b4 in handle_fatal_signal (sig=11) at /home/alice/git/10.2/sql/signal_handler.cc:305
|
#3 <signal handler called>
|
#4 end_sj_materialize (join=<optimized out>, join_tab=<optimized out>, end_of_records=<optimized out>) at /home/alice/git/10.2/sql/sql_select.cc:10873
|
#5 0x00005555a1084104 in evaluate_join_record (join=join@entry=0x7efd300107f8, join_tab=join_tab@entry=0x7efd300cb0b0, error=<optimized out>) at /home/alice/git/10.2/sql/sql_select.cc:18930
|
#6 0x00005555a108be2a in sub_select (join=0x7efd300107f8, join_tab=0x7efd300cb0b0, end_of_records=<optimized out>) at /home/alice/git/10.2/sql/sql_select.cc:18710
|
#7 0x00005555a11529ef in join_tab_execution_startup (tab=tab@entry=0x7efd30102e60) at /home/alice/git/10.2/sql/opt_subselect.cc:5341
|
#8 0x00005555a108bdee in sub_select (join=0x7efd300107f8, join_tab=0x7efd30102e60, end_of_records=<optimized out>) at /home/alice/git/10.2/sql/sql_select.cc:18698
|
#9 0x00005555a1084104 in evaluate_join_record (join=join@entry=0x7efd300107f8, join_tab=join_tab@entry=0x7efd30102ab0, error=<optimized out>) at /home/alice/git/10.2/sql/sql_select.cc:18930
|
#10 0x00005555a108be2a in sub_select (join=0x7efd300107f8, join_tab=0x7efd30102ab0, end_of_records=<optimized out>) at /home/alice/git/10.2/sql/sql_select.cc:18710
|
#11 0x00005555a10a7cb2 in do_select (procedure=<optimized out>, join=0x7efd300107f8) at /home/alice/git/10.2/sql/sql_select.cc:18254
|
#12 JOIN::exec_inner (this=this@entry=0x7efd300107f8) at /home/alice/git/10.2/sql/sql_select.cc:3585
|
#13 0x00005555a10a7e59 in JOIN::exec (this=this@entry=0x7efd300107f8) at /home/alice/git/10.2/sql/sql_select.cc:3380
|
#14 0x00005555a10a7f9e in mysql_select (thd=thd@entry=0x7efd300009a8, tables=0x7efd3002c0a8, wild_num=<optimized out>, fields=..., conds=0x7efd300104c8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7efd3003a368, unit=0x7efd30029b60, select_lex=0x7efd3002a298) at /home/alice/git/10.2/sql/sql_select.cc:3780
|
#15 0x00005555a10a88de in handle_select (thd=thd@entry=0x7efd300009a8, lex=lex@entry=0x7efd30029a98, result=result@entry=0x7efd3003a368, setup_tables_done_option=setup_tables_done_option@entry=0) at /home/alice/git/10.2/sql/sql_select.cc:376
|
#16 0x00005555a0fa7036 in execute_sqlcom_select (thd=thd@entry=0x7efd300009a8, all_tables=0x7efd3002c0a8) at /home/alice/git/10.2/sql/sql_parse.cc:6476
|
#17 0x00005555a105ed16 in mysql_execute_command (thd=0x7efd300009a8) at /home/alice/git/10.2/sql/sql_parse.cc:3483
|
#18 0x00005555a1072c07 in Prepared_statement::execute (this=this@entry=0x7efd300c0b58, expanded_query=expanded_query@entry=0x7efd7055cbd0, open_cursor=open_cursor@entry=false) at /home/alice/git/10.2/sql/sql_prepare.cc:4774
|
#19 0x00005555a1073343 in Prepared_statement::execute_loop (this=0x7efd300c0b58, expanded_query=0x7efd7055cbd0, open_cursor=false, packet_end=<optimized out>, packet=<optimized out>) at /home/alice/git/10.2/sql/sql_prepare.cc:4203
|
#20 0x00005555a107388f in mysql_sql_stmt_execute (thd=thd@entry=0x7efd300009a8) at /home/alice/git/10.2/sql/sql_prepare.cc:3311
|
#21 0x00005555a1059ceb in mysql_execute_command (thd=thd@entry=0x7efd300009a8) at /home/alice/git/10.2/sql/sql_parse.cc:3499
|
#22 0x00005555a1060ddd in mysql_parse (thd=0x7efd300009a8, rawbuf=<optimized out>, length=13, parser_state=0x7efd7055e240, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /home/alice/git/10.2/sql/sql_parse.cc:7941
|
#23 0x00005555a1063976 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7efd300009a8, packet=packet@entry=0x7efd30006ce9 "", packet_length=packet_length@entry=13, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/alice/git/10.2/sql/sql_parse.cc:1820
|
#24 0x00005555a106424f in do_command (thd=0x7efd300009a8) at /home/alice/git/10.2/sql/sql_parse.cc:1374
|
#25 0x00005555a111e734 in do_handle_one_connection (connect=connect@entry=0x5555a423e058) at /home/alice/git/10.2/sql/sql_connect.cc:1335
|
#26 0x00005555a111e8a4 in handle_one_connection (arg=arg@entry=0x5555a423e058) at /home/alice/git/10.2/sql/sql_connect.cc:1241
|
#27 0x00005555a135cb84 in pfs_spawn_thread (arg=0x5555a4207db8) at /home/alice/git/10.2/storage/perfschema/pfs.cc:1862
|
#28 0x00007efd805456ba in start_thread (arg=0x7efd7055f700) at pthread_create.c:333
|
#29 0x00007efd7f9da41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
16148.sql