10:16 a.m.
JDBCCacheLoader does not delete DB table properly
-------------------------------------------------
Key: JBCACHE-1118
URL: http://jira.jboss.com/jira/browse/JBCACHE-1118
Project: JBoss Cache
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: MonthOfBugs_200
Affects Versions: 2.0.0.CR1
Reporter: gmeroz
Assigned To: Manik Surtani
Attachments: cache.xml
when removing items from the cache, records which start with the
"/__JBossInternal__" prefix are not deleted from the cache table in the DB.
see attached code which reproduce it...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:16 a.m.
New subject: [JBoss JIRA] Updated: (JBCACHE-1118) JDBCCacheLoader does not delete DB table properly
[ http://jira.jboss.com/jira/browse/JBCACHE-1118?page=all ]
gmeroz updated JBCACHE-1118:
----------------------------
Attachment: cache.xml
JDBCCacheLoader does not delete DB table properly
-------------------------------------------------
Key: JBCACHE-1118
URL: http://jira.jboss.com/jira/browse/JBCACHE-1118
Project: JBoss Cache
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: MonthOfBugs_200
Affects Versions: 2.0.0.CR1
Reporter: gmeroz
Assigned To: Manik Surtani
Attachments: cache.xml
when removing items from the cache, records which start with the
"/__JBossInternal__" prefix are not deleted from the cache table in the DB.
see attached code which reproduce it...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:19 a.m.
New subject: [JBoss JIRA] Updated: (JBCACHE-1118) JDBCCacheLoader does not delete DB table properly
[ http://jira.jboss.com/jira/browse/JBCACHE-1118?page=all ]
gmeroz updated JBCACHE-1118:
----------------------------
Attachment: JDBCCacheLoderTest.java
JDBCCacheLoader does not delete DB table properly
-------------------------------------------------
Key: JBCACHE-1118
URL: http://jira.jboss.com/jira/browse/JBCACHE-1118
Project: JBoss Cache
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: MonthOfBugs_200
Affects Versions: 2.0.0.CR1
Reporter: gmeroz
Assigned To: Manik Surtani
Attachments: cache.xml, JDBCCacheLoderTest.java
when removing items from the cache, records which start with the
"/__JBossInternal__" prefix are not deleted from the cache table in the DB.
see attached code which reproduce it...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:11 p.m.
New subject: [JBoss JIRA] Updated: (JBCACHE-1118) JDBCCacheLoader does not delete DB table properly
[ http://jira.jboss.com/jira/browse/JBCACHE-1118?page=all ]
Brian Stansberry updated JBCACHE-1118:
--------------------------------------
Component/s: PojoCache
JDBCCacheLoader does not delete DB table properly
-------------------------------------------------
Key: JBCACHE-1118
URL: http://jira.jboss.com/jira/browse/JBCACHE-1118
Project: JBoss Cache
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: PojoCache, MonthOfBugs_200
Affects Versions: 2.0.0.CR1
Reporter: gmeroz
Assigned To: Manik Surtani
Attachments: cache.xml, JDBCCacheLoderTest.java
when removing items from the cache, records which start with the
"/__JBossInternal__" prefix are not deleted from the cache table in the DB.
see attached code which reproduce it...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:14 p.m.
New subject: [JBoss JIRA] Updated: (JBCACHE-1118) JDBCCacheLoader does not delete DB table properly
[ http://jira.jboss.com/jira/browse/JBCACHE-1118?page=all ]
Brian Stansberry updated JBCACHE-1118:
--------------------------------------
Component/s: Cache loaders
JDBCCacheLoader does not delete DB table properly
-------------------------------------------------
Key: JBCACHE-1118
URL: http://jira.jboss.com/jira/browse/JBCACHE-1118
Project: JBoss Cache
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: PojoCache, Cache loaders, MonthOfBugs_200
Affects Versions: 2.0.0.CR1
Reporter: gmeroz
Assigned To: Manik Surtani
Attachments: cache.xml, JDBCCacheLoderTest.java
when removing items from the cache, records which start with the
"/__JBossInternal__" prefix are not deleted from the cache table in the DB.
see attached code which reproduce it...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:20 p.m.
New subject: [JBoss JIRA] Commented: (JBCACHE-1118) JDBCCacheLoader does not delete DB table properly
[ http://jira.jboss.com/jira/browse/JBCACHE-1118?page=comments#action_12368820 ]
Jason T. Greene commented on JBCACHE-1118:
------------------------------------------
The cache loader is behaving correctly. The issue you are seeing is that the cache itself
has empty parent nodes.
For performance reasons, it's normal for both JBossCache and POJO Cache to leave empty
parent nodes around. If we were to cleanup empty parent nodes it would be a significant
performance cost because in order to do it safely we would have to always lock a parent
node for all child insert and delete operations (not just the cleanup operation, for
everything).
Right now the only way to do this is for the application to ensure all inserts have
stopped, and at that time find and remove all empty nodes.
Is there a reason why you have created this as cache loader issue. What is the problem
that you encounter (besides there being some extra rows)?
-Jason
JDBCCacheLoader does not delete DB table properly
-------------------------------------------------
Key: JBCACHE-1118
URL: http://jira.jboss.com/jira/browse/JBCACHE-1118
Project: JBoss Cache
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: PojoCache, Cache loaders, MonthOfBugs_200
Affects Versions: 2.0.0.CR1
Reporter: gmeroz
Assigned To: Manik Surtani
Attachments: cache.xml, JDBCCacheLoderTest.java
when removing items from the cache, records which start with the
"/__JBossInternal__" prefix are not deleted from the cache table in the DB.
see attached code which reproduce it...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:22 p.m.
New subject: [JBoss JIRA] Updated: (JBCACHE-1118) JBossCache and POJO Cache leave empty parent nodes around
[ http://jira.jboss.com/jira/browse/JBCACHE-1118?page=all ]
Jason T. Greene updated JBCACHE-1118:
-------------------------------------
Summary: JBossCache and POJO Cache leave empty parent nodes around (was:
JDBCCacheLoader does not delete DB table properly)
JBossCache and POJO Cache leave empty parent nodes around
---------------------------------------------------------
Key: JBCACHE-1118
URL: http://jira.jboss.com/jira/browse/JBCACHE-1118
Project: JBoss Cache
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: PojoCache, Cache loaders, MonthOfBugs_200
Affects Versions: 2.0.0.CR1
Reporter: gmeroz
Assigned To: Manik Surtani
Attachments: cache.xml, JDBCCacheLoderTest.java
when removing items from the cache, records which start with the
"/__JBossInternal__" prefix are not deleted from the cache table in the DB.
see attached code which reproduce it...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:25 a.m.
New subject: [JBoss JIRA] Commented: (JBCACHE-1118) JBossCache and POJO Cache leave empty parent nodes around
[ http://jira.jboss.com/jira/browse/JBCACHE-1118?page=comments#action_12368861 ]
gmeroz commented on JBCACHE-1118:
---------------------------------
yes, there is a reason:
sometimes i need to reload the cache. in this case i delete all the nodes from the cache,
than i start inseting data again. i always check if the node is already in the cache
before inserting it, and i get the following error:
2007-05-02 09:00:52,155 ERROR
[com.bevents.application.eventaccess.server.manager.cache.NodeQueryCacheImpl] Fatal error,
terminating cache
org.jboss.cache.pojo.PojoCacheException: find
/aag/queries/d3-0-d4-49-d5-0-d6-2-d8-15-d9-30-d19-2-24-4/queryDefinition8-null-SIBLINGS-7-7
failed
at
org.jboss.cache.pojo.impl.PojoCacheImpl.org$jboss$cache$pojo$impl$PojoCacheImpl$find$aop(PojoCacheImpl.java:196)
at
org.jboss.cache.pojo.impl.PojoCacheImpl$PojoCacheImplAdvisor.find_N_7063709169143275953(PojoCacheImpl$PojoCacheImplAdvisor.java)
at org.jboss.cache.pojo.impl.PojoCacheImpl.find(PojoCacheImpl.java)
at org.jboss.cache.pojo.impl.PojoCacheImpl.find(PojoCacheImpl.java:184)
at com.bevents.infra.service.cache.JBossCacheImpl.get(JBossCacheImpl.java:42)
at
com.bevents.application.eventaccess.server.manager.cache.NodeQueryCacheImpl.cacheNodesAndIfNeededSignForPersist(NodeQueryCacheImpl.java:438)
at
com.bevents.application.eventaccess.server.manager.cache.NodeQueryCacheImpl.cacheChunck(NodeQueryCacheImpl.java:513)
at
com.bevents.application.eventaccess.server.manager.cache.NodeQueryCacheImpl.access$000(NodeQueryCacheImpl.java:53)
at
com.bevents.application.eventaccess.server.manager.cache.NodeQueryCacheImpl$CacheJob.run(NodeQueryCacheImpl.java:162)
at
com.bevents.application.eventaccess.server.manager.cache.NodeQueryCacheImpl.cacheNextChunck(NodeQueryCacheImpl.java:584)
at
com.bevents.application.eventaccess.server.manager.cache.NodeQueryCacheImpl$CacheTimerTask.run(NodeQueryCacheImpl.java:1001)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
Caused by: org.jboss.cache.lock.TimeoutException: failure acquiring lock: fqn=/aag,
caller=Thread[Timer-9,5,jboss], lock=write owner=GlobalTransaction:<null>:5
(org.jboss.cache.lock.LockStrategyReadCommitted@99fd98)
at org.jboss.cache.lock.IdentityLock.acquire(IdentityLock.java:528)
at
org.jboss.cache.interceptors.PessimisticLockInterceptor$LockManager.acquire(PessimisticLockInterceptor.java:577)
at
org.jboss.cache.interceptors.PessimisticLockInterceptor.acquireNodeLock(PessimisticLockInterceptor.java:391)
at
org.jboss.cache.interceptors.PessimisticLockInterceptor.lock(PessimisticLockInterceptor.java:328)
at
org.jboss.cache.interceptors.PessimisticLockInterceptor.invoke(PessimisticLockInterceptor.java:178)
at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:75)
at
org.jboss.cache.interceptors.CacheLoaderInterceptor.invoke(CacheLoaderInterceptor.java:157)
at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:75)
at org.jboss.cache.interceptors.UnlockInterceptor.invoke(UnlockInterceptor.java:33)
at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:75)
at
org.jboss.cache.interceptors.CacheStoreInterceptor.invoke(CacheStoreInterceptor.java:198)
at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:75)
at
org.jboss.cache.interceptors.NotificationInterceptor.invoke(NotificationInterceptor.java:22)
at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:75)
at org.jboss.cache.interceptors.TxInterceptor.handleNonTxMethod(TxInterceptor.java:291)
at org.jboss.cache.interceptors.TxInterceptor.invoke(TxInterceptor.java:128)
at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:75)
at
org.jboss.cache.interceptors.CacheMgmtInterceptor.invoke(CacheMgmtInterceptor.java:126)
at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:75)
at
org.jboss.cache.interceptors.InvocationContextInterceptor.invoke(InvocationContextInterceptor.java:66)
at org.jboss.cache.CacheImpl.invokeMethod(CacheImpl.java:3656)
at org.jboss.cache.CacheImpl.get(CacheImpl.java:1297)
at org.jboss.cache.CacheImpl.get(CacheImpl.java:1272)
at org.jboss.cache.pojo.impl.InternalHelper.get(InternalHelper.java:142)
at org.jboss.cache.pojo.impl.InternalHelper.getPojoReference(InternalHelper.java:79)
at org.jboss.cache.pojo.impl.InternalHelper.getPojo(InternalHelper.java:251)
at org.jboss.cache.pojo.impl.PojoCacheDelegate.getObject(PojoCacheDelegate.java:88)
at org.jboss.cache.pojo.impl.PojoCacheImpl.getObject(PojoCacheImpl.java:203)
at
org.jboss.cache.pojo.impl.PojoCacheImpl.org$jboss$cache$pojo$impl$PojoCacheImpl$find$aop(PojoCacheImpl.java:192)
... 12 more
Caused by: org.jboss.cache.lock.TimeoutException: read lock for /aag could not be acquired
by Thread[Timer-9,5,jboss] after 10000 ms. Locks: Read lock owners: []
Write lock owner: GlobalTransaction:<null>:5
, lock info: write owner=GlobalTransaction:<null>:5
(org.jboss.cache.lock.LockStrategyReadCommitted@99fd98)
at org.jboss.cache.lock.IdentityLock.acquireReadLock0(IdentityLock.java:323)
at org.jboss.cache.lock.IdentityLock.acquireReadLock(IdentityLock.java:267)
at org.jboss.cache.lock.IdentityLock.acquire(IdentityLock.java:493)
... 40 more
i found out that when i delete the JDBCCacheLoader table ( which is not empty), the
problem is solved...
Gil
JBossCache and POJO Cache leave empty parent nodes around
---------------------------------------------------------
Key: JBCACHE-1118
URL: http://jira.jboss.com/jira/browse/JBCACHE-1118
Project: JBoss Cache
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: PojoCache, Cache loaders, MonthOfBugs_200
Affects Versions: 2.0.0.CR1
Reporter: gmeroz
Assigned To: Manik Surtani
Attachments: cache.xml, JDBCCacheLoderTest.java
when removing items from the cache, records which start with the
"/__JBossInternal__" prefix are not deleted from the cache table in the DB.
see attached code which reproduce it...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:21 p.m.
New subject: [JBoss JIRA] Updated: (JBCACHE-1118) JBossCache and POJO Cache leave empty parent nodes around
[ http://jira.jboss.com/jira/browse/JBCACHE-1118?page=all ]
Jason T. Greene updated JBCACHE-1118:
-------------------------------------
Component/s: (was: PojoCache)
(was: Cache loaders)
(was: MonthOfBugs_200)
JBossCache and POJO Cache leave empty parent nodes around
---------------------------------------------------------
Key: JBCACHE-1118
URL: http://jira.jboss.com/jira/browse/JBCACHE-1118
Project: JBoss Cache
Issue Type: Bug
Security Level: Public(Everyone can see)
Affects Versions: 2.0.0.CR1
Reporter: gmeroz
Assigned To: Manik Surtani
Attachments: cache.xml, JDBCCacheLoderTest.java
when removing items from the cache, records which start with the
"/__JBossInternal__" prefix are not deleted from the cache table in the DB.
see attached code which reproduce it...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6589
days inactive
6668
days old
8 comments
3 participants
participants (3)
-
Brian Stansberry (JIRA) -
gmeroz (JIRA)
-
Jason T. Greene (JIRA)