Changeset not executed after upgrade

leandrodalbo · August 12, 2021, 10:56am

I am upgrading a project and for some reason no all change logs are being executed.

mariadb from 10.2 → 10.6
liquibase version: 4.3.5
mysql driver: mysql-connector-java-8.0.20.jar

	java -ea -jar lib/liquibase.jar \
		--driver=com.mysql.cj.jdbc.Driver \
		--classpath=lib/mysql-connector-java-8.0.20.jar \
		--url="jdbc:mysql://$HOST:$PORT/$DBNAME" \
		--username=${USER} \
		--password=${PASSWORD} \
		--changeLogFile=${update_path} \
		--logLevel=debug \
		update

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<databaseChangeLog
		xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
		xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
		xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.3.xsd">

	<preConditions>
		<sqlCheck expectedResult="A.79">
			select ID from DATABASECHANGELOG
			WHERE AUTHOR="MajorVersion"
			ORDER BY ORDEREXECUTED DESC
			LIMIT 1;
		</sqlCheck>
	</preConditions>

	<includeAll path="dev/A/A.80/changes" relativeToChangelogFile="true"/>
</databaseChangeLog>

2021-08-12 10:37:27] FINE [liquibase.changelog] Running Changeset:dev/A/A.79/master.xml::A.79::MajorVersion
[2021-08-12 10:37:27] FINE [liquibase.executor] Changeset dev/A/A.79/master.xml::A.79::MajorVersion
[2021-08-12 10:37:27] FINE [liquibase.changelog] Reading ChangeSet: dev/A/A.79/master.xml::A.79::MajorVersion
[2021-08-12 10:37:27] INFO [liquibase.changelog] ChangeSet dev/A/A.79/master.xml::A.79::MajorVersion ran successfully in 1ms
[2021-08-12 10:37:27] FINE [liquibase.executor] Executing with the 'jdbc' executor
[2021-08-12 10:37:27] FINE [liquibase.executor] Executing with the 'jdbc' executor
[2021-08-12 10:37:27] FINE [liquibase.executor] 1 row(s) affected
[2021-08-12 10:37:27] FINE [liquibase.executor] Release Database Lock
[2021-08-12 10:37:27] FINE [liquibase.executor] Executing with the 'jdbc' executor
[2021-08-12 10:37:27] INFO [liquibase.lockservice] Successfully released change log lock
Liquibase: Update has been successful.

**************** running database migration from version A.79 -> A.80 ****************
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.license.LicenseService instance liquibase.pro.license.keymgr.DaticalTrueLicenseService
[2021-08-12 10:37:28] INFO [liquibase.integration] No Liquibase Pro license key supplied. Please set liquibaseProLicenseKey on command line or in liquibase.properties to use Liquibase Pro features.
Liquibase Community 4.3.5 by Datical
Starting Liquibase at 10:37:28 (version 4.3.5 #62 built at 2021-04-29 18:31+0000)
[2021-08-12 10:37:28] FINE [liquibase.integration] Adding 'file:/home/leandro/git/gfl/database/lib/mysql-connector-java-8.0.20.jar' to the Java classpath.
[2021-08-12 10:37:28] FINE [liquibase.integration] Liquibase Hub URL:      https://hub.liquibase.com
[2021-08-12 10:37:28] FINE [liquibase.integration] Liquibase Hub Mode:     all
[2021-08-12 10:37:28] FINE [liquibase.resource] Adding path /home/leandro/git/gfl/database/. to resourceAccessor com.datical.liquibase.ext.database.jvm.ProJdbcConnection
[2021-08-12 10:37:28] FINE [liquibase.database] Connection has been created
[2021-08-12 10:37:28] FINE [liquibase.database] Connected to tcs@10.0.0.2@jdbc:mysql://127.0.0.1:3306/tcs
[com.datical.liquibase.ext.storedlogic.checkconstraint.CheckConstraint
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.structure.DatabaseObject instance com.datical.liquibase.ext.storedlogic.databasepackage.DatabasePackage

[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.parser.ChangeLogParser instance liquibase.parser.core.formattedsql.FormattedSqlChangeLogParser
[2021-08-12 10:37:28] INFO [liquibase.servicelocator] Cannot load service: liquibase.parser.ChangeLogParser: Provider liquibase.parser.core.json.JsonChangeLogParser could not be instantiated
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.parser.ChangeLogParser instance liquibase.parser.core.sql.SqlChangeLogParser
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.parser.ChangeLogParser instance liquibase.parser.core.xml.XMLChangeLogSAXParser
[2021-08-12 10:37:28] INFO [liquibase.servicelocator] Cannot load service: liquibase.parser.ChangeLogParser: Provider liquibase.parser.core.yaml.YamlChangeLogParser could not be instantiated
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.CustomPreconditionWrapper
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.AndPrecondition
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.ChangeLogPropertyDefinedPrecondition
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.ChangeSetExecutedPrecondition
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.ColumnExistsPrecondition
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.DBMSPrecondition
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.ForeignKeyExistsPrecondition
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.IndexExistsPrecondition
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.NotPrecondition
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.ObjectQuotingStrategyPrecondition
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.OrPrecondition
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.PreconditionContainer
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.PrimaryKeyExistsPrecondition
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.RowCountPrecondition
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.RunningAsPrecondition
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.SequenceExistsPrecondition
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.SqlPrecondition
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.TableExistsPrecondition
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.TableIsEmptyPrecondition
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.ViewExistsPrecondition
[2021-08-12 10:37:28] FINE [liquibase.parser] Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.3.xsd'
[2021-08-12 10:37:28] FINE [liquibase.resource] Closing duplicate stream for jar:file:/home/leandro/git/gfl/database/lib/liquibase.jar!/www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.3.xsd
[2021-08-12 10:37:28] FINE [liquibase.parser] Found XML entity at jar:file:/home/leandro/git/gfl/database/lib/liquibase.jar!/www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.3.xsd
[2021-08-12 10:37:28] FINE [liquibase.changelog] includeAll for dev/A/A.80/changes/
[2021-08-12 10:37:28] FINE [liquibase.changelog] Using file opener for includeAll: CompositeResourceAccessor{}
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.changelog.ChangeLogHistoryService instance liquibase.changelog.MockChangeLogHistoryService
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.changelog.ChangeLogHistoryService instance liquibase.changelog.StandardChangeLogHistoryService
[2021-08-12 10:37:28] FINE [liquibase.util] Computed checksum for 1628761048874 as 273e57e34993c8579926b5a657db994d
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.diff.compare.DatabaseObjectComparator instance liquibase.diff.compare.core.CatalogComparator
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.diff.compare.DatabaseObjectComparator instance liquibase.diff.compare.core.ColumnComparator
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.diff.compare.DatabaseObjectComparator instance liquibase.diff.compare.core.DefaultDatabaseObjectComparator
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.diff.compare.DatabaseObjectComparator instance liquibase.diff.compare.core.ForeignKeyComparator
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.diff.compare.DatabaseObjectComparator instance liquibase.diff.compare.core.IndexComparator
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.diff.compare.DatabaseObjectComparator instance liquibase.diff.compare.core.PrimaryKeyComparator
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.diff.compare.DatabaseObjectComparator instance liquibase.diff.compare.core.SchemaComparator
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.diff.compare.DatabaseObjectComparator instance liquibase.diff.compare.core.TableComparator
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.diff.compare.DatabaseObjectComparator instance liquibase.diff.compare.core.UniqueConstraintComparator
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.diff.compare.DatabaseObjectComparator instance com.datical.liquibase.ext.appdba.diff.compare.SynonymComparator
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.diff.compare.DatabaseObjectComparator instance com.datical.liquibase.ext.storedlogic.StoredLogicComparator
[2021-08-12 10:37:28] FINE [liquibase.servicelocator] Loaded liquibase.diff.compare.DatabaseObjectComparator instance com.datical.liquibase.ext.storedlogic.checkconstraint.CheckConstraintComparator
[2021-08-12 10:37:28] FINE [liquibase.executor] Executing with the 'jdbc' executor
[2021-08-12 10:37:28] FINE [liquibase.executor] Executing with the 'jdbc' executor
[2021-08-12 10:37:28] INFO [liquibase.changelog] Reading from tcs.DATABASECHANGELOG
[2021-08-12 10:37:28] FINE [liquibase.executor] Executing with the 'jdbc' executor
[2021-08-12 10:37:29] FINE [liquibase.executor] Executing with the 'jdbc' executor
[2021-08-12 10:37:29] FINE [liquibase.servicelocator] Loaded liquibase.hub.HubService instance liquibase.hub.core.MockHubService
[2021-08-12 10:37:29] INFO [liquibase.servicelocator] Cannot load service: liquibase.hub.HubService: Provider liquibase.hub.core.StandardHubService could not be instantiated
[2021-08-12 10:37:29] FINE [liquibase.executor] Release Database Lock
[2021-08-12 10:37:29] FINE [liquibase.executor] Executing with the 'jdbc' executor
[2021-08-12 10:37:29] INFO [liquibase.lockservice] Successfully released change log lock
Liquibase: Update has been successful.
**************** database migration completed successfully ****************

but when I check on DATABASECHANGELOG A.80 wasn’t executed.mi

aditi · September 9, 2021, 7:15pm

HI @leandrodalbo , Can you verify that the change for A.80 were actually deployed to your database?

Topic		Replies	Views
change set logged as executed but actually not executed General Discussion	4	350	May 26, 2011
4.25 does not execute changesets General Discussion	4	727	December 30, 2023
Liquibase java not applying changesets General Discussion	2	4178	August 5, 2015
Liquibase sqlFile in changeset not executed General Discussion	2	4937	February 9, 2021
Liquibase Change set appears to be empty when executing update command General Discussion	0	863	February 21, 2018

Changeset not executed after upgrade

Related Topics