You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by rishi007bansod <ri...@gmail.com> on 2016/12/27 10:05:21 UTC
Error while writing to oracle DB
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.
Re: Error while writing to oracle DB
Posted by rishi007bansod <ri...@gmail.com>.
Thanks, increasing number of processes solved my problem.
--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Error-while-writing-to-oracle-DB-tp9740p9771.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Re: Error while writing to oracle DB
Posted by Vladislav Pyatkov <vl...@gmail.com>.
Hi,
It means, which your Oracle server has not appropriate listener
configured[1].
Please configure you rdbms, using lsnrctl utility.
[1]:
http://www.dba-oracle.com/sf_ora_12519_tns_no_appropriate_service_handler_found.htm
On Tue, Dec 27, 2016 at 1:05 PM, rishi007bansod <ri...@gmail.com>
wrote:
> 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.CachePartialUpdateCheckedExcep
> tion:
> 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.CachePartialUpdateCheckedExcep
> tion:
> 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(GridNearAtomicSingleUpdateFutu
> re.java:232)
> at
> org.apache.ignite.internal.processors.cache.distributed.dht.atomic.
> GridNearAtomicSingleUpdateFuture$3.apply(GridNearAtomicSingleUpdateFutu
> re.java:455)
> at
> org.apache.ignite.internal.processors.cache.distributed.dht.atomic.
> GridNearAtomicSingleUpdateFuture$3.apply(GridNearAtomicSingleUpdateFutu
> re.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(GridNearAtomicSingleUpdateFutu
> re.java:452)
> at
> org.apache.ignite.internal.processors.cache.distributed.dht.atomic.
> GridNearAtomicSingleUpdateFuture.map(GridNearAtomicSingleUpdateFutu
> re.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(GridNearAtomicAbstractUpdateFu
> ture.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.
>
--
Vladislav Pyatkov