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
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.
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"?