dhis2-devs team mailing list archive

[Morten Olav Hansen <mortenoh@xxxxxxxxx>]

That's a really big database... I think maybe Lars should answer if the
memory of the server is large enough (I'm sure he can compare it with what
he has been doing to tune the Kenya server).

--
Morten


On Tue, Sep 11, 2012 at 2:59 PM, Hannan Khan <hannank@xxxxxxxxx> wrote:

> Hi Morten
>
> Server have 8GB memory and database is 3159MB. We are using MySQL.
>
> Regards
>
> Hannan
>
>
> On Tue, Sep 11, 2012 at 1:53 PM, Morten Olav Hansen <mortenoh@xxxxxxxxx>wrote:
>
>> Hi
>>
>> How much memory does your server have? and what is the size of your
>> database?
>>
>> --
>> Morten
>>
>>
>>
>> On Tue, Sep 11, 2012 at 2:51 PM, Hannan Khan <hannank@xxxxxxxxx> wrote:
>>
>>> -XX:MaxPermSize=2048m and -XX:PermSize=512m
>>>
>>>
>>> On Tue, Sep 11, 2012 at 11:27 AM, Jason Pickering <
>>> jason.p.pickering@xxxxxxxxx> wrote:
>>>
>>>> The PergGen space is the important option.  What are you JAVA_OPTS.?
>>>>
>>>> --
>>>> Sent from my mobile
>>>> On Sep 11, 2012 7:25 AM, "Hannan Khan" <hannank@xxxxxxxxx> wrote:
>>>>
>>>>> Thanks Jason.
>>>>>
>>>>> I put the Java heap space 1GB and Maximum 6GB (Xmx6144m and Xms1024m).
>>>>> But still getting 'java.lang.OutOfMemoryError: Java heap space' error. That
>>>>> why I asked that whether that is a bug or not.
>>>>>
>>>>> I am trying to other options and contact you soon.
>>>>>
>>>>> Regards
>>>>>
>>>>> Hannan
>>>>>
>>>>> On Mon, Sep 10, 2012 at 11:40 AM, Jason Pickering <
>>>>> jason.p.pickering@xxxxxxxxx> wrote:
>>>>>
>>>>>> Hi Hannan,
>>>>>>
>>>>>> You configuration may have worked previously, but some things were
>>>>>> changed in the datamart and you will need to allocate more memory to
>>>>>> it after 2.7.
>>>>>>
>>>>>> The details are here of the server setup are here
>>>>>>
>>>>>> http://dhis2.org/doc/snapshot/en/implementer/html/ch08.html#d5e413
>>>>>>
>>>>>> and the important part is the JAVA_OPTS environment variable, for
>>>>>> instance...
>>>>>>
>>>>>> export JAVA_OPTS='-Xmx6000m -Xms3000m -XX:MaxPermSize=800m
>>>>>> -XX:PermSize=400m'
>>>>>>
>>>>>> I am not really sure what your settings are, but you should at least
>>>>>> specify these options, of course adjusting them for the amount of
>>>>>> memory which can be allocated to DHIS2 .
>>>>>>
>>>>>> Best regards,
>>>>>> Jason
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Mon, Sep 10, 2012 at 10:49 AM, Hannan Khan <hannank@xxxxxxxxx>
>>>>>> wrote:
>>>>>> > Dear Jason
>>>>>> >
>>>>>> > Thanks for your advice. We are running dhis2 from 2010. In earlier
>>>>>> version
>>>>>> > we dont have any problem creating datamart. After updating to
>>>>>> version 2.7 we
>>>>>> > imported a big chuck of data from two data souce and after that we
>>>>>> have
>>>>>> > problem creating datamart.
>>>>>> >
>>>>>> > So far I know the configuration is ok, however I will check again
>>>>>> and get
>>>>>> > back to you.
>>>>>> >
>>>>>> > Regards
>>>>>> >
>>>>>> > Hannan
>>>>>> > from Samsung Galaxy
>>>>>> >
>>>>>> > On Sep 9, 2012 5:39 PM, "Jason Pickering" <
>>>>>> jason.p.pickering@xxxxxxxxx>
>>>>>> > wrote:
>>>>>> >>
>>>>>> >> This is not a bug. You must increase the heap size. Please consult
>>>>>> the
>>>>>> >> implementation manual for details.
>>>>>> >>
>>>>>> >> Regards,
>>>>>> >> Jason
>>>>>> >>
>>>>>> >> --
>>>>>> >> Sent from my mobile
>>>>>> >>
>>>>>> >> On Sep 9, 2012 1:12 PM, "Hannan Khan" <hannank@xxxxxxxxx> wrote:
>>>>>> >>>
>>>>>> >>> We are using dhis2 version 2.7. Whenever we generating datamart
>>>>>> are it
>>>>>> >>> taking long time and it never ends.The error message is (in the
>>>>>> tomcat log
>>>>>> >>> file)
>>>>>> >>>
>>>>>> 'dhis2-org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor
>>>>>> >>> processChildren SEVERE: Exception invoking periodic operation:
>>>>>> >>> java.lang.OutOfMemoryError: Java heap space'.
>>>>>> >>>
>>>>>> >>> I attached the log file.
>>>>>> >>>
>>>>>> >>> Regards
>>>>>> >>>
>>>>>> >>> Hannan Khan
>>>>>> >>>
>>>>>> >>> National Data Warehouse
>>>>>> >>>
>>>>>> >>>
>>>>>> >>>
>>>>>> >>>
>>>>>> >>> _______________________________________________
>>>>>> >>> 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
>>>
>>>
>>
>