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