The response from Apache Infra to a query from the Fr forum was
Result of my dialog with #asfinfra
[11:15] <@pctony> fr__: this service is technically a community run service
[11:15] <fr__> i don't know what is mean
[11:16] <@pctony> basically it means, in plain english, this is not truly an infra issue.
[11:18] <fr__> well how can we fixed this issue?
[11:20] <@pctony> fr__: I can restart the webservice, but this wont fix the problem! The issue is that MySQL has not been tuned and needs to be. You should contact the OOO community.
We need someone with MYSQL config skills, which I haven't. Any volunteers?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
It may need more analysis than just giving it more connections. Note that the number of connected users reported has remained at 294 since 25 October 2012; on some Forum crash occasions I have noted perhaps 120 Users - a long way off the 294. Perhaps there is some form of slowloris or other denial of service attack taking place.
Other notes remark that the "too many connections error" can arise as a spurious message from from full system logs or insufficient disk space.
Thinking about it, it looks like the connections to the server are never released, at least in some cases. That would explain the growing number of connections, until the limit is reached.
I just assumed that the problem affected more than just us (the problem seems to be something new) and either the Apache folks were looking into it, or that imacat would learn of the problem "somehow".
I guess we should have previously worked out what to do when a problem comes up
acknak wrote:I guess we should have previously worked out what to do when a problem comes up
That's why we had asked for an additional admin on the mailing list, which led to imacat as new admin.
Sorry, I meant a protocol for a situation like this: who would take charge of contacting the admin, and how, since the forum could be off line.
This wasn't needed when Terry was the admin, as he was also using the forum. But now we need some defined way to make sure that the admin knows when there's a problem--and that we can know that it's being looked at.
When I see problems, I send a mail directly to imacat. I fear that Drew has other priorities for the moment. Since nor the dev mailing list nor infra team is of any real support, we are on our own. So imacat is the only one who can help quickly. But due to the different time zone and perhaps her own workload, reactivity is much less good than with Terry.
If someone has some skills with such technical field, we could appoint him admin too.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10