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

ER_NOT_KEYFILE or Assertion `! is_set()' failed Diagnostics_area::set_ok_status upon LOAD into temporary Aria table

    XMLWordPrintable

    Details

      Description

      Note: I don't really expect it will be fixed since only 10.1 is affected, but filing it for the record, and keeping priority Major because release builds also end up with an error, although don't crash.

      --write_file $MYSQLTEST_VARDIR/tmp/load.data
      1
      EOF
      CREATE TEMPORARY TABLE t1 (a INT, KEY(a)) ENGINE=Aria ROW_FORMAT=DYNAMIC;
      REPLACE INTO t1 VALUES (0);
      DELETE FROM t1 LIMIT 4;
      OPTIMIZE TABLE t1;
      --eval LOAD DATA LOCAL INFILE '$MYSQLTEST_VARDIR/tmp/load.data' REPLACE INTO TABLE t1;
       
      # Cleanup
      --remove_file $MYSQLTEST_VARDIR/tmp/load.data
      

      10.1 debug cb204e11

      mysqld: /data/src/10.1/sql/sql_error.cc:378: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `! is_set()' failed.
      200112  0:54:18 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f6379630f12 in __GI___assert_fail (assertion=0x5597dbf27628 "! is_set()", file=0x5597dbf27560 "/data/src/10.1/sql/sql_error.cc", line=378, function=0x5597dbf27940 <Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:101
      #8  0x00005597db55d2eb in Diagnostics_area::set_ok_status (this=0x7f63727d0008, affected_rows=1, last_insert_id=0, message=0x7f637b25c210 "Records: 1  Deleted: 0  Skipped: 0  Warnings: 1") at /data/src/10.1/sql/sql_error.cc:378
      #9  0x00005597db5160db in my_ok (thd=0x7f63727cb070, affected_rows=1, id=0, message=0x7f637b25c210 "Records: 1  Deleted: 0  Skipped: 0  Warnings: 1") at /data/src/10.1/sql/sql_class.h:4213
      #10 0x00005597db940d21 in mysql_load (thd=0x7f63727cb070, ex=0x7f63708f6210, table_list=0x7f63708f6298, fields_vars=..., set_fields=..., set_values=..., handle_duplicates=DUP_REPLACE, ignore=false, read_file_from_client=true) at /data/src/10.1/sql/sql_load.cc:726
      #11 0x00005597db58a2de in mysql_execute_command (thd=0x7f63727cb070) at /data/src/10.1/sql/sql_parse.cc:4066
      #12 0x00005597db593d37 in mysql_parse (thd=0x7f63727cb070, rawbuf=0x7f63708f6088 "LOAD DATA LOCAL INFILE '/data/bld/10.1-debug-nightly/mysql-test/var/tmp/load.data' REPLACE INTO TABLE t1", length=104, parser_state=0x7f637b25d1e0) at /data/src/10.1/sql/sql_parse.cc:7209
      #13 0x00005597db582ee9 in dispatch_command (command=COM_QUERY, thd=0x7f63727cb070, packet=0x7f63747ee071 "", packet_length=105) at /data/src/10.1/sql/sql_parse.cc:1499
      #14 0x00005597db581ca7 in do_command (thd=0x7f63727cb070) at /data/src/10.1/sql/sql_parse.cc:1131
      #15 0x00005597db6bf963 in do_handle_one_connection (thd_arg=0x7f63727cb070) at /data/src/10.1/sql/sql_connect.cc:1331
      #16 0x00005597db6bf694 in handle_one_connection (arg=0x7f63727cb070) at /data/src/10.1/sql/sql_connect.cc:1242
      #17 0x00005597dbaf54c2 in pfs_spawn_thread (arg=0x7f6378c39c70) at /data/src/10.1/storage/perfschema/pfs.cc:1861
      #18 0x00007f637aedf4a4 in start_thread (arg=0x7f637b25e700) at pthread_create.c:456
      #19 0x00007f63796edd0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      10.1 non-debug cb204e11

      mysqltest: At line 8: query 'LOAD DATA LOCAL INFILE '$MYSQLTEST_VARDIR/tmp/load.data' REPLACE INTO TABLE t1;' failed: 1034: Number of rows changed from 1 to 0
      

      Not reproducible on 10.2-10.5.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              vlad.lesin Vladislav Lesin
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated: