dhis2-users team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

On Sun, May 2, 2010 at 5:30 PM, Friedman, Roger (CDC/OID/NCHHSTP) (CTR) <
rdf4@xxxxxxx> 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     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>