On 8/5/22 09:38, bob B via Mailman-users wrote:
I have a test Mailman 3 environment. We are using docker, and we are running the database outside of docker in mysql. I need to perform a DR recovery test.
I shut down Mailman in docker (mailman-core & mailman-web, the only docker images I have running for Mailman).
Does shutting down mailman-web also shut down Django qcluster? If not, this could be an issue.
While Mailman was stopped, I had our database team take a backup dump of the database. I then restarted Mailman in docker. I threw some more messages at a test list. I validated that the new messages were delivered, and showed up in the archive. I shut down Mailman again. I had the database team restore the Mailman database from the backup. I started Mailman I logged into Mailman I was expecting to see the messages in the archive prior to the backup and all the messages after the backup would be gone.
I would expect that too.
When went into the list archive, I get a spinning icon and no messages showed up.
I don't offhand know what the issue would be unless Django qcluster was running the whole time.
I quit, restarted my browser, and logged in again, and the same thing. I then sent a test message to the list and the message was delivered to the list. Then when I went to check the archive, the spinning icon was gone and that test message was there along with all the messages before the backup was taken.
Possibly one of the Django periodic jobs, maybe cache_cleanup or daily_cleanup would fix it without a message.
Is this normal? After a restore did the new message cause a refresh of archived messages etc? Is there a way to do this without sending a message to a list after a restoration of the database?
Are there better steps I should take when restoring the database?
I don't know what better you could do as far as the save and restore are concerned as long as shutting down mailman-web stops qcluster.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan