Hi Team, We are onboarding on Pinot. Faced a stra...
# troubleshooting
a
Hi Team, We are onboarding on Pinot. Faced a strange issue that two tables out of 4 in Pinot got deleted for an unknown reason. We might have done something wrong. Any idea about the possible reason for tables deletion. Also any logs I can refer to check this deletion operation. Any help would be appreciated. Thanks
r
when table is being deleted, the deep store segment files will be put in retention for 7 days (default cluster setting) usually they are moved from your PinotFS base/<table_name>/<segment_name> to /base/deleted_segments/<table_name>/<segment_name>
you could probably look at the deep store deleted segment and try to find out when that deletion operation occurs, then backtrack into the controller log at that time.
a
Thanks Rong for the insights. Any reason of default table deletion? is there any configuration that we can do to stop the default table deletion?
r
there's no default table deletion. it can only happen if someone specifically deleted the table via controller API.
let me rephrase what I meant above
a
cool ! Got it now, Thanks
👍 1