Description
Windows jenkins builds frequently - but not always - fail on TestSQLHandler @ L236
In cases where a windows jenkins build finds a failing seed for TestSQLHandler, and the same jenkins build attempts to reproduce using that seed, it reliably encounters a different failure earlier in the test (related to docValues being missing from a sort field).
These seeds do not fail for me when attempted on a Linux machine, and my own attempts @ beasting on linux hasn't turned up any similar failures.
Here's an example from jenkins - the exact same pattern has occured in other windows jenkins builds on other branches at the exact same asserts..
https://jenkins.thetaphi.de/view/Lucene-Solr/job/Lucene-Solr-8.0-Windows/57/
Using Java: 32bit/jdk1.8.0_172 -server -XX:+UseConcMarkSweepGC
...
Checking out Revision 0376bc0052a53480ecb2edea7dfe58298bda5deb (refs/remotes/origin/branch_8_0)
...
[junit4] 2> NOTE: reproduce with: ant test -Dtestcase=TestSQLHandler -Dtests.method=doTest -Dtests.seed=EEE2628F22F5C82A -Dtests.slow=true -Dtests.locale=id -Dtests.timezone=BST -Dtests.asserts=true -Dtests.file.encoding=ISO-8859-1
[junit4] FAILURE 23.3s J0 | TestSQLHandler.doTest <<<
[junit4] > Throwable #1: java.lang.AssertionError
[junit4] > at __randomizedtesting.SeedInfo.seed([EEE2628F22F5C82A:49A6DA2B4F4EDB93]:0)
[junit4] > at org.apache.solr.handler.TestSQLHandler.testBasicSelect(TestSQLHandler.java:236)
[junit4] > at org.apache.solr.handler.TestSQLHandler.doTest(TestSQLHandler.java:93)
[junit4] > at org.apache.solr.BaseDistributedSearchTestCase$ShardsRepeatRule$ShardsFixedStatement.callStatement(BaseDistributedSearchTestCase.java:1082)
[junit4] > at org.apache.solr.BaseDistributedSearchTestCase$ShardsRepeatRule$ShardsStatement.evaluate(BaseDistributedSearchTestCase.java:1054)
[junit4] > at java.lang.Thread.run(Thread.java:748)
...
[junit4] 2> NOTE: reproduce with: ant test -Dtestcase=TestSQLHandler -Dtests.method=doTest -Dtests.seed=EEE2628F22F5C82A -Dtests.slow=true -Dtests.badapples=true -Dtests.locale=id -Dtests.timezone=BST -Dtests.asserts=true -Dtests.file.encoding=ISO-8859-1
[junit4] ERROR 20.8s J0 | TestSQLHandler.doTest <<<
[junit4] > Throwable #1: java.io.IOException: --> http://127.0.0.1:61309/collection1_shard2_replica_n1: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:61309/collection1_shard2_replica_n1/:id{type=string,properties=indexed,stored,sortMissingLast,uninvertible} must have DocValues to use this feature.
[junit4] > at __randomizedtesting.SeedInfo.seed([EEE2628F22F5C82A:49A6DA2B4F4EDB93]: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:2617)
[junit4] > at org.apache.solr.handler.TestSQLHandler.testBasicSelect(TestSQLHandler.java:145)
[junit4] > at org.apache.solr.handler.TestSQLHandler.doTest(TestSQLHandler.java:93)
[junit4] > at org.apache.solr.BaseDistributedSearchTestCase$ShardsRepeatRule$ShardsFixedStatement.callStatement(BaseDistributedSearchTestCase.java:1082)
[junit4] > at org.apache.solr.BaseDistributedSearchTestCase$ShardsRepeatRule$ShardsStatement.evaluate(BaseDistributedSearchTestCase.java:1054)
[junit4] > at java.lang.Thread.run(Thread.java:748)
...
[junit4] 2> NOTE: reproduce with: ant test -Dtestcase=TestSQLHandler -Dtests.method=doTest -Dtests.seed=EEE2628F22F5C82A -Dtests.slow=true -Dtests.badapples=true -Dtests.locale=id -Dtests.timezone=BST -Dtests.asserts=true -Dtests.file.encoding=ISO-8859-1
[junit4] ERROR 20.6s J1 | TestSQLHandler.doTest <<<
[junit4] > Throwable #1: java.io.IOException: --> http://127.0.0.1:61322/collection1_shard1_replica_n1: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:61303/collection1_shard2_replica_n5/:id{type=string,properties=indexed,stored,sortMissingLast,uninvertible} must have DocValues to use this feature.
[junit4] > at __randomizedtesting.SeedInfo.seed([EEE2628F22F5C82A:49A6DA2B4F4EDB93]: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:2617)
[junit4] > at org.apache.solr.handler.TestSQLHandler.testBasicSelect(TestSQLHandler.java:145)
[junit4] > at org.apache.solr.handler.TestSQLHandler.doTest(TestSQLHandler.java:93)
[junit4] > at org.apache.solr.BaseDistributedSearchTestCase$ShardsRepeatRule$ShardsFixedStatement.callStatement(BaseDistributedSearchTestCase.java:1082)
[junit4] > at org.apache.solr.BaseDistributedSearchTestCase$ShardsRepeatRule$ShardsStatement.evaluate(BaseDistributedSearchTestCase.java:1054)
[junit4] > at java.lang.Thread.run(Thread.java:748)
...
Attachments
Issue Links
- relates to
-
SOLR-13040 Harden TestSQLHandler.
-
- Closed
-