Error when running job rebuild-tree: truncate "pageTree" restart identity - could not open relation with OID 16559

[keliansb]

Hello,

I'm facing an issue with my install of Wiki.js, the left menu doesn't load.

The following popup is displayed on the screen:

And I can see the following error on my browser's console:

On container's start, I can see the following logs:

Loading configuration from /wiki/config.yml... OK
DB_PASS_FILE is defined. Will use secret from file.
2023-09-14T16:33:26.062Z [MASTER] info: =======================================
2023-09-14T16:33:26.065Z [MASTER] info: = Wiki.js 2.5.300 =====================
2023-09-14T16:33:26.065Z [MASTER] info: =======================================
2023-09-14T16:33:26.066Z [MASTER] info: Initializing...
2023-09-14T16:33:27.039Z [MASTER] info: Using database driver pg for postgres [ OK ]
2023-09-14T16:33:27.056Z [MASTER] info: Connecting to database...
2023-09-14T16:33:27.093Z [MASTER] info: Database Connection Successful [ OK ]
2023-09-14T16:33:28.147Z [MASTER] warn: Mail is not setup! Please set the configuration in the administration area!
2023-09-14T16:33:28.315Z [MASTER] info: Loading GraphQL Schema...
2023-09-14T16:33:29.655Z [MASTER] info: GraphQL Schema: [ OK ]
2023-09-14T16:33:30.107Z [MASTER] info: HTTP Server on port: [ 3000 ]
2023-09-14T16:33:30.139Z [MASTER] info: HTTP Server: [ RUNNING ]
2023-09-14T16:33:30.337Z [MASTER] info: No new analytics providers found: [ SKIPPED ]
2023-09-14T16:33:30.364Z [MASTER] info: Loaded 21 authentication strategies: [ OK ]
2023-09-14T16:33:30.386Z [MASTER] info: No new comment providers found: [ SKIPPED ]
2023-09-14T16:33:30.416Z [MASTER] info: No new editors found: [ SKIPPED ]
2023-09-14T16:33:30.456Z [MASTER] info: No new loggers found: [ SKIPPED ]
2023-09-14T16:33:30.540Z [MASTER] info: No new renderers found: [ SKIPPED ]
2023-09-14T16:33:30.573Z [MASTER] info: No new search engines found: [ SKIPPED ]
2023-09-14T16:33:30.618Z [MASTER] info: No new storage targets found: [ SKIPPED ]
2023-09-14T16:33:30.619Z [MASTER] info: Checking for installed optional extensions...
2023-09-14T16:33:30.645Z [MASTER] info: Optional extension git is installed. [ OK ]
2023-09-14T16:33:30.661Z [MASTER] info: Optional extension pandoc was not found on this system. [ SKIPPED ]
2023-09-14T16:33:30.676Z [MASTER] info: Optional extension puppeteer was not found on this system. [ SKIPPED ]
2023-09-14T16:33:30.678Z [MASTER] info: Optional extension sharp was not found on this system. [ SKIPPED ]
2023-09-14T16:33:30.686Z [MASTER] info: Authentication Strategy Local: [ OK ]
2023-09-14T16:33:31.856Z [MASTER] info: (COMMENTS/DEFAULT) Initializing...
2023-09-14T16:33:31.857Z [MASTER] info: (COMMENTS/DEFAULT) Initialization completed.
2023-09-14T16:33:31.869Z [MASTER] info: Purging orphaned upload files...
2023-09-14T16:33:31.871Z [MASTER] info: Syncing locales with Graph endpoint...
2023-09-14T16:33:31.873Z [MASTER] info: Fetching latest updates from Graph endpoint...
2023-09-14T16:33:32.005Z [MASTER] info: Purging orphaned upload files: [ COMPLETED ]
Loading configuration from /wiki/config.yml... OK
DB_PASS_FILE is defined. Will use secret from file.
2023-09-14T16:33:32.229Z [MASTER] info: Fetching latest updates from Graph endpoint: [ COMPLETED ]
2023-09-14T16:33:32.275Z [JOB] info: Rebuilding page tree...
2023-09-14T16:33:32.467Z [MASTER] info: Pulled latest locale updates for French from Graph endpoint: [ COMPLETED ]
2023-09-14T16:33:32.650Z [MASTER] info: Pulled latest locale updates for English from Graph endpoint: [ COMPLETED ]
2023-09-14T16:33:32.662Z [MASTER] info: Syncing locales with Graph endpoint: [ COMPLETED ]
2023-09-14T16:33:33.354Z [JOB] info: Using database driver pg for postgres [ OK ]
2023-09-14T16:33:33.463Z [JOB] error: Rebuilding page tree: [ FAILED ]
2023-09-14T16:33:33.463Z [JOB] error: truncate "pageTree" restart identity - could not open relation with OID 16559
2023-09-14T16:33:33.478Z [MASTER] warn: Error when running job rebuild-tree: truncate "pageTree" restart identity - could not open relation with OID 16559

Any help is appreciated!

Installation info

Installation mode: Docker
Wiki.js version: 2.5.300
PostgreSQL version: 13.12

[NGPixel]

Try to restart both the DB server and the app itself

[keliansb]

Already tried, got the same issue

[keliansb]

I'm interested in any leads/ideas

[vpolizzi]

I am facing a similar issue. Any clues?

[abhinavsood]

I have the same problem!

Logs are full of:

Error when running job rebuild-tree: truncate "pageTree" restart identity - relation "pageTree" does not exist
Rebuilding page tree: [ FAILED ]
truncate "pageTree" restart identity - relation "pageTree" does not exist

Connected to the database and see something weird - the table name shows, but get the relation does not exist error:

Wiki has been running in ECS for some time, and the problems started yesterday, out of the blue.

[stiivo]

Hi,

facing the same problem rn.

Loading configuration from /wikicfg/config.yml... OK
2024-05-13T07:23:15.495Z [MASTER] info: =======================================
2024-05-13T07:23:15.498Z [MASTER] info: = Wiki.js 2.5.302 =====================
2024-05-13T07:23:15.498Z [MASTER] info: =======================================
2024-05-13T07:23:15.498Z [MASTER] info: Initializing...
2024-05-13T07:23:16.741Z [MASTER] info: Using database driver pg for postgres [ OK ]
2024-05-13T07:23:16.756Z [MASTER] info: Connecting to database...
2024-05-13T07:23:16.787Z [MASTER] info: Database Connection Successful [ OK ]
2024-05-13T07:23:18.112Z [MASTER] warn: Mail is not setup! Please set the configuration in the administration area!
2024-05-13T07:23:18.438Z [MASTER] info: Loading GraphQL Schema...
2024-05-13T07:23:19.480Z [MASTER] info: GraphQL Schema: [ OK ]
2024-05-13T07:23:19.791Z [MASTER] info: HTTP Server on port: [ 3000 ]
2024-05-13T07:23:19.809Z [MASTER] info: HTTP Server: [ RUNNING ]
2024-05-13T07:23:20.036Z [MASTER] info: No new analytics providers found: [ SKIPPED ]
2024-05-13T07:23:20.064Z [MASTER] info: Loaded 21 authentication strategies: [ OK ]
2024-05-13T07:23:20.100Z [MASTER] info: No new comment providers found: [ SKIPPED ]
2024-05-13T07:23:20.146Z [MASTER] info: No new editors found: [ SKIPPED ]
2024-05-13T07:23:20.217Z [MASTER] info: No new loggers found: [ SKIPPED ]
2024-05-13T07:23:20.353Z [MASTER] info: No new renderers found: [ SKIPPED ]
2024-05-13T07:23:20.407Z [MASTER] info: No new search engines found: [ SKIPPED ]
2024-05-13T07:23:20.485Z [MASTER] info: No new storage targets found: [ SKIPPED ]
2024-05-13T07:23:20.486Z [MASTER] info: Checking for installed optional extensions...
2024-05-13T07:23:20.497Z [MASTER] info: Optional extension git is installed. [ OK ]
2024-05-13T07:23:20.502Z [MASTER] info: Optional extension pandoc was not found on this system. [ SKIPPED ]
2024-05-13T07:23:20.506Z [MASTER] info: Optional extension puppeteer was not found on this system. [ SKIPPED ]
2024-05-13T07:23:20.508Z [MASTER] info: Optional extension sharp was not found on this system. [ SKIPPED ]
2024-05-13T07:23:20.512Z [MASTER] info: Authentication Strategy Local: [ OK ]
2024-05-13T07:23:20.527Z [MASTER] info: Authentication Strategy Login mit Wilai GmbH: [ OK ]
2024-05-13T07:23:21.347Z [MASTER] info: (COMMENTS/DEFAULT) Initializing...
2024-05-13T07:23:21.348Z [MASTER] info: (COMMENTS/DEFAULT) Initialization completed.
2024-05-13T07:23:21.363Z [MASTER] info: Purging orphaned upload files...
2024-05-13T07:23:21.363Z [MASTER] warn: Skipping job syncGraphLocales because offline mode is enabled. [SKIPPED]
2024-05-13T07:23:21.363Z [MASTER] warn: Skipping job syncGraphUpdates because offline mode is enabled. [SKIPPED]
2024-05-13T07:23:21.387Z [MASTER] info: Purging orphaned upload files: [ COMPLETED ]
Loading configuration from /wikicfg/config.yml... OK
2024-05-13T07:23:21.736Z [JOB] info: Rebuilding page tree...
2024-05-13T07:23:22.556Z [JOB] info: Using database driver pg for postgres [ OK ]
2024-05-13T07:23:22.612Z [JOB] error: Rebuilding page tree: [ FAILED ]
2024-05-13T07:23:22.613Z [JOB] error: truncate "pageTree" restart identity - relation "pageTree" does not exist
2024-05-13T07:23:22.624Z [MASTER] warn: Error when running job rebuild-tree: truncate "pageTree" restart identity - relation "pageTree" does not exist

EDIT: Well, the table was indeed not existing. I went the upgrade path from postgres 11 to 16. Maybe there went something wrong on this way. I was able to fix my problem by applying the following command directly to the postgres database of my wikijs instance.

CREATE TABLE "public"."pageTree" (
    "id" INTEGER PRIMARY KEY,
    "path" VARCHAR NOT NULL,
    "depth" INTEGER NOT NULL CHECK ("depth" >= 0),
    "title" VARCHAR NOT NULL,
    "isPrivate" BOOLEAN NOT NULL DEFAULT false,
    "isFolder" BOOLEAN NOT NULL DEFAULT false,
    "privateNS" VARCHAR,
    "parent" INTEGER,
    "pageId" INTEGER,
    "localeCode" CHAR(5),
    "ancestors" JSON,
    FOREIGN KEY ("parent") REFERENCES "public"."pageTree"("id") ON DELETE CASCADE,
    FOREIGN KEY ("pageId") REFERENCES "public"."pages"("id") ON DELETE CASCADE,
    FOREIGN KEY ("localeCode") REFERENCES "public"."locales"("code")
);

After applying you can go to your admin panel to Utilities -> Content -> Rebuild Page Tree and its working again!

Im not 100% sure if this is the right schema but i went from the knex definitions to this. Maybe this can help someone.

thanks