Hi all,
We have installed a 2.4 Ignite cluster
- 3 nodes under Windows systems (24 Go, 16 Go, 16 Go)
- 4 caches configured, partitioned, no backup
- no persistence
cache @c0 contains around 60,000 items,
cache @c3 contains few items (around 200) but items are very large.
We run sql queries which aggregate the @c0 items in large collections (until
14,000 items per collection) and store the result in @c3.
After a while, the sql query stop functionning. The following error is logged :
2018-05-30 23:14:42,716 [282] ERROR
org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor -
Failed to execute local query.
Here is our cache configuration :
<cacheConfiguration>
<cacheConfiguration name="owproposals" cacheMode="Partitioned"
backups="0" readThrough="true" writeThrough="true" writeBehindEnabled="true">
<cacheStoreFactory type="OwProposalFactory"/>
<queryEntities>
<queryEntity valueType="OwProposal, Cache.Common"
valueTypeName="Models.OwProposal"/>
</queryEntities>
</cacheConfiguration>
<cacheConfiguration name="rtproposals" cacheMode="Partitioned"
backups="0" readThrough="true" writeThrough="true" writeBehindEnabled="true">
<cacheStoreFactory type="RtProposalFactory"/>
<queryEntities>
<queryEntity valueType="RtProposal, Cache.Common"
valueTypeName="Models.RtProposal"/>
</queryEntities>
</cacheConfiguration>
<cacheConfiguration name="owcollection" cacheMode="Partitioned"
backups="0">
<queryEntities>
<queryEntity valueType="OwCollection, Cache.Common"
valueTypeName="Models.OwCollection"/>
</queryEntities>
</cacheConfiguration>
<cacheConfiguration name="rtcollection" cacheMode="Partitioned"
backups="0">
<queryEntities>
<queryEntity valueType="RtCollection, Cache.Common"
valueTypeName="Models.RtCollection"/>
</queryEntities>
</cacheConfiguration>
</cacheConfiguration>
I tried to clear the items of @c0 cache before re-populate it but I got the
error :
2018-05-30 23:34:34,333 [16] ERROR ServiceCache - Failed to delete OwItems
older than 2018-05-31
Apache.Ignite.Core.Common.IgniteException: Failed to execute map query on the
node: b9f240d6-0ee6-4dee-bda0-51088a743481, class
org.apache.ignite.internal.processors.query.IgniteSQLException:Failed to set
schema for DB connection for thread [schema=owproposals] --->
Apache.Ignite.Core.Common.JavaException: class
org.apache.ignite.IgniteCheckedException: Failed to execute map query on the
node: b9f240d6-0ee6-4dee-bda0-51088a743481, class
org.apache.ignite.internal.processors.query.IgniteSQLException:Failed to set
schema for DB connection for thread [schema=owproposals]
at
org.apache.ignite.internal.processors.platform.utils.PlatformUtils.unwrapQueryException(PlatformUtils.java:519)
at
org.apache.ignite.internal.processors.platform.cache.query.PlatformAbstractQueryCursor.processOutStream(PlatformAbstractQueryCursor.java:132)
at
org.apache.ignite.internal.processors.platform.PlatformTargetProxyImpl.outStream(PlatformTargetProxyImpl.java:93)
Caused by: javax.cache.CacheException: Failed to run map query remotely.Failed
to execute map query on the node: b9f240d6-0ee6-4dee-bda0-51088a743481, class
org.apache.ignite.internal.processors.query.IgniteSQLException:Failed to set
schema for DB connection for thread [schema=owproposals]
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:747)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$8.iterator(IgniteH2Indexing.java:1339)
at
org.apache.ignite.internal.processors.cache.QueryCursorImpl.iterator(QueryCursorImpl.java:95)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$9.iterator(IgniteH2Indexing.java:1403)
at
org.apache.ignite.internal.processors.cache.QueryCursorImpl.iterator(QueryCursorImpl.java:95)
at
org.apache.ignite.internal.processors.cache.QueryCursorImpl.getAll(QueryCursorImpl.java:127)
at
org.apache.ignite.internal.processors.platform.cache.query.PlatformAbstractQueryCursor.processOutStream(PlatformAbstractQueryCursor.java:127)
... 1 more
Caused by: javax.cache.CacheException: Failed to execute map query on the node:
b9f240d6-0ee6-4dee-bda0-51088a743481, class
org.apache.ignite.internal.processors.query.IgniteSQLException:Failed to set
schema for DB connection for thread [schema=owproposals]
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.fail(GridReduceQueryExecutor.java:275)
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.onFail(GridReduceQueryExecutor.java:265)
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.onMessage(GridReduceQueryExecutor.java:244)
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$2.onMessage(GridReduceQueryExecutor.java:188)
at
org.apache.ignite.internal.managers.communication.GridIoManager$ArrayListener.onMessage(GridIoManager.java:2332)
at
org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1555)
at
org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:1183)
at
org.apache.ignite.internal.managers.communication.GridIoManager.access$4200(GridIoManager.java:126)
at
org.apache.ignite.internal.managers.communication.GridIoManager$9.run(GridIoManager.java:1090)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
à Apache.Ignite.Core.Impl.Unmanaged.Jni.Env.ExceptionCheck()
à Apache.Ignite.Core.Impl.Unmanaged.UnmanagedUtils.TargetOutStream(GlobalRef
target, Int32 opType, Int64 memPtr)
à Apache.Ignite.Core.Impl.PlatformJniTarget.OutStream[T](Int32 type, Func`2
readAction)
--- Fin de la trace de la pile d'exception interne ---
à Apache.Ignite.Core.Impl.PlatformJniTarget.OutStream[T](Int32 type, Func`2
readAction)
à Apache.Ignite.Core.Impl.Cache.Query.QueryCursorBase`1.GetAll()
à MrFly.CacheDlm.Common.Services.ServiceCache.GetKeys[TV](QueryBase query)
à MrFly.CacheDlm.Common.Services.ServiceCache.DeleteOneWayItems(DateTime
createdDate)
At this time, the only way is to down the three nodes and restart them from
scratch.
Any idea about what is malfunctionning or misconfigured ?
Kind regards,
S Gayet
