The Basics
- Nextcloud Server version (e.g., 29.x.x):
30.0.2
- Operating system and version (e.g., Ubuntu 24.04):
Archlinux
- Web server and version (e.g, Apache 2.4.25):
Apache 2.4.62
- Reverse proxy and version _(e.g. nginx 1.27.2)
Linuxserver.io SWAG
- PHP version (e.g, 8.3):
PHP Legacy 8.2.26
- Is this the first time you’ve seen this error? (Yes / No):
Yes
- When did this problem seem to first start?
When I wanted to backup my database before upgrading like I always do.
- Installation method (e.g. AIO, NCP, Bare Metal/Archive, etc.)
Archive
- Are you using Cloudflare, mod_security, or similar? (Yes / No)
No
Summary of the issue you are facing:
As always I tried to backup my database before upgrade using:
mariadb-dump -u root nextcloud >.backup.sql
And the output:
mariadb-dump: Got error: 1030: "Got error 194 "Tablespace is missing for a table" from storage engine InnoDB" when using LOCK TABLES
Then I tried this:
mariadb-check -A --auto-repair -u root
And at the end of output:
Repairing tables
nextcloud.oc_webauthn
Warning : Tablespace is missing for table 'nextcloud/oc_webauthn'
Error : Got error 194 "Tablespace is missing for a table" from storage engine InnoDB
error : Corrupt
I never had the “Two-Factor WebAuthn” app!
Steps to replicate it (hint: details matter!):
Provided in Summery section.
Log entries
Nextcloud.
100 line tail:
Configuration
Nextcloud
occ config:list system:
Apps
occ app:list:
Thanks ^^