I am observing this error in the log of my PostgreSQL 12:
2023-10-07 16:03:06 UTC:LOG: POWA connected to database powa
2023-10-07 16:03:06 UTC:ERROR: query returned more than one row
2023-10-07 16:03:06 UTC:HINT: Make sure the query returns a single row, or use LIMIT 1.
2023-10-07 16:03:06 UTC:CONTEXT: PL/pgSQL function powa_take_snapshot(integer) line 31 at SQL statement
SQL statement "SELECT public.powa_take_snapshot()"
2023-10-07 16:03:06 UTC:LOG: background worker "powa" (PID 34049) exited with exit code 1
2023-10-07 16:03:06 UTC:LOG: POWA connected to database powa
2023-10-07 16:03:06 UTC:ERROR: query returned more than one row
2023-10-07 16:03:06 UTC:HINT: Make sure the query returns a single row, or use LIMIT 1.
2023-10-07 16:03:06 UTC:CONTEXT: PL/pgSQL function powa_take_snapshot(integer) line 31 at SQL statement
SQL statement "SELECT public.powa_take_snapshot()"
2023-10-07 16:03:06 UTC:LOG: background worker "powa" (PID 34049) exited with exit code 1
This error prevents me from doing a pg_basebackup of my DB.
Un saludo,
Pablo Delgado Flores
DBA Oracle · Desarrollador WordPress · Sysadmin
