1#!/bin/bash -ue
2
3declare -r DIST_BASE=$(cd $(dirname $0)/../..; pwd -P)
4TEST_BASE=${TEST_BASE:-"$DIST_BASE"}
5
6. $TEST_BASE/conf/main.conf
7declare -r SCRIPTS="$DIST_BASE/scripts"
8. $SCRIPTS/jobs.sh
9. $SCRIPTS/action.sh
10. $SCRIPTS/kill.sh
11. $SCRIPTS/misc.sh
12
13echo "##################################################################"
14echo "##             regression test for lp:900816"
15echo "##################################################################"
16echo "restarting cluster"
17$SCRIPTS/command.sh restart
18
19PORT=${NODE_INCOMING_PORT[0]}
20HOST=${NODE_INCOMING_HOST[0]}
21USER=$DBMS_TEST_USER
22PSWD=$DBMS_TEST_PSWD
23DB=test
24TABLE=nopk
25TRIES=1000
26
27MYSQL="mysql -u$USER -p$PSWD -h$HOST -P$PORT $DB"
28
29CREATE="
30DROP TABLE IF EXISTS $DB.$TABLE;
31CREATE TABLE $DB.$TABLE (i INT, j INT);"
32
33INSERT="INSERT INTO $DB.$TABLE VALUES (1, 0),(2,0);"
34
35UPDATE="UPDATE $DB.$TABLE SET j=j+1;"
36
37DELETE="DELETE FROM $DB.$TABLE;"
38
39echo $CREATE | $MYSQL
40
41for i in $(seq 1 $TRIES)
42do
43    echo $INSERT | $MYSQL
44    echo $UPDATE | $MYSQL >> update.log 2>&1 &
45    echo $DELETE | $MYSQL
46done
47
48echo "$i tries passed"
49
50$SCRIPTS/command.sh check
51$SCRIPTS/command.sh stop