500 error post setup on docker install #1578

willnewby · 2017-02-09T03:27:48Z

Issue Summary

500 error on hitting the redash server post setup. Error messages that look like this:
http://pastebin.com/2sEVa3Ve
or

server_1 | [2017-02-09 03:22:46,964][PID:135][INFO][werkzeug] 172.19.0.1 - - [09/Feb/2017 03:22:46] "POST /setup HTTP/1.1" 302 - server_1 | [2017-02-09 03:22:46,978] ERROR in app: Exception on / [GET] server_1 | Traceback (most recent call last): server_1 | File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1988, in wsgi_app server_1 | response = self.full_dispatch_request() server_1 | File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1641, in full_dispatch_request server_1 | rv = self.handle_user_exception(e) server_1 | File "/usr/local/lib/python2.7/dist-packages/flask_restful/__init__.py", line 271, in error_router server_1 | return original_handler(e) server_1 | File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1544, in handle_user_exception server_1 | reraise(exc_type, exc_value, tb) server_1 | File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1639, in full_dispatch_request server_1 | rv = self.dispatch_request() server_1 | File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1625, in dispatch_request server_1 | return self.view_functions[rule.endpoint](**req.view_args) server_1 | File "/usr/local/lib/python2.7/dist-packages/flask_login/utils.py", line 228, in decorated_view server_1 | return func(*args, **kwargs) server_1 | File "/app/redash/handlers/static.py", line 30, in index server_1 | return send_file(full_path, **dict(cache_timeout=0, conditional=True)) server_1 | File "/usr/local/lib/python2.7/dist-packages/flask/helpers.py", line 536, in send_file server_1 | file = open(filename, 'rb') server_1 | IOError: [Errno 2] No such file or directory: '/app/redash/../client/dist/index.html' server_1 | [2017-02-09 03:22:46,978][PID:135][ERROR][redash] Exception on / [GET] server_1 | Traceback (most recent call last): server_1 | File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1988, in wsgi_app server_1 | response = self.full_dispatch_request() server_1 | File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1641, in full_dispatch_request server_1 | rv = self.handle_user_exception(e) server_1 | File "/usr/local/lib/python2.7/dist-packages/flask_restful/__init__.py", line 271, in error_router server_1 | return original_handler(e) server_1 | File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1544, in handle_user_exception server_1 | reraise(exc_type, exc_value, tb) server_1 | File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1639, in full_dispatch_request server_1 | rv = self.dispatch_request() server_1 | File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1625, in dispatch_request server_1 | return self.view_functions[rule.endpoint](**req.view_args) server_1 | File "/usr/local/lib/python2.7/dist-packages/flask_login/utils.py", line 228, in decorated_view server_1 | return func(*args, **kwargs) server_1 | File "/app/redash/handlers/static.py", line 30, in index server_1 | return send_file(full_path, **dict(cache_timeout=0, conditional=True)) server_1 | File "/usr/local/lib/python2.7/dist-packages/flask/helpers.py", line 536, in send_file server_1 | file = open(filename, 'rb') server_1 | IOError: [Errno 2] No such file or directory: '/app/redash/../client/dist/index.html' server_1 | [2017-02-09 03:22:46,983][PID:135][INFO][metrics] method=GET path=/ endpoint=redash.index status=500 content_type=? content_length=-1 duration=11.51 query_count=2 query_duration=2.19 server_1 | [2017-02-09 03:22:46,983][PID:135][INFO][werkzeug] 172.19.0.1 - - [09/Feb/2017 03:22:46] "GET / HTTP/1.1" 500 - worker_1 | [2017-02-09 03:22:47,039: INFO/MainProcess] Task redash.tasks.record_event[39c58eed-2ad4-4517-bc6a-227982950c7c] succeeded in 0.0860393460025s: None server_1 | [2017-02-09 03:22:47,187][PID:135][INFO][metrics] method=GET path=/favicon.ico endpoint=redash.send_static status=404 content_type=text/html content_length=233 duration=2.98 query_count=0 query_duration=0.00 server_1 | [2017-02-09 03:22:47,188][PID:135][INFO][werkzeug] 172.19.0.1 - - [09/Feb/2017 03:22:47] "GET /favicon.ico HTTP/1.1" 404 - worker_1 | [2017-02-09 03:22:48,722: INFO/MainProcess] Task redash.tasks.subscribe[e90ee60b-706c-4209-9d57-1975994abd7d] succeeded in 1.758983237s: None worker_1 | [2017-02-09 03:22:58,459: INFO/Beat] Scheduler: Sending due task refresh_queries (redash.tasks.refresh_queries) worker_1 | [2017-02-09 03:22:58,462: INFO/MainProcess] Received task: redash.tasks.refresh_queries[17466b50-6b20-487c-92e4-e2f0b17c4b3c] worker_1 | [2017-02-09 03:22:58,506: INFO/Worker-2] redash.tasks.refresh_queries[17466b50-6b20-487c-92e4-e2f0b17c4b3c]: Refreshing queries... worker_1 | [2017-02-09 03:22:58,518: INFO/Worker-2] redash.tasks.refresh_queries[17466b50-6b20-487c-92e4-e2f0b17c4b3c]: Done refreshing queries. Found 0 outdated queries: [] worker_1 | [2017-02-09 03:22:58,521: INFO/MainProcess] Task redash.tasks.refresh_queries[17466b50-6b20-487c-92e4-e2f0b17c4b3c] succeeded in 0.0576300719986s: None

Steps to Reproduce

Clone down the repo from master branch
docker-compose up
docker-compose run worker create_db (successful)
Go to site URL, fill in setup page successfully.
Submit setup page
500 error

I think the site should load up post setup, or else include more setup steps that happen to be missing.

Technical details:

Redash Version: current master branch
Browser/OS:
Docker version 1.13.0, build 49bf474
docker-compose version 1.10.0, build 4bd6f1a
Docker on Mac
How did you install Redash: clone repo, docker-compose up

The text was updated successfully, but these errors were encountered:

WesleyE · 2017-02-09T10:30:07Z

Same here on a fresh install. Connecting to port 5000 resulted in a half styled registration page. The form was unstyled and below the 'fold'. The right part with the logo did show up nicely. After posting that form the 500 showed up with the same log as above.

Mind you that on my attempt, the nginx container did not start:
edit: #1570 fixes that

2017/02/09 11:21:23 [emerg] 1#1: host not found in upstream "redash:5000" in /etc/nginx/conf.d/default.conf:2
nginx: [emerg] host not found in upstream "redash:5000" in /etc/nginx/conf.d/default.conf:2

The Celery container also had a error:

[2017-02-09 11:19:40,002: INFO/MainProcess] mingle: searching for neighbors
[2017-02-09 11:19:40,119: INFO/Beat] beat: Starting...
[2017-02-09 11:19:40,139: ERROR/Beat] Removing corrupted schedule file 'celerybeat-schedule': DBAccessError(13, 'Permission denied')
Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/celery/beat.py", line 376, in setup_schedule
    self._store = self._open_schedule()
  File "/usr/local/lib/python2.7/dist-packages/celery/beat.py", line 366, in _open_schedule
    return self.persistence.open(self.schedule_filename, writeback=True)
  File "/usr/lib/python2.7/shelve.py", line 243, in open
    return DbfilenameShelf(filename, flag, protocol, writeback)
  File "/usr/lib/python2.7/shelve.py", line 227, in __init__
    Shelf.__init__(self, anydbm.open(filename, flag), protocol, writeback)
  File "/usr/lib/python2.7/anydbm.py", line 85, in open
    return mod.open(file, flag, mode)
  File "/usr/lib/python2.7/dbhash.py", line 18, in open
    return bsddb.hashopen(file, flag, mode)
  File "/usr/lib/python2.7/bsddb/__init__.py", line 364, in hashopen
    d.open(file, db.DB_HASH, flags, mode)
DBAccessError: (13, 'Permission denied')
[2017-02-09 11:19:40,140: ERROR/Beat] Process Beat
Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/billiard/process.py", line 292, in _bootstrap
    self.run()
  File "/usr/local/lib/python2.7/dist-packages/celery/beat.py", line 553, in run
    self.service.start(embedded_process=True)
  File "/usr/local/lib/python2.7/dist-packages/celery/beat.py", line 470, in start
    humanize_seconds(self.scheduler.max_interval))
  File "/usr/local/lib/python2.7/dist-packages/kombu/utils/__init__.py", line 325, in __get__
    value = obj.__dict__[self.__name__] = self.__get(obj)
  File "/usr/local/lib/python2.7/dist-packages/celery/beat.py", line 512, in scheduler
    return self.get_scheduler()
  File "/usr/local/lib/python2.7/dist-packages/celery/beat.py", line 507, in get_scheduler
    lazy=lazy)
  File "/usr/local/lib/python2.7/dist-packages/celery/utils/imports.py", line 53, in instantiate
    return symbol_by_name(name)(*args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/celery/beat.py", line 358, in __init__
    Scheduler.__init__(self, *args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/celery/beat.py", line 185, in __init__
    self.setup_schedule()
  File "/usr/local/lib/python2.7/dist-packages/celery/beat.py", line 384, in setup_schedule
    self._store = self._destroy_open_corrupted_schedule(exc)
  File "/usr/local/lib/python2.7/dist-packages/celery/beat.py", line 372, in _destroy_open_corrupted_schedule
    return self._open_schedule()
  File "/usr/local/lib/python2.7/dist-packages/celery/beat.py", line 366, in _open_schedule
    return self.persistence.open(self.schedule_filename, writeback=True)
  File "/usr/lib/python2.7/shelve.py", line 243, in open
    return DbfilenameShelf(filename, flag, protocol, writeback)
  File "/usr/lib/python2.7/shelve.py", line 227, in __init__
    Shelf.__init__(self, anydbm.open(filename, flag), protocol, writeback)
  File "/usr/lib/python2.7/anydbm.py", line 85, in open
    return mod.open(file, flag, mode)
  File "/usr/lib/python2.7/dbhash.py", line 18, in open
    return bsddb.hashopen(file, flag, mode)
  File "/usr/lib/python2.7/bsddb/__init__.py", line 364, in hashopen
    d.open(file, db.DB_HASH, flags, mode)
DBAccessError: (13, 'Permission denied')
[2017-02-09 11:19:42,007: INFO/MainProcess] mingle: all alone

My workflow:

Clone Repo
git checkout tags/v1.0.0-rc.1
docker-compose -f docker-compose.production.yml run --rm server create_db
docker-compose -f docker-compose.production.yml up

Versions:

Docker on Windows
docker-compose version 1.10.0, build 4bd6f1a0
Docker version 1.13.0, build 49bf474

WesleyE · 2017-02-09T10:57:17Z

Investigated further. It seems that the docker build is missing the npm install and npm run build commands.

Doing this fixes the problem:

docker exec -i -t 854f1fb81a91 /bin/bash
npm install
npm run build
exit

arikfr · 2017-02-09T15:08:46Z

Should be good now, just pull latest docker file and compose files.

I suggest you delete your containers, (docker-compose rm) and recreate them, as sometimes network configuration don't update on start/restart.

buddies2705 · 2017-02-14T17:14:07Z

Still having same issue after the updated docker file . Still need to run "npm run build"

renderit · 2017-08-30T21:48:26Z

Yes, still the same issue here.. On running npm run build I get:

> redash-client@3.0.0 build /Users/muuppal/work/redash
> rm -rf ./client/dist/ && NODE_ENV=production node node_modules/.bin/webpack

Hash: b9c6a3928adb1844c075
Version: webpack 2.7.0
Time: 1527ms
                               Asset       Size  Chunks             Chunk Names
         app.293fb4a9aa874a704698.js  895 bytes       0  [emitted]  app
    manifest.c453d7a6421621373984.js    1.48 kB       1  [emitted]  manifest
     app.293fb4a9aa874a704698.js.map    1.22 kB       0  [emitted]  app
manifest.c453d7a6421621373984.js.map    14.5 kB       1  [emitted]  manifest
                          index.html  723 bytes          [emitted]
                      multi_org.html  735 bytes          [emitted]
   [0] ./client/app/index.js 803 bytes {0} [built] [failed] [1 error]

ERROR in ./client/app/index.js
Module build failed: TypeError: Cannot read property 'length' of undefined
    at Traverser.traverse (/Users/muuppal/work/redash/node_modules/estraverse/estraverse.js:411:37)
    at Traverser.traverse (/Users/muuppal/work/redash/node_modules/eslint/lib/util/traverser.js:31:22)
    at EventEmitter.module.exports.api.verify (/Users/muuppal/work/redash/node_modules/eslint/lib/eslint.js:926:23)
    at processText (/Users/muuppal/work/redash/node_modules/eslint/lib/cli-engine.js:264:31)
    at CLIEngine.executeOnText (/Users/muuppal/work/redash/node_modules/eslint/lib/cli-engine.js:754:26)
    at lint (/Users/muuppal/work/redash/node_modules/eslint-loader/index.js:218:17)
    at Object.module.exports (/Users/muuppal/work/redash/node_modules/eslint-loader/index.js:213:21)
Child html-webpack-plugin for "multi_org.html":
       [0] ./~/html-webpack-plugin/lib/loader.js!./client/app/multi_org.html 654 bytes {0} [built]
Child html-webpack-plugin for "index.html":
       [0] ./~/lodash/lodash.js 540 kB {0} [built]
       [1] ./~/html-webpack-plugin/lib/loader.js!./client/app/index.html 946 bytes {0} [built]
       [2] (webpack)/buildin/global.js 509 bytes {0} [built]
       [3] (webpack)/buildin/module.js 517 bytes {0} [built]
npm ERR! code ELIFECYCLE
npm ERR! errno 2
npm ERR! redash-client@3.0.0 build: `rm -rf ./client/dist/ && NODE_ENV=production node node_modules/.bin/webpack`
npm ERR! Exit status 2
npm ERR!
npm ERR! Failed at the redash-client@3.0.0 build script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR!     /Users/muuppal/.npm/_logs/2017-08-30T21_48_12_100Z-debug.log

I tried it again after docker-compose rm but getting same error. On terminal I can also see

worker_1    | ProgrammingError: (psycopg2.ProgrammingError) relation "queries" does not exist
worker_1    | LINE 2: FROM queries LEFT OUTER JOIN query_results AS query_results_...
worker_1    |              ^

TonyStarkBy · 2017-09-15T21:10:41Z

I have the same error with running npm run build

> redash-client@3.0.0 build /Users/kot/git/python/t2/redash
> rm -rf ./client/dist/ && NODE_ENV=production node node_modules/.bin/webpack
Hash: 2c18853529de3a248d55
Version: webpack 2.7.0
Time: 1218ms
                               Asset       Size  Chunks             Chunk Names
         app.f188f8b699ccb9fc1f47.js  930 bytes       0  [emitted]  app
    manifest.f02fa98bafb241cc0f6e.js    1.48 kB       1  [emitted]  manifest
     app.f188f8b699ccb9fc1f47.js.map    1.26 kB       0  [emitted]  app
manifest.f02fa98bafb241cc0f6e.js.map    14.5 kB       1  [emitted]  manifest
                          index.html  723 bytes          [emitted]
                      multi_org.html  735 bytes          [emitted]
   [0] ./client/app/index.js 838 bytes {0} [built] [failed] [1 error]

ERROR in ./client/app/index.js
Module build failed: TypeError: Cannot read property 'length' of undefined
    at Traverser.traverse (/Users/kot/git/python/t2/redash/node_modules/estraverse/estraverse.js:411:37)
    at Traverser.traverse (/Users/kot/git/python/t2/redash/node_modules/eslint/lib/util/traverser.js:31:22)
    at EventEmitter.module.exports.api.verify (/Users/kot/git/python/t2/redash/node_modules/eslint/lib/eslint.js:926:23)
    at processText (/Users/kot/git/python/t2/redash/node_modules/eslint/lib/cli-engine.js:264:31)
    at CLIEngine.executeOnText (/Users/kot/git/python/t2/redash/node_modules/eslint/lib/cli-engine.js:754:26)
    at lint (/Users/kot/git/python/t2/redash/node_modules/eslint-loader/index.js:218:17)
    at Object.module.exports (/Users/kot/git/python/t2/redash/node_modules/eslint-loader/index.js:213:21)
Child html-webpack-plugin for "multi_org.html":
       [0] ./~/html-webpack-plugin/lib/loader.js!./client/app/multi_org.html 654 bytes {0} [built]
Child html-webpack-plugin for "index.html":
       [0] ./~/lodash/lodash.js 540 kB {0} [built]
       [1] ./~/html-webpack-plugin/lib/loader.js!./client/app/index.html 946 bytes {0} [built]
       [2] (webpack)/buildin/global.js 509 bytes {0} [built]
       [3] (webpack)/buildin/module.js 517 bytes {0} [built]`

is2ei · 2018-06-10T13:13:10Z

I had same issue. npm run build worked.
I think this ticket should be reopen.

kravets-levko · 2018-06-11T21:52:36Z

@is2ei which version have you tried to install, and which type of installation did you use?

is2ei · 2018-06-11T22:54:25Z

@kravets-levko I followed the instruction in https://redash.io/help/open-source/dev-guide/docker

My environment is Debian.

$ lsb_release -a
No LSB modules are available.
Distributor ID:	Debian
Description:	Debian GNU/Linux 9.4 (stretch)
Release:	9.4
Codename:	stretch
$ npm --version
6.1.0
$ docker --version
Docker version 18.03.1-ce, build 9ee9f40
$ docker-compose --version
docker-compose version 1.21.2, build a133471

kravets-levko · 2018-06-12T11:03:10Z

@is2ei the article contains npm run build step (see Usage section). Please next time read all instructions carefully before reporting issues - just to ensure that you did all the possible and it does not work (and it's really a bug)

avishalom · 2020-10-15T12:11:24Z

@kravets-levko does this mean that these extra steps (npm run build) will be necessary with every deployment, and subsequent container restart ?

arikfr mentioned this issue Feb 9, 2017

Updates to Dockerfile: #1582

Merged

arikfr closed this as completed in #1582 Feb 9, 2017

RichardLitt reopened this Jun 11, 2018

kravets-levko closed this as completed Jun 12, 2018

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

500 error post setup on docker install #1578

500 error post setup on docker install #1578

willnewby commented Feb 9, 2017 •

edited by arikfr

Loading

WesleyE commented Feb 9, 2017 •

edited

Loading

WesleyE commented Feb 9, 2017

arikfr commented Feb 9, 2017

buddies2705 commented Feb 14, 2017 •

edited

Loading

renderit commented Aug 30, 2017 •

edited

Loading

TonyStarkBy commented Sep 15, 2017

is2ei commented Jun 10, 2018

kravets-levko commented Jun 11, 2018 •

edited

Loading

is2ei commented Jun 11, 2018

kravets-levko commented Jun 12, 2018

avishalom commented Oct 15, 2020

500 error post setup on docker install #1578

500 error post setup on docker install #1578

Comments

willnewby commented Feb 9, 2017 • edited by arikfr Loading

Issue Summary

Steps to Reproduce

Technical details:

WesleyE commented Feb 9, 2017 • edited Loading

WesleyE commented Feb 9, 2017

arikfr commented Feb 9, 2017

buddies2705 commented Feb 14, 2017 • edited Loading

renderit commented Aug 30, 2017 • edited Loading

TonyStarkBy commented Sep 15, 2017

is2ei commented Jun 10, 2018

kravets-levko commented Jun 11, 2018 • edited Loading

is2ei commented Jun 11, 2018

kravets-levko commented Jun 12, 2018

avishalom commented Oct 15, 2020

willnewby commented Feb 9, 2017 •

edited by arikfr

Loading

WesleyE commented Feb 9, 2017 •

edited

Loading

buddies2705 commented Feb 14, 2017 •

edited

Loading

renderit commented Aug 30, 2017 •

edited

Loading

kravets-levko commented Jun 11, 2018 •

edited

Loading