Loading...

XML

Word

Printable

Details

Type: Bug
Resolution: Done
Priority: Major
Fix Version/s: 9.0.0.Final
Affects Version/s: 9.0.0.CR4
Component/s: Loaders and Stores
Labels:
None

Workaround:

Workaround Exists
Workaround Description:

Hide

Disable upsert by setting the following property on the store `<property name="infinispan.jdbc.upsert.disabled">true</property>`

Show
Disable upsert by setting the following property on the store `<property name="infinispan.jdbc.upsert.disabled">true</property>`
Git Pull Request:
https://github.com/infinispan/infinispan/pull/5038

Description

Writes to the underlying JDBC store fail with the following exception:

14:50:01.919 [main] ERROR org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore - ISPN008024: Error while storing string key to database; key: '41'
com.sybase.jdbc4.jdbc.SybSQLException: Incorrect syntax near the keyword 'VALUES'.

	at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4131) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
	at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3247) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
	at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:294) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:276) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
	at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2749) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
	at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2733) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
	at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:335) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) ~[HikariCP-2.4.6.jar:?]
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) ~[HikariCP-2.4.6.jar:?]
	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.executeUpsert(JdbcStringBasedStore.java:224) ~[infinispan-cachestore-jdbc-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.write(JdbcStringBasedStore.java:209) ~[infinispan-cachestore-jdbc-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.write(JdbcStringBasedStore.java:189) ~[infinispan-cachestore-jdbc-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.persistence.manager.PersistenceManagerImpl.lambda$writeToAllNonTxStores$9(PersistenceManagerImpl.java:518) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184) ~[?:1.8.0_112]
	at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:175) ~[?:1.8.0_112]
	at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:175) ~[?:1.8.0_112]
	at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1374) ~[?:1.8.0_112]
	at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481) ~[?:1.8.0_112]
	at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471) ~[?:1.8.0_112]
	at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151) ~[?:1.8.0_112]
	at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174) ~[?:1.8.0_112]
	at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) ~[?:1.8.0_112]
	at java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:418) ~[?:1.8.0_112]
	at org.infinispan.persistence.manager.PersistenceManagerImpl.writeToAllNonTxStores(PersistenceManagerImpl.java:518) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.impl.CacheWriterInterceptor.storeEntry(CacheWriterInterceptor.java:480) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.impl.CacheWriterInterceptor.lambda$visitPutKeyValueCommand$1(CacheWriterInterceptor.java:189) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextThenAccept(BaseAsyncInterceptor.java:108) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.impl.CacheWriterInterceptor.visitPutKeyValueCommand(CacheWriterInterceptor.java:181) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNext(BaseAsyncInterceptor.java:57) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.impl.CacheLoaderInterceptor.visitDataCommand(CacheLoaderInterceptor.java:196) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.impl.CacheLoaderInterceptor.visitPutKeyValueCommand(CacheLoaderInterceptor.java:133) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextThenAccept(BaseAsyncInterceptor.java:101) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.impl.EntryWrappingInterceptor.setSkipRemoteGetsAndInvokeNextForDataCommand(EntryWrappingInterceptor.java:675) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.impl.EntryWrappingInterceptor.visitPutKeyValueCommand(EntryWrappingInterceptor.java:303) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextAndFinally(BaseAsyncInterceptor.java:153) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.locking.AbstractLockingInterceptor.visitNonTxDataWriteCommand(AbstractLockingInterceptor.java:116) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.locking.NonTransactionalLockingInterceptor.visitDataWriteCommand(NonTransactionalLockingInterceptor.java:39) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.locking.AbstractLockingInterceptor.visitPutKeyValueCommand(AbstractLockingInterceptor.java:77) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNext(BaseAsyncInterceptor.java:57) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.impl.CacheMgmtInterceptor.updateStoreStatistics(CacheMgmtInterceptor.java:167) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.impl.CacheMgmtInterceptor.visitPutKeyValueCommand(CacheMgmtInterceptor.java:156) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextAndExceptionally(BaseAsyncInterceptor.java:126) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.impl.InvocationContextInterceptor.visitCommand(InvocationContextInterceptor.java:94) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.impl.AsyncInterceptorChainImpl.invoke(AsyncInterceptorChainImpl.java:248) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.cache.impl.CacheImpl.executeCommandAndCommitIfNeeded(CacheImpl.java:1489) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.cache.impl.CacheImpl.putInternal(CacheImpl.java:1120) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.cache.impl.CacheImpl.put(CacheImpl.java:1110) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.cache.impl.CacheImpl.put(CacheImpl.java:1559) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.cache.impl.CacheImpl.put(CacheImpl.java:249) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.cache.impl.AbstractDelegatingCache.put(AbstractDelegatingCache.java:358) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.cache.impl.TypeConverterDelegatingAdvancedCache.put(TypeConverterDelegatingAdvancedCache.java:173) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.jboss.set.JdbcWriter.main(JdbcWriter.java:18) [classes/:?]
14:50:01.931 [main] ERROR org.infinispan.interceptors.impl.InvocationContextInterceptor - ISPN000136: Error executing command PutKeyValueCommand, writing keys [1]
org.infinispan.persistence.spi.PersistenceException: Error while storing string key to database; key: '41'
	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.write(JdbcStringBasedStore.java:192) ~[infinispan-cachestore-jdbc-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.persistence.manager.PersistenceManagerImpl.lambda$writeToAllNonTxStores$9(PersistenceManagerImpl.java:518) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184) ~[?:1.8.0_112]
	at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:175) ~[?:1.8.0_112]
	at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:175) ~[?:1.8.0_112]
	at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1374) ~[?:1.8.0_112]
	at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481) ~[?:1.8.0_112]
	at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471) ~[?:1.8.0_112]
	at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151) ~[?:1.8.0_112]
	at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174) ~[?:1.8.0_112]
	at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) ~[?:1.8.0_112]
	at java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:418) ~[?:1.8.0_112]
	at org.infinispan.persistence.manager.PersistenceManagerImpl.writeToAllNonTxStores(PersistenceManagerImpl.java:518) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.impl.CacheWriterInterceptor.storeEntry(CacheWriterInterceptor.java:480) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.impl.CacheWriterInterceptor.lambda$visitPutKeyValueCommand$1(CacheWriterInterceptor.java:189) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextThenAccept(BaseAsyncInterceptor.java:108) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.impl.CacheWriterInterceptor.visitPutKeyValueCommand(CacheWriterInterceptor.java:181) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNext(BaseAsyncInterceptor.java:57) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.impl.CacheLoaderInterceptor.visitDataCommand(CacheLoaderInterceptor.java:196) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.impl.CacheLoaderInterceptor.visitPutKeyValueCommand(CacheLoaderInterceptor.java:133) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextThenAccept(BaseAsyncInterceptor.java:101) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.impl.EntryWrappingInterceptor.setSkipRemoteGetsAndInvokeNextForDataCommand(EntryWrappingInterceptor.java:675) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.impl.EntryWrappingInterceptor.visitPutKeyValueCommand(EntryWrappingInterceptor.java:303) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextAndFinally(BaseAsyncInterceptor.java:153) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.locking.AbstractLockingInterceptor.visitNonTxDataWriteCommand(AbstractLockingInterceptor.java:116) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.locking.NonTransactionalLockingInterceptor.visitDataWriteCommand(NonTransactionalLockingInterceptor.java:39) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.locking.AbstractLockingInterceptor.visitPutKeyValueCommand(AbstractLockingInterceptor.java:77) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNext(BaseAsyncInterceptor.java:57) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.impl.CacheMgmtInterceptor.updateStoreStatistics(CacheMgmtInterceptor.java:167) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.impl.CacheMgmtInterceptor.visitPutKeyValueCommand(CacheMgmtInterceptor.java:156) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextAndExceptionally(BaseAsyncInterceptor.java:126) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.impl.InvocationContextInterceptor.visitCommand(InvocationContextInterceptor.java:94) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.interceptors.impl.AsyncInterceptorChainImpl.invoke(AsyncInterceptorChainImpl.java:248) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.cache.impl.CacheImpl.executeCommandAndCommitIfNeeded(CacheImpl.java:1489) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.cache.impl.CacheImpl.putInternal(CacheImpl.java:1120) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.cache.impl.CacheImpl.put(CacheImpl.java:1110) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.cache.impl.CacheImpl.put(CacheImpl.java:1559) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.cache.impl.CacheImpl.put(CacheImpl.java:249) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.cache.impl.AbstractDelegatingCache.put(AbstractDelegatingCache.java:358) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.cache.impl.TypeConverterDelegatingAdvancedCache.put(TypeConverterDelegatingAdvancedCache.java:173) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
	at org.jboss.set.JdbcWriter.main(JdbcWriter.java:18) [classes/:?]
Caused by: com.sybase.jdbc4.jdbc.SybSQLException: Incorrect syntax near the keyword 'VALUES'.

	at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4131) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
	at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3247) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
	at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:294) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:276) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
	at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2749) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
	at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2733) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
	at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:335) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) ~[HikariCP-2.4.6.jar:?]
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) ~[HikariCP-2.4.6.jar:?]
	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.executeUpsert(JdbcStringBasedStore.java:224) ~[infinispan-cachestore-jdbc-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.write(JdbcStringBasedStore.java:209) ~[infinispan-cachestore-jdbc-9.0.0.CR4.jar:9.0.0.CR4]
	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.write(JdbcStringBasedStore.java:189) ~[infinispan-cachestore-jdbc-9.0.0.CR4.jar:9.0.0.CR4]
	... 45 more
Exception in thread "main" org.infinispan.persistence.spi.PersistenceException: Error while storing string key to database; key: '41'
	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.write(JdbcStringBasedStore.java:192)
	at org.infinispan.persistence.manager.PersistenceManagerImpl.lambda$writeToAllNonTxStores$9(PersistenceManagerImpl.java:518)
	at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
	at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:175)
	at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:175)
	at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1374)
	at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481)
	at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471)
	at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
	at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
	at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:418)
	at org.infinispan.persistence.manager.PersistenceManagerImpl.writeToAllNonTxStores(PersistenceManagerImpl.java:518)
	at org.infinispan.interceptors.impl.CacheWriterInterceptor.storeEntry(CacheWriterInterceptor.java:480)
	at org.infinispan.interceptors.impl.CacheWriterInterceptor.lambda$visitPutKeyValueCommand$1(CacheWriterInterceptor.java:189)
	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextThenAccept(BaseAsyncInterceptor.java:108)
	at org.infinispan.interceptors.impl.CacheWriterInterceptor.visitPutKeyValueCommand(CacheWriterInterceptor.java:181)
	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74)
	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNext(BaseAsyncInterceptor.java:57)
	at org.infinispan.interceptors.impl.CacheLoaderInterceptor.visitDataCommand(CacheLoaderInterceptor.java:196)
	at org.infinispan.interceptors.impl.CacheLoaderInterceptor.visitPutKeyValueCommand(CacheLoaderInterceptor.java:133)
	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74)
	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextThenAccept(BaseAsyncInterceptor.java:101)
	at org.infinispan.interceptors.impl.EntryWrappingInterceptor.setSkipRemoteGetsAndInvokeNextForDataCommand(EntryWrappingInterceptor.java:675)
	at org.infinispan.interceptors.impl.EntryWrappingInterceptor.visitPutKeyValueCommand(EntryWrappingInterceptor.java:303)
	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74)
	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextAndFinally(BaseAsyncInterceptor.java:153)
	at org.infinispan.interceptors.locking.AbstractLockingInterceptor.visitNonTxDataWriteCommand(AbstractLockingInterceptor.java:116)
	at org.infinispan.interceptors.locking.NonTransactionalLockingInterceptor.visitDataWriteCommand(NonTransactionalLockingInterceptor.java:39)
	at org.infinispan.interceptors.locking.AbstractLockingInterceptor.visitPutKeyValueCommand(AbstractLockingInterceptor.java:77)
	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74)
	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNext(BaseAsyncInterceptor.java:57)
	at org.infinispan.interceptors.impl.CacheMgmtInterceptor.updateStoreStatistics(CacheMgmtInterceptor.java:167)
	at org.infinispan.interceptors.impl.CacheMgmtInterceptor.visitPutKeyValueCommand(CacheMgmtInterceptor.java:156)
	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74)
	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextAndExceptionally(BaseAsyncInterceptor.java:126)
	at org.infinispan.interceptors.impl.InvocationContextInterceptor.visitCommand(InvocationContextInterceptor.java:94)
	at org.infinispan.interceptors.impl.AsyncInterceptorChainImpl.invoke(AsyncInterceptorChainImpl.java:248)
	at org.infinispan.cache.impl.CacheImpl.executeCommandAndCommitIfNeeded(CacheImpl.java:1489)
	at org.infinispan.cache.impl.CacheImpl.putInternal(CacheImpl.java:1120)
	at org.infinispan.cache.impl.CacheImpl.put(CacheImpl.java:1110)
	at org.infinispan.cache.impl.CacheImpl.put(CacheImpl.java:1559)
	at org.infinispan.cache.impl.CacheImpl.put(CacheImpl.java:249)
	at org.infinispan.cache.impl.AbstractDelegatingCache.put(AbstractDelegatingCache.java:358)
	at org.infinispan.cache.impl.TypeConverterDelegatingAdvancedCache.put(TypeConverterDelegatingAdvancedCache.java:173)
	at org.jboss.set.JdbcWriter.main(JdbcWriter.java:18)
Caused by: com.sybase.jdbc4.jdbc.SybSQLException: Incorrect syntax near the keyword 'VALUES'.

	at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4131)
	at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3247)
	at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:294)
	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:276)
	at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2749)
	at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2733)
	at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:335)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.executeUpsert(JdbcStringBasedStore.java:224)
	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.write(JdbcStringBasedStore.java:209)
	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.write(JdbcStringBasedStore.java:189)
	... 45 more

Attachments

Activity

People

Assignee:: Ryan Emerson

Reporter:: Ryan Emerson

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2017/03/29 9:51 AM

Updated:: 2020/02/07 5:55 AM

Resolved:: 2017/03/29 3:10 PM