[ci] org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT

[andyb-elastic]

https://elasticsearch-ci.elastic.co/job/elastic+elasticsearch+6.5+multijob-unix-compatibility/os=sles/14/console

build-14.txt.zip

./gradlew :x-pack:qa:sql:no-security:integTestRunner -Dtests.seed=71A16B3FA5A59996 -Dtests.class=org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT  -Dtests.security.manager=true -Dtests.locale=he-IL -Dtests.timezone=Etc/GMT0 -Dcompiler.java=11 -Druntime.java=8

Cases that failed in CI

FAILURE 0.07s | JdbcCsvSpecIT.test {nested.testSelectNestedFieldFirst} <<< FAILURES!    
   > Throwable #1: java.lang.AssertionError: test_emp should have no search contexts expected:<0> but was:<1>                                                                       >    at __randomizedtesting.SeedInfo.seed([71A16B3FA5A59996:F9F554E50B59F46E]:0)     
   >    at org.elasticsearch.xpack.qa.sql.rest.RestSqlTestCase.assertNoSearchContexts(RestSqlTestCase.java:697)                                                                  
   >    at org.elasticsearch.xpack.qa.sql.jdbc.JdbcIntegrationTestCase.checkSearchContent(JdbcIntegrationTestCase.java:40)                                                       
   >    at java.lang.Thread.run(Thread.java:748)     

org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT test {agg.testAggregateWithCastNumericToString}
org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT test {agg.testKurtosisAndSkewnessNoGroup}
org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT test {command.testShowTablesMultiLike}
org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT test {datetime.testConstantDayOfWeek}
org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT test {datetime.testConstantMinuteOfHour}
org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT test {datetime.testConstantMonthOfYear}
org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT test {functions.testCheckColumnNameWithComplexNestedArithmeticFunctionCallsOnTableColumn2}
org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT test {math.testTruncateWithGroupByAndOrderBy}
org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT test {nested.testSelectNestedFieldFirst}
org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT test {nulls.testNullDiv}

More cases failed when I reproduced this

Tests with failures (first 25 out of 47):                                                                                                                                        
  - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {nested.testSelectNestedFieldFirst}                                                                             
  - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {functions.testCheckColumnNameWithComplexNestedArithmeticFunctionCallsOnTableColumn2}                           
  - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {agg.testAggregateWithCastNumericToString}                                                                      
  - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {datetime.testConstantMinuteOfHour}                                                                             
  - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {agg.testKurtosisAndSkewnessNoGroup}                                                                            
  - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {datetime.testConstantMonthOfYear}                                                                              
  - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {datetime.testConstantDayOfWeek}                                                                                
  - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {command.testShowTablesMultiLike}                                                                               
  - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {math.testTruncateWithGroupByAndOrderBy}                                                                        
  - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {nulls.testNullDiv}                                                                                             
  - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {datetime.testConstantSecondOfMinute}                                                                           
  - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {command.testShowTables}                                                                                        
  - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {nested.testFilterPerNestedWithOrderByTopLevel}                                                                 
  - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {math.testTruncateWithAsciiHavingAndOrderBy}                                                                    
  - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {math.testGroupByAndOrderByTruncateWithPositiveParameter}                                                       
  - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {functions.testOctetLengthGroupByAndOrderBy}                                                                    
  - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {agg.testSinglePercentileWithComma}                                                                             
  - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {command.testShowFunctionsWithExactMatch}                                                                         - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {datetime.testDateTimeDayOfWeek}                                                                                
  - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {agg.testSinglePercentileWithoutComma}                                                                            - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {nested.testFilterPerNestedWithOrderByNestedWithAlias}                                                            - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {math.testTruncateWithHavingAndGroupBy}                                                                         
  - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {command.testDescribeMultiLike}                                                                                 
  - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {functions.testSelectInsertWithLcaseAndLengthWithOrderBy}                                                       
  - org.elasticsearch.xpack.qa.sql.nosecurity.JdbcCsvSpecIT.test {functions.testUpperCasingTheSecondLetterFromTheRightFromFirstName}

[elasticmachine]

Pinging @elastic/es-search-aggs

[javanna]

Another occurrence: https://elasticsearch-ci.elastic.co/job/elastic+elasticsearch+master+g1gc/62

[astefan]

master (7.0.0): eaf010c
6.6.0: f270e27
6.5.1: 03872f4