Liquibase Forums - Please note we are upgrading the forum site to use Discourse forums. This forum will become read-only by EOD 5/31/20. URL will remain the same, may have to reset your user.

Liquibase Forums

Recent Topics
All Forums
- Search All
- Tags
- Author
- Advanced Search
Search
New Topic

Topics

Liquibase Development
- All Forums
- Liquibase Users
- Liquibase Development

All

All
Announcements
Discussions
Questions
Ideas
Problems
Sticky posts
Unreplied posts

Liquibase S3 extension
started by Евгений • 12 days ago
No one has responded yet.
Hi,

I developed a simple extension that allows executing SQL files from Amazon S3.
https://github.com/miron4dev/liquibase-s3

I would be glad to get any feedback.

Thanks,
Evgeny.
- View full thread
Liquibase is NOT fully supporting for SAP HANA DB [1 Reply]
started by Kathiresan • last reply by Datical Robert • 22 days ago
Datical Robert responded at 08-May-2020 11:55 AM.
1 Reply of 1
Does this resolve your issues?

https://github.com/liquibase/hana-liquibase

The SAP HANA team built this and transferred the repos to the Liquibase org in GitHub. Let us know how it works for you!

Robert
- 1 Reply of 1
- View full thread
loadUpdateData tag not working in Oracle when using sqlplus [1 Reply]

1
asked by mihir • last reply by Steve Z. • 1 month ago
Steve Z. responded at 30-Apr-2020 02:21 PM.
1 Reply of 1
Hi Mihir,

Please try to upgrade to our latest Liquibase version. https://download.liquibase.org/
The upgrade might solve your issue as we have made some major bug fixes since 3.5.x.

Thanks,
Steve Z.
- 1 Reply of 1
- View full thread
Improve LockService (especially for CI/CD) environments

1
proposed by Mark1 • 1 month ago
No one has responded yet.
Hi,

We've had a number of issues with the liquibase lock not being released in our Continuous Integration/Deployment pipeline. Mainly due to nodes being killed at startup for various reasons.

We've been considering a number of alternatives (like automatically unlocking by updating the record in DATABASECHANGELOGLOCK if the locker no longer exists) but none are very satisfactory.

Instead I have made a liquibase extension (PostgreSQL/Oracle) to lock safely but unlock if the session is killed.
More details here in README.md:

https://github.com/mjeffrey/liquibase-lock

I wonder if this could become part of Liquibase itself?
If you want it, it is available with and Apache 2 licence (but will donate it to liquibase without licence).

This only works for Postgres and Oracle (the 2 databases I need ) but a more general solution is described at the end of the README.md as well.

cheers,
Mark
- View full thread
Documentation improvement about parameters
started by Alexandr • 1 month ago
No one has responded yet.
Hi all,

I've found out that there is an ability to define changeLog's parameters in a property file with paramter. prefix.

But such nice option seems isn't documented anywhere.

If I'm wrong - please, point me to documentation page contains a description of this ability.
If I'm right - can somebody extend documentation with a paragraph about this ability?
- View full thread
Tagging in SQL format changeset [5 Replies]

1
asked by Anantdev Pathak • last reply by Steve From Datical • 2 months ago
Steve From Datical responded at 31-Mar-2020 10:38 AM.
5 Reply of 5
Lots of things to discuss here.

It is not clear to me why you are running the generateChangelog command repeatedly. Typically this is only done once, when you first start using Liquibase, to generate an initial changelog.

You should not need to repeatedly use the liquibase clearchecksums command either.

Then on your final bit - if you want to apply a tag to the database, then there are two ways to do it. You can add a <tag> element to your master changelog, OR after you run the liquibase update command, you can run the liquibase tag command. Doing it with the <tag> element in the changelog ensures that the tag is applied in the same way on every database that you run update on. Doing it with the tag command is a more 'ad-hoc' way of doing it, and requires that you run the command on every database you want to have the tag on.

Steve Donie
Principal Software Engineer
Liquibase Community Engagement
Datical, Inc. http://www.datical.com/
- 5 Reply of 5
- View full thread
New more condensed and more detailed page layout for the changes [4 Replies]

1
proposed by Gyula Bibernáth • last reply by Gyula Bibernáth • 3 months ago
Gyula Bibernáth responded at 21-Feb-2020 04:26 AM.
4 Reply of 4
I've created a new PR #407 containing the changes in the generator to generate the described new layout, that is visible @ liquibase-doc. All the elements can be styled separately in the liquibase.css
It does not have binary dependency on core changes, although some property descriptions will be visible only after core PR #1002 has been merged. Nested properties `insert, update / whereParams` and `executeCommand / args` will be visible after core RP #992 is has been merged.

Regards,
Gyula Bibernáth
- 4 Reply of 4
- View full thread
eclipse / intellij import (liquibase-core) [3 Replies]

1
asked by man.from.home • last reply by Gyula Bibernáth • 3 months ago
Gyula Bibernáth responded at 07-Feb-2020 10:04 AM.
3 Reply of 3
I've seen similar when I was running on java 1.9+.
If you are also, then you need to add the jaxb dependency to the maven plugin's pom file, because jaxb was removed from java core See PR 970
- 3 Reply of 3
- View full thread
Liquibase diff fail

1
reported by Alexis1 • 4 months ago
No one has responded yet.
Hi all,

When i run liquibase diff, i get this error :

[ERROR] Failed to execute goal org.liquibase:liquibase-maven-plugin:3.8.5:diff (default-cli) on project master-hipster-2: Error setting up or running Liquibase: javax.persistence.PersistenceException: Unable to resolve persistence unit root URL: class path resource [] cannot be resolved to URL because it does not exist -> [Help 1]

i use :
- Liquibase 3.8.5
- Liquibase hibernate 3.8
- Hibernate 5.4.10.Final
- Hibernate search 6
- Spring boot 2.2.4

Befor library update i used :
- Liquibase 3.6.3
- Liquibase hibernate 3.6
- Hibernate 5.3.9
- Hibernate search 5.3.9
- Spring boot 2.1.5

I don't change my configuration after the update of spring, hibernate, liquibase dependencies, i used liquibase maven plugins

Configuration inside pom.xml :

<plugin>
<groupId>org.liquibase</groupId>
<artifactId>liquibase-maven-plugin</artifactId>
<version>${liquibase.version}</version>
<configuration>

<changeLogFile>src/main/resources/config/liquibase/master.xml</changeLogFile>
<diffChangeLogFile>src/main/resources/config/liquibase/changelog/${maven.build.timestamp}_changelog.xml</diffChangeLogFile>
<driver>org.postgresql.Driver</driver>
<url>jdbc:postgresql://localhost:5432/DATABASE</url>
<defaultSchemaName></defaultSchemaName>
<username>user</username>
<password>password</password>
<referenceUrl>hibernate:spring:fr.iocean.master.domain?dialect=io.github.jhipster.domain.util.FixedPostgreSQL95Dialect&hibernate.physical_naming_strategy=org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy&hibernate.implicit_naming_strategy=org.springframework.boot.orm.jpa.hibernate.SpringImplicitNamingStrategy</referenceUrl>
<verbose>true</verbose>
<logging>debug</logging>
</configuration>
<dependencies>
<dependency>
<groupId>org.javassist</groupId>
<artifactId>javassist</artifactId>
<version>${javassist.version}</version>
</dependency>
<dependency>
<groupId>org.liquibase.ext</groupId>
<artifactId>liquibase-hibernate5</artifactId>
<version>${liquibase-hibernate5.version}</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
<version>${spring-boot.version}</version>
</dependency>
<dependency>
<groupId>javax.validation</groupId>
<artifactId>validation-api</artifactId>
<version>${validation-api.version}</version>
</dependency>
</dependencies>
</plugin>

Did you have many idea of the origine of this error ?

Thank's
- View full thread
Steps contributing the documentation [2 Replies]

1
asked by Gyula Bibernáth • last reply by Steve From Datical • 4 months ago
Steve From Datical responded at 27-Jan-2020 12:25 PM.
2 Reply of 2
I see that you have submitted PR #964 - https://github.com/liquibase/liquibase/pull/964/

That is a big one, and it appears to alter behavior as well as documentation, so it might take me a while to get it reviewed and merged.

Steve Donie
Principal Software Engineer
Liquibase Community Engagement
Datical, Inc. http://www.datical.com/
- 2 Reply of 2
- View full thread
META-INF\MANIFEST.MF build problem [9 Replies]

1
asked by Gyula Bibernáth • last reply by Steve From Datical • 4 months ago
Steve From Datical responded at 21-Jan-2020 11:23 AM.
9 Reply of 9
Thanks so much! We will review and merge as soon as we can.

Steve Donie
Principal Software Engineer
Liquibase Community Engagement
Datical, Inc. http://www.datical.com/
- 9 Reply of 9
- View full thread
jaxb-api : 2.3.0 copyleft [2 Replies]
started by Yachin • last reply by Yachin • 4 months ago
Yachin responded at 08-Jan-2020 02:01 PM.
2 Reply of 2
Hi Steve,

Thank you for the response! It is very helpful.

Yachin
- 2 Reply of 2
- View full thread
Oracle create stored procedure using Liquibase
started by Kiru.srini • 5 months ago
No one has responded yet.
<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
xmlns:ora="http://www.liquibase.org/xml/ns/dbchangelog-ext"
xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">

<changeSet id="37" author="META" dbms="oracle" runOnChange="true" >
<comment>Load Metadata </comment>
<sqlFile dbms="oracle" endDelimiter="\n/\s*\n|\n/\s*$" path="procedures/prc_delete_metadata.sql" splitStatements="false" />
<rollback>
<sql>DROP PROCEDURE META.PRC_DELETE_METADATA</sql>
</rollback>
</changeSet>
</databaseChangeLog>

Procedure
=========

create or replace PROCEDURE PRC_DELETE_METADATA
AS
------------------------------------------------------------------------
-- Meta Data Deletor
------------------------------------------------------------------------
-- Name : PRC_DELETE_METADATA
-- Purpose : To Truncate the meta data table
-- Modified on : 12/18/2019
------------------------------------------------------------------------
-- Error variables
v_code VARCHAR2(30);
v_desc VARCHAR2(4000);
-- Contant variable
c_user CONSTANT VARCHAR(20) := 'META';
BEGIN
-- Deleting Stage table
-- DELETE FROM stg_metadata;
-- Deletion of load log
-- DELETE FROM METADATA_LOAD_LOG
-- WHERE created_by = c_user;
-- Deleting all the meta data tables
DELETE FROM data_element
WHERE create_user_id = c_user;
DELETE FROM data_type
END;
/

Here is the error i am getting

17:28:28,565 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logback.core.ConsoleAppender]
17:28:28,571 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [STDOUT]
17:28:28,581 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder] property
17:28:28,617 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logback.core.FileAppender]
17:28:28,623 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [FILE]
17:28:28,628 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder] property
17:28:28,630 |-INFO in ch.qos.logback.core.FileAppender[FILE] - File property is set to [/opt/apps/idf/log/metadatadb.log]
17:28:28,634 |-INFO in ch.qos.logback.classic.joran.action.RootLoggerAction - Setting level of ROOT logger to DEBUG
17:28:28,635 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [FILE] to Logger[ROOT]
17:28:28,636 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [STDOUT] to Logger[ROOT]
17:28:28,637 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - End of configuration.
17:28:28,640 |-INFO in ch.qos.logback.classic.joran.JoranConfigurator@5b1d2887 - Registering current configuration as safe fallback point
Starting Liquibase at Sat, 21 Dec 2019 17:28:28 EST (version 3.6.3 built at 2019-01-29 11:34:48)
Unexpected error running Liquibase: ORA-00900: invalid SQL statement
[Failed SQL: end]
liquibase.exception.MigrationFailedException: Migration failed for change set database.account.changelog-2.0.xml::38::META:
Reason: liquibase.exception.DatabaseException: ORA-00900: invalid SQL statement
[Failed SQL: end]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:637)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:83)
at liquibase.Liquibase.update(Liquibase.java:202)
at liquibase.Liquibase.update(Liquibase.java:179)
at liquibase.integration.commandline.Main.doMigration(Main.java:1220)
at liquibase.integration.commandline.Main.run(Main.java:199)
at liquibase.integration.commandline.Main.main(Main.java:137)
Caused by: liquibase.exception.DatabaseException: ORA-00900: invalid SQL statement
[Failed SQL: end]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:356)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:125)
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1229)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1211)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:600)
... 7 common frames omitted
- View full thread
Adding column without deleting the existing records from table [2 Replies]

1
asked by Tamil • last reply by Tamil • 5 months ago
Tamil responded at 17-Dec-2019 04:24 AM.
2 Reply of 2
Hi,

Thanks for reply, I was setting the below property as true so it was dropping all the table and creating new table.

I have set it to false and it was not deleting the existing table and records while adding the new column

SpringLiquibase liquibase = new SpringLiquibase();
liquibase.setDropFirst(true);

Can you please share us any link which include detailed documentation with examples about migration in liquibase
- 2 Reply of 2
- View full thread
dbdoc: adding asciidoc markup generation - could I add it? [1 Reply]

1
proposed by man.from.home • last reply by Steve From Datical • 6 months ago
Steve From Datical responded at 18-Nov-2019 02:21 PM.
1 Reply of 1
Datical, the company that I work for is adding more resources to support Liquibase. One of the things that we would like to do is improve the dbDoc command, so your addition would be very welcomed.

The dbDoc stuff was designed quite a long time ago and hasn't been an area where people have asked for very many fixes/changes/additions. I am not super-familar with that part of the code, so I'm not sure of the best way to extend it. A quick look and it seems like you might be able to add a new method to DBDocVisitor named 'writeAsciiDoc' or similar, and then in the Liquibase class, in the generateDocumentation method, have it call that method instead of the writeHTML method.

What would be even better would be to spend some more time in those classes and come up with an interface and make it a pluggable extensible thing. I'll check with Nathan and see what his thoughts are.

Steve Donie
Principal Software Engineer
Liquibase Community Engagement
Datical, Inc. http://www.datical.com/
- 1 Reply of 1
- View full thread
jdbc error
started by Kiru.srini • 7 months ago
No one has responded yet.
Unexpected error running Liquibase: java.lang.RuntimeException: Cannot find database driver: oracle.jdbc.driver.OracleDriver
liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: java.lang.RuntimeException: Cannot find database driver: oracle.jdbc.driver.OracleDriver
at liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(CommandLineUtils.java:132)
at liquibase.integration.commandline.Main.doMigration(Main.java:974)
at liquibase.integration.commandline.Main.run(Main.java:199)
at liquibase.integration.commandline.Main.main(Main.java:137)
Caused by: liquibase.exception.DatabaseException: java.lang.RuntimeException: Cannot find database driver: oracle.jdbc.driver.OracleDriver
at liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:254)
at liquibase.database.DatabaseFactory.openDatabase(DatabaseFactory.java:149)
at liquibase.integration.commandline.Co<BR>Std err:

i have tried both oracle.jdbc.driver.OracleDriver & oracle.jdbc.OracleDriver still getting the same error
- View full thread
CustomChange(Wrapper?) question [2 Replies]
started by Laszlo Bathory • last reply by Laszlo Bathory • 8 months ago
Laszlo Bathory responded at 28-Sep-2019 03:06 AM.
2 Reply of 2
Yes indeed, but we want the test writer to permute the data (test)runtime to avoid store hundreds of loader files in the project and repository...
I wrote a working solution as a liquibase extension overriding the LoadDataChange class, extending the <loadData ..> tag with an extra attribute !
Maybe it worth to share here when it is totally ready ...
- 2 Reply of 2
- View full thread
Index Precondition performance on ORACLE

1
started by benosmane • 8 months ago
No one has responded yet.
Hello,

I am unsing the 3.6.3 version of liquibase on an Oracle database.

When i use the index pre condition Liquibase is freezing and the freez can take more than one hour..

Here my changeLog

<?xml version="1.0" encoding="UTF-8"?>
<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-3.6.xsd"
logicalFilePath="master-cleva">

<changeSet author="cleva" id="abe_1" labels="Create index IND_HRI_BPP_TYPO_BPB" logicalFilePath="master-cleva">
<preConditions onFail="MARK_RAN" onFailMessage="Index IND_HRI_BPP_TYPO_BPB already exists.">
<not>
<indexExists indexName="IND_HRI_BPP_TYPO_BPB" />
</not>
</preConditions>
<comment></comment>
<createIndex indexName="IND_HRI_BPP_TYPO_BPB" tableName="F_HISTO_RIB" unique="false">
<column name="HRI_PTRBPPIDENT" type="NUMBER(14)" />
<column name="HRI_PTRTYPOIDENT" type="NUMBER(14)" />
<column name="HRI_PTRBPBIDENT" type="NUMBER(14)" />
</createIndex>
</changeSet>

<changeSet author="cleva" id="abe_2" labels="Create index IND_SOR_PTRSORID_SOUSCRIPTION" logicalFilePath="master-cleva">
<preConditions onFail="MARK_RAN" onFailMessage="Index IND_SOR_PTRSORID_SOUSCRIPTION already exists.">
<not>
<indexExists indexName="IND_SOR_PTRSORID_SOUSCRIPTION" />
</not>
</preConditions>
<comment></comment>
<createIndex indexName="IND_SOR_PTRSORID_SOUSCRIPTION" tableName="F_SIT_OBJET_RISQUE" unique="false">
<column name="SOR_PTRSORID_SOUSCRIPTION" type="NUMBER(14)" />
</createIndex>
</changeSet>

<changeSet author="cleva" id="abe_3" labels="Create index IND_MVT_PTRPOL_NON_REGULARISE" logicalFilePath="master-cleva">
<preConditions onFail="MARK_RAN" onFailMessage="Index IND_MVT_PTRPOL_NON_REGULARISE already exists.">
<not>
<indexExists indexName="IND_MVT_PTRPOL_NON_REGULARISE" />
</not>
</preConditions>
<comment></comment>
<createIndex indexName="IND_MVT_PTRPOL_NON_REGULARISE" tableName="F_MOUVEMENT" unique="false">
<column name="MVT_PTRPOLID" type="NUMBER(14)" />
<column name="MVT_NON_REGULARISE" type="VARCHAR(1)" />
</createIndex>
</changeSet>

</databaseChangeLog>

Here the stack trace (freezing on the select index request )
Thread [main] (Suspended)
owns: T4CConnection (id=201)
SocketInputStream.socketRead0(FileDescriptor, byte[], int, int, int) line: not available [native method]
SocketInputStream.socketRead(FileDescriptor, byte[], int, int, int) line: 116
SocketInputStream.read(byte[], int, int, int) line: 171
SocketInputStream.read(byte[], int, int) line: 141
DataPacket(Packet).receive() line: 311
DataPacket.receive() line: 105
NetInputStream.getNextPacket() line: 305
NetInputStream.read(byte[], int, int) line: 249
NetInputStream.read(byte[]) line: 171
NetInputStream.read() line: 89
T4CSocketInputStreamWrapper.readNextPacket() line: 123
T4CSocketInputStreamWrapper.read() line: 79
T4CMAREngineStream.unmarshalUB1() line: 426
T4C8Oall(T4CTTIfun).receive() line: 390
T4C8Oall(T4CTTIfun).doRPC() line: 249
T4C8Oall.doOALL(boolean, boolean, boolean, boolean, boolean, OracleStatement$SqlKind, int, byte[], int, Accessor[], int, Accessor[], int, byte[], char[], short[], int, DBConversion, byte[], InputStream[][], byte[][][], OracleTypeADT[][], OracleStatement, byte[], char[], short[], T4CTTIoac[], int[], int[], int[], NTFDCNRegistration) line: 566
T4CStatement.doOall8(boolean, boolean, boolean, boolean, boolean, int) line: 202
T4CStatement.doOall8(boolean, boolean, boolean, boolean, boolean) line: 45
T4CStatement.executeForRows(boolean) line: 933
T4CStatement(OracleStatement).executeMaybeDescribe() line: 929
T4CStatement(OracleStatement).doExecuteWithTimeout() line: 1034
T4CStatement(OracleStatement).executeQuery(String) line: 1244
OracleStatementWrapper.executeQuery(String) line: 420
JdbcDatabaseSnapshot$CachingDatabaseMetaData$2(ResultSetCache$ResultSetExtractor).executeAndExtract(String, Database, boolean) line: 255
JdbcDatabaseSnapshot$CachingDatabaseMetaData$2(ResultSetCache$ResultSetExtractor).executeAndExtract(String, Database) line: 242
JdbcDatabaseSnapshot$CachingDatabaseMetaData$2.fastFetch() line: 387
JdbcDatabaseSnapshot$CachingDatabaseMetaData$2.bulkFetch() line: 490
ResultSetCache.get(ResultSetExtractor) line: 59
JdbcDatabaseSnapshot$CachingDatabaseMetaData.getIndexInfo(String, String, String, String) line: 318
IndexSnapshotGenerator.snapshotObject(DatabaseObject, DatabaseSnapshot) line: 161
IndexSnapshotGenerator(JdbcSnapshotGenerator).snapshot(DatabaseObject, DatabaseSnapshot, SnapshotGeneratorChain) line: 66
SnapshotGeneratorChain.snapshot(T, DatabaseSnapshot) line: 49
ColumnSnapshotGeneratorOracle(JdbcSnapshotGenerator).snapshot(DatabaseObject, DatabaseSnapshot, SnapshotGeneratorChain) line: 69
SnapshotGeneratorChain.snapshot(T, DatabaseSnapshot) line: 49
JdbcDatabaseSnapshot(DatabaseSnapshot).include(T) line: 286
JdbcDatabaseSnapshot(DatabaseSnapshot).replaceObject(Object) line: 407
JdbcDatabaseSnapshot(DatabaseSnapshot).includeNestedObjects(DatabaseObject) line: 334
JdbcDatabaseSnapshot(DatabaseSnapshot).include(T) line: 309
JdbcDatabaseSnapshot(DatabaseSnapshot).replaceObject(Object) line: 407
JdbcDatabaseSnapshot(DatabaseSnapshot).replaceObject(Object) line: 429
JdbcDatabaseSnapshot(DatabaseSnapshot).includeNestedObjects(DatabaseObject) line: 334
JdbcDatabaseSnapshot(DatabaseSnapshot).include(T) line: 309
JdbcDatabaseSnapshot(DatabaseSnapshot).init(DatabaseObject[]) line: 102
JdbcDatabaseSnapshot(DatabaseSnapshot).<init>(DatabaseObject[], Database, SnapshotControl) line: 59
JdbcDatabaseSnapshot.<init>(DatabaseObject[], Database, SnapshotControl) line: 38
SnapshotGeneratorFactory.createSnapshot(DatabaseObject[], Database, SnapshotControl) line: 217
SnapshotGeneratorFactory.createSnapshot(CatalogAndSchema[], Database, SnapshotControl) line: 190
SnapshotGeneratorFactory.createSnapshot(CatalogAndSchema, Database, SnapshotControl) line: 157
SnapshotGeneratorFactory.has(DatabaseObject, Database) line: 144
IndexExistsPrecondition.check(Database, DatabaseChangeLog, ChangeSet, ChangeExecListener) line: 103
NotPrecondition.check(Database, DatabaseChangeLog, ChangeSet, ChangeExecListener) line: 40
PreconditionContainer(AndPrecondition).check(Database, DatabaseChangeLog, ChangeSet, ChangeExecListener) line: 45
PreconditionContainer.check(Database, DatabaseChangeLog, ChangeSet, ChangeExecListener) line: 215
ChangeSet.execute(DatabaseChangeLog, ChangeExecListener, Database) line: 516
UpdateVisitor.visit(ChangeSet, DatabaseChangeLog, Database, Set<ChangeSetFilterResult>) line: 53
ChangeLogIterator.run(ChangeSetVisitor, RuntimeEnvironment) line: 83
Liquibase.update(Contexts, LabelExpression, boolean) line: 202
Liquibase.update(Contexts, LabelExpression) line: 179
Liquibase.update(String, Contexts, LabelExpression) line: 334
LiquibaseUpdate.doUpdate(Liquibase) line: 33
LiquibaseUpdate(AbstractLiquibaseUpdateMojo).performLiquibaseTask(Liquibase) line: 30
LiquibaseUpdate(AbstractLiquibaseMojo).execute() line: 366
DefaultBuildPluginManager.executeMojo(MavenSession, MojoExecution) line: 134
MojoExecutor.execute(MavenSession, MojoExecution, ProjectIndex, DependencyContext) line: 207
MojoExecutor.execute(MavenSession, MojoExecution, ProjectIndex, DependencyContext, PhaseRecorder) line: 153
MojoExecutor.execute(MavenSession, List<MojoExecution>, ProjectIndex) line: 145
LifecycleModuleBuilder.buildProject(MavenSession, MavenSession, ReactorContext, MavenProject, TaskSegment) line: 116
LifecycleModuleBuilder.buildProject(MavenSession, ReactorContext, MavenProject, TaskSegment) line: 80
SingleThreadedBuilder.build(MavenSession, ReactorContext, ProjectBuildList, List<TaskSegment>, ReactorBuildStatus) line: 51
LifecycleStarter.execute(MavenSession) line: 128
DefaultMaven.doExecute(MavenExecutionRequest, MavenSession, MavenExecutionResult, DefaultRepositorySystemSession) line: 307
DefaultMaven.doExecute(MavenExecutionRequest) line: 193
DefaultMaven.execute(MavenExecutionRequest) line: 106
MavenCli.execute(CliRequest) line: 863
MavenCli.doMain(CliRequest) line: 288
MavenCli.main(String[], ClassWorld) line: 199
NativeMethodAccessorImpl.invoke0(Method, Object, Object[]) line: not available [native method]
NativeMethodAccessorImpl.invoke(Object, Object[]) line: 62
DelegatingMethodAccessorImpl.invoke(Object, Object[]) line: 43
Method.invoke(Object, Object...) line: 498
Launcher.launchEnhanced(String[]) line: 289
Launcher.launch(String[]) line: 229
Launcher.mainWithExitCode(String[]) line: 415
Launcher.main(String[]) line: 356

My output console is

[DEBUG] Computed checksum for 8:f8aaf837475588c187baf059caa66da5: as bc55ef347f1f7684590a93dfc5666107
[DEBUG] Running Changeset:master-cleva::abe_1::cleva
[DEBUG] Changeset master-cleva::abe_1::cleva
[DEBUG] Excluding ABR_CLEVA.T_MVT_NATURE.NMV_PTRPASID
[DEBUG] Excluding ABR_CLEVA.T_MVT_NATURE.NMV_IDENT

Has some body had the same problem?

Thanks.
Abdel.
- View full thread
<tagdatabase> throwing an error
started by Kiru.srini • 8 months ago
No one has responded yet.
<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
xmlns:ora="http://www.liquibase.org/xml/ns/dbchangelog-ext"
xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">

<changeSet id="19" author="Kiru">
<tagDatabase tag="tag-init"/>
<sqlFile dbms="oracle" path="data/test_table.sql" />

<rollback>
<dropTable tableName="test11"/>
</rollback>
</changeSet>
</databaseChangeLog>

I am getting the following an error.

cvc-complex-type.2.4.a: Invalid content was found starting with element 'sqlFile'. One of '{"http://
www.liquibase.org/xml/ns/dbchangelog":modifySql}' is expected.

Please help
- View full thread
can Liquibase generate changelog one file for one object?
started by Roy1 • 9 months ago
No one has responded yet.
Hi,

Thanks for checking my question.

We want to add liquibase into our existing project, and we also hope source control the database objects based on the file, meaning we prefer to generate the one change log file on one database object, then we source control the file and update the database object by sing the single object chang log file.

Now generating changelog create the only file for whole schema, I don't have see the option I could use to generate the changelog file separately for each object.

I know SQLcl could do that, but SQLcl can't allow us to specify the author for the changelog, so there is no perfect approach.Any idea or suggestions will be highly appreciated.

Thanks
Roy
- View full thread
generateChangeLog Oracle [1 Reply]
started by Robert Rabb • last reply by Roy1 • 9 months ago
Roy1 responded at 27-Aug-2019 01:51 AM.
1 Reply of 1
https://docs.oracle.com/en/database/oracle/sql-developer-command-line/19.2/sqcug/using-liquibase-sqlcl.html#GUID-4CA25386-E442-4D9D-B119-C1ACE6B79539

hope it helps
- 1 Reply of 1
- View full thread
Hiring: Liquibase Support Engineer
started by nvoxland • 9 months ago
No one has responded yet.
We are looking for someone to help us elevate the Liquibase support experience. If you consider yourself to be a Liquibase Rockstar and can bring expertise to this area, please let me know.

This can be part-time or full-time position and can be remote.

https://www.datical.com/company/careers/?gh_jid=1827858

Nathan
- View full thread
Redshift extension new release [1 Reply]
started by Michael McCord • last reply by nvoxland • 9 months ago
nvoxland responded at 22-Aug-2019 03:53 PM.
1 Reply of 1
There are a few extensions that need a new release out and we're looking at how to best coordinate all that. Should be soon, thanks for checking.

Nathan
- 1 Reply of 1
- View full thread
Functions, Stored Proc, and the Like [1 Reply]
started by Victor • last reply by Nikita • 9 months ago
Nikita responded at 08-Aug-2019 12:45 AM.
1 Reply of 1
This seems a working solution. Except that you are correct, the presented code would fail on function change
You can use runOnChange attribute on the changeset tags defining the functions and the like (and / or runAlways, just to be on the safe side).

If stored procedures are written in an idempotent way (e.g. CREATE OR REPLACE in Postgres, or DROP IF EXISTS ... ; CREATE ... in SQL Server) then the code would just run on change and it would be possible to use neat git diffs to see the actual change.

Problem here is that it becomes a bit hard to see which changes have been applied to the database and which weren't.
The only thing you know is that "when sproc A was last replaced at <timestamp>, the SQL code hashed to a value of <hash>".
Since you don't have a ready hash of the resulting changeset, it might be a bit hard to identify in case of any discrepancies. This could be a moot point if you have other ways of tracking deployed versions, of course...
- 1 Reply of 1
- View full thread

Code generated for a conditional index gives error in MS SQL Server

started by Sunil • 1 year ago

No one has responded yet.

I have this following index in my SQL Server Database

CREATE NONCLUSTERED INDEX XCR_ACTIVE ON dbo.CS_PA_VEH_BASE ( ETL_ACTIVE_FL ) WHERE ETL_ACTIVE_FL = 'N' ON "default";

for which liquibase gives out following:

</createIndex>

But when I want to execute it (also in MS SQL Server) I get the following error:

(14.2) 05-24-19 11:43:05 (E) (13004:15088) RUN-050304: |Session JOB_ODS_Liquibase

                                                       Function call <raise_exception ( Liquibase update error:      -1: Unexpected error running Liquibase: Incorrect syntax near
                                                       '('. [Failed SQL: CREATE NONCLUSTERED INDEX XCR_ACTIVE ON [dbo].[CS_PA_VEH_DELTA](([ETL_ACTIVE_FL]='N'))] ) > failed, due to
                                                       error <50316>: <Liquibase update error:      -1: Unexpected error running Liquibase: Incorrect syntax near '('. [Failed SQL:
                                                       CREATE NONCLUSTERED INDEX XCR_ACTIVE ON [dbo].[CS_PA_VEH_DELTA](([ETL_ACTIVE_FL]='N'))]>.

I hope it's not the first time this is happening to someone.

View full thread

« Newer
Older »

Join this portal to...

Get recent activities of the portal
Give an idea and get implemented.
Get notifications in email.
View your activities in one place.

Join Now

Liquibase Development

Please note we are upgrading the forum site to use Discourse forums. This forum will become read-only by EOD 5/31/20. URL will remain the same, may have to reset your user.

508 Post(s)

2 Moderator(s)

Forum actions

Quick links

Privacy
Terms & Conditions
RSS
Powered by

Response title

Attachments

New to this Portal?

Topics

Liquibase S3 extension

Liquibase is NOT fully supporting for SAP HANA DB [1 Reply]

loadUpdateData tag not working in Oracle when using sqlplus [1 Reply]

Improve LockService (especially for CI/CD) environments

Documentation improvement about parameters

Tagging in SQL format changeset [5 Replies]

New more condensed and more detailed page layout for the changes [4 Replies]

eclipse / intellij import (liquibase-core) [3 Replies]

Liquibase diff fail

Steps contributing the documentation [2 Replies]

META-INF\MANIFEST.MF build problem [9 Replies]

jaxb-api : 2.3.0 copyleft [2 Replies]

Oracle create stored procedure using Liquibase

Adding column without deleting the existing records from table [2 Replies]

dbdoc: adding asciidoc markup generation - could I add it? [1 Reply]

jdbc error

CustomChange(Wrapper?) question [2 Replies]

Index Precondition performance on ORACLE

<tagdatabase> throwing an error

can Liquibase generate changelog one file for one object?

generateChangeLog Oracle [1 Reply]

Hiring: Liquibase Support Engineer

Redshift extension new release [1 Reply]

Functions, Stored Proc, and the Like [1 Reply]

Code generated for a conditional index gives error in MS SQL Server

Join this portal to...

Please note we are upgrading the forum site to use Discourse forums. This forum will become read-only by EOD 5/31/20. URL will remain the same, may have to reset your user.