Debian Codegraph @

mysql-test/suite/ndb/t/ndb_transaction_pending_abort.test

raw
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;