From: Ianseeks <bingmybong@btinternet.com>
To: pgsql-novice@lists.postgresql.org
Subject: fail to run postgresql16 after update from postgresql13
Date: Thu, 02 Nov 2023 08:14:03 +0000
Message-ID: <4842483.GXAFRqVoOG@lian-li>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="iso-8859-1"
Archived-At: 
 <https://www.postgresql.org/message-id/4842483.GXAFRqVoOG%40lian-li>
Precedence: bulk

Hi

i hope i've got the correct mailing list for this question/problem.  I'm a=
=20
novice.

A little history.=20
I use opensuse tumbleweed and the Kmail/Kontact PIM software which is=20
contrlled by software called Akondai and this requires a DB.  The default w=
as=20
Mysql but it caused a lot of reliability issues for me so i migrated to=20
Postgresql 9.6 (yes, it was a few years ago)

I've since then update the DB to 10, 11, 12 until ver 13 which i=20
have been using until now.  I  did try updating to ver 14 but it failed wit=
h=20
locale issues during the update and i couldn't get a resolution.

I just recently managed to get the database converted from postgresql13 to=
=20
postgresql16 and the data was transferred to the new DB with no issues.=20

I can't get Akonadi to load as it fails to start postgresql16, its failing=
=20
with a message saying it needs postgesql9.6 as the DB was originally create=
d=20
using 9.6. I can't see why it insists on ver 9.6 being there as i've update=
d=20
to ver 16 and that process means i create an empty DB.  I can't even instal=
l=20
Ver 9.6 to see if that cures the problem as its no longer in the opensuse=20
repos.

Thanks for any help.

=2D------------- the section below list processes and the errors ----------

I update the DB manually via scripts with one file per action.
1. Backup
# stop akonadi
akonadictl stop
# copy
cp -R $HOME/.local/share/akonadi/db_data $HOME/.local/share/akonadi/db_data=
_13
# rename
mv $HOME/.local/share/akonadi/db_data $HOME/.local/share/akonadi/db_data_old

2. Create new DB
/usr/lib/postgresql16/bin/initdb --pgdata=3D$HOME/.local/share/akonadi/db_d=
ata=20
=2D-lc-collate=3Den_US.UTF-8 --locale=3Den_US.UTF-8=20

3. Check upgrade
/usr/lib/postgresql16/bin/pg_upgrade -b /usr/lib/postgresql13/bin -B /usr/l=
ib/
postgresql16/bin  -d $HOME/.local/share/akonadi/db_data_13 -D $HOME/.local/
share/akonadi/db_data  --check

4. Do the upgrade if "3" worked okay=20
/usr/lib/postgresql16/bin/pg_upgrade -b /usr/lib/postgresql13/bin -B /usr/l=
ib/
postgresql16/bin -d $HOME/.local/share/akonadi/db_data_13 -D $HOME/.local/
share/akonadi/db_data

=2D----
Here are the error messages from akonadi and the journal.

=2D-------------
~:> akonadictl start
org.kde.pim.akonadictl: Starting Akonadi Server...
org.kde.pim.akonadictl:    done.
~> Connecting to deprecated signal=20
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
org.kde.pim.akonadiserver: Starting up the Akonadi Server...
(QFileInfo(/usr/lib/postgresql/bin), QFileInfo(/usr/lib/postgresql/lib64))
QSqlDatabase: QPSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMARIADB QMYSQL QMYSQL3
org.kde.pim.akonadiserver: Invalid database object during database server=20
startup
QProcess: Destroyed while process ("/usr/bin/pg_ctl") is still running.
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited=20
normally...

=2D--------

This is from "systemctl status postgresql.service"

=D7 postgresql.service - PostgreSQL database server
     Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled;=20
preset: disabled)
     Active: failed (Result: exit-code) since Tue 2023-10-31 16:24:13 GMT;=
=20
1min 31s ago
    Process: 5916 ExecStart=3D/usr/share/postgresql/postgresql-script start=
=20
(code=3Dexited, status=3D1/FAILURE)
        CPU: 8ms

Oct 31 16:24:13 Lian-Li systemd[1]: Starting PostgreSQL database server...
Oct 31 16:24:13 Lian-Li postgresql-script[5916]:  Your database files were=
=20
created by PostgreSQL version 9.6.
Oct 31 16:24:13 Lian-Li postgresql-script[5916]:  Could not find executable=
s=20
for this version.
Oct 31 16:24:13 Lian-Li postgresql-script[5916]:  Please install the=20
PostgreSQL server package for version 9.6.
Oct 31 16:24:13 Lian-Li systemd[1]: postgresql.service: Control process=20
exited, code=3Dexited, status=3D1/FAILURE
Oct 31 16:24:13 Lian-Li systemd[1]: postgresql.service: Failed with result=
=20
'exit-code'.
Oct 31 16:24:13 Lian-Li systemd[1]: Failed to start PostgreSQL database=20
server.

=2D---------
=46rom the journal using "journalctl -xeu postgresql.service"

Oct 31 16:24:13 Lian-Li systemd[1]: Starting PostgreSQL database server...
Subject: A start job for unit postgresql.service has begun execution
Defined-By: systemd
Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel

A start job for unit postgresql.service has begun execution.
=20
The job identifier is 2241.
Oct 31 16:24:13 Lian-Li postgresql-script[5916]:  Your database files were=
=20
created by PostgreSQL version 9.6.
Oct 31 16:24:13 Lian-Li postgresql-script[5916]:  Could not find executable=
s=20
for this version.
Oct 31 16:24:13 Lian-Li postgresql-script[5916]:  Please install the=20
PostgreSQL server package for version 9.6.
Oct 31 16:24:13 Lian-Li systemd[1]: postgresql.service: Control process=20
exited, code=3Dexited, status=3D1/FAILURE
Subject: Unit process exited
Defined-By: systemd
Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel

An ExecStart=3D process belonging to unit postgresql.service has exited.
=20
The process' exit code is 'exited' and its exit status is 1.
Oct 31 16:24:13 Lian-Li systemd[1]: postgresql.service: Failed with result=
=20
'exit-code'.
Subject: Unit failed
Defined-By: systemd
Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel

The unit postgresql.service has entered the 'failed' state with result 'exi=
t-
code'.
Oct 31 16:24:13 Lian-Li systemd[1]: Failed to start PostgreSQL database=20
server.
Subject: A start job for unit postgresql.service has failed
Defined-By: systemd
Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
A start job for unit postgresql.service has finished with a failure.

=2D----------------------

opensuse:tumbleweed:20231030
Qt: 5.15.11 KDE Frameworks: 5.111.0 - KDE Plasma:  5.27.9 - kwin 5.27.9
kmail2 5.24.2 (23.08.2) - akonadiserver 5.24.2 (23.08.2) - Kernel:  6.5.9-1-
default  - kernel-firmware-radeon  20231019