David Dreschner 6656feaf60 fix(Database): Use real idle-timer to prevent lastInsertId being reset on MariaDB/MySQL ...

The previous implementation of the idle timer runs on a strict 30 second interval and sends a dummy `SELECT` statement to keep the connection open.

This generates issues with the `lastInsertId` on long-running tasks (like our CI pipeline), as the MariaDB documentation clearly states:

> If the last query wasn't an INSERT or UPDATE statement or if the modified table does not have a column with the AUTO_INCREMENT attribute and LAST_INSERT_ID was not used, this function will return zero.

Source: https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_insert_id

To mitigate that, this commit now uses a real idle-timer per connection instead.

Assisted-by: ClaudeCode:claude-fable-5
Signed-off-by: David Dreschner <david.dreschner@nextcloud.com>

2026-08-06 12:06:50 +02:00

..

ConnectionActivityConnection.php

…

ConnectionActivityDriver.php

…

ConnectionActivityMiddleware.php

…

ConnectionActivityNotifier.php

…

ConnectionActivityStatement.php

…