rgarrigue opened a new issue, #22773: URL: https://github.com/apache/superset/issues/22773
I'm not sure this is a bug, but at least I need help troubleshooting. The error is as below  Pod's superset container's log ``` superset-7594948b84-r6mpw superset Triggering query_id: 43 superset-7594948b84-r6mpw superset 2023-01-18 11:24:41,138:INFO:superset.sqllab.command:Triggering query_id: 43 superset-7594948b84-r6mpw superset Query 43: Executing 1 statement(s) superset-7594948b84-r6mpw superset 2023-01-18 11:24:41,182:INFO:superset.sql_lab:Query 43: Executing 1 statement(s) superset-7594948b84-r6mpw superset Query 43: Set query to 'running' superset-7594948b84-r6mpw superset 2023-01-18 11:24:41,183:INFO:superset.sql_lab:Query 43: Set query to 'running' superset-7594948b84-r6mpw superset Query 43: Running statement 1 out of 1 superset-7594948b84-r6mpw superset 2023-01-18 11:24:41,238:INFO:superset.sql_lab:Query 43: Running statement 1 out of 1 superset-7594948b84-r6mpw superset Query 43: Storing results in results backend, key: 97ef1791-72ab-4f4d-8568-74736b0c42e3 superset-7594948b84-r6mpw superset 2023-01-18 11:24:41,290:INFO:superset.sql_lab:Query 43: Storing results in results backend, key: 97ef1791-72ab-4f4d-8568-74736b0c42e3 superset-7594948b84-r6mpw superset [SupersetError(message='Authentication required.', error_type=<SupersetErrorType.GENERIC_DB_ENGINE_ERROR: 'GENERIC_DB_ENGINE_ERROR'>, level=<ErrorLevel.ERROR: 'error'>, extra={'engine_name': 'PostgreSQL', 'issue_codes': [{'code': 1002, 'message': 'Issue 1002 - The database returned an unexpected error.'}]})] superset-7594948b84-r6mpw superset Traceback (most recent call last): superset-7594948b84-r6mpw superset File "/app/superset/views/base.py", line 210, in wraps superset-7594948b84-r6mpw superset return f(self, *args, **kwargs) superset-7594948b84-r6mpw superset File "/app/superset/utils/log.py", line 245, in wrapper superset-7594948b84-r6mpw superset value = f(*args, **kwargs) superset-7594948b84-r6mpw superset File "/app/superset/views/core.py", line 2407, in sql_json superset-7594948b84-r6mpw superset command_result: CommandResult = command.run() superset-7594948b84-r6mpw superset File "/app/superset/sqllab/command.py", line 114, in run superset-7594948b84-r6mpw superset raise ex superset-7594948b84-r6mpw superset File "/app/superset/sqllab/command.py", line 98, in run superset-7594948b84-r6mpw superset status = self._run_sql_json_exec_from_scratch() superset-7594948b84-r6mpw superset File "/app/superset/sqllab/command.py", line 151, in _run_sql_json_exec_from_scratch superset-7594948b84-r6mpw superset raise ex superset-7594948b84-r6mpw superset File "/app/superset/sqllab/command.py", line 146, in _run_sql_json_exec_from_scratch superset-7594948b84-r6mpw superset return self._sql_json_executor.execute( superset-7594948b84-r6mpw superset File "/app/superset/sqllab/sql_json_executer.py", line 111, in execute superset-7594948b84-r6mpw superset raise SupersetErrorsException( superset-7594948b84-r6mpw superset superset.exceptions.SupersetErrorsException: [SupersetError(message='Authentication required.', error_type=<SupersetErrorType.GENERIC_DB_ENGINE_ERROR: 'GENERIC_DB_ENGINE_ERROR'>, level=<ErrorLevel.ERROR: 'error'>, extra={'engine_name': 'PostgreSQL', 'issue_codes': [{'code': 1002, 'message': 'Issue 1002 - The database returned an unexpected error.'}]})] superset-7594948b84-r6mpw superset 2023-01-18 11:24:41,331:WARNING:superset.views.base:[SupersetError(message='Authentication required.', error_type=<SupersetErrorType.GENERIC_DB_ENGINE_ERROR: 'GENERIC_DB_ENGINE_ERROR'>, level=<ErrorLevel.ERROR: 'error'>, extra={'engine_name': 'PostgreSQL', 'issue_codes': [{'code': 1002, 'message': 'Issue 1002 - The database returned an unexpected error.'}]})] superset-7594948b84-r6mpw superset Traceback (most recent call last): superset-7594948b84-r6mpw superset File "/app/superset/views/base.py", line 210, in wraps superset-7594948b84-r6mpw superset return f(self, *args, **kwargs) superset-7594948b84-r6mpw superset File "/app/superset/utils/log.py", line 245, in wrapper superset-7594948b84-r6mpw superset value = f(*args, **kwargs) superset-7594948b84-r6mpw superset File "/app/superset/views/core.py", line 2407, in sql_json superset-7594948b84-r6mpw superset command_result: CommandResult = command.run() superset-7594948b84-r6mpw superset File "/app/superset/sqllab/command.py", line 114, in run superset-7594948b84-r6mpw superset raise ex superset-7594948b84-r6mpw superset File "/app/superset/sqllab/command.py", line 98, in run superset-7594948b84-r6mpw superset status = self._run_sql_json_exec_from_scratch() superset-7594948b84-r6mpw superset File "/app/superset/sqllab/command.py", line 151, in _run_sql_json_exec_from_scratch superset-7594948b84-r6mpw superset raise ex superset-7594948b84-r6mpw superset File "/app/superset/sqllab/command.py", line 146, in _run_sql_json_exec_from_scratch superset-7594948b84-r6mpw superset return self._sql_json_executor.execute( superset-7594948b84-r6mpw superset File "/app/superset/sqllab/sql_json_executer.py", line 111, in execute superset-7594948b84-r6mpw superset raise SupersetErrorsException( superset-7594948b84-r6mpw superset superset.exceptions.SupersetErrorsException: [SupersetError(message='Authentication required.', error_type=<SupersetErrorType.GENERIC_DB_ENGINE_ERROR: 'GENERIC_DB_ENGINE_ERROR'>, level=<ErrorLevel.ERROR: 'error'>, extra={'engine_name': 'PostgreSQL', 'issue_codes': [{'code': 1002, 'message': 'Issue 1002 - The database returned an unexpected error.'}]})] superset-7594948b84-r6mpw superset 92.184.112.135 - - [18/Jan/2023:11:24:41 +0000] "POST /superset/sql_json/ HTTP/1.1" 500 255 "https://superset.dev.data.frankfurt.gostudent.cloud/superset/sqllab/"; "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36" superset-7594948b84-r6mpw superset 92.184.112.135 - - [18/Jan/2023:11:24:43 +0000] "PUT /tabstateview/3 HTTP/1.1" 200 1 "https://superset.dev.data.frankfurt.gostudent.cloud/superset/sqllab/"; "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36" superset-7594948b84-r6mpw superset 92.184.112.135 - - [18/Jan/2023:11:24:43 +0000] "GET /superset/queries/1674040593720 HTTP/1.1" 200 657 "https://superset.dev.data.frankfurt.gostudent.cloud/superset/sqllab/"; "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36" ``` Yes, I made very very very sure I c/c'ed the proper password. I tried the said passwords running some python psycopg2 directly in the superset pod, it worked. #### How to reproduce the bug 1. Configure Superset own database or a Redshift database in the "Databases" tab 2. Go to SQL Query 3. Exploring the database works (up to displaying the column of a given table like superset's ab_role 5. Running query get a "Authentication required" ### Expected results A successful query ### Actual results A red banner "Authentication required" #### Screenshots Pasted one above, not really helpful ### Environment - browser type and version: latest stable Firefox 109.0 and Chromium 108.0.5359.124 snap (64 bits) - superset version: tried with 2.0.0 & 2.0.1, official container as the helm chart get it - python version: Python 3.8.12 - node.js version: command not found - any feature flags active: none - Superset own database is running on AWS RDS Aurora Postgresql serverless v2 with postgres engine, tried v13.6 & v14.5 versions - AWS Redshift up to date (they're dealing with the version themselves) - psycopg2, tried v2.9.1, v2.9.4, v2.9.5 - sqlalchemy-redshift 0.8.3, same error as "raw" psycopg above - I tried in both our dev & production environment (meaning VPC + Redshift + EKS where Superset is deployed) ### Checklist Make sure to follow these steps before submitting your issue - thank you! - [x] I have checked the superset logs for python stacktraces and included it here as text if there are any. - [x] I have reproduced the issue with at least the latest released version of superset. - [x] I have checked the issue tracker for the same issue and I haven't found one similar. ### Additional context Charts are working It used to work with a docker-compose based setup, and broke when migrated on Kubernetes. A data engineer workin with me told me he checked SQL Lab previously and it was ok. But I did reverted our (git based) settings, no luck. I already spent a day understanding a first cryptic "bulk" error that was just me using a human friendly DNS CNAME instead of AWS technical hostname hence a SSL verification issue. But now I'm at a loss. Can someone at least can tell me how to have more detailed logs ? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
