Closed feikesteenbergen closed 4 months ago
Boiled down query:
SELECT queryid, lag(total_exec_time) OVER (PARTITION BY queryid)
FROM public.stat_statements
WHERE db_id = 7401 AND observed >= now() - interval '1 day' LIMIT 10;
Resolving the view we get:
SELECT queryid, lag(total_exec_time) OVER (PARTITION BY queryid)
FROM (
SELECT stat_statements.db_id,
stat_statements.queryid,
stat_statements.observed,
stat_statements.total_exec_time
FROM history.stat_statements
UNION ALL
SELECT stat_statements.db_id,
stat_statements.queryid,
stat_statements.observed,
stat_statements.total_exec_time
FROM current.stat_statements
WHERE false
) v
WHERE db_id = 7401 AND observed >= now() - interval '1 day' LIMIT 10;
Applied 2.15.1 to the database; confirmed that the segfaults no longer occur.
What type of bug is this?
Crash
What subsystems and features are affected?
Compression
What happened?
While running a query the database crashed with the following message:
TimescaleDB version affected
2.15.0
PostgreSQL version used
16.3
What operating system did you use?
Docker based on Ubuntu x64
What installation method did you use?
Other
What platform did you run on?
Timescale Cloud
Relevant log output and stack trace