AnsweredAssumed Answered

No live node exists - error halts solr indexing

Question asked by loftux Moderator on Feb 15, 2012
Latest reply on Feb 22, 2013 by yanpak
Using 4.0.d on postgresql indexing with Solr, I see this error in alfresco.log
2012-02-15 08:11:50,393  ERROR [extensions.webscripts.AbstractRuntime] [http-8443-4] Exception from executeScript - redirecting to status template error: 01156612 Wrapped Exception (with status template): No live node exists: 
   ID:        520521
   Cache row: NodeEntity[ ID=520521, version=16, store=workspace://SpacesStore, uuid=64b01e12-dfac-4b22-96d0-bfa30ba7d34e, typeQNameId=32, localeId=15, aclId=null, deleted=true, transaction=TransactionEntity[ ID=1064115, server=null, changeTxnId=f4359d12-f144-43c7-8c17-18697c4eb864, commitTimeMs=null], auditProps=AuditablePropertiesEntity[ auditCreator=anbj01, auditCreated=2012-02-07T08:05:37.520+01:00, auditModifier=anbj01, auditModified=2012-02-07T09:20:18.000+01:00]]
   DB row:    NodeEntity[ ID=520521, version=16, store=workspace://SpacesStore, uuid=64b01e12-dfac-4b22-96d0-bfa30ba7d34e, typeQNameId=32, localeId=15, aclId=null, deleted=true, transaction=TransactionEntity[ ID=1064115, server=null, changeTxnId=f4359d12-f144-43c7-8c17-18697c4eb864, commitTimeMs=null], auditProps=AuditablePropertiesEntity[ auditCreator=anbj01, auditCreated=2012-02-07T08:05:37.520+01:00, auditModifier=anbj01, auditModified=2012-02-07T09:20:18.000+01:00]]
org.springframework.extensions.webscripts.WebScriptException: 01156612 Wrapped Exception (with status template): No live node exists:
   ID:        520521
   Cache row: NodeEntity[ ID=520521, version=16, store=workspace://SpacesStore, uuid=64b01e12-dfac-4b22-96d0-bfa30ba7d34e, typeQNameId=32, localeId=15, aclId=null, deleted=true, transaction=TransactionEntity[ ID=1064115, server=null, changeTxnId=f4359d12-f144-43c7-8c17-18697c4eb864, commitTimeMs=null], auditProps=AuditablePropertiesEntity[ auditCreator=anbj01, auditCreated=2012-02-07T08:05:37.520+01:00, auditModifier=anbj01, auditModified=2012-02-07T09:20:18.000+01:00]]
   DB row:    NodeEntity[ ID=520521, version=16, store=workspace://SpacesStore, uuid=64b01e12-dfac-4b22-96d0-bfa30ba7d34e, typeQNameId=32, localeId=15, aclId=null, deleted=true, transaction=TransactionEntity[ ID=1064115, server=null, changeTxnId=f4359d12-f144-43c7-8c17-18697c4eb864, commitTimeMs=null], auditProps=AuditablePropertiesEntity[ auditCreator=anbj01, auditCreated=2012-02-07T08:05:37.520+01:00, auditModifier=anbj01, auditModified=2012-02-07T09:20:18.000+01:00]]
This error halts Solr indexing, it cannot get past that. I think Solr should be more fault tolerant, but my primary question here is how can this be fixed?
If I do
select * from alf_transaction where change_txn_id='f4359d12-f144-43c7-8c17-18697c4eb864';
id   version   server_id   change_txn_id   commit_time_ms
1064115   1   4   f4359d12-f144-43c7-8c17-18697c4eb864   1328887525021
and then
select * from alf_node where transaction_id = 1064115

id   version   store_id   uuid   transaction_id   node_deleted   type_qname_id   acl_id   audit_creator   audit_created   audit_modifier   audit_modified   audit_accessed   locale_id
530844   4   45   64b01e12-dfac-4b22-96d0-bfa30ba7d34e   1064115   f   34   1649   anbj01   2012-02-07T08:05:37.520+01:00   anbj01   2012-02-07T09:20:18.000+01:00      27
530847   2   45   8b85ff9f-4416-4195-aab8-88ec1dab1288   1064115   f   120   1649   anbj01   2012-02-10T16:24:56.896+01:00   anbj01   2012-02-10T16:24:56.896+01:00      27
530841   5   50   8b85ff9f-4416-4195-aab8-88ec1dab1288   1064115   t   32      anbj01   2012-02-10T16:24:56.896+01:00   anbj01   2012-02-10T16:24:56.896+01:00      15
520521   16   50   64b01e12-dfac-4b22-96d0-bfa30ba7d34e   1064115   t   32      anbj01   2012-02-07T08:05:37.520+01:00   anbj01   2012-02-07T09:20:18.000+01:00      15
Is this just a cache issue, so a restart of tomcat would help?
Or is it something corrupted in the db?
Looking at the source http://svn.alfresco.com/repos/alfresco-open-mirror/alfresco/HEAD/root/projects/repository/source/java/org/alfresco/repo/domain/node/AbstractNodeDAOImpl.java
it is failing in the function trying to "Find an undeleted node" with "ConcurrencyFailureException if the ID doesn't reference a <b>live</b> node".
But what exactly makes this node not live?

Outcomes