I am currently testing around with realtime. I setup a second server with Dragonfly instead of Redis and I am now performance and stress testing a bit. But doing so the main Appwrite server gets kind of overwelmed even though the Dragonfly Server is kind of chilling its life. Furthermore the Realtime container is screaming errors in my face like:
TypeScript
Fatal error: Uncaught Swoole\Error: Socket#115 has already been bound to another coroutine#3, reading of the same socket in coroutine#8 at the same time is not allowed in /usr/src/code/app/init.php:861
Stack trace:
#0 /usr/src/code/app/init.php(861): PDO->__construct('mysql:host=mari...', 'user', Object(SensitiveParameterValue), Array)
#1 @swoole/library/core/Database/PDOProxy.php(33): {closure}()
#2 /usr/src/code/app/init.php(860): Swoole\Database\PDOProxy->__construct(Object(Closure))
#3 /usr/src/code/app/init.php(888): {closure}()
#4 /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php(189): {closure}()
#5 /usr/src/code/app/realtime.php(90): Utopia\Pools\Pool->pop()
#6 /usr/src/code/app/realtime.php(456): getProjectDB(Object(Utopia\Database\Document))
#7 [internal function]: {closure}(70136, Object(Appwrite\Utopia\Request))
#8 /usr/src/code/vendor/utopia-php/websocket/src/WebSocket/Adapter/Swoole.php(93): call_user_func(Object(Closure), 70136, Object(Swoole\Http\Request))
#9 [internal function]: Utopia\WebSocket\Adapter\Swoole->Utopia\WebSocket\Adapter\{closure}(Object(Swoole\WebSocket\Server), Object(Swoole\Http\Request))
#10 {main}
thrown in /usr/src/code/app/init.php on line 861
Sometimes:
TypeScript
[Error] Message: Missing or unknown project ID
Connection open (user: 71435)
[Error] File: /usr/src/code/app/realtime.php
[Error] Line: 445
Pub/sub connection established (worker: 0)
[Error] Type: Exception
[Error] Type: Exception
[Error] Type: Exception
[Error] Type: Exception
[Error] Type: Exception
[Error] Type: Exception
[Error] Type: Exception
[Error] Type: Exception
[Error] Type: Exception
[Error] Type: Exception
[Error] Type: Exception
[Error] Type: Exception
[Error] Type: Exception
[Error] Type: Exception
[Error] Type: Exception
[Error] Type: Exception
[Error] Type: Exception
[Error] Type: Exception
[Error] Type: Exception
[Error] Type: Exception
[Error] Type: Exception
or:
TypeScript
[2024-06-28 15:44:11 $7.0] WARNING Server::check_worker_exit_status(): worker(pid=11585, id=21) abnormal exit, status=255, signal=0
Connection open (user: 71827)
Connection open (user: 71590)
[Error] Message: SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.
[Error] Message: SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.
[Error] Message: Missing or unknown project ID
TL;DR
Developers encountering various error messages in Realtime container such as pool size issues, abnormal worker exits, unbuffered queries, and unknown project IDs. The issue might be related to conflicting coroutines or missing project identifier. Check socket bindings, handle unbuffered queries properly, and ensure all project IDs are valid in the code. Additionally, consider reporting bugs to Swoole developers for potential fixes.or
TypeScript
[Error] Type: Exception
[Error] Type: Exception
Connection open (user: 70481)
[Error] Type: Exception
[Error] Type: Exception
[Error] Type: Exception
Connection open (user: 70475)
[Error] Type: Exception
Connection open (user: 70474)
[Error] Type: Exception
Connection open (user: 71636)
[Error] File: @swoole/library/core/Database/PDOStatementProxy.php
[Error] File: @swoole/library/core/Database/PDOStatementProxy.php
[Error] File: /usr/src/code/app/realtime.php
[Error] Message: Pool 'cache_redis_main' is empty (size 10)
[Error] Message: Pool 'cache_redis_main' is empty (size 10)
[Error] Message: Pool 'cache_redis_main' is empty (size 10)
[Error] Message: Pool 'cache_redis_main' is empty (size 10)
[Error] Message: Pool 'cache_redis_main' is empty (size 10)
[Error] Message: Pool 'cache_redis_main' is empty (size 10)
[Error] Message: Pool 'cache_redis_main' is empty (size 10)
or
TypeScript
Connection open (user: 71994)
[2024-06-28 15:44:11 $7.0] WARNING Server::check_worker_exit_status(): worker(pid=11619, id=11) abnormal exit, status=0, signal=11
A bug occurred in Swoole-v5.1.2, please report it.
The Swoole developers probably don't know about it,
and unless you report it, chances are it won't be fixed.
You can read How to report a bug doc before submitting any bug reports:
>> https://github.com/swoole/swoole-src/blob/master/.github/ISSUE.md
Please do not send bug reports in the mailing list or personal letters.
The issue page is also suitable to submit feature requests.
OS: Linux 6.8.0-31-generic #31-Ubuntu SMP PREEMPT_DYNAMIC Sat Apr 20 00:40:06 UTC 2024 x86_64
GCC_VERSION: 13.2.1 20231014
OPENSSL_VERSION: OpenSSL 3.1.4 24 Oct 2023
PHP_VERSION : 8.3.3
or
TypeScript
big red blocks of:
TypeScript
[Error] Message: Pool 'cache_redis_main' is empty (size 10)
[Error] Message: Pool 'cache_redis_main' is empty (size 10)
[Error] Message: Pool 'cache_redis_main' is empty (size 10)
[Error] Message: Pool 'cache_redis_main' is empty (size 10)
[Error] Message: Pool 'cache_redis_main' is empty (size 10)
[Error] Message: Pool 'cache_redis_main' is empty (size 10)
[Error] Message: Pool 'cache_redis_main' is empty (size 10)
[Error] Message: Pool 'cache_redis_main' is empty (size 10)
[Error] Message: Pool 'cache_redis_main' is empty (size 10)
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
Connection open (user: 72346)
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] File: /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php
[Error] Line: 174
[Error] Line: 174
[Error] Line: 174
[Error] Line: 174
[Error] Line: 174
[Error] Line: 174
[Error] Line: 174
[Error] Line: 174
[Error] Line: 174
xD
Recommended threads
- How to use dart workspaces to deploy a f...
Hello, I'm developing a Flutter application and I would like to leverage dart pub workspaces to deploy a function with a dart runtime as advertised here : http...
- Migration from Cloud to Self-Hosted not ...
Hello Appwrite Community, I've got the problem, that when I try to migrate my Appwrite Project from the cloud to my self-hosted Appwrite, that an API Key is mi...
- I can't migrate my project from Appwrite...
I'm having an issue migrating my Appwrite project to a self-hosted instance. The problem is that I've exceeded my read rate limit (or database read limit), so I...
