Hello, Can someone help us with this ? Trying to upgrade Grameen koota to Mifos 2.0 and we are facing an error. Interestingly we faced this error after migrating the surveys to Questions groups - which was a pain point earlier.
Thanks Chetan From: Rajagopalan, Seetha Sent: Monday, April 16, 2012 6:46 PM To: Keith Woodlock Cc: Jakub Sławiński; Udai Gupta ([email protected]); Bekkinkeri, Chetan Subject: Out of memory error during upgrade Hi! I am trying to upgrade GK's database from v1.6 to v2.0. The upgrade failed due to java.lang.OutOfMemoryError. I require some clarifications in order to resolve this issue. 1. What could be the root cause for this error? I am in the process of checking the server configuration with GK. 2. What are the possible solutions? Increasing the JAVA_OPTS environment variable is one of the options I am considering. 3. Will it be possible to continue the upgrade by redeploying the war file or will I need to restore the database and start again? Please find below a summary of the mifos logs. Could you please help me out? LOGS 1334571413563 Migrated survey no 34900 1334571417054 Migrated survey no 35000 1334571420554 Migrated survey no 35100 1334571424056 Migrated survey no 35200 1334571427821 Migrated survey no 35300 - took 1329965 msec - migrating additional fields... 1334571428428 migrating Additional Fields for CLIENT Exception in thread "Thread-2" java.lang.OutOfMemoryError: Java heap space at java.lang.StringCoding$StringEncoder.encode(StringCoding.java:232) at java.lang.StringCoding.encode(StringCoding.java:272) at java.lang.String.getBytes(String.java:946) at java.io.UnixFileSystem.getBooleanAttributes0(Native Method) at java.io.UnixFileSystem.getBooleanAttributes(UnixFileSystem.java:228) at java.io.File.exists(File.java:733) at org.apache.log4j.helpers.FileWatchdog.checkAndConfigure(FileWatchdog.java:77) at org.apache.log4j.helpers.FileWatchdog.run(FileWatchdog.java:108) 2012-04-16/15:57:35.604/IST ERROR, org.mifos.framework.ApplicationInitializer, ?, ?, ?, Failed to upgrade database. java.lang.OutOfMemoryError: Java heap space at sun.nio.cs.UTF_8.newDecoder(UTF_8.java:49) at java.lang.StringCoding$StringDecoder.<init>(StringCoding.java:116) at java.lang.StringCoding$StringDecoder.<init>(StringCoding.java:108) at java.lang.StringCoding.decode(StringCoding.java:167) at java.lang.String.<init>(String.java:443) at com.mysql.jdbc.ResultSetRow.getString(ResultSetRow.java:796) at com.mysql.jdbc.ByteArrayRow.getString(ByteArrayRow.java:69) at com.mysql.jdbc.ResultSetImpl.getStringInternal(ResultSetImpl.java:5699) at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5576) at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5616) at com.mchange.v2.c3p0.impl.NewProxyResultSet.getString(NewProxyResultSet.java:3342) at org.hibernate.type.StringType.get(StringType.java:41) at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:186) at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:212) at org.hibernate.loader.custom.CustomLoader$ScalarResultColumnProcessor.extract(CustomLoader.java:501) at org.hibernate.loader.custom.CustomLoader$ResultRowProcessor.buildResultRow(CustomLoader.java:447) at org.hibernate.loader.custom.CustomLoader.getResultColumnOrRow(CustomLoader.java:344) at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:647) at org.hibernate.loader.Loader.doQuery(Loader.java:745) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270) at org.hibernate.loader.Loader.doList(Loader.java:2294) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2172) at org.hibernate.loader.Loader.list(Loader.java:2167) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316) at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1832) at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165) at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:179) at org.mifos.accounts.savings.persistence.GenericDaoHibernate.executeNamedQuery(GenericDaoHibernate.java:76) at org.mifos.customers.persistence.CustomerDaoHibernate.getCustomFieldResponses(CustomerDaoHibernate.java:1692) at org.mifos.application.questionnaire.migration.QuestionnaireMigration.getCustomFieldResponsesList(QuestionnaireMigration.java:340) at org.mifos.application.questionnaire.migration.QuestionnaireMigration.getCustomFieldResponses(QuestionnaireMigration.java:328) at org.mifos.application.questionnaire.migration.QuestionnaireMigration.migrateAdditionalFieldsResponses(QuestionnaireMigration.java:253) 2012-04-16/15:57:35.644/IST ERROR, org.hibernate.util.JDBCExceptionReporter, ?, ?, ?, Communications link failure The last packet successfully received from the server was 627,034 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago. 2012-04-16/15:57:35.648/IST ERROR, org.mifos.framework.ApplicationInitializer, ?, ?, ?, unable to start Mifos web application org.mifos.framework.exceptions.StartUpException: org.hibernate.exception.JDBCConnectionException: could not execute query at org.mifos.config.util.helpers.ConfigurationInitializer.initialize(ConfigurationInitializer.java:115) at org.mifos.config.business.Configuration.initialize(Configuration.java:57) at org.mifos.config.business.Configuration.getInstance(Configuration.java:50) at org.mifos.framework.ApplicationInitializer.setAttributesOnContext(ApplicationInitializer.java:210) Thanks and regards, Seetha Rajagopalan * Engineer - Product Development * Mifos * SunGard * Global Services Embassy Icon, 3 Infantry Road, Bangalore 560 001, India Main +91 (80) 3091 3000 X3234 [Description: https://sunshine.sungard.com/SGT/Extras/Proud%20to%20be%20at%20SunGard/Proud%20to%20be%20at%20SunGard.gif]<https://sunshine.sungard.com/SGT/Extras/Proud%20to%20be%20at%20SunGard.aspx> P Think before you print CONFIDENTIALITY: This e-mail (including any attachments) may contain confidential, proprietary and privileged information, and unauthorized disclosure or use is prohibited. If you receive this e-mail in error, please notify the sender and delete this e-mail from your system.
<<inline: image001.gif>>
------------------------------------------------------------------------------ Better than sec? Nothing is better than sec when it comes to monitoring Big Data applications. Try Boundary one-second resolution app monitoring today. Free. http://p.sf.net/sfu/Boundary-dev2dev
_______________________________________________ Mifos-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mifos-users
