redash icon indicating copy to clipboard operation
redash copied to clipboard

CSS and graphics don't load: WEBPACK_MANIFEST_PATH not found

Open ongrid opened this issue 7 months ago • 1 comments

Issue Summary

Opening http://127.0.0.1:5001/setup at the first launch leads to unstyled page with missing favicons and png files (HTTP 404)

The following exception raised on backend side

server-1     | Traceback (most recent call last):
server-1     |   File "/app/redash/handlers/webpack.py", line 17, in get_asset
server-1     |     with open(WEBPACK_MANIFEST_PATH) as fp:
server-1     | FileNotFoundError: [Errno 2] No such file or directory: '/app/redash/handlers/../../client/dist/asset-manifest.json'

Disabling skip_frontend_build enables yarn building but without any effect

diff --git a/compose.yaml b/compose.yaml
index 0b116847..b5fb4970 100644
--- a/compose.yaml
+++ b/compose.yaml
@@ -4,7 +4,7 @@ x-redash-service: &redash-service
   build:
     context: .
     args:
-      skip_frontend_build: "true"  # set to empty string to build
+      skip_frontend_build: ""  # set to empty string to build
   volumes:
     - .:/app
   env_file:

Steps to Reproduce

  1. clone repo
  2. set skip_frontend_build: ""
  3. docker compose build
  4. docker compose up
  5. Open http://127.0.0.1:5001/

Technical details:

  • Redash Version:
commit 5d31429ca80486f27645e7e6d5447818b07315f0 (HEAD -> master, origin/master, origin/HEAD)
Author: Gleb Lesnikov <[email protected]>
Date:   Mon May 5 10:53:07 2025 +0400
Image
  • How did you install Redash:
% docker compose build            
[+] Building 4.0s (54/67)                                                                                                                                                                                                           docker:desktop-linux
 => [server internal] load build definition from Dockerfile                                                                                                                                                                                         0.0s
 => => transferring dockerfile: 3.67kB                                                                                                                                                                                                              0.0s
 => [worker internal] load metadata for docker.io/library/node:18-bookworm                                                                                                                                                                          1.4s
 => [scheduler internal] load metadata for docker.io/library/python:3.10-slim-bookworm                                                                                                                                                              1.4s
 => [server internal] load .dockerignore                                                                                                                                                                                                            0.0s
 => => transferring context: 203B                                                                                                                                                                                                                   0.0s
 => [worker frontend-builder  1/12] FROM docker.io/library/node:18-bookworm@sha256:867be01f97d45cb7d89a8ef0b328d23e8207412ebec4564441ed8cabc8cc4ecd                                                                                                 0.1s
 => => resolve docker.io/library/node:18-bookworm@sha256:867be01f97d45cb7d89a8ef0b328d23e8207412ebec4564441ed8cabc8cc4ecd                                                                                                                           0.0s
 => [server internal] load build context                                                                                                                                                                                                            0.1s
 => => transferring context: 106.51kB                                                                                                                                                                                                               0.1s
 => [scheduler stage-1  1/12] FROM docker.io/library/python:3.10-slim-bookworm@sha256:57038683f4a259e17fcff1ccef7ba30b1065f4b3317dabb5bd7c82640a5ed64f                                                                                              0.1s
 => => resolve docker.io/library/python:3.10-slim-bookworm@sha256:57038683f4a259e17fcff1ccef7ba30b1065f4b3317dabb5bd7c82640a5ed64f                                                                                                                  0.0s
 => CACHED [worker stage-1  2/12] RUN useradd --create-home redash                                                                                                                                                                                  0.0s
 => CACHED [worker stage-1  3/12] RUN apt-get update &&   apt-get install -y --no-install-recommends   pkg-config   curl   gnupg   build-essential   pwgen   libffi-dev   sudo   git-core   libkrb5-dev   libpq-dev   g++ unixodbc-dev   xmlsec1    0.0s
 => CACHED [worker stage-1  4/12] RUN <<EOF (if [ "linux/amd64" = "linux/amd64" ]; then...)                                                                                                                                                         0.0s
 => CACHED [worker stage-1  5/12] WORKDIR /app                                                                                                                                                                                                      0.0s
 => CACHED [worker stage-1  6/12] RUN curl -sSL https://install.python-poetry.org | python3 -                                                                                                                                                       0.0s
 => CACHED [worker stage-1  7/12] RUN /etc/poetry/bin/poetry cache clear pypi --all                                                                                                                                                                 0.0s
 => CACHED [server stage-1  8/12] COPY pyproject.toml poetry.lock ./                                                                                                                                                                                0.0s
 => CACHED [server stage-1  9/12] RUN /etc/poetry/bin/poetry install --only main,all_ds,dev --no-root --no-interaction --no-ansi                                                                                                                    0.0s
 => CACHED [server stage-1 10/12] COPY --chown=redash . /app                                                                                                                                                                                        0.0s
 => CACHED [worker frontend-builder  2/12] RUN npm install --global --force [email protected]                                                                                                                                                            0.0s
 => CACHED [worker frontend-builder  3/12] RUN useradd -m -d /frontend redash                                                                                                                                                                       0.0s
 => CACHED [worker frontend-builder  4/12] WORKDIR /frontend                                                                                                                                                                                        0.0s
 => CACHED [server frontend-builder  5/12] COPY --chown=redash package.json yarn.lock .yarnrc /frontend/                                                                                                                                            0.0s
 => CACHED [server frontend-builder  6/12] COPY --chown=redash viz-lib /frontend/viz-lib                                                                                                                                                            0.0s
 => CACHED [server frontend-builder  7/12] COPY --chown=redash scripts /frontend/scripts                                                                                                                                                            0.0s
 => CACHED [server frontend-builder  8/12] RUN yarn config set network-timeout 300000                                                                                                                                                               0.0s
 => CACHED [server frontend-builder  9/12] RUN if [ "x" = "x" ] ; then yarn --frozen-lockfile --network-concurrency 1; fi                                                                                                                           0.0s
 => CACHED [server frontend-builder 10/12] COPY --chown=redash client /frontend/client                                                                                                                                                              0.0s
 => CACHED [server frontend-builder 11/12] COPY --chown=redash webpack.config.js /frontend/                                                                                                                                                         0.0s
 => CACHED [server frontend-builder 12/12] RUN <<EOF (if [ "x" = "x" ]; then...)                                                                                                                                                                    0.0s
 => CACHED [server stage-1 11/12] COPY --from=frontend-builder --chown=redash /frontend/client/dist /app/client/dist                                                                                                                                0.0s
 => CACHED [server stage-1 12/12] RUN chown redash /app                                                                                                                                                                                             0.0s
 => [server] exporting to image                                                                                                                                                                                                                     1.3s
 => => exporting layers                                                                                                                                                                                                                             0.0s
 => => exporting manifest sha256:9e2b3d4e9c40f1e68bd0e2ba43171ab9eed0d3ccecad347cd377cc59682316e6                                                                                                                                                   0.0s
 => => exporting config sha256:f98e67c83666b9edd91fcefda777e7a7972ee02c1edc8f4a2beb4bd2ce70f28a                                                                                                                                                     0.0s
 => => exporting attestation manifest sha256:3d51f7b4e1950fc2890fa8b7c8667d879bab8d67bb3b6e2c53d9490389042bfc                                                                                                                                       0.0s
 => => exporting manifest list sha256:898729678e18c3fbd1a6d350fdb0911ff76133235cfc90bf262d3f9875ab39e1                                                                                                                                              0.0s
 => => naming to docker.io/library/redash-server:latest                                                                                                                                                                                             0.0s
 => => unpacking to docker.io/library/redash-server:latest                                                                                                                                                                                          1.2s
 => [server] resolving provenance for metadata file                                                                                                                                                                                                 0.0s
 => [scheduler internal] load build definition from Dockerfile                                                                                                                                                                                      0.0s
 => => transferring dockerfile: 3.67kB                                                                                                                                                                                                              0.0s
 => [worker internal] load build definition from Dockerfile                                                                                                                                                                                         0.0s
 => => transferring dockerfile: 3.67kB                                                                                                                                                                                                              0.0s
 => [scheduler internal] load .dockerignore                                                                                                                                                                                                         0.0s
 => => transferring context: 203B                                                                                                                                                                                                                   0.0s
 => [worker internal] load .dockerignore                                                                                                                                                                                                            0.0s
 => => transferring context: 203B                                                                                                                                                                                                                   0.0s
 => [scheduler internal] load build context                                                                                                                                                                                                         0.1s
 => => transferring context: 106.51kB                                                                                                                                                                                                               0.1s
 => [worker internal] load build context                                                                                                                                                                                                            0.1s
 => => transferring context: 106.51kB                                                                                                                                                                                                               0.1s
 => CACHED [worker stage-1  8/12] COPY pyproject.toml poetry.lock ./                                                                                                                                                                                0.0s
 => CACHED [worker stage-1  9/12] RUN /etc/poetry/bin/poetry install --only main,all_ds,dev --no-root --no-interaction --no-ansi                                                                                                                    0.0s
 => CACHED [worker stage-1 10/12] COPY --chown=redash . /app                                                                                                                                                                                        0.0s
 => CACHED [worker frontend-builder  5/12] COPY --chown=redash package.json yarn.lock .yarnrc /frontend/                                                                                                                                            0.0s
 => CACHED [worker frontend-builder  6/12] COPY --chown=redash viz-lib /frontend/viz-lib                                                                                                                                                            0.0s
 => CACHED [worker frontend-builder  7/12] COPY --chown=redash scripts /frontend/scripts                                                                                                                                                            0.0s
 => CACHED [worker frontend-builder  8/12] RUN yarn config set network-timeout 300000                                                                                                                                                               0.0s
 => CACHED [worker frontend-builder  9/12] RUN if [ "x" = "x" ] ; then yarn --frozen-lockfile --network-concurrency 1; fi                                                                                                                           0.0s
 => CACHED [worker frontend-builder 10/12] COPY --chown=redash client /frontend/client                                                                                                                                                              0.0s
 => CACHED [worker frontend-builder 11/12] COPY --chown=redash webpack.config.js /frontend/                                                                                                                                                         0.0s
 => CACHED [worker frontend-builder 12/12] RUN <<EOF (if [ "x" = "x" ]; then...)                                                                                                                                                                    0.0s
 => CACHED [worker stage-1 11/12] COPY --from=frontend-builder --chown=redash /frontend/client/dist /app/client/dist                                                                                                                                0.0s
 => CACHED [scheduler stage-1 12/12] RUN chown redash /app                                                                                                                                                                                          0.0s
 => [scheduler] exporting to image                                                                                                                                                                                                                  0.1s
 => => exporting layers                                                                                                                                                                                                                             0.0s
 => => exporting manifest sha256:2fad4c990c2af1be6ad6ebf9a509fc20ebd21669103d52cab0d670532fdab163                                                                                                                                                   0.0s
 => => exporting config sha256:210dc34f315f046e65fdb721911be8301b6fb72b3dec1adfe6cf1fdd60fc47b6                                                                                                                                                     0.0s
 => => exporting attestation manifest sha256:b113dc5a9f6be92b75cd933ea9201606d0104b895d9fcc83cd0bf932dfd1d5b5                                                                                                                                       0.0s
 => => exporting manifest list sha256:b1726564fea94acb8582dcd29bb3b83585d19ef66b23aaba236b8a525714f73f                                                                                                                                              0.0s
 => => naming to docker.io/library/redash-scheduler:latest                                                                                                                                                                                          0.0s
 => => unpacking to docker.io/library/redash-scheduler:latest                                                                                                                                                                                       0.0s
 => [worker] exporting to image                                                                                                                                                                                                                     0.1s
 => => exporting layers                                                                                                                                                                                                                             0.0s
 => => exporting manifest sha256:b7b286a24e7d0a7d8d73472bf64e067360fde0833397d41d294a9cc11f9024e2                                                                                                                                                   0.0s
 => => exporting config sha256:654dac956958f273def12c1973fa61b5b2fdca38b6ea0513bd3554636a0607c0                                                                                                                                                     0.0s
 => => exporting attestation manifest sha256:79dab46f552665611e8ba4a8eb6bc05dedb0ff4daa51595bb2e02a6b5f2af053                                                                                                                                       0.0s
 => => exporting manifest list sha256:5ba1a09c0a5db23fd95b5eb2cc50e97442c53c14125c5ae61576948d5cdce1d3                                                                                                                                              0.0s
 => => naming to docker.io/library/redash-worker:latest                                                                                                                                                                                             0.0s
 => => unpacking to docker.io/library/redash-worker:latest                                                                                                                                                                                          0.0s
 => [worker] resolving provenance for metadata file                                                                                                                                                                                                 0.0s
 => [scheduler] resolving provenance for metadata file                                                                                                                                                                                              0.0s
[+] Building 3/3
 ✔ scheduler  Built                                                                                                                                                                                                                                 0.0s 
 ✔ server     Built                                                                                                                                                                                                                                 0.0s 
 ✔ worker     Built

 % docker compose up   
[+] Running 6/6
 ✔ Container redash-postgres-1   Created                                                                                                                                                                                                            0.0s 
 ✔ Container redash-redis-1      Created                                                                                                                                                                                                            0.0s 
 ✔ Container redash-email-1      Created                                                                                                                                                                                                            0.0s 
 ✔ Container redash-worker-1     Recreated                                                                                                                                                                                                          0.6s 
 ✔ Container redash-scheduler-1  Recreated                                                                                                                                                                                                          0.4s 
 ✔ Container redash-server-1     Recreated                                                                                                                                                                                                          0.2s 
Attaching to email-1, postgres-1, redis-1, scheduler-1, server-1, worker-1
redis-1      | 1:C 05 May 2025 11:22:56.093 * oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
redis-1      | 1:C 05 May 2025 11:22:56.093 * Redis version=7.4.3, bits=64, commit=00000000, modified=0, pid=1, just started
redis-1      | 1:C 05 May 2025 11:22:56.093 # 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 May 2025 11:22:56.093 * monotonic clock: POSIX clock_gettime
redis-1      | 1:M 05 May 2025 11:22:56.095 * Running mode=standalone, port=6379.
redis-1      | 1:M 05 May 2025 11:22:56.096 * Server initialized
redis-1      | 1:M 05 May 2025 11:22:56.096 * Loading RDB produced by version 7.4.3
redis-1      | 1:M 05 May 2025 11:22:56.096 * RDB age 316 seconds
redis-1      | 1:M 05 May 2025 11:22:56.096 * RDB memory usage when created 1.74 Mb
redis-1      | 1:M 05 May 2025 11:22:56.097 * Done loading RDB, keys loaded: 21, keys expired: 2.
redis-1      | 1:M 05 May 2025 11:22:56.097 * DB loaded from disk: 0.001 seconds
redis-1      | 1:M 05 May 2025 11:22:56.097 * Ready to accept connections tcp
postgres-1   | 
postgres-1   | PostgreSQL Database directory appears to contain a database; Skipping initialization
postgres-1   | 
postgres-1   | ************************************
postgres-1   | PostgreSQL data directory: /var/lib/postgresql/data
postgres-1   | ************************************
postgres-1   | 2025-05-05 11:22:56.183 UTC [9] LOG:  starting PostgreSQL 17.4 on x86_64-pc-linux-musl, compiled by gcc (Alpine 14.2.0) 14.2.0, 64-bit
postgres-1   | 2025-05-05 11:22:56.183 UTC [9] LOG:  listening on IPv4 address "0.0.0.0", port 5432
postgres-1   | 2025-05-05 11:22:56.184 UTC [9] LOG:  listening on IPv6 address "::", port 5432
postgres-1   | 2025-05-05 11:22:56.184 UTC [9] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
postgres-1   | 2025-05-05 11:22:56.187 UTC [33] LOG:  database system was interrupted; last known up at 2025-05-05 11:13:45 UTC
postgres-1   | 2025-05-05 11:22:56.187 UTC [33] LOG:  database system was not properly shut down; automatic recovery in progress
postgres-1   | 2025-05-05 11:22:56.188 UTC [33] LOG:  redo starts at 0/15CB048
postgres-1   | 2025-05-05 11:22:56.188 UTC [33] LOG:  invalid record length at 0/15CB080: expected at least 24, got 0
postgres-1   | 2025-05-05 11:22:56.188 UTC [33] LOG:  redo done at 0/15CB048 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
postgres-1   | 2025-05-05 11:22:56.190 UTC [31] LOG:  checkpoint starting: end-of-recovery immediate wait
postgres-1   | 2025-05-05 11:22:56.191 UTC [31] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.002 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=0 kB; lsn=0/15CB080, redo lsn=0/15CB080
postgres-1   | 2025-05-05 11:22:56.196 UTC [9] LOG:  database system is ready to accept connections
worker-1     | Starting dev RQ worker...
scheduler-1  | Starting dev RQ scheduler...
email-1      | MailDev using directory /tmp/maildev-1
email-1      | MailDev webapp running at http://localhost:1080/
email-1      | (node:1) [DEP0040] DeprecationWarning: The `punycode` module is deprecated. Please use a userland alternative instead.
email-1      | (Use `node --trace-deprecation ...` to show where the warning was created)
email-1      | MailDev SMTP Server running at localhost:1025
server-1     | [2025-05-05 11:23:06,798][PID:1][INFO][xmlschema] Include schema from 'file:///usr/local/lib/python3.10/site-packages/xmlschema/schemas/XSD_1.1/xsd11-extra.xsd'
scheduler-1  | [2025-05-05 11:23:06,858][PID:7][INFO][xmlschema] Include schema from 'file:///usr/local/lib/python3.10/site-packages/xmlschema/schemas/XSD_1.1/xsd11-extra.xsd'
worker-1     | [2025-05-05 11:23:06,859][PID:7][INFO][xmlschema] Include schema from 'file:///usr/local/lib/python3.10/site-packages/xmlschema/schemas/XSD_1.1/xsd11-extra.xsd'
server-1     |  * Debug mode: on
server-1     | [2025-05-05 11:23:07,602][PID:1][INFO][werkzeug] WARNING: This is a development server. Do not use it in a production deployment. Use a production WSGI server instead.
server-1     |  * Running on all addresses (0.0.0.0)
server-1     |  * Running on http://127.0.0.1:5000
server-1     |  * Running on http://172.24.0.5:5000
server-1     | [2025-05-05 11:23:07,602][PID:1][INFO][werkzeug] Press CTRL+C to quit
server-1     | [2025-05-05 11:23:07,625][PID:1][INFO][werkzeug]  * Restarting with watchdog (inotify)
scheduler-1  | [2025-05-05 11:23:07,675][PID:7][INFO][rq_scheduler.scheduler] Registering birth
worker-1     | [2025-05-05 11:23:07,720][PID:7][INFO][rq.worker] Worker rq:worker:a04529676e134b5c97a40bc2baf341dd started with PID 7, version 1.16.1
worker-1     | [2025-05-05 11:23:07,720][PID:7][INFO][rq.worker] Subscribing to channel rq:pubsub:a04529676e134b5c97a40bc2baf341dd
worker-1     | [2025-05-05 11:23:07,722][PID:7][INFO][rq.worker] *** Listening on periodic, emails, default, scheduled_queries, queries, schemas...
worker-1     | [2025-05-05 11:23:07,723][PID:7][INFO][rq.worker] Cleaning registries for queue: periodic
worker-1     | [2025-05-05 11:23:07,725][PID:7][INFO][rq.worker] Cleaning registries for queue: emails
worker-1     | [2025-05-05 11:23:07,728][PID:7][INFO][rq.worker] Cleaning registries for queue: default
worker-1     | [2025-05-05 11:23:07,730][PID:7][INFO][rq.worker] Cleaning registries for queue: scheduled_queries
worker-1     | [2025-05-05 11:23:07,732][PID:7][INFO][rq.worker] Cleaning registries for queue: queries
worker-1     | [2025-05-05 11:23:07,734][PID:7][INFO][rq.worker] Cleaning registries for queue: schemas
worker-1     | [2025-05-05 11:23:07,739][PID:7][INFO][rq.worker] periodic: 18281a865ed3d1a60f366aeb8596fe2283aa421f
worker-1     | [2025-05-05 11:23:07,764][PID:31][INFO][rq.worker] periodic: Job OK (18281a865ed3d1a60f366aeb8596fe2283aa421f)
worker-1     | [2025-05-05 11:23:07,764][PID:31][INFO][rq.worker] Result is kept for 600 seconds
worker-1     | [2025-05-05 11:23:07,776][PID:7][INFO][rq.worker] periodic: 305c0cae0a196ae96915fd2b6f81001c435aad65
worker-1     | [2025-05-05 11:23:07,786][PID:32][INFO][rq.job.redash.tasks.queries.maintenance] job.func_name=redash.tasks.queries.maintenance.refresh_queries job.id=305c0cae0a196ae96915fd2b6f81001c435aad65 Refreshing queries...
worker-1     | [2025-05-05 11:23:07,840][PID:32][INFO][rq.job.redash.tasks.queries.maintenance] job.func_name=redash.tasks.queries.maintenance.refresh_queries job.id=305c0cae0a196ae96915fd2b6f81001c435aad65 Done refreshing queries: {'started_at': 1746444187.7865748, 'outdated_queries_count': 0, 'last_refresh_at': 1746444187.838608, 'query_ids': '[]'}
worker-1     | [2025-05-05 11:23:07,843][PID:32][INFO][rq.worker] periodic: Job OK (305c0cae0a196ae96915fd2b6f81001c435aad65)
worker-1     | [2025-05-05 11:23:07,843][PID:32][INFO][rq.worker] Result is kept for 600 seconds
postgres-1   | 2025-05-05 11:23:07.849 UTC [37] LOG:  unexpected EOF on client connection with an open transaction
worker-1     | [2025-05-05 11:23:07,854][PID:7][INFO][rq.worker] periodic: 59a84668e68687338646f735965213c58e814b32
worker-1     | [2025-05-05 11:23:07,868][PID:33][INFO][rq.job.redash.tasks.queries.maintenance] job.func_name=redash.tasks.queries.maintenance.remove_ghost_locks job.id=59a84668e68687338646f735965213c58e814b32 Locks found: 0, Locks removed: 0
worker-1     | [2025-05-05 11:23:07,871][PID:33][INFO][rq.worker] periodic: Job OK (59a84668e68687338646f735965213c58e814b32)
worker-1     | [2025-05-05 11:23:07,871][PID:33][INFO][rq.worker] Result is kept for 600 seconds
worker-1     | [2025-05-05 11:23:07,883][PID:7][INFO][rq.worker] periodic: e27209059575fcc17c527c47d0957cb21756e551
worker-1     | [2025-05-05 11:23:07,894][PID:34][INFO][rq.job.redash.tasks.queries.maintenance] job.func_name=redash.tasks.queries.maintenance.cleanup_query_results job.id=e27209059575fcc17c527c47d0957cb21756e551 Running query results clean up (removing maximum of 100 unused results, that are 7 days old or more)
worker-1     | [2025-05-05 11:23:07,928][PID:34][INFO][rq.job.redash.tasks.queries.maintenance] job.func_name=redash.tasks.queries.maintenance.cleanup_query_results job.id=e27209059575fcc17c527c47d0957cb21756e551 Deleted 0 unused query results.
worker-1     | [2025-05-05 11:23:07,932][PID:34][INFO][rq.worker] periodic: Job OK (e27209059575fcc17c527c47d0957cb21756e551)
worker-1     | [2025-05-05 11:23:07,932][PID:34][INFO][rq.worker] Result is kept for 600 seconds
server-1     | [2025-05-05 11:23:15,500][PID:25][INFO][xmlschema] Include schema from 'file:///usr/local/lib/python3.10/site-packages/xmlschema/schemas/XSD_1.1/xsd11-extra.xsd'
server-1     | [2025-05-05 11:23:16,252][PID:25][WARNING][werkzeug]  * Debugger is active!
server-1     | [2025-05-05 11:23:16,253][PID:25][INFO][werkzeug]  * Debugger PIN: 958-411-846
postgres-1   | 2025-05-05 11:23:26.140 UTC [48] FATAL:  role "root" does not exist
worker-1     | [2025-05-05 11:23:37,718][PID:7][INFO][rq.worker] periodic: 305c0cae0a196ae96915fd2b6f81001c435aad65
worker-1     | [2025-05-05 11:23:37,734][PID:35][INFO][rq.job.redash.tasks.queries.maintenance] job.func_name=redash.tasks.queries.maintenance.refresh_queries job.id=305c0cae0a196ae96915fd2b6f81001c435aad65 Refreshing queries...
worker-1     | [2025-05-05 11:23:37,783][PID:35][INFO][rq.job.redash.tasks.queries.maintenance] job.func_name=redash.tasks.queries.maintenance.refresh_queries job.id=305c0cae0a196ae96915fd2b6f81001c435aad65 Done refreshing queries: {'started_at': 1746444217.7345598, 'outdated_queries_count': 0, 'last_refresh_at': 1746444217.780974, 'query_ids': '[]'}
worker-1     | [2025-05-05 11:23:37,786][PID:35][INFO][rq.worker] periodic: Job OK (305c0cae0a196ae96915fd2b6f81001c435aad65)
worker-1     | [2025-05-05 11:23:37,786][PID:35][INFO][rq.worker] Result is kept for 600 seconds
postgres-1   | 2025-05-05 11:23:37.792 UTC [49] LOG:  unexpected EOF on client connection with an open transaction
server-1     | [2025-05-05 11:23:55,098][PID:25][ERROR][redash.app] Unable to load webpack manifest
server-1     | Traceback (most recent call last):
server-1     |   File "/app/redash/handlers/webpack.py", line 17, in get_asset
server-1     |     with open(WEBPACK_MANIFEST_PATH) as fp:
server-1     | FileNotFoundError: [Errno 2] No such file or directory: '/app/redash/handlers/../../client/dist/asset-manifest.json'
server-1     | [2025-05-05 11:23:55,102][PID:25][INFO][metrics] method=GET path=/setup endpoint=redash_setup status=200 content_type=text/html; charset=utf-8 content_length=2808 duration=109.89 query_count=1 query_duration=4.23
server-1     | [2025-05-05 11:23:55,103][PID:25][INFO][werkzeug] 192.168.65.1 - - [05/May/2025 11:23:55] "GET /setup HTTP/1.1" 200 -
server-1     | [2025-05-05 11:23:55,130][PID:25][INFO][metrics] method=GET path=/static/server.css endpoint=static status=404 content_type=text/html; charset=utf-8 content_length=207 duration=0.81 query_count=0 query_duration=0.00
server-1     | [2025-05-05 11:23:55,133][PID:25][INFO][werkzeug] 192.168.65.1 - - [05/May/2025 11:23:55] "GET /static/server.css HTTP/1.1" 404 -
server-1     | [2025-05-05 11:23:55,133][PID:25][INFO][metrics] method=GET path=/static/images/redash_icon_small.png endpoint=static status=404 content_type=text/html; charset=utf-8 content_length=207 duration=1.61 query_count=0 query_duration=0.00
server-1     | [2025-05-05 11:23:55,135][PID:25][INFO][werkzeug] 192.168.65.1 - - [05/May/2025 11:23:55] "GET /static/images/redash_icon_small.png HTTP/1.1" 404 -
server-1     | [2025-05-05 11:23:55,486][PID:25][INFO][metrics] method=GET path=/static/images/favicon-32x32.png endpoint=static status=404 content_type=text/html; charset=utf-8 content_length=207 duration=0.71 query_count=0 query_duration=0.00
server-1     | [2025-05-05 11:23:55,487][PID:25][INFO][werkzeug] 192.168.65.1 - - [05/May/2025 11:23:55] "GET /static/images/favicon-32x32.png HTTP/1.1" 404 -
server-1     | [2025-05-05 11:23:55,517][PID:25][INFO][metrics] method=GET path=/static/images/favicon-96x96.png endpoint=static status=404 content_type=text/html; charset=utf-8 content_length=207 duration=1.37 query_count=0 query_duration=0.00
server-1     | [2025-05-05 11:23:55,518][PID:25][INFO][werkzeug] 192.168.65.1 - - [05/May/2025 11:23:55] "GET /static/images/favicon-96x96.png HTTP/1.1" 404 -
server-1     | [2025-05-05 11:23:55,527][PID:25][INFO][metrics] method=GET path=/static/images/favicon-16x16.png endpoint=static status=404 content_type=text/html; charset=utf-8 content_length=207 duration=0.84 query_count=0 query_duration=0.00
server-1     | [2025-05-05 11:23:55,530][PID:25][INFO][werkzeug] 192.168.65.1 - - [05/May/2025 11:23:55] "GET /static/images/favicon-16x16.png HTTP/1.1" 404 -
postgres-1   | 2025-05-05 11:23:56.205 UTC [60] FATAL:  role "root" does not exist
worker-1     | [2025-05-05 11:24:07,757][PID:7][INFO][rq.worker] periodic: 18281a865ed3d1a60f366aeb8596fe2283aa421f
worker-1     | [2025-05-05 11:24:07,780][PID:36][INFO][rq.worker] periodic: Job OK (18281a865ed3d1a60f366aeb8596fe2283aa421f)
worker-1     | [2025-05-05 11:24:07,780][PID:36][INFO][rq.worker] Result is kept for 600 seconds
worker-1     | [2025-05-05 11:24:07,792][PID:7][INFO][rq.worker] periodic: 305c0cae0a196ae96915fd2b6f81001c435aad65
worker-1     | [2025-05-05 11:24:07,808][PID:37][INFO][rq.job.redash.tasks.queries.maintenance] job.func_name=redash.tasks.queries.maintenance.refresh_queries job.id=305c0cae0a196ae96915fd2b6f81001c435aad65 Refreshing queries...
worker-1     | [2025-05-05 11:24:07,849][PID:37][INFO][rq.job.redash.tasks.queries.maintenance] job.func_name=redash.tasks.queries.maintenance.refresh_queries job.id=305c0cae0a196ae96915fd2b6f81001c435aad65 Done refreshing queries: {'started_at': 1746444247.8085992, 'outdated_queries_count': 0, 'last_refresh_at': 1746444247.8482535, 'query_ids': '[]'}
worker-1     | [2025-05-05 11:24:07,852][PID:37][INFO][rq.worker] periodic: Job OK (305c0cae0a196ae96915fd2b6f81001c435aad65)
worker-1     | [2025-05-05 11:24:07,852][PID:37][INFO][rq.worker] Result is kept for 600 seconds
postgres-1   | 2025-05-05 11:24:07.858 UTC [62] LOG:  unexpected EOF on client connection with an open transaction
worker-1     | [2025-05-05 11:24:07,862][PID:7][INFO][rq.worker] periodic: 59a84668e68687338646f735965213c58e814b32
worker-1     | [2025-05-05 11:24:07,877][PID:38][INFO][rq.job.redash.tasks.queries.maintenance] job.func_name=redash.tasks.queries.maintenance.remove_ghost_locks job.id=59a84668e68687338646f735965213c58e814b32 Locks found: 0, Locks removed: 0
worker-1     | [2025-05-05 11:24:07,881][PID:38][INFO][rq.worker] periodic: Job OK (59a84668e68687338646f735965213c58e814b32)
worker-1     | [2025-05-05 11:24:07,881][PID:38][INFO][rq.worker] Result is kept for 600 seconds
server-1     | [2025-05-05 11:24:13,124][PID:25][ERROR][redash.app] Unable to load webpack manifest
server-1     | Traceback (most recent call last):
server-1     |   File "/app/redash/handlers/webpack.py", line 17, in get_asset
server-1     |     with open(WEBPACK_MANIFEST_PATH) as fp:
server-1     | FileNotFoundError: [Errno 2] No such file or directory: '/app/redash/handlers/../../client/dist/asset-manifest.json'
server-1     | [2025-05-05 11:24:13,126][PID:25][INFO][metrics] method=GET path=/setup endpoint=redash_setup status=200 content_type=text/html; charset=utf-8 content_length=2808 duration=5.01 query_count=1 query_duration=1.40
server-1     | [2025-05-05 11:24:13,128][PID:25][INFO][werkzeug] 192.168.65.1 - - [05/May/2025 11:24:13] "GET /setup HTTP/1.1" 200 -
server-1     | [2025-05-05 11:24:13,152][PID:25][INFO][metrics] method=GET path=/static/server.css endpoint=static status=404 content_type=text/html; charset=utf-8 content_length=207 duration=3.53 query_count=0 query_duration=0.00
server-1     | [2025-05-05 11:24:13,153][PID:25][INFO][metrics] method=GET path=/static/images/redash_icon_small.png endpoint=static status=404 content_type=text/html; charset=utf-8 content_length=207 duration=2.03 query_count=0 query_duration=0.00
server-1     | [2025-05-05 11:24:13,155][PID:25][INFO][werkzeug] 192.168.65.1 - - [05/May/2025 11:24:13] "GET /static/images/redash_icon_small.png HTTP/1.1" 404 -
server-1     | [2025-05-05 11:24:13,158][PID:25][INFO][werkzeug] 192.168.65.1 - - [05/May/2025 11:24:13] "GET /static/server.css HTTP/1.1" 404 -
server-1     | [2025-05-05 11:24:13,473][PID:25][INFO][metrics] method=GET path=/static/images/favicon-32x32.png endpoint=static status=404 content_type=text/html; charset=utf-8 content_length=207 duration=2.03 query_count=0 query_duration=0.00
server-1     | [2025-05-05 11:24:13,475][PID:25][INFO][werkzeug] 192.168.65.1 - - [05/May/2025 11:24:13] "GET /static/images/favicon-32x32.png HTTP/1.1" 404 -
server-1     | [2025-05-05 11:24:13,484][PID:25][INFO][metrics] method=GET path=/static/images/favicon-96x96.png endpoint=static status=404 content_type=text/html; charset=utf-8 content_length=207 duration=0.78 query_count=0 query_duration=0.00
server-1     | [2025-05-05 11:24:13,485][PID:25][INFO][werkzeug] 192.168.65.1 - - [05/May/2025 11:24:13] "GET /static/images/favicon-96x96.png HTTP/1.1" 404 -
server-1     | [2025-05-05 11:24:13,496][PID:25][INFO][metrics] method=GET path=/static/images/favicon-16x16.png endpoint=static status=404 content_type=text/html; charset=utf-8 content_length=207 duration=1.37 query_count=0 query_duration=0.00
server-1     | [2025-05-05 11:24:13,497][PID:25][INFO][werkzeug] 192.168.65.1 - - [05/May/2025 11:24:13] "GET /static/images/favicon-16x16.png HTTP/1.1" 404 -
postgres-1   | 2025-05-05 11:24:26.267 UTC [72] FATAL:  role "root" does not exist
worker-1     | [2025-05-05 11:24:37,794][PID:7][INFO][rq.worker] periodic: 305c0cae0a196ae96915fd2b6f81001c435aad65
worker-1     | [2025-05-05 11:24:37,805][PID:39][INFO][rq.job.redash.tasks.queries.maintenance] job.func_name=redash.tasks.queries.maintenance.refresh_queries job.id=305c0cae0a196ae96915fd2b6f81001c435aad65 Refreshing queries...
worker-1     | [2025-05-05 11:24:37,852][PID:39][INFO][rq.job.redash.tasks.queries.maintenance] job.func_name=redash.tasks.queries.maintenance.refresh_queries job.id=305c0cae0a196ae96915fd2b6f81001c435aad65 Done refreshing queries: {'started_at': 1746444277.8050203, 'outdated_queries_count': 0, 'last_refresh_at': 1746444277.8509953, 'query_ids': '[]'}
worker-1     | [2025-05-05 11:24:37,855][PID:39][INFO][rq.worker] periodic: Job OK (305c0cae0a196ae96915fd2b6f81001c435aad65)
worker-1     | [2025-05-05 11:24:37,856][PID:39][INFO][rq.worker] Result is kept for 600 seconds
postgres-1   | 2025-05-05 11:24:37.862 UTC [73] LOG:  unexpected EOF on client connection with an open transaction

ongrid avatar May 05 '25 11:05 ongrid

The issue occurs because when starting with Docker Compose, the /app/client/dist path in the container—which normally contains static HTML assets—is overwritten by the volume mount:

  volumes:
    - .:/app

If your local working directory doesn't include those built assets (i.e. you haven't run a local frontend build), the container will miss them.

ongrid avatar May 05 '25 15:05 ongrid