[jboss-user] [JBoss Cache: Core Edition] - Re: Clustered and JDBCCacheLoader access to DB

[jorgemoralespou_2]

What I don`t understund is why, with this configurations (both) the cache loader does:

1.- Retrieve state from cluster and delete data in JDBCCacheLoader
  | 
  | 
  |   | [org.jboss.cache.TreeCache] received the state (size=131072 bytes)
  |   | 2008-06-23 13:33:42,733 DEBUG [org.jboss.cache.loader.JDBCCacheLoader] executing sql: delete from core_data
  |   | 2008-06-23 13:33:42,736 INFO  [org.jboss.cache.TreeCache] state was retrieved successfully (in 677 milliseconds)
  | 
  | 2.- Store received stat into database
  | 
  | 
  | 
  | 
  |   | 2008-06-23 13:33:42,736 DEBUG [org.jboss.cache.loader.CacheLoaderManager] preloading transient state from cache loader org.jboss.cache.loader.AsyncCacheLoader at 142e6767 delegate=[org.jboss.cache.loader.JDBCCacheLoader at 7286a58a] processor=TQ t=Thread[AsyncCacheLoader-2,5,jboss] stopped=false batchSize=100 pollWait=100 returnOld=true asyncPut=true queue.capacity()=10000 queue.peek()=null
  |   | 2008-06-23 13:33:42,737 DEBUG [org.jboss.cache.loader.JDBCCacheLoader] executing sql: select fqn from core_data where parent=? (/)
  |   | 2008-06-23 13:33:42,783 DEBUG [org.jboss.cache.loader.JDBCCacheLoader] executing sql: select fqn from core_data where parent=? (/DB_CAPABILITY)
  |   | 2008-06-23 13:33:42,789 DEBUG [org.jboss.cache.loader.JDBCCacheLoader] executing sql: select fqn from core_data where parent=? (/DB_CAPABILITY/SESIONES)
  |   | 2008-06-23 13:33:42,792 DEBUG [org.jboss.cache.loader.JDBCCacheLoader] executing sql: select fqn from core_data where parent=? (/TRAP)
  |   | 2008-06-23 13:33:42,824 DEBUG [org.jboss.cache.loader.JDBCCacheLoader] total rows deleted: 152
  |   | 2008-06-23 13:33:42,824 DEBUG [org.jboss.cache.loader.JDBCCacheLoader] executing sql: select node from core_data where fqn=? (/)
  |   | 2008-06-23 13:33:42,829 DEBUG [org.jboss.cache.loader.JDBCCacheLoader] executing sql: insert into core_data (fqn, node, parent) values (?, ?, ?) (/)
  |   | 
  | 
  | 3.- Leave some interleaved messages
  | 
  | 
  |   | 2008-06-23 13:33:42,954 DEBUG [org.jboss.cache.loader.JDBCCacheLoader] executing sql: select node from core_data where fqn=? (/TRAP)
  |   | 2008-06-23 13:33:42,960 DEBUG [org.jboss.cache.loader.CacheLoaderManager] preloading transient state from cache loader was successful (in 223 milliseconds)
  |   | 2008-06-23 13:33:43,001 DEBUG [org.jboss.cache.loader.JDBCCacheLoader] executing sql: insert into core_data (fqn, node, parent) values (?, ?, ?) (/TRAP)
  |   | 2008-06-23 13:33:43,240 DEBUG [org.jboss.cache.TreeCache] Starting jboss.cache:service=SOMServicesProvisioningCache
  |   | 2008-06-23 13:33:43,246 DEBUG [org.jboss.cache.loader.JDBCCacheLoader] executing sql: insert into core_data (fqn, node, parent) values (?, ?, ?) (/TRAP/TA_START_ERROR)
  |   | 2008-06-23 13:33:43,246 INFO  [org.jboss.cache.loader.AsyncCacheLoader] Async cache loader starting: org.jboss.cache.loader.AsyncCacheLoader at 2b51574b delegate=[org.jboss.cache.loader.ClusteredCacheLoader at 693a1324] processor=null stopped=true batchSize=100 pollWait=100 returnOld=true asyncPut=true queue.capacity()=10000 queue.peek()=null
  |   | 2008-06-23 13:33:43,276 DEBUG [org.jboss.cache.loader.JDBCCacheLoader] executing sql: select node from core_data where fqn=? (/TRAP/WS_DEPLOYMENT)
  |   | 
  | 
  | Why is it updating the persistent state from the data I`m receiving from the cluster?
  | 
  | Also, I see that every time I do a read from cache, it is retrieving the data from database. Why?
  | 
  | 
  | 
  |   | 2008-06-23 13:38:50,012 DEBUG [org.jboss.cache.loader.JDBCCacheLoader] executing sql: select node from core_data where fqn=? (/STATISTIC_LOGGING_MONITOR)
  |   | 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4159893#4159893

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4159893