RE: Getting error on - Mailing list pgsql-general

From M Tarkeshwar Rao
Subject RE: Getting error on
Date
Msg-id AM0PR0702MB37775172CE3CA6DDFF1018F8AE9C0@AM0PR0702MB3777.eurprd07.prod.outlook.com
Whole thread Raw
In response to Re: Getting error on  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general

Thanks for reply.

 

Can you please suggest why this error occur?

Any resource crunch on postgres server?

 

Regards

Tarkeshwar

From: Ron <ronljohnsonjr@gmail.com>
Sent: Monday, June 15, 2020 7:17 PM
To: pgsql-general@lists.postgresql.org
Subject: Re: Getting error on

 

On 6/15/20 8:43 AM, M Tarkeshwar Rao wrote:

Hi all,

 

I have the c++ postgres client. When I restarted my client process I am getting following error on insertion.

 

Can you please suggest why this error is coming and how to resolve it?


The error hint says how to resolve it.
 

2020-04-17 06:30:04.498 PRINT_DEFAULT_ERROR: Processor-DefaultCollectorGroup-0 :DRViewerPoint.cc :notify --> Failed to insert the data

ERROR:  index "1_rasciistruct_thefields_2_pkey" contains unexpected zero page at block 291

HINT:  Please REINDEX it.


REINDEX INDEX 1_rasciistruct_thefields_2_pkey;

--
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Getting error on
Next
From: Don Seiler
Date:
Subject: Re: Mixed Locales and Upgrading