Periodic SQLSTATE[HY000] [2002] Connection refused issues

bkolobara

Hi everyone,

I just moved my Flarum installation to a new server and I'm running into a strange issue. From time to time the server will just return a SQLSTATE[HY000] [2002] Connection refused error. Because it's hard to reproduce I don't have much information on it. I assume that I run into a MySQL DB/php-fpm limit? Should I increase some numbers maybe to work around it. I increased the MySQL max_connections to 250, but this didn't help.

Here is the full stacktrace:

Flarum encountered a boot error (PDOException)
SQLSTATE[HY000] [2002] Connection refused
thrown in /var/www/galactictalk.org/vendor/illuminate/database/Connectors/Connector.php on line 70
PDOException: SQLSTATE[HY000] [2002] Connection refused in /var/www/galactictalk.org/vendor/illuminate/database/Connectors/Connector.php:70
Stack trace:
#0 /var/www/galactictalk.org/vendor/illuminate/database/Connectors/Connector.php(70): PDO->__construct()
#1 /var/www/galactictalk.org/vendor/illuminate/database/Connectors/Connector.php(100): Illuminate\Database\Connectors\Connector->createPdoConnection()
#2 /var/www/galactictalk.org/vendor/illuminate/database/Connectors/Connector.php(50): Illuminate\Database\Connectors\Connector->tryAgainIfCausedByLostConnection()
#3 /var/www/galactictalk.org/vendor/illuminate/database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection()
#4 /var/www/galactictalk.org/vendor/illuminate/database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect()
#5 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}()
#6 /var/www/galactictalk.org/vendor/illuminate/database/Connection.php(956): call_user_func()
#7 /var/www/galactictalk.org/vendor/illuminate/database/Connection.php(938): Illuminate\Database\Connection->getPdo()
#8 /var/www/galactictalk.org/vendor/illuminate/database/Connection.php(918): Illuminate\Database\Connection->getDoctrineConnection()
#9 /var/www/galactictalk.org/vendor/flarum/core/src/Database/Migrator.php(91): Illuminate\Database\Connection->getDoctrineSchemaManager()
#10 [internal function]: Flarum\Database\Migrator->__construct()
#11 /var/www/galactictalk.org/vendor/illuminate/container/Container.php(880): ReflectionClass->newInstanceArgs()
#12 /var/www/galactictalk.org/vendor/illuminate/container/Container.php(717): Illuminate\Container\Container->build()
#13 /var/www/galactictalk.org/vendor/illuminate/container/Container.php(655): Illuminate\Container\Container->resolve()
#14 /var/www/galactictalk.org/vendor/illuminate/container/Container.php(990): Illuminate\Container\Container->make()
#15 /var/www/galactictalk.org/vendor/illuminate/container/Container.php(910): Illuminate\Container\Container->resolveClass()
#16 /var/www/galactictalk.org/vendor/illuminate/container/Container.php(871): Illuminate\Container\Container->resolveDependencies()
#17 /var/www/galactictalk.org/vendor/illuminate/container/Container.php(283): Illuminate\Container\Container->build()
#18 /var/www/galactictalk.org/vendor/illuminate/container/Container.php(832): Illuminate\Container\Container->Illuminate\Container\{closure}()
#19 /var/www/galactictalk.org/vendor/illuminate/container/Container.php(717): Illuminate\Container\Container->build()
#20 /var/www/galactictalk.org/vendor/illuminate/container/Container.php(655): Illuminate\Container\Container->resolve()
#21 /var/www/galactictalk.org/vendor/flarum/core/src/Extension/ExtensionServiceProvider.php(31): Illuminate\Container\Container->make()
#22 [internal function]: Flarum\Extension\ExtensionServiceProvider->Flarum\Extension\{closure}()
#23 /var/www/galactictalk.org/vendor/flarum/core/src/Foundation/Application.php(329): call_user_func()
#24 /var/www/galactictalk.org/vendor/flarum/core/src/Foundation/Application.php(270): Flarum\Foundation\Application->fireAppCallbacks()
#25 /var/www/galactictalk.org/vendor/flarum/core/src/Foundation/InstalledSite.php(150): Flarum\Foundation\Application->boot()
#26 /var/www/galactictalk.org/vendor/flarum/core/src/Foundation/InstalledSite.php(82): Flarum\Foundation\InstalledSite->bootLaravel()
#27 /var/www/galactictalk.org/vendor/flarum/core/src/Http/Server.php(58): Flarum\Foundation\InstalledSite->bootApp()
#28 /var/www/galactictalk.org/vendor/flarum/core/src/Http/Server.php(35): Flarum\Http\Server->safelyBootAndGetHandler()
#29 /var/www/galactictalk.org/public/index.php(26): Flarum\Http\Server->listen()
#30 {main}

Justoverclock

i've found this error when i was trying a new local environment, idk if this help but my issue was my localhost ip, we need to know more about your actual server btw

clarkwinkelmann

can you share more details about the server? Is it a VPS, shared, managed?

bkolobara

clarkwinkelmann It's a VPS: 4 Arm (AArch64) cores with 24 Gb ram.

Running Oracle Linux 8, MySQL 8.0.21 & PHP 7.4.6.

> php flarum info
Flarum core 1.0.0
PHP version: 7.4.6
Loaded extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, pcntl, readline, Reflection, SPL, session, standard, bz2, calendar, ctype, curl, dom, mbstring, fileinfo, ftp, gd, gettext, iconv, json, exif, mysqlnd, PDO, Phar, SimpleXML, sockets, sqlite3, tokenizer, xml, xmlwriter, xsl, mysqli, pdo_mysql, pdo_sqlite, xmlreader, zip
+----------------------+---------+--------+
| Flarum Extensions    |         |        |
+----------------------+---------+--------+
| ID                   | Version | Commit |
+----------------------+---------+--------+
| flarum-flags         | v1.0.0  |        |
| flarum-subscriptions | v1.0.0  |        |
| flarum-tags          | v1.0.0  |        |
| fof-formatting       | 1.0.0   |        |
| flarum-statistics    | v1.0.0  |        |
| flarum-pusher        | v1.0.0  |        |
| flarum-lang-english  | v1.0.0  |        |
| flarum-suspend       | v1.0.0  |        |
| flarum-sticky        | v1.0.0  |        |
| flarum-mentions      | v1.0.0  |        |
| flarum-markdown      | v1.0.0  |        |
| flarum-lock          | v1.0.0  |        |
| flarum-likes         | v1.0.0  |        |
| flarum-emoji         | v1.0.0  |        |
| flarum-approval      | v1.0.0  |        |
| fof-links            | 1.0.0   |        |
| fof-follow-tags      | 1.0.0   |        |
| v17development-seo   | v1.8.0  |        |
+----------------------+---------+--------+
Base URL: https://galactictalk.org
Installation path: /var/www/galactictalk.org
Debug mode: off

I misconfigured my CDN pointing to the server and suddenly everyone became me (admin user), so I needed to revert back to my old installation. But I would still like to get to the bottom of this issue.

Nearata

i'm on windows 10, getting this issue with mysql (8.0.23) only. mariadb (10.5.10) is fine.

Flarum core 1.0.1
PHP version: 7.4.16
Loaded extensions: Core, bcmath, calendar, ctype, date, filter, hash, iconv, json, SPL, pcre, readline, Reflection, session, standard, mysqlnd, tokenizer, zip, zlib, libxml, dom, PDO, openssl, SimpleXML, xml, xmlreader, xmlwriter, curl, fileinfo, gd, intl, mbstring, exif, mysqli, Phar, pdo_mysql, xsl
+----------------------+----------+------------------------------------------+
| Flarum Extensions    |          |                                          |
+----------------------+----------+------------------------------------------+
| ID                   | Version  | Commit                                   |
+----------------------+----------+------------------------------------------+
| flarum-flags         | v1.0.0   |                                          |
| nearata-listen-moe   | dev-main | 1894be97ff5fe3749eb01874a4918abed2a9cc13 |
| flarum-tags          | v1.0.1   |                                          |
| flarum-suspend       | v1.0.0   |                                          |
| flarum-subscriptions | v1.0.0   |                                          |
| flarum-sticky        | v1.0.0   |                                          |
| flarum-statistics    | v1.0.0   |                                          |
| flarum-mentions      | v1.0.0   |                                          |
| flarum-markdown      | v1.0.1   |                                          |
| flarum-lock          | v1.0.0   |                                          |
| flarum-likes         | v1.0.0   |                                          |
| flarum-lang-english  | v1.0.0   |                                          |
| flarum-emoji         | v1.0.0   |                                          |
| flarum-bbcode        | v1.0.0   |                                          |
| flarum-approval      | v1.0.0   |                                          |
+----------------------+----------+------------------------------------------+
Base URL: -
Installation path: -
Debug mode: ON

query in mysqld.log

/api/discussions?include=user%2ClastPostedUser%2Ctags%2CfirstPost&sort&page%5Boffset%5D=0

the flarum logs are like @bkolobara , error 2002.

i tried by upgrading and fresh, same results.