Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.2, 5.5.30
-
None
-
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
|