Skip to content
This repository was archived by the owner on Apr 26, 2024. It is now read-only.
This repository was archived by the owner on Apr 26, 2024. It is now read-only.

Port script cannot be run twice on the same DB #8619

Closed
#8755
Closed
Port script cannot be run twice on the same DB#8619
#8755
Labels
S-MinorBlocks non-critical functionality, workarounds exist.T-DefectBugs, crashes, hangs, security vulnerabilities, or other reported issues.X-RegressionSomething broke which worked on a previous releasez-p2(Deprecated Label)

Description

@erikjohnston
erikjohnston
opened on Oct 21, 2020

The port script should be able to run multiple times on the same DB, to allow incremental porting.

This fails with:

(env) ~/temp/synapse >>> synapse_port_db --sqlite-database matrix.db.snapshot --postgres-config homeserver-postgres.yaml                                                                  [130]
Preparing sqlite3...
2020-10-21 18:04:54,927 - synapse.storage.prepare_database - 102 - INFO - ['main', 'state']: Checking existing schema version
2020-10-21 18:04:54,928 - synapse.storage.prepare_database - 107 - INFO - ['main', 'state']: Existing schema is 58 (+20 deltas)
2020-10-21 18:04:54,929 - synapse.storage.databases.main - 601 - INFO - Checking database for consistency with configuration...
2020-10-21 18:04:54,929 - synapse.storage.prepare_database - 379 - INFO - Applying schema deltas for v58
2020-10-21 18:04:54,929 - synapse.storage.prepare_database - 503 - INFO - Schema now up to date
2020-10-21 18:04:54,931 - synapse.storage.util.id_generators - 57 - INFO - initialising stream generator for events(stream_ordering)
2020-10-21 18:04:54,931 - synapse.storage.util.id_generators - 57 - INFO - initialising stream generator for events(stream_ordering)
2020-10-21 18:04:54,931 - synapse.storage.util.id_generators - 57 - INFO - initialising stream generator for ex_outlier_stream(event_stream_ordering)
Preparing psycopg2...
2020-10-21 18:04:54,946 - synapse.storage.prepare_database - 102 - INFO - ['main', 'state']: Checking existing schema version
2020-10-21 18:04:54,948 - synapse.storage.prepare_database - 107 - INFO - ['main', 'state']: Existing schema is 58 (+22 deltas)
2020-10-21 18:04:54,948 - synapse.storage.databases.main - 601 - INFO - Checking database for consistency with configuration...
2020-10-21 18:04:54,949 - synapse.storage.prepare_database - 379 - INFO - Applying schema deltas for v58
2020-10-21 18:04:54,949 - synapse.storage.prepare_database - 503 - INFO - Schema now up to date
--- Logging error ---
Traceback (most recent call last):
  File "/usr/lib/python3.8/logging/__init__.py", line 1081, in emit
    msg = self.format(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 925, in format
    return fmt.format(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 664, in format
    record.message = record.getMessage()
  File "/usr/lib/python3.8/logging/__init__.py", line 369, in getMessage
    msg = msg % self.args
TypeError: not enough arguments for format string
Call stack:
  File "/home/twilight/temp/synapse/env/bin/synapse_port_db", line 1097, in <module>
    start()
  File "/home/twilight/temp/synapse/env/bin/synapse_port_db", line 1092, in start
    reactor.run()
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/twisted/internet/base.py", line 1283, in run
    self.mainLoop()
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/twisted/internet/base.py", line 1292, in mainLoop
    self.runUntilCurrent()
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/metrics/__init__.py", line 538, in f
    ret = func(*args, **kwargs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/twisted/internet/base.py", line 886, in runUntilCurrent
    f(*a, **kw)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/twisted/internet/defer.py", line 460, in callback
    self._startRunCallbacks(result)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/twisted/internet/defer.py", line 568, in _startRunCallbacks
    self._runCallbacks()
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/twisted/internet/defer.py", line 654, in _runCallbacks
    current.result = callback(current.result, *args, **kw)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/twisted/internet/defer.py", line 1475, in gotResult
    _inlineCallbacks(r, g, status)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/twisted/internet/defer.py", line 1418, in _inlineCallbacks
    result = g.send(result)
  File "/home/twilight/temp/synapse/env/bin/synapse_port_db", line 547, in run
    self.postgres_store = self.build_db_store(
  File "/home/twilight/temp/synapse/env/bin/synapse_port_db", line 497, in build_db_store
    store = Store(DatabasePool(hs, db_config, engine), db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/client_ips.py", line 34, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/deviceinbox.py", line 286, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/devices.py", line 704, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/events_bg_updates.py", line 32, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/media_repository.py", line 27, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/registration.py", line 784, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/registration.py", line 39, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/room.py", line 866, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/roommember.py", line 826, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/search.py", line 92, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/state/bg_updates.py", line 184, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/state.py", line 323, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/roommember.py", line 57, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/events_worker.py", line 83, in __init__
    self._stream_id_gen = MultiWriterIdGenerator(
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/util/id_generators.py", line 263, in __init__
    self._sequence_gen.check_consistency(
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/util/sequence.py", line 118, in check_consistency
    logger.warning(
Message: 'Postgres sequence %s is behind table %s: %d < %d'
Arguments: (1, 41)
2020-10-21 18:04:54,960 - synapse_port_db - 639 - ERROR - 
Traceback (most recent call last):
  File "/home/twilight/temp/synapse/env/bin/synapse_port_db", line 547, in run
    self.postgres_store = self.build_db_store(
  File "/home/twilight/temp/synapse/env/bin/synapse_port_db", line 497, in build_db_store
    store = Store(DatabasePool(hs, db_config, engine), db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/client_ips.py", line 34, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/deviceinbox.py", line 286, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/devices.py", line 704, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/events_bg_updates.py", line 32, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/media_repository.py", line 27, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/registration.py", line 784, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/registration.py", line 39, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/room.py", line 866, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/roommember.py", line 826, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/search.py", line 92, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/state/bg_updates.py", line 184, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/state.py", line 323, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/roommember.py", line 57, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/events_worker.py", line 83, in __init__
    self._stream_id_gen = MultiWriterIdGenerator(
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/util/id_generators.py", line 263, in __init__
    self._sequence_gen.check_consistency(
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/util/sequence.py", line 123, in check_consistency
    raise IncorrectDatabaseSetup(
synapse.storage.engines._base.IncorrectDatabaseSetup: 
Postgres sequence 'events_stream_seq' is inconsistent with associated
table 'events'. This can happen if Synapse has been downgraded and
then upgraded again, or due to a bad migration.

To fix this error, shut down Synapse (including any and all workers)
and run the following SQL:

    SELECT setval('events_stream_seq', (
        SELECT GREATEST(MAX(stream_ordering), 0) FROM events
    ));

See docs/postgres.md for more information.

Traceback (most recent call last):
  File "/home/twilight/temp/synapse/env/bin/synapse_port_db", line 547, in run
    self.postgres_store = self.build_db_store(
  File "/home/twilight/temp/synapse/env/bin/synapse_port_db", line 497, in build_db_store
    store = Store(DatabasePool(hs, db_config, engine), db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/client_ips.py", line 34, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/deviceinbox.py", line 286, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/devices.py", line 704, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/events_bg_updates.py", line 32, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/media_repository.py", line 27, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/registration.py", line 784, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/registration.py", line 39, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/room.py", line 866, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/roommember.py", line 826, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/search.py", line 92, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/state/bg_updates.py", line 184, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/state.py", line 323, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/roommember.py", line 57, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/databases/main/events_worker.py", line 83, in __init__
    self._stream_id_gen = MultiWriterIdGenerator(
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/util/id_generators.py", line 263, in __init__
    self._sequence_gen.check_consistency(
  File "/home/twilight/temp/synapse/env/lib/python3.8/site-packages/synapse/storage/util/sequence.py", line 123, in check_consistency
    raise IncorrectDatabaseSetup(
synapse.storage.engines._base.IncorrectDatabaseSetup: 
Postgres sequence 'events_stream_seq' is inconsistent with associated
table 'events'. This can happen if Synapse has been downgraded and
then upgraded again, or due to a bad migration.

To fix this error, shut down Synapse (including any and all workers)
and run the following SQL:

    SELECT setval('events_stream_seq', (
        SELECT GREATEST(MAX(stream_ordering), 0) FROM events
    ));

See docs/postgres.md for more information.

Traceback (most recent call last):
  File "/home/twilight/temp/synapse/env/bin/synapse_port_db", line 1104, in <module>
    sys.stderr.write(end_error)
TypeError: write() argument must be str, not IncorrectDatabaseSetup

Activity

  1. clokep
    added
    z-bug(Deprecated Label)
    p1
    on Oct 21, 2020
  2. clokep
    added
    z-regression(Deprecated Label)
    on Oct 29, 2020
  3. neilisfragile
    added
    release blocker
    on Nov 5, 2020
  4. erikjohnston
    closed this as completedin #8755on Nov 13, 2020
  5. erikjohnston
    added a commit that references this issue on Nov 13, 2020

    Fix port script so that it can be run again after failure. (#8755)

    1b15a3d
  6. richvdh
    reopened this on May 5, 2021

  7. richvdh commented on May 5, 2021

    @richvdh
    richvdh
    on May 5, 2021
    Member

    this seems to have regressed:

    Preparing sqlite3...
2021-05-05 16:27:47,280 - synapse.storage.prepare_database - 98 - INFO - ('main', 'state'): Checking existing schema version
2021-05-05 16:27:47,282 - synapse.storage.prepare_database - 103 - INFO - ('main', 'state'): Existing schema is 59 (+15 deltas)
2021-05-05 16:27:47,283 - synapse.storage.databases.main - 351 - INFO - Checking database for consistency with configuration...
2021-05-05 16:27:47,283 - synapse.storage.prepare_database - 374 - INFO - Applying schema deltas for v59
2021-05-05 16:27:47,284 - synapse.storage.prepare_database - 504 - INFO - Schema now up to date
2021-05-05 16:27:47,307 - synapse.storage.util.id_generators - 55 - INFO - initialising stream generator for pushers(id)
2021-05-05 16:27:47,307 - synapse.storage.util.id_generators - 55 - INFO - initialising stream generator for deleted_pushers(stream_id)
2021-05-05 16:27:47,308 - synapse.storage.util.id_generators - 55 - INFO - initialising stream generator for events(stream_ordering)
2021-05-05 16:27:47,309 - synapse.storage.util.id_generators - 55 - INFO - initialising stream generator for events(stream_ordering)
2021-05-05 16:27:47,309 - synapse.storage.util.id_generators - 55 - INFO - initialising stream generator for ex_outlier_stream(event_stream_ordering)
Preparing psycopg2...
2021-05-05 16:27:47,356 - synapse.storage.prepare_database - 98 - INFO - ('main', 'state'): Checking existing schema version
2021-05-05 16:27:47,360 - synapse.storage.prepare_database - 103 - INFO - ('main', 'state'): Existing schema is 59 (+19 deltas)
2021-05-05 16:27:47,361 - synapse.storage.databases.main - 351 - INFO - Checking database for consistency with configuration...
2021-05-05 16:27:47,362 - synapse.storage.prepare_database - 374 - INFO - Applying schema deltas for v59
2021-05-05 16:27:47,363 - synapse.storage.prepare_database - 504 - INFO - Schema now up to date
2021-05-05 16:27:47,369 - synapse.storage.util.id_generators - 55 - INFO - initialising stream generator for pushers(id)
2021-05-05 16:27:47,370 - synapse.storage.util.id_generators - 55 - INFO - initialising stream generator for deleted_pushers(stream_id)
2021-05-05 16:27:47,379 - synapse.storage.util.sequence - 173 - WARNING - Postgres sequence event_auth_chain_id is behind table event_auth_chains: 224 < 225
2021-05-05 16:27:47,379 - synapse_port_db - 715 - ERROR - 
Traceback (most recent call last):
  File "./scripts/synapse_port_db", line 580, in run
    self.postgres_store = self.build_db_store(
  File "./scripts/synapse_port_db", line 530, in build_db_store
    store = Store(DatabasePool(hs, db_config, engine), db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/client_ips.py", line 34, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/deviceinbox.py", line 541, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/devices.py", line 919, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/events_bg_updates.py", line 57, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/media_repository.py", line 47, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/registration.py", line 1082, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/registration.py", line 78, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/cache.py", line 42, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/room.py", line 1016, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/roommember.py", line 959, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/search.py", line 91, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/state/bg_updates.py", line 186, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/state.py", line 322, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/roommember.py", line 67, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/events_worker.py", line 174, in __init__
    self.event_chain_id_gen = build_sequence_generator(
  File "/home/rav/work/synapse/synapse/storage/util/sequence.py", line 283, in build_sequence_generator
    seq.check_consistency(
  File "/home/rav/work/synapse/synapse/storage/util/sequence.py", line 180, in check_consistency
    raise IncorrectDatabaseSetup(
synapse.storage.engines._base.IncorrectDatabaseSetup: 
Postgres sequence 'event_auth_chain_id' is inconsistent with associated
table 'event_auth_chains'. This can happen if Synapse has been downgraded and
then upgraded again, or due to a bad migration.

To fix this error, shut down Synapse (including any and all workers)
and run the following SQL:

    SELECT setval('event_auth_chain_id', (
        SELECT GREATEST(MAX(chain_id), 0) FROM event_auth_chains
    ));

See docs/postgres.md for more information.

Traceback (most recent call last):
  File "./scripts/synapse_port_db", line 580, in run
    self.postgres_store = self.build_db_store(
  File "./scripts/synapse_port_db", line 530, in build_db_store
    store = Store(DatabasePool(hs, db_config, engine), db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/client_ips.py", line 34, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/deviceinbox.py", line 541, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/devices.py", line 919, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/events_bg_updates.py", line 57, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/media_repository.py", line 47, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/registration.py", line 1082, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/registration.py", line 78, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/cache.py", line 42, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/room.py", line 1016, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/roommember.py", line 959, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/search.py", line 91, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/state/bg_updates.py", line 186, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/state.py", line 322, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/roommember.py", line 67, in __init__
    super().__init__(database, db_conn, hs)
  File "/home/rav/work/synapse/synapse/storage/databases/main/events_worker.py", line 174, in __init__
    self.event_chain_id_gen = build_sequence_generator(
  File "/home/rav/work/synapse/synapse/storage/util/sequence.py", line 283, in build_sequence_generator
    seq.check_consistency(
  File "/home/rav/work/synapse/synapse/storage/util/sequence.py", line 180, in check_consistency
    raise IncorrectDatabaseSetup(
synapse.storage.engines._base.IncorrectDatabaseSetup: 
Postgres sequence 'event_auth_chain_id' is inconsistent with associated
table 'event_auth_chains'. This can happen if Synapse has been downgraded and
then upgraded again, or due to a bad migration.

To fix this error, shut down Synapse (including any and all workers)
and run the following SQL:

    SELECT setval('event_auth_chain_id', (
        SELECT GREATEST(MAX(chain_id), 0) FROM event_auth_chains
    ));

See docs/postgres.md for more information.


Postgres sequence 'event_auth_chain_id' is inconsistent with associated
table 'event_auth_chains'. This can happen if Synapse has been downgraded and
then upgraded again, or due to a bad migration.

To fix this error, shut down Synapse (including any and all workers)
and run the following SQL:

    SELECT setval('event_auth_chain_id', (
        SELECT GREATEST(MAX(chain_id), 0) FROM event_auth_chains
    ));

See docs/postgres.md for more information.
  8. richvdh
    added
    S-MinorBlocks non-critical functionality, workarounds exist.
    T-DefectBugs, crashes, hangs, security vulnerabilities, or other reported issues.
    X-RegressionSomething broke which worked on a previous release
    and removed
    z-bug(Deprecated Label)
    z-p1
    z-regression(Deprecated Label)
    z-release blocker
    on May 5, 2021
  9. callahad
    added
    P2
    on May 6, 2021

  10. richvdh commented on May 13, 2021

    @richvdh
    richvdh
    on May 13, 2021
    Member

    It's actually worse than that - Synapse won't start when pointed to the ported database. This isn't really a regression of the original bug, so I'm going to close this in favour of #9979.

  11. richvdh
    closed this as completedon May 13, 2021
  12. kittykat
    added
    z-p2(Deprecated Label)
    on Sep 6, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    S-MinorBlocks non-critical functionality, workarounds exist.T-DefectBugs, crashes, hangs, security vulnerabilities, or other reported issues.X-RegressionSomething broke which worked on a previous releasez-p2(Deprecated Label)

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions