Bug #3454

PostgreSQL start failed during distro upgrade

Added by Davide Principi about 1 year ago. Updated 11 months ago.

Status:CLOSEDStart date:
Priority:NormalDue 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

Revision 52889d1b
Added by Davide Principi 11 months ago

Fix PostgreSQL startup error (#5)

Clean up the old DB data storage directory, as it is rebuilt during the
post-restore-data event.

Refs #3454

History

#1 Updated by Davide Principi about 1 year ago

Workaround

rm -rf /var/lib/pgsql/data/*
signal-event nethserver-postgresql-update

#2 Updated by Davide Principi 11 months ago

  • Status changed from TRIAGED to MODIFIED
  • % Done changed from 20 to 60

#3 Updated by Davide Principi 11 months 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 11 months ago

  • Assignee set to Luca Gasparini

#5 Updated by Luca Gasparini 11 months 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 11 months 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

Also available in: Atom PDF