Postgres Pro
Downloads
Home   >   mailing lists

Thread: Getting error on

Getting error on

From
M Tarkeshwar Rao
Date:

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?

 

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.

 

Regards

Tarkeshwar

Re: Getting error on

From
Ron
Date:
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.

RE: Getting error on

From
M Tarkeshwar Rao
Date:

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.