Bug or not? PrismaClientKnownRequestError - code P2021

[koshia]

Hello,
I was wondering if someone more experience than me could identify if this is a bug or if this is just something in a postgresql 14 docker that's not supported.

I have an UnRaid setup and configuring the docker engine with Affine. The image pulls down fine, but upon initial load, it's throwing this error:

text  error  warn  system  array  login  

/app/node_modules/@prisma/client/runtime/library.js:122
`)}var eo=({clientMethod:e,activeProvider:t})=>r=>{let n="",i;if(Array.isArray(r)){let[o,...s]=r;n=o,i={values:Ar(s||[]),__prismaRawParameters__:!0}}else switch(t){case"sqlite":case"mysql":{n=r.sql,i={values:Ar(r.values),__prismaRawParameters__:!0};break}case"cockroachdb":case"postgresql":case"postgres":{n=r.text,i={values:Ar(r.values),__prismaRawParameters__:!0};break}case"sqlserver":{n=il(r),i={values:Ar(r.values),__prismaRawParameters__:!0};break}default:throw new Error(`The ${t} provider does not support ${e}`)}return i?.values?ll(`prisma.${e}(${n}, ${i.values})`):ll(`prisma.${e}(${n})`),{query:n,parameters:i}},ul={requestArgsToMiddlewareArgs(e){return[e.strings,...e.values]},middlewareArgsToRequestArgs(e){let[t,...r]=e;return new ie(t,r)}},cl={requestArgsToMiddlewareArgs(e){return[e]},middlewareArgsToRequestArgs(e){return e[0]}};function to(e){return function(r){let n,i=(o=e)=>{try{return o===void 0||o?.kind==="itx"?n??(n=pl(r(o))):pl(r(o))}catch(s){return Promise.reject(s)}};return{then(o,s){return i().then(o,s)},catch(o){return i().catch(o)},finally(o){return i().finally(o)},requestTransaction(o){let s=i(o);return s.requestTransaction?s.requestTransaction(o):s},[Symbol.toStringTag]:"PrismaPromise"}}}function pl(e){return typeof e.then=="function"?e:Promise.resolve(e)}var ml={isEnabled(){return!1},getTraceParent(){return"00-10-10-00"},async createEngineSpan(){},getActiveContext(){},runInChildSpan(e,t){return t()}},ro=class{isEnabled(){return this.getGlobalTracingHelper().isEnabled()}getTraceParent(t){return this.getGlobalTracingHelper().getTraceParent(t)}createEngineSpan(t){return this.getGlobalTracingHelper().createEngineSpan(t)}getActiveContext(){return this.getGlobalTracingHelper().getActiveContext()}runInChildSpan(t,r){return this.getGlobalTracingHelper().runInChildSpan(t,r)}getGlobalTracingHelper(){return globalThis.PRISMA_INSTRUMENTATION?.helper??ml}};function dl(e){return e.includes("tracing")?new ro:ml}function fl(e,t=()=>{}){let r,n=new Promise(i=>r=i);return{then(i){return--e===0&&r(t()),i?.(n)}}}var rd=["$connect","$disconnect","$on","$transaction","$use","$extends"],gl=rd;function hl(e){return typeof e=="string"?e:e.reduce((t,r)=>{let n=typeof r=="string"?r:r.level;return n==="query"?t:t&&(r==="info"||t==="info")?"info":n},void 0)}var An=class{constructor(){this._middlewares=[]}use(t){this._middlewares.push(t)}get(t){return this._middlewares[t]}has(t){return!!this._middlewares[t]}length(){return this._middlewares.length}};var bl=k(mi());function In(e){return typeof e.batchRequestIdx=="number"}function On(e){return e===null?e:Array.isArray(e)?e.map(On):typeof e=="object"?nd(e)?id(e):gt(e,On):e}function nd(e){return e!==null&&typeof e=="object"&&typeof e.$type=="string"}function id({$type:e,value:t}){switch(e){case"BigInt":return BigInt(t);case"Bytes":return Buffer.from(t,"base64");case"DateTime":return new Date(t);case"Decimal":return new Te(t);case"Json":return JSON.parse(t);default:tt(t,"Unknown tagged value")}}function yl(e){if(e.action!=="findUnique"&&e.action!=="findUniqueOrThrow")return;let t=[];return e.modelName&&t.push(e.modelName),e.query.arguments&&t.push(no(e.query.arguments)),t.push(no(e.query.selection)),t.join("")}function no(e){return`(${Object.keys(e).sort().map(r=>{let n=e[r];return typeof n=="object"&&n!==null?`(${r} ${no(n)})`:r}).join(" ")})`}var od={aggregate:!1,aggregateRaw:!1,createMany:!0,createManyAndReturn:!0,createOne:!0,deleteMany:!0,deleteOne:!0,executeRaw:!0,findFirst:!1,findFirstOrThrow:!1,findMany:!1,findRaw:!1,findUnique:!1,findUniqueOrThrow:!1,groupBy:!1,queryRaw:!1,runCommandRaw:!0,updateMany:!0,updateOne:!0,upsertOne:!0};function io(e){return od[e]}var kn=class{constructor(t){this.options=t;this.tickActive=!1;this.batches={}}request(t){let r=this.options.batchBy(t);return r?(this.batches[r]||(this.batches[r]=[],this.tickActive||(this.tickActive=!0,process.nextTick(()=>{this.dispatchBatches(),this.tickActive=!1}))),new Promise((n,i)=>{this.batches[r].push({request:t,resolve:n,reject:i})})):this.options.singleLoader(t)}dispatchBatches(){for(let t in this.batches){let r=this.batches[t];delete this.batches[t],r.length===1?this.options.singleLoader(r[0].request).then(n=>{n instanceof Error?r[0].reject(n):r[0].resolve(n)}).catch(n=>{r[0].reject(n)}):(r.sort((n,i)=>this.options.batchOrder(n.request,i.request)),this.options.batchLoader(r.map(n=>n.request)).then(n=>{if(n instanceof Error)for(let i=0;i<r.length;i++)r[i].reject(n);else for(let i=0;i<r.length;i++){let o=n[i];o instanceof Error?r[i].reject(o):r[i].resolve(o)}}).catch(n=>{for(let i=0;i<r.length;i++)r[i].reject(n)}))}}get[Symbol.toStringTag](){return"DataLoader"}};var sd=F("prisma:client:request_handler"),_n=class{constructor(t,r){this.logEmitter=r,this.client=t,this.dataloader=new kn({batchLoader:oa(async({requests:n,customDataProxyFetch:i})=>{let{transaction:o,otelParentCtx:s}=n[0],a=n.map(p=>p.protocolQuery),l=this.client._tracingHelper.getTraceParent(s),u=n.some(p=>io(p.protocolQuery.action));return(await this.client._engine.requestBatch(a,{traceparent:l,transaction:ad(o),containsWrite:u,customDataProxyFetch:i})).map((p,m)=>{if(p instanceof Error)return p;try{return this.mapQueryEngineResult(n[m],p)}catch(f){return f}})}),singleLoader:async n=>{let i=n.transaction?.kind==="itx"?El(n.transaction):void 0,o=await this.client._engine.request(n.protocolQuery,{traceparent:this.client._tracingHelper.getTraceParent(),interactiveTransaction:i,isWrite:io(n.protocolQuery.action),customDataProxyFetch:n.customDataProxyFetch});return this.mapQueryEngineResult(n,o)},batchBy:n=>n.transaction?.id?`transaction-${n.transaction.id}`:yl(n.protocolQuery),batchOrder(n,i){return n.transaction?.kind==="batch"&&i.transaction?.kind==="batch"?n.transaction.index-i.transaction.index:0}})}async request(t){try{return await this.dataloader.request(t)}catch(r){let{clientMethod:n,callsite:i,transaction:o,args:s,modelName:a}=t;this.handleAndLogRequestError({error:r,clientMethod:n,callsite:i,transaction:o,args:s,modelName:a,globalOmit:t.globalOmit})}}mapQueryEngineResult({dataPath:t,unpacker:r},n){let i=n?.data,o=n?.elapsed,s=this.unpack(i,t,r);return process.env.PRISMA_CLIENT_GET_TIME?{data:s,elapsed:o}:s}handleAndLogRequestError(t){try{this.handleRequestError(t)}catch(r){throw this.logEmitter&&this.logEmitter.emit("error",{message:r.message,target:t.clientMethod,timestamp:new Date}),r}}handleRequestError({error:t,clientMethod:r,callsite:n,transaction:i,args:o,modelName:s,globalOmit:a}){if(sd(t),ld(t,i)||t instanceof De)throw t;if(t instanceof V&&ud(t)){let u=wl(t.meta);Sn({args:o,errors:[u],callsite:n,errorFormat:this.client._errorFormat,originalMethod:r,clientVersion:this.client._clientVersion,globalOmit:a})}let l=t.message;if(n&&(l=Ot({callsite:n,originalMethod:r,isPanic:t.isPanic,showColors:this.client._errorFormat==="pretty",message:l})),l=this.sanitizeMessage(l),t.code){let u=s?{modelName:s,...t.meta}:t.meta;throw new V(l,{code:t.code,clientVersion:this.client._clientVersion,meta:u,batchRequestIdx:t.batchRequestIdx})}else{if(t.isPanic)throw new le(l,this.client._clientVersion);if(t instanceof B)throw new B(l,{clientVersion:this.client._clientVersion,batchRequestIdx:t.batchRequestIdx});if(t instanceof R)throw new R(l,this.client._clientVersion);if(t instanceof le)throw new le(l,this.client._clientVersion)}throw t.clientVersion=this.client._clientVersion,t}sanitizeMessage(t){return this.client._errorFormat&&this.client._errorFormat!=="pretty"?(0,bl.default)(t):t}unpack(t,r,n){if(!t||(t.data&&(t=t.data),!t))return t;let i=Object.values(t)[0],o=r.filter(a=>a!=="select"&&a!=="include"),s=On(_i(i,o));return n?n(s):s}get[Symbol.toStringTag](){return"RequestHandler"}};function ad(e){if(e){if(e.kind==="batch")return{kind:"batch",options:{isolationLevel:e.isolationLevel}};if(e.kind==="itx")return{kind:"itx",options:El(e)};tt(e,"Unknown transaction kind")}}function El(e){return{id:e.id,payload:e.payload}}function ld(e,t){return In(e)&&t?.kind==="batch"&&e.batchRequestIdx!==t.index}function ud(e){return e.code==="P2009"||e.code==="P2012"}function wl(e){if(e.kind==="Union")return{kind:"Union",errors:e.errors.map(wl)};if(Array.isArray(e.selectionPath)){let[,...t]=e.selectionPath;return{...e,selectionPath:t}}return e}var xl="5.16.2";var Pl=xl;function vl(e){return e.map(t=>{let r={};for(let n of Object.keys(t))r[n]=Tl(t[n]);return r})}function Tl({prisma__type:e,prisma__value:t}){switch(e){case"bigint":return BigInt(t);case"bytes":return Buffer.from(t,"base64");case"decimal":return new Te(t);case"datetime":case"date":return new Date(t);case"time":return new Date(`1970-01-01T${t}Z`);case"array":return t.map(Tl);default:return t}}var Il=k(Yi());var L=class extends Error{constructor(t){super(t+`
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            

PrismaClientKnownRequestError: 
Invalid `prisma.runtimeConfig.findMany()` invocation:


The table `public.app_runtime_settings` does not exist in the current database.
    at _n.handleRequestError (/app/node_modules/@prisma/client/runtime/library.js:122:6927)
    at _n.handleAndLogRequestError (/app/node_modules/@prisma/client/runtime/library.js:122:6235)
    at _n.request (/app/node_modules/@prisma/client/runtime/library.js:122:5919)
    at async l (/app/node_modules/@prisma/client/runtime/library.js:131:9116)
    at async Runtime.upgradeDB (file:///app/dist/fundamentals/config/runtime/service.js:189:36)
    at async Runtime.onApplicationBootstrap (file:///app/dist/fundamentals/config/runtime/service.js:98:9)
    at async Promise.all (index 0)
    at async callModuleBootstrapHook (/app/node_modules/@nestjs/core/hooks/on-app-bootstrap.hook.js:43:5)
    at async NestApplication.callBootstrapHook (/app/node_modules/@nestjs/core/nest-application-context.js:243:13)
    at async NestApplication.init (/app/node_modules/@nestjs/core/nest-application.js:102:9) {
  code: 'P2021',
  clientVersion: '5.16.2',
  meta: { modelName: 'RuntimeConfig', table: 'public.app_runtime_settings' }
}

Node.js v20.15.1
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] WebSocketModule dependencies initialized +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] SyncModule dependencies initialized +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] GqlModule dependencies initialized +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] CacheModule dependencies initialized +11ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] DiscoveryModule dependencies initialized +1ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] EventModule dependencies initialized +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] MetricsModule dependencies initialized +1ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] StorageProviderModule dependencies initialized +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] HelpersModule dependencies initialized +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] ErrorModule dependencies initialized +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] EventEmitterModule dependencies initialized +2ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] ScheduleModule dependencies initialized +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] RedisModule dependencies initialized +1ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] MailModule dependencies initialized +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] AppModule dependencies initialized +1ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] ServerConfigModule dependencies initialized +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] ConfigModule dependencies initialized +1ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] MutexModule dependencies initialized +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] StorageModule dependencies initialized +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] GraphQLSchemaBuilderModule dependencies initialized +1ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] ThrottlerModule dependencies initialized +1ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] QuotaModule dependencies initialized +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] FeatureModule dependencies initialized +1ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] DocModule dependencies initialized +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] RateLimiterModule dependencies initialized +1ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] UserModule dependencies initialized +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] OAuthModule dependencies initialized +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] EventsModule dependencies initialized +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] PaymentModule dependencies initialized +1ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] GraphQLModule dependencies initialized +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] AuthModule dependencies initialized +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [InstanceLoader] WorkspaceModule dependencies initialized +1ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [WebSocketsController] EventsGateway subscribed to the "client-handshake-sync" message +18ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [WebSocketsController] EventsGateway subscribed to the "client-handshake-awareness" message +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [WebSocketsController] EventsGateway subscribed to the "client-leave-sync" message +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [WebSocketsController] EventsGateway subscribed to the "client-leave-awareness" message +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [WebSocketsController] EventsGateway subscribed to the "client-pre-sync" message +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [WebSocketsController] EventsGateway subscribed to the "client-update-v2" message +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [WebSocketsController] EventsGateway subscribed to the "doc-load-v2" message +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [WebSocketsController] EventsGateway subscribed to the "awareness-init" message +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [WebSocketsController] EventsGateway subscribed to the "awareness-update" message +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [RoutesResolver] AppController {/}: +3ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [RouterExplorer] Mapped {/, GET} route +2ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [RoutesResolver] AuthController {/api/auth}: +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [RouterExplorer] Mapped {/api/auth/sign-in, POST} route +1ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [RouterExplorer] Mapped {/api/auth/sign-out, GET} route +1ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [RouterExplorer] Mapped {/api/auth/magic-link, POST} route +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [RouterExplorer] Mapped {/api/auth/session, GET} route +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [RouterExplorer] Mapped {/api/auth/sessions, GET} route +1ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [RouterExplorer] Mapped {/api/auth/challenge, GET} route +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [RoutesResolver] UserAvatarController {/api/avatars}: +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [RouterExplorer] Mapped {/api/avatars/:id, GET} route +1ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [RoutesResolver] WorkspacesController {/api/workspaces}: +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [RouterExplorer] Mapped {/api/workspaces/:id/blobs/:name, GET} route +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [RouterExplorer] Mapped {/api/workspaces/:id/docs/:guid, GET} route +1ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [RouterExplorer] Mapped {/api/workspaces/:id/docs/:guid/histories/:timestamp, GET} route +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [RoutesResolver] StripeWebhook {/api/stripe}: +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [RouterExplorer] Mapped {/api/stripe/webhook, POST} route +1ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [RoutesResolver] OAuthController {/oauth}: +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [RouterExplorer] Mapped {/oauth/login, GET} route +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [RouterExplorer] Mapped {/oauth/callback, GET} route +0ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [DocManager] Use Database
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [DocManager] Automation started
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [GraphQLModule] Mapped {/graphql, POST} route +208ms
[Nest] 1  - 08/02/2024, 9:44:20 PM     LOG [ErrorModule] Generating UserFriendlyError classes

** Press ANY KEY to close this window ** 

From what I can tell, the error indicates there's a missing table in the postgresql and i'm unsure if this is a table that's supposed to already be in the PostgreSQL schema, or if it's supposed to be created by a script from the Affine image.

[findthelorax]

The issue seems to be related to the database migration. I got the docker-compose to work on unraid but haven't found anything for getting the image to work. I believe it's this code
yarn prisma migrate deploy && node --import ./scripts/register.js ./dist/data/index.js that needs to be run but I haven't figured out where exactly to run it properly. I've been trying with the docker run command but I keep getting environment variable not found: DATABASE_URL.

EDIT:

Got it! I mixed up the syntax of course.

Adjust the database url as necessary.

docker run -e DATABASE_URL=postgres://affine:affine@postgres:5437/affine ghcr.io/toeverything/affine-graphql:stable sh -c "yarn prisma migrate deploy && node --import ./scripts/register.js ./dist/data/index.js"

I'll test some more then i'll work on getting up a CA Template for Unraid.

[koshia]

Appreciate the response and follow up. Glad you got it to work! I used chatgpt and it led me down the path of running some shadowdb migration to create some of the missing tables, but then afterwards, still couldn't get the UI to pull up, so I just gave up. I moved to Outline but their docker has some challenges as well. At least it's got a CA template.

[findthelorax]

Did you get Outline working? I'm also trying to install that.