search

elastic / elasticsearch

Free and Open Source, Distributed, RESTful Search Engine
https://www.elastic.co/products/elasticsearch
Other
69.62k stars 24.64k forks source link

[CI] ConsistentFunctionArgHandlingIT failing on 7.17 / windows #105857

Closed mosche closed 6 months ago

mosche commented 6 months ago

elasticsearch / periodic / platform-support / 7.17 / windows-2019 / checkPart2 / platform-support-windows Test failures:

ConsistentFunctionArgHandlingIT » test {p0=INSERT(foobar, 2, 3, replacement)}
ConsistentFunctionArgHandlingIT » test {p0=LOCATE(ob, foobar, 1)}
ConsistentFunctionArgHandlingIT » test {p0=SUBSTRING(foobar, 1, 2)}
ConsistentFunctionArgHandlingIT » test {p0=REPLACE(foo, o, bar)}

Failing as of 2024-02-23: https://es-delivery-stats.elastic.dev/app/r/s/nWprU

Build scan: https://gradle-enterprise.elastic.co/s/2ysycouffh47o/tests/:x-pack:plugin:sql:qa:server:single-node:javaRestTest/org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT/test%20%7Bp0=INSERT(foobar,%202,%203,%20replacement)%7D

Reproduction line:

gradlew ':x-pack:plugin:sql:qa:server:single-node:javaRestTest' --tests "org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT.test {p0=INSERT(foobar, 2, 3, replacement)}" -Dtests.seed=2C642E1AB038385E -Dtests.locale=zh-Hans-SG -Dtests.timezone=Europe/Uzhgorod -Druntime.java=21

Applicable branches: 7.17

Reproduces locally?: No

Failure history: Failure dashboard for org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT#test {p0=INSERT(foobar, 2, 3, replacement)}&_a=(controlGroupInput:(chainingSystem:HIERARCHICAL,controlStyle:twoLine,ignoreParentSettings:(ignoreFilters:!f,ignoreQuery:!f,ignoreTimerange:!f,ignoreValidations:!t),panels:('0c0c9cb8-ccd2-45c6-9b13-96bac4abc542':(explicitInput:(dataViewId:fbbdc689-be23-4b3d-8057-aa402e9ed0c5,enhancements:(),fieldName:task.keyword,grow:!t,id:'0c0c9cb8-ccd2-45c6-9b13-96bac4abc542',searchTechnique:wildcard,selectedOptions:!(),singleSelect:!t,title:'Gradle%20Task',width:medium),grow:!t,order:0,type:optionsListControl,width:small),'144933da-5c1b-4257-a969-7f43455a7901':(explicitInput:(dataViewId:fbbdc689-be23-4b3d-8057-aa402e9ed0c5,enhancements:(),fieldName:name.keyword,grow:!t,id:'144933da-5c1b-4257-a969-7f43455a7901',searchTechnique:wildcard,selectedOptions:!('test%20%7Bp0%3DINSERT(foobar,%202,%203,%20replacement)%7D'),title:Test,width:medium),grow:!t,order:2,type:optionsListControl,width:medium),'4e6ad9d6-6fdc-4fcc-bf1a-aa6ca79e0850':(explicitInput:(dataViewId:fbbdc689-be23-4b3d-8057-aa402e9ed0c5,enhancements:(),fieldName:className.keyword,grow:!t,id:'4e6ad9d6-6fdc-4fcc-bf1a-aa6ca79e0850',searchTechnique:wildcard,selectedOptions:!('org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT'),title:Suite,width:medium),grow:!t,order:1,type:optionsListControl,width:medium)))))

Failure excerpt:

java.sql.SQLException: Server sent bad type [x_content_parse_exception]. Original type was [[-1:160] [sql/query] failed to parse field [time_zone]]. [org.elasticsearch.xcontent.XContentParseException: [-1:160] [sql/query] failed to parse field [time_zone]
    at org.elasticsearch.xcontent.ObjectParser.throwFailedToParse(ObjectParser.java:609)
    at org.elasticsearch.xcontent.ObjectParser.parseValue(ObjectParser.java:604)
    at org.elasticsearch.xcontent.ObjectParser.parseSub(ObjectParser.java:652)
    at org.elasticsearch.xcontent.ObjectParser.parse(ObjectParser.java:320)
    at org.elasticsearch.xcontent.ObjectParser.parse(ObjectParser.java:260)
    at org.elasticsearch.xcontent.ObjectParser.apply(ObjectParser.java:393)
    at org.elasticsearch.xpack.sql.action.SqlQueryRequest.fromXContent(SqlQueryRequest.java:335)
    at org.elasticsearch.xpack.sql.plugin.RestSqlQueryAction.prepareRequest(RestSqlQueryAction.java:51)
    at org.elasticsearch.rest.BaseRestHandler.handleRequest(BaseRestHandler.java:86)
    at org.elasticsearch.rest.RestController.dispatchRequest(RestController.java:340)
    at org.elasticsearch.rest.RestController.tryAllHandlers(RestController.java:405)
    at org.elasticsearch.rest.RestController.dispatchRequest(RestController.java:252)
    at org.elasticsearch.http.AbstractHttpServerTransport.dispatchRequest(AbstractHttpServerTransport.java:384)
    at org.elasticsearch.http.AbstractHttpServerTransport.handleIncomingRequest(AbstractHttpServerTransport.java:478)
    at org.elasticsearch.http.AbstractHttpServerTransport.incomingRequest(AbstractHttpServerTransport.java:358)
    at org.elasticsearch.http.netty4.Netty4HttpRequestHandler.channelRead0(Netty4HttpRequestHandler.java:35)
    at org.elasticsearch.http.netty4.Netty4HttpRequestHandler.channelRead0(Netty4HttpRequestHandler.java:19)
    at io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:99)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
    at org.elasticsearch.http.netty4.Netty4HttpPipeliningHandler.channelRead(Netty4HttpPipeliningHandler.java:48)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:442)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
    at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
    at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103)
    at io.netty.handler.codec.MessageToMessageCodec.channelRead(MessageToMessageCodec.java:111)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:442)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
    at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
    at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
    at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:346)
    at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:318)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
    at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:286)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:442)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
    at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
    at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:440)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
    at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919)
    at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:166)
    at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:788)
    at io.netty.channel.nio.NioEventLoop.processSelectedKeysPlain(NioEventLoop.java:689)
    at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:652)
    at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:562)
    at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:997)
    at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
    at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: java.time.zone.ZoneRulesException: Unknown time-zone ID: America/Ciudad_Juarez
    at java.base/java.time.zone.ZoneRulesProvider.getProvider(ZoneRulesProvider.java:280)
    at java.base/java.time.zone.ZoneRulesProvider.getRules(ZoneRulesProvider.java:235)
    at java.base/java.time.ZoneRegion.ofId(ZoneRegion.java:121)
    at java.base/java.time.ZoneId.of(ZoneId.java:410)
    at java.base/java.time.ZoneId.of(ZoneId.java:358)
    at org.elasticsearch.xpack.sql.action.AbstractSqlQueryRequest.lambda$objectParser$1(AbstractSqlQueryRequest.java:125)
    at org.elasticsearch.xcontent.ObjectParser.lambda$declareField$8(ObjectParser.java:424)
    at org.elasticsearch.xcontent.ObjectParser.parseValue(ObjectParser.java:602)
    ... 65 more
]

  at __randomizedtesting.SeedInfo.seed([2C642E1AB038385E:A43011C01EC455A6]:0)
  at org.elasticsearch.xpack.sql.client.JreHttpUrlConnection.parserError(JreHttpUrlConnection.java:225)
  at org.elasticsearch.xpack.sql.client.JreHttpUrlConnection.request(JreHttpUrlConnection.java:177)
  at org.elasticsearch.xpack.sql.client.HttpClient.lambda$post$1(HttpClient.java:126)
  at org.elasticsearch.xpack.sql.client.JreHttpUrlConnection.http(JreHttpUrlConnection.java:75)
  at org.elasticsearch.xpack.sql.client.HttpClient.lambda$post$2(HttpClient.java:122)
  at java.security.AccessController.doPrivileged(AccessController.java:319)
  at org.elasticsearch.xpack.sql.client.HttpClient.post(HttpClient.java:121)
  at org.elasticsearch.xpack.sql.client.HttpClient.query(HttpClient.java:90)
  at org.elasticsearch.xpack.sql.jdbc.JdbcHttpClient.query(JdbcHttpClient.java:80)
  at org.elasticsearch.xpack.sql.jdbc.JdbcStatement.initResultSet(JdbcStatement.java:160)
  at org.elasticsearch.xpack.sql.jdbc.JdbcStatement.execute(JdbcStatement.java:151)
  at org.elasticsearch.xpack.sql.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:41)
  at org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT.lambda$test$5(ConsistentFunctionArgHandlingIT.java:199)
  at org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT.lambda$iterateAllPermutations$9(ConsistentFunctionArgHandlingIT.java:281)
  at org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT.lambda$iterateAllPermutations$9(ConsistentFunctionArgHandlingIT.java:281)
  at org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT.lambda$iterateAllPermutations$9(ConsistentFunctionArgHandlingIT.java:281)
  at org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT.lambda$iterateAllPermutations$9(ConsistentFunctionArgHandlingIT.java:281)
  at org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT.iterateAllPermutations(ConsistentFunctionArgHandlingIT.java:273)
  at org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT.iterateAllPermutations(ConsistentFunctionArgHandlingIT.java:276)
  at org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT.iterateAllPermutations(ConsistentFunctionArgHandlingIT.java:276)
  at org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT.iterateAllPermutations(ConsistentFunctionArgHandlingIT.java:276)
  at org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT.iterateAllPermutations(ConsistentFunctionArgHandlingIT.java:276)
  at org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT.lambda$test$6(ConsistentFunctionArgHandlingIT.java:178)
  at org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT.lambda$iterateAllPermutations$9(ConsistentFunctionArgHandlingIT.java:281)
  at org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT.lambda$iterateAllPermutations$9(ConsistentFunctionArgHandlingIT.java:281)
  at org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT.lambda$iterateAllPermutations$9(ConsistentFunctionArgHandlingIT.java:281)
  at org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT.lambda$iterateAllPermutations$9(ConsistentFunctionArgHandlingIT.java:281)
  at org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT.iterateAllPermutations(ConsistentFunctionArgHandlingIT.java:273)
  at org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT.iterateAllPermutations(ConsistentFunctionArgHandlingIT.java:276)
  at org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT.iterateAllPermutations(ConsistentFunctionArgHandlingIT.java:276)
  at org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT.iterateAllPermutations(ConsistentFunctionArgHandlingIT.java:276)
  at org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT.iterateAllPermutations(ConsistentFunctionArgHandlingIT.java:276)
  at org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT.test(ConsistentFunctionArgHandlingIT.java:170)
  at jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
  at java.lang.reflect.Method.invoke(Method.java:580)
  at com.carrotsearch.randomizedtesting.RandomizedRunner.invoke(RandomizedRunner.java:1758)
  at com.carrotsearch.randomizedtesting.RandomizedRunner$8.evaluate(RandomizedRunner.java:946)
  at com.carrotsearch.randomizedtesting.RandomizedRunner$9.evaluate(RandomizedRunner.java:982)
  at com.carrotsearch.randomizedtesting.RandomizedRunner$10.evaluate(RandomizedRunner.java:996)
  at com.carrotsearch.randomizedtesting.rules.StatementAdapter.evaluate(StatementAdapter.java:36)
  at org.junit.rules.RunRules.evaluate(RunRules.java:20)
  at org.apache.lucene.util.TestRuleSetupTeardownChained$1.evaluate(TestRuleSetupTeardownChained.java:49)
  at org.apache.lucene.util.AbstractBeforeAfterRule$1.evaluate(AbstractBeforeAfterRule.java:45)
  at org.apache.lucene.util.TestRuleThreadAndTestName$1.evaluate(TestRuleThreadAndTestName.java:48)
  at org.apache.lucene.util.TestRuleIgnoreAfterMaxFailures$1.evaluate(TestRuleIgnoreAfterMaxFailures.java:64)
  at org.apache.lucene.util.TestRuleMarkFailure$1.evaluate(TestRuleMarkFailure.java:47)
  at org.junit.rules.RunRules.evaluate(RunRules.java:20)
  at com.carrotsearch.randomizedtesting.rules.StatementAdapter.evaluate(StatementAdapter.java:36)
  at com.carrotsearch.randomizedtesting.ThreadLeakControl$StatementRunner.run(ThreadLeakControl.java:390)
  at com.carrotsearch.randomizedtesting.ThreadLeakControl.forkTimeoutingTask(ThreadLeakControl.java:843)
  at com.carrotsearch.randomizedtesting.ThreadLeakControl$3.evaluate(ThreadLeakControl.java:490)
  at com.carrotsearch.randomizedtesting.RandomizedRunner.runSingleTest(RandomizedRunner.java:955)
  at com.carrotsearch.randomizedtesting.RandomizedRunner$5.evaluate(RandomizedRunner.java:840)
  at com.carrotsearch.randomizedtesting.RandomizedRunner$6.evaluate(RandomizedRunner.java:891)
  at com.carrotsearch.randomizedtesting.RandomizedRunner$7.evaluate(RandomizedRunner.java:902)
  at org.apache.lucene.util.AbstractBeforeAfterRule$1.evaluate(AbstractBeforeAfterRule.java:45)
  at com.carrotsearch.randomizedtesting.rules.StatementAdapter.evaluate(StatementAdapter.java:36)
  at org.apache.lucene.util.TestRuleStoreClassName$1.evaluate(TestRuleStoreClassName.java:41)
  at com.carrotsearch.randomizedtesting.rules.NoShadowingOrOverridesOnMethodsRule$1.evaluate(NoShadowingOrOverridesOnMethodsRule.java:40)
  at com.carrotsearch.randomizedtesting.rules.NoShadowingOrOverridesOnMethodsRule$1.evaluate(NoShadowingOrOverridesOnMethodsRule.java:40)
  at com.carrotsearch.randomizedtesting.rules.StatementAdapter.evaluate(StatementAdapter.java:36)
  at com.carrotsearch.randomizedtesting.rules.StatementAdapter.evaluate(StatementAdapter.java:36)
  at org.apache.lucene.util.TestRuleAssertionsRequired$1.evaluate(TestRuleAssertionsRequired.java:53)
  at org.apache.lucene.util.TestRuleMarkFailure$1.evaluate(TestRuleMarkFailure.java:47)
  at org.apache.lucene.util.TestRuleIgnoreAfterMaxFailures$1.evaluate(TestRuleIgnoreAfterMaxFailures.java:64)
  at org.apache.lucene.util.TestRuleIgnoreTestSuites$1.evaluate(TestRuleIgnoreTestSuites.java:54)
  at org.junit.rules.RunRules.evaluate(RunRules.java:20)
  at com.carrotsearch.randomizedtesting.rules.StatementAdapter.evaluate(StatementAdapter.java:36)
  at com.carrotsearch.randomizedtesting.ThreadLeakControl$StatementRunner.run(ThreadLeakControl.java:390)
  at com.carrotsearch.randomizedtesting.ThreadLeakControl.lambda$forkTimeoutingTask$0(ThreadLeakControl.java:850)
  at java.lang.Thread.run(Thread.java:1583)
mosche commented 6 months ago

Another example: https://gradle-enterprise.elastic.co/s/rgeliqtdi5bh2/tests/task/:x-pack:plugin:sql:qa:server:single-node:javaRestTest/details/org.elasticsearch.xpack.sql.qa.single_node.ConsistentFunctionArgHandlingIT/test%20%7Bp0=INSERT(foobar,%202,%203,%20replacement)%7D?top-execution=1

elasticsearchmachine commented 6 months ago

Pinging @elastic/es-analytical-engine (Team:Analytics)

mosche commented 6 months ago

another one: ConsistentFunctionArgHandlingIT » test {p0=INSERT(foobar, 2, 3, replacement)}

mosche commented 6 months ago

Duplicate of https://github.com/elastic/elasticsearch/issues/105857, same timezone issue over and over again