Error when running job rebuild-tree: truncate pageTree

[Keith-Barrett]

Hello Experts,

I have been using wikijs without issue for quite a while. Very happy and very greatful for all the work ye do to provide such a product for free. So thank you.

Something happened yesterday which resulted in an issue with the pageTree table and has resulted in it becomming corrupted.

2025-12-05T10:47:32.415Z [JOB] info: Rebuilding page tree... 2025-12-05T10:47:32.651Z [JOB] info: Using database driver mysql2 for mariadb [ OK ] 2025-12-05T10:47:32.673Z [JOB] error: Rebuilding page tree: [ FAILED ] 2025-12-05T10:47:32.673Z [JOB] error: truncate pageTree- Got error 194 "Tablespace is missing for a table" from storage engine InnoDB 2025-12-05T10:47:32.679Z [MASTER] warn: Error when running job rebuild-tree: truncatepageTree - Got error 194 "Tablespace is missing for a table" from storage engine InnoDB 2025-12-05T10:47:32.719Z [MASTER] info: Fetching latest updates from Graph endpoint: [ COMPLETED ]

I have tried restoring the database -> wikijs DB objects back via a restore but that unfortuatly did not resolve or change the issue, the pageTree corruption remained the same :

Could anyone with some more knowledge guide my or point me in the right direction so I can resolve this issue please? I have seen some suggestions that dropping and rebuilding may help but I am not sure how to complete such steps.

Thank you kindly for any guidence.

Kind Regards.

[Keith-Barrett]

I just now found some suggestions which are specific to the DB issue of Missing TABLESPACE where we can import the TABLESPACE :

I dont want to be doing anything without some idea of the cost and any possible breaking changes but would dropping these 'Secondary Indexes' and then trying to import the TABLESPACE by a possible fix?