dhis2-devs team mailing list archive

[Morten Olav Hansen <morten@xxxxxxxxx>]

Ok, thanks Stian (no need to work on this then Viet)

(knut, using pg_dump we normally filter away analytic* which means no
period boundaries..)

-- 
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org

On Thu, Jul 12, 2018 at 6:14 PM, Stian Sandvold <stian@xxxxxxxxx> wrote:

> I have started the work on renaming the table. I will update this thread
> as soon as I make progress.
>
> On Thu, Jul 12, 2018 at 12:17 PM, Morten Olav Hansen <morten@xxxxxxxxx>
> wrote:
>
>> Hi Knut
>>
>> I mean the main issue the thread was about... using maintenance => clear
>> analytic tables, it will delete analytics* which includes the analytical
>> boundaries.
>>
>>
>> --
>> Morten Olav Hansen
>> Senior Engineer, DHIS 2
>> University of Oslo
>> http://www.dhis2.org
>>
>> On Thu, Jul 12, 2018 at 5:11 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
>>
>>> Hi Morten, sorry but which functionality are you suggesting should not
>>> be used? What do you mean by manually deleting?
>>>
>>> Thanks,
>>> Knut
>>>
>>> On Thu, Jul 12, 2018, 4:23 PM Morten Olav Hansen <morten@xxxxxxxxx>
>>> wrote:
>>>
>>>> Hi Calle
>>>>
>>>> We are aware of this issue (actually it caused a problem with us in
>>>> Lao), for now.. I would also say don't use this functionality, its better
>>>> to manually delete the analytics_* tables if you need it. We will rename
>>>> that table soon we hope, and that should fix it (this also causes potential
>>>> issues with your backups...)
>>>>
>>>>
>>>> --
>>>> Morten Olav Hansen
>>>> Senior Engineer, DHIS 2
>>>> University of Oslo
>>>> http://www.dhis2.org
>>>>
>>>> On Thu, Jul 12, 2018 at 3:58 PM, Calle Hedberg <calle.hedberg@xxxxxxxxx
>>>> > wrote:
>>>>
>>>>> Bob,
>>>>>
>>>>> No response/action on the JIRA bug report yet - I guess most
>>>>> developers are on leave (wonderful summer here in Norway this year).
>>>>>
>>>>> Otherwise I agree, the name of that table does not fit the general
>>>>> naming convention as far as I can see. It would make more sense to call it
>>>>> e.g. "programindicator_periodboundary". The name then provides an
>>>>> intuitive description of the content and it sorts together with the group
>>>>> of programindicator tables.
>>>>>
>>>>> Regards
>>>>> calle
>>>>>
>>>>> On 12 July 2018 at 08:57, Bob Jolliffe <bobjolliffe@xxxxxxxxx> wrote:
>>>>>
>>>>>> Thats nasty alright.  I guess using "-T anlytics_*" instead would
>>>>>> help.  But there are so many backup scripts out there broken by this
>>>>>> that it will be better to rename the table.
>>>>>>
>>>>>> On 11 July 2018 at 22:39, Calle Hedberg <calle.hedberg@xxxxxxxxx>
>>>>>> wrote:
>>>>>> > Hi
>>>>>> >
>>>>>> > For as long as I can remember, we have used the standard parameter
>>>>>> "-T
>>>>>> > analytics*" when dumping a DHIS2 database into e.g. a backup or
>>>>>> similar.
>>>>>> >
>>>>>> > The purpose of the parameter was to exclude all analytics tables
>>>>>> from the
>>>>>> > dump, since it is significantly faster to restore a dump without
>>>>>> analytics
>>>>>> > tables and then run analytics to re-create them (due to the use of
>>>>>> > multi-threading), compared to dumping and restoring a database
>>>>>> instance with
>>>>>> > all the analytics table (restore is NOT using multi-threading).
>>>>>> >
>>>>>> > For some reason, in 2.29 a new table that stores periodboundary
>>>>>> data for
>>>>>> > Program Indicators was called "analyticsperiodboundary" - which
>>>>>> means the
>>>>>> > standard pg_dump parameter will leave that table behind together
>>>>>> with all
>>>>>> > other "analytics*" tables.
>>>>>> >
>>>>>> > Furthermore, the routine called "Clear Analytics Tables" found
>>>>>> under Data
>>>>>> > Administration -> Maintenance is as before deleting all tables named
>>>>>> > Analytics* - THE PROBLEM IS THAT IT ALSO DELETES THE NEW
>>>>>> > ANALYTICSPERIODBOUNDARY TABLE (same in both 2.29 and 2.30)
>>>>>> >
>>>>>> > Which will crash your system in the sense that you won't see any
>>>>>> program
>>>>>> > indicator data in dashboards etc.
>>>>>> >
>>>>>> > The "analyticsperiodboundary" table will be re-created and
>>>>>> re-populated with
>>>>>> > DEFAULT (boundless) Program Indicator Period boundaries when you
>>>>>> re-start
>>>>>> > the system (it's part of the TableAlteror routine during startup),
>>>>>> but
>>>>>> > - you have to re-start the system
>>>>>> > - you will lose any non-default boundary settings used for any
>>>>>> program
>>>>>> > indicator.
>>>>>> >
>>>>>> > This has also been reported as a high-priority bug on JIRA
>>>>>> (DHIS2-4260).
>>>>>> >
>>>>>> > Regards
>>>>>> > Calle
>>>>>> >
>>>>>> > *******************************************
>>>>>> >
>>>>>> > Calle Hedberg
>>>>>> >
>>>>>> > 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>>>>>> <https://maps.google.com/?q=46D+Alma+Road,+7700+Rosebank,+SOUTH+AFRICA&entry=gmail&source=g>
>>>>>> >
>>>>>> > Tel/fax (home): +27-21-685-6472
>>>>>> >
>>>>>> > Cell: +27-82-853-5352
>>>>>> >
>>>>>> > Iridium SatPhone: +8816-315-19119
>>>>>> >
>>>>>> > 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
>>>>>> >
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>> *******************************************
>>>>>
>>>>> Calle Hedberg
>>>>>
>>>>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>>>>> <https://maps.google.com/?q=46D+Alma+Road,+7700+Rosebank,+SOUTH+AFRICA&entry=gmail&source=g>
>>>>>
>>>>> Tel/fax (home): +27-21-685-6472
>>>>>
>>>>> Cell: +27-82-853-5352
>>>>>
>>>>> Iridium SatPhone: +8816-315-19119
>>>>>
>>>>> 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
>>>>>
>>>>>
>>>> _______________________________________________
>>>> 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
>>
>>
>
>
> --
> Stian Sandvold
> Software developer, DHIS2
> University of Oslo
> http://www.dhis2.org
>