20220722-pg_dump: error: invalid number of parents 0 for table

From: "Techsupport" <techsupport(at)sardonyx(dot)in>
To: <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: 20220722-pg_dump: error: invalid number of parents 0 for table
Date: 2022-07-22 15:20:43
Message-ID: 014a01d89dde$9e120030$da360090$@sardonyx.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Team,

We are using PostgreSQL 12.3, It is running under windows

In that server there is nearly 8 databases are running.

I have changed the data directory from one drive to another drive. At the
time of change the data directory,

have stopped the PostgreSQL instance and Copy the contents under the data
directory and paste it on the new drive,

and changed the data directory in the registry and start the instance.

After that all the databases are working, but unable to take backup for one
database.

In 8 database, I have faced this issue in one database.

When I see the log file it gives the following error,

2022-07-16 12:16:58.019 +04 [9332] STATEMENT: select f_rta_log_partition();

2022-07-16 12:21:41.186 +04 [12936] LOG: request to flush past end of
generated WAL; request D9F/E61D8E10, currpos D9F/E61AB138

2022-07-16 12:21:41.186 +04 [12936] CONTEXT: writing block 9 of relation
pg_tblspc/907117/PG_12_201909212/907120/2611

2022-07-16 12:21:41.187 +04 [12936] ERROR: xlog flush request D9F/E61D8E10
is not satisfied --- flushed only to D9F/E61AB138

2022-07-16 12:21:41.187 +04 [12936] CONTEXT: writing block 9 of relation
pg_tblspc/907117/PG_12_201909212/907120/2611

2022-07-16 12:21:42.458 +04 [12936] LOG: request to flush past end of
generated WAL; request D9F/E61D8E10, currpos D9F/E61AB138

2022-07-16 12:21:42.458 +04 [12936] CONTEXT: writing block 9 of relation
pg_tblspc/907117/PG_12_201909212/907120/2611

2022-07-16 12:21:42.459 +04 [12936] ERROR: xlog flush request D9F/E61D8E10
is not satisfied --- flushed only to D9F/E61AB138

2022-07-16 12:21:42.459 +04 [12936] CONTEXT: writing block 9 of relation
pg_tblspc/907117/PG_12_201909212/907120/2611

2022-07-16 12:21:42.460 +04 [12936] WARNING: could not write block 9 of
pg_tblspc/907117/PG_12_201909212/907120/2611

2022-07-16 12:21:42.460 +04 [12936] DETAIL: Multiple failures --- write
error might be permanent.

.

When I try to back up by using command prompt it shows the below error

pg_dump: error: invalid number of parents 0 for table "<partition Table
name>"

suggest me how to solve this issue.

Thanks in advance.

Thanks,

Karthick Ramu

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2022-07-22 15:52:47 Re: 20220722-pg_dump: error: invalid number of parents 0 for table
Previous Message Sergey Burladyan 2022-07-22 14:46:37 How does postgres sort large strings?