| 1 |
--source include/have_ndb.inc |
| 2 |
|
| 3 |
# See Bug#32491105 DATA NODE CRASH WHEN MAXDMLOPERATIONSPERTRANSACTION |
| 4 |
# VIOLATED BY DELETE STMT |
| 5 |
|
| 6 |
create table t(id int NOT NULL PRIMARY KEY, data int unsigned) engine=ndb; |
| 7 |
load data local infile 'suite/ndb/data/table_data10000.dat' into table t |
| 8 |
fields terminated by ' ' lines terminated by '\n' (id, @data) set data = id; |
| 9 |
|
| 10 |
select count(*) from t; |
| 11 |
|
| 12 |
# Check that it is possible to commit a SCAN operation which is run 'on top' |
| 13 |
# of an operation which is pending abort. |
| 14 |
|
| 15 |
begin; |
| 16 |
update t set data=data+1 ORDER BY id LIMIT 5000; |
| 17 |
update t set data=data+1 ORDER BY id LIMIT 5000; |
| 18 |
|
| 19 |
# Data node soft crash due to temporary error 234 |
| 20 |
# MaxNoOfConcurrentOperations exceeded by multiple transactions |
| 21 |
--error 1297 |
| 22 |
update t set data=data+1 ORDER BY id LIMIT 5000; |
| 23 |
commit; |
| 24 |
|
| 25 |
begin; |
| 26 |
update t set data=data+1 ORDER BY id LIMIT 5000; |
| 27 |
update t set data=data+1 ORDER BY id LIMIT 5000; |
| 28 |
commit; |
| 29 |
|
| 30 |
drop table t; |