Uploaded image for project: 'Solr'
  1. Solr
  2. SOLR-13294

TestSQLHandler failures on windows jenkins machines

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Resolved
    • Affects Version/s: None
    • Fix Version/s: 7.7.1, 8.0
    • Component/s: None
    • Labels:
      None

      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

            Activity

              People

              • Assignee:
                jbernste Joel Bernstein
                Reporter:
                hossman Chris M. Hostetter
              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: