bug(cnpg): error with refresh continuous aggregate policy #670

New issue

Closed

opened 2026-03-28 04:27:15 +00:00 by mfreeman451 · 1 comment

mfreeman451 commented

2026-03-28 04:27:15 +00:00

Owner

Imported from GitHub.

Original GitHub issue: #2065
Original author: @mfreeman451
Original URL: https://github.com/carverauto/serviceradar/issues/2065
Original created: 2025-12-05T02:55:12Z

{"level":"info","ts":"2025-12-05T02:51:06.12215505Z","logger":"postgres","msg":"record","logging_pod":"cnpg-7","record":{"log_time":"2025-12-05 02:51:06.121 UTC","process_id":"156372","session_id":"6932489a.262d4","session_line_num":"1","session_start_time":"2025-12-05 02:51:06 UTC","virtual_transaction_id":"27/26178","transaction_id":"837359","error_severity":"LOG","sql_state_code":"00000","message":"job 1032 threw an error","backend_type":"Refresh Continuous Aggregate Policy [1032]","query_id":"0"}}
{"level":"info","ts":"2025-12-05T02:51:06.12379142Z","logger":"postgres","msg":"record","logging_pod":"cnpg-7","record":{"log_time":"2025-12-05 02:51:06.123 UTC","process_id":"156372","session_id":"6932489a.262d4","session_line_num":"2","session_start_time":"2025-12-05 02:51:06 UTC","virtual_transaction_id":"27/0","transaction_id":"0","error_severity":"ERROR","sql_state_code":"XX000","message":"cache lookup failed for function \"time_bucket\" with 2 args","backend_type":"Refresh Continuous Aggregate Policy [1032]","query_id":"0"}}                {"level":"info","ts":"2025-12-05T02:51:06.126136654Z","logger":"postgres","msg":"record","logging_pod":"cnpg-7","record":{"log_time":"2025-12-05 02:51:06.125 UTC","process_id":"31","se
ssion_id":"69313bc8.1f","session_line_num":"351","session_start_time":"2025-12-04 07:44:08 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"background worker \"Refresh Continuous Aggregate Policy [1032]\" (PID 156372) exited with exit code 1","backend_type":"postmaster","query_id":"0"}}

Imported from GitHub. Original GitHub issue: #2065 Original author: @mfreeman451 Original URL: https://github.com/carverauto/serviceradar/issues/2065 Original created: 2025-12-05T02:55:12Z --- ``` {"level":"info","ts":"2025-12-05T02:51:06.12215505Z","logger":"postgres","msg":"record","logging_pod":"cnpg-7","record":{"log_time":"2025-12-05 02:51:06.121 UTC","process_id":"156372","session_id":"6932489a.262d4","session_line_num":"1","session_start_time":"2025-12-05 02:51:06 UTC","virtual_transaction_id":"27/26178","transaction_id":"837359","error_severity":"LOG","sql_state_code":"00000","message":"job 1032 threw an error","backend_type":"Refresh Continuous Aggregate Policy [1032]","query_id":"0"}} {"level":"info","ts":"2025-12-05T02:51:06.12379142Z","logger":"postgres","msg":"record","logging_pod":"cnpg-7","record":{"log_time":"2025-12-05 02:51:06.123 UTC","process_id":"156372","session_id":"6932489a.262d4","session_line_num":"2","session_start_time":"2025-12-05 02:51:06 UTC","virtual_transaction_id":"27/0","transaction_id":"0","error_severity":"ERROR","sql_state_code":"XX000","message":"cache lookup failed for function \"time_bucket\" with 2 args","backend_type":"Refresh Continuous Aggregate Policy [1032]","query_id":"0"}} {"level":"info","ts":"2025-12-05T02:51:06.126136654Z","logger":"postgres","msg":"record","logging_pod":"cnpg-7","record":{"log_time":"2025-12-05 02:51:06.125 UTC","process_id":"31","se ssion_id":"69313bc8.1f","session_line_num":"351","session_start_time":"2025-12-04 07:44:08 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"background worker \"Refresh Continuous Aggregate Policy [1032]\" (PID 156372) exited with exit code 1","backend_type":"postmaster","query_id":"0"}} ```

mfreeman451 commented

2026-03-28 04:27:15 +00:00

Author

Owner

Imported GitHub comment.

Original author: @mfreeman451
Original URL: https://github.com/carverauto/serviceradar/issues/2065#issuecomment-3617678740
Original created: 2025-12-05T16:46:30Z

closing as completed

Imported GitHub comment. Original author: @mfreeman451 Original URL: https://github.com/carverauto/serviceradar/issues/2065#issuecomment-3617678740 Original created: 2025-12-05T16:46:30Z --- closing as completed