dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

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 <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
>>
>
>
> _______________________________________________
> 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
>
>



-- 
Cheers,
Knut Staring