cancel
Showing results for 
Search instead for 
Did you mean: 

Why Alfresco not deleting a rows from ALF_NODE_STATUS

skorde
Champ in-the-making
Champ in-the-making
Hi
In our production environment we have alfresco alfresco-community-tomcat-2.1.0 and database is oracle9i
while observing a database I found that ,if you delete content(file or folder) from alfresco ,it deleted the row from ALF_NODE and few other table but not from ALF_NODE_STATUS
my question is
Why Alfresco not deleting rows from ALF_NODE_STATUS? even after cleaning a recycle bin

Thanks in advanced
2 REPLIES 2

francescof
Champ in-the-making
Champ in-the-making
The alf_node_status table is used to keep track of the last transaction in which a node was created, modified or deleted. For this reason when a node is deleted its record is removed from alf_node, while it is marked as deleted (along with the current transaction id) in alf_node_status.

The alf_node_status table is used with alf_transaction while rebuilding indexes or tracking updates and deletion on remote cluster nodes.

skorde
Champ in-the-making
Champ in-the-making
if i am rough please correct me
Well that means Alfresco's ContentStoreCleaner class  moves("contentstore" to "contentstore.deleted") only thus content which has been  marked deleted
my question is
Why alfresco maintain status of thus content Which has been clean-up from "contentstore" and "contentstore.deleted"?