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

Assertion `inited == NONE' fails on closing a connection with open handler on temporary table

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.2, 5.5.30
    • Fix Version/s: 10.0.4, 5.5.32
    • Component/s: None
    • Labels:
      None

      Description

      The problem happens if a connection which has an open handler on a temporary table gets closed without closing the handler first.

      sql/handler.h:1832: virtual handler::~handler(): Assertion `inited == NONE' failed.
      130504 19:45:30 [ERROR] mysqld got signal 6 ;

      #7  0x00007f23e36e4192 in __GI___assert_fail (assertion=0xdf50cb "inited == NONE", file=0xdf5060 "/home/elenst/bzr/5.5/sql/handler.h", line=1832, function=0xdf67e0 "virtual handler::~handler()") at assert.c:103
      #8  0x00000000007dfeb9 in handler::~handler (this=0x7f239000e658, __in_chrg=<optimized out>) at /home/elenst/bzr/5.5/sql/handler.h:1832
      #9  0x000000000098fa32 in ha_innobase::~ha_innobase (this=0x7f239000e658, __in_chrg=<optimized out>) at /home/elenst/bzr/5.5/storage/xtradb/handler/ha_innodb.cc:1912
      #10 0x000000000098fa6a in ha_innobase::~ha_innobase (this=0x7f239000e658, __in_chrg=<optimized out>) at /home/elenst/bzr/5.5/storage/xtradb/handler/ha_innodb.cc:1914
      #11 0x00000000006df0e6 in closefrm (table=0x7f2390012c00, free_share=false) at /home/elenst/bzr/5.5/sql/table.cc:2718
      #12 0x00000000005b1a4a in close_temporary (table=0x7f2390012c00, free_share=true, delete_table=true) at /home/elenst/bzr/5.5/sql/sql_base.cc:2271
      #13 0x00000000005b0513 in close_temporary_tables (thd=0x2e89ef0) at /home/elenst/bzr/5.5/sql/sql_base.cc:1686
      #14 0x00000000005d6eb0 in THD::cleanup (this=0x2e89ef0) at /home/elenst/bzr/5.5/sql/sql_class.cc:1387
      #15 0x000000000055e06c in thd_cleanup (thd=0x2e89ef0) at /home/elenst/bzr/5.5/sql/mysqld.cc:2445
      #16 0x000000000055e128 in unlink_thd (thd=0x2e89ef0) at /home/elenst/bzr/5.5/sql/mysqld.cc:2479
      #17 0x000000000055e553 in one_thread_per_connection_end (thd=0x2e89ef0, put_in_cache=true) at /home/elenst/bzr/5.5/sql/mysqld.cc:2602
      #18 0x0000000000719cb9 in do_handle_one_connection (thd_arg=0x2e89ef0) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1277
      #19 0x00000000007195fa in handle_one_connection (arg=0x2e89ef0) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1181
      #20 0x00007f23e44b4e9a in start_thread (arg=0x7f23e4ea9700) at pthread_create.c:308
      #21 0x00007f23e37a8cbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

      Test case:

      --connect (con1,localhost,root,,)
      create temporary table t1 as select 1;
      handler t1 open;
      handler t1 read next;
      --disconnect con1

      bzr version-info

      revision-id: psergey@askmonty.org-20130504090524-usg6oi1z1eqln2zu
      revno: 3743
      branch-nick: 5.5

        Attachments

          Activity

            People

            • Assignee:
              serg Sergei Golubchik
              Reporter:
              elenst Elena Stepanova
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: