[
https://issues.apache.org/jira/browse/SOLR-9167?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15346304#comment-15346304
]
Joel Bernstein commented on SOLR-9167:
--------------------------------------
It's in the documentation here
https://cwiki.apache.org/confluence/display/solr/Parallel+SQL+Interface#ParallelSQLInterface-JDBCDriver.
But agreed that it could be called out with more emphasis.
> 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: [email protected]
For additional commands, e-mail: [email protected]
