Error: Error handler had an error: Pool 'console' is empty
I'm playing with appwrite selfhosted, and tried to stress test it and overload it and got this error when trying to access the console:
{"message":"Error: Error handler had an error: Pool 'console' is empty (size 10)","code":500,"file":"\/usr\/src\/code\/vendor\/utopia-php\/framework\/src\/App.php","line":574,"trace":[{"file":"\/usr\/src\/code\/vendor\/utopia-php\/framework\/src\/App.php","line":705,"function":"execute","class":"Utopia\\App","type":"->","args":[{},{},{}]},{"file":"\/usr\/src\/code\/app\/http.php","line":255,"function":"run","class":"Utopia\\App","type":"->","args":[{},{}]},{"function":"{closure}","args":[{"fd":214,"streamId":0,"header":{"host":"192.168.1.3","user-agent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/131.0.0.0 Safari\/537.36","accept":"*\/*","accept-encoding":"gzip, deflate","accept-language":"en-US,en","content-type":"application\/json","referer":"http:\/\/192.168.1.3\/console\/project-675cb72f00285bae7cf4\/overview\/platforms","sec-gpc":"1","x-appwrite-project":"console","x-appwrite-response-format":"1.6.0","x-fallback-cookies":"{\"a_session_console\":\"xxxxxxxxxxxxxxxx\"}","x-forwarded-for":"10.0.0.2","x-forwarded-host":"192.168.1.3","x-forwarded-port":"80","x-forwarded-proto":"http","x-forwarded-server":"6f099860a213","x-real-ip":"10.0.0.2","x-sdk-language":"web","x-sdk-name":"Console","x-sdk-platform":"console","x-sdk-version":"1.1.0"},"server":{"request_method":"GET","request_uri":"\/v1\/teams\/675cb72c00000883fbf0","path_info":"\/v1\/teams\/675cb72c00000883fbf0","request_time":1735929495,"request_time_float":1735929495.137188,"server_protocol":"HTTP\/1.1","server_port":80,"remote_port":41216,"remote_addr":"10.0.2.14","master_time":1735929495},"cookie":{"a_session_console_legacy":"xxxxxxxxxx"},"get":null,"files":null,"post":null,"tmpfiles":null},{"fd":214,"socket":null,"header":null,"cookie":null,"trailer":null}]}],"version":"1.6.0"}
🧐
does restarting appwrite container help?
What were you stress testing?
Yes
But it will come back if i did the test another time
And it won't go until i restart the containers
Just a simple k6 stress test with 4 stages of 500, 1000, 1500, 0 vu's creating random documents in a collection.
It says pool 'console' is empty (size 10) what does that mean ? And also the api stops responding.
You mean it goes unresponsive?
Yes it crashes and won't respond until i restart the containers
🧐
It could be related to DB pool. What if you increase it by changing the en variable or docker compose file?
No, i already did that i also increased the db max connections.
Nothing worked.
@Steven sorry for the ping but no one have any clues on what is happening.
It's related to database connections. When self hosting, it's on you to scale and tune Appwrite. If you want help, you can sign up for support
Hi @jesus, did you get any support/insights on this? 🙂 Im running into the same issue
I would like to know as well. We have been facing this issue since we moved to 1.8.0. Nothing else in the worfklow has changed, so it must be linked to the migration 1.8
@pgk1124 @whataboutno13 Pls create new post
