Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
Description
CREATE TABLE t1 (a INT) ENGINE=Aria; |
|
|
--connect (con1,localhost,root,,)
|
FLUSH TABLE t1 FOR EXPORT; |
--error ER_CONNECTION_KILLED
|
KILL CONNECTION_ID();
|
--disconnect con1
|
|
|
--connection default
|
DROP TABLE t1; |
|
10.1 7158edcba3 |
mysqld: /data/src/10.1/storage/maria/ha_maria.cc:2768: virtual int ha_maria::external_lock(THD*, int): Assertion `!thd->get_stmt_da()->is_sent() || thd->killed == KILL_CONNECTION' failed.
|
190107 22:03:28 [ERROR] mysqld got signal 6 ;
|
|
|
#7 0x00007f2b0ef67ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x000055afd98796d9 in ha_maria::external_lock (this=0x7f2b06445088, thd=0x7f2b07cdb070, lock_type=2) at /data/src/10.1/storage/maria/ha_maria.cc:2767
|
#9 0x000055afd96bc5f8 in handler::ha_external_lock (this=0x7f2b06445088, thd=0x7f2b07cdb070, lock_type=2) at /data/src/10.1/sql/handler.cc:5866
|
#10 0x000055afd979f996 in unlock_external (thd=0x7f2b07cdb070, table=0x7f2b0641d698, count=1) at /data/src/10.1/sql/lock.cc:673
|
#11 0x000055afd979efc8 in mysql_unlock_tables (thd=0x7f2b07cdb070, sql_lock=0x7f2b0641d670, free_lock=true) at /data/src/10.1/sql/lock.cc:399
|
#12 0x000055afd979ef34 in mysql_unlock_tables (thd=0x7f2b07cdb070, sql_lock=0x7f2b0641d670) at /data/src/10.1/sql/lock.cc:388
|
#13 0x000055afd9403517 in close_thread_tables (thd=0x7f2b07cdb070) at /data/src/10.1/sql/sql_base.cc:1030
|
#14 0x000055afd940702a in Locked_tables_list::unlock_locked_tables (this=0x7f2b07cdea18, thd=0x7f2b07cdb070) at /data/src/10.1/sql/sql_base.cc:2868
|
#15 0x000055afd942c172 in THD::cleanup (this=0x7f2b07cdb070) at /data/src/10.1/sql/sql_class.cc:1482
|
#16 0x000055afd939fc24 in thd_cleanup (thd=0x7f2b07cdb070) at /data/src/10.1/sql/mysqld.cc:2763
|
#17 0x000055afd939fd8d in unlink_thd (thd=0x7f2b07cdb070) at /data/src/10.1/sql/mysqld.cc:2831
|
#18 0x000055afd93a0191 in one_thread_per_connection_end (thd=0x7f2b07cdb070, put_in_cache=true) at /data/src/10.1/sql/mysqld.cc:2959
|
#19 0x000055afd95a51cb in do_handle_one_connection (thd_arg=0x7f2b07cdb070) at /data/src/10.1/sql/sql_connect.cc:1349
|
#20 0x000055afd95a4e22 in handle_one_connection (arg=0x7f2b07cdb070) at /data/src/10.1/sql/sql_connect.cc:1242
|
#21 0x000055afd99630a0 in pfs_spawn_thread (arg=0x7f2b0e43a3f0) at /data/src/10.1/storage/perfschema/pfs.cc:1861
|
#22 0x00007f2b10c6b494 in start_thread (arg=0x7f2b10fa1b00) at pthread_create.c:333
|
#23 0x00007f2b0f02493f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
|
|
Query (0x0):
|
Connection ID (thread ID): 4
|
Status: KILL_CONNECTION
|
Not reproducible on 10.0.
No visible effect on a non-debug build.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Affects Version/s | 10.3 [ 22126 ] | |
| Affects Version/s | N/A [ 14700 ] |
| Affects Version/s | 10.1 [ 16100 ] | |
| Affects Version/s | 10.2 [ 14601 ] |
| Affects Version/s | 10.4 [ 22408 ] |
| Comment |
[ New occurrence on 10.1: https://travis-ci.org/elenst/travis-tests/jobs/467295573
] |
| Comment | [ New occurrence on 10.4: https://travis-ci.org/elenst/travis-tests/jobs/462490512 ] |
| Comment | [ New occurrence on 10.2: https://travis-ci.org/elenst/travis-tests/jobs/416584565 ] |
| Comment | [ New occurrence on 10.2: https://travis-ci.org/elenst/travis-tests/jobs/435027398 ] |
| Comment |
[ New occurrence: https://travis-ci.org/elenst/travis-tests/jobs/405594864
{noformat} # 1328,19,3 / 1328.19.3 Server: 10.1 323f269d4099b4a47530f0574af63292dfd89b8f Tests: master 22a15d6a9a42af4902b95a763d3b764f5ba7983f {noformat} For this, coredump, datadir etc. are available on demand. ] |
| Comment | [ New occurrence: https://api.travis-ci.org/v3/job/374054098/log.txt ] |
| Comment | [ New occurrence on 10.3: https://api.travis-ci.org/v3/job/368265219/log.txt ] |
| Comment | [ New occurrence: https://api.travis-ci.org/v3/job/379339022/log.txt ] |
| Attachment | threads [ 44911 ] |
| Fix Version/s | 10.1 [ 16100 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Assignee | Elena Stepanova [ elenst ] | Michael Widenius [ monty ] |
| Description |
https://api.travis-ci.org/v3/job/328488714/log.txt
{noformat:title=bb-10.3-temporal 755367d6b43fb60705d21c7435f2f1cdebab81c8} mysqld: /home/travis/src/storage/maria/ha_maria.cc:2775: virtual int ha_maria::external_lock(THD*, int): Assertion `!thd->get_stmt_da()->is_sent() || thd->killed == KILL_CONNECTION' failed. 180115 5:27:11 [ERROR] mysqld got signal 6 ; Query (0x0): Connection ID (thread ID): 25 Status: KILL_CONNECTION {noformat} {noformat} #3 <signal handler called> #4 0x00007f656e0c4c37 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56 #5 0x00007f656e0c8028 in __GI_abort () at abort.c:89 #6 0x00007f656e0bdbf6 in __assert_fail_base (fmt=0x7f656e212018 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x563d702f7ef8 "!thd->get_stmt_da()->is_sent() || thd->killed == KILL_CONNECTION", file=file@entry=0x563d702f7508 "/home/travis/src/storage/maria/ha_maria.cc", line=line@entry=2775, function=function@entry=0x563d702f89e0 <ha_maria::external_lock(THD*, int)::__PRETTY_FUNCTION__> "virtual int ha_maria::external_lock(THD*, int)") at assert.c:92 #7 0x00007f656e0bdca2 in __GI___assert_fail (assertion=0x563d702f7ef8 "!thd->get_stmt_da()->is_sent() || thd->killed == KILL_CONNECTION", file=0x563d702f7508 "/home/travis/src/storage/maria/ha_maria.cc", line=2775, function=0x563d702f89e0 <ha_maria::external_lock(THD*, int)::__PRETTY_FUNCTION__> "virtual int ha_maria::external_lock(THD*, int)") at assert.c:101 #8 0x0000563d6fd7f81a in ha_maria::external_lock (this=0x7f65140de0f8, thd=0x7f6514000d90, lock_type=2) at /home/travis/src/storage/maria/ha_maria.cc:2774 #9 0x0000563d6f76cba5 in handler::ha_external_lock (this=0x7f65140de0f8, thd=0x7f6514000d90, lock_type=2) at /home/travis/src/sql/handler.cc:6106 #10 0x0000563d6f886030 in unlock_external (thd=0x7f6514000d90, table=0x7f65141f2260, count=1) at /home/travis/src/sql/lock.cc:729 #11 0x0000563d6f885441 in mysql_unlock_tables (thd=0x7f6514000d90, sql_lock=0x7f65141f2230, free_lock=true) at /home/travis/src/sql/lock.cc:434 #12 0x0000563d6f885399 in mysql_unlock_tables (thd=0x7f6514000d90, sql_lock=0x7f65141f2230) at /home/travis/src/sql/lock.cc:420 #13 0x0000563d6f3ea7aa in close_thread_tables (thd=0x7f6514000d90) at /home/travis/src/sql/sql_base.cc:840 #14 0x0000563d6f3ed45b in Locked_tables_list::unlock_locked_tables (this=0x7f6514004988, thd=0x7f6514000d90) at /home/travis/src/sql/sql_base.cc:2189 #15 0x0000563d6f4160a9 in THD::cleanup (this=0x7f6514000d90) at /home/travis/src/sql/sql_class.cc:1495 #16 0x0000563d6f379dd8 in unlink_thd (thd=0x7f6514000d90) at /home/travis/src/sql/mysqld.cc:2939 #17 0x0000563d6f37a285 in one_thread_per_connection_end (thd=0x7f6514000d90, put_in_cache=true) at /home/travis/src/sql/mysqld.cc:3080 #18 0x0000563d6f5d300d in do_handle_one_connection (connect=0x563d71fc1620) at /home/travis/src/sql/sql_connect.cc:1420 #19 0x0000563d6f5d2cb1 in handle_one_connection (arg=0x563d71fc1620) at /home/travis/src/sql/sql_connect.cc:1307 #20 0x00007f656ec7f184 in start_thread (arg=0x7f6558890700) at pthread_create.c:312 #21 0x00007f656e18bffd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111 {noformat} {noformat:title=experimental ca750c313df92ab38a8f6a26d5dc865675851719} perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --seed=1515993910 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,ConvertTablesToDerived,Count,DisableOptimizations,Distinct,EnableOptimizations,ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsDerived,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsWhereSubquery,Having,InlineSubqueries,InlineVirtualColumns,LimitRowsExamined,OrderBy,StraightJoin,ExecuteAsPreparedTwice,ExecuteAsTrigger,ExecuteAsSPTwice,ExecuteAsFunctionTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --views --redefine=conf/mariadb/versioning.yy --basedir=/home/travis/server --debug --grammar=conf/runtime/WL5004_sql.yy --gendata=conf/runtime/WL5004_data.zz --engine=Aria --mysqld=--default-storage-engine=Aria --vardir=/home/travis/logs/vardir1_4 {noformat} |
{code:sql}
CREATE TABLE t1 (a INT) ENGINE=Aria; --connect (con1,localhost,root,,) FLUSH TABLE t1 FOR EXPORT; --error ER_CONNECTION_KILLED KILL CONNECTION_ID(); --disconnect con1 --connection default DROP TABLE t1; {code} {noformat:title=10.1 7158edcba3} mysqld: /data/src/10.1/storage/maria/ha_maria.cc:2768: virtual int ha_maria::external_lock(THD*, int): Assertion `!thd->get_stmt_da()->is_sent() || thd->killed == KILL_CONNECTION' failed. 190107 22:03:28 [ERROR] mysqld got signal 6 ; #7 0x00007f2b0ef67ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6 #8 0x000055afd98796d9 in ha_maria::external_lock (this=0x7f2b06445088, thd=0x7f2b07cdb070, lock_type=2) at /data/src/10.1/storage/maria/ha_maria.cc:2767 #9 0x000055afd96bc5f8 in handler::ha_external_lock (this=0x7f2b06445088, thd=0x7f2b07cdb070, lock_type=2) at /data/src/10.1/sql/handler.cc:5866 #10 0x000055afd979f996 in unlock_external (thd=0x7f2b07cdb070, table=0x7f2b0641d698, count=1) at /data/src/10.1/sql/lock.cc:673 #11 0x000055afd979efc8 in mysql_unlock_tables (thd=0x7f2b07cdb070, sql_lock=0x7f2b0641d670, free_lock=true) at /data/src/10.1/sql/lock.cc:399 #12 0x000055afd979ef34 in mysql_unlock_tables (thd=0x7f2b07cdb070, sql_lock=0x7f2b0641d670) at /data/src/10.1/sql/lock.cc:388 #13 0x000055afd9403517 in close_thread_tables (thd=0x7f2b07cdb070) at /data/src/10.1/sql/sql_base.cc:1030 #14 0x000055afd940702a in Locked_tables_list::unlock_locked_tables (this=0x7f2b07cdea18, thd=0x7f2b07cdb070) at /data/src/10.1/sql/sql_base.cc:2868 #15 0x000055afd942c172 in THD::cleanup (this=0x7f2b07cdb070) at /data/src/10.1/sql/sql_class.cc:1482 #16 0x000055afd939fc24 in thd_cleanup (thd=0x7f2b07cdb070) at /data/src/10.1/sql/mysqld.cc:2763 #17 0x000055afd939fd8d in unlink_thd (thd=0x7f2b07cdb070) at /data/src/10.1/sql/mysqld.cc:2831 #18 0x000055afd93a0191 in one_thread_per_connection_end (thd=0x7f2b07cdb070, put_in_cache=true) at /data/src/10.1/sql/mysqld.cc:2959 #19 0x000055afd95a51cb in do_handle_one_connection (thd_arg=0x7f2b07cdb070) at /data/src/10.1/sql/sql_connect.cc:1349 #20 0x000055afd95a4e22 in handle_one_connection (arg=0x7f2b07cdb070) at /data/src/10.1/sql/sql_connect.cc:1242 #21 0x000055afd99630a0 in pfs_spawn_thread (arg=0x7f2b0e43a3f0) at /data/src/10.1/storage/perfschema/pfs.cc:1861 #22 0x00007f2b10c6b494 in start_thread (arg=0x7f2b10fa1b00) at pthread_create.c:333 #23 0x00007f2b0f02493f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Query (0x0): Connection ID (thread ID): 4 Status: KILL_CONNECTION {noformat} Not reproducible on 10.0. No visible effect on a non-debug build. |
| Summary | [Draft] Assertion `!thd->get_stmt_da()->is_sent() || thd->killed == KILL_CONNECTION' failed in ha_maria::external_lock | Assertion `!thd->get_stmt_da()->is_sent() || thd->killed == KILL_CONNECTION' failed in ha_maria::external_lock |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Assignee | Michael Widenius [ monty ] | Vladislav Lesin [ vlad.lesin ] |
| Assignee | Vladislav Lesin [ vlad.lesin ] | Michael Widenius [ monty ] |
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| issue.field.resolutiondate | 2019-06-27 17:58:49.0 | 2019-06-27 17:58:49.082 |
| Fix Version/s | 10.2.26 [ 23409 ] | |
| Fix Version/s | 10.3.17 [ 23411 ] | |
| Fix Version/s | 10.4.7 [ 23720 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 84955 ] | MariaDB v4 [ 153599 ] |
Fixed assert to handle any case where thread is killed