[MDEV-5047] virtual THD::~THD(): Assertion `status_var.memory_used == 0' fails on disconnect after an error and SHOW WARNINGS Created: 2013-09-20  Updated: 2013-09-23  Resolved: 2013-09-23

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: 10.0.5

Type: Bug Priority: Blocker
Reporter: Elena Stepanova Assignee: Sergei Petrunia
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates

 Description   

bzr version-info
revision-id: psergey@askmonty.org-20130920134524-lfb0zu42yhoo6pvt
revno: 3692
branch-nick: 10.0-base-explain-slowquerylog

I'm not sure whether it's related to EXPLAIN update/delete or slow log, but it's reproducible on the tree, and is not reproducible on 10.0-base

sql/sql_class.cc:1498: virtual THD::~THD(): Assertion `status_var.memory_used == 0' failed.

#3  <signal handler called>
#4  0x00007fd704f96425 in __GI_raise (sig=<optimised out>) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
#5  0x00007fd704f99b8b in __GI_abort () at abort.c:91
#6  0x00007fd704f8f0ee in __assert_fail_base (fmt=<optimised out>, assertion=0xdab5e8 "status_var.memory_used == 0", file=0xdab320 "10.0-base-explain-slowquerylog/sql/sql_class.cc", line=<optimised out>, function=<optimised out>) at assert.c:94
#7  0x00007fd704f8f192 in __GI___assert_fail (assertion=0xdab5e8 "status_var.memory_used == 0", file=0xdab320 "10.0-base-explain-slowquerylog/sql/sql_class.cc", line=1498, function=0xdad270 "virtual THD::~THD()") at assert.c:103
#8  0x00000000005e5638 in THD::~THD (this=0x48cedb8, __in_chrg=<optimised out>) at 10.0-base-explain-slowquerylog/sql/sql_class.cc:1498
#9  0x00000000005e579a in THD::~THD (this=0x48cedb8, __in_chrg=<optimised out>) at 10.0-base-explain-slowquerylog/sql/sql_class.cc:1503
#10 0x00000000005692c9 in unlink_thd (thd=0x48cedb8) at 10.0-base-explain-slowquerylog/sql/mysqld.cc:2571
#11 0x0000000000569688 in one_thread_per_connection_end (thd=0x48cedb8, put_in_cache=true) at 10.0-base-explain-slowquerylog/sql/mysqld.cc:2687
#12 0x000000000073daed in do_handle_one_connection (thd_arg=0x48cedb8) at 10.0-base-explain-slowquerylog/sql/sql_connect.cc:1277
#13 0x000000000073d7b5 in handle_one_connection (arg=0x48cedb8) at 10.0-base-explain-slowquerylog/sql/sql_connect.cc:1181
#14 0x00007fd705d5fe9a in start_thread (arg=0x7fd70662b700) at pthread_create.c:308
#15 0x00007fd705053cbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

--connect (con1,localhost,root,,)
--error ER_NO_SUCH_TABLE
ALTER TABLE nonexisting ENABLE KEYS;
SHOW WARNINGS;
--disconnect con1
--connection default
SELECT 1;


Generated at Thu Feb 08 07:01:15 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.