Hi
When delete some data,it got an error.
sql = "delete from \"tmpCompanyCuBaseDataCache\".TmpCompanyCuBaseData "；
cache.query(new SqlFieldsQuery(sql))
I use jdbc to excute this sql ,it's the same.
This table has about 200000 records.
I had check the data ,and found the data is normal.
What did I miss?
Thanks.
Here is the trace:
javax.cache.CacheException: class
org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to
process key '1516002613660-100-82' at
org.apache.ignite.internal.processors.cache.IgniteCacheProxyImpl.query(IgniteCacheProxyImpl.java:597)
at
org.apache.ignite.internal.processors.cache.IgniteCacheProxyImpl.query(IgniteCacheProxyImpl.java:560)
at
org.apache.ignite.internal.processors.cache.GatewayProtectedCacheProxy.query(GatewayProtectedCacheProxy.java:382)
at
xxx.xxx.xxx.basedata.framework.app.IgniteDatabaseDAssignService.batchExecute(IgniteDatabaseDAssignService.java:50)
at
xxx.xxx.xxx.sss.sss.sss.sss.CustomerControllerBean.batchAssignCompanyInfo2(CustomerControllerBean.java:5226)
at
xxx.xxx.xxx.sss.sss.sss.sss.CustomerControllerBean._batchAssignAssist(CustomerControllerBean.java:5718)
at
xxx.xxx.xxx.sss.sss.sss.sss.AbstractCustomerControllerBean.batchAssignAssist(AbstractCustomerControllerBean.java:862)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:94)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:619) at
xxx.xxx.x22.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:125)
at
xxx.xxx.x22.transaction.EJBTxFacade.TxInvokerBean.INVOKE_REQUIRED(TxInvokerBean.java:60)
at
xxx.xxx.x22.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_REQUIRED(Unknown
Source) at
xxx.xxx.x22.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:171)
at
xxx.xxx.x22.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at com.sun.proxy.$Proxy465.batchAssignAssist(Unknown Source)
at
xxx.xxx.xxx.basedata.master.cssp.Customer.batchAssignAssist(Customer.java:595)
at
rpc_generate._PROXY_com_1_kingdee_1_eas_1_basedata_1_master_1_cssp_1_ICustomer.pi120(Unknown
Source) at
rpc_generate._PROXY_com_1_kingdee_1_eas_1_basedata_1_master_1_cssp_1_ICustomer.processInvoke(Unknown
Source) at
xxx.xxx.x22.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177) at
xxx.xxx.x22.rpc.impl.RPCService.serviceInvoke(RPCService.java:788) at
xxx.xxx.x22.rpc.impl.RPCService.service(RPCService.java:141) at
xxx.xxx.x22.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153) at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:482) at
java.util.concurrent.FutureTask.run(FutureTask.java:273) at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1176)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
at java.lang.Thread.run(Thread.java:853) Caused by: class
org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to
process key '1516002613660-100-82'
at
org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.doDelete(DmlStatementsProcessor.java:581)
at
org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.processDmlSelectResult(DmlStatementsProcessor.java:444)
at
org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.executeUpdateStatement(DmlStatementsProcessor.java:420)
at
org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.updateSqlFields(DmlStatementsProcessor.java:194)
at
org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.updateSqlFieldsDistributed(DmlStatementsProcessor.java:229)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSqlFields(IgniteH2Indexing.java:1453)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor$5.applyx(GridQueryProcessor.java:1909)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor$5.applyx(GridQueryProcessor.java:1907)
at
org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2445)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:1914)
at
org.apache.ignite.internal.processors.cache.IgniteCacheProxyImpl.query(IgniteCacheProxyImpl.java:585)
... 28 more
Caused by: java.sql.SQLException: Failed to process key '1516002613660-100-82'
at
org.apache.ignite.internal.processors.cache.query.IgniteQueryErrorCode.createJdbcSqlException(IgniteQueryErrorCode.java:116)
at
org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.splitErrors(DmlStatementsProcessor.java:794)
at
org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.processPage(DmlStatementsProcessor.java:934)
at
org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.access$600(DmlStatementsProcessor.java:105)
at
org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor$BatchSender.sendBatch(DmlStatementsProcessor.java:1329)
at
org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor$BatchSender.add(DmlStatementsProcessor.java:1282)
at
org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.doDelete(DmlStatementsProcessor.java:560)
... 39 more Caused by: javax.cache.processor.EntryProcessorException: class
org.apache.ignite.IgniteCheckedException: null at
org.apache.ignite.internal.processors.cache.CacheInvokeResult.get(CacheInvokeResult.java:102)
at
org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.splitErrors(DmlStatementsProcessor.java:791)
... 44 more
Caused by: class org.apache.ignite.IgniteCheckedException: null at
org.apache.ignite.internal.util.IgniteUtils.cast(IgniteUtils.java:7252) at
org.apache.ignite.internal.processors.cache.GridCacheContext.validateKeyAndValue(GridCacheContext.java:1828)
at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.updateWithBatch(GridDhtAtomicCache.java:2073)
at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.update(GridDhtAtomicCache.java:1864)
at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.updateAllAsyncInternal0(GridDhtAtomicCache.java:1735)
at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.updateAllAsyncInternal(GridDhtAtomicCache.java:1627)
at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.processNearAtomicUpdateRequest(GridDhtAtomicCache.java:3054)
at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.access$400(GridDhtAtomicCache.java:129)
at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache$5.apply(GridDhtAtomicCache.java:265)
at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache$5.apply(GridDhtAtomicCache.java:260)
at
org.apache.ignite.internal.processors.cache.GridCacheIoManager.processMessage(GridCacheIoManager.java:1060)
at
org.apache.ignite.internal.processors.cache.GridCacheIoManager.onMessage0(GridCacheIoManager.java:579)
at
org.apache.ignite.internal.processors.cache.GridCacheIoManager.handleMessage(GridCacheIoManager.java:378)
at
org.apache.ignite.internal.processors.cache.GridCacheIoManager.handleMessage(GridCacheIoManager.java:304)
at
org.apache.ignite.internal.processors.cache.GridCacheIoManager.access$100(GridCacheIoManager.java:99)
at
org.apache.ignite.internal.processors.cache.GridCacheIoManager$1.onMessage(GridCacheIoManager.java:293)
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
org.apache.ignite.internal.util.StripedExecutor$Stripe.run(StripedExecutor.java:505)
at java.lang.Thread.run(Thread.java:745) Caused by:
java.lang.NullPointerException at
org.apache.ignite.internal.processors.query.GridQueryProcessor.typeByValue(GridQueryProcessor.java:1782)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.validateKeyAndValue(GridQueryProcessor.java:2671)
at
org.apache.ignite.internal.processors.cache.GridCacheContext.validateKeyAndValue(GridCacheContext.java:1825)
... 20 more
