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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux