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

LP:697610 - ha_index_prev(uchar*): Assertion `inited==INDEX' failed with HANDLER + InnoDB in maria-5.3

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      Affected versions: maria-5.3 , maria-5.3-handler . Not affected, maria-5.1, maria-5.2 , mysql-5.1 mysql-5.5

      Assertion:

      mysqld: sql_class.h:3552: int handler::ha_index_prev(uchar*): Assertion `inited==INDEX' failed.

      backtrace:

      #8 0x006b0d98 in __assert_fail () from /lib/libc.so.6
      #9 0x081b21b8 in handler::ha_index_prev (this=0xa0cb1c0,
      buf=0xa0cb6e8 "\377\217\217\217\217\217\217\217\217\245\245\245\245\245\245\245\377\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\030\267\f\n\200\267\f\n") at sql_class.h:3552
      #10 0x081b0d88 in mysql_ha_read (thd=0xa06e9d8, tables=0xa0bbe90, mode=RPREV, keyname=0xa0bc098 "PRIMARY", key_expr=0xa5a5a5a5,
      ha_rkey_mode=HA_READ_KEY_EXACT, cond=0x0, select_limit_cnt=1, offset_limit_cnt=0) at sql_handler.cc:606
      #11 0x082a1461 in mysql_execute_command (thd=0xa06e9d8) at sql_parse.cc:4061
      #12 0x082a6f46 in mysql_parse (thd=0xa06e9d8, rawbuf=0xa0bbd78 "HANDLER t1 READ `PRIMARY` PREV", length=30, found_semicolon=0x9f6fb228) at sql_parse.cc:6077
      #13 0x08298eac in dispatch_command (command=COM_QUERY, thd=0xa06e9d8, packet=0xa086a69 "", packet_length=30) at sql_parse.cc:1210
      #14 0x08298316 in do_command (thd=0xa06e9d8) at sql_parse.cc:903
      #15 0x082953f2 in handle_one_connection (arg=0xa06e9d8) at sql_connect.cc:1154
      #16 0x00821919 in start_thread () from /lib/libpthread.so.0
      #17 0x0076acce in clone () from /lib/libc.so.6

      test case:

      --source include/have_innodb.inc
      --disable_abort_on_error
      CREATE TABLE t1 ( f1 integer, f2 integer, primary key (f1), key (f2)) ENGINE=innodb;
      HANDLER t1 OPEN;
      HANDLER t1 READ FIRST WHERE f2 <= 1;
      HANDLER t1 OPEN;
      HANDLER t1 READ `PRIMARY` PREV;

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 697610

            Show
            ratzpo Rasmus Johansson added a comment - Launchpad bug id: 697610

              People

              • Assignee:
                monty Michael Widenius
                Reporter:
                philipstoev Philip Stoev
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: