dhis2-devs team mailing list archive

[gerald thomas <gerald17006@xxxxxxxxx>]

Kumar,
Kindly change the following on your postgresql.conf:
shared_buffers = 2120 MB
effective_cache_size = 5300 MB

Then do:
sudo service postgres restart

And run analytics again

On Tue, Jun 5, 2018 at 8:58 AM, Kumar Shahdeo <gauravns@xxxxxxxxxxxxxxxx>
wrote:

> Yes, its 8 GB
>
> On Tue, Jun 5, 2018 at 2:13 PM, gerald thomas <gerald17006@xxxxxxxxx>
> wrote:
>
>> Kumar,
>> What is the RAM size of this server, Is it 8BG?
>>
>> On Tue, Jun 5, 2018 at 6:39 AM, Kumar Shahdeo <gauravns@xxxxxxxxxxxxxxxx>
>> wrote:
>>
>>> I am using Postgres 9.4 . Please find the attached postgres conf file
>>>
>>> On Tue, Jun 5, 2018 at 11:24 AM, gerald thomas <gerald17006@xxxxxxxxx>
>>> wrote:
>>>
>>>> Dear Kumar,
>>>> What version of Postgres are running? Normally, these errors occurs
>>>> when the postgres.conf is not configured properly based on the data size it
>>>> has to analyzed.
>>>> Please can you send your Postgres.conf file.
>>>>
>>>> On Tue, 5 Jun 2018 at 05:40, Kumar Shahdeo <gauravns@xxxxxxxxxxxxxxxx>
>>>> wrote:
>>>>
>>>>> Yes, I rebooted the server, but still I am getting the same issue
>>>>> while running analytics
>>>>>
>>>>> On Tue, Jun 5, 2018 at 10:52 AM, gerald thomas <gerald17006@xxxxxxxxx>
>>>>> wrote:
>>>>>
>>>>>> Dear Kumar,
>>>>>> Have you tried to reboot the server after upgrades and then run
>>>>>> analytics again?
>>>>>>
>>>>>> On Tue, 5 Jun 2018 at 04:49, Kumar Shahdeo <gauravns@xxxxxxxxxxxxxxxx>
>>>>>> wrote:
>>>>>>
>>>>>>> Hi DHIS users,
>>>>>>>
>>>>>>>
>>>>>>> I have migrated from DHIS 2.27 to DHIS 2.29. I used the upgrade
>>>>>>> script provided by DHIS to upgrade the db. I have tried both incremental
>>>>>>> upgrade (2.27->2.28->2.29) and skipping 2.28(2.27->2.29). In both the cases
>>>>>>> I am getting the same issue.
>>>>>>>
>>>>>>> I am not able to run analytics. Analytics fails with below
>>>>>>> error(captured in screenshot)
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> When I checked server logs. I got this exception :
>>>>>>>
>>>>>>> org.springframework.dao.DataIntegrityViolationException with error
>>>>>>> message ‘new row for relation "analytics_temp_2012" violates check
>>>>>>> constraint "analytics_temp_2012,_yearly_check”’
>>>>>>>
>>>>>>>
>>>>>>> Any suggestions on this will be highly appreciated.
>>>>>>>
>>>>>>> Regards
>>>>>>> --
>>>>>>> Kumar Gaurav Nath Shahdeo
>>>>>>> Developer
>>>>>>> Email gauravns@xxxxxxxxxxxxxxxx
>>>>>>> Telephone +91 9160688935 <+91+9160688935>
>>>>>>> [image: ThoughtWorks]
>>>>>>> <http://www.thoughtworks.com/?utm_campaign=kumar-gaurav%20nath%20shahdeo-signature&utm_medium=email&utm_source=thoughtworks-email-signature-generator>
>>>>>>> _______________________________________________
>>>>>>> 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
>>>>>>>
>>>>>> --
>>>>>> Regards,
>>>>>>
>>>>>> Gerald
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Kumar Gaurav Nath Shahdeo
>>>>> Developer
>>>>> Email gauravns@xxxxxxxxxxxxxxxx
>>>>> Telephone +91 9160688935 <+91+9160688935>
>>>>> [image: ThoughtWorks]
>>>>> <http://www.thoughtworks.com/?utm_campaign=kumar-gaurav%20nath%20shahdeo-signature&utm_medium=email&utm_source=thoughtworks-email-signature-generator>
>>>>>
>>>> --
>>>> Regards,
>>>>
>>>> Gerald
>>>>
>>>
>>>
>>>
>>> --
>>> Kumar Gaurav Nath Shahdeo
>>> Developer
>>> Email gauravns@xxxxxxxxxxxxxxxx
>>> Telephone +91 9160688935 <+91+9160688935>
>>> [image: ThoughtWorks]
>>> <http://www.thoughtworks.com/?utm_campaign=kumar-gaurav%20nath%20shahdeo-signature&utm_medium=email&utm_source=thoughtworks-email-signature-generator>
>>>
>>
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>
>
>
> --
> Kumar Gaurav Nath Shahdeo
> Developer
> Email gauravns@xxxxxxxxxxxxxxxx
> Telephone +91 9160688935 <+91+9160688935>
> [image: ThoughtWorks]
> <http://www.thoughtworks.com/?utm_campaign=kumar-gaurav%20nath%20shahdeo-signature&utm_medium=email&utm_source=thoughtworks-email-signature-generator>
>



-- 
Regards,

Gerald