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 <mor...@dhis2.org> 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.hedb...@gmail.com> > 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 <bobjolli...@gmail.com> 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.hedb...@gmail.com> 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 >>> > >>> > Tel/fax (home): +27-21-685-6472 >>> > >>> > Cell: +27-82-853-5352 >>> > >>> > Iridium SatPhone: +8816-315-19119 >>> > >>> > Email: calle.hedb...@gmail.com >>> > >>> > Skype: calle_hedberg >>> > >>> > ******************************************* >>> > >>> > >>> > >>> > _______________________________________________ >>> > Mailing list: https://launchpad.net/~dhis2-devs >>> > Post to : dhis2-devs@lists.launchpad.net >>> > 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-19119 >> >> Email: calle.hedb...@gmail.com >> >> Skype: calle_hedberg >> >> ******************************************* >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-devs@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-devs@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp