Multisite восстанавливает загрузки в 'default' вместо реального имени базы данных

kris.kotlarek · 22.Октябрь.2019 02:57:31

Я потратил некоторое время на расследование этого, но в конце концов нашёл решение

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	12.01.2018
Rake multisite:migrate is broken Bug	4	1537	23.06.2020
Restore from old multisite installation failing Self-hosting	6	594	26.08.2020
Restore to New Host Product Support	13	839	15.01.2026
How to specify alternate configuration in multisite Self-hosting	23	2601	13.11.2017

Multisite восстанавливает загрузки в 'default' вместо реального имени базы данных

Связанные темы