← Back to team overview

dhis2-users team mailing list archive

Re: Error while running analytics in 2.29

 

Kumar,
Any update?

On Tue, Jun 5, 2018 at 9:14 AM, gerald thomas <gerald17006@xxxxxxxxx> wrote:

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



-- 
Regards,

Gerald

PNG image


Follow ups

References