search

baptisteArno / typebot.io

💬 Typebot is a powerful chatbot builder that you can self-host.
https://typebot.io
Other
6.41k stars 1.7k forks source link

Error during typebot publishing #1624

Closed marciotisouza closed 2 weeks ago

marciotisouza commented 3 weeks ago

Hello everybody

I'm having this error when trying to publish the bot, I had updated to version 2.26 a few days ago and everything was fine, now I'm back to version 2.24 and the error persists, any idea how to resolve it?

version 2.26

Invalid prisma.publicTypebot.updateMany() invocation: Error occurred during query execution: ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(PostgresError { code: "XX001", message: "could not read block 45 in file \"base/16388/16842\": read only 0 of 8192 bytes", severity: "ERROR", detail: None, column: None, hint: None }), transient: false })

version 2.24

Error occurred during query execution: ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(PostgresError { code: "55000", message: "attempted to delete invisible tuple", severity: "ERROR", detail: None, column: None, hint: None }), transient: false }) at si.handleRequestError (/app/node_modules/.pnpm/@prisma+client@5.8.0_prisma@5.8.0/node_modules/@prisma/client/runtime/library.js:125:7007) at si.handleAndLogRequestError (/app/node_modules/.pnpm/@prisma+client@5.8.0_prisma@5.8.0/node_modules/@prisma/client/runtime/library.js:125:6151) at si.request (/app/node_modules/.pnpm/@prisma+client@5.8.0_prisma@5.8.0/node_modules/@prisma/client/runtime/library.js:125:5859) at async l (/app/node_modules/.pnpm/@prisma+client@5.8.0_prisma@5.8.0/node_modules/@prisma/client/runtime/library.js:130:9805) at async /app/apps/builder/.next/server/chunks/9108.js:1:66903 at async resolveMiddleware (file:///app/node_modules/.pnpm/@trpc+server@10.40.0/node_modules/@trpc/server/dist/index.mjs:420:30) at async callRecursive (file:///app/node_modules/.pnpm/@trpc+server@10.40.0/node_modules/@trpc/server/dist/index.mjs:456:32) at async outputMiddleware (file:///app/node_modules/.pnpm/@trpc+server@10.40.0/node_modules/@trpc/server/dist/index.mjs:301:24) at async callRecursive (file:///app/node_modules/.pnpm/@trpc+server@10.40.0/node_modules/@trpc/server/dist/index.mjs:456:32) at async callRecursive (file:///app/node_modules/.pnpm/@trpc+server@10.40.0/node_modules/@trpc/server/dist/index.mjs:456:32) { clientVersion: '5.8.0' } }

Invalid prisma.result.findMany() invocation: The column Answer.itemId does not exist in the current database.

version 2.26.1

2024-07-04 17:13:00.511 UTC [129] ERROR: column Answer.itemId does not exist at character 127 2024-07-04 17:13:00.511 UTC [129] STATEMENT: SELECT "public"."Answer"."resultId", "public"."Answer"."blockId", "public"."Answer"."groupId", "public"."Answer"."createdAt", "public"."Answer"."itemId", "public"."Answer"."variableId", "public"."Answer"."content", "public"."Answer"."storageUsed" FROM "public"."Answer" WHERE "public"."Answer"."resultId" IN ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40) OFFSET $41 2024-07-04 17:18:18.882 UTC [127] ERROR: could not read block 45 in file "base/16388/16842": read only 0 of 8192 bytes 2024-07-04 17:18:18.882 UTC [127] STATEMENT: INSERT INTO "public"."PublicTypebot" ("events","theme","createdAt","version","variables","typebotId","groups","edges","id","updatedAt","settings") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11) 2024-07-04 17:19:32.521 UTC [27] LOG: checkpoint starting: time 2024-07-04 17:19:34.538 UTC [27] LOG: checkpoint complete: wrote 21 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.008 s, sync=0.003 s, total=2.017 s; sync files=17, longest=0.002 s, average=0.001 s; distance=65 kB, estimate=479 kB; lsn=0/41750B88, redo lsn=0/41750B50

baptisteArno commented 2 weeks ago

You upgraded to 2.26 so it migrated the database, if you rolled back to previous then the database is not up to date with the code.

Can you again upgrade to 2.26 and tell me what'S the issue?

marciotisouza commented 2 weeks ago

Invalid prisma.publicTypebot.updateMany() invocation: Error occurred during query execution: ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(PostgresError { code: "XX001", message: "could not read block 45 in file "base/16388/16842": read only 0 of 8192 bytes", severity: "ERROR", detail: None, column: None, hint: None }), transient: false })

baptisteArno commented 2 weeks ago

See: https://dba.stackexchange.com/questions/44508/error-could-not-read-block-x-of-relation-base-y-z

Most likely you have disk or file system problems.

I'm sorry but that is not related to Typebot 🙏