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

ER_DATA_TOO_LONG or Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed upon UPDATE on RocksDB table

Details

    Description

      INSTALL SONAME 'ha_rocksdb';
       
      CREATE TABLE t1 (
          pk INT PRIMARY KEY,
          a VARCHAR(16) CHARACTER SET utf8,
          b INT,
          KEY(a)
      ) ENGINE=RocksDB;
       
      --error ER_DATA_TOO_LONG
      UPDATE t1 SET b = 1 WHERE a LIKE 'bar%';
      

      10.2 13535b27

      mysqld: /data/src/10.2/sql/sql_error.cc:380: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed.
      191008  2:40:02 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007fd23e77ef12 in __GI___assert_fail (assertion=0x55b652d9ae78 "!is_set() || (m_status == DA_OK_BULK && is_bulk_op())", file=0x55b652d9adb0 "/data/src/10.2/sql/sql_error.cc", line=380, function=0x55b652d9b1c0 <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  0x000055b6522d97b3 in Diagnostics_area::set_ok_status (this=0x7fd228005cb0, affected_rows=0, last_insert_id=0, message=0x7fd238ab13c0 "Rows matched: 0  Changed: 0  Warnings: 2") at /data/src/10.2/sql/sql_error.cc:380
      #9  0x000055b65228c5b3 in my_ok (thd=0x7fd228000b00, affected_rows=0, id=0, message=0x7fd238ab13c0 "Rows matched: 0  Changed: 0  Warnings: 2") at /data/src/10.2/sql/sql_class.h:4547
      #10 0x000055b6523f804c in mysql_update (thd=0x7fd228000b00, table_list=0x7fd228012560, fields=..., values=..., conds=0x7fd228012f88, order_num=0, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7fd238ab1870, updated_return=0x7fd238ab1920) at /data/src/10.2/sql/sql_update.cc:1023
      #11 0x000055b652307f0d in mysql_execute_command (thd=0x7fd228000b00) at /data/src/10.2/sql/sql_parse.cc:4014
      #12 0x000055b652313d8e in mysql_parse (thd=0x7fd228000b00, rawbuf=0x7fd228012468 "UPDATE t1 SET b = 1 WHERE a LIKE 'bar%'", length=39, parser_state=0x7fd238ab2200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7759
      #13 0x000055b652302097 in dispatch_command (command=COM_QUERY, thd=0x7fd228000b00, packet=0x7fd22808d6f1 "UPDATE t1 SET b = 1 WHERE a LIKE 'bar%'", packet_length=39, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1831
      #14 0x000055b6523009eb in do_command (thd=0x7fd228000b00) at /data/src/10.2/sql/sql_parse.cc:1384
      #15 0x000055b652455ca5 in do_handle_one_connection (connect=0x55b65564d860) at /data/src/10.2/sql/sql_connect.cc:1336
      #16 0x000055b652455a10 in handle_one_connection (arg=0x55b65564d860) at /data/src/10.2/sql/sql_connect.cc:1241
      #17 0x000055b652c86a40 in pfs_spawn_thread (arg=0x55b655670b10) at /data/src/10.2/storage/perfschema/pfs.cc:1862
      #18 0x00007fd2402f44a4 in start_thread (arg=0x7fd238ab3700) at pthread_create.c:456
      #19 0x00007fd23e83bd0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      Non-debug build doesn't crash, but it produces an error which looks unexpected:

      CURRENT_TEST: bug.4282
      mysqltest: At line 10: query 'UPDATE t1 SET b = 1 WHERE a LIKE 'bar%'' failed: 1406: Data too long for column 'a' at row 1
      

      Reproducible on 10.2-10.5.

      Note: the table is created with a warning:

      Warnings:
      Warning	1815	Internal error: Indexed column test.t1.a uses a collation that does not allow index-only access in secondary key and has reduced disk space efficiency in primary key.
      

      Attachments

        Activity

          No workflow transitions have been executed yet.

          People

            psergei Sergei Petrunia
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.