Hi Taras,
attached the extract from the local node log (which is a Ignite client)
and the remote node log (which is a Ignite server with persistance enabled).
What's really strange is that previous value "IDX_STAGE_308" seems to be
the root cause? This is a value in column UCID but it's not related to
the current search, except that of course the H2 DB must search through
this column. Maybe there is invalid characters in the index from data
rows from a few days ago? Maybe the index is broken? Why would it only
show when this specific query is executed?
Please let me know your thoughts.
Thanks,
Thomas.
Am 29.07.2022 um 12:48 schrieb Taras Ledkov:
Hi,
Could you provide the original exception from the map node?
It must be available at the log files of the map node.
29-07-2022 04:08:37.695 [ 399] ERROR IgniteCachedJobQueue
Error in job cache search(SELECT JQ._val, J.M1, J.M2, J.M3 FROM
"JobQueue".JobQueue AS JQ LEFT JOIN "Jobs".Jobs AS J ON JQ._key=J._key WHERE
JQ.ucid=? AND (JQ.status in (?))) : Failed to execute map query on remote node
[nodeId=a46a2ed4-e54a-4ff6-bc28-d0c89eb8ef5c, errMsg=General error: "class
org.apache.ignite.IgniteCheckedException: Runtime failure on bounds:
[lower=IndexSearchRowImpl
[rowHnd=org.apache.ignite.internal.processors.query.h2.index.QueryIndexRowHandler@12f90758],
upper=IndexSearchRowImpl
[rowHnd=org.apache.ignite.internal.processors.query.h2.index.QueryIndexRowHandler@12f90758]]";
SQL statement:
SELECT
JQ__Z0._VAL __C0_0,
J__Z1.M1 __C0_1,
J__Z1.M2 __C0_2,
J__Z1.M3 __C0_3
FROM "JobQueue".JOBQUEUE JQ__Z0
LEFT OUTER JOIN "Jobs".JOBS J__Z1
ON JQ__Z0._KEY = J__Z1._KEY
WHERE (JQ__Z0.UCID = ?1) AND (JQ__Z0.STATUS = ?2) [50000-197]]
29-07-2022 04:08:37.695 [ 399] WARN CacheTransaction
Transaction(CacheTransaction [thread=399, tx=null]) method had expection:
javax.cache.CacheException: Failed to execute map query on remote node
[nodeId=a46a2ed4-e54a-4ff6-bc28-d0c89eb8ef5c, errMsg=General error: "class
org.apache.ignite.IgniteCheckedException: Runtime failure on bounds:
[lower=IndexSearchRowImpl
[rowHnd=org.apache.ignite.internal.processors.query.h2.index.QueryIndexRowHandler@12f90758],
upper=IndexSearchRowImpl
[rowHnd=org.apache.ignite.internal.processors.query.h2.index.QueryIndexRowHandler@12f90758]]";
SQL statement:
SELECT
JQ__Z0._VAL __C0_0,
J__Z1.M1 __C0_1,
J__Z1.M2 __C0_2,
J__Z1.M3 __C0_3
FROM "JobQueue".JOBQUEUE JQ__Z0
LEFT OUTER JOIN "Jobs".JOBS J__Z1
ON JQ__Z0._KEY = J__Z1._KEY
WHERE (JQ__Z0.UCID = ?1) AND (JQ__Z0.STATUS = ?2) [50000-197]]
de.ks.mf.net.ignite.jobqueue.JobQueueException: javax.cache.CacheException:
Failed to execute map query on remote node
[nodeId=a46a2ed4-e54a-4ff6-bc28-d0c89eb8ef5c, errMsg=General error: "class
org.apache.ignite.IgniteCheckedException: Runtime failure on bounds:
[lower=IndexSearchRowImpl
[rowHnd=org.apache.ignite.internal.processors.query.h2.index.QueryIndexRowHandler@12f90758],
upper=IndexSearchRowImpl
[rowHnd=org.apache.ignite.internal.processors.query.h2.index.QueryIndexRowHandler@12f90758]]";
SQL statement:
SELECT
JQ__Z0._VAL __C0_0,
J__Z1.M1 __C0_1,
J__Z1.M2 __C0_2,
J__Z1.M3 __C0_3
FROM "JobQueue".JOBQUEUE JQ__Z0
LEFT OUTER JOIN "Jobs".JOBS J__Z1
ON JQ__Z0._KEY = J__Z1._KEY
WHERE (JQ__Z0.UCID = ?1) AND (JQ__Z0.STATUS = ?2) [50000-197]]
at
de.ks.mf.net.ignite.jobqueue.IgniteCachedJobQueue.getQueueEntries(IgniteCachedJobQueue.java:412)
~[mediafan.jar:?]
at
de.ks.mf.net.ignite.jobqueue.JobManager$10.execute(JobManager.java:1041)
~[mediafan.jar:?]
at
de.ks.mf.net.ignite.cache.transaction.MediaFanCacheTransaction.start(MediaFanCacheTransaction.java:146)
~[mediafan.jar:?]
at
de.ks.mf.net.ignite.cache.transaction.MediaFanCacheTransaction.startWithoutTransaction(MediaFanCacheTransaction.java:75)
~[mediafan.jar:?]
at
de.ks.mf.net.ignite.jobqueue.JobManager.getQueueEntries(JobManager.java:1036)
~[mediafan.jar:?]
at
de.ks.mf.workflow.auto.vmafscore.extenc.AutoWorkflowVmafScoreExternalEncoder.loadJobTaskHistory(AutoWorkflowVmafScoreExternalEncoder.java:151)
~[mediafan.jar:?]
at
de.ks.mf.workflow.auto.vmafscore.extenc.AutoWorkflowVmafScoreExternalEncoder.setJob(AutoWorkflowVmafScoreExternalEncoder.java:83)
~[mediafan.jar:?]
at
de.ks.mf.net.NetMasterIgnite.createNewMediaSetAutoWorkflow(NetMasterIgnite.java:1639)
~[mediafan.jar:?]
at
de.ks.mf.net.NetMasterIgnite.createNewMediaSet(NetMasterIgnite.java:1548)
~[mediafan.jar:?]
at
de.ks.mf.net.NetMasterIgnite.createNewMediaSet(NetMasterIgnite.java:1533)
~[mediafan.jar:?]
at
de.ks.mf.plugins.builtin.MediaProducerSingleFile.produceMedia(MediaProducerSingleFile.java:168)
~[mediafan.jar:?]
at
de.ks.mf.plugins.external.MediaProducerAutoWorkflow.produceMedia(MediaProducerAutoWorkflow.java:29)
~[mediafan.jar:?]
at
de.ks.mf.net.ignite.jobqueue.JobManager.startMediaFanJob(JobManager.java:385)
~[mediafan.jar:?]
at
de.ks.mf.net.ignite.jobqueue.JobManager.startNextJobOrWait(JobManager.java:292)
~[mediafan.jar:?]
at de.ks.mf.net.ignite.jobqueue.JobManager.run(JobManager.java:801)
~[mediafan.jar:?]
at java.lang.Thread.run(Thread.java:834) ~[?:?]
Caused by: javax.cache.CacheException: Failed to execute map query on remote
node [nodeId=a46a2ed4-e54a-4ff6-bc28-d0c89eb8ef5c, errMsg=General error: "class
org.apache.ignite.IgniteCheckedException: Runtime failure on bounds:
[lower=IndexSearchRowImpl
[rowHnd=org.apache.ignite.internal.processors.query.h2.index.QueryIndexRowHandler@12f90758],
upper=IndexSearchRowImpl
[rowHnd=org.apache.ignite.internal.processors.query.h2.index.QueryIndexRowHandler@12f90758]]";
SQL statement:
SELECT
JQ__Z0._VAL __C0_0,
J__Z1.M1 __C0_1,
J__Z1.M2 __C0_2,
J__Z1.M3 __C0_3
FROM "JobQueue".JOBQUEUE JQ__Z0
LEFT OUTER JOIN "Jobs".JOBS J__Z1
ON JQ__Z0._KEY = J__Z1._KEY
WHERE (JQ__Z0.UCID = ?1) AND (JQ__Z0.STATUS = ?2) [50000-197]]
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.fail(GridReduceQueryExecutor.java:239)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.onFail(GridReduceQueryExecutor.java:218)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.onMessage(IgniteH2Indexing.java:2225)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.lambda$start$23(IgniteH2Indexing.java:2153)
~[mediafan.jar:?]
at
org.apache.ignite.internal.managers.communication.GridIoManager$ArrayListener.onMessage(GridIoManager.java:3482)
~[mediafan.jar:?]
at
org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1909)
~[mediafan.jar:?]
at
org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:1530)
~[mediafan.jar:?]
at
org.apache.ignite.internal.managers.communication.GridIoManager.access$5300(GridIoManager.java:243)
~[mediafan.jar:?]
at
org.apache.ignite.internal.managers.communication.GridIoManager$9.execute(GridIoManager.java:1423)
~[mediafan.jar:?]
at
org.apache.ignite.internal.managers.communication.TraceRunnable.run(TraceRunnable.java:55)
~[mediafan.jar:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
~[?:?]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
~[?:?]
... 1 more
29-07-2022 04:08:21.358 [ 1202] WARN QueryParser
For join two partitioned tables join condition should contain the equality
operation of affinity keys. Left side: JOBQUEUE; right side: JOBS
29-07-2022 04:08:24.435 [ 37277] WARN GridMapQueryExecutor
Failed to execute local query.
org.apache.ignite.internal.processors.query.IgniteSQLException: General error:
"class org.apache.ignite.IgniteCheckedException: Runtime failure on bounds:
[lower=IndexSearchRowImpl
[rowHnd=org.apache.ignite.internal.processors.query.h2.index.QueryIndexRowHandler@12f90758],
upper=IndexSearchRowImpl
[rowHnd=org.apache.ignite.internal.processors.query.h2.index.QueryIndexRowHandler@12f90758]]";
SQL statement:
SELECT
JQ__Z0._VAL __C0_0,
J__Z1.M1 __C0_1,
J__Z1.M2 __C0_2,
J__Z1.M3 __C0_3
FROM "JobQueue".JOBQUEUE JQ__Z0
LEFT OUTER JOIN "Jobs".JOBS J__Z1
ON JQ__Z0._KEY = J__Z1._KEY
WHERE (JQ__Z0.UCID = ?1) AND (JQ__Z0.STATUS = ?2) [50000-197]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:898)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:985)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:471)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:284)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.onMessage(IgniteH2Indexing.java:2219)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.lambda$start$23(IgniteH2Indexing.java:2153)
~[mediafan.jar:?]
at
org.apache.ignite.internal.managers.communication.GridIoManager$ArrayListener.onMessage(GridIoManager.java:3482)
~[mediafan.jar:?]
at
org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1909)
~[mediafan.jar:?]
at
org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:1530)
~[mediafan.jar:?]
at
org.apache.ignite.internal.managers.communication.GridIoManager.access$5300(GridIoManager.java:243)
~[mediafan.jar:?]
at
org.apache.ignite.internal.managers.communication.GridIoManager$9.execute(GridIoManager.java:1423)
~[mediafan.jar:?]
at
org.apache.ignite.internal.managers.communication.TraceRunnable.run(TraceRunnable.java:55)
~[mediafan.jar:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
~[?:?]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
~[?:?]
at java.lang.Thread.run(Thread.java:834) ~[?:?]
Caused by: org.h2.jdbc.JdbcSQLException: General error: "class
org.apache.ignite.IgniteCheckedException: Runtime failure on bounds:
[lower=IndexSearchRowImpl
[rowHnd=org.apache.ignite.internal.processors.query.h2.index.QueryIndexRowHandler@12f90758],
upper=IndexSearchRowImpl
[rowHnd=org.apache.ignite.internal.processors.query.h2.index.QueryIndexRowHandler@12f90758]]";
SQL statement:
SELECT
JQ__Z0._VAL __C0_0,
J__Z1.M1 __C0_1,
J__Z1.M2 __C0_2,
J__Z1.M3 __C0_3
FROM "JobQueue".JOBQUEUE JQ__Z0
LEFT OUTER JOIN "Jobs".JOBS J__Z1
ON JQ__Z0._KEY = J__Z1._KEY
WHERE (JQ__Z0.UCID = ?1) AND (JQ__Z0.STATUS = ?2) [50000-197]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
~[mediafan.jar:?]
at org.h2.message.DbException.get(DbException.java:168)
~[mediafan.jar:?]
at org.h2.message.DbException.convert(DbException.java:307)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.query.h2.database.H2TreeIndex.find(H2TreeIndex.java:216)
~[mediafan.jar:?]
at org.h2.index.BaseIndex.find(BaseIndex.java:130) ~[mediafan.jar:?]
at org.h2.index.IndexCursor.find(IndexCursor.java:176) ~[mediafan.jar:?]
at org.h2.table.TableFilter.next(TableFilter.java:471) ~[mediafan.jar:?]
at
org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1452)
~[mediafan.jar:?]
at org.h2.result.LazyResult.hasNext(LazyResult.java:79)
~[mediafan.jar:?]
at org.h2.result.LazyResult.next(LazyResult.java:59) ~[mediafan.jar:?]
at org.h2.command.dml.Select.queryFlat(Select.java:527)
~[mediafan.jar:?]
at org.h2.command.dml.Select.queryWithoutCache(Select.java:633)
~[mediafan.jar:?]
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
~[mediafan.jar:?]
at org.h2.command.dml.Query.query(Query.java:352) ~[mediafan.jar:?]
at org.h2.command.dml.Query.query(Query.java:333) ~[mediafan.jar:?]
at org.h2.command.CommandContainer.query(CommandContainer.java:114)
~[mediafan.jar:?]
at org.h2.command.Command.executeQuery(Command.java:202)
~[mediafan.jar:?]
at
org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:114)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:888)
~[mediafan.jar:?]
... 14 more
Caused by: org.apache.ignite.IgniteCheckedException: Runtime failure on bounds:
[lower=IndexSearchRowImpl
[rowHnd=org.apache.ignite.internal.processors.query.h2.index.QueryIndexRowHandler@12f90758],
upper=IndexSearchRowImpl
[rowHnd=org.apache.ignite.internal.processors.query.h2.index.QueryIndexRowHandler@12f90758]]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.find(BPlusTree.java:1209)
~[mediafan.jar:?]
at
org.apache.ignite.internal.cache.query.index.sorted.inline.InlineIndexImpl.find(InlineIndexImpl.java:104)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.query.h2.database.H2TreeIndex.find(H2TreeIndex.java:209)
~[mediafan.jar:?]
at org.h2.index.BaseIndex.find(BaseIndex.java:130) ~[mediafan.jar:?]
at org.h2.index.IndexCursor.find(IndexCursor.java:176) ~[mediafan.jar:?]
at org.h2.table.TableFilter.next(TableFilter.java:471) ~[mediafan.jar:?]
at
org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1452)
~[mediafan.jar:?]
at org.h2.result.LazyResult.hasNext(LazyResult.java:79)
~[mediafan.jar:?]
at org.h2.result.LazyResult.next(LazyResult.java:59) ~[mediafan.jar:?]
at org.h2.command.dml.Select.queryFlat(Select.java:527)
~[mediafan.jar:?]
at org.h2.command.dml.Select.queryWithoutCache(Select.java:633)
~[mediafan.jar:?]
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
~[mediafan.jar:?]
at org.h2.command.dml.Query.query(Query.java:352) ~[mediafan.jar:?]
at org.h2.command.dml.Query.query(Query.java:333) ~[mediafan.jar:?]
at org.h2.command.CommandContainer.query(CommandContainer.java:114)
~[mediafan.jar:?]
at org.h2.command.Command.executeQuery(Command.java:202)
~[mediafan.jar:?]
at
org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:114)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:888)
~[mediafan.jar:?]
... 14 more
Caused by: org.apache.ignite.IgniteCheckedException: Rows cannot be compared
at
org.apache.ignite.internal.processors.query.h2.index.H2RowComparator.compareValues(H2RowComparator.java:150)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.query.h2.index.H2RowComparator.compareRow(H2RowComparator.java:115)
~[mediafan.jar:?]
at
org.apache.ignite.internal.cache.query.index.sorted.inline.InlineIndexTree.compareFullRows(InlineIndexTree.java:336)
~[mediafan.jar:?]
at
org.apache.ignite.internal.cache.query.index.sorted.inline.InlineIndexTree.compare(InlineIndexTree.java:316)
~[mediafan.jar:?]
at
org.apache.ignite.internal.cache.query.index.sorted.inline.InlineIndexTree.compare(InlineIndexTree.java:74)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.compare(BPlusTree.java:5553)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.findInsertionPoint(BPlusTree.java:5473)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.access$1100(BPlusTree.java:162)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$Search.run0(BPlusTree.java:369)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$GetPageHandler.run(BPlusTree.java:6089)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$Search.run(BPlusTree.java:349)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$GetPageHandler.run(BPlusTree.java:6075)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.util.PageHandler.readPage(PageHandler.java:174)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.DataStructure.read(DataStructure.java:415)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.read(BPlusTree.java:6276)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.findDown(BPlusTree.java:1542)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.doFind(BPlusTree.java:1509)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.access$7300(BPlusTree.java:162)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$AbstractForwardCursor.find(BPlusTree.java:5746)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.find(BPlusTree.java:1201)
~[mediafan.jar:?]
at
org.apache.ignite.internal.cache.query.index.sorted.inline.InlineIndexImpl.find(InlineIndexImpl.java:104)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.query.h2.database.H2TreeIndex.find(H2TreeIndex.java:209)
~[mediafan.jar:?]
at org.h2.index.BaseIndex.find(BaseIndex.java:130) ~[mediafan.jar:?]
at org.h2.index.IndexCursor.find(IndexCursor.java:176) ~[mediafan.jar:?]
at org.h2.table.TableFilter.next(TableFilter.java:471) ~[mediafan.jar:?]
at
org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1452)
~[mediafan.jar:?]
at org.h2.result.LazyResult.hasNext(LazyResult.java:79)
~[mediafan.jar:?]
at org.h2.result.LazyResult.next(LazyResult.java:59) ~[mediafan.jar:?]
at org.h2.command.dml.Select.queryFlat(Select.java:527)
~[mediafan.jar:?]
at org.h2.command.dml.Select.queryWithoutCache(Select.java:633)
~[mediafan.jar:?]
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
~[mediafan.jar:?]
at org.h2.command.dml.Query.query(Query.java:352) ~[mediafan.jar:?]
at org.h2.command.dml.Query.query(Query.java:333) ~[mediafan.jar:?]
at org.h2.command.CommandContainer.query(CommandContainer.java:114)
~[mediafan.jar:?]
at org.h2.command.Command.executeQuery(Command.java:202)
~[mediafan.jar:?]
at
org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:114)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:888)
~[mediafan.jar:?]
... 14 more
Caused by: org.h2.message.DbException: Data conversion error converting
"IDX_STAGE_308" [22018-197]
at org.h2.message.DbException.get(DbException.java:179)
~[mediafan.jar:?]
at org.h2.message.DbException.get(DbException.java:155)
~[mediafan.jar:?]
at org.h2.value.ValueUuid.get(ValueUuid.java:118) ~[mediafan.jar:?]
at org.h2.value.Value.convertTo(Value.java:1106) ~[mediafan.jar:?]
at org.h2.value.Value.convertTo(Value.java:617) ~[mediafan.jar:?]
at org.h2.value.Value.convertTo(Value.java:592) ~[mediafan.jar:?]
at org.h2.table.Table.compareTypeSafe(Table.java:1186) ~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.query.h2.index.H2RowComparator.compareValues(H2RowComparator.java:147)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.query.h2.index.H2RowComparator.compareRow(H2RowComparator.java:115)
~[mediafan.jar:?]
at
org.apache.ignite.internal.cache.query.index.sorted.inline.InlineIndexTree.compareFullRows(InlineIndexTree.java:336)
~[mediafan.jar:?]
at
org.apache.ignite.internal.cache.query.index.sorted.inline.InlineIndexTree.compare(InlineIndexTree.java:316)
~[mediafan.jar:?]
at
org.apache.ignite.internal.cache.query.index.sorted.inline.InlineIndexTree.compare(InlineIndexTree.java:74)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.compare(BPlusTree.java:5553)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.findInsertionPoint(BPlusTree.java:5473)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.access$1100(BPlusTree.java:162)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$Search.run0(BPlusTree.java:369)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$GetPageHandler.run(BPlusTree.java:6089)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$Search.run(BPlusTree.java:349)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$GetPageHandler.run(BPlusTree.java:6075)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.util.PageHandler.readPage(PageHandler.java:174)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.DataStructure.read(DataStructure.java:415)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.read(BPlusTree.java:6276)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.findDown(BPlusTree.java:1542)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.doFind(BPlusTree.java:1509)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.access$7300(BPlusTree.java:162)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$AbstractForwardCursor.find(BPlusTree.java:5746)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.find(BPlusTree.java:1201)
~[mediafan.jar:?]
at
org.apache.ignite.internal.cache.query.index.sorted.inline.InlineIndexImpl.find(InlineIndexImpl.java:104)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.query.h2.database.H2TreeIndex.find(H2TreeIndex.java:209)
~[mediafan.jar:?]
at org.h2.index.BaseIndex.find(BaseIndex.java:130) ~[mediafan.jar:?]
at org.h2.index.IndexCursor.find(IndexCursor.java:176) ~[mediafan.jar:?]
at org.h2.table.TableFilter.next(TableFilter.java:471) ~[mediafan.jar:?]
at
org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1452)
~[mediafan.jar:?]
at org.h2.result.LazyResult.hasNext(LazyResult.java:79)
~[mediafan.jar:?]
at org.h2.result.LazyResult.next(LazyResult.java:59) ~[mediafan.jar:?]
at org.h2.command.dml.Select.queryFlat(Select.java:527)
~[mediafan.jar:?]
at org.h2.command.dml.Select.queryWithoutCache(Select.java:633)
~[mediafan.jar:?]
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
~[mediafan.jar:?]
at org.h2.command.dml.Query.query(Query.java:352) ~[mediafan.jar:?]
at org.h2.command.dml.Query.query(Query.java:333) ~[mediafan.jar:?]
at org.h2.command.CommandContainer.query(CommandContainer.java:114)
~[mediafan.jar:?]
at org.h2.command.Command.executeQuery(Command.java:202)
~[mediafan.jar:?]
at
org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:114)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:888)
~[mediafan.jar:?]
... 14 more
Caused by: org.h2.jdbc.JdbcSQLException: Data conversion error converting
"IDX_STAGE_308" [22018-197]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
~[mediafan.jar:?]
at org.h2.message.DbException.get(DbException.java:179)
~[mediafan.jar:?]
at org.h2.message.DbException.get(DbException.java:155)
~[mediafan.jar:?]
at org.h2.value.ValueUuid.get(ValueUuid.java:118) ~[mediafan.jar:?]
at org.h2.value.Value.convertTo(Value.java:1106) ~[mediafan.jar:?]
at org.h2.value.Value.convertTo(Value.java:617) ~[mediafan.jar:?]
at org.h2.value.Value.convertTo(Value.java:592) ~[mediafan.jar:?]
at org.h2.table.Table.compareTypeSafe(Table.java:1186) ~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.query.h2.index.H2RowComparator.compareValues(H2RowComparator.java:147)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.query.h2.index.H2RowComparator.compareRow(H2RowComparator.java:115)
~[mediafan.jar:?]
at
org.apache.ignite.internal.cache.query.index.sorted.inline.InlineIndexTree.compareFullRows(InlineIndexTree.java:336)
~[mediafan.jar:?]
at
org.apache.ignite.internal.cache.query.index.sorted.inline.InlineIndexTree.compare(InlineIndexTree.java:316)
~[mediafan.jar:?]
at
org.apache.ignite.internal.cache.query.index.sorted.inline.InlineIndexTree.compare(InlineIndexTree.java:74)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.compare(BPlusTree.java:5553)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.findInsertionPoint(BPlusTree.java:5473)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.access$1100(BPlusTree.java:162)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$Search.run0(BPlusTree.java:369)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$GetPageHandler.run(BPlusTree.java:6089)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$Search.run(BPlusTree.java:349)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$GetPageHandler.run(BPlusTree.java:6075)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.util.PageHandler.readPage(PageHandler.java:174)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.DataStructure.read(DataStructure.java:415)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.read(BPlusTree.java:6276)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.findDown(BPlusTree.java:1542)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.doFind(BPlusTree.java:1509)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.access$7300(BPlusTree.java:162)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$AbstractForwardCursor.find(BPlusTree.java:5746)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.find(BPlusTree.java:1201)
~[mediafan.jar:?]
at
org.apache.ignite.internal.cache.query.index.sorted.inline.InlineIndexImpl.find(InlineIndexImpl.java:104)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.query.h2.database.H2TreeIndex.find(H2TreeIndex.java:209)
~[mediafan.jar:?]
at org.h2.index.BaseIndex.find(BaseIndex.java:130) ~[mediafan.jar:?]
at org.h2.index.IndexCursor.find(IndexCursor.java:176) ~[mediafan.jar:?]
at org.h2.table.TableFilter.next(TableFilter.java:471) ~[mediafan.jar:?]
at
org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1452)
~[mediafan.jar:?]
at org.h2.result.LazyResult.hasNext(LazyResult.java:79)
~[mediafan.jar:?]
at org.h2.result.LazyResult.next(LazyResult.java:59) ~[mediafan.jar:?]
at org.h2.command.dml.Select.queryFlat(Select.java:527)
~[mediafan.jar:?]
at org.h2.command.dml.Select.queryWithoutCache(Select.java:633)
~[mediafan.jar:?]
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
~[mediafan.jar:?]
at org.h2.command.dml.Query.query(Query.java:352) ~[mediafan.jar:?]
at org.h2.command.dml.Query.query(Query.java:333) ~[mediafan.jar:?]
at org.h2.command.CommandContainer.query(CommandContainer.java:114)
~[mediafan.jar:?]
at org.h2.command.Command.executeQuery(Command.java:202)
~[mediafan.jar:?]
at
org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:114)
~[mediafan.jar:?]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:888)
~[mediafan.jar:?]
... 14 more
