Error lastval not supported for session created by connection manager in

[pujagarg17]

Application

Shlink

Application version

4.4.0

How do you serve the application

Other (explain in summary)

Database engine (if any)

None

Edit by maintainer: Postgres

Database version

No response

Summary

[2025-08-07T07:16:55.322162+00:00] [b1bbb91e-ac13-424f-a009-c55d5d520e87] Shlink.ERROR - PDOException: SQLSTATE[55000]: Object not in prerequisite state: 7 ERROR: lastval not supported for session created by connection manager in /Users/pujgarg/Projects/bitbucket/web-shlink/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:74
Stack trace:
#0 /Users/pujgarg/Projects/bitbucket/web-shlink/vendor/doctrine/dbal/src/Driver/PDO/Connection.php(74): PDO->lastInsertId()
#1 /Users/pujgarg/Projects/bitbucket/web-shlink/vendor/doctrine/dbal/src/Connection.php(912): Doctrine\DBAL\Driver\PDO\Connection->lastInsertId()
#2 /Users/pujgarg/Projects/bitbucket/web-shlink/vendor/doctrine/orm/src/Id/BigIntegerIdentityGenerator.php(18): Doctrine\DBAL\Connection->lastInsertId()
#3 /Users/pujgarg/Projects/bitbucket/web-shlink/vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php(254): Doctrine\ORM\Id\BigIntegerIdentityGenerator->generateId(Object(Doctrine\ORM\EntityManager), Object(Shlinkio\Shlink\Core\ShortUrl\Entity\ShortUrl))

[acelaya]

1. You say database is "None", which is obviously not possible. A quick google search shows this error can happen in Postgres (I edited your message).
2. Database version: Also no response provided here, but that's very important information to investigate the issue, so which is it?
3. You did not provide any context of what lead you to see this error. A detailed description and steps to reproduce would be helpful.
4. On top of the above, you did not explain the consequences of this error. Is it making something "crash", or you just saw this in the logs and decided to report it, but has no impact to end users?
5. Provided exception trace is incomplete, and only includes a couple of affected lines in vendor code. It would be good to include the full stack trace, to know where in Shlink code this is happening.

[pujagarg17]

Regarding database I am using Yugabyte DB where connection pooling was enabled
and also when trying to create a short url this error is coming and getting 500 internal server error when the system trying to generate ID (primary key) for the short url record from the last session .
but when we disabled the connection pooling on yugabyte db it started working, i was able to create short url and also I am not bale to see detailed logs on my UAT env when deployed the app via azure app service this error then I saw while running the repo in my local, can u please help me to check what we are doing in the code which is causing this issue while generating the id with connection pooling enabled