LevelDB storage engine (MDEV-3841)

[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 Created: 2013-01-16  Updated: 2013-01-17  Resolved: 2013-01-17

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Technical task Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Petrunia
Resolution: Fixed Votes: 0
Labels: leveldb

Issue Links:
Relates

 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;


Generated at Thu Feb 08 06:53:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.