[ https://issues.apache.org/jira/browse/SOLR-9167?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15305447#comment-15305447 ]
Kevin Risden commented on SOLR-9167: ------------------------------------ Thanks for the detailed ticket. The error message about Packet len I've seen when there is too much data in ZK and the jute buffer is filled. {quote} java.io.IOException: Packet len1213486160 is out of range! {quote} I see that you tried a query with curl that is different than the one with the JDBC driver. Can you try the following with curl? {code} curl --data-urlencode 'stmt=SELECT count(*) FROM test' 'http://localhost:8983?collection=test&aggregationMode=map_reduce&numWorkers=2' {code} map_reduce and facet take two different code paths. > Unable to connect to solr via solrj jdbc driver > ------------------------------------------------ > > Key: SOLR-9167 > URL: https://issues.apache.org/jira/browse/SOLR-9167 > Project: Solr > Issue Type: Bug > Components: SolrCloud, SolrJ > Affects Versions: 6.0 > Environment: java.version=1.8.0_77 > java.vendor=Oracle Corporation > os.name=Mac OS X > os.arch=x86_64 > os.version=10.11.5 > Reporter: Christian Schwarzinger > Priority: Minor > > Getting the following error, when trying to connect to solr via jdbc driver. > {panel:title=client > error|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1|bgColor=#FFFFCE} > (ClientCnxn.java:1102) - Session 0x0 for server > fe80:0:0:0:0:0:0:1%1/fe80:0:0:0:0:0:0:1%1:8983, unexpected error, closing > socket connection and attempting reconnect > java.io.IOException: Packet len1213486160 is out of range! > at > org.apache.zookeeper.ClientCnxnSocket.readLength(ClientCnxnSocket.java:112) > ~[zookeeper-3.4.6.jar:3.4.6-1569965] > at > org.apache.zookeeper.ClientCnxnSocketNIO.doIO(ClientCnxnSocketNIO.java:79) > ~[zookeeper-3.4.6.jar:3.4.6-1569965] > at > org.apache.zookeeper.ClientCnxnSocketNIO.doTransport(ClientCnxnSocketNIO.java:366) > ~[zookeeper-3.4.6.jar:3.4.6-1569965] > at org.apache.zookeeper.ClientCnxn$SendThread.run(ClientCnxn.java:1081) > [zookeeper-3.4.6.jar:3.4.6-1569965] > {panel} > This is imho. caused by the following server error: > {panel:title=server > error|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1|bgColor=#FFFFCE} > Illegal character 0x0 in state=START for buffer > HeapByteBuffer@5cc6fe87[p=1,​l=49,​c=8192,​r=48]={\x00<<<\x00\x00-\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00...\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00>>>charset=UTF-8\r\nCo...\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00} > {panel} > Using http interface for sql via curl works however: > {code} > bin/solr start -cloud > bin/solr create -c test > curl -X POST -H 'Content-Type: application/json' > 'http://localhost:8983/solr/test/update/json/docs' --data-binary ' > { > "id": "1", > "title": "Doc 1" > }' > curl 'http://localhost:8983/solr/test/update?commit=true' > curl --data-urlencode 'stmt=SELECT count(*) FROM test' > http://localhost:8983/solr/test/sql?aggregationMode=facet > {code} > This is the code, that fails: > {code} > Connection con = > DriverManager.getConnection("jdbc:solr://localhost:8983?collection=test&aggregationMode=map_reduce&numWorkers=2"); > {code} > taken from: > https://cwiki.apache.org/confluence/display/solr/Parallel+SQL+Interface > Same error also occurs in 6.1.0-68 developer snapshot. > Background: I'm trying to write a solr sql connector for Jedox BI Suite, > which should allow for better integration of solr into BI processes. Any > advice / help appreciated. -- This message was sent by Atlassian JIRA (v6.3.4#6332) --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org