Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-33017

Assertion `temp > 1969' fails in Field_timestamp::val_str on 32-bit

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • N/A
    • N/A
    • Temporal Types
    • None
    • i386

    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

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.