[MDEV-33017] Assertion `temp > 1969' fails in Field_timestamp::val_str on 32-bit Created: 2023-12-14  Updated: 2023-12-18  Resolved: 2023-12-18

Status: Closed
Project: MariaDB Server
Component/s: Temporal Types
Affects Version/s: N/A
Fix Version/s: N/A

Type: Bug Priority: Critical
Reporter: Elena Stepanova Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: None
Environment:

i386


Issue Links:
Problem/Incident
is caused by MDEV-32188 make TIMESTAMP use whole 32-bit unsig... In Testing

 Description   

A couple of MTR tests fail on i386 debug builds:

bb-11.3-timestamp fd6689da3fffc4d57d8ebde5f8776aefa8cdb8a4

innodb.instant_alter '32k,innodb'        [ fail ]
        Test ended at 2023-12-13 19:50:37
 
CURRENT_TEST: innodb.instant_alter
mysqltest: At line 316: query 'ANALYZE TABLE big' failed: <Unknown> (2013): Lost connection to server during query

mariadbd: /home/buildbot/bb-11.3-timestamp/sql/field.cc:5454: virtual String* Field_timestamp::val_str(String*, String*): Assertion `temp > 1969' failed.
231213 19:50:35 [ERROR] mysqld got signal 6 ;
 
#9  0xb703fd8b in __assert_fail () from /lib/i386-linux-gnu/libc.so.6
#10 0x80b2a8db in Field_timestamp::val_str (this=0xaa922fd0, val_buffer=0xad354ff4, val_ptr=0xad354ff4) at /home/buildbot/bb-11.3-timestamp/sql/field.cc:5454
#11 0x806383ca in Field::val_str (this=0xaa922fd0, str=0xad354ff4) at /home/buildbot/bb-11.3-timestamp/sql/field.h:1040
#12 0x809bd665 in Histogram_json_builder::append_column_value (this=0xaec17290, elem=0xaa7100e4, is_start=true) at /home/buildbot/bb-11.3-timestamp/sql/opt_histogram_json.cc:241
#13 0x809bd599 in Histogram_json_builder::start_bucket (this=0xaec17290, elem=0xaa7100e4, cnt=32) at /home/buildbot/bb-11.3-timestamp/sql/opt_histogram_json.cc:224
#14 0x809bd98e in Histogram_json_builder::next (this=0xaec17290, elem=0xaa7100e4, elem_cnt=32) at /home/buildbot/bb-11.3-timestamp/sql/opt_histogram_json.cc:316
#15 0x808779e4 in histogram_build_walk (elem=0xaa7100e4, elem_cnt=32, arg=0xaec17290) at /home/buildbot/bb-11.3-timestamp/sql/sql_statistics.cc:1674
#16 0x813b428b in tree_walk_left_root_right (tree=0xaec12c00, element=0xaa7100d8, action=0x808779b9 <histogram_build_walk(void*, element_count, void*)>, argument=0xaec17290) at /home/buildbot/bb-11.3-timestamp/mysys/tree.c:589
#17 0x813b41ec in tree_walk (tree=0xaec12c00, action=0x808779b9 <histogram_build_walk(void*, element_count, void*)>, argument=0xaec17290, visit=left_root_right) at /home/buildbot/bb-11.3-timestamp/mysys/tree.c:576
#18 0x80917214 in Unique::walk (this=0xaec12b08, table=0xaa928770, action=0x808779b9 <histogram_build_walk(void*, element_count, void*)>, walk_action_arg=0xaec17290) at /home/buildbot/bb-11.3-timestamp/sql/uniques.cc:657
#19 0x8087fcc9 in Count_distinct_field::walk_tree_with_histogram (this=0xaec12ae8, rows=32) at /home/buildbot/bb-11.3-timestamp/sql/sql_statistics.cc:1782
#20 0x808808b7 in Column_statistics_collected::finish (this=0xaa92aa34, mem_root=0xaa928944, rows=32, sample_fraction=1) at /home/buildbot/bb-11.3-timestamp/sql/sql_statistics.cc:2508
#21 0x80878b26 in collect_statistics_for_table (thd=0xaec015c0, table=0xaa928770) at /home/buildbot/bb-11.3-timestamp/sql/sql_statistics.cc:2819
#22 0x8096995e in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const LEX_CSTRING *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), bool) (thd=0xaec015c0, tables=0xaec10dc0, check_opt=0xaec04d20, operator_name=0x81e99828 <msg_analyze>, lock_type=TL_READ_NO_INSERT, org_open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x80b693c4 <handler::ha_analyze(THD*, st_ha_check_opt*)>, view_operator_func=0x0, is_cmd_replicated=true) at /home/buildbot/bb-11.3-timestamp/sql/sql_admin.cc:987
#23 0x8096b504 in Sql_cmd_analyze_table::execute (this=0xaec112b0, thd=0xaec015c0) at /home/buildbot/bb-11.3-timestamp/sql/sql_admin.cc:1485
#24 0x80787247 in mysql_execute_command (thd=0xaec015c0, is_called_from_prepared_stmt=false) at /home/buildbot/bb-11.3-timestamp/sql/sql_parse.cc:5723
#25 0x8078d0d6 in mysql_parse (thd=0xaec015c0, rawbuf=0xaec10d28 "ANALYZE TABLE big", length=17, parser_state=0xad356820) at /home/buildbot/bb-11.3-timestamp/sql/sql_parse.cc:7735
#26 0x8077a582 in dispatch_command (command=COM_QUERY, thd=0xaec015c0, packet=0xaec08999 "", packet_length=17, blocking=true) at /home/buildbot/bb-11.3-timestamp/sql/sql_parse.cc:1893
#27 0x80778caf in do_command (thd=0xaec015c0, blocking=true) at /home/buildbot/bb-11.3-timestamp/sql/sql_parse.cc:1407
#28 0x809509f6 in do_handle_one_connection (connect=0x842abb28, put_in_cache=true) at /home/buildbot/bb-11.3-timestamp/sql/sql_connect.cc:1445
#29 0x8095070c in handle_one_connection (arg=0x842abb28) at /home/buildbot/bb-11.3-timestamp/sql/sql_connect.cc:1347
#30 0x80e59880 in pfs_spawn_thread (arg=0x84249838) at /home/buildbot/bb-11.3-timestamp/storage/perfschema/pfs.cc:2201
#31 0xb73c62b5 in start_thread () from /lib/i386-linux-gnu/libpthread.so.0
#32 0xb710216e in clone () from /lib/i386-linux-gnu/libc.so.6

Another test failing the similar way is rpl.rpl_slow_query_log.

Example: https://buildbot.mariadb.net/buildbot/builders/kvm-fulltest2/builds/43443/steps/mtr_nm/logs/stdio



 Comments   
Comment by Michael Widenius [ 2023-12-15 ]

This works on my machine built for 32 bit.

Comment by Michael Widenius [ 2023-12-18 ]

Fixed by changing assert to >= 1969

Comment by Michael Widenius [ 2023-12-18 ]

Fixed in bb-11.3-timestamp

Generated at Thu Feb 08 10:35:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.