snapp: Postgres in container doesn't perform initial migration

Hi

I’m taking a look at v0.8 and have chosen postgres support but startup fails with the following message. An empty _prisma_migrations table is created in the db so I’m certain my connection settings are correct. If I use sqlite it works fine.

snapp  | -------------------------------------------                                                                                                                                                    
snapp  |              Welcome to Snapp!                                                                                                                                                                 
snapp  | -------------------------------------------                                                                                                                                                    
snapp  |                                                                                                                                                                                                
snapp  |       Thank you for choosing this app.                                                                                                                                                         
snapp  |                                                                                                                                                                                                
snapp  |       Have a great day and enjoy your                                                                                                                                                          
snapp  |             experience with us!                                                                                                                                                                
snapp  |                                                                                                                                                                                                
snapp  | -------------------------------------------                                                                                                                                                    
snapp  | /app/node_modules/@prisma/client/runtime/library.js:121                                                                                                                                        
snapp  | `)}var to=({clientMethod:e,activeProvider:t})=>r=>{let n="",i;if(Array.isArray(r)){let[o,...s]=r;n=o,i={values:Ir(s||[]),__prismaRawParameters__:!0}}else switch(t){case"sqlite":case"mysql":{n
=r.sql,i={values:Ir(r.values),__prismaRawParameters__:!0};break}case"cockroachdb":case"postgresql":case"postgres":{n=r.text,i={values:Ir(r.values),__prismaRawParameters__:!0};break}case"sqlserver":{n=
il(r),i={values:Ir(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){r
eturn[e]},middlewareArgsToRequestArgs(e){return e[0]}};function ro(e){return function(r){let n,i=(o=e)=>{try{return o===void 0||o?.kind==="itx"?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 dl={isEnabled(){return!1},getTraceParent(){return"00-10-10-00"},async createEngineSpan(){},getA
ctiveContext(){},runInChildSpan(e,t){return t()}},no=class{isEnabled(){return this.getGlobalTracingHelper().isEnabled()}getTraceParent(t){return this.getGlobalTracingHelper().getTraceParent(t)}createE
ngineSpan(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??dl}};function ml(e){return e.includes("tracing")?new no:dl}function fl(e,t=()=>{}){let r,n=new Promise(
i=>r=i);return{then(i){return--e===0&&r(t()),i?.(n)}}}var tm=["$connect","$disconnect","$on","$transaction","$use","$extends"],gl=tm;function hl(e){return typeof e=="string"?e:e.reduce((t,r)=>{let n=t
ypeof r=="string"?r:r.level;return n==="query"?t:t&&(r==="info"||t==="info")?"info":n},void 0)}var In=class{constructor(){this._middlewares=[]}use(t){this._middlewares.push(t)}get(t){return this._midd
lewares[t]}has(t){return!!this._middlewares[t]}length(){return this._middlewares.length}};var El=k(mi());function On(e){return typeof e.batchRequestIdx=="number"}function kn(e){return e===null?e:Array
.isArray(e)?e.map(kn):typeof e=="object"?rm(e)?nm(e):ht(e,kn):e}function rm(e){return e!==null&&typeof e=="object"&&typeof e.$type=="string"}function nm({$type:e,value:t}){switch(e){case"BigInt":retur
n BigInt(t);case"Bytes":return Buffer.from(t,"base64");case"DateTime":return new Date(t);case"Decimal":return new ve(t);case"Json":return JSON.parse(t);default:De(t,"Unknown tagged value")}}function y
l(e){if(e.action!=="findUnique"&&e.action!=="findUniqueOrThrow")return;let t=[];return e.modelName&&t.push(e.modelName),e.query.arguments&&t.push(io(e.query.arguments)),t.push(io(e.query.selection)),t
.join("")}function io(e){return`(${Object.keys(e).sort().map(r=>{let n=e[r];return typeof n=="object"&&n!==null?`(${r} ${io(n)})`:r}).join(" ")})`}var im={aggregate:!1,aggregateRaw:!1,createMany:!0,cr
eateManyAndReturn:!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,runCommandR
aw:!0,updateMany:!0,updateOne:!0,upsertOne:!0};function oo(e){return im[e]}var Dn=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,re
solve: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"}};function ct(e,t){if(t===null)return t;switch(e){case"bigint":return BigInt(t);case"bytes":return Buffer.from(t,"base64");case"decimal":ret
urn new ve(t);case"datetime":case"date":return new Date(t);case"time":return new Date(`1970-01-01T${t}Z`);case"bigint-array":return t.map(r=>ct("bigint",r));case"bytes-array":return t.map(r=>ct("bytes
",r));case"decimal-array":return t.map(r=>ct("decimal",r));case"datetime-array":return t.map(r=>ct("datetime",r));case"date-array":return t.map(r=>ct("date",r));case"time-array":return t.map(r=>ct("ti
me",r));default:return t}}function bl(e){let t=[],r=om(e);for(let n=0;n<e.rows.length;n++){let i=e.rows[n],o={...r};for(let s=0;s<i.length;s++)o[e.columns[s]]=ct(e.types[s],i[s]);t.push(o)}return t}fu
nction om(e){let t={};for(let r=0;r<e.columns.length;r++)t[e.columns[r]]=null;return t}var sm=F("prisma:client:request_handler"),_n=class{constructor(t,r){this.logEmitter=r,this.client=t,this.dataload
er=new Dn({batchLoader:sa(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=>oo
(p.protocolQuery.action));return(await this.client._engine.requestBatch(a,{traceparent:l,transaction:am(o),containsWrite:u,customDataProxyFetch:i})).map((p,d)=>{if(p instanceof Error)return p;try{retu
rn this.mapQueryEngineResult(n[d],p)}catch(f){return f}})}),singleLoader:async n=>{let i=n.transaction?.kind==="itx"?wl(n.transaction):void 0,o=await this.client._engine.request(n.protocolQuery,{trace
parent:this.client._tracingHelper.getTraceParent(),interactiveTransaction:i,isWrite:oo(n.protocolQuery.action),customDataProxyFetch:n.customDataProxyFetch});return this.mapQueryEngineResult(n,o)},batc
hBy: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.ind
ex: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,ca
llsite: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_GE
T_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:n
ew Date}),r}}handleRequestError({error:t,clientMethod:r,callsite:n,transaction:i,args:o,modelName:s,globalOmit:a}){if(sm(t),lm(t,i)||t instanceof _e)throw t;if(t instanceof V&&um(t)){let u=xl(t.meta);
An({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=kt({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.cli
ent._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,bat
chRequestIdx: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._clientVers
ion,t}sanitizeMessage(t){return this.client._errorFormat&&this.client._errorFormat!=="pretty"?(0,El.default)(t):t}unpack(t,r,n){if(!t||(t.data&&(t=t.data),!t))return t;let i=Object.keys(t)[0],o=Object
.values(t)[0],s=r.filter(u=>u!=="select"&&u!=="include"),a=_i(o,s),l=i==="queryRaw"?bl(a):kn(a);return n?n(l):l}get[Symbol.toStringTag](){return"RequestHandler"}};function am(e){if(e){if(e.kind==="bat
ch")return{kind:"batch",options:{isolationLevel:e.isolationLevel}};if(e.kind==="itx")return{kind:"itx",options:wl(e)};De(e,"Unknown transaction kind")}}function wl(e){return{id:e.id,payload:e.payload}
}function lm(e,t){return On(e)&&t?.kind==="batch"&&e.batchRequestIdx!==t.index}function um(e){return e.code==="P2009"||e.code==="P2012"}function xl(e){if(e.kind==="Union")return{kind:"Union",errors:e.
errors.map(xl)};if(Array.isArray(e.selectionPath)){let[,...t]=e.selectionPath;return{...e,selectionPath:t}}return e}var Pl="5.18.0";var vl=Pl;var Al=k(Zi());var L=class extends Error{constructor(t){su
per(t+`                                                                                                                                                                                                 
snapp  |                                                                                                                                                                                                
                                                                                                                                                                                                        
                                                                                                                                                                                                        
                                                                                                                                                                                                        
                                                                                                                                                                                                        
                                                                                                                                                                                                        
snapp  |                                                                                                                                                                                                
snapp  | PrismaClientKnownRequestError:                                                                                                                                                                 
snapp  | Invalid `prisma.setting.findFirst()` invocation:                                                                                                                                               
snapp  |                                                                                                                                                                                                
snapp  |                                                                                                                                                                                                
snapp  | The table `public.settings` does not exist in the current database.                                                                                                                            
snapp  |     at _n.handleRequestError (/app/node_modules/@prisma/client/runtime/library.js:121:7749)                                                                                                    
snapp  |     at _n.handleAndLogRequestError (/app/node_modules/@prisma/client/runtime/library.js:121:7057)                                                                                              
snapp  |     at _n.request (/app/node_modules/@prisma/client/runtime/library.js:121:6741)                                                                                                               
snapp  |     at async l (/app/node_modules/@prisma/client/runtime/library.js:130:9355)                                                                                                                  
snapp  |     at async Object.get_setting [as get] (file:///app/build/server/chunks/database-B1j6GVom.js:77:10)                                                                                          
snapp  |     at async run_init_functions (file:///app/build/server/chunks/hooks.server-BPDlRnFS.js:19:50)                                                                                               
snapp  |     at async file:///app/build/server/chunks/hooks.server-BPDlRnFS.js:27:1 {                                                                                                                   
snapp  |   code: 'P2021',                                                                                                                                                                               
snapp  |   clientVersion: '5.18.0',                                                                                                                                                                     
snapp  |   meta: { modelName: 'Setting', table: 'public.settings' }                                                                                                                                     
snapp  | }                                                                                                                                                                                              
snapp  |                                                                                                                                                                                                
snapp  | Node.js v20.16.0                                                                                                                                                                               
snapp exited with code 0                                                                                                                                                                                

About this issue

  • Original URL
  • State: closed
  • Created 2 years ago
  • Comments: 15 (11 by maintainers)

Most upvoted comments

yeah i edited after the works yesterday to fix this, as i said it became necessary to be very specific about this and it changed, i updated the compose on the repo, but forgot to specify elsewhere, sorry, i’ll put it better in README file

immagine

repull latest or :0.8 image 🚀

OK, let’s say it was like passed 2 o’clock and then kind of convinced myself i made it, but there are some really rookie mistake here and there, like who wrote this code. Yesterday night myself seems more messy than i thought.

I think i have a solution, hold on please 🙏

ok, let’s revise the entrypoint all over again 😄

noticed some more typo around indeed. i’m wondering how it worked so far.