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 2020/03/08 17:23:45 UTC
[GitHub] [incubator-superset] akki opened a new issue #9258: Superset
docker-compose gave error
akki opened a new issue #9258: Superset docker-compose gave error
URL: https://github.com/apache/incubator-superset/issues/9258
A clear and concise description of what the bug is.
I tried running the following code:
```
git clone https://github.com/apache/incubator-superset/
cd incubator-superset
# you can run this command everytime you need to start superset now:
docker-compose up
```
as mentioned here - https://superset.incubator.apache.org/installation.html#start-with-docker
### Expected results
Expect Superset UI to allow me to access it and it should work.
### Actual results
The UI didn't recognize the credentials at first. Then I went inside the Docker container of superset named `incubator-superset_superset` and ran the following command:
```
superset fab create-admin \
--username admin \
--firstname Superset \
--lastname Admin \
--email admin@superset.com \
--password admin
```
which I copied from here - https://github.com/apache/incubator-superset/blob/master/docker/docker-init.sh#L36.
I got authenticated successfully but got an error page, the content of which is as following:
```
sqlalchemy.exc.ProgrammingError
sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) relation "user_attribute" does not exist
LINE 2: FROM user_attribute
^
[SQL: SELECT user_attribute.welcome_dashboard_id AS user_attribute_welcome_dashboard_id
FROM user_attribute
WHERE user_attribute.user_id = %(user_id_1)s]
[parameters: {'user_id_1': '1'}]
(Background on this error at: http://sqlalche.me/e/f405)
Traceback (most recent call last)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1246, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 581, in do_execute
cursor.execute(statement, parameters)
The above exception was the direct cause of the following exception:
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2463, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2449, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1866, in handle_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python3.6/site-packages/flask/_compat.py", line 39, in reraise
raise value
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2446, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1951, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1820, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python3.6/site-packages/flask/_compat.py", line 39, in reraise
raise value
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1949, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1935, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/app/superset/views/core.py", line 2633, in welcome
.filter_by(user_id=g.user.get_id())
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3355, in scalar
ret = self.one()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3325, in one
ret = self.one_or_none()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3294, in one_or_none
ret = list(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3367, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3392, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 982, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1101, in _execute_clauseelement
distilled_params,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1250, in _execute_context
e, statement, parameters, cursor, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1476, in _handle_dbapi_exception
util.raise_from_cause(sqlalchemy_exception, exc_info)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 152, in reraise
raise value.with_traceback(tb)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1246, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 581, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) relation "user_attribute" does not exist
LINE 2: FROM user_attribute
^
[SQL: SELECT user_attribute.welcome_dashboard_id AS user_attribute_welcome_dashboard_id
FROM user_attribute
WHERE user_attribute.user_id = %(user_id_1)s]
[parameters: {'user_id_1': '1'}]
(Background on this error at: http://sqlalche.me/e/f405)
The debugger caught an exception in your WSGI application. You can now look at the traceback which led to the error.
To switch between the interactive traceback and the plaintext one, you can click on the "Traceback" headline. From the text traceback you can also create a paste of it. For code execution mouse-over the frame you want to debug and click on the console icon on the right side.
You can execute arbitrary Python code in the stack frames and there are some extra helpers available for introspection:
dump() shows all variables in the frame
dump(obj) dumps all that's known about the object
```
#### How to reproduce the bug
Run steps mentioned previously.
It is worth noting that when I follow the same steps with the branch [`0.36`](https://github.com/apache/incubator-superset/blob/0.36/docker/docker-init.sh) I do not see this problem.
### Environment
(please complete the following information):
- superset version: `master` branch
- python version: based on the docker-compose file
- node.js version: based on the docker-compose file
- npm version: based on the docker-compose file
### Checklist
Make sure these boxes are checked 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
Add any other context about the problem here.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] willbarrett commented on issue #9258: Superset
docker-compose gave error
Posted by GitBox <gi...@apache.org>.
willbarrett commented on issue #9258: Superset docker-compose gave error
URL: https://github.com/apache/incubator-superset/issues/9258#issuecomment-596723191
OK @akki - I was unable to duplicate the issue you ran into, but I've done some thinking about what would cause it. If the database setup did not finish successfully, that would explain the issue you're seeing. As a next step, here are some things to try:
If you're running Docker Desktop (e.g. if you're on a mac and not Linux), make sure that you have at least 6GB of RAM assigned to Docker.
Try running `docker-compose down -rmi all -v` followed by `docker-compose up`. This will remove any linger containers and volumes and re-start the build from scratch. Please check the logs, especially from the `superset-init_1` container for any errors. I'm guessing that something about your setup is causing an error creating the proper database schema, and I'm hoping the issue will appear in those 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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] willbarrett commented on issue #9258: Superset
docker-compose gave error
Posted by GitBox <gi...@apache.org>.
willbarrett commented on issue #9258: Superset docker-compose gave error
URL: https://github.com/apache/incubator-superset/issues/9258#issuecomment-598254490
No worries. We're still evolving the docker-compose setup to be more reliable under a number of circumstances. I'll close this for now given our inability to reproduce.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] akki edited a comment on issue #9258: Superset
docker-compose gave error
Posted by GitBox <gi...@apache.org>.
akki edited a comment on issue #9258: Superset docker-compose gave error
URL: https://github.com/apache/incubator-superset/issues/9258#issuecomment-597961993
Hi @willbarrett Thanks for the investigation.
I was not able to work further on this and I am not very confident that I'll be able to try your steps any soon.
Since it is working on the latest release and the `master` branch is working on your laptop, I am happy for now - maybe it was just something about my setup (I do use a Mac BTW).
If I am able to see the behaviour again, I'll post more details here again.
Meanwhile, feel free to the close this issue if you see fit (and apologies of not being of help further right now).
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] mistercrunch commented on issue #9258:
Superset docker-compose gave error
Posted by GitBox <gi...@apache.org>.
mistercrunch commented on issue #9258: Superset docker-compose gave error
URL: https://github.com/apache/incubator-superset/issues/9258#issuecomment-596230100
@craig-rueda @willbarrett
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] dpgaspar closed issue #9258: Superset
docker-compose gave error
Posted by GitBox <gi...@apache.org>.
dpgaspar closed issue #9258: Superset docker-compose gave error
URL: https://github.com/apache/incubator-superset/issues/9258
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] akki commented on issue #9258: Superset
docker-compose gave error
Posted by GitBox <gi...@apache.org>.
akki commented on issue #9258: Superset docker-compose gave error
URL: https://github.com/apache/incubator-superset/issues/9258#issuecomment-597961993
Hi @willbarrett Thanks for the investigation.
I was not able to work further on this and I am not very confident that I'll able to try your steps any soon.
Since it is working on the latest release and the `master` branch is working on your laptop, I am happy for now - maybe it was just something about my setup (I do use a Mac BTW).
If I am able to see the behaviour again, I'll post more details here again.
Meanwhile, feel free to the close this issue if you see fit (and apologies of not being of help further right now).
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] willbarrett commented on issue #9258: Superset
docker-compose gave error
Posted by GitBox <gi...@apache.org>.
willbarrett commented on issue #9258: Superset docker-compose gave error
URL: https://github.com/apache/incubator-superset/issues/9258#issuecomment-596618854
Thanks for the report @akki - I'll see if I can reproduce the error you're running into today and get back to 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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] akki commented on issue #9258: Superset
docker-compose gave error
Posted by GitBox <gi...@apache.org>.
akki commented on issue #9258: Superset docker-compose gave error
URL: https://github.com/apache/incubator-superset/issues/9258#issuecomment-596229494
It seems similar to https://github.com/apache/incubator-superset/issues/6918 but we are running different commands.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org