Insights tab not loading all data

[manymotes]

most of the graphs in the insights page dont load.

The bottom operations card does load:

seeing this in the network tab:

getting these logs in docker container:
2024-04-11 16:53:58 {"level":30,"time":1712876038726,"pid":7,"hostname":"33014e5c5e8c","msg":"[204] (::ffff:192.168.65.1) OPTIONS /graphql"}
2024-04-11 16:53:58 Flag "startTransaction" is disabled but Sentry failed to find a transaction.
2024-04-11 16:53:58 Try to create a transaction before GraphQL execution phase is started.
2024-04-11 16:53:58 {"level":30,"time":1712876038759,"pid":7,"hostname":"33014e5c5e8c","msg":"Counting requests and failures (period={"from":"2024-04-04T22:00:00.000Z","to":"2024-04-11T21:59:59.000Z"}, target=1fbf9615-9ac4-49a6-860b-a3fd94ff5d70) - (requestId=/bkIH247Sii+p04m4yrWGA/0000000330)"}
2024-04-11 16:53:58 {"level":30,"time":1712876038759,"pid":7,"hostname":"33014e5c5e8c","msg":"Counting requests and failures (period={"from":"2024-04-04T22:00:00.000Z","to":"2024-04-11T21:59:59.000Z"}, target=1fbf9615-9ac4-49a6-860b-a3fd94ff5d70) - (requestId=/bkIH247Sii+p04m4yrWGA/0000000330)"}
2024-04-11 16:53:58 {"level":30,"time":1712876038759,"pid":7,"hostname":"33014e5c5e8c","msg":"Counting failures (period={"from":"2024-04-04T22:00:00.000Z","to":"2024-04-11T21:59:59.000Z"}, target=1fbf9615-9ac4-49a6-860b-a3fd94ff5d70) - (requestId=/bkIH247Sii+p04m4yrWGA/0000000330)"}
2024-04-11 16:53:58 {"level":30,"time":1712876038759,"pid":7,"hostname":"33014e5c5e8c","msg":"Counting unique operations (period={"from":"2024-04-04T22:00:00.000Z","to":"2024-04-11T21:59:59.000Z"}, target=1fbf9615-9ac4-49a6-860b-a3fd94ff5d70) - (requestId=/bkIH247Sii+p04m4yrWGA/0000000330)"}
2024-04-11 16:53:58 {"level":30,"time":1712876038759,"pid":7,"hostname":"33014e5c5e8c","msg":"Reading overall duration percentiles (period={"from":"2024-04-04T22:00:00.000Z","to":"2024-04-11T21:59:59.000Z"}, target=1fbf9615-9ac4-49a6-860b-a3fd94ff5d70) - (requestId=/bkIH247Sii+p04m4yrWGA/0000000330)"}
2024-04-11 16:53:58 {"level":30,"time":1712876038759,"pid":7,"hostname":"33014e5c5e8c","msg":"Reading failures over time (period={"from":"2024-04-04T22:00:00.000Z","to":"2024-04-11T21:59:59.000Z"}, resolution=90, target=1fbf9615-9ac4-49a6-860b-a3fd94ff5d70) - (requestId=/bkIH247Sii+p04m4yrWGA/0000000330)"}
2024-04-11 16:53:58 {"level":30,"time":1712876038759,"pid":7,"hostname":"33014e5c5e8c","msg":"Reading requests over time (period={"from":"2024-04-04T22:00:00.000Z","to":"2024-04-11T21:59:59.000Z"}, resolution=90, target=1fbf9615-9ac4-49a6-860b-a3fd94ff5d70) - (requestId=/bkIH247Sii+p04m4yrWGA/0000000330)"}
2024-04-11 16:53:58 {"level":30,"time":1712876038759,"pid":7,"hostname":"33014e5c5e8c","msg":"Reading duration over time (period={"from":"2024-04-04T22:00:00.000Z","to":"2024-04-11T21:59:59.000Z"}, resolution=90, target=1fbf9615-9ac4-49a6-860b-a3fd94ff5d70) - (requestId=/bkIH247Sii+p04m4yrWGA/0000000330)"}
2024-04-11 16:53:58 {"level":30,"time":1712876038759,"pid":7,"hostname":"33014e5c5e8c","msg":"Counting unique clients (period={"from":"2024-04-04T22:00:00.000Z","to":"2024-04-11T21:59:59.000Z"}, target=1fbf9615-9ac4-49a6-860b-a3fd94ff5d70) - (requestId=/bkIH247Sii+p04m4yrWGA/0000000330)"}
2024-04-11 16:53:58 {"level":50,"time":1712876038771,"pid":7,"hostname":"33014e5c5e8c","msg":"Failed to run ClickHouse query, executionId: duration_and_count_over_time_hourly-d7f17c746acf7, code: ERR_NON_2XX_3XX_RESPONSE , error name: HTTPError, message: Response code 500 (Internal Server Error) - (requestId=/bkIH247Sii+p04m4yrWGA/0000000330)"}
2024-04-11 16:53:59 {"level":50,"time":1712876039024,"pid":7,"hostname":"33014e5c5e8c","msg":"Failed to run ClickHouse query, executionId: duration_and_count_over_time_hourly-d7f17c746acf7, code: ERR_NON_2XX_3XX_RESPONSE , error name: HTTPError, message: Response code 500 (Internal Server Error) - (requestId=/bkIH247Sii+p04m4yrWGA/0000000330)"}
2024-04-11 16:53:59 {"level":50,"time":1712876039529,"pid":7,"hostname":"33014e5c5e8c","msg":"Failed to run ClickHouse query, executionId: duration_and_count_over_time_hourly-d7f17c746acf7, code: ERR_NON_2XX_3XX_RESPONSE , error name: HTTPError, message: Response code 500 (Internal Server Error) - (requestId=/bkIH247Sii+p04m4yrWGA/0000000330)"}
2024-04-11 16:54:00 {"level":50,"time":1712876040283,"pid":7,"hostname":"33014e5c5e8c","msg":"Failed to run ClickHouse query, executionId: duration_and_count_over_time_hourly-d7f17c746acf7, code: ERR_NON_2XX_3XX_RESPONSE , error name: HTTPError, message: Response code 500 (Internal Server Error) - (requestId=/bkIH247Sii+p04m4yrWGA/0000000330)"}
2024-04-11 16:54:01 {"level":50,"time":1712876041288,"pid":7,"hostname":"33014e5c5e8c","msg":"Failed to run ClickHouse query, executionId: duration_and_count_over_time_hourly-d7f17c746acf7, code: ERR_NON_2XX_3XX_RESPONSE , error name: HTTPError, message: Response code 500 (Internal Server Error) - (requestId=/bkIH247Sii+p04m4yrWGA/0000000330)"}

[kamilkisiela]

Fixed in #4537

There was a bug in latest ClickHouse ClickHouse/ClickHouse#62113 ClickHouse/ClickHouse#62698
ClickHouse team fixed (ClickHouse/ClickHouse#62186), but we're now waiting for a release.

[manymotes]

Awesome, TY so much!!!

[17bcs1837]

Hi, is it fixed yet?