[ https://issues.apache.org/jira/browse/SOLR-9167?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15346307#comment-15346307 ]
Joel Bernstein commented on SOLR-9167: -------------------------------------- Another round of the SQL/JDBC work will be coming along over the next couple of releases. We can try to find ways to make this simpler and possibly support a non-cloud mode. > 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