多站点将上传内容恢复为“默认”而非实际数据库名称

kris.kotlarek · 2019 年10 月 22 日 02:57

我花了一些时间调查这个问题，但最终还是找到了解决方法

github.com/discourse/discourse

FIX: Reconnect in restore process connects to correct DB (#8218)

master ← KrisKotlarek:fix-multisite-resore-db-name

merged 06:23AM - 23 Oct 19 UTC

KrisKotlarek

+23 -0

Simplified flow of restore is like that ``` migrate_database reconnect extra…ct_uploads ``` Problem with incorrect current database started with this fix https://github.com/discourse/discourse/commit/025d4ee91f4 Dump task is reconnecting to default database https://github.com/rails/rails/blob/master/activerecord/lib/active_record/railties/databases.rake#L429 And then, we are trying to reconnect to the original database with that code: ``` def reconnect_database log "Reconnecting to the database..." RailsMultisite::ConnectionManagement::establish_connection(db: @current_db) end ``` This reconnect is not switching us back to correct database because of that check https://github.com/discourse/rails_multisite/blob/master/lib/rails_multisite/connection_management.rb#L181 Basically, it finds existing handler and it thinks that we are connected to correct DB and this step can be skipped. To solve it, we can reload RailsMultisite::ConnectionManagement which creates a new instance of that class https://github.com/discourse/rails_multisite/blob/master/lib/rails_multisite/connection_management.rb#L38 Meta: https://meta.discourse.org/t/multisite-restores-uploads-to-default-instead-of-actual-db-name/130778

话题		回复	浏览量
Commandline restore specific site in multi-site configuration Product Support	2	726	2018 年1 月 12 日
Rake multisite:migrate is broken Bug	4	1537	2020 年6 月 23 日
Restore from old multisite installation failing Self-hosting	6	594	2020 年8 月 26 日
Restore to New Host Product Support	13	839	2026 年1 月 15 日
How to specify alternate configuration in multisite Self-hosting	23	2601	2017 年11 月 13 日

多站点将上传内容恢复为“默认”而非实际数据库名称

相关话题