Bug #3454
PostgreSQL start failed during distro upgrade
Status: | CLOSED | Start date: | ||
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | - | % Done: | 100% | |
Category: | nethserver-upgrade-tool | |||
Target version: | v6.10 | |||
Security class: | Resolution: | |||
Affected version: | v6.10 | NEEDINFO: | No |
Description
After the last reboot of the distro upgrade procedure the postgresql service fails to start
Oct 22 11:04:24 vm6 esmith::event[1760]: Action: /etc/e-smith/events/nethserver-postgresql-update/S00initialize-default-databases SUCCESS [2.266389] Oct 22 11:04:24 vm6 esmith::event[1760]: Action: /etc/e-smith/events/nethserver-postgresql-update/S02nethserver-postgresql-conf SUCCESS [0.046197] Oct 22 11:04:24 vm6 esmith::event[1760]: expanding /var/lib/pgsql/data/pg_hba.conf Oct 22 11:04:24 vm6 esmith::event[1760]: Action: /etc/e-smith/events/actions/generic_template_expand SUCCESS [0.208272] Oct 22 11:04:24 vm6 systemd: Reloading. Oct 22 11:04:25 vm6 systemd: Starting PostgreSQL database server... Oct 22 11:04:25 vm6 postgresql-check-db-dir: An old version of the database format was found. Oct 22 11:04:25 vm6 postgresql-check-db-dir: Use "postgresql-setup upgrade" to upgrade to version 9.2. Oct 22 11:04:25 vm6 postgresql-check-db-dir: See /usr/share/doc/postgresql-9.2.24/README.rpm-dist for more information. Oct 22 11:04:25 vm6 esmith::event[1760]: Job for postgresql.service failed because the control process exited with error code. See "systemctl status postgresql.service" and "journalctl -xe" for details. Oct 22 11:04:25 vm6 systemd: postgresql.service: control process exited, code=exited status=1 Oct 22 11:04:25 vm6 systemd: Failed to start PostgreSQL database server. Oct 22 11:04:25 vm6 systemd: Unit postgresql.service entered failed state. Oct 22 11:04:25 vm6 systemd: postgresql.service failed.
Steps to reproduce
- Install webtop4
- Run the upgrade to ns7 tool
Associated revisions
History
#1 Updated by Davide Principi almost 2 years ago
Workaround
rm -rf /var/lib/pgsql/data/* signal-event nethserver-postgresql-update
#2 Updated by Davide Principi over 1 year ago
- Status changed from TRIAGED to MODIFIED
- % Done changed from 20 to 60
#3 Updated by Davide Principi over 1 year ago
- Status changed from MODIFIED to ON_QA
- Assignee deleted (
Davide Principi) - % Done changed from 60 to 70
In nethserver-testing 6.10
- nethserver-upgrade-tool-1.1.2-1.1.g52889d1.ns6.x86_64.rpm
#4 Updated by Luca Gasparini over 1 year ago
- Assignee set to Luca Gasparini
#5 Updated by Luca Gasparini over 1 year ago
- Status changed from ON_QA to VERIFIED
- % Done changed from 70 to 90
Tested OK
After the last reboot the postgresql service runs regularly.
#6 Updated by Davide Principi over 1 year ago
- Status changed from VERIFIED to CLOSED
- Assignee deleted (
Luca Gasparini) - % Done changed from 90 to 100
In nethserver-updates 6.10
- nethserver-upgrade-tool-1.1.3-1.ns6.x86_64.rpm