Not sure if it is related really, but for MySql are you using MyIsam or InnoDB? I think DHIS2 requires InnoDB?
2010/5/4 Lars Helge Øverland <[email protected]>: > > > On Sun, May 2, 2010 at 5:30 PM, Friedman, Roger (CDC/OID/NCHHSTP) (CTR) > <[email protected]> wrote: >> >> Using 2.0.3, attempting to create all four resource files, received the >> following error: >> >> * ERROR 11:04:26,812 Error while executing action >> (ExceptionInterceptor.java [http-8080-1]) >> >> java.lang.RuntimeException: Failed to add objects >> >> at >> org.amplecode.quick.batchhandler.AbstractBatchHandler.addObject(AbstractBatchHandler.java:195) >> >> at >> org.hisp.dhis.resourcetable.DefaultResourceTableService.generateOrganisationUnitStructures(DefaultResourceTableService.java:162) >> >> ...SNIP... >> >> Caused by: java.sql.SQLException: Lock wait timeout exceeded; try >> restarting transaction >> >> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) >> >> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) >> >> ... 93 more >> >> At this point, orgunitstructure is empty; orgunitgroupsetstructure appears >> to be fully built; orgunitgroupsetexclusivestructure has orgunitids but no >> exclusive groups; categoryoptioncomboname contains only id 1 default. >> >> Seems like it might be a MySQL setting issue, any suggestions? >> >> Thanks, Roger >> >> > > Yes looks like a Mysql issue. I am testing on postgres on a daily basis, > will install mysql and investigate further. > Lars > > >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- Cheers, Knut Staring _______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
