postgresql failed

Bug #1866451 reported by FSA
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
matrix-synapse (Ubuntu)
New
Undecided
Unassigned

Bug Description

Ubuntu 20.04, matrix-synapse-1.11.0
Service failed with:
```
database:
  name: "psycopg2"
  args:
    user: "matrix"
    password: "mypassword"
    database: "matrix"
    host: "localhost"
    cp_min: 5
    cp_max: 10
```
No error message.
syslog:
```
Mar 7 11:38:27 ubuntu-2gb-nbg1-1 systemd[1]: Starting Synapse Matrix homeserver...
Mar 7 11:38:29 ubuntu-2gb-nbg1-1 systemd[1]: Started Synapse Matrix homeserver.
Mar 7 11:38:30 ubuntu-2gb-nbg1-1 synapse[122934]: root: [None] ***** STARTING SERVER *****
Mar 7 11:38:30 ubuntu-2gb-nbg1-1 synapse[122934]: root: [None] Server /usr/lib/python3/dist-packages/synapse/app/homeserver.py version 1.11.0
Mar 7 11:38:30 ubuntu-2gb-nbg1-1 synapse[122934]: root: [None] Server hostname: tavda.info
Mar 7 11:38:30 ubuntu-2gb-nbg1-1 synapse[122934]: synapse.app.homeserver: [None] Setting up server
Mar 7 11:38:30 ubuntu-2gb-nbg1-1 synapse[122934]: synapse.server: [None] Setting up.
Mar 7 11:38:31 ubuntu-2gb-nbg1-1 systemd[1]: matrix-synapse.service: Main process exited, code=exited, status=1/FAILURE
Mar 7 11:38:31 ubuntu-2gb-nbg1-1 systemd[1]: matrix-synapse.service: Failed with result 'exit-code'.
Mar 7 11:38:34 ubuntu-2gb-nbg1-1 systemd[1]: matrix-synapse.service: Scheduled restart job, restart counter is at 4.
Mar 7 11:38:34 ubuntu-2gb-nbg1-1 systemd[1]: Stopped Synapse Matrix homeserver.
Mar 7 11:38:34 ubuntu-2gb-nbg1-1 systemd[1]: Starting Synapse Matrix homeserver...
Mar 7 11:38:35 ubuntu-2gb-nbg1-1 systemd[1]: Started Synapse Matrix homeserver.
```
This config work fine on Ubuntu 18.04 LTS (matrix.org/package/debian, matrix-synapse-1.11.0 and 1.11.1).
SQLite work without errors.

При добавлении в конфигурацию настроек базы PostgreSQL сервис перестаёт стартовать. В syslog только сообщения об остановке процесса. При запуске с SQLite проблем не наблюдается. База данных точно доступна (захожу через Adminer (PHP) без проблем).

Revision history for this message
FSA (fsa) wrote :

python3-psycopg2 required.

# sudo apt install python3-psycopg2

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.