I’ve got the problem. Several time a day my forum goes in situation where all updates process are delayed. 'Updating Last Seen' is still running after 90 seconds on db default, this process may need to be restarted! /var/www/discourse/vendor/bundle/ruby/2.5.0/gems/logster-2.1.2/lib/logster/logger.…

More errors: Job exception: ERROR: deadlock detected DETAIL: Process 22512 waits for ExclusiveLock on tuple (22418,9) of relation 16742 of database 16400; blocked by process 28074. Process 28074 waits for ShareLock on transaction 1013165180; blocked by process 24391. Process 24391 waits for Share…

[صورة] Dmitry_Krasnoperov: I do have two plugins discourse-whos-online discourse-topic-list-previews Disable these and rebuild and see if that helps things.

Do you have enough ram? I’d the cpu far enough? How big is your database and how much ram do you have? Is swap enabled? Is it getting full?

[image] 4CPU/8GB and 2GB swap enabled. But DB is large enough with a lot of images 84.0GiB [##########] /uploads 26.7GiB [### ] /postgres_data 4.7GiB [ ] /backups 3.7GiB [ ] /log 201.5MiB [ ] /redis_data 1.7MiB [ ] /letsencrypt 176.…

[صورة] codinghorror: Disable these and rebuild and see if that helps things. Yep, will disable one by one and see. Thanks

That’s a big database. What’s the value of db_shared_buffers in app.yml?

## Set db_shared_buffers to a max of 25% of the total memory. ## ## On 1GB installs set to 128MB (to leave room for other processes) ## on a 4GB instance you may raise to 1GB db_shared_buffers: "2048MB"

You might try bumping it and the other memory variable up a bit. You have fast ssd?

Hi Dmitry, I am also experiencing the same combination of errors. are you still getting this error resolved?

لا تزال وظائف 'تحديث آخر ظهور' و'اختطاف توقيتات المواضيع' و'تتبع الزيارة' تعمل بعد 90 ثانية

دعم المنتج

Dmitry_Krasnoperov (Dmitry Krasnoperov) 19 مايو 2019، 1:55م 10

Hi,

I’m in DigitalOcean SSD disk.
Set db_shared_buffers: “3048MB”
Disable plugins one by one.

but I’m still getting this disk activity peaks

الموضوع		الردود	مرات العرض
Discourse installation has been getting slower and slower and slower Self-hosting server-resources	36	2244	15 أبريل 2023
PostgreSQL runaway IO Self-hosting	35	3776	3 مارس 2021
Unusually high CPU usage Self-hosting	31	1455	18 فبراير 2026
Improving Instance Performance (Megatopics, Database Size and Extreme Load) Self-hosting	60	6691	13 أكتوبر 2020
'bundle exec rake db:migrate' taking a long time due to calendar migration Self-hosting	33	1245	5 ديسمبر 2023

لا تزال وظائف 'تحديث آخر ظهور' و'اختطاف توقيتات المواضيع' و'تتبع الزيارة' تعمل بعد 90 ثانية

الموضوعات ذات الصلة