prestodb / presto

The official home of the Presto distributed SQL query engine for big data
http://prestodb.io
Apache License 2.0
15.75k stars 5.29k forks source link

Apache Pinot Select query issue after enabling SSL #21490

Open ashaa24asha opened 7 months ago

ashaa24asha commented 7 months ago

Query 20231206_065307_00006_qsx57 failed: java.io.EOFException: HttpConnectionOverHTTP@450b0c95::DecryptedEndPoint@16d34a8e{48.43.f096.ip4.static.sl-reverse.com/150.240.67.72:8099<->/172.17.127.59:56016,OPEN,fill=-,flush=P,to=30989/300000} java.io.UncheckedIOException: java.io.EOFException: HttpConnectionOverHTTP@450b0c95::DecryptedEndPoint@16d34a8e{48.43.f096.ip4.static.sl-reverse.com/150.240.67.72:8099<->/172.17.127.59:56016,OPEN,fill=-,flush=P,to=30989/300000}

Your Environment

We have enabled SSL in apache pinot and trying to query from presto ,when trying to query all queries are working except Select query, without SSL all queries works fine

Properties used: connector.name=pinot pinot.controller-urls=150.240.67.72:8443 pinot.secure-connection=true pinot.grpc-tls-key-store-path=/home/asha/pinotssl/keystore.jks pinot.grpc-tls-key-store-password=** pinot.grpc-tls-trust-store-path=/home/asha/pinotssl/truststore.jks pinot.grpc-tls-trust-store-password=**

Current Behavior

presto:default> select * from transcript; Query 20231206_065307_00006_qsx57 failed: java.io.EOFException: HttpConnectionOverHTTP@450b0c95::DecryptedEndPoint@16d34a8e{48.43.f096.ip4.static.sl-reverse.com/150.240.67.72:8099<->/172.17.127.59:56016,OPEN,fill=-,flush=P,to=30989/300000} java.io.UncheckedIOException: java.io.EOFException: HttpConnectionOverHTTP@450b0c95::DecryptedEndPoint@16d34a8e{48.43.f096.ip4.static.sl-reverse.com/150.240.67.72:8099<->/172.17.127.59:56016,OPEN,fill=-,flush=P,to=30989/300000}

Screenshots (if appropriate)

image

walterddr commented 6 months ago

looks like a SSLContext issue on presto-pinot connector. tagging @xiangfu0 to share some insights