HouseWatch icon indicating copy to clipboard operation
HouseWatch copied to clipboard
verified publisher icon PostHog

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

Open Dolso opened this issue 2 years ago • 2 comments

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

Dolso avatar Jul 14 '23 12:07 Dolso

@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

my-git-hub avatar Jul 16 '23 12:07 my-git-hub

For me, the error was due to older version of clickhouse running in my cluster.

chiragb1994 avatar Aug 09 '23 07:08 chiragb1994