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