← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] Timeout when updating large organisation unit group in large instance (2.23)

 

If you are willing to do manual import (using the command line), in 223 you
can use /api/23/metadata I think... it will use the "new" importer.. which
should be quicker, please be aware that 223 is not supported anymore, so
please update ASAP if you can..

-- 
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org

On Tue, Aug 29, 2017 at 1:09 AM, Martin Van Aken <martin@xxxxxxxxxxxxxxxx>
wrote:

> Hi Morten,
> This is on 2.23 - I tried to manipulate big groups on the play demo
> instance and it goes well there.
>
> I'll try to get some logs.
>
> Martin
>
> On Mon, Aug 28, 2017 at 5:27 PM, Morten Olav Hansen <morten@xxxxxxxxx>
> wrote:
>
>> Hi Martin
>>
>> What version of DHIS2 are you on? if you are on 227 there is currently a
>> bug that has lowered performance in 227 vs the older versions (226, 225,
>> etc..)
>>
>> If you are not, if you could.. please file a JIRA issue and either attach
>> the org units, or email me directly
>>
>> --
>> Morten Olav Hansen
>> Senior Engineer, DHIS 2
>> University of Oslo
>> http://www.dhis2.org
>>
>> On Mon, Aug 28, 2017 at 10:14 PM, Martin Van Aken <
>> martin@xxxxxxxxxxxxxxxx> wrote:
>>
>>> Hello Joseph,
>>> Thanks for the feedback. I'll try rh
>>>
>>> On Mon, Aug 28, 2017 at 5:13 PM, Joseph K. Osborn <
>>> osbornlegrand@xxxxxxxxxx> wrote:
>>>
>>>> Hello Martin,
>>>>
>>>> We had this problem with 2.22 or 2.23, the solution was to perform
>>>> these updates during off-peak hours, times when the server was not too
>>>> busy, so after 10pm, and it worked.
>>>>
>>>> But with 2.26 which has improved the analytic time and executions of
>>>> several queries, we do our updates even during the day.
>>>>
>>>> Regards.
>>>>
>>>>
>>>> Osborn
>>>> ------------------------------
>>>> *De :* Dhis2-devs <dhis2-devs-bounces+osbornlegrand=
>>>> hotmail.fr@xxxxxxxxxxxxxxxxxxx> de la part de Martin Van Aken <
>>>> martin@xxxxxxxxxxxxxxxx>
>>>> *Envoyé :* lundi 28 août 2017 15:34:53
>>>> *À :* Michael Mwebaze
>>>> *Cc :* dhis2-users; DHIS 2 Developers list
>>>> *Objet :* Re: [Dhis2-devs] [Dhis2-users] Timeout when updating large
>>>> organisation unit group in large instance (2.23)
>>>>
>>>> Got nothing until now but I'm investigating in that direction right
>>>> now.
>>>>
>>>> Thanks already for the pointer!
>>>>
>>>> Martin
>>>>
>>>> On Mon, Aug 28, 2017 at 4:12 PM, Michael Mwebaze <
>>>> michael.mwebaze@xxxxxxxxx> wrote:
>>>>
>>>>> Hi Martin,
>>>>>
>>>>> do you have access to the Tomcat logs? If an exception is being thrown
>>>>> that would also be helpful to figure out what is happening.
>>>>>
>>>>> Regards,
>>>>>
>>>>> Michael
>>>>>
>>>>> On 28 August 2017 at 10:04, Martin Van Aken <martin@xxxxxxxxxxxxxxxx>
>>>>> wrote:
>>>>>
>>>>>> Hi DHIS2 users & developers,
>>>>>> We have a relatively large instance of DHIS2 (30 000 org units) where
>>>>>> we have several groups that can make up to 3 000 org unit each.
>>>>>>
>>>>>> When trying to update them through the UX, our server get a timeout
>>>>>> (looking in the console for the network calls).
>>>>>>
>>>>>> The call is like this:
>>>>>>
>>>>>> /api/organisationUnitGroups/RZYPaa6gxq8?mergeMode=REPLACE
>>>>>>
>>>>>> When using the API, we get no problem but we typically add/remove
>>>>>> relations one by one (so the call is very different).
>>>>>>
>>>>>>  I tested on the last version on play and everything is working
>>>>>> there, but the version is quite different too.
>>>>>>
>>>>>> Is this something someone encountered already? Anything we could do
>>>>>> to avoid this ?
>>>>>>
>>>>>> Thanks,
>>>>>>
>>>>>> Martin
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> *Martin Van Aken - **Freelance Enthusiast Developer*
>>>>>>
>>>>>> Mobile : +32 486 899 652
>>>>>>
>>>>>> Follow me on Twitter : @martinvanaken
>>>>>> <http://twitter.com/martinvanaken>
>>>>>> Call me on Skype : vanakenm
>>>>>> Hang out with me : martin@xxxxxxxxxxxxxxxx
>>>>>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
>>>>>> Company website : www.joyouscoding.com
>>>>>>
>>>>>> _______________________________________________
>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> *Martin Van Aken - **Freelance Enthusiast Developer*
>>>>
>>>> Mobile : +32 486 899 652
>>>>
>>>> Follow me on Twitter : @martinvanaken
>>>> <http://twitter.com/martinvanaken>
>>>> Call me on Skype : vanakenm
>>>> Hang out with me : martin@xxxxxxxxxxxxxxxx
>>>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
>>>> Company website : www.joyouscoding.com
>>>>
>>>
>>>
>>>
>>> --
>>> *Martin Van Aken - **Freelance Enthusiast Developer*
>>>
>>> Mobile : +32 486 899 652
>>>
>>> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken>
>>> Call me on Skype : vanakenm
>>> Hang out with me : martin@xxxxxxxxxxxxxxxx
>>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
>>> Company website : www.joyouscoding.com
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>
>
> --
> *Martin Van Aken - **Freelance Enthusiast Developer*
>
> Mobile : +32 486 899 652
>
> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken>
> Call me on Skype : vanakenm
> Hang out with me : martin@xxxxxxxxxxxxxxxx
> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
> Company website : www.joyouscoding.com
>

Follow ups

References