Postgres Pro
Downloads
Home   >   mailing lists

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

From Pablo Delgado
Subject Error "public.powa_take_snapshot()" in PostgreSQL
Date
Msg-id CAL61JzHMposndF=myRAtcb-06+mt2Cb5H5PyHMmf7WKTvxF3HQ@mail.gmail.com
Whole thread Raw
Responses Re: Error "public.powa_take_snapshot()" in PostgreSQL
Re: Error "public.powa_take_snapshot()" in PostgreSQL
List pgsql-admin
Tree view
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: Benjamin Acquaye
Date:
Subject: Re:
Next
From: Ninad Shah
Date:
Subject: Re: Error "public.powa_take_snapshot()" in PostgreSQL