Apache Pinot

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.

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

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.

```[
  {
    "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": ""
    }
  }
]```

Hmm what does external view look like? Are segments online?

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.

Then check the debug api for those tables

already checked but debug api's not showing any error, getting only broker info, it is not giving segments debug info

Are those segments offline in ideal state as well?

yes they are offline in ideal state also.

I see. Anything in the controller/server logs for those segments that are OFFLINE?