[MDEV-10711] Assertion `status_var.memory_used == 0' failed in virtual THD::~THD() Created: 2016-08-31  Updated: 2022-09-08

Status: Confirmed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 10.0, 10.1
Fix Version/s: 10.1

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Note: Not reproducible on the current 10.2.

CREATE TABLE t1 (i INT);
INSERT INTO t1 VALUES (1),(2);
--error ER_SUBQUERY_NO_1_ROW
SELECT ( SELECT DISTINCT BENCHMARK(1,1) AS field1 FROM t1 GROUP BY 1 WITH ROLLUP ) AS sq;
DROP TABLE t1;

10.0 b34d7fba31

Warning:  288 bytes lost at 0x7f6ba37703f0, allocated by T@3 at 0x9c82a8, 0x830960, 0x82bdae, 0x6ae87e, 0x67fe70, 0x681f57, 0x681216, 0x8d7e13
Memory lost: 288 bytes in 2778 chunks
mysqld: /data/src/10.0/sql/sql_class.cc:1645: virtual THD::~THD(): Assertion `status_var.memory_used == 0' failed.
161011 18:21:46 [ERROR] mysqld got signal 6 ;
 
#7  0x00007f6baac64312 in __GI___assert_fail (assertion=0xe8a5d7 "status_var.memory_used == 0", file=0xe8a348 "/data/src/10.0/sql/sql_class.cc", line=1645, function=0xe8b910 <THD::~THD()::__PRETTY_FUNCTION__> "virtual THD::~THD()") at assert.c:101
#8  0x000000000060b598 in THD::~THD (this=0x7f6ba63dd070, __in_chrg=<optimized out>) at /data/src/10.0/sql/sql_class.cc:1645
#9  0x000000000060b730 in THD::~THD (this=0x7f6ba63dd070, __in_chrg=<optimized out>) at /data/src/10.0/sql/sql_class.cc:1650
#10 0x000000000058a8e2 in unlink_thd (thd=0x7f6ba63dd070) at /data/src/10.0/sql/mysqld.cc:2778
#11 0x000000000058ac38 in one_thread_per_connection_end (thd=0x7f6ba63dd070, put_in_cache=true) at /data/src/10.0/sql/mysqld.cc:2889
#12 0x0000000000761f9c in do_handle_one_connection (thd_arg=0x7f6ba63dd070) at /data/src/10.0/sql/sql_connect.cc:1389
#13 0x0000000000761c6c in handle_one_connection (arg=0x7f6ba63dd070) at /data/src/10.0/sql/sql_connect.cc:1293
#14 0x00000000009faa88 in pfs_spawn_thread (arg=0x7f6ba4d91370) at /data/src/10.0/storage/perfschema/pfs.cc:1860
#15 0x00007f6bacb660a4 in start_thread (arg=0x7f6bacf2a700) at pthread_create.c:309
#16 0x00007f6baad1e87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111


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