dhis2-devs team mailing list archive

Thread
Date

[Bug 499164] Re: Report table fails to delete relative periods on H2

To: dhis2-devs@xxxxxxxxxxxxxxxxxxx
From: Lars Helge Øverland <larshelge@xxxxxxxxx>
Date: Fri, 19 Mar 2010 16:00:19 -0000
Reply-to: Bug 499164 <499164@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx

** Changed in: dhis2
    Milestone: 2.0.4 => 2.0.5

-- 
Report table fails to delete relative periods on H2
https://bugs.launchpad.net/bugs/499164
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.

Status in DHIS 2 - District Health Information Software: New

Bug description:
Report table fails to delete relative periods on H2 with the following message:

Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table PERIOD; SQL statement:
DELETE FROM period WHERE periodtypeid IN ( SELECT periodtypeid FROM periodtype WHERE periodtype.name = 'Relative' ); [50200-119]

References

[Bug 499164] [NEW] Report table fails to delete relative periods on H2
From: Lars Helge Øverland, 2009-12-21