Unable to db.connect() via Flask on remote server

[simondpalmer]

I am trying to run prisma client py via flask on pythonAnywhere but get the following error:

Traceback (most recent call last):
  File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 2077, in wsgi_app
    response = self.full_dispatch_request()
  File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 1525, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 1523, in full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 1509, in dispatch_request
    return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)
  File "/home/simonpalmer/ideally/flask_api.py", line 641, in street_query
    create_analysis_edges(user_id, lot_id, edges_collection)
  File "/home/simonpalmer/ideally/flask_api.py", line 180, in create_analysis_edges
    db.connect()
  File "/home/simonpalmer/.local/lib/python3.10/site-packages/prisma/client.py", line 254, in connect
    self.__engine.connect(
  File "/home/simonpalmer/.local/lib/python3.10/site-packages/prisma/engine/query.py", line 132, in connect
    self.spawn(file, timeout=timeout, datasources=datasources)
  File "/home/simonpalmer/.local/lib/python3.10/site-packages/prisma/engine/query.py", line 187, in spawn
    self.process = subprocess.Popen(
  File "/usr/local/lib/python3.10/subprocess.py", line 835, in __init__
    errread, errwrite) = self._get_handles(stdin, stdout, stderr)
  File "/usr/local/lib/python3.10/subprocess.py", line 1639, in _get_handles
    errwrite = stderr.fileno()
AttributeError: 'ErrorLogFile' object has no attribute 'fileno'

My steps:
This all works locally but I am pushing this to production now.
I have an existing prisma db so I created a prisma.schema file in the same directory as the flask app.
I then used prisma db pull.
Made a request in the frontend and get this error

Has this error got something to do using a remote server connection? What am I missing?
FYI I am using supabase for my prisma db. I have a javascript frontend that connects to the same db which is hosted elsewhere which seems to be connecting to prisma just fine

[RobertCraigie]

@simondpalmer this seems to be an issue with PythonAnywhere where subprocesses cannot be spawned for some reason. I'm not familiar with PythonAnywhere unfortunately so I can't help there.

The reason that the JS client would work where the Python client doesn't is because the JS client now uses rust bindings instead of spawning a separate process. I started working on transitioning the Python client to a similar structure but it's a fairly monumental effort.

[simondpalmer]

Thanks for the reply, do you know of an alternative remote server provider that would provide these subprocess's? That works best with prisma py?

[RobertCraigie]

Any remote server provider that gives you access to your own server should work.

I've successfully used Railway before but to name some others that should work as well:

• Digital Ocean
• OVH
• AWS

(These are just some providers I know off the top of my head fwiw)

I'd currently recommend staying away from any Serverless offerings as well.

[simondpalmer]

Thanks so much I'll give them a try!