We are running a self-hosted Discourse forum (tff-forum.de) with more than 4 million posts and a lot of large threads. Since the last update to version 3.4.0.beta3 we are experiencing long runtimes of 15 to 20 seconds when moving posts from one thread to another. In some cases the function terminates with an error and the log shows the following message: Unicorn worker received USR2 signal indicating it is about to timeout, dumping backtrace for main thread Before the update we had only problems moving posts between very large threads. Now the function terminates sometimes when the threads only contain a few posts. Do you have any advice what we can check to find the cause for this problem? Is it possible that we have an issue with the database (missing index/statistics)? Thank you in advance for your support.

There were some commits in beta3 that had some performance issue. You should probably upgrade. Note: PostgreSQL 15 update complicates the upgrade.

Thank you for the advice to update to 3.4.0.beta4. Because of the PostgreSQL change to version 15 we need a longer maintenance timeslot. But it makes sense to do the update in the next days to see if this solves our problem. We were a little bit surprised about the PostgreSQL update. We did the update of our test system to 3.4.0.beta3 a few days earlier and had no problems. When we did the update of the production system the database update was suddenly part of the process. We were not prepared for that and skipped the database update. So we have to do it either together with version 3.4.0.beta4 or as a separate step before. Is it possible that the skipped database update causes our performance issues? Is there an easy way to check if the database indexes and statistics are correct?

[תמונה] Thorsten: Is it possible that the skipped database update causes our performance issues? Probably not. [תמונה] Thorsten: Is there an easy way to check if the database indexes and statistics are correct? You can do the vacuum and reindex commands suggested in the PG update topic at any time.

פוסטים שנמשכים זמן רב / שגיאות timeout

תמיכה

pfaffman (Jay Pfaffman) 9 בפברואר,‏ 2025,‏ 6:43pm 4

Probably not.

You can do the vacuum and reindex commands suggested in the PG update topic at any time.

נושא		תגובות	צפיות
Moving posts to a long topic fails Bug	4	264	28 בינואר,‏ 2025
Moving posts returns 502 bad gateway Self-hosting performance , server-resources	71	6463	12 בינואר,‏ 2025
PostgreSQL runaway IO Self-hosting	35	3885	3 במרץ,‏ 2021
"There was an error moving posts" Bug	2	193	12 בדצמבר,‏ 2024
Update takes ~20 minutes and progress update breaks (temporarily) at step multisite:migrate Product Support dev-ops	5	351	18 בספטמבר,‏ 2024

פוסטים שנמשכים זמן רב / שגיאות timeout

נושאים קשורים