[MDEV-19131] Assertion `table->versioned(VERS_TRX_ID) || (table->versioned() && table->s->table_category == TABLE_CATEGORY_TEMPORARY)' failed in Field_vers_trx_id::get_date Created: 2019-04-02  Updated: 2023-11-28

Status: Confirmed
Project: MariaDB Server
Component/s: Versioned Tables
Affects Version/s: 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 10.11, 11.0
Fix Version/s: 10.4, 10.5, 10.6, 10.11, 11.0

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Aleksey Midenkov
Resolution: Unresolved Votes: 0
Labels: trx-versioning

Issue Links:
Relates
relates to MDEV-16226 TRX_ID-based System Versioning refact... Stalled

 Description    

--source include/have_innodb.inc
 
 
 
CREATE OR REPLACE TABLE t1 (a INT, s BIGINT UNSIGNED AS ROW START, e BIGINT UNSIGNED AS ROW END, PERIOD FOR SYSTEM_TIME(s,e)) WITH SYSTEM VERSIONING ENGINE=InnoDB; 
CREATE OR REPLACE ALGORITHM=TEMPTABLE VIEW v AS SELECT * FROM t1;
 
INSERT INTO t1 (a) VALUES (1);
 
 
 
CREATE OR REPLACE TABLE t2 (f TIMESTAMP);
 
INSERT INTO t2 VALUES ('2019-04-01 23:22:12'),('2019-04-01 23:22:12');
 
SELECT * from v WHERE s IN (SELECT f FROM t2);
 
 
 
# Cleanup
 
DROP VIEW v;
 
DROP TABLE t1, t2;

10.3 ed661a0e

 
mysqld: /data/src/10.3/sql/field.cc:2096: bool Field_vers_trx_id::get_date(MYSQL_TIME*, ulonglong, ulonglong): Assertion `table->versioned(VERS_TRX_ID) || (table->versioned() && table->s->table_category == TABLE_CATEGORY_TEMPORARY)' failed.
 
190402  3:09:22 [ERROR] mysqld got signal 6 ;
 
 
 
#7  0x00007f11f7889ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
 
#8  0x000055676aa8d0a6 in Field_vers_trx_id::get_date (this=0x7f11a003fd98, ltime=0x7f11f0bcd9e0, fuzzydate=33554433, trx_id=36) at /data/src/10.3/sql/field.cc:2095
 
#9  0x000055676aab9ae2 in Field_vers_trx_id::get_date (this=0x7f11a003fd98, ltime=0x7f11f0bcd9e0, fuzzydate=33554433) at /data/src/10.3/sql/field.h:2353
 
#10 0x000055676aaeb3ba in Item_field::get_date (this=0x7f11a0015578, ltime=0x7f11f0bcd9e0, fuzzydate=33554433) at /data/src/10.3/sql/item.cc:3445
 
#11 0x000055676a9b3030 in Temporal_with_date::make_from_item (this=0x7f11f0bcd9e0, thd=0x7f11a0000b00, item=0x7f11a0015578, flags=33554433) at /data/src/10.3/sql/sql_type.cc:150
 
#12 0x000055676a6c9870 in Temporal_with_date::Temporal_with_date (this=0x7f11f0bcd9e0, thd=0x7f11a0000b00, item=0x7f11a0015578, flags=33554433) at /data/src/10.3/sql/sql_type.h:295
 
#13 0x000055676a6c9934 in Datetime::Datetime (this=0x7f11f0bcd9e0, thd=0x7f11a0000b00, item=0x7f11a0015578, flags=33554433) at /data/src/10.3/sql/sql_type.h:370
 
#14 0x000055676a6ca58e in Item::val_datetime_packed (this=0x7f11a0015578) at /data/src/10.3/sql/item.h:1521
 
#15 0x000055676ab0b8e7 in Arg_comparator::compare_datetime (this=0x7f11a00415e8) at /data/src/10.3/sql/item_cmpfunc.cc:736
 
#16 0x000055676ab1fef2 in Arg_comparator::compare (this=0x7f11a00415e8) at /data/src/10.3/sql/item_cmpfunc.h:102
 
#17 0x000055676ab0eb2b in Item_func_eq::val_int (this=0x7f11a0041528) at /data/src/10.3/sql/item_cmpfunc.cc:1728
 
#18 0x000055676a8d1990 in SQL_SELECT::skip_record (this=0x7f11a0044130, thd=0x7f11a0000b00) at /data/src/10.3/sql/opt_range.h:1658
 
#19 0x000055676a97cea9 in JOIN_CACHE::check_match (this=0x7f11a0044300, rec_ptr=0x7f11a00ab981 "") at /data/src/10.3/sql/sql_join_cache.cc:2449
 
#20 0x000055676a97896c in JOIN_CACHE::generate_full_extensions (this=0x7f11a0044300, rec_ptr=0x7f11a00ab981 "") at /data/src/10.3/sql/sql_join_cache.cc:2392
 
#21 0x000055676a97874c in JOIN_CACHE::join_matching_records (this=0x7f11a0044300, skip_last=false) at /data/src/10.3/sql/sql_join_cache.cc:2292
 
#22 0x000055676a978118 in JOIN_CACHE::join_records (this=0x7f11a0044300, skip_last=false) at /data/src/10.3/sql/sql_join_cache.cc:2088
 
#23 0x000055676a8440cf in sub_select_cache (join=0x7f11a0019668, join_tab=0x7f11a00460f8, end_of_records=true) at /data/src/10.3/sql/sql_select.cc:19176
 
#24 0x000055676a8442dc in sub_select (join=0x7f11a0019668, join_tab=0x7f11a0045d48, end_of_records=true) at /data/src/10.3/sql/sql_select.cc:19347
 
#25 0x000055676a843aa4 in do_select (join=0x7f11a0019668, procedure=0x0) at /data/src/10.3/sql/sql_select.cc:18938
 
#26 0x000055676a81c607 in JOIN::exec_inner (this=0x7f11a0019668) at /data/src/10.3/sql/sql_select.cc:4040
 
#27 0x000055676a81ba48 in JOIN::exec (this=0x7f11a0019668) at /data/src/10.3/sql/sql_select.cc:3834
 
#28 0x000055676a81cce8 in mysql_select (thd=0x7f11a0000b00, tables=0x7f11a0014f10, wild_num=1, fields=..., conds=0x7f11a00169d0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f11a0019640, unit=0x7f11a00049c8, select_lex=0x7f11a0005138) at /data/src/10.3/sql/sql_select.cc:4239
 
#29 0x000055676a80ec08 in handle_select (thd=0x7f11a0000b00, lex=0x7f11a0004900, result=0x7f11a0019640, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:385
 
#30 0x000055676a7d95ff in execute_sqlcom_select (thd=0x7f11a0000b00, all_tables=0x7f11a0014f10) at /data/src/10.3/sql/sql_parse.cc:6548
 
#31 0x000055676a7cff1e in mysql_execute_command (thd=0x7f11a0000b00) at /data/src/10.3/sql/sql_parse.cc:3821
 
#32 0x000055676a7dd59d in mysql_parse (thd=0x7f11a0000b00, rawbuf=0x7f11a0014ce8 "SELECT * from v WHERE s IN (SELECT f FROM t2)", length=45, parser_state=0x7f11f0bcf5f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8091
 
#33 0x000055676a7ca86c in dispatch_command (command=COM_QUERY, thd=0x7f11a0000b00, packet=0x7f11a01621d1 "", packet_length=45, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1857
 
#34 0x000055676a7c9256 in do_command (thd=0x7f11a0000b00) at /data/src/10.3/sql/sql_parse.cc:1403
 
#35 0x000055676a931eef in do_handle_one_connection (connect=0x55676ed03220) at /data/src/10.3/sql/sql_connect.cc:1402
 
#36 0x000055676a931c73 in handle_one_connection (arg=0x55676ed03220) at /data/src/10.3/sql/sql_connect.cc:1308
 
#37 0x000055676adce589 in pfs_spawn_thread (arg=0x55676ec48140) at /data/src/10.3/storage/perfschema/pfs.cc:1862
 
#38 0x00007f11f9778494 in start_thread (arg=0x7f11f0bd0700) at pthread_create.c:333
 
#39 0x00007f11f794693f in clone () from /lib/x86_64-linux-gnu/libc.so.6

No obvious effect on a non-debug build.

 Comments   
Comment by Alice Sherepa [ 2022-04-20 ] 

mysqld: /11.2/sql/field.cc:2305: bool Field_vers_trx_id::get_date(MYSQL_TIME*, date_mode_t, ulonglong): Assertion `table->versioned(VERS_TRX_ID) || (table->versioned() && table->s->table_category == TABLE_CATEGORY_TEMPORARY)' failed.
 
230725 14:01:32 [ERROR] mysqld got signal 6 ;
 
 
 
Server version: 11.2.0-MariaDB-debug-log source revision: cb6307f7099ede2016e6a42e440176c290727fa5
 
 
 
sql/field.cc:2306(Field_vers_trx_id::get_date(st_mysql_time*, date_mode_t, unsigned long long))[0x556a3dea387e]
 
sql/field.h:2837(Field_vers_trx_id::get_date(st_mysql_time*, date_mode_t))[0x556a3defd54a]
 
sql/item.cc:3395(Item_field::get_date_result(THD*, st_mysql_time*, date_mode_t))[0x556a3dfa2287]
 
sql/item.cc:8576(Item_ref::get_date(THD*, st_mysql_time*, date_mode_t))[0x556a3dfcafb8]
 
sql/sql_type.cc:1010(Temporal_with_date::make_from_item(THD*, Item*, date_mode_t))[0x556a3dcc17be]
 
sql/sql_type.h:2119(Temporal_with_date::Temporal_with_date(THD*, Item*, date_mode_t))[0x556a3d26cd67]
 
sql/sql_type.h:2399(Datetime::Datetime(THD*, Item*, date_mode_t))[0x556a3d26d1d7]
 
sql/item_timefunc.h:1445(Item_func_timestamp::get_date(THD*, st_mysql_time*, date_mode_t))[0x556a3de08bd4]
 
sql/sql_type.cc:1010(Temporal_with_date::make_from_item(THD*, Item*, date_mode_t))[0x556a3dcc17be]
 
sql/sql_type.h:2119(Temporal_with_date::Temporal_with_date(THD*, Item*, date_mode_t))[0x556a3d26cd67]
 
sql/sql_type.h:2399(Datetime::Datetime(THD*, Item*, date_mode_t))[0x556a3d26d1d7]
 
sql/item.h:2052(Item::val_datetime_packed(THD*))[0x556a3d26f9ba]
 
sql/item_cmpfunc.cc:747(Arg_comparator::compare_datetime())[0x556a3dfff183]
 
sql/item_cmpfunc.h:104(Arg_comparator::compare())[0x556a3e042a0a]
 
sql/item_cmpfunc.cc:1820(Item_func_gt::val_int())[0x556a3e00ba91]
 
sql/item.cc:343(Item::val_decimal_from_int(my_decimal*))[0x556a3df872f1]
 
sql/item_func.h:1168(Item_int_func::val_decimal(my_decimal*))[0x556a3d2ff81f]
 
sql/sql_type.cc:301(VDec::VDec(Item*))[0x556a3dcbb286]
 
sql/item_cmpfunc.cc:894(Arg_comparator::compare_e_decimal())[0x556a3e0016d3]
 
sql/item_cmpfunc.h:104(Arg_comparator::compare())[0x556a3e042a0a]
 
sql/item_cmpfunc.cc:1798(Item_func_equal::val_int())[0x556a3e00b857]
 
sql/item.cc:6862(Item::save_int_in_field(Field*, bool))[0x556a3dfbcb73]
 
sql/sql_type.cc:4343(Type_handler_int_result::Item_save_in_field(Item*, Field*, bool) const)[0x556a3dcd2d34]
 
sql/item.cc:6872(Item::save_in_field(Field*, bool))[0x556a3dfbcd57]
 
sql/item.h:3489(Item_result_field::save_in_result_field(bool))[0x556a3d2fdbc0]
 
sql/sql_select.cc:28836(copy_funcs(Item**, THD const*))[0x556a3d7c3db1]
 
sql/sql_select.cc:24966(end_write(JOIN*, st_join_table*, bool))[0x556a3d7a8e22]
 
sql/sql_select.cc:32242(AGGR_OP::put_record(bool))[0x556a3d7ddb3a]
 
sql/sql_select.h:1180(AGGR_OP::put_record())[0x556a3d7f2495]
 
sql/sql_select.cc:23121(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x556a3d79b873]
 
sql/sql_select.cc:23664(evaluate_join_record(JOIN*, st_join_table*, int))[0x556a3d79e4ad]
 
sql/sql_select.cc:32323(AGGR_OP::end_send())[0x556a3d7de21a]
 
sql/sql_select.cc:23115(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x556a3d79b7e1]
 
sql/sql_select.cc:23365(sub_select(JOIN*, st_join_table*, bool))[0x556a3d79c2ad]
 
sql/sql_select.cc:22950(do_select(JOIN*, Procedure*))[0x556a3d79a80e]
 
sql/sql_select.cc:4933(JOIN::exec_inner())[0x556a3d71a7a1]
 
sql/sql_select.cc:4710(JOIN::exec())[0x556a3d717b9a]
 
sql/sql_select.cc:5239(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x556a3d71c167]
 
sql/sql_select.cc:627(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x556a3d6ec00d]
 
sql/sql_parse.cc:6030(execute_sqlcom_select(THD*, TABLE_LIST*))[0x556a3d613174]
 
sql/sql_parse.cc:3944(mysql_execute_command(THD*, bool))[0x556a3d603d25]
 
sql/sql_parse.cc:7769(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x556a3d61daee]
 
sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x556a3d5f669a]
 
sql/sql_parse.cc:1405(do_command(THD*, bool))[0x556a3d5f338d]
 
sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x556a3dab71b0]
 
sql/sql_connect.cc:1320(handle_one_connection)[0x556a3dab6b06]
 
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x556a3e7a6d61]
 
nptl/pthread_create.c:487(start_thread)[0x7f1a63852fa3]
 
x86_64/clone.S:97(clone)[0x7f1a6345c06f]

Generated at Thu Feb 08 08:49:17 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.