main/postgresql community/synapse main/py-psycopg2: Error relocating /usr/lib/postgresql/plpgsql.so: EnsurePortalSnapshotExists: symbol not found
Hi. I run a up-to-date v3.14
I installed the synapse
package, which depends on py-psycopg2
. I have also postgresql
, postgresql-libs
and postgresql-client
installed.
The synapse process fails with this stacktrace
2021-09-02 15:29:27,960 - root - 336 - WARNING - main - ***** STARTING SERVER *****
2021-09-02 15:29:27,960 - root - 337 - WARNING - main - Server /usr/lib/python3.9/site-packages/synapse/app/homeserver.py version 1.41.1
2021-09-02 15:29:27,960 - root - 338 - INFO - main - Server hostname: xxxxxx
2021-09-02 15:29:27,960 - root - 339 - INFO - main - Instance name: master
2021-09-02 15:29:27,960 - synapse.app.homeserver - 357 - INFO - main - Setting up server
2021-09-02 15:29:27,961 - synapse.server - 307 - INFO - main - Setting up.
2021-09-02 15:29:27,984 - synapse.storage.databases - 49 - INFO - main - [database config 'master']: Checking database server
2021-09-02 15:29:27,988 - synapse.storage.databases - 52 - INFO - main - [database config 'master']: Preparing for databases ['main', 'state']
2021-09-02 15:29:27,988 - synapse.storage.prepare_database - 116 - INFO - main - ['main', 'state']: Checking existing schema version
2021-09-02 15:29:28,002 - synapse.storage.prepare_database - 120 - INFO - main - ['main', 'state']: Existing schema is 59 (+19 deltas)
2021-09-02 15:29:28,006 - synapse.storage.databases.main - 346 - INFO - main - Checking database for consistency with configuration...
2021-09-02 15:29:28,009 - synapse.storage.prepare_database - 407 - INFO - main - Applying schema deltas for v59
2021-09-02 15:29:28,012 - synapse.storage.prepare_database - 508 - INFO - main - Applying schema 59/11add_knock_members_to_stats.sql
2021-09-02 15:29:28,015 - synapse.storage.prepare_database - 508 - INFO - main - Applying schema 59/13users_to_send_full_presence_to.sql
2021-09-02 15:29:28,026 - synapse.storage.prepare_database - 508 - INFO - main - Applying schema 59/14refresh_tokens.sql
2021-09-02 15:29:28,038 - synapse.storage.prepare_database - 508 - INFO - main - Applying schema 59/15locks.sql
2021-09-02 15:29:28,044 - synapse.storage.prepare_database - 508 - INFO - main - Applying schema 59/16federation_inbound_staging.sql
2021-09-02 15:29:28,052 - synapse.storage.prepare_database - 407 - INFO - main - Applying schema deltas for v60
2021-09-02 15:29:28,054 - synapse.storage.prepare_database - 516 - INFO - main - Applying engine-specific schema 60/01recreate_stream_ordering.sql.postgres
2021-09-02 15:29:28,059 - synapse.storage.prepare_database - 516 - INFO - main - Applying engine-specific schema 60/02change_stream_ordering_columns.sql.postgres
2021-09-02 15:29:28,100 - synapse.storage.prepare_database - 407 - INFO - main - Applying schema deltas for v61
2021-09-02 15:29:28,101 - synapse.storage.prepare_database - 516 - INFO - main - Applying engine-specific schema 61/01change_appservices_txns.sql.postgres
2021-09-02 15:29:28,114 - synapse.storage.prepare_database - 508 - INFO - main - Applying schema 61/01insertion_event_lookups.sql
2021-09-02 15:29:28,137 - synapse.storage.prepare_database - 508 - INFO - main - Applying schema 61/02drop_redundant_room_depth_index.sql
2021-09-02 15:29:28,140 - synapse.storage.prepare_database - 516 - INFO - main - Applying engine-specific schema 61/02state_groups_state_n_distinct.sql.postgres
2021-09-02 15:29:28,142 - synapse.storage.prepare_database - 493 - INFO - main - Running script 61/03recreate_min_depth.py
2021-09-02 15:29:28,151 - synapse.app._base - 160 - ERROR - main - Exception during startup
Traceback (most recent call last):
File "/usr/lib/python3.9/site-packages/synapse/app/homeserver.py", line 360, in setup
hs.setup()
File "/usr/lib/python3.9/site-packages/synapse/server.py", line 309, in setup
self.datastores = Databases(self.DATASTORE_CLASS, self)
File "/usr/lib/python3.9/site-packages/synapse/storage/databases/__init__.py", line 57, in __init__
prepare_database(
File "/usr/lib/python3.9/site-packages/synapse/storage/prepare_database.py", line 145, in prepare_database
_upgrade_existing_database(
File "/usr/lib/python3.9/site-packages/synapse/storage/prepare_database.py", line 494, in _upgrade_existing_database
module.run_create(cur, database_engine) # type: ignore
File "/usr/lib/python3.9/site-packages/synapse/storage/schema/main/delta/61/03recreate_min_depth.py", line 33, in run_create
cur.execute(
File "/usr/lib/python3.9/site-packages/synapse/storage/database.py", line 298, in execute
self._do_execute(self.txn.execute, sql, *args)
File "/usr/lib/python3.9/site-packages/synapse/storage/database.py", line 331, in _do_execute
return func(sql, *args)
psycopg2.errors.UndefinedFile: could not load library "/usr/lib/postgresql/plpgsql.so": Error relocating /usr/lib/postgresql/plpgsql.so: EnsurePortalSnapshotExists: symbol not found
The incriminated file exists:
$ ll /usr/lib/postgresql/plpgsql.so
-rwxr-xr-x 1 root root 202408 Aug 16 05:18 /usr/lib/postgresql/plpgsql.so
Reinstalling the packages does not help.
sudo apk add --force --no-cache synapse py-psycopg2 postgresql postgresql-libs postgresql-client
Do you have an idea what is going wrong?