Thread: CASCADING could not open relation with OID

CASCADING could not open relation with OID

From
"Silvela, Jaime \(Exchange\)"
Date:

I’ve seen that some other people have had ERROR could not open relation with OID ###

 

The suggested cause was somebody trying to drop a table in the middle of   VACUUM.

 

In my case, the error seems to be spreading. Initially it affected only one table in a staging area that would get TRUNCATEd and populated every night. Now I’m starting to see it in more tables with similar functionality.

 

These get populated by scripts that run at night. Some of these are crashing. You can see a log below.

 

Has somebody experienced this before? I’m getting worried, could this be due to a faulty disk?

 

In the short term, I think I’m just going to recreate the tables from a backup of the schema. Any suggestions?

 

Thanks

Jaime

 

 

 

WARNING:  terminating connection because of crash of another server process

DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.

HINT:  In a moment you should be able to reconnect to the database and repeat your command.

CONTEXT:  writing block 5529 of relation 1663/16390/686426795

Re: CASCADING could not open relation with OID

From
Tom Lane
Date:
"Silvela, Jaime \(Exchange\)" <JSilvela@Bear.com> writes:
> WARNING:  terminating connection because of crash of another server
> process

This is not an interesting message: the interesting message is the
previous one about exactly what happened to the other process.  Look
earlier in the server log.

            regards, tom lane