You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by "jadami10 (via GitHub)" <gi...@apache.org> on 2023/11/11 00:58:58 UTC

[I] Querying 2 tables across different broker tenants gives an ambiguous error message [pinot]

jadami10 opened a new issue, #11990:
URL: https://github.com/apache/pinot/issues/11990

   We have table A on broker tenant A. Table B on broker tenant B. Trying to join these tables show `ProcessingException(errorCode:450, message:InternalError)`.
   
   While it's expected this doesn't work (broker needs to know about both tables), the error message is extremely vague. I ended up having to search for it in the broker logs before confirming what the real issue was.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org


Re: [I] Querying 2 tables across different broker tenants gives an ambiguous error message [pinot]

Posted by "walterddr (via GitHub)" <gi...@apache.org>.
walterddr commented on issue #11990:
URL: https://github.com/apache/pinot/issues/11990#issuecomment-1811566504

   hmm. interesting. the error should have 5 lines of stack trace at least. is it only this without any messages attached?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org


Re: [I] Querying 2 tables across different broker tenants gives an ambiguous error message [pinot]

Posted by "Jackie-Jiang (via GitHub)" <gi...@apache.org>.
Jackie-Jiang commented on issue #11990:
URL: https://github.com/apache/pinot/issues/11990#issuecomment-1813537617

   @walterddr From what I can tell, the query should fail at `WorkerManager.assignWorkersToNonPartitionedLeafFragment()`: `Preconditions.checkState(!routingTableMap.isEmpty(), "Unable to find routing entries for table: %s", tableName);`


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org


Re: [I] Querying 2 tables across different broker tenants gives an ambiguous error message [pinot]

Posted by "walterddr (via GitHub)" <gi...@apache.org>.
walterddr commented on issue #11990:
URL: https://github.com/apache/pinot/issues/11990#issuecomment-1813721719

   not really. this is only true if broker API is directly called. if it is called via controller API. the error message will be from 
   `PinotQueryResource.getMultiStageQueryResponse`: 
   ```
   QueryException.getException(QueryException.BROKER_REQUEST_SEND_ERROR, new Exception(
               String.format("Unable to dispatch multistage query for tables: [%s]", tableNames))).toString();
   ```
   b/c the return code is 450, it looks like it is directly hitting a broker and yes we are not returning proper error message here. good catch. will create a fix soon
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org


Re: [I] Querying 2 tables across different broker tenants gives an ambiguous error message [pinot]

Posted by "jadami10 (via GitHub)" <gi...@apache.org>.
jadami10 commented on issue #11990:
URL: https://github.com/apache/pinot/issues/11990#issuecomment-1811706737

   this is the only one i've seen. we ran into it randomly


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org


Re: [I] Querying 2 tables across different broker tenants gives an ambiguous error message [pinot]

Posted by "Jackie-Jiang (via GitHub)" <gi...@apache.org>.
Jackie-Jiang commented on issue #11990:
URL: https://github.com/apache/pinot/issues/11990#issuecomment-1810814110

   @walterddr Can you help take a look?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org