Steps to upgrade guzzle from 0.7.19 to 0.7.20 - ja-guzzle/guzzle_docs GitHub Wiki

SSH into guzzle VM and execute following commands one after another. Don't copy all of them together and paste into the shell:

export GUZZLE_HOME=/guzzle
export GUZZLE_VERSION=0.7.20

pid=$(sudo ps aux | grep '[a]pi-0.0.1-SNAPSHOT.jar' | awk '{print $2}')
sudo kill $pid

cd ~
wget -q https://guzzlesa.blob.core.windows.net/guzzle-release/guzzle-${GUZZLE_VERSION}.tar.gz
tar xf guzzle-${GUZZLE_VERSION}.tar.gz
cd guzzle-${GUZZLE_VERSION}

cp -rf version.txt $GUZZLE_HOME/version.txt
cp -rf bin/* $GUZZLE_HOME/bin/
cp -rf libs/* $GUZZLE_HOME/libs/
cp -f  api/api-0.0.1-SNAPSHOT.jar $GUZZLE_HOME/api/
cp -rf sample_conf/instance/schema/* $GUZZLE_HOME/conf/instance/schema/
cp -rf sample_conf/default/ext/* $GUZZLE_HOME/conf/default/ext/

API_URL=$(grep -oP 'window.API_URL="[^"]+"' $GUZZLE_HOME/web/index.html)
API_DOMAIN=$(grep -oP 'window.API_DOMAIN="[^"]+"' $GUZZLE_HOME/web/index.html)

API_URL_PLACEHOLDER=window.API_URL=\"http://192.168.1.207:9090\"
API_DOMAIN_PLACEHOLDER=window.API_DOMAIN=\"192.168.1.207\"

cp -rf web/* $GUZZLE_HOME/web/
sed -i -e "s#$API_URL_PLACEHOLDER#$API_URL#g" -e "s#$API_DOMAIN_PLACEHOLDER#$API_DOMAIN#g"  $GUZZLE_HOME/web/index.html

If guzzle.yml has mysql database configuration like:

database:
  type: mysql
  properties:
    jdbc_url: ...
    ...

Change it to:

database:
  type: jdbc
  properties:
    jdbc_url: ...
    ...

Run following command to generate DDL sql statements for guzzle repo tables:

java -cp $GUZZLE_HOME/bin/*:$GUZZLE_HOME/libs/* com.justanalytics.guzzle.common.DatabaseInitializer generate

Create file upgrade.sql (in some directory) and copy create table statements for following tables in it:

job_heartbeat
job_info_ext
job_info_param_ext

Also add following statement at the end of the file:

ALTER TABLE job_info ADD source_name VARCHAR(200);

Execute SQLs in upgrade.sql file using following command:

java -cp $GUZZLE_HOME/bin/*:$GUZZLE_HOME/libs/* com.justanalytics.guzzle.misc.sqlexecutor.FileExecutor /<absolute_path_of_sql_file>/upgrade.sql

Start Guzzle API application with usual Guzzle API startup command

⚠️ **GitHub.com Fallback** ⚠️