|
»
»
»
Problem while migration 1.6 to 1.7
|
View:
New views
7 Messages
—
Rating Filter:
Alert me
|
 |
Problem while migration 1.6 to 1.7
by Stellit
::
Rate this Message:
I'm very happy to see liquibase releases newest version 1.7, but after
trying migrate 1.6 to 1.7, liquibase does not read any data from changelog. has anybody got the same problem? any idea? regards, Stellit ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ Liquibase-user mailing list Liquibase-user@... https://lists.sourceforge.net/lists/listinfo/liquibase-user |
|
|
Re: Problem while migration 1.6 to 1.7
by Voxland, Nathan
::
Rate this Message:
Are you getting any errors? What mode are you using? (command line,
ant, maven, etc)? Nathan -----Original Message----- From: liquibase-user-bounces@... [mailto:liquibase-user-bounces@...] On Behalf Of Stellit Sent: Monday, June 30, 2008 3:19 AM To: liquibase-user@... Subject: [Liquibase-user] Problem while migration 1.6 to 1.7 I'm very happy to see liquibase releases newest version 1.7, but after trying migrate 1.6 to 1.7, liquibase does not read any data from changelog. has anybody got the same problem? any idea? regards, Stellit ------------------------------------------------------------------------ - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ Liquibase-user mailing list Liquibase-user@... https://lists.sourceforge.net/lists/listinfo/liquibase-user ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ Liquibase-user mailing list Liquibase-user@... https://lists.sourceforge.net/lists/listinfo/liquibase-user |
|
|
Re: Problem while migration 1.6 to 1.7
by Stellit
::
Rate this Message:
The configure file looks like the following:
<bean id="liquibase" class="liquibase.spring.SpringLiquibase"> <property name="dataSource" ref="dataSource" /> <property name="changeLog" value="classpath:db-changelog/MAIN.changelog.xml" /> <!-- The following configuration options are optional --> <property name="executeEnabled" value="true" /> <!-- If set to true, writeSqlFileEnabled will write the generated SQL to a file before executing it. --> <property name="writeSqlFileEnabled" value="true" /> <!-- sqlOutputDir specifies the directory into which the SQL file will be written, if so configured. --> <property name="sqlOutputDir" value="${java.io.tmpdir}/smec-liquibase-sqloutputdir" /> <!-- contexts specifies the runtime contexts to use. --> <property name="contexts" value="${liquibase.contexts}" /> </bean> it looks almost the same as the manual page on liquibase.org I use liquibase with spring and it works under liquibase 1.6 withou any problem. Liquibase read every changelog, check the grammar of each, and the context property of each changelog is the same as the configure file(property contexts) any Idea? Regards, Stellit Voxland, Nathan schrieb: > Are you getting any errors? What mode are you using? (command line, > ant, maven, etc)? > > Nathan > > -----Original Message----- > From: liquibase-user-bounces@... > [mailto:liquibase-user-bounces@...] On Behalf Of > Stellit > Sent: Monday, June 30, 2008 3:19 AM > To: liquibase-user@... > Subject: [Liquibase-user] Problem while migration 1.6 to 1.7 > > I'm very happy to see liquibase releases newest version 1.7, but after > trying migrate 1.6 to 1.7, liquibase does not read any data from > changelog. > has anybody got the same problem? > any idea? > regards, > Stellit > > ------------------------------------------------------------------------ > - > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > Liquibase-user mailing list > Liquibase-user@... > https://lists.sourceforge.net/lists/listinfo/liquibase-user > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > Liquibase-user mailing list > Liquibase-user@... > https://lists.sourceforge.net/lists/listinfo/liquibase-user > ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ Liquibase-user mailing list Liquibase-user@... https://lists.sourceforge.net/lists/listinfo/liquibase-user |
|
|
Re: Problem while migration 1.6 to 1.7
by Voxland, Nathan
::
Rate this Message:
It looks right. You are not getting anything in the logs? If you do a
select * from DATABASECHANGELOG order by DATEEXECUTED desc do you see your newest changes marked as ran? Nathan -----Original Message----- From: liquibase-user-bounces@... [mailto:liquibase-user-bounces@...] On Behalf Of Stellit Sent: Monday, June 30, 2008 10:12 AM To: liquibase-user@... Subject: Re: [Liquibase-user] Problem while migration 1.6 to 1.7 The configure file looks like the following: <bean id="liquibase" class="liquibase.spring.SpringLiquibase"> <property name="dataSource" ref="dataSource" /> <property name="changeLog" value="classpath:db-changelog/MAIN.changelog.xml" /> <!-- The following configuration options are optional --> <property name="executeEnabled" value="true" /> <!-- If set to true, writeSqlFileEnabled will write the generated SQL to a file before executing it. --> <property name="writeSqlFileEnabled" value="true" /> <!-- sqlOutputDir specifies the directory into which the SQL file will be written, if so configured. --> <property name="sqlOutputDir" value="${java.io.tmpdir}/smec-liquibase-sqloutputdir" /> <!-- contexts specifies the runtime contexts to use. --> <property name="contexts" value="${liquibase.contexts}" /> </bean> it looks almost the same as the manual page on liquibase.org I use liquibase with spring and it works under liquibase 1.6 withou any problem. Liquibase read every changelog, check the grammar of each, and the context property of each changelog is the same as the configure file(property contexts) any Idea? Regards, Stellit Voxland, Nathan schrieb: > Are you getting any errors? What mode are you using? (command line, > ant, maven, etc)? > > Nathan > > -----Original Message----- > From: liquibase-user-bounces@... > [mailto:liquibase-user-bounces@...] On Behalf Of > Stellit > Sent: Monday, June 30, 2008 3:19 AM > To: liquibase-user@... > Subject: [Liquibase-user] Problem while migration 1.6 to 1.7 > > I'm very happy to see liquibase releases newest version 1.7, but after > trying migrate 1.6 to 1.7, liquibase does not read any data from > changelog. > has anybody got the same problem? > any idea? > regards, > Stellit > > ------------------------------------------------------------------------ > - > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > Liquibase-user mailing list > Liquibase-user@... > https://lists.sourceforge.net/lists/listinfo/liquibase-user > > - > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > Liquibase-user mailing list > Liquibase-user@... > https://lists.sourceforge.net/lists/listinfo/liquibase-user > ------------------------------------------------------------------------ - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ Liquibase-user mailing list Liquibase-user@... https://lists.sourceforge.net/lists/listinfo/liquibase-user ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ Liquibase-user mailing list Liquibase-user@... https://lists.sourceforge.net/lists/listinfo/liquibase-user |
|
|
Re: Problem while migration 1.6 to 1.7
by Stellit
::
Rate this Message:
following is the log from liquibase while I start my app, normally,
liquibase should also starting to read changelog and make the changes in database. ==================liquibase log start here=============== 02.07.2008 08:10:09 liquibase.lock.LockHandler acquireLock INFO: Successfully acquired change log lock 02.07.2008 08:10:09 liquibase.database.AbstractDatabase checkDatabaseChangeLogTable INFO: Creating database history table with name: `DATABASECHANGELOG` 02.07.2008 08:10:09 liquibase.database.AbstractDatabase getRanChangeSetList INFO: Reading from `DATABASECHANGELOG` 02.07.2008 08:10:09 liquibase.lock.LockHandler releaseLock INFO: Successfully released change log lock 02.07.2008 08:10:09 liquibase.database.template.JdbcTemplate comment INFO: Create Database Lock Table 02.07.2008 08:10:09 liquibase.database.template.JdbcTemplate comment INFO: Lock Database 02.07.2008 08:10:09 liquibase.lock.LockHandler acquireLock INFO: Successfully acquired change log lock 02.07.2008 08:10:09 liquibase.database.template.JdbcTemplate comment INFO: Create Database Change Log Table 02.07.2008 08:10:09 liquibase.database.AbstractDatabase checkDatabaseChangeLogTable INFO: Creating database history table with name: `DATABASECHANGELOG` 02.07.2008 08:10:10 liquibase.database.template.JdbcTemplate comment INFO: Release Database Lock 02.07.2008 08:10:10 liquibase.lock.LockHandler releaseLock INFO: Successfully released change log lock =========liquibase log above========= 08:10:10.349 INFO [main] org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:209) >09> Root WebApplicationContext: initialization completed in 13800 ms regards, stellit Voxland, Nathan schrieb: > It looks right. You are not getting anything in the logs? If you do a > select * from DATABASECHANGELOG order by DATEEXECUTED desc do you see > your newest changes marked as ran? > > Nathan > > -----Original Message----- > From: liquibase-user-bounces@... > [mailto:liquibase-user-bounces@...] On Behalf Of > Stellit > Sent: Monday, June 30, 2008 10:12 AM > To: liquibase-user@... > Subject: Re: [Liquibase-user] Problem while migration 1.6 to 1.7 > > The configure file looks like the following: > <bean id="liquibase" class="liquibase.spring.SpringLiquibase"> > <property name="dataSource" ref="dataSource" /> > <property name="changeLog" > value="classpath:db-changelog/MAIN.changelog.xml" /> > <!-- The following configuration options are optional --> > <property name="executeEnabled" value="true" /> > <!-- > If set to true, writeSqlFileEnabled will write the generated > SQL to a file before executing it. > --> > <property name="writeSqlFileEnabled" value="true" /> > <!-- > sqlOutputDir specifies the directory into which the SQL file > will be written, if so configured. > --> > <property name="sqlOutputDir" > value="${java.io.tmpdir}/smec-liquibase-sqloutputdir" /> > <!-- > contexts specifies the runtime contexts to use. > --> > <property name="contexts" value="${liquibase.contexts}" /> > </bean> > it looks almost the same as the manual page on liquibase.org > I use liquibase with spring and it works under liquibase 1.6 withou any > problem. > Liquibase read every changelog, check the grammar of each, and the > context property of each changelog is the same as the configure > file(property contexts) > any Idea? > > Regards, > Stellit > > Voxland, Nathan schrieb: > >> Are you getting any errors? What mode are you using? (command line, >> ant, maven, etc)? >> >> Nathan >> >> -----Original Message----- >> From: liquibase-user-bounces@... >> [mailto:liquibase-user-bounces@...] On Behalf Of >> Stellit >> Sent: Monday, June 30, 2008 3:19 AM >> To: liquibase-user@... >> Subject: [Liquibase-user] Problem while migration 1.6 to 1.7 >> >> I'm very happy to see liquibase releases newest version 1.7, but after >> > > >> trying migrate 1.6 to 1.7, liquibase does not read any data from >> changelog. >> has anybody got the same problem? >> any idea? >> regards, >> Stellit >> >> >> > ------------------------------------------------------------------------ > >> - >> Check out the new SourceForge.net Marketplace. >> It's the best place to buy or sell services for >> just about anything Open Source. >> http://sourceforge.net/services/buy/index.php >> _______________________________________________ >> Liquibase-user mailing list >> Liquibase-user@... >> https://lists.sourceforge.net/lists/listinfo/liquibase-user >> >> >> > ------------------------------------------------------------------------ > - > >> Check out the new SourceForge.net Marketplace. >> It's the best place to buy or sell services for >> just about anything Open Source. >> http://sourceforge.net/services/buy/index.php >> _______________________________________________ >> Liquibase-user mailing list >> Liquibase-user@... >> https://lists.sourceforge.net/lists/listinfo/liquibase-user >> >> > > > ------------------------------------------------------------------------ > - > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > Liquibase-user mailing list > Liquibase-user@... > https://lists.sourceforge.net/lists/listinfo/liquibase-user > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > Liquibase-user mailing list > Liquibase-user@... > https://lists.sourceforge.net/lists/listinfo/liquibase-user > ------------------------------------------------------------------------- Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 _______________________________________________ Liquibase-user mailing list Liquibase-user@... https://lists.sourceforge.net/lists/listinfo/liquibase-user |
|
|
Re: Problem while migration 1.6 to 1.7
by Voxland, Nathan
::
Rate this Message:
According to the log, it looks like it is seeing a blank database and
creating the databasechangelog table. I'm not sure if it would log what it executes or not. I'll config my test instance like yours is set up and see what I can find. Thanks for your help troubleshooting this. Nathan -----Original Message----- From: liquibase-user-bounces@... [mailto:liquibase-user-bounces@...] On Behalf Of Stellit Sent: Wednesday, July 02, 2008 1:15 AM To: liquibase-user@... Subject: Re: [Liquibase-user] Problem while migration 1.6 to 1.7 following is the log from liquibase while I start my app, normally, liquibase should also starting to read changelog and make the changes in database. ==================liquibase log start here=============== 02.07.2008 08:10:09 liquibase.lock.LockHandler acquireLock INFO: Successfully acquired change log lock 02.07.2008 08:10:09 liquibase.database.AbstractDatabase checkDatabaseChangeLogTable INFO: Creating database history table with name: `DATABASECHANGELOG` 02.07.2008 08:10:09 liquibase.database.AbstractDatabase getRanChangeSetList INFO: Reading from `DATABASECHANGELOG` 02.07.2008 08:10:09 liquibase.lock.LockHandler releaseLock INFO: Successfully released change log lock 02.07.2008 08:10:09 liquibase.database.template.JdbcTemplate comment INFO: Create Database Lock Table 02.07.2008 08:10:09 liquibase.database.template.JdbcTemplate comment INFO: Lock Database 02.07.2008 08:10:09 liquibase.lock.LockHandler acquireLock INFO: Successfully acquired change log lock 02.07.2008 08:10:09 liquibase.database.template.JdbcTemplate comment INFO: Create Database Change Log Table 02.07.2008 08:10:09 liquibase.database.AbstractDatabase checkDatabaseChangeLogTable INFO: Creating database history table with name: `DATABASECHANGELOG` 02.07.2008 08:10:10 liquibase.database.template.JdbcTemplate comment INFO: Release Database Lock 02.07.2008 08:10:10 liquibase.lock.LockHandler releaseLock INFO: Successfully released change log lock =========liquibase log above========= 08:10:10.349 INFO [main] org.springframework.web.context.ContextLoader.initWebApplicationContext( ContextLoader.java:209) >09> Root WebApplicationContext: initialization completed in 13800 ms regards, stellit Voxland, Nathan schrieb: > It looks right. You are not getting anything in the logs? If you do a > select * from DATABASECHANGELOG order by DATEEXECUTED desc do you see > your newest changes marked as ran? > > Nathan > > -----Original Message----- > From: liquibase-user-bounces@... > [mailto:liquibase-user-bounces@...] On Behalf Of > Stellit > Sent: Monday, June 30, 2008 10:12 AM > To: liquibase-user@... > Subject: Re: [Liquibase-user] Problem while migration 1.6 to 1.7 > > The configure file looks like the following: > <bean id="liquibase" class="liquibase.spring.SpringLiquibase"> > <property name="dataSource" ref="dataSource" /> > <property name="changeLog" > value="classpath:db-changelog/MAIN.changelog.xml" /> > <!-- The following configuration options are optional --> > <property name="executeEnabled" value="true" /> > <!-- > If set to true, writeSqlFileEnabled will write the > SQL to a file before executing it. > --> > <property name="writeSqlFileEnabled" value="true" /> > <!-- > sqlOutputDir specifies the directory into which the SQL file > will be written, if so configured. > --> > <property name="sqlOutputDir" > value="${java.io.tmpdir}/smec-liquibase-sqloutputdir" /> > <!-- > contexts specifies the runtime contexts to use. > --> > <property name="contexts" value="${liquibase.contexts}" /> > </bean> > it looks almost the same as the manual page on liquibase.org > I use liquibase with spring and it works under liquibase 1.6 withou > problem. > Liquibase read every changelog, check the grammar of each, and the > context property of each changelog is the same as the configure > file(property contexts) > any Idea? > > Regards, > Stellit > > Voxland, Nathan schrieb: > >> Are you getting any errors? What mode are you using? (command line, >> ant, maven, etc)? >> >> Nathan >> >> -----Original Message----- >> From: liquibase-user-bounces@... >> [mailto:liquibase-user-bounces@...] On Behalf Of >> Stellit >> Sent: Monday, June 30, 2008 3:19 AM >> To: liquibase-user@... >> Subject: [Liquibase-user] Problem while migration 1.6 to 1.7 >> >> I'm very happy to see liquibase releases newest version 1.7, but >> > > >> trying migrate 1.6 to 1.7, liquibase does not read any data from >> changelog. >> has anybody got the same problem? >> any idea? >> regards, >> Stellit >> >> >> > > >> - >> Check out the new SourceForge.net Marketplace. >> It's the best place to buy or sell services for >> just about anything Open Source. >> http://sourceforge.net/services/buy/index.php >> _______________________________________________ >> Liquibase-user mailing list >> Liquibase-user@... >> https://lists.sourceforge.net/lists/listinfo/liquibase-user >> >> >> > > - > >> Check out the new SourceForge.net Marketplace. >> It's the best place to buy or sell services for >> just about anything Open Source. >> http://sourceforge.net/services/buy/index.php >> _______________________________________________ >> Liquibase-user mailing list >> Liquibase-user@... >> https://lists.sourceforge.net/lists/listinfo/liquibase-user >> >> > > > > - > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > Liquibase-user mailing list > Liquibase-user@... > https://lists.sourceforge.net/lists/listinfo/liquibase-user > > - > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > Liquibase-user mailing list > Liquibase-user@... > https://lists.sourceforge.net/lists/listinfo/liquibase-user > ------------------------------------------------------------------------ - Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 _______________________________________________ Liquibase-user mailing list Liquibase-user@... https://lists.sourceforge.net/lists/listinfo/liquibase-user ------------------------------------------------------------------------- Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 _______________________________________________ Liquibase-user mailing list Liquibase-user@... https://lists.sourceforge.net/lists/listinfo/liquibase-user |
|
|
Re: Problem while migration 1.6 to 1.7
by Stellit
::
Rate this Message:
thanks nathan.
can't wait to see the solution from you~~ Stellit ------------------------------------------------------------------------- Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 _______________________________________________ Liquibase-user mailing list Liquibase-user@... https://lists.sourceforge.net/lists/listinfo/liquibase-user |
| Free Forum Powered by Nabble | Forum Help |