Setup Issue using setup.sh (Redash環境構築が正常に実行できない)

sugato · January 5, 2020, 12:04pm

A summary of the issue

公式の手順に沿ってdocker上でRedashの環境を構築しようとしたのですが、いくつか詰まってしまいお知恵をお借りしたいです。

postgresに関するエラーは、volumeを利用することで回避できました。
起動は何とかできたのですが、ログイン画面が表示されない、というのが現状です。
EC2やDockerを初めて利用したため、理解が甘い部分があると思いますが、よろしくお願いします。

Postgres errors could be avoided by using volume.
I managed to start, but the login screen is not displayed

the browser/OS environment in which it occurs.

AWS EC2
OS:Ubuntu 18.04 LTS
Docker version 19.03.5
docker-compose version 1.22.0

参考(Reference)

手順(Procedure)

EC2でUbuntuを起動
Launch Ubuntu on EC2
setup用のリポジトリを持ってくる
Clone the repository for setup
下記を実行
cd setup
bash setup.sh
redash_postgres_1の構築部分でエラーになる

ubuntu@ip-172-31-15-103:~/setup$ bash setup.sh
Reading package lists... Done
Building dependency tree
Reading state information... Done
ca-certificates is already the newest version (20180409).
pwgen is already the newest version (2.08-1).
curl is already the newest version (7.58.0-2ubuntu3.8).
software-properties-common is already the newest version (0.96.24.32.12).
wget is already the newest version (1.19.4-1ubuntu2.2).
apt-transport-https is already the newest version (1.6.12).
The following package was automatically installed and is no longer required:
  libdumbnet1
Use 'sudo apt autoremove' to remove it.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
OK
Hit:1 http://us-east-2.ec2.archive.ubuntu.com/ubuntu bionic InRelease
Hit:2 http://us-east-2.ec2.archive.ubuntu.com/ubuntu bionic-updates InRelease
Hit:3 http://us-east-2.ec2.archive.ubuntu.com/ubuntu bionic-backports InRelease
Hit:4 https://download.docker.com/linux/ubuntu bionic InRelease
Get:5 http://security.ubuntu.com/ubuntu bionic-security InRelease [88.7 kB]
Fetched 88.7 kB in 1s (175 kB/s)
Reading package lists... Done
Hit:1 http://us-east-2.ec2.archive.ubuntu.com/ubuntu bionic InRelease
Hit:2 http://us-east-2.ec2.archive.ubuntu.com/ubuntu bionic-updates InRelease
Hit:3 http://us-east-2.ec2.archive.ubuntu.com/ubuntu bionic-backports InRelease
Hit:4 https://download.docker.com/linux/ubuntu bionic InRelease
Get:5 http://security.ubuntu.com/ubuntu bionic-security InRelease [88.7 kB]
Fetched 88.7 kB in 1s (168 kB/s)
Reading package lists... Done
Reading package lists... Done
Building dependency tree
Reading state information... Done
docker-ce is already the newest version (5:19.03.5~3-0~ubuntu-bionic).
The following package was automatically installed and is no longer required:
  libdumbnet1
Use 'sudo apt autoremove' to remove it.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100   617    0   617    0     0   3164      0 --:--:-- --:--:-- --:--:--  3147
100 11.2M  100 11.2M    0     0  12.0M      0 --:--:-- --:--:-- --:--:-- 12.0M
--2020-01-05 10:31:10--  https://raw.githubusercontent.com/getredash/setup/master/data/docker-compose.yml
Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 151.101.248.133
Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|151.101.248.133|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1076 (1.1K) [text/plain]
Saving to: ‘docker-compose.yml’
docker-compose.yml                       100%[=================================================================================>]   1.05K  --.-KB/s    in 0s
2020-01-05 10:31:10 (161 MB/s) - ‘docker-compose.yml’ saved [1076/1076]
Pulling redis (redis:5.0-alpine)...
5.0-alpine: Pulling from library/redis
e6b0cf9c0882: Pull complete
7c5ff11edca6: Pull complete
14fa80ee9473: Pull complete
4d4f6840431a: Pull complete
9d4162ad1104: Pull complete
b2c320096d0f: Pull complete
Digest: sha256:a4e0b7bff7ecec0dc0be95d185d6c99323a92a51065d9563a5bafbc1cf6b3497
Status: Downloaded newer image for redis:5.0-alpine
Pulling postgres (postgres:9.6-alpine)...
9.6-alpine: Pulling from library/postgres
89d9c30c1d48: Pull complete
66ddea140797: Pull complete
977cf4e465c1: Pull complete
bf767ccee4ed: Pull complete
608d60dd3761: Pull complete
3a4aae018173: Pull complete
1e4b8fd4dd20: Pull complete
d475e12d3454: Pull complete
f3c12e3fd90d: Pull complete
Digest: sha256:ab7fb8889082bf80c0a4709e47aeb58e824d7d17189ca613c505bf66dafcf321
Status: Downloaded newer image for postgres:9.6-alpine
Creating redash_redis_1 ...
Creating redash_postgres_1 ... error
Creating redash_redis_1    ... done
e system"
ERROR: for postgres  Cannot start service postgres: b"error while creating mount source path '/opt/redash/postgres-data': mkdir /opt/redash: read-only file system"
ERROR: Encountered errors while bringing up the project.

下記サイトを参考に、volumeを利用することでエラーを回避
Modifying docker-compose.yml referring to the following site
https://qiita.com/laqiiz/items/25432b591494501df95d
docker volume create --name pg-data
docker-compose run --rm server create_db
docker-compose up -d
起動はできたがlocalhostにアクセスしても、ログイン画面が表示されない
Login screen is not displayed when accessing localhost

ubuntu@ip-172-31-15-103:/opt/redash$ docker-compose up -d
Pulling nginx (redash/nginx:latest)...
latest: Pulling from redash/nginx
03e1855d4f31: Pull complete
a3ed95caeb02: Pull complete
ccca24cf536d: Pull complete
6114b204585d: Pull complete
46062b965522: Pull complete
Digest: sha256:b10bc96086fa30b8fd8a8d1c47ce6fdb5f531c91cbfa5820595a687b33082be3
Status: Downloaded newer image for redash/nginx:latest
redash_redis_1 is up-to-date
redash_postgres_1 is up-to-date
Creating redash_server_1           ... done
Creating redash_scheduler_1        ... done
Creating redash_adhoc_worker_1     ... done
Creating redash_scheduled_worker_1 ... done
Creating redash_nginx_1            ... done

sugato · January 5, 2020, 12:11pm

参考(Reference)

https://yoshitaku-jp.hatenablog.com/entry/2018/05/20/750/

上記を参考に、portを変更して再度立ち上げたところ、エラーになっているので止めたログです
テキストオーバーしたので、一部カットしてます
error log
Refer to the above and change the port and re-execute it.
I cut some text because it was over

ubuntu@ip-172-31-15-103:/opt/redash$ docker-compose up
redash_postgres_1 is up-to-date
redash_redis_1 is up-to-date
redash_server_1 is up-to-date
redash_scheduled_worker_1 is up-to-date
redash_adhoc_worker_1 is up-to-date
redash_scheduler_1 is up-to-date
Recreating redash_nginx_1 ... done
Attaching to redash_postgres_1, redash_redis_1, redash_server_1, redash_scheduled_worker_1, redash_adhoc_worker_1, redash_scheduler_1, redash_nginx_1
redis_1             | 1:C 05 Jan 2020 10:46:49.369 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
redis_1             | 1:C 05 Jan 2020 10:46:49.369 # Redis version=5.0.7, bits=64, commit=00000000, modified=0, pid=1, just started
redis_1             | 1:C 05 Jan 2020 10:46:49.369 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
redis_1             | 1:M 05 Jan 2020 10:46:49.371 # You requested maxclients of 10000 requiring at least 10032 max file descriptors.
redis_1             | 1:M 05 Jan 2020 10:46:49.371 # Server can't set maximum open files to 10032 because of OS error: Operation not permitted.
redis_1             | 1:M 05 Jan 2020 10:46:49.371 # Current maximum open files is 4096. maxclients has been reduced to 4064 to compensate for low ulimit. If you need higher maxclients increase 'ulimit -n'.
redis_1             | 1:M 05 Jan 2020 10:46:49.371 * Running mode=standalone, port=6379.
redis_1             | 1:M 05 Jan 2020 10:46:49.371 # WARNING: The TCP backlog setting of 511 cannot be enforced because /proc/sys/net/core/somaxconn is set to the lower value of 128.
redis_1             | 1:M 05 Jan 2020 10:46:49.371 # Server initialized
redis_1             | 1:M 05 Jan 2020 10:46:49.371 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
redis_1             | 1:M 05 Jan 2020 10:46:49.371 # WARNING you have Transparent Huge Pages (THP) support enabled in your kernel. This will create latency and memory usage issues with Redis. To fix this issue run the command 'echo never > /sys/kernel/mm/transparent_hugepage/enabled' as root, and add it to your /etc/rc.local in order to retain the setting after a reboot. Redis must be restarted after THP is disabled.
redis_1             | 1:M 05 Jan 2020 10:46:49.371 * Ready to accept connections
redis_1             | 1:M 05 Jan 2020 10:51:50.084 * 100 changes in 300 seconds. Saving...
redis_1             | 1:M 05 Jan 2020 10:51:50.084 * Background saving started by pid 12
redis_1             | 12:C 05 Jan 2020 10:51:50.087 * DB saved on disk
redis_1             | 12:C 05 Jan 2020 10:51:50.087 * RDB: 0 MB of memory used by copy-on-write
redis_1             | 1:M 05 Jan 2020 10:51:50.185 * Background saving terminated with success
redis_1             | 1:M 05 Jan 2020 10:56:51.050 * 100 changes in 300 seconds. Saving...
redis_1             | 1:M 05 Jan 2020 10:56:51.050 * Background saving started by pid 13
redis_1             | 13:C 05 Jan 2020 10:56:51.053 * DB saved on disk
redis_1             | 13:C 05 Jan 2020 10:56:51.053 * RDB: 0 MB of memory used by copy-on-write
redis_1             | 1:M 05 Jan 2020 10:56:51.151 * Background saving terminated with success
server_1            | [2020-01-05 10:48:23 +0000] [1] [INFO] Starting gunicorn 19.7.1
server_1            | [2020-01-05 10:48:23 +0000] [1] [INFO] Listening at: http://0.0.0.0:5000 (1)
server_1            | [2020-01-05 10:48:23 +0000] [1] [INFO] Using worker: sync
server_1            | [2020-01-05 10:48:23 +0000] [9] [INFO] Booting worker with pid: 9
server_1            | [2020-01-05 10:48:23 +0000] [11] [INFO] Booting worker with pid: 11
server_1            | [2020-01-05 10:48:23 +0000] [13] [INFO] Booting worker with pid: 13
server_1            | [2020-01-05 10:48:23 +0000] [14] [INFO] Booting worker with pid: 14
adhoc_worker_1      | Starting 2 workers for queues: queries...
adhoc_worker_1      |
adhoc_worker_1      |  -------------- celery@4ca1d12f07bf v4.3.0 (rhubarb)
adhoc_worker_1      | ---- **** -----
adhoc_worker_1      | --- * ***  * -- Linux-4.15.0-1056-aws-x86_64-with-debian-10.0 2020-01-05 10:48:24
adhoc_worker_1      | -- * - **** ---
adhoc_worker_1      | - ** ---------- [config]
adhoc_worker_1      | - ** ---------- .> app:         redash:0x7f76316f5f10
adhoc_worker_1      | - ** ---------- .> transport:   redis://redis:6379/0
adhoc_worker_1      | - ** ---------- .> results:     redis://redis:6379/0
adhoc_worker_1      | - *** --- * --- .> concurrency: 2 (prefork)
adhoc_worker_1      | -- ******* ---- .> task events: OFF (enable -E to monitor tasks in this worker)
adhoc_worker_1      | --- ***** -----
adhoc_worker_1      |  -------------- [queues]
adhoc_worker_1      |                 .> queries          exchange=queries(direct) key=queries
adhoc_worker_1      |
adhoc_worker_1      |
adhoc_worker_1      | [tasks]
adhoc_worker_1      |   . redash.tasks.check_alerts_for_query
adhoc_worker_1      |   . redash.tasks.cleanup_query_results
adhoc_worker_1      |   . redash.tasks.empty_schedules
adhoc_worker_1      |   . redash.tasks.execute_query
adhoc_worker_1      |   . redash.tasks.record_event
adhoc_worker_1      |   . redash.tasks.refresh_queries
adhoc_worker_1      |   . redash.tasks.refresh_schema
adhoc_worker_1      |   . redash.tasks.refresh_schemas
adhoc_worker_1      |   . redash.tasks.send_aggregated_errors
adhoc_worker_1      |   . redash.tasks.send_mail
adhoc_worker_1      |   . redash.tasks.subscribe
adhoc_worker_1      |   . redash.tasks.sync_user_details
adhoc_worker_1      |   . redash.tasks.version_check
adhoc_worker_1      |
adhoc_worker_1      | [2020-01-05 10:48:25,211][PID:1][INFO][MainProcess] Connected to redis://redis:6379/0
adhoc_worker_1      | [2020-01-05 10:48:25,307][PID:1][INFO][MainProcess] mingle: searching for neighbors
adhoc_worker_1      | [2020-01-05 10:48:26,409][PID:1][INFO][MainProcess] mingle: all alone
adhoc_worker_1      | [2020-01-05 10:48:26,447][PID:1][INFO][MainProcess] celery@4ca1d12f07bf ready.
adhoc_worker_1      | [2020-01-05 10:48:26,714][PID:1][INFO][MainProcess] sync with celery@857565298c5e
adhoc_worker_1      | [2020-01-05 10:48:28,863][PID:1][INFO][MainProcess] sync with celery@ca4f9d7329ff
postgres_1          | The files belonging to this database system will be owned by user "postgres".
postgres_1          | This user must also own the server process.
postgres_1          |
postgres_1          | The database cluster will be initialized with locale "en_US.utf8".
postgres_1          | The default database encoding has accordingly been set to "UTF8".
postgres_1          | The default text search configuration will be set to "english".
postgres_1          |
postgres_1          | Data page checksums are disabled.
postgres_1          |
postgres_1          | fixing permissions on existing directory /var/lib/postgresql/data ... ok
postgres_1          | creating subdirectories ... ok
postgres_1          | selecting default max_connections ... 100
postgres_1          | selecting default shared_buffers ... 128MB
postgres_1          | selecting default timezone ... UTC
postgres_1          | selecting dynamic shared memory implementation ... posix
postgres_1          | creating configuration files ... ok
postgres_1          | running bootstrap script ... ok
postgres_1          | sh: locale: not found
postgres_1          | performing post-bootstrap initialization ... No usable system locales were found.
postgres_1          | Use the option "--debug" to see details.
postgres_1          | ok
postgres_1          | syncing data to disk ... ok
postgres_1          |
postgres_1          | Success. You can now start the database server using:
postgres_1          |
postgres_1          |     pg_ctl -D /var/lib/postgresql/data -l logfile start
postgres_1          |
postgres_1          |
postgres_1          | WARNING: enabling "trust" authentication for local connections
postgres_1          | You can change this by editing pg_hba.conf or using the option -A, or
postgres_1          | --auth-local and --auth-host, the next time you run initdb.
postgres_1          | waiting for server to start....LOG:  database system was shut down at 2020-01-05 10:46:49 UTC
postgres_1          | LOG:  MultiXact member wraparound protections are now enabled
postgres_1          | LOG:  database system is ready to accept connections
postgres_1          | LOG:  autovacuum launcher started
postgres_1          |  done
postgres_1          | server started
postgres_1          |
postgres_1          | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
postgres_1          |
postgres_1          | LOG:  received fast shutdown request
postgres_1          | LOG:  aborting any active transactions
postgres_1          | LOG:  autovacuum launcher shutting down
postgres_1          | waiting for server to shut down....LOG:  shutting down
postgres_1          | LOG:  database system is shut down
postgres_1          |  done
postgres_1          | server stopped
postgres_1          |
postgres_1          | PostgreSQL init process complete; ready for start up.
postgres_1          |
postgres_1          | LOG:  database system was shut down at 2020-01-05 10:46:50 UTC
postgres_1          | LOG:  MultiXact member wraparound protections are now enabled
postgres_1          | LOG:  database system is ready to accept connections
postgres_1          | LOG:  autovacuum launcher started
scheduled_worker_1  | Starting 1 workers for queues: scheduled_queries,schemas...
scheduled_worker_1  |
scheduled_worker_1  |  -------------- celery@857565298c5e v4.3.0 (rhubarb)
scheduled_worker_1  | ---- **** -----
scheduled_worker_1  | --- * ***  * -- Linux-4.15.0-1056-aws-x86_64-with-debian-10.0 2020-01-05 10:48:26
scheduled_worker_1  | -- * - **** ---
scheduled_worker_1  | - ** ---------- [config]
scheduled_worker_1  | - ** ---------- .> app:         redash:0x7f7289b1bf90
scheduled_worker_1  | - ** ---------- .> transport:   redis://redis:6379/0
scheduled_worker_1  | - ** ---------- .> results:     redis://redis:6379/0
scheduled_worker_1  | - *** --- * --- .> concurrency: 1 (prefork)
scheduled_worker_1  | -- ******* ---- .> task events: OFF (enable -E to monitor tasks in this worker)
scheduled_worker_1  | --- ***** -----
scheduled_worker_1  |  -------------- [queues]
scheduled_worker_1  |                 .> scheduled_queries exchange=scheduled_queries(direct) key=scheduled_queries
scheduled_worker_1  |                 .> schemas          exchange=schemas(direct) key=schemas
scheduled_worker_1  |
scheduled_worker_1  | [tasks]
scheduled_worker_1  |   . redash.tasks.check_alerts_for_query
scheduled_worker_1  |   . redash.tasks.cleanup_query_results
scheduled_worker_1  |   . redash.tasks.empty_schedules
scheduled_worker_1  |   . redash.tasks.execute_query
scheduled_worker_1  |   . redash.tasks.record_event
scheduled_worker_1  |   . redash.tasks.refresh_queries
scheduled_worker_1  |   . redash.tasks.refresh_schema
scheduled_worker_1  |   . redash.tasks.refresh_schemas
scheduled_worker_1  |   . redash.tasks.send_aggregated_errors
scheduled_worker_1  |   . redash.tasks.send_mail
scheduled_worker_1  |   . redash.tasks.subscribe
scheduled_worker_1  |   . redash.tasks.sync_user_details
scheduled_worker_1  |   . redash.tasks.version_check
scheduled_worker_1  |
scheduled_worker_1  | [2020-01-05 10:48:26,655][PID:1][INFO][MainProcess] Connected to redis://redis:6379/0
scheduled_worker_1  | [2020-01-05 10:48:26,679][PID:1][INFO][MainProcess] mingle: searching for neighbors
scheduled_worker_1  | [2020-01-05 10:48:27,719][PID:1][INFO][MainProcess] mingle: sync with 1 nodes
scheduled_worker_1  | [2020-01-05 10:48:27,719][PID:1][INFO][MainProcess] mingle: sync complete
scheduled_worker_1  | [2020-01-05 10:48:27,738][PID:1][INFO][MainProcess] celery@857565298c5e ready.
scheduled_worker_1  | [2020-01-05 10:48:28,863][PID:1][INFO][MainProcess] sync with celery@ca4f9d7329ff
scheduler_1         | Starting scheduler and 1 workers for queues: celery...
scheduler_1         |
scheduler_1         |  -------------- celery@ca4f9d7329ff v4.3.0 (rhubarb)
scheduler_1         | ---- **** -----
scheduler_1         | --- * ***  * -- Linux-4.15.0-1056-aws-x86_64-with-debian-10.0 2020-01-05 10:48:28
scheduler_1         | -- * - **** ---
scheduler_1         | - ** ---------- [config]
scheduler_1         | - ** ---------- .> app:         redash:0x7f3d66ea0f50
scheduler_1         | - ** ---------- .> transport:   redis://redis:6379/0
scheduler_1         | - ** ---------- .> results:     redis://redis:6379/0
scheduler_1         | - *** --- * --- .> concurrency: 1 (prefork)
scheduler_1         | -- ******* ---- .> task events: OFF (enable -E to monitor tasks in this worker)
scheduler_1         | --- ***** -----
scheduler_1         |  -------------- [queues]
scheduler_1         |                 .> celery           exchange=celery(direct) key=celery
scheduler_1         |
scheduler_1         |
scheduler_1         | [tasks]
scheduler_1         |   . redash.tasks.check_alerts_for_query
scheduler_1         |   . redash.tasks.cleanup_query_results
scheduler_1         |   . redash.tasks.empty_schedules
scheduler_1         |   . redash.tasks.execute_query
scheduler_1         |   . redash.tasks.record_event
scheduler_1         |   . redash.tasks.refresh_queries
scheduler_1         |   . redash.tasks.refresh_schema
scheduler_1         |   . redash.tasks.refresh_schemas
scheduler_1         |   . redash.tasks.send_aggregated_errors
scheduler_1         |   . redash.tasks.send_mail
scheduler_1         |   . redash.tasks.subscribe
scheduler_1         |   . redash.tasks.sync_user_details
scheduler_1         |   . redash.tasks.version_check
scheduler_1         |
scheduler_1         | [2020-01-05 10:48:28,778][PID:1][INFO][MainProcess] Connected to redis://redis:6379/0
scheduler_1         | [2020-01-05 10:48:28,783][PID:13][INFO][Beat] beat: Starting...
scheduler_1         | [2020-01-05 10:48:28,815][PID:1][INFO][MainProcess] mingle: searching for neighbors
scheduler_1         | [2020-01-05 10:48:29,867][PID:1][INFO][MainProcess] mingle: sync with 2 nodes
scheduler_1         | [2020-01-05 10:48:29,868][PID:1][INFO][MainProcess] mingle: sync complete
scheduler_1         | [2020-01-05 10:48:29,885][PID:1][INFO][MainProcess] celery@ca4f9d7329ff ready.
scheduler_1         | [2020-01-05 10:48:58,865][PID:13][INFO][Beat] Scheduler: Sending due task refresh_queries (redash.tasks.refresh_queries)
scheduler_1         | [2020-01-05 10:48:58,874][PID:1][INFO][MainProcess] Received task: redash.tasks.refresh_queries[622aa910-b3b6-437d-9730-b512a8cb0941]
scheduler_1         | [2020-01-05 10:48:58,876][PID:12][INFO][ForkPoolWorker-2] task_name=redash.tasks.refresh_queries task_id=622aa910-b3b6-437d-9730-b512a8cb0941 Refreshing queries...
scheduler_1         | [2020-01-05 10:48:58,980][PID:12][INFO][ForkPoolWorker-2] task_name=redash.tasks.refresh_queries task_id=622aa910-b3b6-437d-9730-b512a8cb0941 Done refreshing queries. Found 0 outdated queries: []
scheduler_1         | [2020-01-05 10:48:58,983][PID:12][INFO][ForkPoolWorker-2] Task redash.tasks.refresh_queries[622aa910-b3b6-437d-9730-b512a8cb0941] succeeded in 0.107177188s: None
scheduler_1         | [2020-01-05 10:49:28,863][PID:13][INFO][Beat] Scheduler: Sending due task sync_user_details (redash.tasks.sync_user_details)
scheduler_1         | [2020-01-05 10:49:28,864][PID:13][INFO][Beat] Scheduler: Sending due task refresh_queries (redash.tasks.refresh_queries)
scheduler_1         | [2020-01-05 10:49:28,865][PID:1][INFO][MainProcess] Received task: redash.tasks.sync_user_details[af009418-9007-47c5-9a3d-b864bda1cb8d]   expires:[2020-01-05 10:50:13.863595+00:00]
scheduler_1         | [2020-01-05 10:49:28,867][PID:12][INFO][ForkPoolWorker-2] Task redash.tasks.sync_user_details[af009418-9007-47c5-9a3d-b864bda1cb8d] succeeded in 0.000759753000239s: None
scheduler_1         | [2020-01-05 10:49:28,868][PID:1][INFO][MainProcess] Received task: redash.tasks.refresh_queries[a392b351-5a9c-4716-b9a2-461f7d2eed77]
scheduler_1         | [2020-01-05 10:49:28,869][PID:12][INFO][ForkPoolWorker-2] task_name=redash.tasks.refresh_queries task_id=a392b351-5a9c-4716-b9a2-461f7d2eed77 Refreshing queries...
scheduler_1         | [2020-01-05 10:49:28,874][PID:12][INFO][ForkPoolWorker-2] task_name=redash.tasks.refresh_queries task_id=a392b351-5a9c-4716-b9a2-461f7d2eed77 Done refreshing queries. Found 0 outdated queries: []
scheduler_1         | [2020-01-05 10:49:28,875][PID:12][INFO][ForkPoolWorker-2] Task redash.tasks.refresh_queries[a392b351-5a9c-4716-b9a2-461f7d2eed77] succeeded in 0.00608327999998s: None
scheduler_1         | [2020-01-05 10:49:58,885][PID:13][INFO][Beat] Scheduler: Sending due task refresh_queries (redash.tasks.refresh_queries)
scheduler_1         | [2020-01-05 10:49:58,887][PID:1][INFO][MainProcess] Received task: redash.tasks.refresh_queries[b94fcf41-0e89-4602-a5fe-8510bdfbed10]
scheduler_1         | [2020-01-05 10:49:58,888][PID:12][INFO][ForkPoolWorker-2] task_name=redash.tasks.refresh_queries task_id=b94fcf41-0e89-4602-a5fe-8510bdfbed10 Refreshing queries...
scheduler_1         | [2020-01-05 10:49:58,892][PID:12][INFO][ForkPoolWorker-2] task_name=redash.tasks.refresh_queries task_id=b94fcf41-0e89-4602-a5fe-8510bdfbed10 Done refreshing queries. Found 0 outdated queries: []
scheduler_1         | [2020-01-05 10:49:58,894][PID:12][INFO][ForkPoolWorker-2] Task redash.tasks.refresh_queries[b94fcf41-0e89-4602-a5fe-8510bdfbed10] succeeded in 0.00584294800001s: None
scheduler_1         | [2020-01-05 10:50:28,866][PID:13][INFO][Beat] Scheduler: Sending due task sync_user_details (redash.tasks.sync_user_details)
scheduler_1         | [2020-01-05 10:50:28,868][PID:1][INFO][MainProcess] Received task: redash.tasks.sync_user_details[0f8780c2-4a3c-48a9-9eaf-dfa3b65dfca3]   expires:[2020-01-05 10:51:13.867266+00:00]
scheduler_1         | [2020-01-05 10:50:28,870][PID:12][INFO][ForkPoolWorker-2] Task redash.tasks.sync_user_details[0f8780c2-4a3c-48a9-9eaf-dfa3b65dfca3] succeeded in 0.000691523000114s: None
scheduler_1         | [2020-01-05 10:50:28,885][PID:13][INFO][Beat] Scheduler: Sending due task refresh_queries (redash.tasks.refresh_queries)
scheduler_1         | [2020-01-05 10:50:28,886][PID:1][INFO][MainProcess] Received task: redash.tasks.refresh_queries[11c58b5f-8c88-4f60-a074-43dece8349ee]
scheduler_1         | [2020-01-05 10:50:28,887][PID:12][INFO][ForkPoolWorker-2] task_name=redash.tasks.refresh_queries task_id=11c58b5f-8c88-4f60-a074-43dece8349ee Refreshing queries...
scheduler_1         | [2020-01-05 10:50:28,891][PID:12][INFO][ForkPoolWorker-2] task_name=redash.tasks.refresh_queries task_id=11c58b5f-8c88-4f60-a074-43dece8349ee Done refreshing queries. Found 0 outdated queries: []
scheduler_1         | [2020-01-05 10:50:28,893][PID:12][INFO][ForkPoolWorker-2] Task redash.tasks.refresh_queries[11c58b5f-8c88-4f60-a074-43dece8349ee] succeeded in 0.00565459600011s: None
scheduler_1         | [2020-01-05 10:50:58,905][PID:13][INFO][Beat] Scheduler: Sending due task refresh_queries (redash.tasks.refresh_queries)
scheduler_1         | [2020-01-05 10:50:58,907][PID:1][INFO][MainProcess] Received task: redash.tasks.refresh_queries[61035ffe-e3a9-400c-be36-0a8e1b3ab80a]
scheduler_1         | [2020-01-05 10:50:58,908][PID:12][INFO][ForkPoolWorker-2] task_name=redash.tasks.refresh_queries task_id=61035ffe-e3a9-400c-be36-0a8e1b3ab80a Refreshing queries...
scheduler_1         | [2020-01-05 10:50:58,912][PID:12][INFO][ForkPoolWorker-2] task_name=redash.tasks.refresh_queries task_id=61035ffe-e3a9-400c-be36-0a8e1b3ab80a Done refreshing queries. Found 0 outdated queries: []
scheduler_1         | [2020-01-05 10:50:58,914][PID:12][INFO][ForkPoolWorker-2] Task redash.tasks.refresh_queries[61035ffe-e3a9-400c-be36-0a8e1b3ab80a] succeeded in 0.00573941700031s: None
scheduler_1         | [2020-01-05 10:51:28,866][PID:13][INFO][Beat] Scheduler: Sending due task sync_user_details (redash.tasks.sync_user_details)
scheduler_1         | [2020-01-05 10:51:28,869][PID:1][INFO][MainProcess] Received task: redash.tasks.sync_user_details[545045fc-1efb-47a5-8c40-bee2ce6ce311]   expires:[2020-01-05 10:52:13.867348+00:00]
scheduler_1         | [2020-01-05 10:51:28,870][PID:12][INFO][ForkPoolWorker-2] Task redash.tasks.sync_user_details[545045fc-1efb-47a5-8c40-bee2ce6ce311] succeeded in 0.000780430999839s: None
scheduler_1         | [2020-01-05 10:51:28,905][PID:13][INFO][Beat] Scheduler: Sending due task refresh_queries (redash.tasks.refresh_queries)
scheduler_1         | [2020-01-05 10:51:28,907][PID:1][INFO][MainProcess] Received task: redash.tasks.refresh_queries[5c9e449f-d97a-43b0-b8eb-0e321cfd1b20]
scheduler_1         | [2020-01-05 10:51:28,908][PID:12][INFO][ForkPoolWorker-2] task_name=redash.tasks.refresh_queries task_id=5c9e449f-d97a-43b0-b8eb-0e321cfd1b20 Refreshing queries...
scheduler_1         | [2020-01-05 10:51:28,913][PID:12][INFO][ForkPoolWorker-2] task_name=redash.tasks.refresh_queries task_id=5c9e449f-d97a-43b0-b8eb-0e321cfd1b20 Done refreshing queries. Found 0 outdated queries: []
scheduler_1         | [2020-01-05 10:51:28,914][PID:12][INFO][ForkPoolWorker-2] Task redash.tasks.refresh_queries[5c9e449f-d97a-43b0-b8eb-0e321cfd1b20] succeeded in 0.00610291999965s: None
scheduler_1         | [2020-01-05 10:51:58,927][PID:13][INFO][Beat] Scheduler: Sending due task refresh_queries (redash.tasks.refresh_queries)
scheduler_1         | [2020-01-05 10:51:58,930][PID:1][INFO][MainProcess] Received task: redash.tasks.refresh_queries[4bffd20f-04d7-42e8-b18f-24ea2ff96957]
scheduler_1         | [2020-01-05 10:51:58,931][PID:12][INFO][ForkPoolWorker-2] task_name=redash.tasks.refresh_queries task_id=4bffd20f-04d7-42e8-b18f-24ea2ff96957 Refreshing queries...
scheduler_1         | [2020-01-05 10:51:58,935][PID:12][INFO][ForkPoolWorker-2] task_name=redash.tasks.refresh_queries task_id=4bffd20f-04d7-42e8-b18f-24ea2ff96957 Done refreshing queries. Found 0 outdated queries: []
scheduler_1         | [2020-01-05 10:51:58,936][PID:12][INFO][ForkPoolWorker-2] Task redash.tasks.refresh_queries[4bffd20f-04d7-42e8-b18f-24ea2ff96957] succeeded in 0.00572356999965s: None
scheduler_1         | [2020-01-05 10:52:28,869][PID:13][INFO][Beat] Scheduler: Sending due task sync_user_details (redash.tasks.sync_user_details)
scheduler_1         | [2020-01-05 10:52:28,872][PID:1][INFO][MainProcess] Received task: redash.tasks.sync_user_details[98424ccf-d603-4751-b5f8-6b8f0be22637]   expires:[2020-01-05 10:53:13.869933+00:00]
scheduler_1         | [2020-01-05 10:52:28,878][PID:14][INFO][ForkPoolWorker-3] Task redash.tasks.sync_user_details[98424ccf-d603-4751-b5f8-6b8f0be22637] succeeded in 0.00480605299981s: None
scheduler_1         | [2020-01-05 10:52:28,927][PID:13][INFO][Beat] Scheduler: Sending due task refresh_queries (redash.tasks.refresh_queries)
scheduler_1         | [2020-01-05 10:52:28,929][PID:1][INFO][MainProcess] Received task: redash.tasks.refresh_queries[5caf4c57-2e9d-451f-82e2-e4c5fbedc982]
scheduler_1         | [2020-01-05 10:52:28,931][PID:14][INFO][ForkPoolWorker-3] task_name=redash.tasks.refresh_queries task_id=5caf4c57-2e9d-451f-82e2-e4c5fbedc982 Refreshing queries...
scheduler_1         | [2020-01-05 10:52:29,028][PID:14][INFO][ForkPoolWorker-3] task_name=redash.tasks.refresh_queries task_id=5caf4c57-2e9d-451f-82e2-e4c5fbedc982 Done refreshing queries. Found 0 outdated queries: []
scheduler_1         | [2020-01-05 10:52:29,030][PID:14][INFO][ForkPoolWorker-3] Task redash.tasks.refresh_queries[5caf4c57-2e9d-451f-82e2-e4c5fbedc982] succeeded in 0.0993369520002s: None
scheduler_1         | [2020-01-05 10:52:58,948][PID:13][INFO][Beat] Scheduler: Sending due task refresh_queries (redash.tasks.refresh_queries)
scheduler_1         | [2020-01-05 10:52:58,950][PID:1][INFO][MainProcess] Received task: redash.tasks.refresh_queries[f16a3453-d28a-411c-891b-fdd89b91ade1]
scheduler_1         | [2020-01-05 10:52:58,951][PID:14][INFO][ForkPoolWorker-3] task_name=redash.tasks.refresh_queries task_id=f16a3453-d28a-411c-891b-fdd89b91ade1 Refreshing queries...
scheduler_1         | [2020-01-05 10:52:58,956][PID:14][INFO][ForkPoolWorker-3] task_name=redash.tasks.refresh_queries task_id=f16a3453-d28a-411c-891b-fdd89b91ade1 Done refreshing queries. Found 0 outdated queries: []
scheduler_1         | [2020-01-05 10:52:58,957][PID:14][INFO][ForkPoolWorker-3] Task redash.tasks.refresh_queries[f16a3453-d28a-411c-891b-fdd89b91ade1] succeeded in 0.00613466699997s: None
scheduler_1         | [2020-01-05 10:53:28,844][PID:13][INFO][Beat] Scheduler: Sending due task cleanup_query_results (redash.tasks.cleanup_query_results)
scheduler_1         | [2020-01-05 10:53:28,846][PID:1][INFO][MainProcess] Received task: redash.tasks.cleanup_query_results[59046b5d-1c85-4fed-910b-a5db099093ef]
scheduler_1         | [2020-01-05 10:53:28,848][PID:14][INFO][ForkPoolWorker-3] Running query results clean up (removing maximum of 100 unused results, that are 7 days old or more)
scheduler_1         | [2020-01-05 10:53:28,852][PID:14][INFO][ForkPoolWorker-3] task_name=redash.tasks.cleanup_query_results task_id=59046b5d-1c85-4fed-910b-a5db099093ef Deleted 0 unused query results.
scheduler_1         | [2020-01-05 10:53:28,853][PID:14][INFO][ForkPoolWorker-3] Task redash.tasks.cleanup_query_results[59046b5d-1c85-4fed-910b-a5db099093ef] succeeded in 0.0050666470006s: None
scheduler_1         | [2020-01-05 10:53:28,869][PID:13][INFO][Beat] Scheduler: Sending due task sync_user_details (redash.tasks.sync_user_details)
scheduler_1         | [2020-01-05 10:53:28,871][PID:1][INFO][MainProcess] Received task: redash.tasks.sync_user_details[2ba29408-94a9-4b38-b753-da93bea3daf8]   expires:[2020-01-05 10:54:13.869862+00:00]
scheduler_1         | [2020-01-05 10:53:28,872][PID:14][INFO][ForkPoolWorker-3] Task redash.tasks.sync_user_details[2ba29408-94a9-4b38-b753-da93bea3daf8] succeeded in 0.000724082000488s: None
scheduler_1         | [2020-01-05 10:53:28,948][PID:13][INFO][Beat] Scheduler: Sending due task refresh_queries (redash.tasks.refresh_queries)
scheduler_1         | [2020-01-05 10:53:28,950][PID:1][INFO][MainProcess] Received task: redash.tasks.refresh_queries[cbf65b33-3508-4a6a-ad6e-0e5044f60bcf]
scheduler_1         | [2020-01-05 10:53:28,951][PID:14][INFO][ForkPoolWorker-3] task_name=redash.tasks.refresh_queries task_id=cbf65b33-3508-4a6a-ad6e-0e5044f60bcf Refreshing queries...
scheduler_1         | [2020-01-05 10:53:28,955][PID:14][INFO][ForkPoolWorker-3] task_name=redash.tasks.refresh_queries task_id=cbf65b33-3508-4a6a-ad6e-0e5044f60bcf Done refreshing queries. Found 0 outdated queries: []
scheduler_1         | [2020-01-05 10:53:28,957][PID:14][INFO][ForkPoolWorker-3] Task redash.tasks.refresh_queries[cbf65b33-3508-4a6a-ad6e-0e5044f60bcf] succeeded in 0.00612328500029s: None
scheduler_1         | [2020-01-05 10:53:58,951][PID:13][INFO][Beat] Scheduler: Sending due task refresh_queries (redash.tasks.refresh_queries)
scheduler_1         | [2020-01-05 10:53:58,953][PID:1][INFO][MainProcess] Received task: redash.tasks.refresh_queries[23d3f777-d1c2-4cf3-a8d7-6508041ab746]
scheduler_1         | [2020-01-05 10:53:58,954][PID:14][INFO][ForkPoolWorker-3] task_name=redash.tasks.refresh_queries task_id=23d3f777-d1c2-4cf3-a8d7-6508041ab746 Refreshing queries...
scheduler_1         | [2020-01-05 10:53:58,958][PID:14][INFO][ForkPoolWorker-3] task_name=redash.tasks.refresh_queries task_id=23d3f777-d1c2-4cf3-a8d7-6508041ab746 Done refreshing queries. Found 0 outdated queries: []
scheduler_1         | [2020-01-05 10:53:58,959][PID:14][INFO][ForkPoolWorker-3] Task redash.tasks.refresh_queries[23d3f777-d1c2-4cf3-a8d7-6508041ab746] succeeded in 0.00578118800058s: None
scheduler_1         | [2020-01-05 10:54:28,871][PID:13][INFO][Beat] Scheduler: Sending due task sync_user_details (redash.tasks.sync_user_details)
scheduler_1         | [2020-01-05 10:54:28,873][PID:1][INFO][MainProcess] Received task: redash.tasks.sync_user_details[e96f11e8-3dfd-46c3-bd41-a0a04e33ee1f]   expires:[2020-01-05 10:55:13.871585+00:00]
scheduler_1         | [2020-01-05 10:54:28,875][PID:14][INFO][ForkPoolWorker-3] Task redash.tasks.sync_user_details[e96f11e8-3dfd-46c3-bd41-a0a04e33ee1f] succeeded in 0.000775262999923s: None
scheduler_1         | [2020-01-05 10:54:28,951][PID:13][INFO][Beat] Scheduler: Sending due task refresh_queries (redash.tasks.refresh_queries)
scheduler_1         | [2020-01-05 10:54:28,953][PID:1][INFO][MainProcess] Received task: redash.tasks.refresh_queries[acc6c5e3-f6ad-4ebc-b4ad-4b697704cf96]
scheduler_1         | [2020-01-05 10:54:28,954][PID:14][INFO][ForkPoolWorker-3] task_name=redash.tasks.refresh_queries task_id=acc6c5e3-f6ad-4ebc-b4ad-4b697704cf96 Refreshing queries...
scheduler_1         | [2020-01-05 10:54:28,958][PID:14][INFO][ForkPoolWorker-3] task_name=redash.tasks.refresh_queries task_id=acc6c5e3-f6ad-4ebc-b4ad-4b697704cf96 Done refreshing queries. Found 0 outdated queries: []
scheduler_1         | [2020-01-05 10:54:28,960][PID:14][INFO][ForkPoolWorker-3] Task redash.tasks.refresh_queries[acc6c5e3-f6ad-4ebc-b4ad-4b697704cf96] succeeded in 0.00609559700024s: None
scheduler_1         | [2020-01-05 10:54:58,960][PID:13][INFO][Beat] Scheduler: Sending due task refresh_queries (redash.tasks.refresh_queries)
scheduler_1         | [2020-01-05 10:54:58,962][PID:1][INFO][MainProcess] Received task: redash.tasks.refresh_queries[29f3db17-3b02-4e64-839f-cb18f7070adf]
scheduler_1         | [2020-01-05 10:54:58,963][PID:14][INFO][ForkPoolWorker-3] task_name=redash.tasks.refresh_queries task_id=29f3db17-3b02-4e64-839f-cb18f7070adf Refreshing queries...
scheduler_1         | [2020-01-05 10:54:58,968][PID:14][INFO][ForkPoolWorker-3] task_name=redash.tasks.refresh_queries task_id=29f3db17-3b02-4e64-839f-cb18f7070adf Done refreshing queries. Found 0 outdated queries: []
scheduler_1         | [2020-01-05 10:54:58,969][PID:14][INFO][ForkPoolWorker-3] Task redash.tasks.refresh_queries[29f3db17-3b02-4e64-839f-cb18f7070adf] succeeded in 0.00589640700036s: None

Gracefully stopping... (press Ctrl+C again to force)
Stopping redash_nginx_1            ... done
Stopping redash_scheduled_worker_1 ... done
Stopping redash_scheduler_1        ... done
Stopping redash_adhoc_worker_1     ... done
Stopping redash_server_1           ... done
Stopping redash_postgres_1         ... done
Stopping redash_redis_1            ... done

sugato · January 5, 2020, 12:21pm

何を確認すればいいのか分からず、とりあえず確認した80番ポートの利用状況を貼っておきます。
I don’t know what to check, I check the port usage and put it on.

ubuntu@ip-172-31-15-103:/opt/redash$ sudo netstat -anp | grep 80
tcp6       0      0 :::80                   :::*                    LISTEN      8807/docker-proxy
unix  2      [ ACC ]     STREAM     LISTENING     27580    2550/systemd         /run/user/1000/snapd-session-agent.socket
unix  2      [ ACC ]     STREAM     LISTENING     85006    8567/containerd-shi  @/containerd-shim/moby/ca4f9d7329ff0b0e215113f57bf20988cb1fe2ab2f64c73943a4926b3d4b6801/shim.sock@
unix  2      [ ACC ]     STREAM     LISTENING     82708    8158/containerd-shi  @/containerd-shim/moby/fe8c70da4109f6628809305cb607f59129fb04389086177d7d1aea707dd92d7b/shim.sock@
unix  3      [ ]         STREAM     CONNECTED     84280    8506/containerd-shi  @/containerd-shim/moby/7b1d176003861693deb27f7efc93dac9ed75ccf3bf13b44da735decdb130a532/shim.sock@
unix  3      [ ]         STREAM     CONNECTED     18021    951/systemd-logind
unix  3      [ ]         STREAM     CONNECTED     83076    8158/containerd-shi  @/containerd-shim/moby/fe8c70da4109f6628809305cb607f59129fb04389086177d7d1aea707dd92d7b/shim.sock@
unix  3      [ ]         STREAM     CONNECTED     15803    721/systemd-network
unix  3      [ ]         STREAM     CONNECTED     18023    1/init               /run/systemd/journal/stdout
unix  3      [ ]         STREAM     CONNECTED     18033    1/init               /run/systemd/journal/stdout
unix  3      [ ]         STREAM     CONNECTED     84421    8567/containerd-shi  @/containerd-shim/moby/ca4f9d7329ff0b0e215113f57bf20988cb1fe2ab2f64c73943a4926b3d4b6801/shim.sock@

ubuntu@ip-172-31-15-103:/opt/redash$ sudo lsof -i:80
COMMAND    PID USER   FD   TYPE DEVICE SIZE/OFF NODE NAME
docker-pr 8807 root    4u  IPv6  86500      0t0  TCP *:http (LISTEN)

ariarijp · January 6, 2020, 2:05pm

こんにちは。利用されている AWS EC2 のインスタンスタイプはどちらになりますか？
公式ドキュメントにも記載があるとおり、t2.small(t3.small) 以下のインスタンスタイプですと、動作しない場合があります。

また、日本語での質問などは以下の日本語カテゴリーをお使いいただけるとありがたいです。

http://discuss.redash.io/c/japanese/12

sugato · January 7, 2020, 2:22pm

こんにちは。
EC2のインスタンスタイプですが、公式の方も拝見しt2.mediumを利用しています。

日本語カテゴリーに関しては失念していました。
以後、質問する場合は利用させていただきます！

Google翻訳しただけの英語ですが、どなたからか回答が貰えたらありがたいなと思っておりました。

ariarijp · January 7, 2020, 3:25pm

EC2のインスタンスタイプですが、公式の方も拝見しt2.mediumを利用しています。

それであれば、スペックの問題はなさそうですね。

起動はできたがlocalhostにアクセスしても、ログイン画面が表示されない

よくよく見ると、ここで localhost にアクセスしているとのことですが、EC2 を利用されているのであれば、該当インスタンスのグローバル IP アドレスあてにアクセスして確認するのが正しいかと思います。

また、AWS でインスタンスタイプと同じぐらいありがちなことで、セキュリティグループでポートを開けていないというのもありますので、あわせてご確認ください。

sugato · January 7, 2020, 3:40pm

問題の切り分けとして、ローカルのUbuntuではハンズオン資料を参考にRedashにアクセスできたことを確認。

念のためコンテナやイメージを全て削除して、EC2で再現しようとしました。
起動はできたのですが、localhostにアクセスしても何も表示されない。

ポートが開放されていないのでは？と思い、下記を参考にセキュリティグループを確認
https://www.ipentec.com/document/amazon-ec2-add-rule-to-security-group
⇒22番と3389番しかポートを開けていなかった

80番、443番も開放し再実行したが、接続できない
(どこを開放すればいいのか分かっていない状態です。。)

ちょうど困っていたタイミングで返信をいただき、下記を参考にグローバルIPを割り当てる
https://ac-5.net/aws/aws_elasticip_allocation
⇒無事アクセスできました！！

TCP/IPマスタリングの本を以前読んだのですが、自分の中に欠片も残っていないことを痛感したので、これを機会に勉強し直したいと思います。。
親切にご対応いただき、ありがとうございます！

ariarijp · January 7, 2020, 3:59pm

解決したようでよかったです！

Happy Querying!

▼Categories

▼Tags

Setup Issue using setup.sh (Redash環境構築が正常に実行できない)

A summary of the issue

the browser/OS environment in which it occurs.

参考(Reference)

手順(Procedure)

参考(Reference)