[SOLR-9167] Unable to connect to solr via solrj jdbc driver

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Not A Problem
• Affects Version/s: 6.0
• Component/s: SolrCloud, SolrJ

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

• Assignee: Unassigned
• Reporter: Christian Schwarzinger
• Created: 27/May/16 10:05
• Updated: 24/Jun/16 01:52
• Resolved: 23/Jun/16 07:45

Description

Getting the following error, when trying to connect to solr via jdbc driver.

client error

(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]

This is imho. caused by the following server error:

server error

Illegal character 0x0 in state=START for buffer HeapByteBuffer@5cc6fe87p=1,​l=49,​c=8192,​r=48=

Unknown macro: {x00<<<x00x00-x00x00x00x00x00x00x00x00x00x00x00x00x00x00...x00x00x00x00x00x00x00x00x00x00x00x00x00x00x00>>>charset=UTF-8rnCo...x00x00x00x00x00x00x00x00x00x00x00x00x00x00x00}

Using http interface for sql via curl works however:

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

This is the code, that fails:

Connection con = DriverManager.getConnection("jdbc:solr://localhost:8983?collection=test&aggregationMode=map_reduce&numWorkers=2");

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.