- 2023-04-19 18:28:26.755 UTC [45] LOG: database system was not properly shut down; automatic recovery in progress
If your database can’t stop safely in 60s, which will happen with large DBs with slower disks, it will enter this state and fail a rebuild if it can’t recover in 5s (which is rare since it’s large/slow).
This has nothing to do with the changes listed here, and is a problem in Discourse since at least 2016.