https://pinot.apache.org/ logo
#troubleshooting
Title
# troubleshooting
s

Saumya Upadhyay

04/29/2022, 10:55 AM
hi All , if segments are offline how to make them online, on of the table has offline state it has been recovered automatically but other three tables segments are in offline state.
m

Mayank

04/29/2022, 5:06 PM
Check debug api in swagger. Typically it implies an underlying error that the debug endpoint might surface. You can also look at the server log for those segment names. Restarting the servers usually helps
s

Saumya Upadhyay

05/01/2022, 3:38 PM
debug api is not showing debug info for segments , broker info is coming and that is showing healthy. What we need to pass to get segment debug info.
Copy code
[
  {
    "tableName": "tScr_REALTIME",
    "numSegments": 408,
    "numServers": 2,
    "numBrokers": 2,
    "segmentDebugInfos": [],
    "serverDebugInfos": [],
    "brokerDebugInfos": [
      {
        "brokerName": "Broker_pinot-broker-0.pinot-broker-headless.pinot-qa.svc.cluster.local_8099",
        "idealState": "ONLINE",
        "externalView": "ONLINE"
      },
      {
        "brokerName": "Broker_pinot-broker-1.pinot-broker-headless.pinot-qa.svc.cluster.local_8099",
        "idealState": "ONLINE",
        "externalView": "ONLINE"
      }
    ],
    "tableSize": {
      "reportedSize": "411 KB",
      "estimatedSize": "411 KB"
    },
    "ingestionStatus": {
      "ingestionState": "HEALTHY",
      "errorMessage": ""
    }
  }
]
m

Mayank

05/01/2022, 4:59 PM
Hmm what does external view look like? Are segments online?
s

Saumya Upadhyay

05/02/2022, 4:14 AM
for this table yes they are online , but other tables which has very less data and size are offline and there we are facing records missing issue.
m

Mayank

05/02/2022, 4:15 AM
Then check the debug api for those tables
s

Saumya Upadhyay

05/02/2022, 4:16 AM
already checked but debug api's not showing any error, getting only broker info, it is not giving segments debug info
m

Mayank

05/02/2022, 4:17 AM
Are those segments offline in ideal state as well?
s

Saumya Upadhyay

05/02/2022, 4:18 AM
yes they are offline in ideal state also.
m

Mayank

05/02/2022, 4:27 AM
I see. Anything in the controller/server logs for those segments that are OFFLINE?
s

Saumya Upadhyay

05/02/2022, 5:26 AM
I cannot see any such errors
m

Mayank

05/02/2022, 3:15 PM
Helping in dm