admin.ensure_partition_metric_time ERROR when using pgwatch with timescaleDB

[HangDazon]

ERROR
[admin.ensure_partition_metric_time](sql:select * from admin.ensure_partition_metric_time($1, $2)])
metrics Failed to create partition on 'metrics':number of field descriptions must equal number of destinations, got 2 and 1

Expected behavior
it keep showing this error whenever I used timescaleDB and Metric DB. But When I use PostgreSQL is normal state.

[pashagolub]

Would you please post a text log instead of screenshot?

[HangDazon]

@pashagolub , sorry here is the logs:

2025-01-18 16:40:38.673 [INFO] [source:pg17-primary] [metric:stat_activity_realtime] [rows:1] measurements fetched
2025-01-18 16:40:38.846 [ERROR] [sink:postgres] [db:imdb_metrics] [sql:select * from admin.ensure_partition_metric_time($1, $2)] [args:[stat_activity_realtime 2025-01-18 16:40:38.670528 +0700 +07]] [err:number of field descriptions must equal number of destinations, got 2 and 1] [pid:78754] [time:1.604351ms] Query
2025-01-18 16:40:38.847 [ERROR] [sink:postgres] [db:imdb_metrics] Failed to create partition on 'metrics':number of field descriptions must equal number of destinations, got 2 and 1

it's only got ERROR with stat_activity_realtime, I think.

[pashagolub]

What metrics/presets are active in your deployment? I see stat_activity_realtime in error message but maybe you have more?

[HangDazon]

I used Full Preset and Added stat_activity_realtime metric.

[pashagolub]

Would you please check if #624 fixes the issue for you?

Thanks in advance!

[HangDazon]

@pashagolub Thanks, I've been testing for a while now, it seem fine.