You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Mikhail Khludnev (JIRA)" <ji...@apache.org> on 2019/03/11 08:17:00 UTC

[jira] [Commented] (SOLR-13040) Harden TestSQLHandler.

    [ https://issues.apache.org/jira/browse/SOLR-13040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16789277#comment-16789277 ] 

Mikhail Khludnev commented on SOLR-13040:
-----------------------------------------

https://jenkins.thetaphi.de/job/Lucene-Solr-master-Windows/7765/console
{quote}

   [junit4]   2> 101049 ERROR (qtp1507774207-4585) [n:127.0.0.1:60514_p_g c:collection1 s:shard2 r:core_node8 x:collection1_shard2_replica_n6] o.a.s.h.e.ExportWriter java.io.IOException: id{type=string,properties=indexed,stored,sortMissingLast,uninvertible} must have DocValues to use this feature.
   [junit4]   2> 	at org.apache.solr.handler.export.ExportWriter.getFieldWriters(ExportWriter.java:333)
   [junit4]   2> 	at org.apache.solr.handler.export.ExportWriter.write(ExportWriter.java:213)
   [junit4]   2> 	at org.apache.solr.core.SolrCore$4.write(SolrCore.java:2713)
   [junit4]   2> 	at org.apache.solr.response.QueryResponseWriterUtil.writeQueryResponse(QueryResponseWriterUtil.java:49)
   [junit4]   2> 	at org.apache.solr.servlet.HttpSolrCall.writeResponse(HttpSolrCall.java:789)

   [junit4]   2> 101059 ERROR (qtp508851506-4535) [n:127.0.0.1:60461_p_g c:collection1 s:shard2 r:core_node4 x:collection1_shard2_replica_n2] o.a.s.c.s.i.s.ExceptionStream java.io.IOException: Failed to execute sqlQuery 'select id, field_i, str_s, field_i_p, field_f_p, field_d_p, field_l_p from collection1 where (text='(XXXX)' OR text='XXXX') AND text='XXXX' order by field_i desc' against JDBC connection 'jdbc:calcitesolr:'.
   [junit4]   2> Error while executing SQL "select id, field_i, str_s, field_i_p, field_f_p, field_d_p, field_l_p from collection1 where (text='(XXXX)' OR text='XXXX') AND text='XXXX' order by field_i desc": java.io.IOException: java.util.concurrent.ExecutionException: java.io.IOException: --> http://127.0.0.1:60514/p_g/collection1_shard2_replica_n6/:id{type=string,properties=indexed,stored,sortMissingLast,uninvertible} must have DocValues to use this feature.
   [junit4]   2> 	at org.apache.solr.client.solrj.io.stream.JDBCStream.open(JDBCStream.java:271)
   [junit4]   2> 	at org.apache.solr.client.solrj.io.stream.ExceptionStream.open(ExceptionStream.java:54)
   [junit4]   2> 	at org.apache.solr.handler.StreamHandler$TimerStream.open(StreamHandler.java:394)
   [junit4]   2> 	at org.apache.solr.client.solrj.io.stream.TupleStream.writeMap(TupleStream.java:78)
   [junit4]   2> 	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)
   [junit4]   2> 	at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)
   [junit4]   2> 	at java.base/java.lang.Thread.run(Thread.java:844)
   [junit4]   2> Caused by: java.sql.SQLException: Error while executing SQL "select id, field_i, str_s, field_i_p, field_f_p, field_d_p, field_l_p from collection1 where (text='(XXXX)' OR text='XXXX') AND text='XXXX' order by field_i desc": java.io.IOException: java.util.concurrent.ExecutionException: java.io.IOException: --> http://127.0.0.1:60514/p_g/collection1_shard2_replica_n6/:id{type=string,properties=indexed,stored,sortMissingLast,uninvertible} must have DocValues to use this feature.
   [junit4]   2> 	at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
   [junit4]   2> 	at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
   [junit4]   2> 	at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:163)
   [junit4]   2> 	at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:227)
   [junit4]   2> 	at org.apache.solr.client.solrj.io.stream.JDBCStream.open(JDBCStream.java:269)
   [junit4]   2> 	... 40 more
   [junit4]   2> Caused by: java.lang.RuntimeException: java.io.IOException: java.util.concurrent.ExecutionException: java.io.IOException: --> http://127.0.0.1:60514/p_g/collection1_shard2_replica_n6/:id{type=string,properties=indexed,stored,sortMissingLast,uninvertible} must have DocValues to use this feature.
   [junit4]   2> 	at org.apache.solr.handler.sql.SolrEnumerator.<init>(SolrEnumerator.java:51)
   [junit4]   2> 	at org.apache.solr.handler.sql.SolrTable$1.enumerator(SolrTable.java:171)
   [junit4]   2> 	at org.apache.calcite.linq4j.AbstractEnumerable.iterator(AbstractEnumerable.java:33)
   [junit4]   2> 	at org.apache.calcite.avatica.MetaImpl.createCursor(MetaImpl.java:90)
   [junit4]   2> 	at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:156)
   [junit4]   2> 	... 42 more
   [junit4]   2> Caused by: java.io.IOException: java.util.concurrent.ExecutionException: java.io.IOException: --> http://127.0.0.1:60514/p_g/collection1_shard2_replica_n6/:id{type=string,properties=indexed,stored,sortMissingLast,uninvertible} must have DocValues to use this feature.
   [junit4]   2> 	at org.apache.solr.client.solrj.io.stream.CloudSolrStream.openStreams(CloudSolrStream.java:411)
   [junit4]   2> 	at org.apache.solr.client.solrj.io.stream.CloudSolrStream.open(CloudSolrStream.java:279)
   [junit4]   2> 	at org.apache.solr.handler.sql.SolrEnumerator.<init>(SolrEnumerator.java:49)
   [junit4]   2> 	... 52 more
   [junit4]   2> Caused by: java.util.concurrent.ExecutionException: java.io.IOException: --> http://127.0.0.1:60514/p_g/collection1_shard2_replica_n6/:id{type=string,properties=indexed,stored,sortMissingLast,uninvertible} must have DocValues to use this feature.
   [junit4]   2> 	at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122)
   [junit4]   2> 	at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191)
   [junit4]   2> 	at org.apache.solr.client.solrj.io.stream.CloudSolrStream.openStreams(CloudSolrStream.java:405)
   [junit4]   2> 	... 54 more
   [junit4]   2> Caused by: java.io.IOException: --> http://127.0.0.1:60514/p_g/collection1_shard2_replica_n6/:id{type=string,properties=indexed,stored,sortMissingLast,uninvertible} must have DocValues to use this feature.
   [junit4]   2> 	at org.apache.solr.client.solrj.io.stream.SolrStream.read(SolrStream.java:215)
   [junit4]   2> 	at org.apache.solr.client.solrj.io.stream.CloudSolrStream$TupleWrapper.next(CloudSolrStream.java:495)
   [junit4]   2> 	at org.apache.solr.client.solrj.io.stream.CloudSolrStream$StreamOpener.call(CloudSolrStream.java:518)
   [junit4]   2> 	at org.apache.solr.client.solrj.io.stream.CloudSolrStream$StreamOpener.call(CloudSolrStream.java:505)
   [junit4]   2> 	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)

   [junit4]   2> 101060 ERROR (qtp1873208813-4554) [n:127.0.0.1:60482_p_g c:collection1 s:shard1 r:core_node3 x:collection1_shard1_replica_n1] o.a.s.h.e.ExportWriter java.io.IOException: id{type=string,properties=indexed,stored,sortMissingLast,uninvertible} must have DocValues to use this feature.
   [junit4]   2> 	at org.apache.solr.handler.export.ExportWriter.getFieldWriters(ExportWriter.java:333)
   [junit4]   2> 	at org.apache.solr.handler.export.ExportWriter.write(ExportWriter.java:213)
   [junit4]   2> 	at org.apache.solr.core.SolrCore$4.write(SolrCore.java:2713)
   [junit4]   2> 	at org.apache.solr.response.QueryResponseWriterUtil.writeQueryResponse(QueryResponseWriterUtil.java:49)
   [junit4]   2> 	at org.apache.solr.servlet.HttpSolrCall.writeResponse(HttpSolrCall.java:789)
   [junit4]   2> 	at org.apache.solr.servlet.HttpSolrCall.call(HttpSolrCall.java:525)

   [junit4]   2> NOTE: reproduce with: ant test  -Dtestcase=TestSQLHandler -Dtests.method=doTest -Dtests.seed=5A25986C48C424BE -Dtests.slow=true -Dtests.badapples=true -Dtests.locale=kok-IN -Dtests.timezone=Europe/Busingen -Dtests.asserts=true -Dtests.file.encoding=US-ASCII
   [junit4] ERROR   14.8s J0 | TestSQLHandler.doTest <<<
   [junit4]    > Throwable #1: java.io.IOException: --> http://127.0.0.1:60461/p_g/collection1_shard2_replica_n2:Failed to execute sqlQuery 'select id, field_i, str_s, field_i_p, field_f_p, field_d_p, field_l_p from collection1 where (text='(XXXX)' OR text='XXXX') AND text='XXXX' order by field_i desc' against JDBC connection 'jdbc:calcitesolr:'.
   [junit4]    > Error while executing SQL "select id, field_i, str_s, field_i_p, field_f_p, field_d_p, field_l_p from collection1 where (text='(XXXX)' OR text='XXXX') AND text='XXXX' order by field_i desc": java.io.IOException: java.util.concurrent.ExecutionException: java.io.IOException: --> http://127.0.0.1:60514/p_g/collection1_shard2_replica_n6/:id{type=string,properties=indexed,stored,sortMissingLast,uninvertible} must have DocValues to use this feature.
   [junit4]    > 	at __randomizedtesting.SeedInfo.seed([5A25986C48C424BE:FD6120C8257F3707]:0)
   [junit4]    > 	at org.apache.solr.client.solrj.io.stream.SolrStream.read(SolrStream.java:215)
   [junit4]    > 	at org.apache.solr.handler.TestSQLHandler.getTuples(TestSQLHandler.java:2517)
{quote}

It's probably easy to fix by providing right field or excluding the edge case. But is it right to have IOException, Shouldn't it be written as SolrException(BAD_REQUEST), presumably providing more reasonable http status?  

> Harden TestSQLHandler.
> ----------------------
>
>                 Key: SOLR-13040
>                 URL: https://issues.apache.org/jira/browse/SOLR-13040
>             Project: Solr
>          Issue Type: Sub-task
>      Security Level: Public(Default Security Level. Issues are Public) 
>            Reporter: Mark Miller
>            Assignee: Joel Bernstein
>            Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org