search

hapostgres / pg_auto_failover

Postgres extension and service for automated failover and high-availability
Other
1.1k stars 115 forks source link

Monitor ERROR: invalid input syntax for type integer: "" #1033

Open degubellini opened 4 months ago

degubellini commented 4 months ago

Hello, On 4 Debian 12 nodes (3 nodes + 1 monitor node), I've installed postgresql 16 and postgresql-16-auto-failover. Packages come from postgres repository (https://apt.postgresql.org/pub/repos/apt)

I am testing postresql switchover and I run "pg_autoctl perform switchover --formation default --group 0" on a node

Looking at journalctl log files for the service, everything looks fine and "pg_autoctl show state" is showing the switchover complete. However, at the cli, before the completion of the switchover I get

Error

Why am I getting this error? Does it mean that I can't trust the failover also if it seems that happened?

This is pg_autofailover version

pg_autoctl version 2.1-2.pgdg120+1 pg_autoctl extension version 2.1 compiled with PostgreSQL 16.1 (Debian 16.1-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit compatible with Postgres 11, 12, 13, 14, 15, and 16

degubellini commented 4 months ago

Morning, any feedback on this? or do you need more specific details?

degubellini commented 3 months ago

Any feedback for this?

jamielinux commented 2 months ago

I'm getting this issue too. Also on postgres 16.

Like you, the switchover seems to be ok, but it's hard to know if this warning means something less noticeable broke.