| From: | Pablo Delgado <pabloj(dot)df(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Error "public.powa_take_snapshot()" in PostgreSQL |
| Date: | 2023-10-07 21:54:15 |
| Message-ID: | CAL61JzHMposndF=myRAtcb-06+mt2Cb5H5PyHMmf7WKTvxF3HQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
https://pablodelgadoflores.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ninad Shah | 2023-10-09 12:25:51 | Re: Error "public.powa_take_snapshot()" in PostgreSQL |
| Previous Message | Benjamin Acquaye | 2023-10-05 20:55:34 | Re: |