SQLSTATE[HY000] [1040] Too many connections | Appwrite | Page 1

barren trout Oct 10, 2023, 8:09 AM

#

After our production release we have a problem handling big traffic
logs from appwrite container:

[Error] Timestamp: 2023-10-10T08:04:18+00:00
[Error] Method: GET
[Error] URL: /v1/databases/:databaseId/collections/:collectionId/documents/:documentId
[Error] Type: PDOException
[Error] Message: SQLSTATE[HY000] [1040] Too many connections
[Error] File: /usr/src/code/app/init.php
[Error] Line: 700
[Error] Timestamp: 2023-10-10T08:04:19+00:00
[Error] Method: GET
[Error] URL: /v1/databases/:databaseId/collections/:collectionId/documents
[Error] Type: PDOException
[Error] Message: SQLSTATE[HY000] [1040] Too many connections
[Error] File: /usr/src/code/app/init.php
[Error] Line: 700
[Error] Timestamp: 2023-10-10T08:04:19+00:00

toxic junco Oct 11, 2023, 2:10 AM

#

barren trout After our production release we have a problem handling big traffic logs from a...

You can try fiddling around with:

_APP_CONNECTIONS_MAX
_APP_POOL_CLIENTS
_APP_SERVER_MULTIPROCESS
_APP_WORKER_PER_CORE

See https://github.com/appwrite/appwrite/blob/8dce3d586284bced9047b62fbcba3c811776d6e7/app/init.php#L641-L650

barren trout Nov 11, 2023, 11:54 AM

#

these are not present in documentation - should I just put them into .env file?

#SQLSTATE[HY000] [1040] Too many connections