PostHog/HouseWatch

After docker-compose up and i go to the site, method /api/analyze/query_graphs return 500

Dolso opened this issue · 2 comments

Dolso commented

Hi! I decided to try your tool, but I can't use it

In localhost:3000 i see erros:

backend: http api method /api/analyze/query_graphs return 500 with body {"type":"server_error","code":"error","detail":"A server error occurred.","attr":null}

frontend:
Screenshot 2023-07-14 at 15 43 14

logs:

housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 GET /
housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 Returned 304 in 7 ms
housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 GET /static/css/1.f7ef86df.chunk.css
housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 GET /static/css/main.6e4c166f.chunk.css
housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 Returned 304 in 5 ms
housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 Returned 304 in 5 ms
housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 GET /static/js/1.fb96ed73.chunk.js
housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 GET /static/js/main.a91ea030.chunk.js
housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 Returned 304 in 2 ms
housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 Returned 304 in 2 ms
housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 GET /static/css/main.6e4c166f.chunk.css.map
housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 GET /static/css/1.f7ef86df.chunk.css.map
housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 Returned 304 in 1 ms
housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 Returned 304 in 1 ms
housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 GET /static/js/1.fb96ed73.chunk.js.map
housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 GET /static/js/main.a91ea030.chunk.js.map
housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 Returned 304 in 1 ms
housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 Returned 304 in 2 ms
housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 GET /static/media/HindSiliguri-Medium.41fd138d.ttf
housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 Returned 304 in 1 ms
housewatch-app-1 | [14/Jul/2023 12:45:08] "GET /api/analyze/hostname HTTP/1.1" 200 29
housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 GET /favicon.ico
housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 Returned 304 in 2 ms
housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 GET /manifest.json
housewatch-web-1 | HTTP 7/14/2023 12:45:08 PM 172.18.0.1 Returned 304 in 1 ms
housewatch-app-1 | [14/Jul/2023 12:45:08] "GET /api/analyze/query_graphs HTTP/1.1" 500 86

I use environment variables: CLICKHOUSE_SECURE=False, CLICKHOUSE_HOST , CLICKHOUSE_CLUSTER, CLICKHOUSE_USER and CLICKHOUSE_PASSWORD

With respect, Andrei

my-git-hub commented

@Dolso there can be many reasons for 500 Internal server error. Can you click on the link to the API http://localhost:8000/api/analyze/query_graphs and open it in a new tab. Check if there's any additional explanation about the error, like trace logs.

If there will be just the pretty error-page try to start the API in debug mode. Like so:
DEBUG=1 python manage.py runserver 0.0.0.0:8000