6FywSxUu

1#!/bin/bash
2
3roachprod destroy local || true
4roachprod create local --nodes 4
5roachprod start local
6
7# Create a table with leaseholders on all four nodes.
8roachprod sql local:1 <<EOF
9CREATE DATABASE IF NOT EXISTS d;
10DROP TABLE IF EXISTS d.t;
11CREATE TABLE d.t (x INT PRIMARY KEY);
12INSERT INTO d.t VALUES (1), (2), (3), (4);
13ALTER TABLE d.t SPLIT AT VALUES (2), (3), (4);
14SELECT pg_sleep(15);
15ALTER TABLE d.t TESTING_RELOCATE VALUES
16  (ARRAY[1,2,3], 1),
17  (ARRAY[2,3,4], 2),
18  (ARRAY[3,4,1], 3),
19  (ARRAY[4,1,2], 4);
20EOF
21
22# Stop one of the nodes.
23roachprod stop local:4
24
25echo "sleeping"
26sleep 10
27
28while [ $? -eq 0 ]; do roachprod sql local:1 <<EOF
29SELECT * FROM d.t;
30EOF
31done