Re: Error "public.powa_take_snapshot()" in PostgreSQL

Поиск
Список
Период
Сортировка
От Ninad Shah
Тема Re: Error "public.powa_take_snapshot()" in PostgreSQL
Дата
Msg-id CAMtEjObzv9WW-bxrpnUnFz3n_T2zo83sdCkgSTziMuO7T7KJww@mail.gmail.com
обсуждение исходный текст
Ответ на Error "public.powa_take_snapshot()" in PostgreSQL  (Pablo Delgado <pabloj.df@gmail.com>)
Список pgsql-admin
Дерево обсуждения
Hi Pablo,

This is not a PG in-built function. It seems like a user-defined one. You may need to troubleshoot the function.


Thanks,
Ninad



On Mon, Oct 9, 2023 at 4:01 PM Pablo Delgado <pabloj.df@gmail.com> wrote:
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

This error prevents me from doing a pg_basebackup of my DB.

--
Un saludo, 

Pablo Delgado Flores
DBA Oracle · Desarrollador WordPress · Sysadmin

В списке pgsql-admin по дате отправления: