Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-3841 LevelDB storage engine
  3. MDEV-4060

LevelDB: Assertion `! trx->batch' fails in Ldb_transaction* get_or_create_trx(THD*) on SELECT after rolling back a transaction which didn't make changes

    XMLWordPrintable

Details

    • Technical task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      mysqld: mysql-5.6-leveldb/storage/leveldb/ha_leveldb.cc:306: Ldb_transaction* get_or_create_trx(THD*): Assertion `!
      trx->batch' failed.
      16:07:39 UTC - mysqld got signal 6 ;

      #9  0xb7365167 in __assert_fail () from /lib/libc.so.6
      #10 0x0891b327 in get_or_create_trx (thd=0xab13e08) at mysql-5.6-leveldb/storage/leveldb/ha_leveldb.cc:306
      #11 0x0891cc3f in ha_leveldb::rnd_init (this=0xb6adb8f8, scan=true) at mysql-5.6-leveldb/storage/leveldb/ha_leveldb.cc:912
      #12 0x0824eb6e in handler::ha_rnd_init (this=0xb6adb8f8, scan=true) at mysql-5.6-leveldb/sql/handler.cc:2557
      #13 0x08514273 in init_read_record (info=0xb6a2c9f0, thd=0xab13e08, table=0xb6adb220, select=0xb6a2cba0, use_record_cache=1, print_error=true, disable_rr_cache=false) at mysql-5.6-leveldb/sql/records.cc:287
      #14 0x0837fbe7 in join_init_read_record (tab=0xb6a2c9a4) at mysql-5.6-leveldb/sql/sql_executor.cc:2369
      #15 0x0837d654 in sub_select (join=0xb6a2bfb0, join_tab=0xb6a2c9a4, end_of_records=false) at mysql-5.6-leveldb/sql/sql_executor.cc:1246
      #16 0x0837d124 in do_select (join=0xb6a2bfb0) at mysql-5.6-leveldb/sql/sql_executor.cc:933
      #17 0x0837b343 in JOIN::exec (this=0xb6a2bfb0) at mysql-5.6-leveldb/sql/sql_executor.cc:191
      #18 0x083cdc65 in mysql_execute_select (thd=0xab13e08, select_lex=0xab15950, free_join=true) at mysql-5.6-leveldb/sql/sql_select.cc:1085
      #19 0x083cdf79 in mysql_select (thd=0xab13e08, tables=0xb6a2bb50, wild_num=1, fields=..., conds=0x0, order=0xab15a44, group=0xab159e0, having=0x0, select_options=2147748608, result=0xb6a2bf98, unit=0xab154f8, select_lex=0xab15950) at mysql-5.6-leveldb/sql/sql_select.cc:1206
      #20 0x083cc320 in handle_select (thd=0xab13e08, result=0xb6a2bf98, setup_tables_done_option=0) at mysql-5.6-leveldb/sql/sql_select.cc:110
      #21 0x083ac8cf in execute_sqlcom_select (thd=0xab13e08, all_tables=0xb6a2bb50) at mysql-5.6-leveldb/sql/sql_parse.cc:4982
      #22 0x083a5c73 in mysql_execute_command (thd=0xab13e08) at mysql-5.6-leveldb/sql/sql_parse.cc:2552
      #23 0x083aead8 in mysql_parse (thd=0xab13e08, rawbuf=0xb6a2ba00 "select * from t1", length=16, parser_state=0xaf7e8758) at mysql-5.6-leveldb/sql/sql_parse.cc:6097
      #24 0x083a34be in dispatch_command (command=COM_QUERY, thd=0xab13e08, packet=0xabb37c9 "", packet_length=16) at mysql-5.6-leveldb/sql/sql_parse.cc:1312
      #25 0x083a28ee in do_command (thd=0xab13e08) at mysql-5.6-leveldb/sql/sql_parse.cc:1036
      #26 0x083722a9 in do_handle_one_connection (thd_arg=0xab13e08) at mysql-5.6-leveldb/sql/sql_connect.cc:969
      #27 0x08371e52 in handle_one_connection (arg=0xab13e08) at mysql-5.6-leveldb/sql/sql_connect.cc:885
      #28 0x08650cc7 in pfs_spawn_thread (arg=0xaa97938) at mysql-5.6-leveldb/storage/perfschema/pfs.cc:1853
      #29 0xb76b9e32 in start_thread () from /lib/libpthread.so.0

      revision-id: psergey@askmonty.org-20130115181447-1jfr200qcuqzp1sr
      revno: 4495
      branch-nick: mysql-5.6-leveldb

      Test case:

      create table t1 (pk int primary key, a int) engine=LevelDB;
      insert into t1 values (1,10),(2,20);
      begin;
      update t1 set a = 100 where pk = 3;
      rollback;
      select * from t1;

      Attachments

        Activity

          People

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