Randomly happening PDOException: SQLSTATE[HY000]: General error: 7 server closed the connection unexpectedly

[panki]

How Shlink is set-up

• Shlink Version: stable (3.3.2)
• PHP Version: x.y.z
• How do you serve Shlink: Docker container created from official dockerhub image (tag: stable)
• Database engine used: PostgreSQL 14.2 on aarch64-unknown-linux-musl, compiled by gcc (Alpine 10.3.1_git20211027) 10.3.1 20211027, 64-bit also running in docker

Summary

Everything works well, but periodically I receive 500 error, the same also happens on production with the same shlink version and PostgreSQL 11.16, compiled by Visual C++ build 1800, 64-bit.

No other services experience any problems with postgres, I'm 100% sure it doesn't drop connections.

Shlink container logs:

local-dev-url-shortener-1  | [2022-12-15T18:11:44.081153+00:00] [94490011-9de4-4e8e-8284-cf9afb7a408d] Access.ERROR - - "POST /rest/v3/short-urls HTTP/1.1" 500 143
local-dev-url-shortener-1  | [2022-12-15T18:11:45.548765+00:00] [77b546b8-86ef-4e67-865c-307168ad2894] Shlink.ERROR - PDOException: SQLSTATE[HY000]: General error: 7 server closed the connection unexpectedly
local-dev-url-shortener-1  | 	This probably means the server terminated abnormally
local-dev-url-shortener-1  | 	before or while processing the request. in /etc/shlink/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134
local-dev-url-shortener-1  | Stack trace:
local-dev-url-shortener-1  | #0 /etc/shlink/vendor/doctrine/dbal/src/Driver/PDO/Statement.php(134): PDOStatement->execute(NULL)
local-dev-url-shortener-1  | #1 /etc/shlink/vendor/doctrine/dbal/src/Connection.php(1063): Doctrine\DBAL\Driver\PDO\Statement->execute()
local-dev-url-shortener-1  | #2 /etc/shlink/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(750): Doctrine\DBAL\Connection->executeQuery('SELECT t0.id AS...', Array, Array)
local-dev-url-shortener-1  | #3 /etc/shlink/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(241): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(Array, NULL, NULL, Array, NULL, 1, NULL)
local-dev-url-shortener-1  | #4 /etc/shlink/module/Rest/src/Service/ApiKeyService.php(85): Doctrine\ORM\EntityRepository->findOneBy(Array)
local-dev-url-shortener-1  | #5 /etc/shlink/module/Rest/src/Service/ApiKeyService.php(52): Shlinkio\Shlink\Rest\Service\ApiKeyService->getByKey('test-api-key')
local-dev-url-shortener-1  | #6 /etc/shlink/module/Rest/src/Middleware/AuthenticationMiddleware.php(47): Shlinkio\Shlink\Rest\Service\ApiKeyService->check('test-api-key')
local-dev-url-shortener-1  | #7 /etc/shlink/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(27): Shlinkio\Shlink\Rest\Middleware\AuthenticationMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #8 /etc/shlink/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #9 /etc/shlink/module/Rest/src/Middleware/BodyParserMiddleware.php(35): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
local-dev-url-shortener-1  | #10 /etc/shlink/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(27): Shlinkio\Shlink\Rest\Middleware\BodyParserMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #11 /etc/shlink/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #12 /etc/shlink/vendor/mezzio/mezzio-router/src/Middleware/ImplicitOptionsMiddleware.php(72): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
local-dev-url-shortener-1  | #13 /etc/shlink/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(27): Mezzio\Router\Middleware\ImplicitOptionsMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #14 /etc/shlink/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #15 /etc/shlink/module/Rest/src/Middleware/ErrorHandler/BackwardsCompatibleProblemDetailsHandler.php(22): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
local-dev-url-shortener-1  | #16 /etc/shlink/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(27): Shlinkio\Shlink\Rest\Middleware\ErrorHandler\BackwardsCompatibleProblemDetailsHandler->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #17 /etc/shlink/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #18 /etc/shlink/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
local-dev-url-shortener-1  | #19 /etc/shlink/vendor/laminas/laminas-stratigility/src/Middleware/PathMiddlewareDecorator.php(60): Laminas\Stratigility\MiddlewarePipe->process(Object(Laminas\Diactoros\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
local-dev-url-shortener-1  | #20 /etc/shlink/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\PathMiddlewareDecorator->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #21 /etc/shlink/vendor/laminas/laminas-stratigility/src/Next.php(42): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
local-dev-url-shortener-1  | #22 /etc/shlink/vendor/mezzio/mezzio-router/src/Middleware/ImplicitHeadMiddleware.php(76): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
local-dev-url-shortener-1  | #23 /etc/shlink/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(27): Mezzio\Router\Middleware\ImplicitHeadMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #24 /etc/shlink/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #25 /etc/shlink/vendor/mezzio/mezzio-router/src/Middleware/RouteMiddleware.php(50): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
local-dev-url-shortener-1  | #26 /etc/shlink/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(27): Mezzio\Router\Middleware\RouteMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #27 /etc/shlink/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #28 /etc/shlink/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
local-dev-url-shortener-1  | #29 /etc/shlink/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\MiddlewarePipe->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #30 /etc/shlink/vendor/laminas/laminas-stratigility/src/Next.php(42): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
local-dev-url-shortener-1  | #31 /etc/shlink/vendor/shlinkio/shlink-common/src/Middleware/CloseDbConnectionMiddleware.php(24): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
local-dev-url-shortener-1  | #32 /etc/shlink/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(27): Shlinkio\Shlink\Common\Middleware\CloseDbConnectionMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #33 /etc/shlink/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #34 /etc/shlink/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
local-dev-url-shortener-1  | #35 /etc/shlink/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\MiddlewarePipe->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #36 /etc/shlink/vendor/laminas/laminas-stratigility/src/Middleware/PathMiddlewareDecorator.php(122): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
local-dev-url-shortener-1  | #37 /etc/shlink/vendor/laminas/laminas-stratigility/src/Next.php(42): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Laminas\Diactoros\ServerRequest))
local-dev-url-shortener-1  | #38 /etc/shlink/vendor/mezzio/mezzio-problem-details/src/ProblemDetailsMiddleware.php(47): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
local-dev-url-shortener-1  | #39 /etc/shlink/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(27): Mezzio\ProblemDetails\ProblemDetailsMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #40 /etc/shlink/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #41 /etc/shlink/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
local-dev-url-shortener-1  | #42 /etc/shlink/vendor/laminas/laminas-stratigility/src/Middleware/PathMiddlewareDecorator.php(60): Laminas\Stratigility\MiddlewarePipe->process(Object(Laminas\Diactoros\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
local-dev-url-shortener-1  | #43 /etc/shlink/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\PathMiddlewareDecorator->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #44 /etc/shlink/vendor/laminas/laminas-stratigility/src/Next.php(42): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
local-dev-url-shortener-1  | #45 /etc/shlink/module/Rest/src/Middleware/CrossDomainMiddleware.php(24): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
local-dev-url-shortener-1  | #46 /etc/shlink/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(27): Shlinkio\Shlink\Rest\Middleware\CrossDomainMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #47 /etc/shlink/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #48 /etc/shlink/vendor/laminas/laminas-stratigility/src/Middleware/ErrorHandler.php(129): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
local-dev-url-shortener-1  | #49 /etc/shlink/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(27): Laminas\Stratigility\Middleware\ErrorHandler->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #50 /etc/shlink/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #51 /etc/shlink/vendor/php-middleware/request-id/src/RequestIdMiddleware.php(32): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
local-dev-url-shortener-1  | #52 /etc/shlink/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(27): PhpMiddleware\RequestId\RequestIdMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #53 /etc/shlink/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #54 /etc/shlink/vendor/shlinkio/shlink-common/src/Middleware/ContentLengthMiddleware.php(24): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
local-dev-url-shortener-1  | #55 /etc/shlink/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(27): Shlinkio\Shlink\Common\Middleware\ContentLengthMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #56 /etc/shlink/vendor/laminas/laminas-stratigility/src/Next.php(49): Mezzio\Middleware\LazyLoadingMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #57 /etc/shlink/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
local-dev-url-shortener-1  | #58 /etc/shlink/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\MiddlewarePipe->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
local-dev-url-shortener-1  | #59 /etc/shlink/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
local-dev-url-shortener-1  | #60 /etc/shlink/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\EmptyPipelineHandler))
local-dev-url-shortener-1  | #61 /etc/shlink/vendor/mezzio/mezzio-swoole/src/Event/RequestHandlerRequestListener.php(109): Laminas\Stratigility\MiddlewarePipe->handle(Object(Laminas\Diactoros\ServerRequest))
local-dev-url-shortener-1  | #62 /etc/shlink/vendor/mezzio/mezzio-swoole/src/Event/EventDispatcher.php(36): Mezzio\Swoole\Event\RequestHandlerRequestListener->__invoke(Object(Mezzio\Swoole\Event\RequestEvent))
local-dev-url-shortener-1  | #63 /etc/shlink/vendor/mezzio/mezzio-swoole/src/SwooleRequestHandlerRunner.php(147): Mezzio\Swoole\Event\EventDispatcher->dispatch(Object(Mezzio\Swoole\Event\RequestEvent))
local-dev-url-shortener-1  | #64 [internal function]: Mezzio\Swoole\SwooleRequestHandlerRunner->onRequest(Object(Swoole\Http\Request), Object(Swoole\Http\Response))
local-dev-url-shortener-1  | #65 {main}

[panki]

Configuration used to run the service:

      DEFAULT_DOMAIN: example.com
      IS_HTTPS_ENABLED: "false"
      GEOLITE_LICENSE_KEY:
      DEFAULT_SHORT_CODES_LENGTH: 6
      PORT: 8881
      WEB_WORKER_NUM: 4
      TASK_WORKER_NUM: 4
      INITIAL_API_KEY: test-api-key
      DB_DRIVER: postgres
      DB_NAME: shlink
      DB_USER: postgres
      DB_HOST: postgres
      DB_PORT: 5432
      DISABLE_TRACKING: "true"
      DISABLE_IP_TRACKING: "true"
      DISABLE_REFERRER_TRACKING: "true"
      DISABLE_UA_TRACKING: "true"
      ANONYMIZE_REMOTE_ADDR: "true"
      SKIP_INITIAL_GEOLITE_DOWNLOAD: "true"

[panki]

Also have tried to use the latest vesrion, the same problem.

[SenorKarlos]

I'm having the same issue using stable tag with MySQL database, and similarly can vouch for the DB stability & overall docker environment stability. I'm going to dump the database and try going back a few version tags.

[acelaya]

@panki can you open a bug report referencing this discussion? This might be an actual bug, but I accidentally overlooked it.

If I remember correctly, this same issue happened long ago, when support for swoole was first introduced.

The problem back then was that database connections could potentially expire if there's no activity for a couple of hours in one specific worker.

The database abstraction layer still assumes the classic PHP approach, in which everything is bootstrapped on every request, so they don't handle expired connections, but that's not the case with swoole, openswoole and roadrunner.

The way this was originally approached was by explicitly closing the connection after ever request, and opening it back at the beginning of the next one, if it's not open yet.

I'm wondering if there's some situation in which the connection is not being properly closed, and since you have disabled any kind of tracking, there's less interaction with the database in general, increasing the chances for the connection to expire due to inactivity, and causing this errors randomly.

I will dig further.

[panki]

Sure, I will create a bug report. The only difference with the error you described is it happens mostly right after a fresh start.

[acelaya]

Hmmm. In that case it's not an expired connection.

Let's continue the conversation in the issue once I've had a chance to dig further.

[SenorKarlos]

I went back as far as 3.30 to get the web client to connect (using the free hosted one) but I cannot create a short link nor view domains on it. Visiting the subdomain url I have configured at least now produces a 404 page from shlink and not cloudflare gateway error. I feel like the docker setup is missing something to make it work properly, but I am new to this software entirely. Not having a great introduction lol

no longer seeing sql went away errors but constant 'abnormal exit' warnings every page access of the UI. My database also does not have a 'default domain' despite being set in my docker compose environment

[acelaya]

@SenorKarlos please, try not to mix topics.

[khanh-momos]

I'm having the same issue with the stable version (v4.4.0) right now, anyone has a resolution so far?

[acelaya]

Can you elaborate a bit? Do you see this error frequently? Is it causing service downtimes, or you simply noticed it in the logs from time to time?

Does it happen mainly when the service starts/scales-up? The original reporter mentioned that's how it happened for him #1636 (reply in thread)

[khanh-momos]

hey @acelaya, this is very frequent (look into the log and I mostly saw the error message)

2025-01-07T17:35:02.422+07:00
PDOException: SQLSTATE[HY000]: General error: 7 no connection to the server in /etc/shlink/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:55
2025-01-07T17:35:02.422+07:00
Stack trace:
2025-01-07T17:35:02.422+07:00
#0 /etc/shlink/vendor/doctrine/dbal/src/Driver/PDO/Statement.php(55): PDOStatement->execute()
2025-01-07T17:35:02.422+07:00
#1 /etc/shlink/vendor/doctrine/dbal/src/Connection.php(772): Doctrine\DBAL\Driver\PDO\Statement->execute()
2025-01-07T17:35:02.422+07:00
#2 /etc/shlink/vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php(938): Doctrine\DBAL\Connection->executeQuery('SELECT t0.id AS...', Array, Array)
2025-01-07T17:35:02.422+07:00
#3 /etc/shlink/vendor/doctrine/orm/src/EntityRepository.php(110): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll(Array, Array, 15, NULL)
2025-01-07T17:35:02.422+07:00
#4 /etc/shlink/module/Core/src/Geolocation/GeolocationDbUpdater.php(59): Doctrine\ORM\EntityRepository->findBy(Array, Array, 15)
2025-01-07T17:35:02.422+07:00
#5 /etc/shlink/module/Core/src/Geolocation/GeolocationDbUpdater.php(47): Shlinkio\Shlink\Core\Geolocation\GeolocationDbUpdater->downloadIfNeeded(Object(Shlinkio\Shlink\Core\Geolocation\GeolocationDownloadProgressHandlerInterface@anonymous))
2025-01-07T17:35:02.422+07:00
#6 /etc/shlink/module/Core/src/EventDispatcher/UpdateGeoLiteDb.php(30): Shlinkio\Shlink\Core\Geolocation\GeolocationDbUpdater->checkDbUpdate(Object(Shlinkio\Shlink\Core\Geolocation\GeolocationDownloadProgressHandlerInterface@anonymous))
2025-01-07T17:35:02.422+07:00
#7 /etc/shlink/vendor/shlinkio/shlink-event-dispatcher/src/RoadRunner/RoadRunnerTaskConsumerToListener.php(52): Shlinkio\Shlink\Core\EventDispatcher\UpdateGeoLiteDb->__invoke(Object(Shlinkio\Shlink\Core\EventDispatcher\Event\UrlVisited))
2025-01-07T17:35:02.422+07:00
#8 /etc/shlink/bin/roadrunner-worker.php(32): Shlinkio\Shlink\EventDispatcher\RoadRunner\RoadRunnerTaskConsumerToListener->listenForTasks(Object(Closure))
2025-01-07T17:35:02.422+07:00
#9 /etc/shlink/bin/roadrunner-worker.php(36): {closure:/etc/shlink/bin/roadrunner-worker.php:13}()
2025-01-07T17:35:02.422+07:00
#10 {main}

I'm hosting this one on ECS (using stable version) and using PostgreSQL as the DB

[acelaya]

Have you tried googling for that just in case it's something that can be fixed by tweaking the database server configuration?

[acelaya]

All I'm seeing on "the internet" for this problem seems to point in the direction of "network issues" or connection timeouts.

Some also mention potential database server crashes, but I doubt it's that.

Perhaps the fact that the docker image is alpine-based is related. I know those have known DNS/network issues, although I would expect a different error if it was DNS-related.

[acelaya]

@khanh-momos can you share how do you pass the database host to Shlink? Do you use a AWS URL including the domain name?