John Peter S
09/12/2022, 8:12 AM[
{
"message": "QueryExecutionError:\njava.lang.RuntimeException: Received error query execution result block: {230=ServerTableMissing:\nFailed to find table: SegmentMembership on server: Server_172.20.0.11_8098}\n\tat org.apache.pinot.query.service.QueryDispatcher.reduceMailboxReceive(QueryDispatcher.java:133)\n\tat org.apache.pinot.query.service.QueryDispatcher.submitAndReduce(QueryDispatcher.java:73)\n\tat org.apache.pinot.broker.requesthandler.MultiStageBrokerRequestHandler.handleRequest(MultiStageBrokerRequestHandler.java:156)",
"errorCode": 200
}
]
But I see the table is in good state with the segments present in all the configured servers including the server mentioned in the log.John Peter S
09/12/2022, 8:43 AM{
"exceptions": [
{
"message": "QueryExecutionError:\njava.lang.RuntimeException: Received error query execution result block: {230=ServerTableMissing:\nFailed to find table: SegmentMembership on server: Server_172.20.0.10_8098}\n\tat org.apache.pinot.query.service.QueryDispatcher.reduceMailboxReceive(QueryDispatcher.java:133)\n\tat org.apache.pinot.query.service.QueryDispatcher.submitAndReduce(QueryDispatcher.java:73)\n\tat org.apache.pinot.broker.requesthandler.MultiStageBrokerRequestHandler.handleRequest(MultiStageBrokerRequestHandler.java:156)",
"errorCode": 200
}
],
"numServersQueried": 0,
"numServersResponded": 0,
"numSegmentsQueried": 0,
"numSegmentsProcessed": 0,
"numSegmentsMatched": 0,
"numConsumingSegmentsQueried": 0,
"numConsumingSegmentsProcessed": 0,
"numConsumingSegmentsMatched": 0,
"numDocsScanned": 0,
"numEntriesScannedInFilter": 0,
"numEntriesScannedPostFilter": 0,
"numGroupsLimitReached": false,
"totalDocs": 0,
"timeUsedMs": 0,
"offlineThreadCpuTimeNs": 0,
"realtimeThreadCpuTimeNs": 0,
"offlineSystemActivitiesCpuTimeNs": 0,
"realtimeSystemActivitiesCpuTimeNs": 0,
"offlineResponseSerializationCpuTimeNs": 0,
"realtimeResponseSerializationCpuTimeNs": 0,
"offlineTotalCpuTimeNs": 0,
"realtimeTotalCpuTimeNs": 0,
"segmentStatistics": [],
"traceInfo": {},
"minConsumingFreshnessTimeMs": 0,
"numSegmentsPrunedByBroker": 0,
"numSegmentsPrunedByServer": 0,
"numSegmentsPrunedInvalid": 0,
"numSegmentsPrunedByLimit": 0,
"numSegmentsPrunedByValue": 0,
"explainPlanNumEmptyFilterSegments": 0,
"explainPlanNumMatchAllFilterSegments": 0,
"numRowsResultSet": 0
}
Mayank
Rong R
09/12/2022, 2:34 PMJohn Peter S
09/12/2022, 5:13 PMselect count(s1.member_id) from SegmentMembership s1 join SegmentMembership s2 on s1.member_id = s2.member_id where s1.segment_id='seg0' and s2.segment_id != 'seg0' group by s2.segment_id;
Rong R
09/12/2022, 5:14 PMRong R
09/12/2022, 5:14 PM_OFFLINE
to the table nameJohn Peter S
09/12/2022, 5:28 PM