aboutsummaryrefslogtreecommitdiffstats
path: root/plans
diff options
context:
space:
mode:
authorwaqas.ikram <waqas.ikram@est.tech>2019-07-19 16:41:37 +0000
committerwaqas.ikram <waqas.ikram@est.tech>2019-07-19 16:41:37 +0000
commitbfdec07ceb31eb61084dd611846c4e31eed2fb17 (patch)
tree14802620be2931d983ab7cb4dcbb94f5ed297806 /plans
parent7d753296b2f742c4633c0b81f468daccabba2c9e (diff)
Adding time out handling in apply-workarounds.sh
Change-Id: I77a9ef6c28bfb12c7eed812967a4cfcd0a8836c7 Issue-ID: SO-1955 Signed-off-by: waqas.ikram <waqas.ikram@est.tech>
Diffstat (limited to 'plans')
-rwxr-xr-xplans/so/integration-etsi-testing/config/apply-workarounds.sh46
1 files changed, 37 insertions, 9 deletions
diff --git a/plans/so/integration-etsi-testing/config/apply-workarounds.sh b/plans/so/integration-etsi-testing/config/apply-workarounds.sh
index f6bf906b..ff167bf7 100755
--- a/plans/so/integration-etsi-testing/config/apply-workarounds.sh
+++ b/plans/so/integration-etsi-testing/config/apply-workarounds.sh
@@ -27,7 +27,8 @@ NORTH_BOUND_TABLE_NAME="northbound_request_ref_lookup"
TABLE_EXISTS_QUERY="select count(*) from information_schema.tables WHERE table_schema='$CATALOG_DB' AND table_name='$BUIDLING_BLOCK_TABLE_NAME';"
BUILDING_BLOCK_COUNT_QUERY="select count(*) from $BUIDLING_BLOCK_TABLE_NAME;"
FLY_WAY_MIGRATION_QUERY="SELECT COUNT(*) FROM flyway_schema_history WHERE script LIKE '%R__MacroData%' AND installed_on IS NOT NULL;"
-
+SLEEP_TIME=5
+TIME_OUT_DEFAULT_VALUE_SEC=1200 #20 mins
current_timestamp()
{
@@ -38,8 +39,9 @@ wait_for_database_availability()
{
echo "$(current_timestamp): Checking for database availability"
until echo '\q' | mysql -h $DB_HOST -P $DB_PORT -uroot -p$MYSQL_ROOT_PASSWORD $CATALOG_DB; do
- >&2 echo "$(current_timestamp): Database is unavailable - sleeping for 5 seconds"
- sleep 5
+ >&2 echo "$(current_timestamp): Database is unavailable - sleeping for ${SLEEP_TIME} seconds"
+ isTimeOut
+ sleep ${SLEEP_TIME}
done
echo "$(current_timestamp): Database is available now"
@@ -48,13 +50,15 @@ wait_for_database_availability()
wait_container_to_create_table()
{
while [ $(mysql -h $DB_HOST -P $DB_PORT -uroot -p$MYSQL_ROOT_PASSWORD $CATALOG_DB -sse "$TABLE_EXISTS_QUERY") -eq "0" ] ; do
- echo "$(current_timestamp): Waiting for so-catalog container to create tables - sleeping for 5 seconds"
- sleep 5
+ echo "$(current_timestamp): Waiting for so-catalog container to create tables - sleeping for ${SLEEP_TIME} seconds"
+ isTimeOut
+ sleep ${SLEEP_TIME}
done
while [ $(mysql -h $DB_HOST -P $DB_PORT -uroot -p$MYSQL_ROOT_PASSWORD $CATALOG_DB -sse "$BUILDING_BLOCK_COUNT_QUERY") -eq "0" ] ; do
- echo "$(current_timestamp): Waiting for so-catalog container to insert records in $BUIDLING_BLOCK_TABLE_NAME - sleeping for 5 seconds"
- sleep 5
+ echo "$(current_timestamp): Waiting for so-catalog container to insert records in $BUIDLING_BLOCK_TABLE_NAME - sleeping for ${SLEEP_TIME} seconds"
+ isTimeOut
+ sleep ${SLEEP_TIME}
done
echo "$(current_timestamp): $CATALOG_DB tables available now . . ."
@@ -63,8 +67,9 @@ wait_container_to_create_table()
wait_for_flyway_migration_to_finish()
{
while [ $(mysql -h $DB_HOST -P $DB_PORT -uroot -p$MYSQL_ROOT_PASSWORD $CATALOG_DB -sse "$FLY_WAY_MIGRATION_QUERY") -ne "1" ] ; do
- echo "$(current_timestamp): Waiting for flyway migration sql statement to finish with success - sleeping for 5 seconds"
- sleep 5
+ echo "$(current_timestamp): Waiting for flyway migration sql statement to finish with success - sleeping for ${SLEEP_TIME} seconds"
+ isTimeOut
+ sleep ${SLEEP_TIME}
done
echo "$(current_timestamp): flyway migration finished . . . "
}
@@ -111,6 +116,29 @@ EOF
echo "$(current_timestamp): Finished applying workaround . . ."
}
+isTimeOut()
+{
+ if [ `date +%s` -gt $TIME_OUT_END_TIME_IN_MS ]; then
+ echo "$(current_timestamp): workaround script timed out . . ."
+ exit 1;
+ fi
+}
+
# main body
+if [ -z "$TIME_OUT_IN_SECONDS"]; then
+ echo "$(current_timestamp): TIME_OUT_IN_SECONDS attribute is empty will use default val: $TIME_OUT_DEFAULT_VALUE_SEC"
+ TIME_OUT_IN_SECONDS=$TIME_OUT_DEFAULT_VALUE_SEC
+fi
+
+DIGITS_REGEX='^[0-9]+$'
+if ! [[ $TIME_OUT_IN_SECONDS =~ $DIGIT_REGEX ]] ; then
+ echo "$(current_timestamp): TIME_OUT_IN_SECONDS attribute Must be number: $TIME_OUT_IN_SECONDS, will use default val: $TIME_OUT_DEFAULT_VALUE_SEC"
+ TIME_OUT_IN_SECONDS=$TIME_OUT_DEFAULT_VALUE_SEC
+fi
+
+START_TIME_IN_MS=`date +%s`
+TIME_OUT_END_TIME_IN_MS=$(($START_TIME_IN_MS+$TIME_OUT_IN_SECONDS));
+echo "$(current_timestamp): Workaround script will time out at `date -d @$TIME_OUT_END_TIME_IN_MS`"
+
apply_workaround