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

Cassandra: Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed on DELETE with ORDER BY

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 10.0.0
    • None
    • None

    Description

      This is most likely either the same problem as MDEV-476, or a closely related one. The test case is exactly the same, except that in this bug we execute the flow in the second connection and get the assertion failure; while in MDEV-476 we execute the flow in the first connection, and get the crash. It happens both with MTR and if I start the server and execute the test manually.

      With MTR, the flow, according to the general log, is such:

      MDEV-476:

      • server starts;
      • connection 1 connects;
      • connection 1 executes MTR service stuff;
      • connection 1 quits;
      • connection 2 connects;
      • connection 2 executes the test case statements;
      • server crashes

      This bug:

      • server starts;
      • connection 1 connects;
      • connection 1 executes MTR service stuff;
      • connection 1 quits;
      • connection 2 connects;
      • connection 3 connects;
      • connection 3 executes the test case statements;
      • assertion fails.

      When I execute it manually, I do it even simpler:

      MDEV-476:

      • start the server;
      • connection 1 connects;
      • connection 1 executes the test case statements;
      • server crashes.

      This bug:

      • start the server;
      • connection 1 connects;
      • connection 1 quits;
      • connection 2 connects;
      • connection 2 executes the test case statements;
      • assertion fails.

      I find the difference in behavior disturbing, so I'll file it separately just so it doesn't get lost. Please feel free to close it as a duplicate if that's what it is. 

      mysqld: sql/field.cc:3795: virtual longlong Field_longlong::val_int(): Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed.
      		 

      #8  0xb7498014 in __assert_fail () from /lib/libc.so.6
      		 
      #9  0x083eb8fb in Field_longlong::val_int (this=0x97cf9e0)
      		 
          at sql/field.cc:3795
      		 
      #10 0x0859216e in BigintDataConverter::mariadb_to_cassandra(char**, int*) ()
      		 
      #11 0x08590d12 in ha_cassandra::index_read_map (this=0x97cf580,
      		 
          buf=0x97cf9a0 "\377", key=0x97d73e8 "\001", keypart_map=1,
      		 
          find_flag=HA_READ_KEY_EXACT)
      		 
          at storage/cassandra/ha_cassandra.cc:648
      		 
      #12 0x085917ad in ha_cassandra::rnd_pos (this=0x97cf580,
      		 
          buf=0x97cf9a0 "\377", pos=0x97d73e8 "\001")
      		 
          at storage/cassandra/ha_cassandra.cc:882
      		 
      #13 0x082651eb in handler::ha_rnd_pos (this=0x97cf580,
      		 
          buf=0x97cf9a0 "\377", pos=0x97d73e8 "\001")
      		 
          at sql/sql_class.h:4283
      		 
      #14 0x0851989b in rr_from_pointers (info=0xacec6714)
      		 
          at sql/records.cc:529
      		 
      #15 0x0853b984 in mysql_delete (thd=0x97afe68, table_list=0x97b23e0,
      		 
          conds=0x0, order_list=0x97b1a20, limit=1, options=0)
      		 
          at sql/sql_delete.cc:327
      		 
      #16 0x08278fe7 in mysql_execute_command (thd=0x97afe68)
      		 
          at sql/sql_parse.cc:3050
      		 
      #17 0x08280453 in mysql_parse (thd=0x97afe68,
      		 
          rawbuf=0x97b2320 "DELETE FROM t1 ORDER BY a LIMIT 1", length=33,
      		 
          parser_state=0xacec6da4)
      		 
          at sql/sql_parse.cc:5736
      		 
      #18 0x0827489c in dispatch_command (command=COM_QUERY, thd=0x97afe68,
      		 
          packet=0x97c6da1 "DELETE FROM t1 ORDER BY a LIMIT 1",
      		 
          packet_length=33)
      		 
          at sql/sql_parse.cc:1055
      		 
      #19 0x08273d61 in do_command (thd=0x97afe68)
      		 
          at sql/sql_parse.cc:794
      		 
      #20 0x0835fb11 in do_handle_one_connection (thd_arg=0x97afe68)
      		 
          at sql/sql_connect.cc:1253
      		 
      #21 0x0835f65c in handle_one_connection (arg=0x97afe68)
      		 
          at sql/sql_connect.cc:1168
      		 
      #22 0x0858bf70 in pfs_spawn_thread (arg=0x97e7d50)
      		 
          at storage/perfschema/pfs.cc:1015
      		 
      #23 0xb7811b25 in start_thread () from /lib/libpthread.so.0
      		 
       
      		 

      revision-id: psergey@askmonty.org-20120821143827-1gfv6fmua0cu29sl
      		 
      date: 2012-08-21 18:38:27 +0400
      		 
      build-date: 2012-08-23 00:46:27 +0400
      		 
      revno: 3492

      Test case:

       
      		 
      --connect (con1,localhost,root,,)
      		 
       
      		 
      DROP TABLE IF EXISTS t1;
      		 
      CREATE TABLE t1 (rowkey BIGINT PRIMARY KEY, a BIGINT) ENGINE=CASSANDRA
      		 
        thrift_host='localhost' keyspace='storage_engine' column_family = 'colfam_t1';
      		 
       
      		 
      INSERT INTO t1 VALUES (1,1),(2,2);
      		 
      DELETE FROM t1 ORDER BY a LIMIT 1;

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-431 Cassandra storage engine

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-476 Cassandra: Server crashes in calculate_key_len on DELETE with ORDER BY

          • Major - Major loss of function.
          • Closed

          Activity

            People

              psergei Sergei Petrunia
              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.