Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17582

Assertion `status_var.local_memory_used == 0' failed in THD::~THD()

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Duplicate
    • 10.1
    • N/A
    • Server
    • None

    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.

      Attachments

        Issue Links

          Activity

            People

              elenst Elena Stepanova
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.