Errors in PostgreSQL log file after clean install: relation "event_search_fts_idx" already exists and duplicate key value violates unique constraint "device_uniqueness"

[Tokodomo]

Description

Errors in PostgreSQL log file after clean installation (new database etc.) - running on localhost: ERROR: relation "event_search_fts_idx" already exists and ERROR: duplicate key value violates unique constraint "device_uniqueness" :

2019-06-02 14:31:28.683 CEST [13608] LOG:  listening on IPv6 address "::1", port 54320
2019-06-02 14:31:28.683 CEST [13608] LOG:  listening on IPv4 address "127.0.0.1", port 54320
2019-06-02 14:31:28.749 CEST [13608] LOG:  listening on Unix socket "~/pgsql_store/.s.PGSQL.54320"
2019-06-02 14:31:28.859 CEST [13609] LOG:  database system was shut down at 2019-06-02 14:30:37 CEST
2019-06-02 14:31:28.894 CEST [13608] LOG:  database system is ready to accept connections
2019-06-02 14:32:59.847 CEST [13984] ERROR:  relation "event_search_fts_idx" already exists
2019-06-02 14:32:59.847 CEST [13984] STATEMENT:  CREATE INDEX CONCURRENTLY event_search_fts_idx ON event_search USING GIN (vector)
2019-06-02 14:42:58.656 CEST [16884] ERROR:  duplicate key value violates unique constraint "device_uniqueness"
2019-06-02 14:42:58.656 CEST [16884] DETAIL:  Key (user_id, device_id)=(@alice:nas, HTZNEHCJTE) already exists.
2019-06-02 14:42:58.656 CEST [16884] STATEMENT:  INSERT INTO devices (user_id, device_id, display_name) VALUES('@alice:nas', 'HTZNEHCJTE', NULL)
2019-06-02 14:47:25.814 CEST [18230] ERROR:  duplicate key value violates unique constraint "device_uniqueness"
2019-06-02 14:47:25.814 CEST [18230] DETAIL:  Key (user_id, device_id)=(@bob:nas, RSQDVOFEKU) already exists.
2019-06-02 14:47:25.814 CEST [18230] STATEMENT:  INSERT INTO devices (user_id, device_id, display_name) VALUES('@bob:nas', 'RSQDVOFEKU', NULL)
2019-06-02 14:47:41.030 CEST [18237] ERROR:  duplicate key value violates unique constraint "device_uniqueness"
2019-06-02 14:47:41.030 CEST [18237] DETAIL:  Key (user_id, device_id)=(@alice:nas, HTZNEHCJTE) already exists.
2019-06-02 14:47:41.030 CEST [18237] STATEMENT:  INSERT INTO devices (user_id, device_id, display_name) VALUES('@alice:nas', 'HTZNEHCJTE', NULL)

Steps to reproduce

• create a new virtualenv and install Synapse 0.99.5.2
• prepare a fresh PostgreSQL database
• start Synapse and register/login some users
• analyse the PostgreSQL log file

Version information

• Homeserver: nas (test installation running on localhost)

• Version: Synapse 0.99.5.2, PostgreSQL 11.3, Python 3.7.3

• Install method: pip install matrix-synapse[all] in virtualenv

• Platform: Debian AMD64

[richvdh]

I think these are expected, see #5961