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

Assertion `max_ts.cmp(Timestamp(0, 0)) == 0' failed in prep_alter_part_table() on ALTER ... INTERVAL ... AUTO when the only history row has row_end within the first second of 1970

    XMLWordPrintable

Details

    Description

      --source include/have_innodb.inc
      --source include/have_partition.inc
      create table t1 (a int) engine=innodb with system versioning;
      set timestamp=0.000001;
      insert into t1 values (1);
      delete from t1;
      alter table t1 partition by system_time interval 1 day auto;
      drop table t1;
      

      13.2.0-MariaDB-asan-debug source revision: cc85c4fb7a8eeaddf910fa0be358e7c8860402be
      mariadbd: /main/src/sql/sql_partition.cc:6322: uint prep_alter_part_table(THD*, TABLE*, Alter_info*, HA_CREATE_INFO*, bool*, bool*): Assertion `max_ts.cmp(Timestamp(0, 0)) == 0' failed.
      #3  0x00005aaa6baf972f in my_write_core (sig=6) at /main/src/mysys/stacktrace.c:424
      #4  0x00005aaa69e05486 in handle_fatal_signal (sig=6) at /main/src/sql/signal_handler.cc:300
      #5  <signal handler called>
      #6  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:44
      #7  __pthread_kill_internal (signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:78
      #8  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
      #9  0x000070019564527e in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
      #10 0x00007001956288ff in __GI_abort () at ./stdlib/abort.c:79
      #11 0x000070019562881b in __assert_fail_base (...) at ./assert/assert.c:96
      #12 0x000070019563b517 in __assert_fail (assertion=0x5aaa69288ec0 "max_ts.cmp(Timestamp(0, 0)) == 0", file=0x5aaa6927f3c0 "/main/src/sql/sql_partition.cc", line=6322, function=0x5aaa69288680 "uint prep_alter_part_table(THD*, TABLE*, Alter_info*, HA_CREATE_INFO*, bool*, bool*)") at ./assert/assert.c:105
      #13 0x00005aaa6a6ed329 in prep_alter_part_table (thd=thd@entry=0x52c0001a0220, table=table@entry=0x519000075da0, alter_info=alter_info@entry=0x68017fe7e100, create_info=create_info@entry=0x68017fe7e2c0, partition_changed=partition_changed@entry=0x6801800cc030, fast_alter_table=fast_alter_table@entry=0x6801800cdd99) at /main/src/sql/sql_partition.cc:6322
      #14 0x00005aaa6a981b30 in mysql_alter_table (...) at /main/src/sql/sql_table.cc
      #15 0x00005aaa6ab50296 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x52c0001a0220) at /main/src/sql/sql_alter.cc:720
      #16 0x00005aaa6a6ad89b in mysql_execute_command (thd=thd@entry=0x52c0001a0220, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /main/src/sql/sql_parse.cc:5947
      #17 0x00005aaa6a6af7d3 in mysql_parse (thd=thd@entry=0x52c0001a0220, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x68017ff441b0) at /main/src/sql/sql_parse.cc:8005
      #18 0x00005aaa6a6b3487 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x52c0001a0220, packet=packet@entry=0x52900014f221 "alter table t1 partition by system_time interval 1 day auto", packet_length=packet_length@entry=59, blocking=blocking@entry=true) at /main/src/sql/sql_parse.cc:1903
      #19 0x00005aaa6a6b7ce9 in do_command (thd=thd@entry=0x52c0001a0220, blocking=blocking@entry=true) at /main/src/sql/sql_parse.cc:1437
      #20 0x00005aaa6ab3592b in do_handle_one_connection (connect=<optimized out>, connect@entry=0x50b0000054f0, put_in_cache=put_in_cache@entry=true) at /main/src/sql/sql_connect.cc:1514
      #21 0x00005aaa6ab35d31 in handle_one_connection (arg=arg@entry=0x50b0000054f0) at /main/src/sql/sql_connect.cc:1426
      

      Attachments

        Issue Links

          Activity

            People

              midenok Aleksey Midenkov
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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