Error "public.powa_take_snapshot()" in PostgreSQL
От
Pablo Delgado
Тема
Error "public.powa_take_snapshot()" in PostgreSQL
Дата
Msg-id
CAL61JzHMposndF=myRAtcb-06+mt2Cb5H5PyHMmf7WKTvxF3HQ@mail.gmail.com
Список
Дерево обсуждения
Error "public.powa_take_snapshot()" in PostgreSQL Pablo Delgado <pabloj.df@gmail.com>
Re: Error "public.powa_take_snapshot()" in PostgreSQL Ninad Shah <ninad.shah@percona.com>
Re: Error "public.powa_take_snapshot()" in PostgreSQL Julien Rouhaud <rjuju123@gmail.com>
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
В списке pgsql-admin по дате отправления
