-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathbehave.sh
executable file
·94 lines (93 loc) · 7.1 KB
/
behave.sh
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
#!/bin/sh -eux
(
if [ ! -f /home/gpadmin/sqldump/dump.sql ]; then
mkdir -p /home/gpadmin/sqldump
wget -nv https://rt.adsw.io/artifactory/common/dump.sql.xz -O /home/gpadmin/sqldump/dump.sql.xz
xz -d /home/gpadmin/sqldump/dump.sql.xz
fi
cd "$HOME/src/gpdb$GP_MAJOR/gpMgmt"
make -j$(nproc) install
#gpstop -a || echo $?
#sudo rm -rf /data/gpdata
sudo mkdir -p /data/gpdata
sudo chown -R $USER:$GROUP /data/gpdata
#sudo bash -c 'echo "cdw" >/etc/hostname'
if [ "$(hostname)" != "cdw" ]; then
sudo bash -c 'echo "$(hostname -i) cdw" >>/etc/hosts'
sudo bash -c 'echo "$(hostname -i) sdw1" >>/etc/hosts'
sudo bash -c 'echo "$(hostname -i) sdw2" >>/etc/hosts'
sudo bash -c 'echo "$(hostname -i) sdw3" >>/etc/hosts'
sudo hostname cdw
fi
rm "$HOME/gpAdminLogs/"* || echo $?
#cd /data/gpdata
#cd "$HOME"
#ln -fs "$HOME/src/gpdb$GP_MAJOR/gpMgmt/test" .
#gpstop -afr
dropdb gptest || echo $?
createdb --owner="$USER" gptest || echo $?
gpstop -a || echo $?
export PGPORT=15432
export PORT_BASE=$PGPORT
#export MASTER_DATA_DIRECTORY=/data/gpdata/coordinator/gpseg-1
#/home/gpadmin/src/gpdb6u/gpAux/gpdemo/datadirs/qddir/demoDataDir-1
#export DATADIRS=$HOME/src/gpdb$GP_MAJOR/gpAux/gpdemo/datadirs
#export MASTER_DATA_DIRECTORY=$DATADIRS/qddir/demoDataDir-1
#export MASTER_DATA_DIRECTORY=/data/gpdata/gpexpand/data/master/gpseg-1
export DATADIRS=/data/gpdata/gpexpand/data
export MASTER_DATA_DIRECTORY="$DATADIRS/master/gpseg-1"
#cd "$HOME/src/gpdb$GP_MAJOR"
#sudo groupadd --system docker
#sudo groupmems -a $USER -g docker
#export IMAGE=behave
#docker build -t $IMAGE -f arenadata/Dockerfile .
#source $HOME/qa.sh
#make -f Makefile.behave behave "$*" TAR=tar 2>&1
#make -j$(nproc) behave tags=gpexpand
#make -j$(nproc) behave tags=gplogfilter
#make -j$(nproc) behave tags=gpperfmon
#make -j$(nproc) behave -n "gpperfmon does not lose the query text if its text differs from the text in pg_stat_activity"
#make -j$(nproc) -f Makefile.behave behave tags=gplogfilter
#make -j$(nproc) -f Makefile.behave behave tags=gpexpand
#behave test/behave/mgmt_utils --tags=gpperfmon -n "install gpperfmon" -n "run gpperfmon" -n "get info about current queries"
#behave test/behave/mgmt_utils --tags=gpperfmon -n "install gpperfmon" -n "run gpperfmon" -n "gpperfmon does not log PL/pgSQL statements with log_min_messages < debug4"
#behave test/behave/mgmt_utils --tags=gpperfmon -n "install gpperfmon" -n "run gpperfmon" -n "gpperfmon only logs nested statements if log_min_messages is set to debug4 or debug5"
#behave test/behave/mgmt_utils --tags=gpperfmon -n "install gpperfmon" -n "run gpperfmon" -n "get info about current queries"
#behave test/behave/mgmt_utils --tags=gpperfmon -n "install gpperfmon" -n "run gpperfmon"
#behave test/behave/mgmt_utils --tags=gpperfmon -n "run gpperfmon" -n "get info about current queries"
#behave test/behave/mgmt_utils --tags=gpperfmon -n "get info about current queries"
#behave test/behave/mgmt_utils --tags=gpperfmon -n "install gpperfmon" -n "run gpperfmon" -n "get info about current queries" -n "gpperfmon adds to database_history table"
#behave test/behave/mgmt_utils --tags=gpperfmon -n "run gpperfmon" -n "get info about current queries" -n "gpperfmon adds to database_history table"
#behave test/behave/mgmt_utils --tags=gpperfmon -n "get info about current queries" -n "gpperfmon adds to database_history table"
#behave test/behave/mgmt_utils --tags=gpperfmon -n "install gpperfmon" -n "run gpperfmon" -n "gpperfmon does not lose the query text if its text differs from the text in pg_stat_activity"
#behave test/behave/mgmt_utils --tags=gpperfmon -n "install gpperfmon" -n "run gpperfmon" -n "gpperfmon ignore ALTER TABLE SET DISTRIBUTED BY"
#behave test/behave/mgmt_utils --tags=gpperfmon -n "gpperfmon ignore ALTER TABLE SET DISTRIBUTED BY"
#behave test/behave/mgmt_utils --tags=gpperfmon -n "gpperfmon ignore ALTER TABLE SET DISTRIBUTED BY" -n "gpperfmon does not lose the query text if its text differs from the text in pg_stat_activity"
#behave test/behave/mgmt_utils --tags=gprecoverseg -n "gprecoverseg should not give warning if pg_basebackup is running for the up segments"
#behave test/behave/mgmt_utils --tags=gpexpand -n "expand the cluster by adding more segments"
#behave test/behave/mgmt_utils --tags=gpexpand --name="Avoid overwriting the tar file on coordinator"
#behave test/behave/mgmt_utils --tags=gpexpand -n "after resuming a duration interrupted redistribution, tables are restored" -n "after a duration interrupted redistribution, state file on standby matches coordinator" -n "after resuming an end time interrupted redistribution, tables are restored"
#behave test/behave/mgmt_utils --tags=gpstop -n 'gpstop gpstop should not print "Failed to kill processes for segment" when locale is different from English'
#behave test/behave/mgmt_utils --tags=gpexpand -n 'gpexpand should skip already expanded/broken tables when redistributing'
#behave test/behave/mgmt_utils --tags=gpexpand --name='gpexpand should skip already expanded/broken tables when redistributing' --verbose
#behave test/behave/mgmt_utils --tags=gpexpand --name='after resuming a duration interrupted redistribution, tables are restored' --verbose
#behave test/behave/mgmt_utils --tags=gpperfmon -n "install gpperfmon" -n "run gpperfmon" -n "gpperfmon ignore ALTER TABLE SET DISTRIBUTED BY" -n "gpperfmon does not lose the query text if its text differs from the text in pg_stat_activity"
#behave test/behave/mgmt_utils --tags=gpperfmon -n "install gpperfmon" -n "run gpperfmon" -n "gpperfmon adds to diskspace_history table"
#behave test/behave/mgmt_utils --tags=gpperfmon -n "gpperfmon adds to diskspace_history table"
#behave test/behave/mgmt_utils --tags=gpperfmon -k -n "gpperfmon adds to diskspace_history table"
#behave test/behave/mgmt_utils --tags=gplogfilter -k -n "invalid begin and end arguments"
behave test/behave/mgmt_utils --tags=gplogfilter -k
#arenadata/scripts/run_behave_tests.bash "gpexpand should skip already expanded/broken tables when redistributing"
#cd "$HOME/src/gpdb$GP_MAJOR"
#arenadata/scripts/run_behave_tests.bash "gpexpand Avoid overwriting the tar file on coordinator"
#export PEXPECT_LIB="$GPHOME/bin/lib"
#export TEST_DIR="$HOME/src/gpdb$GP_MAJOR/gpMgmt"
#export PYTHONPATH="$PYTHONPATH":"$PEXPECT_LIB":"$TEST_DIR"
#PYTHONPATH="$PYTHONPATH":"$GPHOME/bin/lib":"$HOME/src/gpdb$GP_MAJOR/gpMgmt"
#behave "$HOME/src/gpdb$GP_MAJOR/gpMgmt/test/behave/"* --tags=gpexpand --name='gpexpand should skip already expanded/broken tables when redistributing' --verbose
#behave test/behave/mgmt_utils --tags=gpexpand --name='gpexpand should skip already expanded/broken tables when redistributing' --verbose
#behave test/behave/mgmt_utils --tags=gpactivatestandby --name='gprecoverseg recoveries failed segment when standby works instead of coordinator' --verbose
#behave test/behave/mgmt_utils --tags=gpinitstandby --name='gpinitstandby should create pg_hba entry to segment primary' --verbose
#behave test/behave/mgmt_utils --tags=gpinitstandby --name='gpinitstandby should create pg_hba standby entry to segment primary and mirror' --verbose
#behave test/behave/mgmt_utils --tags=gpactivatestandby --name='gpstate after running gpactivatestandby works' --verbose
) 2>&1 | tee "$HOME/behave.log"