-
Notifications
You must be signed in to change notification settings - Fork 144
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Connection through Pgpool not working #584
Comments
Seems like your database name is |
That's not the case, just a typo in the local stand yaml.... We have a Pgpool based cluster with data on a production server and we can access it with connectorx via normal route to the one of the replicas or master, but going through Pgpool is messed up. Feels like the driver laying behind connectorx is not waiting for query response and due to Pgpool rerouting mechanism connection closes before query result is acknowledged by the client... |
What language are you using?.
Python3.9
What version are you using?
0.3.2
What database are you using?
PostgreSQL
What dataframe are you using?
Pandas
Can you describe your bug?
Connection through pgpool to postgresql instance results with "RuntimeError: connection closed". Direct connection works as intended.
What are the steps to reproduce the behavior?
Example from "Getting started" section of the connectorx package and docker-compose with pgpool
Database setup if the error only happens on specific data or data type
Example query / code
What is the error?
Traceback (most recent call last):
File "/home/mikhail/sandbox/py/test.py", line 3, in
cx.read_sql("postgresql://postgres:[email protected]:5432/postgres?sslmode=disable", "select * from information_schema.tables")
File "/home/mikhail/sandbox/py/.venv/lib/python3.9/site-packages/connectorx/init.py", line 264, in read_sql
result = _read_sql(
RuntimeError: connection closed
The text was updated successfully, but these errors were encountered: