2019-04-19 18:14:23 |
Michael Kuhn |
bug |
|
|
added bug |
2019-04-19 19:03:51 |
Brian Murray |
ubuntu-release-upgrader (Ubuntu): importance |
Undecided |
High |
|
2019-04-19 19:03:51 |
Brian Murray |
ubuntu-release-upgrader (Ubuntu): status |
New |
Incomplete |
|
2019-04-19 19:20:07 |
Brian Murray |
attachment added |
|
bug-1825563-postgresql-prompt.png https://bugs.launchpad.net/ubuntu/+source/ubuntu-release-upgrader/+bug/1825563/+attachment/5257124/+files/bug-1825563-postgresql-prompt.png |
|
2019-04-19 19:49:52 |
Michael Kuhn |
attachment added |
|
apt-term.log https://bugs.launchpad.net/ubuntu/+source/ubuntu-release-upgrader/+bug/1825563/+attachment/5257125/+files/apt-term.log |
|
2019-04-19 22:23:34 |
Brian Murray |
ubuntu-release-upgrader (Ubuntu): status |
Incomplete |
In Progress |
|
2019-04-19 22:34:55 |
Brian Murray |
summary |
Upgrade to Ubuntu 19.04 removed PostgreSQL databases |
automatically removed packages includes postgresql-10 which can result in cluster dropping |
|
2019-04-19 22:35:02 |
Brian Murray |
ubuntu-release-upgrader (Ubuntu): assignee |
|
Brian Murray (brian-murray) |
|
2019-04-19 22:42:17 |
Brian Murray |
description |
While upgrading to Ubuntu 19.04, the release upgrader removed postgresql-10. To make matters worse, apt/dpkg did NOT ask whether the databases should be kept and simply removed all of them.
I believe this is due to removal_blacklist.cfg containing ^postgresql-.*[0-9]\.[0-9].*, which does not match newer releases such as postgresql-10 as it expects an X.Y version scheme. Something like ^postgresql-.*[0-9].* should probably be added in addition. |
[Impact]
Users who choose to autoremove packages can have postgresql-10 removed which during its purge will drop the cluster and its databases.
[Test Case]
On a cosmic system
1) install postgresql-10 and ubuntu-release-upgrader-core
2) create a test database using psql - create database junk;
3) fill that database with junk using pgbench e.g. pgbench -in -s10 junk
4) verify you have data in /var/lib/postgresql - du -sh /var/lib/postgresql/*
5) run do-release-upgrade
6) choose to automatically remove packages (watch postgresql-10 get removed)
7) observe you have no more data in /var/lib/postgresql
With the version of the release upgrader in -proposed postgresql-10 will not be removed, postgresql-11 will not be installed and you'll still have your data.
[Regression Potential]
The regex could be too generic and prevent some other packages from being removed so look at it closely.
While upgrading to Ubuntu 19.04, the release upgrader removed postgresql-10. To make matters worse, apt/dpkg did NOT ask whether the databases should be kept and simply removed all of them.
I believe this is due to removal_blacklist.cfg containing ^postgresql-.*[0-9]\.[0-9].*, which does not match newer releases such as postgresql-10 as it expects an X.Y version scheme. Something like ^postgresql-.*[0-9].* should probably be added in addition. |
|
2019-04-19 22:42:27 |
Brian Murray |
tags |
|
disco eoan |
|
2019-04-19 22:53:34 |
Steve Langasek |
ubuntu-release-upgrader (Ubuntu Disco): status |
New |
Fix Committed |
|
2019-04-19 22:53:36 |
Steve Langasek |
bug |
|
|
added subscriber Ubuntu Stable Release Updates Team |
2019-04-19 22:53:39 |
Steve Langasek |
bug |
|
|
added subscriber SRU Verification |
2019-04-19 22:53:42 |
Steve Langasek |
tags |
disco eoan |
disco eoan verification-needed verification-needed-disco |
|
2019-04-19 23:53:20 |
Launchpad Janitor |
ubuntu-release-upgrader (Ubuntu Disco): status |
Fix Committed |
Fix Released |
|
2019-04-21 01:42:37 |
Launchpad Janitor |
branch linked |
|
lp:~ubuntu-core-dev/ubuntu/disco/ubuntu-release-upgrader/disco |
|
2019-04-22 19:55:49 |
Launchpad Janitor |
branch linked |
|
lp:ubuntu-release-upgrader |
|
2019-05-03 18:51:58 |
Launchpad Janitor |
ubuntu-release-upgrader (Ubuntu): status |
In Progress |
Fix Released |
|