Package upgrades should run DB update in postinst script

[matomo-org]

Package upgrades should run DB update in postinst script

[aureq]

hi @jnachtigall

Thank you for the suggestion. Though, I slightly disagree on this, but allow me to explain.

Updating the database may not be a good idea if the sysadmin is not fully aware of all the risks.

• High CPU usage if the database is big and potential side effects on database cluster
• Possible corruption (happened to me) and no way to revert back

Though, I do see your point and the needs behind your ticket. I will try to implement a package setting that will allow you to do this automatically if the package setting is enabled. I'll keep you updated as to what I'll be implementing.

[jnachtigall]

I will try to implement a package setting that will allow you to do this automatically if the package setting is enabled. I'll keep you updated as to what I'll be implementing.

👍 Good idea

[danielhjames]

One way to handle this is to use a debconf question such as:

Upgrade Piwik database automatically? yes/no

Sysadmins who prefer to upgrade their database manually will have their 'no' choice saved in the debconf database for future upgrades. See http://www.fifi.org/doc/debconf-doc/tutorial.html

[jnachtigall]

Any news on this? I again had a piwik downtime due to the recent package upgrade

[jnachtigall]

For the upcoming 2.13 (security fix) there will be a db upgrade again. Hope you can fix this issue until then...

[aureq]

@jnachtigall No, I haven't forgotten you, at all. I've already prepared 2.13.0, but I need to test it to ensure it's all good. When this is done, I'll then implement that feature (I need it to).
It will come as a debconf "pin" that will allow the automatic db upgrade to happen.

[aureq]

@jnachtigall I finished the implementation. Let me know how it goes for you please.
Please note that you need to enable the automatic upgrade the first time either through the command line or apt-get. (piwik/automatic-upgrade => true)

[jnachtigall]

@aureq Works great, thank you 👍