データベースの再接続が機能しないため、復元が失敗します

david · 2026 年 10 月 7 日午前 10:25

ありがとう @RGJ。これで対応できると思います：

github.com/discourse/discourse

FIX: Reconnect to the database after restoring a backup (#44323)

main ← fix-restore-db-reconnect

merged 11:24AM - 07 Oct 26 UTC

davidtaylorhq

+32 -1

A restore opens one database connection at the start. `psql` and `rake db:migrat…e` run in separate processes, which can take a long time. If Rails' connection is dropped for some reason while `psql`/`migrate` are running, then the restore will fail on the first query after the migration. We already had a "Reconnecting to the database..." step, but this step did not actually open a new connection. On a single-site install it did nothing, and on a multisite install it used the cached connection again. Rails automatic reconnection does not take effect because Discourse's `DB.*` uses the raw_connection. - `reconnect_database` now calls `reconnect!`, so the restore continues on a new connection. - A new spec ends the restore's connection while the dump is restored, and checks that the restore still saves its date. - `execute_stubbed_restore` stubs `reconnect!` by default, because a real reconnect drops the test transaction. The multisite spec uses a real reconnect, because its second database is not in a test transaction. https://meta.discourse.org/t/413615

トピック		返信	表示
Can't restore saved backup Self-hosting	3	1325	2017 年 3 月 7 日
Timeout when restoring a backup Self-hosting	1	936	2020 年 11 月 16 日
Large restore failing midway through Support	2	144	2025 年 1 月 7 日
Error when restore DB backup Self-hosting	25	2135	2018 年 8 月 23 日
Database issues migrating form old version 20150822141540 Self-hosting	13	1247	2022 年 9 月 22 日

データベースの再接続が機能しないため、復元が失敗します

関連トピック