[java] 01:36:54,106 ERROR [org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore] (HotRodServerHandler-8-2) ISPN008024: Error while storing string key to database; key: '?8A09AJAAAAAAAAA==': java.sql.SQLSyntaxErrorException: ORA-00928: missing SELECT keyword [java] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) [java] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:910) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3865) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3845) [java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1061) [java] at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537) [java] at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.executeUpsert(JdbcStringBasedStore.java:160) [java] at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.write(JdbcStringBasedStore.java:145) [java] at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.write(JdbcStringBasedStore.java:125) [java] at org.infinispan.persistence.manager.PersistenceManagerImpl.lambda$writeToAllNonTxStores$9(PersistenceManagerImpl.java:514) [java] at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184) [java] at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:175) [java] at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:175) [java] at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1380) [java] at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481) [java] at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471) [java] at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151) [java] at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174) [java] at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) [java] at java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:418) [java] at org.infinispan.persistence.manager.PersistenceManagerImpl.writeToAllNonTxStores(PersistenceManagerImpl.java:514) [java] at org.infinispan.interceptors.impl.CacheWriterInterceptor.storeEntry(CacheWriterInterceptor.java:413) [java] at org.infinispan.interceptors.impl.CacheWriterInterceptor.lambda$visitPutKeyValueCommand$1(CacheWriterInterceptor.java:185) [java] at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextThenAccept(BaseAsyncInterceptor.java:108) [java] at org.infinispan.interceptors.impl.CacheWriterInterceptor.visitPutKeyValueCommand(CacheWriterInterceptor.java:177) [java] at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:79) [java] at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNext(BaseAsyncInterceptor.java:57) [java] at org.infinispan.interceptors.impl.CacheLoaderInterceptor.visitDataCommand(CacheLoaderInterceptor.java:196) [java] at org.infinispan.interceptors.impl.CacheLoaderInterceptor.visitPutKeyValueCommand(CacheLoaderInterceptor.java:133) [java] at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:79) [java] at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextThenAccept(BaseAsyncInterceptor.java:101) [java] at org.infinispan.interceptors.impl.EntryWrappingInterceptor.setSkipRemoteGetsAndInvokeNextForDataCommand(EntryWrappingInterceptor.java:664) [java] at org.infinispan.interceptors.impl.EntryWrappingInterceptor.visitPutKeyValueCommand(EntryWrappingInterceptor.java:304) [java] at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:79) [java] at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextAndFinally(BaseAsyncInterceptor.java:153) [java] at org.infinispan.interceptors.locking.AbstractLockingInterceptor.visitNonTxDataWriteCommand(AbstractLockingInterceptor.java:116) [java] at org.infinispan.interceptors.locking.NonTransactionalLockingInterceptor.visitDataWriteCommand(NonTransactionalLockingInterceptor.java:39) [java] at org.infinispan.interceptors.locking.AbstractLockingInterceptor.visitPutKeyValueCommand(AbstractLockingInterceptor.java:77) [java] at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:79) [java] at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextAndFinally(BaseAsyncInterceptor.java:153) [java] at org.infinispan.interceptors.impl.CacheMgmtInterceptor.updateStoreStatistics(CacheMgmtInterceptor.java:170) [java] at org.infinispan.interceptors.impl.CacheMgmtInterceptor.visitPutKeyValueCommand(CacheMgmtInterceptor.java:156) [java] at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:79) [java] at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextAndExceptionally(BaseAsyncInterceptor.java:126) [java] at org.infinispan.interceptors.impl.InvocationContextInterceptor.visitCommand(InvocationContextInterceptor.java:92) [java] at org.infinispan.interceptors.impl.AsyncInterceptorChainImpl.invoke(AsyncInterceptorChainImpl.java:281) [java] at org.infinispan.cache.impl.CacheImpl.executeCommandAndCommitIfNeeded(CacheImpl.java:1582) [java] at org.infinispan.cache.impl.CacheImpl.putInternal(CacheImpl.java:1208) [java] at org.infinispan.cache.impl.CacheImpl.put(CacheImpl.java:1198) [java] at org.infinispan.cache.impl.DecoratedCache.put(DecoratedCache.java:544) [java] at org.infinispan.cache.impl.AbstractDelegatingAdvancedCache.put(AbstractDelegatingAdvancedCache.java:305) [java] at org.infinispan.cache.impl.EncoderCache.put(EncoderCache.java:441) [java] at org.infinispan.cache.impl.AbstractDelegatingAdvancedCache.put(AbstractDelegatingAdvancedCache.java:305) [java] at org.infinispan.server.hotrod.CacheDecodeContext.put(CacheDecodeContext.java:422) [java] at org.infinispan.server.hotrod.ContextHandler.realRead(ContextHandler.java:66) [java] at org.infinispan.server.hotrod.ContextHandler.lambda$channelRead0$0(ContextHandler.java:53) [java] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [java] at io.netty.util.concurrent.DefaultThreadFactory$DefaultRunnableDecorator.run(DefaultThreadFactory.java:144) [java] at java.lang.Thread.run(Thread.java:748) [java] Caused by: Error : 928, Position : 39, Sql = MERGE INTO "EDG_STRING_default" USING (VALUES (:1 , :2 , :3 )) AS tmp (datum, version, id) ON (datum = tmp.datum) WHEN MATCHED THEN UPDATE SET version = tmp.version, id = tmp.id WHEN NOT MATCHED THEN INSERT (datum, version, id) VALUES (tmp.datum, tmp.version, tmp.id), OriginalSql = MERGE INTO "EDG_STRING_default" USING (VALUES (?, ?, ?)) AS tmp (datum, version, id) ON (datum = tmp.datum) WHEN MATCHED THEN UPDATE SET version = tmp.version, id = tmp.id WHEN NOT MATCHED THEN INSERT (datum, version, id) VALUES (tmp.datum, tmp.version, tmp.id), Error Msg = ORA-00928: missing SELECT keyword [java] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) [java] ... 69 more [java] 01:36:54,110 ERROR [org.infinispan.interceptors.impl.InvocationContextInterceptor] (HotRodServerHandler-8-2) ISPN000136: Error executing command PutKeyValueCommand, writing keys [WrappedByteArray{bytes=0x034F4024000000000000, hashCode=-1685400495}]: org.infinispan.persistence.spi.PersistenceException: Error while storing string key to database; key: '?8A09AJAAAAAAAAA==' [java] at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.write(JdbcStringBasedStore.java:128) [java] at org.infinispan.persistence.manager.PersistenceManagerImpl.lambda$writeToAllNonTxStores$9(PersistenceManagerImpl.java:514) [java] at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184) [java] at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:175) [java] at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:175) [java] at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1380) [java] at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481) [java] at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471) [java] at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151) [java] at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174) [java] at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) [java] at java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:418) [java] at org.infinispan.persistence.manager.PersistenceManagerImpl.writeToAllNonTxStores(PersistenceManagerImpl.java:514) [java] at org.infinispan.interceptors.impl.CacheWriterInterceptor.storeEntry(CacheWriterInterceptor.java:413) [java] at org.infinispan.interceptors.impl.CacheWriterInterceptor.lambda$visitPutKeyValueCommand$1(CacheWriterInterceptor.java:185) [java] at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextThenAccept(BaseAsyncInterceptor.java:108) [java] at org.infinispan.interceptors.impl.CacheWriterInterceptor.visitPutKeyValueCommand(CacheWriterInterceptor.java:177) [java] at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:79) [java] at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNext(BaseAsyncInterceptor.java:57) [java] at org.infinispan.interceptors.impl.CacheLoaderInterceptor.visitDataCommand(CacheLoaderInterceptor.java:196) [java] at org.infinispan.interceptors.impl.CacheLoaderInterceptor.visitPutKeyValueCommand(CacheLoaderInterceptor.java:133) [java] at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:79) [java] at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextThenAccept(BaseAsyncInterceptor.java:101) [java] at org.infinispan.interceptors.impl.EntryWrappingInterceptor.setSkipRemoteGetsAndInvokeNextForDataCommand(EntryWrappingInterceptor.java:664) [java] at org.infinispan.interceptors.impl.EntryWrappingInterceptor.visitPutKeyValueCommand(EntryWrappingInterceptor.java:304) [java] at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:79) [java] at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextAndFinally(BaseAsyncInterceptor.java:153) [java] at org.infinispan.interceptors.locking.AbstractLockingInterceptor.visitNonTxDataWriteCommand(AbstractLockingInterceptor.java:116) [java] at org.infinispan.interceptors.locking.NonTransactionalLockingInterceptor.visitDataWriteCommand(NonTransactionalLockingInterceptor.java:39) [java] at org.infinispan.interceptors.locking.AbstractLockingInterceptor.visitPutKeyValueCommand(AbstractLockingInterceptor.java:77) [java] at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:79) [java] at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextAndFinally(BaseAsyncInterceptor.java:153) [java] at org.infinispan.interceptors.impl.CacheMgmtInterceptor.updateStoreStatistics(CacheMgmtInterceptor.java:170) [java] at org.infinispan.interceptors.impl.CacheMgmtInterceptor.visitPutKeyValueCommand(CacheMgmtInterceptor.java:156) [java] at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:79) [java] at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextAndExceptionally(BaseAsyncInterceptor.java:126) [java] at org.infinispan.interceptors.impl.InvocationContextInterceptor.visitCommand(InvocationContextInterceptor.java:92) [java] at org.infinispan.interceptors.impl.AsyncInterceptorChainImpl.invoke(AsyncInterceptorChainImpl.java:281) [java] at org.infinispan.cache.impl.CacheImpl.executeCommandAndCommitIfNeeded(CacheImpl.java:1582) [java] at org.infinispan.cache.impl.CacheImpl.putInternal(CacheImpl.java:1208) [java] at org.infinispan.cache.impl.CacheImpl.put(CacheImpl.java:1198) [java] at org.infinispan.cache.impl.DecoratedCache.put(DecoratedCache.java:544) [java] at org.infinispan.cache.impl.AbstractDelegatingAdvancedCache.put(AbstractDelegatingAdvancedCache.java:305) [java] at org.infinispan.cache.impl.EncoderCache.put(EncoderCache.java:441) [java] at org.infinispan.cache.impl.AbstractDelegatingAdvancedCache.put(AbstractDelegatingAdvancedCache.java:305) [java] at org.infinispan.server.hotrod.CacheDecodeContext.put(CacheDecodeContext.java:422) [java] at org.infinispan.server.hotrod.ContextHandler.realRead(ContextHandler.java:66) [java] at org.infinispan.server.hotrod.ContextHandler.lambda$channelRead0$0(ContextHandler.java:53) [java] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [java] at io.netty.util.concurrent.DefaultThreadFactory$DefaultRunnableDecorator.run(DefaultThreadFactory.java:144) [java] at java.lang.Thread.run(Thread.java:748) [java] Caused by: java.sql.SQLSyntaxErrorException: ORA-00928: missing SELECT keyword [java] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) [java] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:910) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3865) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3845) [java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1061) [java] at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537) [java] at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.executeUpsert(JdbcStringBasedStore.java:160) [java] at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.write(JdbcStringBasedStore.java:145) [java] at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.write(JdbcStringBasedStore.java:125) [java] ... 51 more [java] Caused by: Error : 928, Position : 39, Sql = MERGE INTO "EDG_STRING_default" USING (VALUES (:1 , :2 , :3 )) AS tmp (datum, version, id) ON (datum = tmp.datum) WHEN MATCHED THEN UPDATE SET version = tmp.version, id = tmp.id WHEN NOT MATCHED THEN INSERT (datum, version, id) VALUES (tmp.datum, tmp.version, tmp.id), OriginalSql = MERGE INTO "EDG_STRING_default" USING (VALUES (?, ?, ?)) AS tmp (datum, version, id) ON (datum = tmp.datum) WHEN MATCHED THEN UPDATE SET version = tmp.version, id = tmp.id WHEN NOT MATCHED THEN INSERT (datum, version, id) VALUES (tmp.datum, tmp.version, tmp.id), Error Msg = ORA-00928: missing SELECT keyword [java] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) [java] ... 69 more