topic Why Alfresco not deleting a rows from ALF_NODE_STATUS in Alfresco Archive

Why Alfresco not deleting a rows from ALF_NODE_STATUS

skorde — Mon, 15 Sep 2008 09:31:34 GMT

HiIn our production environment we have alfresco alfresco-community-tomcat-2.1.0 and database is oracle9iwhile 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_STATUSmy question is Why A

Re: Why Alfresco not deleting a rows from ALF_NODE_STATUS

francescof — Mon, 15 Sep 2008 11:36:59 GMT

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.

Re: Why Alfresco not deleting a rows from ALF_NODE_STATUS

skorde — Mon, 15 Sep 2008 12:40:27 GMT

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