search

lucafaggianelli / plombery

Python task scheduler with a user-friendly web UI
http://lucafaggianelli.com/plombery/
MIT License
328 stars 47 forks source link

Postgresql invalid connection option "check_same_thread" #421

Open rizquuula opened 2 months ago

rizquuula commented 2 months ago

I am using this config in plombery.config.yaml

database_url: postgresql://plombery:plombery123@plombery_db:5432/plombery_db

the library returned error 

Exception has occurred: ProgrammingError
(psycopg2.ProgrammingError) invalid dsn: invalid connection option "check_same_thread"

(Background on this error at: https://sqlalche.me/e/20/f405)
psycopg2.ProgrammingError: invalid dsn: invalid connection option "check_same_thread"

The above exception was the direct cause of the following exception:

  File "/home/muhamad/Salts/plombery/src/flow/test_1.py", line 3, in <module>
    from plombery import task, Trigger, register_pipeline
  File "/home/muhamad/Salts/plombery/src/app.py", line 1, in <module>
    from flow.test_1 import *
sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) invalid dsn: invalid connection option "check_same_thread"

(Background on this error at: https://sqlalche.me/e/20/f405)

Happened on v0.4.1, why don't you upgrade it to the latest main branch? There is a fix for this already