Postgres Pro
Downloads
Home   >   mailing lists

Re: Error "public.powa_take_snapshot()" in PostgreSQL - Mailing list pgsql-admin

From Ninad Shah
Subject Re: Error "public.powa_take_snapshot()" in PostgreSQL
Date
Msg-id CAMtEjObzv9WW-bxrpnUnFz3n_T2zo83sdCkgSTziMuO7T7KJww@mail.gmail.com
Whole thread Raw
In response to Error "public.powa_take_snapshot()" in PostgreSQL  (Pablo Delgado <pabloj.df@gmail.com>)
List pgsql-admin
Tree view
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 by date:

Previous
From: Pablo Delgado
Date:
Subject: Error "public.powa_take_snapshot()" in PostgreSQL
Next
From: Julien Rouhaud
Date:
Subject: Re: Error "public.powa_take_snapshot()" in PostgreSQL