SQLSTATE[42000]: Syntax error or access violation: 1305 SAVEPOINT DOCTRINE_2 does not exist when creating short URL using MariaDB/MySQL

[cesare190]

Shlink version

4.1.0

PHP version

8.3.6

How do you serve Shlink

Docker image

Database engine

MariaDB

Database version

10.11.7

Current behavior

If I try to shorten a long link using the command terminal or the web-app the system returns an error, specifically in the web-app an "unknown error" is shown while the terminal gives some additional information which I report below.

sudo docker exec -it shlink short-url:create

In ExceptionConverter.php line 90:

An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1305 SAVEPOINT DOCTRINE_2 does not exist

In Exception.php line 28:

SQLSTATE[42000]: Syntax error or access violation: 1305 SAVEPOINT DOCTRINE_2 does not exist

In Connection.php line 27:

SQLSTATE[42000]: Syntax error or access violation: 1305 SAVEPOINT DOCTRINE_2 does not exist

I tried to change the version of MariaDB by trying to do downgrades without success. Authentication to the database seems to occur without problems, the redirects assigned to alternative domains to the main one via the respective cli commands and subsequently modifying them via the web-app work correctly. I currently use Nginx Proxy Manager as a reverse proxy.

Expected behavior

Normally I would expect to be able to generate error-free links via the terminal or via the web-app

Minimum steps to reproduce

To create my Shlink environment in Docker you can use this Stack:

version: '3.8'
services:
shlink:
container_name: shlink-web
hostname: shlink-web
image: 'shlinkio/shlink:latest'
restart: unless-stopped
networks:
- webbridge
- default
env_file:
- stack.env

db:
container_name: shlink-db
hostname: shlink-db
image: 'mariadb:lts'
restart: unless-stopped
environment:
MARIADB_ROOT_PASSWORD: ‘rootpassword’
MARIADB_DATABASE: 'shlink'
MARIADB_USER: 'shlink'
MARIADB_PASSWORD: ‘userpassword’
MARIADB_AUTO_UPGRADE: '1'
volumes:
- /var/dockervar/shlink/db:/var/lib/mysql

networks:
default:
driver: bridge
webbridge:
external: true

.env:

DEFAULT_DOMAIN=defaultlink
IS_HTTPS_ENABLED=true
DB_DRIVER=maria
DB_USER=shlink
DB_PASSWORD=userpassword
DB_HOST=shlink-db

Once the two containers have started, it will then be necessary to create an api-key to interact via the web-app. From the terminal this command will return no errors and will work as usual. Instead, creating shortened links should return the error reported above. The way to shorten the links does not change the result but the reason for the error will be returned from the terminal, which does not happen via the web-app.

[acelaya]

Seems to be a bug in Shlink's ORM doctrine/orm#11230. Let's wait for them to fix and I'll release a patch afterwards.

[acelaya]

In the meantime, that issue mentions something about disabling "savepoints" (not sure what that is) in MySQL. Maybe that's something you can try.