You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When running Superset version 0.36 coupled with postgres to schedule jobs that runs raw SQL postgres queries in kubernetes environemnt. The query execution fails as follow :-
psycopg2.DatabaseError: error with status PGRES_TUPLES_OK and no message from the libpq
Expected results
When Raw SQL is run in the db session object using the execute method
By using fetchall to fetch all row from the postgres database, result is expected to be a list of tuples containing value of columns
Actual results
When Raw SQL is run in the db session object using the execute method
Then using fetchall to fetch all row we encounter below error
result that we get is the Postgres error as psycopg2.DatabaseError: error with status PGRES_TUPLES_OK and no message from the libpq
Screenshots
How to reproduce the bug
In a celery job initialize db session
DB session is initialized as db.session() or db.create_scoped_session()
raw sql is used as sqlalchemy text e.g. sqlalchemy.text('Select * from Employees')
raw sql is executed in the db object to give result as list of tuples
The code being used is db.create_scoped_session().execute(sqlalchemy.text('Select * from Employees')).fetchall()
The code fails as psycopg2.DatabaseError: error with status PGRES_TUPLES_OK and no message from the libpq.
Environment
(please complete the following information):
superset version: 0.36
python version: 3.7.6
We use postgres version 9.2 with the celery running in kubernetes within docker container.
Celery has redis configured as Backend. Below are few python module with their respective version
Make sure to follow these steps before submitting your issue - thank you!
I have checked the superset logs for python stacktraces and included it here as text if there are any.
I have reproduced the issue with at least the latest released version of superset.
I have checked the issue tracker for the same issue and I haven't found one similar.
Additional context
For the superset version we are using is 0.36 release which we do not have any plans to upgrade as of now.
The main use is to fetch details from postgres table that are not currently part of superset model architecture and process the same every 5min to 1 hour which takes around 20 minutes to get completed, for which trying to create a celery job.
When running Superset version 0.36 coupled with postgres to schedule jobs that runs raw SQL postgres queries in kubernetes environemnt. The query execution fails as follow :-
Expected results
Actual results
Screenshots
How to reproduce the bug
Environment
(please complete the following information):
0.36
3.7.6
We use postgres version 9.2 with the celery running in kubernetes within docker container.
Celery has redis configured as Backend. Below are few python module with their respective version
celery==4.4.2
SQLAlchemy==1.3.17
Flask==1.1.2
Flask-AppBuilder==2.3.4
kombu==4.6.8
psycopg2==2.8.5
redis == 3.5.0
Checklist
Make sure to follow these steps before submitting your issue - thank you!
Additional context
The text was updated successfully, but these errors were encountered: