Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5, 10.6, 10.11, 10.3(EOL), 10.4(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
None
Description
CREATE TEMPORARY TABLE t (c POINT NOT NULL,SPATIAL (c)); |
INSERT INTO t SELECT POINTFROMTEXT ('POINT(0 0)') FROM seq_1_to_500; |
XA BEGIN 'a'; |
DELETE FROM t ORDER BY c; |
Leads to:
10.10.2 87e8463e0454a04c2bbaa38d44227c491fb07dc1 (Debug) |
InnoDB: Failing assertion: table->n_rec_locks == 0
|
10.10.2 87e8463e0454a04c2bbaa38d44227c491fb07dc1 (Debug) |
Core was generated by `/test/MD200822-mariadb-10.10.2-linux-x86_64-dbg/bin/mysqld --no-defaults --core'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
[Current thread is 1 (Thread 0x1490d6e12700 (LWP 1822186))]
|
(gdb) bt
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#1 0x0000149103d95859 in __GI_abort () at abort.c:79
|
#2 0x00005613f5ab3301 in ut_dbg_assertion_failed (expr=expr@entry=0x5613f60e80f0 "table->n_rec_locks == 0", file=file@entry=0x5613f60e81d8 "/test/10.10_dbg/storage/innobase/dict/dict0dict.cc", line=line@entry=1855) at /test/10.10_dbg/storage/innobase/ut/ut0dbg.cc:60
|
#3 0x00005613f5b75f5e in dict_sys_t::remove (this=this@entry=0x5613f6766a00 <dict_sys>, table=0x14909001d820, lru=lru@entry=false, keep=keep@entry=true) at /test/10.10_dbg/storage/innobase/dict/dict0dict.cc:1855
|
#4 0x00005613f588f5e0 in ha_innobase::delete_table (this=<optimized out>, name=0x14909001ca88 "/test/MD200822-mariadb-10.10.2-linux-x86_64-dbg/data/#sql-temptable-1bcab4-4-0") at /test/10.10_dbg/storage/innobase/handler/ha_innodb.cc:13409
|
#5 0x00005613f556799e in hton_drop_table (hton=<optimized out>, path=<optimized out>) at /test/10.10_dbg/sql/handler.cc:576
|
#6 0x00005613f54bd993 in THD::rm_temporary_table (this=<optimized out>, base=0x5613f8e16578, path=0x14909001ca88 "/test/MD200822-mariadb-10.10.2-linux-x86_64-dbg/data/#sql-temptable-1bcab4-4-0") at /test/10.10_dbg/sql/temporary_tables.cc:706
|
#7 0x00005613f54be115 in THD::free_tmp_table_share (this=this@entry=0x149090000db8, share=0x14909001c4c8, delete_table=delete_table@entry=true) at /test/10.10_dbg/sql/handler.h:1688
|
#8 0x00005613f54beb8a in THD::close_temporary_tables (this=this@entry=0x149090000db8) at /test/10.10_dbg/sql/temporary_tables.cc:545
|
#9 0x00005613f520de0b in THD::cleanup (this=this@entry=0x149090000db8) at /test/10.10_dbg/sql/sql_class.cc:1526
|
#10 0x00005613f51440d9 in unlink_thd (thd=0x149090000db8) at /test/10.10_dbg/sql/mysqld.cc:2752
|
#11 0x00005613f53dd3b4 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5613f91ce5b8, put_in_cache=put_in_cache@entry=true) at /test/10.10_dbg/sql/sql_connect.cc:1429
|
#12 0x00005613f53dd6e3 in handle_one_connection (arg=0x5613f91ce5b8) at /test/10.10_dbg/sql/sql_connect.cc:1312
|
#13 0x00001491042a6609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#14 0x0000149103e92133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
10.5.18 5fc172fd43375b392a8c8adfb9038c279e578d83 (Optimized) |
InnoDB: Failing assertion: table->n_rec_locks == 0
|
10.5.18 5fc172fd43375b392a8c8adfb9038c279e578d83 (Optimized) |
Core was generated by `/test/MD200822-mariadb-10.5.18-linux-x86_64-opt/bin/mysqld --no-defaults --core'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
[Current thread is 1 (Thread 0x14adc810a700 (LWP 1822202))]
|
(gdb) bt
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#1 0x000014addfce1859 in __GI_abort () at abort.c:79
|
#2 0x000056479cb414a4 in ut_dbg_assertion_failed (expr=expr@entry=0x56479d6d6c71 "table->n_rec_locks == 0", file=file@entry=0x56479d6d6398 "/test/10.5_opt/storage/innobase/dict/dict0dict.cc", line=line@entry=1888) at /test/10.5_opt/storage/innobase/ut/ut0dbg.cc:60
|
#3 0x000056479cb4da38 in dict_sys_t::remove (this=0x56479dc6d780 <dict_sys>, table=0x14ad400190d8, lru=lru@entry=false, keep=keep@entry=false) at /test/10.5_opt/storage/innobase/dict/dict0dict.cc:1888
|
#4 0x000056479d1d768c in row_drop_table_for_mysql (name=name@entry=0x14adc8109430 "data/#sql-temptable-1bcae3-4-0", trx=trx@entry=0x14addde02118, sqlcom=sqlcom@entry=SQLCOM_END, create_failed=create_failed@entry=false, nonatomic=<optimized out>, nonatomic@entry=true) at /test/10.5_opt/storage/innobase/row/row0mysql.cc:3352
|
#5 0x000056479d125bf4 in ha_innobase::delete_table (this=<optimized out>, name=0x14ad40018150 "/test/MD200822-mariadb-10.5.18-linux-x86_64-opt/data/#sql-temptable-1bcae3-4-0", sqlcom=SQLCOM_END) at /test/10.5_opt/storage/innobase/handler/ha_innodb.cc:13346
|
#6 0x000056479ce6b515 in hton_drop_table (hton=<optimized out>, path=<optimized out>) at /test/10.5_opt/sql/handler.cc:564
|
#7 0x000056479cdee438 in THD::rm_temporary_table (this=<optimized out>, base=0x56479f56c9c8, path=0x14ad40018150 "/test/MD200822-mariadb-10.5.18-linux-x86_64-opt/data/#sql-temptable-1bcae3-4-0") at /test/10.5_opt/sql/temporary_tables.cc:705
|
#8 0x000056479cdee8f1 in THD::free_tmp_table_share (this=this@entry=0x14ad40000c58, share=0x14ad40017ca8, delete_table=delete_table@entry=true) at /test/10.5_opt/sql/table.h:778
|
#9 0x000056479cdef321 in THD::close_temporary_tables (this=this@entry=0x14ad40000c58) at /test/10.5_opt/sql/temporary_tables.cc:544
|
#10 0x000056479cc1177a in THD::cleanup (this=this@entry=0x14ad40000c58) at /test/10.5_opt/sql/sql_class.cc:1539
|
#11 0x000056479cb96bf9 in unlink_thd (thd=0x14ad40000c58) at /test/10.5_opt/sql/mysqld.cc:2607
|
#12 0x000056479cd610c1 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x56479f923d38, put_in_cache=put_in_cache@entry=true) at /test/10.5_opt/sql/sql_connect.cc:1429
|
#13 0x000056479cd6157d in handle_one_connection (arg=0x56479f923d38) at /test/10.5_opt/sql/sql_connect.cc:1312
|
#14 0x000014ade01f2609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#15 0x000014addfdde133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
10.3.37 a1055ab35d29437b717e83b1a388eaa02901c42f (Optimized) |
InnoDB: Failing assertion: table->n_rec_locks == 0
|
10.3.37 a1055ab35d29437b717e83b1a388eaa02901c42f (Optimized) |
Core was generated by `/test/MD200822-mariadb-10.3.37-linux-x86_64-opt/bin/mysqld --no-defaults --core'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
[Current thread is 1 (Thread 0x1511140ff700 (LWP 1822197))]
|
(gdb) bt
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#1 0x0000151129dc3859 in __GI_abort () at abort.c:79
|
#2 0x00005642a5f880e8 in ut_dbg_assertion_failed (expr=expr@entry=0x5642a693e44d "table->n_rec_locks == 0", file=file@entry=0x5642a693cd48 "/test/10.3_opt/storage/innobase/dict/dict0dict.cc", line=line@entry=1803) at /test/10.3_opt/storage/innobase/ut/ut0dbg.cc:60
|
#3 0x00005642a5f96c31 in dict_table_remove_from_cache_low (table=0x1510c8017fd8, lru_evict=0, lru_evict=0) at /test/10.3_opt/storage/innobase/dict/dict0dict.cc:1803
|
#4 0x00005642a64b5b0a in row_drop_table_for_mysql (name=name@entry=0x1511140fe6b0 "data/#sql1bcac7_9_0", trx=trx@entry=0x151114f6f0a8, sqlcom=sqlcom@entry=SQLCOM_END, create_failed=create_failed@entry=false, nonatomic=<optimized out>, nonatomic@entry=true) at /test/10.3_opt/storage/innobase/row/row0mysql.cc:3396
|
#5 0x00005642a640bc54 in ha_innobase::delete_table (this=<optimized out>, name=0x1510c8017150 "/test/MD200822-mariadb-10.3.37-linux-x86_64-opt/data/#sql1bcac7_9_0", sqlcom=SQLCOM_END) at /test/10.3_opt/storage/innobase/handler/ha_innodb.cc:13277
|
#6 0x00005642a61e3531 in THD::rm_temporary_table (this=<optimized out>, base=<optimized out>, path=0x1510c8017150 "/test/MD200822-mariadb-10.3.37-linux-x86_64-opt/data/#sql1bcac7_9_0") at /test/10.3_opt/sql/temporary_tables.cc:703
|
#7 0x00005642a61e39f1 in THD::free_tmp_table_share (this=this@entry=0x1510c8000c48, share=0x1510c8016d08, delete_table=delete_table@entry=true) at /test/10.3_opt/sql/table.h:751
|
#8 0x00005642a61e4401 in THD::close_temporary_tables (this=this@entry=0x1510c8000c48) at /test/10.3_opt/sql/temporary_tables.cc:544
|
#9 0x00005642a6037465 in THD::cleanup (this=this@entry=0x1510c8000c48) at /test/10.3_opt/sql/sql_class.cc:1473
|
#10 0x00005642a5fc0e44 in unlink_thd (thd=thd@entry=0x1510c8000c48) at /test/10.3_opt/sql/mysqld.cc:2981
|
#11 0x00005642a5fc0f3c in one_thread_per_connection_end (thd=0x1510c8000c48, put_in_cache=<optimized out>) at /test/10.3_opt/sql/mysqld.cc:3128
|
#12 0x00005642a615fb5e in do_handle_one_connection (connect=<optimized out>) at /test/10.3_opt/sql/sql_connect.cc:1422
|
#13 0x00005642a615fcbd in handle_one_connection (arg=<optimized out>) at /test/10.3_opt/sql/sql_connect.cc:1308
|
#14 0x0000151129f9b609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#15 0x0000151129ec0133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
10.3.37 a1055ab35d29437b717e83b1a388eaa02901c42f (Debug) |
InnoDB: Failing assertion: table->n_rec_locks == 0
|
10.3.37 a1055ab35d29437b717e83b1a388eaa02901c42f (Debug) |
Core was generated by `/test/MD200822-mariadb-10.3.37-linux-x86_64-dbg/bin/mysqld --no-defaults --core'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
[Current thread is 1 (Thread 0x14b6cc0d7700 (LWP 1822603))]
|
(gdb) bt
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#1 0x000014b6e39a9859 in __GI_abort () at abort.c:79
|
#2 0x000056015f037dd5 in ut_dbg_assertion_failed (expr=expr@entry=0x56015f61659d "table->n_rec_locks == 0", file=file@entry=0x56015f6167a0 "/test/10.3_dbg/storage/innobase/dict/dict0dict.cc", line=line@entry=1803) at /test/10.3_dbg/storage/innobase/ut/ut0dbg.cc:60
|
#3 0x000056015f123056 in dict_table_remove_from_cache_low (table=0x14b68000c970, lru_evict=lru_evict@entry=0) at /test/10.3_dbg/storage/innobase/dict/dict0dict.cc:1803
|
#4 0x000056015f123daf in dict_table_remove_from_cache (table=<optimized out>) at /test/10.3_dbg/storage/innobase/dict/dict0dict.cc:1906
|
#5 0x000056015ef51a4a in row_drop_table_for_mysql (name=name@entry=0x14b6cc0d6650 "data/#sql1bcac0_9_0", trx=trx@entry=0x14b6e0f0d168, sqlcom=sqlcom@entry=SQLCOM_END, create_failed=create_failed@entry=false, nonatomic=<optimized out>, nonatomic@entry=true) at /test/10.3_dbg/storage/innobase/row/row0mysql.cc:3396
|
#6 0x000056015ede8ba6 in ha_innobase::delete_table (this=this@entry=0x14b6800113d8, name=<optimized out>, name@entry=0x14b68001dd28 "/test/MD200822-mariadb-10.3.37-linux-x86_64-dbg/data/#sql1bcac0_9_0", sqlcom=sqlcom@entry=SQLCOM_END) at /test/10.3_dbg/storage/innobase/handler/ha_innodb.cc:13277
|
#7 0x000056015eddeaa6 in ha_innobase::delete_table (this=0x14b6800113d8, name=0x14b68001dd28 "/test/MD200822-mariadb-10.3.37-linux-x86_64-dbg/data/#sql1bcac0_9_0") at /test/10.3_dbg/storage/innobase/handler/ha_innodb.cc:13402
|
#8 0x000056015ebc5677 in handler::ha_delete_table (this=this@entry=0x14b6800113d8, name=name@entry=0x14b68001dd28 "/test/MD200822-mariadb-10.3.37-linux-x86_64-dbg/data/#sql1bcac0_9_0") at /test/10.3_dbg/sql/handler.cc:4722
|
#9 0x000056015eb1f931 in THD::rm_temporary_table (this=<optimized out>, base=<optimized out>, path=0x14b68001dd28 "/test/MD200822-mariadb-10.3.37-linux-x86_64-dbg/data/#sql1bcac0_9_0") at /test/10.3_dbg/sql/temporary_tables.cc:703
|
#10 0x000056015eb2006d in THD::free_tmp_table_share (this=this@entry=0x14b680000d90, share=0x14b68001d7e0, delete_table=delete_table@entry=true) at /test/10.3_dbg/sql/handler.h:1553
|
#11 0x000056015eb20ad6 in THD::close_temporary_tables (this=this@entry=0x14b680000d90) at /test/10.3_dbg/sql/temporary_tables.cc:544
|
#12 0x000056015e916e69 in THD::cleanup (this=this@entry=0x14b680000d90) at /test/10.3_dbg/sql/sql_class.cc:1473
|
#13 0x000056015e884dec in unlink_thd (thd=thd@entry=0x14b680000d90) at /test/10.3_dbg/sql/mysqld.cc:2981
|
#14 0x000056015e884f74 in one_thread_per_connection_end (thd=0x14b680000d90, put_in_cache=<optimized out>) at /test/10.3_dbg/sql/mysqld.cc:3128
|
#15 0x000056015ea7b200 in do_handle_one_connection (connect=<optimized out>) at /test/10.3_dbg/sql/sql_connect.cc:1422
|
#16 0x000056015ea7b2bf in handle_one_connection (arg=<optimized out>) at /test/10.3_dbg/sql/sql_connect.cc:1308
|
#17 0x000014b6e3b81609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#18 0x000014b6e3aa6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 10.3.37 (dbg), 10.3.37 (opt), 10.4.27 (dbg), 10.4.27 (opt), 10.5.18 (dbg), 10.5.18 (opt), 10.6.10 (dbg), 10.6.10 (opt), 10.7.6 (dbg), 10.7.6 (opt), 10.8.5 (dbg), 10.8.5 (opt), 10.9.2 (dbg), 10.9.2 (opt), 10.10.2 (dbg), 10.10.2 (opt), 10.11.0 (dbg), 10.11.0 (opt)
Bug (or feature/syntax) confirmed not present in:
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.38 (dbg), 5.7.38 (opt), 8.0.29 (dbg), 8.0.29 (opt)