After posting here, he ran a few database queries (he suspects there’s a database issue behind it) and asked me to post the dumps here for the ‘experts’.
@Der Pepe (Hubzilla) ⁂@Markus Ouch, that sounds all too familiar, and pinpointing exactly the cause can be quite difficult in my experience at least.
The only thing I see from those dumps is that it seems there's quite a busy feed from relay.fedi.buzz. I'm not able to see whether that is the issue though.
A few things to check: - What's the system load (Run uptime) - How many php-fpm workers are running, are any of them running for a long time? Can you increase the number of workers? - A tool like mytop or pgtop can give you a good idea about what's going on in your db at the moment. - Check the size of the db and the tables over time. If you see that the db or a particular table is growing unexpectedly, that can give you a good hint about what it wrong.
Also feel free to ping the matrix room or irc channel (#hubzilla on libera.chat.) if you're not able to reach the forum.
Markus is currently having massive problems with his hub and can’t really use it at all. He keeps getting a 504 Gateway Timeout.
After posting here, he ran a few database queries (he suspects there’s a database issue behind it) and asked me to post the dumps here for the ‘experts’.
Here you go: Hubzilla_SHOW FULL PROCESSLIST;.txt
The only thing I see from those dumps is that it seems there's quite a busy feed from relay.fedi.buzz. I'm not able to see whether that is the issue though.
A few things to check:
- What's the system load (Run
uptime)- How many php-fpm workers are running, are any of them running for a long time? Can you increase the number of workers?
- A tool like mytop or pgtop can give you a good idea about what's going on in your db at the moment.
- Check the size of the db and the tables over time. If you see that the db or a particular table is growing unexpectedly, that can give you a good hint about what it wrong.
Also feel free to ping the matrix room or irc channel (
#hubzillaon libera.chat.) if you're not able to reach the forum.