[jboss-jira] [JBoss JIRA] Commented: (JBCACHE-1118) JDBCCacheLoader does not delete DB table properly

[Jason T. Greene (JIRA)]

    [ 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