A new topic, 'Problem with liquibase when use tag command on informix', has
been made on a board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=691.new#new
The text of the topic is shown below:
hi all,
i am getting the error as shown below when i try to tag the informix database
using liquibase command. have anyone come into this issue before? please advise
how to resolve this.
Thanks in advance.
and btw, i am using informix version 10
Liquibase Update Failed: Error executing SQL UPDATE DATABASECHANGELOG SET TAG =
'2' WHERE DATEEXECUTED = (SELECT MAX(DATEEXECUTED) FROM DATABASECHANGELOG)
Sep 8, 2010 8:59:27 AM liquibase.logging.jvm.JavaUtilLogger info
INFO: Error executing SQL UPDATE DATABASECHANGELOG SET TAG = '2' WHERE DATEEXECU
TED = (SELECT MAX(DATEEXECUTED) FROM DATABASECHANGELOG)
liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: Er
ror executing SQL UPDATE DATABASECHANGELOG SET TAG = '2' WHERE DATEEXECUTED = (S
ELECT MAX(DATEEXECUTED) FROM DATABASECHANGELOG)
at liquibase.database.AbstractDatabase.tag(AbstractDatabase.java:632)
at liquibase.Liquibase.tag(Liquibase.java:507)
at liquibase.integration.commandline.Main.doMigration(Main.java:631)
at liquibase.integration.commandline.Main.main(Main.java:105)
Caused by: liquibase.exception.DatabaseException: Error executing SQL UPDATE DAT
ABASECHANGELOG SET TAG = '2' WHERE DATEEXECUTED = (SELECT MAX(DATEEXECUTED) FROM
DATABASECHANGELOG)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
at liquibase.executor.jvm.JdbcExecutor.update(JdbcExecutor.java:222)
at liquibase.executor.jvm.JdbcExecutor.update(JdbcExecutor.java:199)
at liquibase.database.AbstractDatabase.tag(AbstractDatabase.java:624)
... 3 more
Caused by: java.sql.SQLException: Cannot modify table or view used in subquery.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3175)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3484)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2328)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2244)
at com.informix.jdbc.IfxSqli.executeCommand(IfxSqli.java:766)
at com.informix.jdbc.IfxResultSet.b(IfxResultSet.java:291)
at com.informix.jdbc.IfxStatement.c(IfxStatement.java:1253)
at com.informix.jdbc.IfxStatement.b(IfxStatement.java:407)
at com.informix.jdbc.IfxStatement.executeUpdate(IfxStatement.java:261)
at liquibase.executor.jvm.JdbcExecutor$1UpdateStatementCallback.doInStat
ement(JdbcExecutor.java:214)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
... 6 more
Caused by: java.sql.SQLException
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3489)
... 15 more
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0
Regards,
The Liquibase Community Forum Team.------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
