Richdocument app upgrade failure - Error on rename of './nextcloud/oc_richdocuments_wopi'

[reetp]

Describe the bug
After (succesfully) upgrading nextcloud from 31.0.13 to 31.0.14 I was asked to upgrade the app.

Whilst upgrading via the web updater an error was thrown and I was unable to complete the update.

 "Message": "SQLSTATE[HY000]: General error: 1025 Error on rename of './nextcloud/oc_richdocuments_wopi' to './nextcloud/#sql-backup-8e3-4353' (errno: 168 \"Unknown (generic) error from engine\")",

From a terminal I managed to turn maintenance mode off and disable the app. Any attempt at upgrade throws the same error.

Expected behavior
The app to update without breaking the system and leaving it in maintenance mode.

Server details

Operating system:
Rocky v8

Web server:
Apache

Database:
MariaDB-server-11.4.10-1.el8.x86_64

PHP version:
PHP 8.3

Nextcloud version:
31.0.13/31.0.14

Version of the richdocuments app

Disabled:

• richdocuments: 8.7.8 (installed 8.7.7)

Version of Collabora Online
collaboraoffice-25.04.9-1.x86_64

Configuration of the richdocuments app

{
    "apps": {
        "richdocuments": {
            "disable_certificate_verification": "",
            "enabled": "no",
            "installed_version": "8.7.7",
            "public_wopi_url": "https:\/\/collabora.mydomain.net",
            "types": "filesystem,prevent_group_restriction",
            "wopi_url": "https:\/\/collabora.mydomain.net"
        }
    }
}

Logs attached

nextcloud.log.txt

nextcloud-updater.log.txt

[reetp]

I managed t keep this whichj I originally saw on the updater page.

Exception: Database error when running migration 10000Date20251217143558 for app richdocuments An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1025 Error on rename of './nextcloud/oc_richdocuments_wopi' to './nextcloud/#sql-backup-8e3-42a5' (errno: 168 "Unknown (generic) error from engine")

Detailed logs 
Preparing update

Set log level to debug

Turned on maintenance mode

Repair step: Repair MySQL collation

Repair info: All tables already have the correct collation -> nothing to do

Repair step: Copy data from accounts table when migrating from ownCloud

Repair step: Drop account terms table when migrating from ownCloud

Updating database schema

Updated database

Exception: Database error when running migration 10000Date20251217143558 for app richdocuments An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1025 Error on rename of './nextcloud/oc_richdocuments_wopi' to './nextcloud/#sql-backup-8e3-42a5' (errno: 168 "Unknown (generic) error from engine")

The update was unsuccessful. Please report this issue to the Nextcloud community.