← Back to team overview

dhis2-devs team mailing list archive

Re: Weird cache issue

 

Hi Calle,
It is very difficult to say much without knowing what SQL it was you
executed. In general, use of the API or UI is usually much safer.

Do you have any sort of cache in front of your DHIS2 instance?

Can you confirm from the database that the names were actually changed?

Regards,
Jason


On Tue, Sep 1, 2015 at 12:49 PM, Calle Hedberg <calle.hedberg@xxxxxxxxx>
wrote:

> Lars,
>
> Nope - all data set names and short names are the same.
>
> It's just weird, and I don't like inexplicable things happening to a
> database....
>
> When you run data integrity - WHERE are those queries fetching data from?
> Are the integrity queries running against the database itself, or some kind
> of cache repository?
>
> Regards
> Calle
>
> On 1 September 2015 at 13:00, Lars Helge Øverland <larshelge@xxxxxxxxx>
> wrote:
>
>> Hi Calle,
>>
>> perhaps you did not update the data set short names?
>>
>> Lars
>>
>> On Tue, Sep 1, 2015 at 11:50 AM, Calle Hedberg <calle.hedberg@xxxxxxxxx>
>> wrote:
>>
>>> Hi
>>>
>>> I've got a baffling problem (presumably related to some kind of caching):
>>>
>>> 1. yesterday I updated various data records using pgremote, including
>>> data set names. We restarted tomcat after the updates.
>>>
>>> 2. I've also cleared my browser cache, the DHIS2 cache, updated resource
>>> tables, etc.
>>>
>>> 3. When I now open the list of data sets, all the changed/new names are
>>> showing as expected.
>>>
>>> 4. BUT when I run Data Integrity, a few violations related to data sets
>>> are coming up AND THE DATA SET NAMES ARE THE OLD ONES.
>>>
>>> Any ideas what could cause this weird behaviour?
>>>
>>> Regards
>>> Calle
>>>
>>> *******************************************
>>>
>>> Calle Hedberg
>>>
>>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>>>
>>> Tel/fax (home): +27-21-685-6472
>>>
>>> Cell: +27-82-853-5352
>>>
>>> Iridium SatPhone: +8816-315-19274
>>>
>>> Email: calle.hedberg@xxxxxxxxx
>>>
>>> Skype: calle_hedberg
>>>
>>> *******************************************
>>>
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> http://www.dhis2.org <https://www.dhis2.org>
>>
>>
>
>
> --
>
> *******************************************
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19274
>
> Email: calle.hedberg@xxxxxxxxx
>
> Skype: calle_hedberg
>
> *******************************************
>
>
> _______________________________________________
> 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
>
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049

Follow ups

References