9 November 2012
Hi,
Good day! I asked Jervis to help our coop in the upgrade of Mifos from 2.4.1 to
2.5. Encountered some errors. Please read his comments below. Any help
appreciated. Thanks.
----
We were attempting to upgrade our mifos setup from v2.4.1 into v.2.5.0
We were following the instructions found here
We got into several errors after running the batch file "expand_db.bat".
Please find below the error logs.
C:\mifos\mifos-v2.5.0\db\bin>expand_db.bat
INFO 11/9/12 11:40 PM:liquibase: Successfully acquired change log lock
INFO 11/9/12 11:40 PM:liquibase: Reading from `mifos`.`DATABASECHANGELOG`
INFO 11/9/12 11:40 PM:liquibase: Reading from `mifos`.`DATABASECHANGELOG`
SEVERE 11/9/12 11:40 PM:liquibase: Change Set changesets/changelog-Release_J.xml
::MIFOSACC::Hugo Technologies failed. Error: Error executing SQL Insert into co
nfig_key_value
(configuration_type,configuration_key,
configuration_value) values
(1,'MisProcessing','01/01/2012'): Duplicate entry 'MisPr
ocessing' for key 'configuration_key'
liquibase.exception.DatabaseException: Error executing SQL Insert into config_ke
y_value
(configuration_type,configuration_key,
configuration_value) values
(1,'MisProcessing','01/01/2012'): Duplicate entry 'MisPr
ocessing' for key 'configuration_key'
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:107
5)
at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabas
e.java:1059)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27
)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
at liquibase.Liquibase.update(Liquibase.java:113)
at liquibase.integration.commandline.Main.doMigration(Main.java:779)
at liquibase.integration.commandline.Main.main(Main.java:133)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationExce
ption: Duplicate entry 'MisProcessing' for key 'configuration_key'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:842)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:681)
at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInSta
tement(JdbcExecutor.java:92)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
... 9 more
INFO 11/9/12 11:40 PM:liquibase: Successfully released change log lock
Liquibase Update Failed: Error executing SQL Insert into config_key_value
(configuration_type,configuration_key,
configuration_value) values
(1,'MisProcessing','01/01/2012'): Duplicate entry 'MisPr
ocessing' for key 'configuration_key'
SEVERE 11/9/12 11:40 PM:liquibase: Error executing SQL Insert into config_key_va
lue
(configuration_type,configuration_key,
configuration_value) values
(1,'MisProcessing','01/01/2012'): Duplicate entry 'MisPr
ocessing' for key 'configuration_key'
liquibase.exception.MigrationFailedException: Migration failed for change set ch
angesets/changelog-Release_J.xml::MIFOSACC::Hugo Technologies:
Reason: liquibase.exception.DatabaseException: Error executing SQL Insert i
nto config_key_value
(configuration_type,configuration_key,
configuration_value) values
(1,'MisProcessing','01/01/2012'): Duplicate entry 'MisPr
ocessing' for key 'configuration_key':
Caused By: Error executing SQL Insert into config_key_value
(configuration_type,configuration_key,
configuration_value) values
(1,'MisProcessing','01/01/2012'): Duplicate entry 'MisPr
ocessing' for key 'configuration_key':
Caused By: Duplicate entry 'MisProcessing' for key 'configuration_key'
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27
)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
at liquibase.Liquibase.update(Liquibase.java:113)
at liquibase.integration.commandline.Main.doMigration(Main.java:779)
at liquibase.integration.commandline.Main.main(Main.java:133)
Caused by: liquibase.exception.DatabaseException: Error executing SQL Insert int
o config_key_value
(configuration_type,configuration_key,
configuration_value) values
(1,'MisProcessing','01/01/2012'): Duplicate entry 'MisPr
ocessing' for key 'configuration_key'
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:107
5)
at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabas
e.java:1059)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
... 5 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationExce
ption: Duplicate entry 'MisProcessing' for key 'configuration_key'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:842)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:681)
at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInSta
tement(JdbcExecutor.java:92)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
... 9 more
For more information, use the --logLevel flag)
C:\mifos\mifos-v2.5.0\db\bin>
Regards,
Dale A. Fuertes-Pham
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_nov
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
