bug: Prisma client doesn't work on Globe

[indratrisnar]

Is there an existing issue for this?

• I have searched the existing issues.

CLI Version

0.0.9+1

Project ID

72440fcd-a637-4df4-a746-c3a388a56651

Description

i re-deploy after update Globe CLI to 0.0.9+1. success.
then, when i tried access api. some api return Internal Server Error.

i have connection to Prisma ORM (mysql) inside my app. if Prisma ORM cause this error.

how to integrated/install Prisma ORM and mysql to Globe?

Steps to reproduce

1. update Globe CLI
2. deploy production
3. test api, some work and some return Internal Server Error

Expected behavior

return data

Screenshots

success deploy:

work api:

not work api:

Additional context and comments

No response

[lesnitsky]

I can see a few issues in your deployment logs:

2024-02-29T11:25:36.534141Z [dotenv] Load failed: file not found: File: '.env'
2024-02-29T11:25:36.535465Z [ERROR] 2024-02-29 11:25:36.531538 0:00:00.000958 GET /notes
2024-02-29T11:25:36.535598Z ERROR - 2024-02-29 11:25:36.533394

You need to set env vars on the dashboard instead of trying to read .env:

• Go to your project
• Settings
• Environment variables

---

2024-02-29T11:25:36.539975Z PrismaInitializationException: Cannot find the query engine binary (Basename: C:\Users\Indra\node_modules\prisma\query-engine-windows.exe | prisma-query-engine)
2024-02-29T11:25:36.539986Z package:orm/binary_engine.dart 85 BinaryEngine.resolvedExecutable
2024-02-29T11:25:36.540707Z Error thrown by handler.
2024-02-29T11:25:36.540789Z package:orm/binary_engine.dart 191 BinaryEngine._createProcess
2024-02-29T11:25:36.542726Z package:orm/binary_engine.dart 156 BinaryEngine.start
2024-02-29T11:25:36.543209Z PrismaInitializationException: Cannot find the query engine binary (Basename: C:\Users\Indra\node_modules\prisma\query-engine-windows.exe | prisma-query-engine)
2024-02-29T11:25:36.543219Z package:orm/binary_engine.dart 85 BinaryEngine.resolvedExecutable
2024-02-29T11:25:36.544087Z package:orm/binary_engine.dart 191 BinaryEngine._createProcess
2024-02-29T11:25:36.547038Z package:orm/binary_engine.dart 156 BinaryEngine.start

C:\Users\Indra\node_modules\prisma\query-engine-windows.exe
This path only exists on your machine. I'm not sure if that's a consequence of invalid env vars, but it is definitely something that is causing the failure.

[indratrisnar]

Oke i'll try, thanks for the instruction Pada Kam, 29 Feb 2024 19.29, Andrei Lesnitsky ***@***.***> menulis:

…

I can see a few issues in your deployment logs: 2024-02-29T11:25:36.534141Z [dotenv] Load failed: file not found: File: '.env' 2024-02-29T11:25:36.535465Z [ERROR] 2024-02-29 11:25:36.531538 0:00:00.000958 GET /notes 2024-02-29T11:25:36.535598Z ERROR - 2024-02-29 11:25:36.533394 You need to set env vars on the dashboard instead of trying to read .env: - Go to your project - Settings - Environment variables ------------------------------ 2024-02-29T11:25:36.539975Z PrismaInitializationException: Cannot find the query engine binary (Basename: C:\Users\Indra\node_modules\prisma\query-engine-windows.exe | prisma-query-engine) 2024-02-29T11:25:36.539986Z package:orm/binary_engine.dart 85 BinaryEngine.resolvedExecutable 2024-02-29T11:25:36.540707Z Error thrown by handler. 2024-02-29T11:25:36.540789Z package:orm/binary_engine.dart 191 BinaryEngine._createProcess 2024-02-29T11:25:36.542726Z package:orm/binary_engine.dart 156 BinaryEngine.start 2024-02-29T11:25:36.543209Z PrismaInitializationException: Cannot find the query engine binary (Basename: C:\Users\Indra\node_modules\prisma\query-engine-windows.exe | prisma-query-engine) 2024-02-29T11:25:36.543219Z package:orm/binary_engine.dart 85 BinaryEngine.resolvedExecutable 2024-02-29T11:25:36.544087Z package:orm/binary_engine.dart 191 BinaryEngine._createProcess 2024-02-29T11:25:36.547038Z package:orm/binary_engine.dart 156 BinaryEngine.start C:\Users\Indra\node_modules\prisma\query-engine-windows.exe This path only exists on your machine. I'm not sure if that's a consequence of invalid env vars, but it is definitely something that is causing the failure. — Reply to this email directly, view it on GitHub <#54 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/APTLYD6AMUBUPFAZG447IG3YV4PKNAVCNFSM6AAAAABD7YIFJSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNZRGAZTMOBZHE> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[lesnitsky]

After additional digging into how Prisma ORM works, we are coming to the conclusion that it won't work on Globe, since it has a dependency on node and npm, which are unavailable in our environment.

[indratrisnar]

i have checked into the dashboard settings. but, the env I need is already there.

I forgot, whether it was made by me before or automatically.
because when I first linked the project to globe. I allow env upload.

[indratrisnar]

After additional digging into how Prisma ORM works, we are coming to the conclusion that it won't work on Globe, since it has a dependency on node and npm, which are unavailable in our environment.

ok