Hi.. i am trying to delete a pinot segment from re...
# generalh
Harshini Elath
02/14/2020, 5:26 PMHi.. i am trying to delete a pinot segment from rest api but it doesn’t delete it. Why would that happen?
n
Neha Pawar
02/14/2020, 5:43 PM
Can you share the curl command? And what is the controller log printing at that time?
h
Harshini Elath
02/14/2020, 5:44 PMi'm using the swagger ui
Harshini Elath
02/14/2020, 5:44 PMmessage has been deleted
Harshini Elath
02/14/2020, 5:45 PMbut when i do get segments; i can still see the segment
Harshini Elath
02/14/2020, 5:46 PMmessage has been deleted
n
Neha Pawar
02/14/2020, 5:50 PM
do you have access to the controller's log file? there could be an exception in there that will help
h
Harshini Elath
02/14/2020, 5:54 PMHarshini Elath
02/14/2020, 5:54 PMn
Neha Pawar
02/14/2020, 6:01 PM
thanks, will investigate in a bit. The ideal state and external view of this table would also help.
Neha Pawar
02/14/2020, 6:01 PM
do you see this segment in ideal state/external view?
Neha Pawar
02/14/2020, 6:01 PM
what about in segment metadata?
h
Harshini Elath
02/14/2020, 6:03 PMi can see the segment in external view
Harshini Elath
02/14/2020, 6:03 PMalso segment metadata
Harshini Elath
02/14/2020, 6:03 PM{
"segment.offline.download.url": "http://pinot-controller-0.pinot-controller.pinot.svc.cluster.local:9000/segments/temp_pos_psa/temp_pos_psa",
"segment.time.unit": null,
"segment.start.time": "-1",
"segment.end.time": "-1",
"segment.total.docs": "5318029",
"segment.table.name": "temp_pos_psa",
"segment.creation.time": "1581697248926",
"segment.name": "temp_pos_psa",
"segment.index.version": "v3",
"segment.offline.refresh.time": "1581699556268",
"custom.map": null,
"segment.type": "OFFLINE",
"segment.offline.push.time": "1581699439359",
"segment.crc": "1578365118"
}
n
Neha Pawar
02/14/2020, 7:01 PM
why does the metadata say null, -1 -1
Copy code
"segment.time.unit": null,
"segment.start.time": "-1",
"segment.end.time": "-1",h
Harshini Elath
02/14/2020, 7:31 PMi think that is because the other segments are like :
Harshini Elath
02/14/2020, 7:31 PMtemp_pos_psa_2020-01-01_2020-01-01
Harshini Elath
02/14/2020, 7:31 PMwith time field i gave
Harshini Elath
02/14/2020, 7:32 PMSo.. when I first loaded the table ; I forgot the time spec in table schema and table config and it created this segment temp_pos_psa
Harshini Elath
02/14/2020, 7:33 PMI deleted the segment and recreated the schema and table config ; so updated segments loaded like : temp_pos_psa_2020-01-01_2020-01-01
Harshini Elath
02/14/2020, 7:34 PMbut for some reason ; this temp_pos_psa segment is not getting removed from pinot
n
Neha Pawar
02/14/2020, 9:37 PM
can you share the logs from the pinot-server that has this segment?
h
Harshini Elath
02/14/2020, 10:20 PMi don't see any relevant logs in server
Harshini Elath
02/14/2020, 10:21 PMbut surprisingly, i deleted the segment from rest api , and it deleted it this time
Harshini Elath
02/14/2020, 10:21 PMnot sure what was the reason
n
Neha Pawar
02/14/2020, 10:24 PM
i suspect it was just a slow helix transition
Neha Pawar
02/14/2020, 10:25 PM
is your controller log configured to separate out the helix logs in a different file?
Neha Pawar
02/14/2020, 10:25 PM
because i couldn't see information about helix transitions in the controller
h
Harshini Elath
02/14/2020, 10:29 PMyeah.. might be
Harshini Elath
02/14/2020, 10:29 PMi don't think so.. i got this from kubernetes shell