Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
N/A
-
None
Description
--source include/have_sequence.inc
|
|
CREATE TABLE t1 (a varchar(1024)); |
INSERT INTO t1 VALUES ('this'),('is'),('just'),('a'),('filling'),('for'),(REPEAT('a',500)); |
|
SET max_tmp_session_space_usage = 1024*1024, max_heap_table_size= 4*1024*1024; |
SELECT DISTINCT a, seq FROM t1 JOIN seq_1_to_600; |
|
# Cleanup
|
DROP TABLE t1; |
bb-11.5-monty a7801b24 |
mariadbd: /data/bld/bb-11.5-monty-debug/storage/maria/ma_close.c:42: maria_close: Assertion `info->key_del_used == 0' failed.
|
240428 3:23:05 [ERROR] mysqld got signal 6 ;
|
|
#9 0x00007fa8ae453e32 in __GI___assert_fail (assertion=0x55eb6c76b74b "info->key_del_used == 0", file=0x55eb6c76b6d0 "/data/bld/bb-11.5-monty-debug/storage/maria/ma_close.c", line=42, function=0x55eb6c76bb58 <__PRETTY_FUNCTION__.1> "maria_close") at ./assert/assert.c:101
|
#10 0x000055eb6bce907b in maria_close (info=0x7fa898f1e978) at /data/bld/bb-11.5-monty-debug/storage/maria/ma_close.c:42
|
#11 0x000055eb6bcf35c9 in ha_maria::close (this=0x7fa8980882e0) at /data/bld/bb-11.5-monty-debug/storage/maria/ha_maria.cc:1290
|
#12 0x000055eb6bacee8b in handler::ha_close (this=0x7fa8980882e0) at /data/bld/bb-11.5-monty-debug/sql/handler.cc:3605
|
#13 0x000055eb6bcf8b66 in ha_maria::drop_table (this=0x7fa8980882e0, name=0x7fa8980685e0 "/mnt8t/bld/bb-11.5-monty-debug/mysql-test/var/tmp/mysqld.1/#sql-temptable-1ec6b-4-f") at /data/bld/bb-11.5-monty-debug/storage/maria/ha_maria.cc:2950
|
#14 0x000055eb6b7514ec in create_internal_tmp_table_from_heap (thd=0x7fa898000dc8, table=0x7fa898067860, start_recinfo=0x7fa898068410, recinfo=0x7fa898067018, error=135, ignore_last_dupp_key_error=true, is_duplicate=0x7fa8a8b93c73) at /data/bld/bb-11.5-monty-debug/sql/sql_select.cc:22819
|
#15 0x000055eb6b757922 in end_write (join=0x7fa8980191a0, join_tab=0x7fa898065f68, end_of_records=false) at /data/bld/bb-11.5-monty-debug/sql/sql_select.cc:25203
|
#16 0x000055eb6b76c3fa in AGGR_OP::put_record (this=0x7fa898067170, end_of_records=false) at /data/bld/bb-11.5-monty-debug/sql/sql_select.cc:32500
|
#17 0x000055eb6b774d7d in AGGR_OP::put_record (this=0x7fa898067170) at /data/bld/bb-11.5-monty-debug/sql/sql_select.h:1186
|
#18 0x000055eb6b752d44 in sub_select_postjoin_aggr (join=0x7fa8980191a0, join_tab=0x7fa898065f68, end_of_records=false) at /data/bld/bb-11.5-monty-debug/sql/sql_select.cc:23298
|
#19 0x000055eb6b902e13 in JOIN_CACHE::generate_full_extensions (this=0x7fa898066eb0, rec_ptr=0x7fa898069edb "\376\001") at /data/bld/bb-11.5-monty-debug/sql/sql_join_cache.cc:2540
|
#20 0x000055eb6b902acd in JOIN_CACHE::join_matching_records (this=0x7fa898066eb0, skip_last=false) at /data/bld/bb-11.5-monty-debug/sql/sql_join_cache.cc:2432
|
#21 0x000055eb6b902241 in JOIN_CACHE::join_records (this=0x7fa898066eb0, skip_last=false) at /data/bld/bb-11.5-monty-debug/sql/sql_join_cache.cc:2182
|
#22 0x000055eb6b752e75 in sub_select_cache (join=0x7fa8980191a0, join_tab=0x7fa898065af8, end_of_records=true) at /data/bld/bb-11.5-monty-debug/sql/sql_select.cc:23357
|
#23 0x000055eb6b753146 in sub_select (join=0x7fa8980191a0, join_tab=0x7fa898065688, end_of_records=true) at /data/bld/bb-11.5-monty-debug/sql/sql_select.cc:23547
|
#24 0x000055eb6b752675 in do_select (join=0x7fa8980191a0, procedure=0x0) at /data/bld/bb-11.5-monty-debug/sql/sql_select.cc:23127
|
#25 0x000055eb6b71e2fb in JOIN::exec_inner (this=0x7fa8980191a0) at /data/bld/bb-11.5-monty-debug/sql/sql_select.cc:4988
|
#26 0x000055eb6b71d309 in JOIN::exec (this=0x7fa8980191a0) at /data/bld/bb-11.5-monty-debug/sql/sql_select.cc:4774
|
#27 0x000055eb6b71ed96 in mysql_select (thd=0x7fa898000dc8, tables=0x7fa898016000, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2164525825, result=0x7fa898019178, unit=0x7fa8980052b0, select_lex=0x7fa898015890) at /data/bld/bb-11.5-monty-debug/sql/sql_select.cc:5304
|
#28 0x000055eb6b70d009 in handle_select (thd=0x7fa898000dc8, lex=0x7fa8980051d0, result=0x7fa898019178, setup_tables_done_option=0) at /data/bld/bb-11.5-monty-debug/sql/sql_select.cc:630
|
#29 0x000055eb6b6b0891 in execute_sqlcom_select (thd=0x7fa898000dc8, all_tables=0x7fa898016000) at /data/bld/bb-11.5-monty-debug/sql/sql_parse.cc:6101
|
#30 0x000055eb6b6a8672 in mysql_execute_command (thd=0x7fa898000dc8, is_called_from_prepared_stmt=false) at /data/bld/bb-11.5-monty-debug/sql/sql_parse.cc:3948
|
#31 0x000055eb6b6b5856 in mysql_parse (thd=0x7fa898000dc8, rawbuf=0x7fa8980157d0 "SELECT DISTINCT a, seq FROM t1 JOIN seq_1_to_600", length=48, parser_state=0x7fa8a8b95330) at /data/bld/bb-11.5-monty-debug/sql/sql_parse.cc:7821
|
#32 0x000055eb6b6a1ee4 in dispatch_command (command=COM_QUERY, thd=0x7fa898000dc8, packet=0x7fa89800bd39 "", packet_length=48, blocking=true) at /data/bld/bb-11.5-monty-debug/sql/sql_parse.cc:1893
|
#33 0x000055eb6b6a083d in do_command (thd=0x7fa898000dc8, blocking=true) at /data/bld/bb-11.5-monty-debug/sql/sql_parse.cc:1406
|
#34 0x000055eb6b89ffcd in do_handle_one_connection (connect=0x55eb6e6b8f98, put_in_cache=true) at /data/bld/bb-11.5-monty-debug/sql/sql_connect.cc:1439
|
#35 0x000055eb6b89fd42 in handle_one_connection (arg=0x55eb6e6fc9d8) at /data/bld/bb-11.5-monty-debug/sql/sql_connect.cc:1341
|
#36 0x000055eb6bdeee54 in pfs_spawn_thread (arg=0x55eb6e6b8b08) at /data/bld/bb-11.5-monty-debug/storage/perfschema/pfs.cc:2201
|
#37 0x00007fa8ae4a8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#38 0x00007fa8ae52861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
Attachments
Issue Links
- is caused by
-
MDEV-9101 Limit size of created disk temporary files and tables
-
- Closed
-