ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rishi007bansod <rishi007ban...@gmail.com>
Subject Error while writing to oracle DB
Date Tue, 27 Dec 2016 10:05:21 GMT
When I enable writethrough operation to oracle DB and writebehind operation
is disabled, I am getting following error:

Exception in thread "main" javax.cache.integration.CacheWriterException:
class
org.apache.ignite.internal.processors.cache.CachePartialUpdateCheckedException:
Failed to update keys (retry update if possible).: [Orders5Key [oId=3015,
oDId=7, oWId=4]]
	at
org.apache.ignite.internal.processors.cache.GridCacheUtils.convertToCacheException(GridCacheUtils.java:1485)
	at
org.apache.ignite.internal.processors.cache.IgniteCacheProxy.cacheException(IgniteCacheProxy.java:2021)
	at
org.apache.ignite.internal.processors.cache.IgniteCacheProxy.put(IgniteCacheProxy.java:1221)
	at test370.new_order(test370.java:765)
	at test370.main(test370.java:477)
Caused by: class
org.apache.ignite.internal.processors.cache.CachePartialUpdateCheckedException:
Failed to update keys (retry update if possible).: [Orders5Key [oId=3015,
oDId=7, oWId=4]]
	at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicSingleUpdateFuture.onResult(GridNearAtomicSingleUpdateFuture.java:232)
	at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicSingleUpdateFuture$3.apply(GridNearAtomicSingleUpdateFuture.java:455)
	at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicSingleUpdateFuture$3.apply(GridNearAtomicSingleUpdateFuture.java:453)
	at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.updateAllAsyncInternal0(GridDhtAtomicCache.java:1744)
	at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.updateAllAsyncInternal(GridDhtAtomicCache.java:1490)
	at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicSingleUpdateFuture.mapSingle(GridNearAtomicSingleUpdateFuture.java:452)
	at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicSingleUpdateFuture.map(GridNearAtomicSingleUpdateFuture.java:569)
	at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicSingleUpdateFuture.mapOnTopology(GridNearAtomicSingleUpdateFuture.java:441)
	at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicAbstractUpdateFuture.map(GridNearAtomicAbstractUpdateFuture.java:207)
	at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache$22.apply(GridDhtAtomicCache.java:1015)
	at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache$22.apply(GridDhtAtomicCache.java:1013)
	at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.asyncOp(GridDhtAtomicCache.java:711)
	at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.updateAsync0(GridDhtAtomicCache.java:1013)
	at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.putAsync0(GridDhtAtomicCache.java:483)
	at
org.apache.ignite.internal.processors.cache.GridCacheAdapter.putAsync(GridCacheAdapter.java:2541)
	at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.put(GridDhtAtomicCache.java:460)
	at
org.apache.ignite.internal.processors.cache.GridCacheAdapter.put(GridCacheAdapter.java:2215)
	at
org.apache.ignite.internal.processors.cache.IgniteCacheProxy.put(IgniteCacheProxy.java:1214)
	... 2 more
	Suppressed: class org.apache.ignite.IgniteCheckedException: Failed to
update keys on primary node.
		at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicUpdateResponse.addFailedKey(GridNearAtomicUpdateResponse.java:350)
		at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.updateSingle(GridDhtAtomicCache.java:2393)
		at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.updateAllAsyncInternal0(GridDhtAtomicCache.java:1652)
		... 16 more
		Suppressed: class org.apache.ignite.IgniteCheckedException: Failed to
write entry to database [table=C##TPCCTEST.ORDERS5, entry=Entry
[key=Orders5Key [oId=3015, oDId=7, oWId=4], val=Orders5 [oId=3015, oDId=7,
oWId=4, oCId=2020, oEntryD=2016-12-27 15:04:34.172, oCarrierId=null,
oOlCnt=12, oAllLocal=1]]]
			at
org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.put(GridCacheStoreManagerAdapter.java:583)
			at
org.apache.ignite.internal.processors.cache.GridCacheMapEntry.innerUpdate(GridCacheMapEntry.java:2425)
			at
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.updateSingle(GridDhtAtomicCache.java:2252)
			... 17 more
		Caused by: javax.cache.integration.CacheWriterException: Failed to write
entry to database [table=C##TPCCTEST.ORDERS5, entry=Entry [key=Orders5Key
[oId=3015, oDId=7, oWId=4], val=Orders5 [oId=3015, oDId=7, oWId=4,
oCId=2020, oEntryD=2016-12-27 15:04:34.172, oCarrierId=null, oOlCnt=12,
oAllLocal=1]]]
			at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.write(CacheAbstractJdbcStore.java:1020)
			at
org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.put(GridCacheStoreManagerAdapter.java:575)
			... 19 more
		Caused by: java.sql.SQLException: Listener refused the connection with the
following error:
ORA-12519, TNS:no appropriate service handler found
 
			at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:673)
			at
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:711)
			at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385)
			at
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30)
			at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:558)
			at
oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:297)
			at
oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:224)
			at
oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:169)
			at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.openConnection(CacheAbstractJdbcStore.java:322)
			at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.connection(CacheAbstractJdbcStore.java:352)
			at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.write(CacheAbstractJdbcStore.java:978)
			... 20 more
		Caused by: oracle.net.ns.NetException: Listener refused the connection
with the following error:
ORA-12519, TNS:no appropriate service handler found
 
			at
oracle.net.ns.NSProtocolStream.negotiateConnection(NSProtocolStream.java:272)
			at oracle.net.ns.NSProtocol.connect(NSProtocol.java:263)
			at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1360)
			at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:486)
			... 30 more

What can be cause for this error? 



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Error-while-writing-to-oracle-DB-tp9740.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Mime
View raw message