Hello! It looks that Web Console generated an incorrect schema for PositionCache cache. Can you share CacheConfiguration and schema for the related table?
On Tue, Dec 5, 2017 at 5:00 PM, Ahmad Al-Masry <[email protected]> wrote: > Hi; > Want to to test Ignite to improve the performance of our reporting system. > The datasource is MySQL. > We used The Web Console to create the integration with MySQL and used the > auto generated package from there to load the data. > Some the tables have loaded successfully and the rest did not, and the > following of some of the exceptions: > 1- This Error gives SQL syntax error when trying to load Job table: > > Dec 05, 2017 3:54:32 PM org.apache.ignite.logger.java.JavaLogger error > SEVERE: Failed to obtain remote job result policy for result from > ComputeTask.result(..) method (will fail the whole task): GridJobResultImpl > [job=C2 [c=LoadCacheJobV2 [keepBinary=false]], sib=GridJobSiblingImpl > [sesId=88b94f62061-b5688ca0-691e-4982-84e7-9f5cc596a8b7, > jobId=98b94f62061-b5688ca0-691e-4982-84e7-9f5cc596a8b7, > nodeId=705cc1c6-2965-4700-83b3-0fc9671a70e0, isJobDone=false], > jobCtx=GridJobContextImpl > [jobId=98b94f62061-b5688ca0-691e-4982-84e7-9f5cc596a8b7, > timeoutObj=null, attrs={}], node=TcpDiscoveryNode > [id=705cc1c6-2965-4700-83b3-0fc9671a70e0, addrs=[0:0:0:0:0:0:0:1%lo, > 10.10.11.31, 127.0.0.1], sockAddrs=[ip-10-10-11-31.ec2.internal/ > 10.10.11.31:47500, 0:0:0:0:0:0:0:1%lo:47500, /127.0.0.1:47500], > discPort=47500, order=1, intOrder=1, lastExchangeTime=1512482063467, > loc=false, ver=2.3.0#19700101-sha1:00000000, isClient=false], ex=class > o.a.i.IgniteException: Failed to load cache: JobApplicationCache, > hasRes=true, isCancelled=false, isOccupied=true] > class org.apache.ignite.IgniteException: Remote job threw user exception > (override or implement ComputeTask.result(..) method if you would like to > have automatic failover for this exception). > at org.apache.ignite.compute.ComputeTaskAdapter.result( > ComputeTaskAdapter.java:101) > at org.apache.ignite.internal.processors.task.GridTaskWorker$5.apply( > GridTaskWorker.java:1047) > at org.apache.ignite.internal.processors.task.GridTaskWorker$5.apply( > GridTaskWorker.java:1040) > at org.apache.ignite.internal.util.IgniteUtils. > wrapThreadLoader(IgniteUtils.java:6663) > at org.apache.ignite.internal.processors.task.GridTaskWorker.result( > GridTaskWorker.java:1040) > at org.apache.ignite.internal.processors.task.GridTaskWorker.onResponse( > GridTaskWorker.java:858) > at org.apache.ignite.internal.processors.task.GridTaskProcessor. > processJobExecuteResponse(GridTaskProcessor.java:1066) > at org.apache.ignite.internal.processors.task.GridTaskProcessor$ > JobMessageListener.onMessage(GridTaskProcessor.java:1301) > 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( > ThreadPoolExecutor.java:1149) > at java.util.concurrent.ThreadPoolExecutor$Worker.run( > ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:748) > Caused by: class org.apache.ignite.IgniteException: Failed to load cache: > JobApplicationCache > at org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2. > execute(GridClosureProcessor.java:1858) > at org.apache.ignite.internal.processors.job.GridJobWorker$ > 2.call(GridJobWorker.java:566) > at org.apache.ignite.internal.util.IgniteUtils. > wrapThreadLoader(IgniteUtils.java:6631) > at org.apache.ignite.internal.processors.job.GridJobWorker. > execute0(GridJobWorker.java:560) > at org.apache.ignite.internal.processors.job.GridJobWorker. > body(GridJobWorker.java:489) > at org.apache.ignite.internal.util.worker.GridWorker.run( > GridWorker.java:110) > at org.apache.ignite.internal.processors.job.GridJobProcessor. > processJobExecuteRequest(GridJobProcessor.java:1115) > at org.apache.ignite.internal.processors.job.GridJobProcessor$ > JobExecutionListener.onMessage(GridJobProcessor.java:1913) > ... 7 more > Caused by: class org.apache.ignite.IgniteException: Failed to load cache: > JobApplicationCache > at org.apache.ignite.internal.util.IgniteUtils. > convertException(IgniteUtils.java:966) > at org.apache.ignite.internal.processors.cache. > GridCacheAdapter$LoadCacheJob.localExecute(GridCacheAdapter.java:5472) > at org.apache.ignite.internal.processors.cache.GridCacheAdapter$ > LoadCacheJobV2.localExecute(GridCacheAdapter.java:5516) > at org.apache.ignite.internal.processors.cache.GridCacheAdapter$ > TopologyVersionAwareJob.execute(GridCacheAdapter.java:6131) > at org.apache.ignite.compute.ComputeJobAdapter.call( > ComputeJobAdapter.java:132) > at org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2. > execute(GridClosureProcessor.java:1855) > ... 14 more > Caused by: class org.apache.ignite.IgniteCheckedException: Failed to load > cache: JobApplicationCache > at org.apache.ignite.internal.processors.cache.store. > GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter. > java:532) > at org.apache.ignite.internal.processors.cache.distributed. > dht.GridDhtCacheAdapter.localLoadCache(GridDhtCacheAdapter.java:607) > at org.apache.ignite.internal.processors.cache.GridCacheProxyImpl. > localLoadCache(GridCacheProxyImpl.java:217) > at org.apache.ignite.internal.processors.cache. > GridCacheAdapter$LoadCacheJob.localExecute(GridCacheAdapter.java:5467) > ... 18 more > Caused by: javax.cache.integration.CacheLoaderException: Failed to load > cache: JobApplicationCache > at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.loadCache( > CacheAbstractJdbcStore.java:819) > at org.apache.ignite.internal.processors.cache.store. > GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter. > java:509) > ... 21 more > Caused by: class org.apache.ignite.IgniteCheckedException: Failed to load > cache > at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$1. > call(CacheAbstractJdbcStore.java:474) > at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$1. > call(CacheAbstractJdbcStore.java:434) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > ... 3 more > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You > have an error in your SQL syntax; check the manual that corresponds to your > MySQL server version for the right syntax to use near > 'order,is_new,candidate_archived,candidate_archived_date,seen_by_candidate,requir' > at line 1 > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at sun.reflect.NativeConstructorAccessorImpl.newInstance( > NativeConstructorAccessorImpl.java:62) > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance( > DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:423) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) > at com.mysql.jdbc.Util.getInstance(Util.java:408) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484) > at com.mysql.jdbc.PreparedStatement.executeInternal( > PreparedStatement.java:1858) > at com.mysql.jdbc.PreparedStatement.executeQuery( > PreparedStatement.java:1966) > at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$1. > call(CacheAbstractJdbcStore.java:461) > ... 5 more > [15:54:33] Ignite node stopped OK [name=Harri, uptime=00:00:04.593] > Exception in thread "main" javax.cache.integration.CacheLoaderException: > Failed to load cache: JobApplicationCache > at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.loadCache( > CacheAbstractJdbcStore.java:819) > at org.apache.ignite.internal.processors.cache.store. > GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter. > java:509) > at org.apache.ignite.internal.processors.cache.distributed. > dht.GridDhtCacheAdapter.localLoadCache(GridDhtCacheAdapter.java:607) > at org.apache.ignite.internal.processors.cache.GridCacheProxyImpl. > localLoadCache(GridCacheProxyImpl.java:217) > at org.apache.ignite.internal.processors.cache. > GridCacheAdapter$LoadCacheJob.localExecute(GridCacheAdapter.java:5467) > at org.apache.ignite.internal.processors.cache.GridCacheAdapter$ > LoadCacheJobV2.localExecute(GridCacheAdapter.java:5516) > at org.apache.ignite.internal.processors.cache.GridCacheAdapter$ > TopologyVersionAwareJob.execute(GridCacheAdapter.java:6131) > at org.apache.ignite.compute.ComputeJobAdapter.call( > ComputeJobAdapter.java:132) > at org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2. > execute(GridClosureProcessor.java:1855) > at org.apache.ignite.internal.processors.job.GridJobWorker$ > 2.call(GridJobWorker.java:566) > at org.apache.ignite.internal.util.IgniteUtils. > wrapThreadLoader(IgniteUtils.java:6631) > at org.apache.ignite.internal.processors.job.GridJobWorker. > execute0(GridJobWorker.java:560) > at org.apache.ignite.internal.processors.job.GridJobWorker. > body(GridJobWorker.java:489) > at org.apache.ignite.internal.util.worker.GridWorker.run( > GridWorker.java:110) > at org.apache.ignite.internal.processors.job.GridJobProcessor. > processJobExecuteRequest(GridJobProcessor.java:1115) > at org.apache.ignite.internal.processors.job.GridJobProcessor$ > JobExecutionListener.onMessage(GridJobProcessor.java:1913) > 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( > ThreadPoolExecutor.java:1149) > at java.util.concurrent.ThreadPoolExecutor$Worker.run( > ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:748) > Caused by: class org.apache.ignite.IgniteCheckedException: Failed to load > cache > at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$1. > call(CacheAbstractJdbcStore.java:474) > at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$1. > call(CacheAbstractJdbcStore.java:434) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > ... 3 more > > *Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You > have an error in your SQL syntax; check the manual that corresponds to your > MySQL server version for the right syntax to use near > 'order,is_new,candidate_archived,candidate_archived_date,seen_by_candidate,requir' > at line 1* at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at sun.reflect.NativeConstructorAccessorImpl.newInstance( > NativeConstructorAccessorImpl.java:62) > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance( > DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:423) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) > at com.mysql.jdbc.Util.getInstance(Util.java:408) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484) > at com.mysql.jdbc.PreparedStatement.executeInternal( > PreparedStatement.java:1858) > at com.mysql.jdbc.PreparedStatement.executeQuery( > PreparedStatement.java:1966) > at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$1. > call(CacheAbstractJdbcStore.java:461) > ... 5 more > > 2- Another error because of data format when loading Position Table: > > Dec 05, 2017 3:58:33 PM org.apache.ignite.logger.java.JavaLogger error > SEVERE: Failed to obtain remote job result policy for result from > ComputeTask.result(..) method (will fail the whole task): GridJobResultImpl > [job=C2 [c=LoadCacheJobV2 [keepBinary=false]], sib=GridJobSiblingImpl > [sesId=4bb58f62061-bad74bf5-16fb-40c8-9a7a-219762f849f8, > jobId=5bb58f62061-bad74bf5-16fb-40c8-9a7a-219762f849f8, > nodeId=705cc1c6-2965-4700-83b3-0fc9671a70e0, isJobDone=false], > jobCtx=GridJobContextImpl > [jobId=5bb58f62061-bad74bf5-16fb-40c8-9a7a-219762f849f8, > timeoutObj=null, attrs={}], node=TcpDiscoveryNode > [id=705cc1c6-2965-4700-83b3-0fc9671a70e0, addrs=[0:0:0:0:0:0:0:1%lo, > 10.10.11.31, 127.0.0.1], sockAddrs=[ip-10-10-11-31.ec2.internal/ > 10.10.11.31:47500, 0:0:0:0:0:0:0:1%lo:47500, /127.0.0.1:47500], > discPort=47500, order=1, intOrder=1, lastExchangeTime=1512482309773, > loc=false, ver=2.3.0#19700101-sha1:00000000, isClient=false], ex=class > o.a.i.IgniteException: Failed to load cache: PositionCache, hasRes=true, > isCancelled=false, isOccupied=true] > class org.apache.ignite.IgniteException: Remote job threw user exception > (override or implement ComputeTask.result(..) method if you would like to > have automatic failover for this exception). > at org.apache.ignite.compute.ComputeTaskAdapter.result( > ComputeTaskAdapter.java:101) > at org.apache.ignite.internal.processors.task.GridTaskWorker$5.apply( > GridTaskWorker.java:1047) > at org.apache.ignite.internal.processors.task.GridTaskWorker$5.apply( > GridTaskWorker.java:1040) > at org.apache.ignite.internal.util.IgniteUtils. > wrapThreadLoader(IgniteUtils.java:6663) > at org.apache.ignite.internal.processors.task.GridTaskWorker.result( > GridTaskWorker.java:1040) > at org.apache.ignite.internal.processors.task.GridTaskWorker.onResponse( > GridTaskWorker.java:858) > at org.apache.ignite.internal.processors.task.GridTaskWorker. > processDelayedResponses(GridTaskWorker.java:707) > at org.apache.ignite.internal.processors.task.GridTaskWorker.body( > GridTaskWorker.java:538) > at org.apache.ignite.internal.util.worker.GridWorker.run( > GridWorker.java:110) > at org.apache.ignite.internal.processors.task.GridTaskProcessor.startTask( > GridTaskProcessor.java:749) > at org.apache.ignite.internal.processors.task.GridTaskProcessor.execute( > GridTaskProcessor.java:448) > at org.apache.ignite.internal.processors.closure.GridClosureProcessor. > callAsync(GridClosureProcessor.java:449) > at org.apache.ignite.internal.processors.closure.GridClosureProcessor. > callAsync(GridClosureProcessor.java:420) > at org.apache.ignite.internal.processors.closure.GridClosureProcessor. > callAsync(GridClosureProcessor.java:404) > at org.apache.ignite.internal.processors.cache.GridCacheAdapter. > globalLoadCacheAsync(GridCacheAdapter.java:3677) > at org.apache.ignite.internal.processors.cache.GridCacheAdapter. > globalLoadCache(GridCacheAdapter.java:3653) > at org.apache.ignite.internal.processors.cache.IgniteCacheProxyImpl. > loadCache(IgniteCacheProxyImpl.java:268) > at org.apache.ignite.internal.processors.cache.GatewayProtectedCacheProxy. > loadCache(GatewayProtectedCacheProxy.java:260) > at load.LoadCaches.main(LoadCaches.java:46) > Caused by: class org.apache.ignite.IgniteException: Failed to load cache: > PositionCache > at org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2. > execute(GridClosureProcessor.java:1858) > at org.apache.ignite.internal.processors.job.GridJobWorker$ > 2.call(GridJobWorker.java:566) > at org.apache.ignite.internal.util.IgniteUtils. > wrapThreadLoader(IgniteUtils.java:6631) > at org.apache.ignite.internal.processors.job.GridJobWorker. > execute0(GridJobWorker.java:560) > at org.apache.ignite.internal.processors.job.GridJobWorker. > body(GridJobWorker.java:489) > at org.apache.ignite.internal.util.worker.GridWorker.run( > GridWorker.java:110) > at org.apache.ignite.internal.processors.job.GridJobProcessor. > processJobExecuteRequest(GridJobProcessor.java:1115) > at org.apache.ignite.internal.processors.job.GridJobProcessor$ > JobExecutionListener.onMessage(GridJobProcessor.java:1913) > 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( > ThreadPoolExecutor.java:1149) > at java.util.concurrent.ThreadPoolExecutor$Worker.run( > ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:748) > Caused by: class org.apache.ignite.IgniteException: Failed to load cache: > PositionCache > at org.apache.ignite.internal.util.IgniteUtils. > convertException(IgniteUtils.java:966) > at org.apache.ignite.internal.processors.cache. > GridCacheAdapter$LoadCacheJob.localExecute(GridCacheAdapter.java:5472) > at org.apache.ignite.internal.processors.cache.GridCacheAdapter$ > LoadCacheJobV2.localExecute(GridCacheAdapter.java:5516) > at org.apache.ignite.internal.processors.cache.GridCacheAdapter$ > TopologyVersionAwareJob.execute(GridCacheAdapter.java:6131) > at org.apache.ignite.compute.ComputeJobAdapter.call( > ComputeJobAdapter.java:132) > at org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2. > execute(GridClosureProcessor.java:1855) > ... 14 more > Caused by: class org.apache.ignite.IgniteCheckedException: Failed to load > cache: PositionCache > at org.apache.ignite.internal.processors.cache.store. > GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter. > java:532) > at org.apache.ignite.internal.processors.cache.distributed. > dht.GridDhtCacheAdapter.localLoadCache(GridDhtCacheAdapter.java:607) > at org.apache.ignite.internal.processors.cache.GridCacheProxyImpl. > localLoadCache(GridCacheProxyImpl.java:217) > at org.apache.ignite.internal.processors.cache. > GridCacheAdapter$LoadCacheJob.localExecute(GridCacheAdapter.java:5467) > ... 18 more > Caused by: javax.cache.integration.CacheLoaderException: Failed to load > cache: PositionCache > at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.loadCache( > CacheAbstractJdbcStore.java:819) > at org.apache.ignite.internal.processors.cache.store. > GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter. > java:509) > ... 21 more > Caused by: javax.cache.CacheException: Failed to read binary object: > com.harri.model.Position > at org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStore. > buildBinaryObject(CacheJdbcPojoStore.java:255) > at org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStore.buildObject( > CacheJdbcPojoStore.java:136) > at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$1. > call(CacheAbstractJdbcStore.java:467) > at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$1. > call(CacheAbstractJdbcStore.java:434) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > ... 3 more > Caused by: java.sql.SQLException: Value ' 2058 cashier-retail Cashier��� > 10 1 2016-06-22 00:13:27 2017-02-10 23:19:09 0 0000-00-00 00:00:00 21�� ' > can not be represented as java.sql.Timestamp > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861) > at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:937) > at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:559) > at com.mysql.jdbc.ResultSetImpl.getTimestampInternal( > ResultSetImpl.java:5921) > at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5591) > at org.apache.ignite.cache.store.jdbc.JdbcTypesDefaultTransformer. > getColumnValue(JdbcTypesDefaultTransformer.java:66) > at org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStore. > buildBinaryObject(CacheJdbcPojoStore.java:247) > ... 7 more > > [15:58:33] Ignite node stopped OK [name=Harri, uptime=00:00:00.816] > Exception in thread "main" javax.cache.integration.CacheLoaderException: > Failed to load cache: PositionCache > at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.loadCache( > CacheAbstractJdbcStore.java:819) > at org.apache.ignite.internal.processors.cache.store. > GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter. > java:509) > at org.apache.ignite.internal.processors.cache.distributed. > dht.GridDhtCacheAdapter.localLoadCache(GridDhtCacheAdapter.java:607) > at org.apache.ignite.internal.processors.cache.GridCacheProxyImpl. > localLoadCache(GridCacheProxyImpl.java:217) > at org.apache.ignite.internal.processors.cache. > GridCacheAdapter$LoadCacheJob.localExecute(GridCacheAdapter.java:5467) > at org.apache.ignite.internal.processors.cache.GridCacheAdapter$ > LoadCacheJobV2.localExecute(GridCacheAdapter.java:5516) > at org.apache.ignite.internal.processors.cache.GridCacheAdapter$ > TopologyVersionAwareJob.execute(GridCacheAdapter.java:6131) > at org.apache.ignite.compute.ComputeJobAdapter.call( > ComputeJobAdapter.java:132) > at org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2. > execute(GridClosureProcessor.java:1855) > at org.apache.ignite.internal.processors.job.GridJobWorker$ > 2.call(GridJobWorker.java:566) > at org.apache.ignite.internal.util.IgniteUtils. > wrapThreadLoader(IgniteUtils.java:6631) > at org.apache.ignite.internal.processors.job.GridJobWorker. > execute0(GridJobWorker.java:560) > at org.apache.ignite.internal.processors.job.GridJobWorker. > body(GridJobWorker.java:489) > at org.apache.ignite.internal.util.worker.GridWorker.run( > GridWorker.java:110) > at org.apache.ignite.internal.processors.job.GridJobProcessor. > processJobExecuteRequest(GridJobProcessor.java:1115) > at org.apache.ignite.internal.processors.job.GridJobProcessor$ > JobExecutionListener.onMessage(GridJobProcessor.java:1913) > 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( > ThreadPoolExecutor.java:1149) > at java.util.concurrent.ThreadPoolExecutor$Worker.run( > ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:748) > Caused by: javax.cache.CacheException: Failed to read binary object: > com.harri.model.Position > at org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStore. > buildBinaryObject(CacheJdbcPojoStore.java:255) > at org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStore.buildObject( > CacheJdbcPojoStore.java:136) > at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$1. > call(CacheAbstractJdbcStore.java:467) > at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$1. > call(CacheAbstractJdbcStore.java:434) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > ... 3 more > *Caused by: java.sql.SQLException: Value ' 2058 cashier-retail Cashier��� > 10 1 2016-06-22 00:13:27 2017-02-10 23:19:09 0 0000-00-00 00:00:00 21�� ' > can not be represented as java.sql.Timestamp* > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861) > at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:937) > at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:559) > at com.mysql.jdbc.ResultSetImpl.getTimestampInternal( > ResultSetImpl.java:5921) > at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5591) > at org.apache.ignite.cache.store.jdbc.JdbcTypesDefaultTransformer. > getColumnValue(JdbcTypesDefaultTransformer.java:66) > at org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStore. > buildBinaryObject(CacheJdbcPojoStore.java:247) > ... 7 more > > > I checked that database and it is has no problem in formatting and the > displayed Value in the exception is a whole row. > > Please you advice. > BR > > > > This email, and the content it contains, are intended only for the persons > or entities to which it is addressed. It may contain sensitive, > confidential and/or privileged material. Any review, retransmission, > dissemination or other use of, or taking of any action in reliance upon, > this information by persons or entities other than the intended > recipient(s) is prohibited. If you received this email in error, please > immediately contact security[at]harri[dot]com and delete it from any device > or system on which it may be stored. >
