Error when running job rebuild-tree: truncate "pageTree" restart identity - could not open relation with OID 16559 #6728
Replies: 5 comments 1 reply
-
Try to restart both the DB server and the app itself |
Beta Was this translation helpful? Give feedback.
-
I'm interested in any leads/ideas |
Beta Was this translation helpful? Give feedback.
-
I am facing a similar issue. Any clues? |
Beta Was this translation helpful? Give feedback.
-
I have the same problem! Logs are full of:
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. |
Beta Was this translation helpful? Give feedback.
-
Hi, facing the same problem rn.
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 |
Beta Was this translation helpful? Give feedback.
-
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:
Any help is appreciated!
Installation info
Installation mode: Docker
Wiki.js version: 2.5.300
PostgreSQL version: 13.12
Beta Was this translation helpful? Give feedback.
All reactions