Hello :slightly_smiling_face: Can someone remind m...
# troubleshooting
j
Hello 🙂 Can someone remind me the steps to handle
"message": "MergeResponseError: Data schema mismatch between merged block:
after a REALTIME table backward-compatible schema change ? (new column) I've tried
Reload All Segments
Is that because I haven't set
pinot.server.instance.reload.consumingSegment
?
Full message:
Copy code
[
  {
    "errorCode": 500,
    "message": "MergeResponseError:
Data schema mismatch between merged block: 

[communityId(STRING),documentId(STRING),eventTimeString(STRING),eventType(STRING),hoverDuration(INT),ibcustomer(STRING),origin(STRING),projectId(STRING),selectionId(STRING),timeString(STRING),userId(STRING)] 

and block to merge:

[communityId(STRING),documentId(STRING),eventTimeString(STRING),eventType(STRING),ibcustomer(STRING),origin(STRING),projectId(STRING),selectionId(STRING),timeString(STRING),userId(STRING)], 
drop block to merge"
  }
]
x
can you try to restart realtime servers?
j
Oh, I'd have to see with the SREs Is that the only way ?
Because that would mean changing a schema would lead to downtime, right ?
x
hmm, typically it should be if it’s backwards compatible changes
Shouldn’t
Need to check what’s going on there
Can you create an issue and describe how you find this issue?
j
Yeah sure will do, thanks @Xiang Fu
j
Yes, in order to reload consuming segment as well, you need to set a flag
We should consider making it on by default
j
@Jackie Is there any benefit to keeping it off ?
j
I don’t think so. I think the flag is added when testing the feature
Let me double check
j
Okay It's this flag :
pinot.server.instance.reload.consumingSegment
, right ? 🙂
j
Yes, that is correct
j
Great news, I'll try that then 🎉 Thanks Jackie
j
@Xiang Fu PR to set the default behavior: https://github.com/apache/incubator-pinot/pull/7078
j
Fantastic thankyou