[CI] JdbcSqlSpecIT fails because of unknown NamedWriteable Processor

[elasticmachine]

Original comment by @tlrx:

The test JdbcSqlSpecIT failed today on CI on master branch:
LINK REDACTED

It reproduces locally:

./gradlew :x-pack-elasticsearch:qa:sql:security:no-ssl:integTestRunner -Dtests.seed=C56C85CB596BD3AA -Dtests.class=org.elasticsearch.xpack.qa.sql.security.JdbcSqlSpecIT -Dtests.method="test {math.testMathATan2}" -Dtests.security.manager=true -Dtests.locale=sq -Dtests.timezone=Indian/Mayotte

Many tests methods failed but they seem to have the same original root cause:

Throwable LINK REDACTED: java.sql.SQLException: Server encountered an error [Unexpected failure decoding cursor]. [SqlIllegalArgumentException[Unexpected failure decoding cursor]; nested: IllegalArgumentException[Unknown NamedWriteable [org.elasticsearch.xpack.sql.expression.function.scalar.processor.runtime.Processor][mb]];
10:56:30    > 	at org.elasticsearch.xpack.sql.session.Cursors.decodeFromString(Cursors.java:108)
10:56:30    > 	at org.elasticsearch.xpack.sql.plugin.TransportSqlQueryAction.operation(TransportSqlQueryAction.java:79)
10:56:30    > 	at org.elasticsearch.xpack.sql.plugin.TransportSqlQueryAction.doExecute(TransportSqlQueryAction.java:63)
10:56:30    > 	at org.elasticsearch.xpack.sql.plugin.TransportSqlQueryAction.doExecute(TransportSqlQueryAction.java:43)

cc @elastic/es-sql

[elasticmachine]

Original comment by @nik9000:

Looks like a thing for @costin that probably came from the switch to composite aggs.

[elasticmachine]

Original comment by @costin:

It's from the new math functions. The question is how I can fix it? The code is frozen so it will have to wait until after the move, right?

[elasticmachine]

Original comment by @nik9000:

It's from the new math functions. The question is how I can fix it? The code is frozen so it will have to wait until after the move, right?

You can open a PR but then you wait, yeah.

[mayya-sharipova]

More recent failures from today:

https://elasticsearch-ci.elastic.co/job/elastic+elasticsearch+6.3+periodic/5/console

[martijnvg]

Other failures:

• https://elasticsearch-ci.elastic.co/job/elastic+elasticsearch+master+multijob-unix-compatibility/os=fedora/2374/consoleFull
• https://elasticsearch-ci.elastic.co/job/elastic+elasticsearch+6.x+intake/1611/consoleText

JdbcSqlSpecIT.test {math.testMathPower} <<< FAILURES!
   > Throwable #1: java.sql.SQLException: Server encountered an error [Unexpected failure decoding cursor]. [SqlIllegalArgumentException[Unexpected failure decoding cursor]; nested: IllegalArgumentException[Unknown NamedWriteable [org.elasticsearch.xpack.sql.expression.function.scalar.processor.runtime.Processor][mb]];
   > 	at org.elasticsearch.xpack.sql.session.Cursors.decodeFromString(Cursors.java:96)
   > 	at org.elasticsearch.xpack.sql.plugin.TransportSqlQueryAction.operation(TransportSqlQueryAction.java:67)
   > 	at org.elasticsearch.xpack.sql.plugin.TransportSqlQueryAction.doExecute(TransportSqlQueryAction.java:51)
   > 	at org.elasticsearch.xpack.sql.plugin.TransportSqlQueryAction.doExecute(TransportSqlQueryAction.java:31)
   > 	at org.elasticsearch.action.support.TransportAction.doExecute(TransportAction.java:143)
   > 	at org.elasticsearch.action.support.TransportAction$RequestFilterChain.proceed(TransportAction.java:167)
   > 	at org.elasticsearch.action.support.TransportAction.execute(TransportAction.java:139)
   > 	at org.elasticsearch.action.support.TransportAction.execute(TransportAction.java:81)
   > 	at org.elasticsearch.client.node.NodeClient.executeLocally(NodeClient.java:87)
   > 	at org.elasticsearch.client.node.NodeClient.doExecute(NodeClient.java:76)
   > 	at org.elasticsearch.client.support.AbstractClient.execute(AbstractClient.java:405)
   > 	at org.elasticsearch.xpack.sql.plugin.RestSqlQueryAction.lambda$prepareRequest$0(RestSqlQueryAction.java:79)
   > 	at org.elasticsearch.rest.BaseRestHandler.handleRequest(BaseRestHandler.java:97)
   > 	at org.elasticsearch.rest.RestController.dispatchRequest(RestController.java:239)
   > 	at org.elasticsearch.rest.RestController.tryAllHandlers(RestController.java:335)
   > 	at org.elasticsearch.rest.RestController.dispatchRequest(RestController.java:173)
   > 	at org.elasticsearch.http.netty4.Netty4HttpServerTransport.dispatchRequest(Netty4HttpServerTransport.java:467)
   > 	at org.elasticsearch.http.netty4.Netty4HttpRequestHandler.channelRead0(Netty4HttpRequestHandler.java:137)
   > 	at io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105)
   > 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362)
   > 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348)
   > 	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340)
   > 	at org.elasticsearch.http.netty4.pipelining.HttpPipeliningHandler.channelRead(HttpPipeliningHandler.java:68)
   > 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362)
   > 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348)
   > 	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340)
   > 	at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102)
   > 	at io.netty.handler.codec.MessageToMessageCodec.channelRead(MessageToMessageCodec.java:111)
   > 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362)
   > 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348)
   > 	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340)
   > 	at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102)
   > 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362)
   > 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348)
   > 	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340)
   > 	at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102)
   > 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362)
   > 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348)
   > 	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340)
   > 	at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:310)
   > 	at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:284)
   > 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362)
   > 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348)
   > 	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340)
   > 	at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:286)
   > 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362)
   > 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348)
   > 	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340)
   > 	at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86)
   > 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362)
   > 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348)
   > 	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340)
   > 	at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1359)
   > 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362)
   > 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348)
   > 	at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:935)
   > 	at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:134)
   > 	at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:645)
   > 	at io.netty.channel.nio.NioEventLoop.processSelectedKeysPlain(NioEventLoop.java:545)
   > 	at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:499)
   > 	at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:459)