You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2022/08/04 01:17:56 UTC
[GitHub] [superset] nightbear1009 opened a new issue, #20968: DB engine Error
nightbear1009 opened a new issue, #20968:
URL: https://github.com/apache/superset/issues/20968
after upgrade to superset 2.0.0 global filter is not working the error message is shown as below
i am connect to Bigquery and I find out when using filter with `=` it works. But when using `in` filter shown error
```
Unexpected param: (2, 3)
This may be triggered by:
Issue 1011 - Superset encountered an unexpected error.
Please reach out to the Chart Owner for assistance.
Chart Owner: Admin Admin
```
and the image is shown as below
<img width="995" alt="image" src="https://user-images.githubusercontent.com/5819643/182741826-4f0fe2d0-eb5a-4026-bcf6-5ff20dadfea9.png">
--
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-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] Yatagani commented on issue #20968: DB engine Error
Posted by GitBox <gi...@apache.org>.
Yatagani commented on issue #20968:
URL: https://github.com/apache/superset/issues/20968#issuecomment-1253678193
Hi @venkatAkula8, I had the exact same issue. Install `sqlalchemy-bigquery` instead of `pybigquery` in the `values.yaml` config file. Seems like `pybigquery` is outdated. https://pypi.org/project/pybigquery/
--
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-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] venkatAkula8 commented on issue #20968: DB engine Error
Posted by GitBox <gi...@apache.org>.
venkatAkula8 commented on issue #20968:
URL: https://github.com/apache/superset/issues/20968#issuecomment-1238987795
Hi [nightbear1009](https://github.com/nightbear1009), I'm also facing same issue. Did you find any solution?
Thank you
--
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-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] DB engine Error [superset]
Posted by "xxcmp1977 (via GitHub)" <gi...@apache.org>.
xxcmp1977 commented on issue #20968:
URL: https://github.com/apache/superset/issues/20968#issuecomment-1887054862
Same here!
Restarted superset and got this error
I'm using mssql connection, so there is only line
pymssql
in requirements-local.txt
--
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-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] Yatagani commented on issue #20968: DB engine Error
Posted by GitBox <gi...@apache.org>.
Yatagani commented on issue #20968:
URL: https://github.com/apache/superset/issues/20968#issuecomment-1260788943
Hi @pthirumalai,
Can you ensure that the update was successfully made? And the helm chart now has the right configuration.
To upgrade chart on Kubernetes run: helm upgrade --install --values values.yaml superset superset/superset
To see if your current chart config run: helm get values superset
My output:
```
bootstrapScript: |
#!/bin/bash
rm -rf /var/lib/apt/lists/* && \
pip install \
psycopg2-binary==2.9.1 \
sqlalchemy-bigquery==1.4.0 \
redis==3.5.3 && \
if [ ! -f ~/bootstrap ]; then echo "Running Superset with uid {{ .Values.runAsUser }}" > ~/bootstrap; fi
```
--
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-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] pthirumalai commented on issue #20968: DB engine Error
Posted by GitBox <gi...@apache.org>.
pthirumalai commented on issue #20968:
URL: https://github.com/apache/superset/issues/20968#issuecomment-1262105296
Hi @Yatagani
We have installed Apache superset in Docker, How can we check whether we have configured correctly in Docker ?
Thanks
--
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-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] pthirumalai commented on issue #20968: DB engine Error
Posted by GitBox <gi...@apache.org>.
pthirumalai commented on issue #20968:
URL: https://github.com/apache/superset/issues/20968#issuecomment-1260762139
Hi @Yatagani , I created a dashboard with filter and when I tried to use the filter to manipulate the dashboard, I am getting "DB engine error". We installed sqlalchemy-bigquery and uninstalled pybigquery but still we have this issue. Do we need to make any changes to the values.yaml file ?
--
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-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] ramirobg94 commented on issue #20968: DB engine Error
Posted by "ramirobg94 (via GitHub)" <gi...@apache.org>.
ramirobg94 commented on issue #20968:
URL: https://github.com/apache/superset/issues/20968#issuecomment-1509884121
I have the same error with Postgresql and running the examples
The database used on the query different from examples is remote, I am able to query and get the data but not able to build charts with graphics. But If I create a dataset from this query I can.
```
docker build -t supersetcustom .
docker run -d -pdocker build -t nodebb . 8080:8088 -e "SUPERSET_SECRET_KEY=KEYKEY" --name superset superset
docker exec -it superset superset fab create-admin --username admin --firstname Superset --lastname Admin --email admin@superset.com --password admin
docker exec -it superset superset db upgrade
docker exec -it superset superset load_examples
docker exec -it superset superset init
```
and my Dockerfile is:
```
FROM apache/superset
# Switching to root to install the required packages
USER root
# Example: installing the MySQL driver to connect to the metadata database
# if you prefer Postgres, you may want to use `psycopg2-binary` instead
# RUN pip install mysqlclient
RUN pip install psycopg2
RUN pip install psycopg2-binary
# Example: installing a driver to connect to Redshift
# Find which driver you need based on the analytics database
# you want to connect to here:
# https://superset.apache.org/installation.html#database-dependencies
# RUN pip install sqlalchemy-redshift
# RUN pop install sqlalchemy-bigquery
# RUN pip install sqlalchemy-bigquery
# Switching back to using the `superset` user
RUN pip install sqlalchemy-bigquery
USER superset
```
<img width="1680" alt="Captura de Pantalla 2023-04-15 a las 18 05 00" src="https://user-images.githubusercontent.com/11272068/232237136-633b063d-3ae7-46b1-8cb5-1c7a597fc62b.png">
<img width="1675" alt="Captura de Pantalla 2023-04-15 a las 17 49 50" src="https://user-images.githubusercontent.com/11272068/232237133-5b0c2049-950d-4cb6-9543-1bc5e15a0f8e.png">
![Uploading Captura de Pantalla 2023-04-15 a las 18.05.00.png…]()
--
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-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] saghatelian commented on issue #20968: DB engine Error
Posted by GitBox <gi...@apache.org>.
saghatelian commented on issue #20968:
URL: https://github.com/apache/superset/issues/20968#issuecomment-1274351978
Hi @pthirumalai
We also have a Docker installation.
Changing `pybigquery` to `sqlalchemy-bigquery` in `docker/requirements-local.txt` solved the issue for me.
--
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-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] DB engine Error [superset]
Posted by "xxcmp1977 (via GitHub)" <gi...@apache.org>.
xxcmp1977 commented on issue #20968:
URL: https://github.com/apache/superset/issues/20968#issuecomment-1887222120
resolved by downgrading pymssql driver to pymssql==2.2.3 in /app/docker/requirements-local.txt
(It didn't work with pymssql 2.2.11)
I'm using connection string like this:
mssql+pymssql://sqluser:sqlpassword@192.168.1.4\NameOfInstance/NameOdDatabase
--
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-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] pthirumalai commented on issue #20968: DB engine Error
Posted by GitBox <gi...@apache.org>.
pthirumalai commented on issue #20968:
URL: https://github.com/apache/superset/issues/20968#issuecomment-1274496062
Hi @saghatelian
The issue got resolved after we made changes to the docker/requirements-local.txt as per your suggestion. Thanks.
--
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-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] nightbear1009 commented on issue #20968: DB engine Error
Posted by GitBox <gi...@apache.org>.
nightbear1009 commented on issue #20968:
URL: https://github.com/apache/superset/issues/20968#issuecomment-1239521773
prevent pip install elaticsearch solve my problem
--
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-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] DB engine Error [superset]
Posted by "duchuynh (via GitHub)" <gi...@apache.org>.
duchuynh commented on issue #20968:
URL: https://github.com/apache/superset/issues/20968#issuecomment-1832442806
Hi, bumping this because I am having the same error when I shut down Superset and start it again...
--
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-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org