Allow to flexibility for --force continue execution of ChangeSet' s SqlQueries when encounters errors

Description

Many company follow Multi-tenancy environment .It is economical because software development and maintenance costs are shared.
A common Sql file will be executed for all clients during the product release .
Mysql allow force execution of all queries in script through
mysql -w -f -v -A $db -h************ -u********** -p******* < /home/jenkins/queries1.sql

There is need force countinue execution of all error free queries of ChangeSets when encountering error in changeSet.

Only remain to execute those query which have issue. Stuck Queries should track with the help of the below options.
--logFile =tennat_logs.txt --logLevel=INFO .

Summary: Force execution of queries of changeSet must be part of liquibase as same feature of Mysql.

Environment

all environment include production,qa

Ubuntu
Mysql 5.7
Liquibase 3.8.3 till 3.8.5

Activity

Show:

monu.kumar April 27, 2020 at 9:30 AM

Any update?

 

Details

Reporter

Components

Fix versions

Affects versions

Priority

Created January 14, 2020 at 7:49 AM
Updated April 27, 2020 at 9:30 AM