ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stéphane Gayet <Stephane.Ga...@misterfly.com>
Subject SQL Query error
Date Wed, 30 May 2018 21:44:11 GMT
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





Mime
View raw message