I migrated a 200,000-post forum to a new server. The live site was put in read-only mode so there wouldn’t be downtime. I restored the backup on a different subdomain so that users wouldn’t see the install screens or any problems that might happen during the restore – something like dev.example.com.…

If you have local disk, you can add swap, which would avoid memory exhaustion (whether or not that’s the cause of trouble here.) What does free tell you? Do you see oom or memory in the output of dmesg?

First, see Change the domain name or rename your Discourse (though another solution is to backup and then restore with the new hostname). My guess is that you’re running out of connections to the database, but that isn’t quick the error I would expect. Is this a standard install or are you using s…

Thanks for the links. It’s a standard Docker install on a DigitalOcean droplet (“Premium AMD”, 4GB RAM, 2 vCPUs). I followed the instructions in the link you mentioned. I found some of the wrong URLs in the settings, so I fixed those and rebuilt the forum again to be safe. Then I ran this kind of …

[이미지] Ed S: What does free tell you? At the moment it says: total used free shared buff/cache available Mem: 3.8Gi 2.1Gi 160Mi 1.0Gi 1.6Gi 488Mi Swap: 0B 0B 0B [이미지] Ed S: Do you s…

If you have the disk space, it’s certainly worth adding say 2G of swap. The other thing to do is to monitor usage while your large job is running. I would use vmstat 5 5 and perhaps log to a file. You’re hoping not to see large values in si or so columns, and not to see the swpd column get close to…

Thanks, I’ll try those things later today. I have 50GB free at the moment.

Sounds good! Just for the record you could add more swap, even as the task is running, if vmstat or free (or top) show that swap is getting exhausted. if you’re careful, you could probably do a reversible temporary upgrade to a larger-RAM instance, which will cost a little money, but need only be…

[이미지] Ed S: you could probably do a reversible temporary upgrade to a larger-RAM instance I thought about it, but I would have to shut the server off, and users already had an annoying “read-only” period and downtime when I moved servers. :sweat: I wasn’t able to finish it last night because…

Do keep an eye on things with vmstat or similar - that’s such a long-running job, you don’t want to have to restart it. I’d probably add another 2G of swap, to be safe.

Thanks, I checked with vmstat occasionally. I started it in a tmux session so I could detach and close my laptop for a while. It probably took 8-9 hours to run the command, but everything completed without errors.

Rake:rebake 실행 시 PG::ConnectionBad: PQsocket 오류로 충돌

지원 자체 호스팅

j127 2월 28, 2023, 7:15오전 8

I added a 2GB swapfile, and that seems to have fixed it. The rebaking is only 20% done, but there hasn’t been a single error yet, and RAM usage is just under 100%.

Thank you both for your help.

Rebake failing: how to diagnose and fix?

글		댓글	조회수
Rebake failing: how to diagnose and fix? Support	6	227	12월 14, 2025
Rebake aborts with error message Self-hosting server-resources	4	1196	3월 12, 2022
`rake posts:rebake` crashed half way through Self-hosting	2	393	2월 3, 2023
Error "Killed" while running rake posts:rebake Self-hosting server-resources	21	3051	5월 13, 2019
PG::ConnectionBad causes site to temporarily crash Support	12	1012	4월 5, 2020

Rake:rebake 실행 시 PG::ConnectionBad: PQsocket 오류로 충돌

Related topics