Recentely I updated Ignite version from 1.5.8 to 1.6.0 and found some
queries failed with the following information.
It never happened in Ignite version 1.5.8.
Could anyone help me to confirm it?
[14:04:45,486][SEVERE][pub-#14%null%][GridMapQueryExecutor] Failed to
execute local query: GridQueryRequest [reqId=1013355, pageSize=1024,
space=eqtLnkRlCache, qrys=[GridCacheSqlQuery [qry=SELECT
E.LINKID __C0,
E.LINKNAME __C1
FROM "eqtLnkRlCache".EQTLINKRELATED E
WHERE (E.EQTEMSNAME = '218.5.204.111-1-0-3.1-8') AND ((E.LINKTYPE = 3) AND
(E.REGIONID = 350600)), params=[], paramIdxs=[], paramsSize=0,
cols={__C0=GridSqlType [type=13, scale=0, precision=2147483647,
displaySize=2147483647, sql=VARCHAR], __C1=GridSqlType [type=13, scale=0,
precision=2147483647, displaySize=2147483647, sql=VARCHAR]}, alias=null]],
topVer=AffinityTopologyVersion [topVer=24, minorTopVer=0], extraSpaces=null,
parts=null]
class org.apache.ignite.IgniteCheckedException: Failed to execute SQL query.
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:847)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:870)
at
org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:454)
at
org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:184)
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.send(GridReduceQueryExecutor.java:1065)
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:572)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$2.iterator(IgniteH2Indexing.java:971)
at
org.apache.ignite.internal.processors.cache.QueryCursorImpl.iterator(QueryCursorImpl.java:61)
at
org.apache.ignite.internal.processors.cache.QueryCursorImpl.getAll(QueryCursorImpl.java:73)
at
com.caa.test.ignite.rlam.service.impl.IgnitePublicServiceImpl.queryBySqlFieldCommon(IgnitePublicServiceImpl.java:222)
at
com.caa.test.ignite.rlam.service.impl.IgnitePublicServiceImpl.queryBySqlFieldCommon(IgnitePublicServiceImpl.java:243)
at
com.caa.test.ignite.rlam.service.impl.TopoRelatedServiceImpl.findCableLinkInfo2(TopoRelatedServiceImpl.java:356)
at
com.caa.test.ignite.rlam.service.impl.TopoRelatedServiceImpl.addCableLink(TopoRelatedServiceImpl.java:282)
at
com.caa.test.ignite.rlam.service.impl.TopoRelatedServiceImpl.fullTopoRelatedInfo(TopoRelatedServiceImpl.java:92)
at
com.caa.test.ignite.rlam.compute.TopoRelatedRunnable.doLoadOrgAlarmInfo(TopoRelatedRunnable.java:58)
at
com.caa.test.ignite.rlam.compute.TopoRelatedRunnable.run(TopoRelatedRunnable.java:47)
at
org.apache.ignite.internal.processors.closure.GridClosureProcessor$C4V2.execute(GridClosureProcessor.java:2206)
at
org.apache.ignite.internal.processors.job.GridJobWorker$2.call(GridJobWorker.java:509)
at
org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6459)
at
org.apache.ignite.internal.processors.job.GridJobWorker.execute0(GridJobWorker.java:503)
at
org.apache.ignite.internal.processors.job.GridJobWorker.body(GridJobWorker.java:456)
at
org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.h2.jdbc.JdbcSQLException: General error:
"java.lang.ArrayIndexOutOfBoundsException"; SQL statement:
SELECT
E.LINKID __C0,
E.LINKNAME __C1
FROM "eqtLnkRlCache".EQTLINKRELATED E
WHERE (E.EQTEMSNAME = '218.5.204.111-1-0-3.1-8') AND ((E.LINKTYPE = 3) AND
(E.REGIONID = 350600)) [50000-175]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
at org.h2.message.DbException.get(DbException.java:161)
at org.h2.message.DbException.convert(DbException.java:284)
at org.h2.command.Command.executeQuery(Command.java:208)
at
org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:106)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:844)
... 24 more
Caused by: java.lang.ArrayIndexOutOfBoundsException
--
View this message in context:
http://apache-ignite-users.70518.x6.nabble.com/ArrayIndexOutOfBoundsException-happened-when-doing-qurey-in-version-1-6-0-tp6245.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
