[Mifos-issues] [JIRA Studio] Created: (MIFOS-4004) Database upgrade from 1.6.1 to Leila E fails with the SQLGrammerException in upgrade 1285177663
Jakub Sławiński (JIRA)
-----------------------------------------------------------------------------------------------
Key: MIFOS-4004
URL: http://mifosforge.jira.com/browse/MIFOS-4004
Project: mifos
Issue Type: Bug
Affects Versions: Release E
Reporter: Jakub Sławiński
Assignee: Artur Siekielski
Priority: Critical
Fix For: Release E - Iteration 10, Release E
Database upgrade from 1.6.1 to Leila E fails with the SQLGrammerException in upgrade 1285177663. This error is caused by changes introduced in upgrade 1286195484 (new column in customer_address_detail). It seems that we cannot have schema changes of entities used in Java upgrades (schema changes cannot be introduced after the Java upgrade).
The easiest workaround is to move schema upgrade before Java upgrade.
applying upgrade with timestamp: 1285177663
Time to execute the query 38 . Got 6 accounts.
Using parameters:
OutputIntervalForBatchJobs: 1000
BatchSizeForBatchJobs: 100
RecordCommittingSizeForBatchJobs: 500
6 accounts to process, results output every 1000 accounts
2010-10-25/11:26:36.613/CEST ERROR, org.hibernate.util.JDBCExceptionReporter, ?, ?, ?, Unknown column 'customerad1_.phone_number_stripped' in 'field list'
account 12 exception could not load an entity: [org.mifos.customers.business.CustomerBO#9]
2010-10-25/11:26:36.659/CEST ERROR, org.mifos.framework.persistence.Upgrade, ?, ?, ?, Unable to generate schedules for account with ID 12
org.hibernate.exception.SQLGrammarException: could not load an entity: [org.mifos.customers.business.CustomerBO#9]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1937)
...
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'customerad1_.phone_number_stripped' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Mifos-issues mailing list
Mifos-...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-issues
Mifos Hudson Jira Plugin User (JIRA)
[ http://mifosforge.jira.com/browse/MIFOS-4004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=61053#action_61053 ]
Mifos Hudson Jira Plugin User commented on MIFOS-4004:
------------------------------------------------------
Integrated in !http://ci.mifos.org/hudson/images/16x16/blue.gif! [head-1.7.x #121|http://ci.mifos.org/hudson/job/head-1.7.x/121/]
MIFOS-4004: workaround for not working db upgrade.
Artur Siekielski : [8e26646cfd5e5053a3edaac3742154fa21215bcc|http://mifos.git.sourceforge.net/git/gitweb.cgi?p=mifos/head&a=commit&h=8e26646cfd5e5053a3edaac3742154fa21215bcc]
Files :
* application/src/main/java/org/mifos/application/master/persistence/Upgrade1286195484.java
* application/src/main/java/org/mifos/application/master/persistence/Upgrade1285177663.java
Artur Siekielski (JIRA)
[ http://mifosforge.jira.com/browse/MIFOS-4004?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Artur Siekielski resolved MIFOS-4004.
-------------------------------------
Resolution: Fixed
Mifos Hudson Jira Plugin User (JIRA)
[ http://mifosforge.jira.com/browse/MIFOS-4004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=61065#action_61065 ]
Mifos Hudson Jira Plugin User commented on MIFOS-4004:
------------------------------------------------------
Integrated in !http://ci.mifos.org/hudson/images/16x16/blue.gif! [head-master #2060|http://ci.mifos.org/hudson/job/head-master/2060/]
MIFOS-4004: workaround for not working db upgrade.
Artur Siekielski : [8e26646cfd5e5053a3edaac3742154fa21215bcc|http://mifos.git.sourceforge.net/git/gitweb.cgi?p=mifos/head&a=commit&h=8e26646cfd5e5053a3edaac3742154fa21215bcc]
Files :
* application/src/main/java/org/mifos/application/master/persistence/Upgrade1286195484.java
* application/src/main/java/org/mifos/application/master/persistence/Upgrade1285177663.java
jbrewster (JIRA)
[ http://mifosforge.jira.com/browse/MIFOS-4004?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
jbrewster updated MIFOS-4004:
-----------------------------
Status: Verified (was: Resolved)