Error in segment -Reg

[Deepan S]

Hi all,

I am facing error as "relation does not exist (seg5 10.10.10.1:4000 pid=5643).

I can't able to drop, truncate the tables. Even i can't able to drop that database also. I am this error after crash recovery.

I am getting error in that particular segment.

Kindly suggest me what to do? It's about 8TB.

REGARDS! DEEPAN S

[Joe Manning]

Hi, Deepan.

 

It should be possible to drop the table with “DROP TABLE IF EXISTS schema.table”

 

Regards,

joe.

 

From: Deepan S <dee...@softsmith.com>
Date: Wednesday, 22 February 2023 at 12:39
To: gpdb-...@greenplum.org <gpdb-...@greenplum.org>
Subject: [gpdb-users] Error in segment -Reg

!! External Email

--
You received this message because you are subscribed to the Google Groups "Greenplum Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+...@greenplum.org.
To view this discussion on the web visit https://groups.google.com/a/greenplum.org/d/msgid/gpdb-users/CAJtRhxavJbO2gx8pQS%3DqEMYBz7xajagYRJn9jfxEib1f810M0A%40mail.gmail.com.

 

!! External Email: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender.