I have trouble with db locks. The worker stops to work and there is no response from the application. This is now the second time that this happens. Any Ideas what's wrong here?
This is what `show processlist` returns
Friendica Support hat dies geteilt.
Matthias Moritz
Als Antwort auf Matthias Moritz • •This is still a issue @Friendica Support
Anyone any idea?
Friendica Support hat dies geteilt.
Raroun
Als Antwort auf Matthias Moritz • • •looks like a client connection is idle but a transaction is still running.
You could add the following to your MySQL.conf file:
interactive_timeout = 60
wait_timeout = 60
This will close open and idle database connections.
Default value is 28800.
It’s worth a try.
You have to restart the MySQL-Service after that.
Matthias Moritz mag das.
Friendica Support hat dies geteilt.