commit fc7df372047d3e16f8e3779544d175175e33bef3
author tierno <alfonso.tiernosepulveda@telefonica.com> Fri Dec 21 10:19:38 2018 +0000
committer tierno <alfonso.tiernosepulveda@telefonica.com> Fri Dec 21 13:08:17 2018 +0000
tree 7a95f45405422e045d3fae80d25660160e67c007
parent 89aada4f5e6bd52afd284ed8b2a27a5b36e677bb

bug 608 Database migration recovering with docker relaunch

Change-Id: I4005e048b71284c154495a90d8b1256a09e6ff98
Signed-off-by: tierno <alfonso.tiernosepulveda@telefonica.com>

scripts/RO-start.sh

diff --git a/scripts/RO-start.sh b/scripts/RO-start.sh
index 53e189c..9297559 100755
--- a/scripts/RO-start.sh
+++ b/scripts/RO-start.sh
@@ -17,7 +17,12 @@
     db_version=$6  # minimun database version
 
     if mysqlshow -h"$db_host" -P"$db_port" -u"$db_user" -p"$db_pswd" | grep -v Wildcard | grep -q -e "$db_name" ; then
-        if echo "SELECT * FROM schema_version WHERE version='$db_version'" |
+        if echo "SELECT * FROM schema_version WHERE version='0'" |
+                mysql -h"$db_host" -P"$db_port" -u"$db_user" -p"$db_pswd" "$db_name" |
+                grep -q -e "init" ; then
+            echo " DB $db_name exists BUT failed in previous init"
+            return 1
+        elif echo "SELECT * FROM schema_version WHERE version='$db_version'" |
                 mysql -h"$db_host" -P"$db_port" -u"$db_user" -p"$db_pswd" "$db_name" |
                 grep -q -e "$db_version" ; then
             echo " DB $db_name exists and inited"
@@ -103,7 +108,7 @@
 else
     echo "  migrate database version"
     ${RO_PATH}/database_utils/migrate_mano_db.sh -u "$RO_DB_USER" -p "$RO_DB_PASSWORD" -h "$RO_DB_HOST" \
-        -P "$RO_DB_PORT" -d "$RO_DB_NAME"
+        -P "$RO_DB_PORT" -d "$RO_DB_NAME" -b /var/log/osm
 fi
 
 OVIM_PATH=`python -c 'import lib_osm_openvim; print(lib_osm_openvim.__path__[0])'`
@@ -125,7 +130,7 @@
 else
     echo "  migrate database version"
     ${OVIM_PATH}/database_utils/migrate_vim_db.sh -u "$RO_DB_OVIM_USER" -p "$RO_DB_OVIM_PASSWORD" -h "$RO_DB_OVIM_HOST"\
-        -P "$RO_DB_OVIM_PORT" -d "$RO_DB_OVIM_NAME"
+        -P "$RO_DB_OVIM_PORT" -d "$RO_DB_OVIM_NAME" -b /var/log/osm
 fi