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/06/17 18:56:23 UTC
[GitHub] [incubator-superset] badman-rodriguez opened a new issue #10087: Question on Readonly DB error
badman-rodriguez opened a new issue #10087:
URL: https://github.com/apache/incubator-superset/issues/10087
Currently when i build the Dockerfile (the one in the root directory) and execute it... it works fine. Site comes up, no prob.
But, i am not able to add a dashboard. Im just trying to make sure this works properly before launching it to a production environment.
```
/usr/local/lib/python3.6/site-packages/flask_caching/__init__.py:189: UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively disabled.
"Flask-Caching: CACHE_TYPE is set to null, "
/usr/local/lib/python3.6/site-packages/flask_appbuilder/fields.py:182: UserWarning: allow_blank=True does not do anything for QuerySelectMultipleField.
"allow_blank=True does not do anything for QuerySelectMultipleField."
ERROR:flask_appbuilder.models.sqla.interface:Add record error: (sqlite3.OperationalError) attempt to write a readonly database
[SQL: INSERT INTO dashboards (created_on, changed_on, dashboard_title, position_json, description, css, json_metadata, slug, published, created_by_fk, changed_by_fk) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
[parameters: ('2020-06-17 18:22:23.045075', '2020-06-17 18:22:23.045085', 'Test', None, None, None, None, 'test', 0, 1, 1)]
(Background on this error at: http://sqlalche.me/e/e3q8)
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 590, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: attempt to write a readonly database
```
Thanks in advance, appreciate the help.
- Superset version: 0.36
- Python version 3.6
- Docker Versions 19.03.5
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] badman-rodriguez edited a comment on issue #10087: Question on Readonly DB error
Posted by GitBox <gi...@apache.org>.
badman-rodriguez edited a comment on issue #10087:
URL: https://github.com/apache/incubator-superset/issues/10087#issuecomment-646031808
@dpgaspar i suspected as much... but i was curious if it was setting/config that managed the permissions.
For example:
`docker-compose.yml` file, which uses Dockerfile-dev, and spins up a dev version of the application. No issues on the sqlite permissions
`Dockerfile`, setting the application to production... sqlite permissions.
I mean its fine for me to manually do this and add it to the dockerfile tasks to do `chmod` but... i assuming that it shouldnt be this way....
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] badman-rodriguez commented on issue #10087: Question on Readonly DB error
Posted by GitBox <gi...@apache.org>.
badman-rodriguez commented on issue #10087:
URL: https://github.com/apache/incubator-superset/issues/10087#issuecomment-655074350
Fixed the 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.
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] [incubator-superset] issue-label-bot[bot] commented on issue #10087: Question on Readonly DB error
Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #10087:
URL: https://github.com/apache/incubator-superset/issues/10087#issuecomment-645559647
Issue-Label Bot is automatically applying the label `#question` to this issue, with a confidence of 0.71. Please mark this comment with :thumbsup: or :thumbsdown: to give our bot feedback!
Links: [app homepage](https://github.com/marketplace/issue-label-bot), [dashboard](https://mlbot.net/data/apache/incubator-superset) and [code](https://github.com/hamelsmu/MLapp) for this bot.
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] badman-rodriguez commented on issue #10087: Question on Readonly DB error
Posted by GitBox <gi...@apache.org>.
badman-rodriguez commented on issue #10087:
URL: https://github.com/apache/incubator-superset/issues/10087#issuecomment-646171836
@dpgaspar So i realized its not a permissions issues, its a multiple process issue (also listed in that stack overflow)
its when i was creating the superset admin user:
```
superset fab create-admin \
--username admin \
--firstname Superset \
--lastname Admin \
--email admin@superset.com \
--password admin
```
i was using `docker-init.sh` before the usage of the `docker-entrypoint.sh`
obviously... that's not working. When should i create the admin user in the Dockerfile? i havent been able to succesfully create it and have it run properly.
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] badman-rodriguez commented on issue #10087: Question on Readonly DB error
Posted by GitBox <gi...@apache.org>.
badman-rodriguez commented on issue #10087:
URL: https://github.com/apache/incubator-superset/issues/10087#issuecomment-646031808
@dpgaspar i suspected as much... but i was curious if it was setting/config that managed the permissions.
For example:
`docker-compose.yml` file, which uses Dockerfile-dev, and spins up a dev version of the application. No issues on the sqlite permissions
Dockerfile, setting the application to production... sqlite permissions.
I mean its fine for me to manually do this and add it to the dockerfile tasks to do `chmod` but... i assuming that it shouldnt be this way....
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] badman-rodriguez edited a comment on issue #10087: Question on Readonly DB error
Posted by GitBox <gi...@apache.org>.
badman-rodriguez edited a comment on issue #10087:
URL: https://github.com/apache/incubator-superset/issues/10087#issuecomment-646031808
@dpgaspar i suspected as much... but i was curious if it was setting/config that managed the permissions.
For example:
`docker-compose.yml` file, which uses `Dockerfile-dev`, and spins up a dev version of the application. No issues on the sqlite permissions
`Dockerfile`, setting the application to production... sqlite permissions.
I mean its fine for me to manually do this and add it to the dockerfile tasks to do `chmod` but... i assuming that it shouldnt be this way....
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] badman-rodriguez closed issue #10087: Question on Readonly DB error
Posted by GitBox <gi...@apache.org>.
badman-rodriguez closed issue #10087:
URL: https://github.com/apache/incubator-superset/issues/10087
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] dpgaspar commented on issue #10087: Question on Readonly DB error
Posted by GitBox <gi...@apache.org>.
dpgaspar commented on issue #10087:
URL: https://github.com/apache/incubator-superset/issues/10087#issuecomment-645910454
Hi @badman-rodriguez,
Have you checked all of these: https://stackoverflow.com/questions/1518729/change-sqlite-database-mode-to-read-write
?
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org