Hi Calle, I meant "Private mode", https://www.google.no/search?q=chrome+incognito+mode
Or Chrome on another machine. Or Firefox. Just to ascertain whether it is indeed related to browser caching. Knut On Wed, Sep 2, 2015 at 1:02 PM, Calle Hedberg <[email protected]> wrote: > Knut, > > No, I didn't try another browser - we are trying to standardise on chrome > for DHIS2. Remember that this is not some kind of "crisis" issue where we > are stuck with something per se - I'm just trying to track down the root > cause of (several) seemingly cache-related issues we have encountered. > > I don't know anything about "incognito mode", I'm afraid. So I obviously > did not try that... > > Regards > Calle > > On 2 September 2015 at 13:58, Knut Staring <[email protected]> wrote: > >> Probably a stupid question, but did you try incognito mode or another >> browser? >> >> On Wed, Sep 2, 2015 at 12:44 PM, Calle Hedberg <[email protected]> >> wrote: >> >>> Halvdan, >>> >>> Noted, thanks for clarification - and yes, this issue is not related to >>> that (I'm still 98% sure it's somehow related to caching, I just don't know >>> how - my reason for pursuing this is obviously that since we are regularly >>> updating databases directly or via the web api, we want to be sure that all >>> cache refreshing is working and thus ensure that such updates are pushed to >>> users immediately. >>> >>> Regards >>> Calle >>> >>> On 2 September 2015 at 13:35, Halvdan Grelland <[email protected]> >>> wrote: >>> >>>> Ok. I'm sorry the api query was lacking a parameter (should be >>>> api/dataSet.json&fields=name,shortName,displayName) to show all the fields. >>>> DisplayNames are generated (i.e. they're either the translation if one >>>> exists or they're simply the name). If you're not using translations that's >>>> obviously a dead end though. >>>> >>>> 2015-09-02 12:21 GMT+02:00 Calle Hedberg <[email protected]>: >>>> >>>>> Halvdan, >>>>> >>>>> We do not use translations for any South African instance - all >>>>> English (i.e. the translation table has 0 rows) >>>>> >>>>> We are using either 2.19 or 2.20 (mostly 2.19) - actually a slightly >>>>> modified version of 2.19 in most cases. That version contains additional >>>>> code related to DHIS 1.4->DHIS2 conversions etc, but none of that code is >>>>> in any way linked to this problem. >>>>> >>>>> <instance>/api/dataSets gives the result below, or in other words it >>>>> only show names - and all those names are the correct/updated ones. >>>>> >>>>> I'm not sure where "displayNames" would be coming from - I am not >>>>> aware that data sets HAVE a field called "displayName" or similar. In >>>>> which >>>>> table can I find that? >>>>> >>>>> Regards >>>>> >>>>> On 2 September 2015 at 13:05, Halvdan Grelland <[email protected]> >>>>> wrote: >>>>> >>>>>> Could you go to <instance>/api/dataSets and confirm that the names, >>>>>> shortNames and displayNames are correct? The names displayed should be >>>>>> the >>>>>> displayNames; which reminds me: do you have translations for the given >>>>>> dataSets/current locale? If you do they will be displayed, and they will >>>>>> not have been updated. >>>>>> >>>>>> Q: >>>>>> Is the problem true for all objects in the integrity checks, or just >>>>>> DataSets? What about DataElements? >>>>>> >>>>>> Q: >>>>>> Also, what version are you on? >>>>>> >>>>>> Try running ... >>>>>> select * from translation where objectclass like '%DataSet%'; >>>>>> ...and inspect the results (might be a large query if you have a lot >>>>>> of dataSets). >>>>>> >>>>>> Also find the uid of one of the affected DataSets and try to run: >>>>>> select * from translation where objectuid like '<insert uid of object >>>>>> here>'; >>>>>> .. any hints there? >>>>>> >>>>>> 2015-09-02 10:40 GMT+02:00 Calle Hedberg <[email protected]>: >>>>>> >>>>>>> Jason, >>>>>>> >>>>>>> 1. Yes >>>>>>> 2. Yes, I changed both name and shortname (identical) - but I do >>>>>>> not know if the Data Integrity checks display name or short name >>>>>>> (settings >>>>>>> = short name for that instance). >>>>>>> 3. We are not using any caching proxy >>>>>>> >>>>>>> We did restart Tomcat - which should clear the server cache (?) - >>>>>>> and I did clear all my local caches. >>>>>>> >>>>>>> BUT we had some other strange behaviour with regard to dashboard >>>>>>> privileges yesterday, and it was seemingly fixed by clearing the DHIS2 >>>>>>> cache MULTIPLE times (not sure how many, but I only cleared the cache >>>>>>> one >>>>>>> time...) >>>>>>> >>>>>>> Regards >>>>>>> Calle >>>>>>> >>>>>>> On 2 September 2015 at 10:10, Jason Pickering < >>>>>>> [email protected]> wrote: >>>>>>> >>>>>>>> So, coming back to Lars's point. >>>>>>>> >>>>>>>> 1) Did you check the "dataset" table to confirm that your intended >>>>>>>> changes were persisted? >>>>>>>> >>>>>>>> 2) Did you alter the dataset "shortname" and is that the same which >>>>>>>> you are seeing in your integrity checks? >>>>>>>> >>>>>>>> 3) You indicated you cleared the DHIS 2 server cache. Can you >>>>>>>> confirm that you have no other upstream caching proxy which might be >>>>>>>> caching some response? >>>>>>>> >>>>>>>> The data integrity checks are a series of SQL (actually generated >>>>>>>> by Hibernate) queries, so as is usually the case, if you make direct >>>>>>>> database manipulations (and do not clear the server cache and possibly >>>>>>>> your >>>>>>>> local browser cache) you may see inconsistent results. For this type of >>>>>>>> operation, use of the UI is probably better, or alternative with the >>>>>>>> WebAPI. >>>>>>>> >>>>>>>> Regards, >>>>>>>> Jason >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Tue, Sep 1, 2015 at 11:57 PM, Calle Hedberg < >>>>>>>> [email protected]> wrote: >>>>>>>> >>>>>>>>> Halvdan, >>>>>>>>> >>>>>>>>> Ah, OK, and not - I was not using any queries, I simply updated >>>>>>>>> the Data Set names directly in the table. >>>>>>>>> >>>>>>>>> As I've said - the weird thing is that all those new names >>>>>>>>> immediately showed up in the UI data set list, but the old names are >>>>>>>>> still >>>>>>>>> appearing wherever the Data Integrity process throws up integrity >>>>>>>>> violations >>>>>>>>> >>>>>>>>> Regards >>>>>>>>> Calle >>>>>>>>> >>>>>>>>> On 1 September 2015 at 18:01, Halvdan Grelland < >>>>>>>>> [email protected]> wrote: >>>>>>>>> >>>>>>>>>> Calle, I'm pretty sure Jason was referring to whatever you were >>>>>>>>>> doing to update the records (your point #1 in original email) which >>>>>>>>>> was >>>>>>>>>> not, as far as I can understand, using the UI or the web-api. I am >>>>>>>>>> not >>>>>>>>>> familiar with "pgremote" but am assuming it's some kind of postgres >>>>>>>>>> connector allowing you to run (sql) queries. We'd need to see those >>>>>>>>>> queries >>>>>>>>>> in order to figure out what could have gone wrong. >>>>>>>>>> >>>>>>>>>> 2015-09-01 14:50 GMT+02:00 Calle Hedberg <[email protected] >>>>>>>>>> >: >>>>>>>>>> >>>>>>>>>>> Jason >>>>>>>>>>> >>>>>>>>>>> I was not executing any custom sql - I'm running the Data >>>>>>>>>>> Administration -> Data Integrity process checks. >>>>>>>>>>> >>>>>>>>>>> My reference to the sql queries being run relates to my >>>>>>>>>>> ASSUMPTION that the Data Integrity checks are a series of SQL >>>>>>>>>>> queries - but >>>>>>>>>>> maybe not, maybe the integrity checks are a series of web api calls >>>>>>>>>>> followed by some kind of front-end processing? I just don't know, >>>>>>>>>>> and I'm >>>>>>>>>>> not a Java developer and I don't have the code base on my laptop so >>>>>>>>>>> I >>>>>>>>>>> cannot find out myself... >>>>>>>>>>> >>>>>>>>>>> Seems my initial post was not clear enough on this - apologies >>>>>>>>>>> for that. >>>>>>>>>>> >>>>>>>>>>> Regards >>>>>>>>>>> Calle >>>>>>>>>>> >>>>>>>>>>> On 1 September 2015 at 14:31, Jason Pickering < >>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>> >>>>>>>>>>>> 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 < >>>>>>>>>>>> [email protected]> 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 < >>>>>>>>>>>>> [email protected]> 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 < >>>>>>>>>>>>>> [email protected]> 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: [email protected] >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Skype: calle_hedberg >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> ******************************************* >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>>>>> Mailing list: https://launchpad.net/~dhis2-devs >>>>>>>>>>>>>>> Post to : [email protected] >>>>>>>>>>>>>>> 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: [email protected] >>>>>>>>>>>>> >>>>>>>>>>>>> Skype: calle_hedberg >>>>>>>>>>>>> >>>>>>>>>>>>> ******************************************* >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>>> Mailing list: https://launchpad.net/~dhis2-devs >>>>>>>>>>>>> Post to : [email protected] >>>>>>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>>>>>>>>>>> More help : https://help.launchpad.net/ListHelp >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>>> Jason P. Pickering >>>>>>>>>>>> email: [email protected] >>>>>>>>>>>> tel:+46764147049 >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> >>>>>>>>>>> ******************************************* >>>>>>>>>>> >>>>>>>>>>> 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: [email protected] >>>>>>>>>>> >>>>>>>>>>> Skype: calle_hedberg >>>>>>>>>>> >>>>>>>>>>> ******************************************* >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> _______________________________________________ >>>>>>>>>>> Mailing list: https://launchpad.net/~dhis2-devs >>>>>>>>>>> Post to : [email protected] >>>>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>>>>>>>>> More help : https://help.launchpad.net/ListHelp >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> >>>>>>>>> ******************************************* >>>>>>>>> >>>>>>>>> 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: [email protected] >>>>>>>>> >>>>>>>>> Skype: calle_hedberg >>>>>>>>> >>>>>>>>> ******************************************* >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Jason P. Pickering >>>>>>>> email: [email protected] >>>>>>>> tel:+46764147049 >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> >>>>>>> ******************************************* >>>>>>> >>>>>>> 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-19119 >>>>>>> >>>>>>> Email: [email protected] >>>>>>> >>>>>>> Skype: calle_hedberg >>>>>>> >>>>>>> ******************************************* >>>>>>> >>>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> >>>>> ******************************************* >>>>> >>>>> 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-19119 >>>>> >>>>> Email: [email protected] >>>>> >>>>> Skype: calle_hedberg >>>>> >>>>> ******************************************* >>>>> >>>>> >>>> >>> >>> >>> -- >>> >>> ******************************************* >>> >>> 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-19119 >>> >>> Email: [email protected] >>> >>> Skype: calle_hedberg >>> >>> ******************************************* >>> >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : [email protected] >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> >> -- >> Knut Staring >> Dept. of Informatics, University of Oslo >> Norway: +4791880522 >> Skype: knutstar >> http://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-19119 > > Email: [email protected] > > Skype: calle_hedberg > > ******************************************* > > -- Knut Staring Dept. of Informatics, University of Oslo Norway: +4791880522 Skype: knutstar http://dhis2.org
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
