ctdb/tests/simple/58_ctdb_restoredb.sh

   1 #!/bin/bash
   2
   3 test_info()
   4 {
   5     cat <<EOF
   6 The command 'ctdb restoredb' is used to restore a database across the
   7 whole cluster.
   8
   9 Prerequisites:
  10
  11 * An active CTDB cluster with at least 2 active nodes.
  12
  13 Steps:
  14
  15 1. Verify that the status on all of the ctdb nodes is 'OK'.
  16 2. Create a persistent test database
  17 3. Add some records to test database
  18 4. Backup database
  19 5. Wipe database and verify the database is empty on all nodes
  20 6. Restore database and make sure all the records are restored
  21 7. Make sure no recovery has been triggered
  22
  23 Expected results:
  24
  25 * Database operations should not cause a recovery
  26
  27 EOF
  28 }
  29
  30 . "${TEST_SCRIPTS_DIR}/integration.bash"
  31
  32 ctdb_test_init "$@"
  33
  34 set -e
  35
  36 cluster_is_healthy
  37
  38 try_command_on_node 0 $CTDB status
  39 generation=$(echo "$out" | sed -n -e 's/^Generation:\([0-9]*\)/\1/p')
  40
  41 try_command_on_node 0 "$CTDB listnodes"
  42 num_nodes=$(echo "$out" | wc -l)
  43
  44 # 2.
  45 test_db="restoredb_test.tdb"
  46 test_dump=$(mktemp)
  47 echo $test_dump
  48 echo "Create persistent test database \"$test_db\""
  49 try_command_on_node 0 $CTDB attach "$test_db" persistent
  50 try_command_on_node 0 $CTDB wipedb "$test_db"
  51
  52 # 3.
  53 # add 10,000 records to database
  54 echo "Adding 10000 records to database"
  55 (
  56 for i in $(seq 1 10000) ; do
  57         echo "\"key$i\" \"value$i\""
  58 done
  59 ) | try_command_on_node -i 0 $CTDB ptrans "$test_db"
  60
  61 num_records=$(db_ctdb_cattdb_count_records 1 "$test_db")
  62 if [ $num_records = "10000" ] ; then
  63     echo "OK: Records added"
  64 else
  65     echo "BAD: We did not end up with 10000 records"
  66     echo "num records = $num_records"
  67     exit 1
  68 fi
  69
  70 ctdb_test_exit_hook_add "rm -f $test_dump"
  71
  72 # 4.
  73 echo "Backup database"
  74 try_command_on_node 0 $CTDB backupdb "$test_db" "$test_dump"
  75
  76 # 5.
  77 echo "Wipe database"
  78 try_command_on_node 0 $CTDB wipedb "$test_db"
  79
  80 # check that the database is restored
  81 num_records=$(db_ctdb_cattdb_count_records 1 "$test_db")
  82 if [ $num_records = "0" ] ; then
  83     echo "OK: Database was wiped"
  84 else
  85     echo "BAD: We did not end up with an empty database"
  86     echo "num records = $num_records"
  87     exit 1
  88 fi
  89
  90 # 6.
  91 echo "Restore database"
  92 try_command_on_node 0 $CTDB restoredb "$test_dump" "$test_db"
  93
  94 # check that the database is restored
  95 num_records=$(db_ctdb_cattdb_count_records 1 "$test_db")
  96 if [ $num_records = "10000" ] ; then
  97     echo "OK: Database was restored"
  98 else
  99     echo "BAD: We did not end up with 10000 records"
 100     echo "num records = $num_records"
 101     exit 1
 102 fi
 103
 104 # 7.
 105 wait_until_ready
 106
 107 try_command_on_node 0 $CTDB status
 108 new_generation=$(echo "$out" | sed -n -e 's/^Generation:\([0-9]*\)/\1/p')
 109
 110 echo "Old generation = $generation"
 111 echo "New generation = $new_generation"
 112
 113 if [ "$generation" = "$new_generation" ]; then
 114     echo "OK: Database recovery not triggered."
 115 else
 116     echo "BAD: Database recovery triggered."
 117     exit 1
 118 fi