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

Server crashes in handler::ha_write_row or handler::mark_trx_read_write

    XMLWordPrintable

Details

    Description

      --source include/have_partition.inc
       
      CREATE TABLE t1 (
          a INT,
          s TIMESTAMP(6) AS ROW START,
          e TIMESTAMP(6) AS ROW END,
          PERIOD FOR SYSTEM_TIME(s,e)
      ) WITH SYSTEM VERSIONING
        ENGINE=MyISAM
        PARTITION BY system_time ( PARTITION p1 HISTORY, PARTITION pn CURRENT );
       
      INSERT INTO t1 () VALUES ();
      SET SQL_MODE= 'SIMULTANEOUS_ASSIGNMENT';
      --error 0,ER_WARNING_NON_DEFAULT_VALUE_FOR_GENERATED_COLUMN
      UPDATE t1 SET e = NOW();
      --error ER_NO_DEFAULT_FOR_FIELD
      INSERT INTO t1 (a) VALUES (1);
       
      # Cleanup
      DROP TABLE t1;
      

      10.4 09e9f884 debug

      #3  <signal handler called>
      #4  0x00005627cc6a8f37 in handler::ha_write_row (this=0xffffff7f7c1388c8, buf=0x7ffb7c1341f8 "\375\001") at /data/src/10.4/sql/handler.cc:6665
      #5  0x00005627cce1cb76 in ha_partition::write_row (this=0x7ffb7c1378a8, buf=0x7ffb7c1341f8 "\375\001") at /data/src/10.4/sql/ha_partition.cc:4318
      #6  0x00005627cc6a91a5 in handler::ha_write_row (this=0x7ffb7c1378a8, buf=0x7ffb7c1341f8 "\375\001") at /data/src/10.4/sql/handler.cc:6682
      #7  0x00005627cc317a08 in write_record (thd=0x7ffb7c000b00, table=0x7ffb7c136a40, info=0x7ffb8d5de4b0) at /data/src/10.4/sql/sql_insert.cc:2037
      #8  0x00005627cc314d17 in mysql_insert (thd=0x7ffb7c000b00, table_list=0x7ffb7c0131f0, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /data/src/10.4/sql/sql_insert.cc:1075
      #9  0x00005627cc35f93c in mysql_execute_command (thd=0x7ffb7c000b00) at /data/src/10.4/sql/sql_parse.cc:4528
      #10 0x00005627cc36b7ed in mysql_parse (thd=0x7ffb7c000b00, rawbuf=0x7ffb7c013108 "INSERT INTO t1 (a) VALUES (1)", length=29, parser_state=0x7ffb8d5df180, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7908
      #11 0x00005627cc357a96 in dispatch_command (command=COM_QUERY, thd=0x7ffb7c000b00, packet=0x7ffb7c008311 "INSERT INTO t1 (a) VALUES (1)", packet_length=29, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1843
      #12 0x00005627cc3561dc in do_command (thd=0x7ffb7c000b00) at /data/src/10.4/sql/sql_parse.cc:1360
      #13 0x00005627cc4cf716 in do_handle_one_connection (connect=0x5627ceb82cb0) at /data/src/10.4/sql/sql_connect.cc:1404
      #14 0x00005627cc4cf465 in handle_one_connection (arg=0x5627ceb82cb0) at /data/src/10.4/sql/sql_connect.cc:1306
      #15 0x00005627ccdfab09 in pfs_spawn_thread (arg=0x5627cebe6630) at /data/src/10.4/storage/perfschema/pfs.cc:1862
      #16 0x00007ffb94f824a4 in start_thread (arg=0x7ffb8d5e0700) at pthread_create.c:456
      #17 0x00007ffb934cad0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      10.4 09e9f884 non-debug

      #3  <signal handler called>
      #4  handler::mark_trx_read_write (this=0xffffff7f88081980) at /data/src/10.4/sql/handler.h:4512
      #5  handler::ha_write_row (this=0xffffff7f88081980, buf=buf@entry=0x7f4288080670 "\375\001") at /data/src/10.4/sql/handler.cc:6671
      #6  0x00005622a348606b in ha_partition::write_row (this=0x7f4288080a40, buf=0x7f4288080670 "\375\001") at /data/src/10.4/sql/ha_partition.cc:4318
      #7  0x00005622a2fe518e in handler::ha_write_row (this=0x7f4288080a40, buf=0x7f4288080670 "\375\001") at /data/src/10.4/sql/handler.cc:6682
      #8  0x00005622a2db4f66 in write_record (thd=thd@entry=0x7f42880009a8, table=table@entry=0x7f42880872b8, info=info@entry=0x7f4298f528d0) at /data/src/10.4/sql/sql_insert.cc:2037
      #9  0x00005622a2dbc0dd in mysql_insert (thd=thd@entry=0x7f42880009a8, table_list=<optimized out>, fields=..., values_list=..., update_fields=..., update_values=..., duplic=<optimized out>, ignore=<optimized out>) at /data/src/10.4/sql/sql_insert.cc:1075
      #10 0x00005622a2de8bac in mysql_execute_command (thd=thd@entry=0x7f42880009a8) at /data/src/10.4/sql/sql_parse.cc:4528
      #11 0x00005622a2ded6c9 in mysql_parse (thd=thd@entry=0x7f42880009a8, rawbuf=<optimized out>, length=29, parser_state=parser_state@entry=0x7f4298f551c0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.4/sql/sql_parse.cc:7908
      #12 0x00005622a2defa4e in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f42880009a8, packet=packet@entry=0x7f4288007979 "INSERT INTO t1 (a) VALUES (1)", packet_length=packet_length@entry=29, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.4/sql/sql_parse.cc:1843
      #13 0x00005622a2df11c9 in do_command (thd=0x7f42880009a8) at /data/src/10.4/sql/sql_parse.cc:1360
      #14 0x00005622a2ebf59e in do_handle_one_connection (connect=connect@entry=0x5622a59945c8) at /data/src/10.4/sql/sql_connect.cc:1404
      #15 0x00005622a2ebf6b4 in handle_one_connection (arg=arg@entry=0x5622a59945c8) at /data/src/10.4/sql/sql_connect.cc:1306
      #16 0x00005622a3467f44 in pfs_spawn_thread (arg=0x5622a59273b8) at /data/src/10.4/storage/perfschema/pfs.cc:1862
      #17 0x00007f42a08fa4a4 in start_thread (arg=0x7f4298f56700) at pthread_create.c:456
      #18 0x00007f429ee42d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      Attachments

        Issue Links

          Activity

            People

              midenok Aleksey Midenkov
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.