[MDEV-17582] Assertion `status_var.local_memory_used == 0' failed in THD::~THD() Created: 2018-10-31  Updated: 2020-02-28  Resolved: 2020-02-28

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.1
Fix Version/s: N/A

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

Issue Links:
Duplicate
duplicates MDEV-21837 Assertion `status_var.local_memory_us... Open

 Description   

https://travis-ci.org/elenst/travis-tests/jobs/444876092

10.1 5b735e8f09c81a2533c30cdd62d60dffa8226cd4

Version: '10.1.37-MariaDB-debug'  socket: '/home/travis/logs/vardir/mysql.sock'  port: 19300  Source distribution
Warning: 261280 bytes lost at 0x7f30dc05a720, allocated by T@12 at sql/records.cc:607, sql/records.cc:255, sql/sql_select.cc:19386, sql/sql_select.cc:18476, sql/sql_select.cc:18134, sql/sql_select.cc:3275, sql/sql_select.cc:2563, sql/item_subselect.cc:3859
Warning: 261280 bytes lost at 0x7f30dc546350, allocated by T@12 at sql/records.cc:607, sql/records.cc:255, sql/sql_select.cc:19386, sql/sql_select.cc:18476, sql/sql_select.cc:18134, sql/sql_select.cc:3275, sql/sql_select.cc:2563, sql/item_subselect.cc:3859
Warning: 261280 bytes lost at 0x7f30dc3a08d0, allocated by T@12 at sql/records.cc:607, sql/records.cc:255, sql/sql_select.cc:19386, sql/sql_select.cc:18476, sql/sql_select.cc:18134, sql/sql_select.cc:3275, sql/sql_select.cc:2563, sql/item_subselect.cc:3859
Memory lost: 783840 bytes in 4388 chunks
mysqld: /home/travis/src/sql/sql_class.cc:1608: virtual THD::~THD(): Assertion `status_var.local_memory_used == 0' failed.
181023  4:42:55 [ERROR] mysqld got signal 6 ;
 
Some pointers may be invalid and cause the dump to abort.
Query (0x0): 
Connection ID (thread ID): 12
Status: KILL_CONNECTION
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off

#6  0x00007f30e1abfbf6 in ?? () from /lib/x86_64-linux-gnu/libc.so.6
#7  0x00007f30e1abfca2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8  0x000055c405db2b77 in THD::~THD (this=0x55c4093fffb0, __in_chrg=<optimized out>) at /home/travis/src/sql/sql_class.cc:1608
#9  0x000055c405db2d24 in THD::~THD (this=0x55c4093fffb0, __in_chrg=<optimized out>) at /home/travis/src/sql/sql_class.cc:1613
#10 0x000055c405d25e17 in unlink_thd (thd=0x55c4093fffb0) at /home/travis/src/sql/mysqld.cc:2839
#11 0x000055c405d2617a in one_thread_per_connection_end (thd=0x55c4093fffb0, put_in_cache=true) at /home/travis/src/sql/mysqld.cc:2952
#12 0x000055c405f2c10d in do_handle_one_connection (thd_arg=0x55c4093fffb0) at /home/travis/src/sql/sql_connect.cc:1349
#13 0x000055c405f2bd64 in handle_one_connection (arg=0x55c4093fffb0) at /home/travis/src/sql/sql_connect.cc:1242
#14 0x00007f30e246b184 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#15 0x00007f30e1b8dffd in clone () from /lib/x86_64-linux-gnu/libc.so.6

elenst-mdev14046 1348571d03a3b335fe5d772cbbb27c13f24c62e0

perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1540269416 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/sp.yy --redefine=conf/mariadb/bulk_insert.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=30 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--default-storage-engine=MyISAM --grammar=conf/mariadb/functions.yy --mysqld=--log_bin_trust_function_creators=1 --mysqld=--default-storage-engine=MyISAM --grammar=conf/mariadb/functions.yy --mysqld=--log-bin --transformers=ExecuteAsDeleteReturning,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice --redefine=conf/mariadb/general-workarounds.yy

Not reproducible right away.



 Comments   
Comment by Elena Stepanova [ 2019-01-06 ]

New occurrence: https://travis-ci.org/elenst/travis-tests/jobs/475573546

Comment by Elena Stepanova [ 2019-01-15 ]

New occurrence: https://travis-ci.org/elenst/travis-tests/jobs/479682719

Comment by Elena Stepanova [ 2020-02-28 ]

Didn't notice this old one and filed it again by mistake: MDEV-21837. Let's keep the new one as it already has a test case.

Generated at Thu Feb 08 08:37:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.