Node without parents does not have root aspect

[nimbus58]

Hello,

I have a 33g system running fine on Ubuntu 10.04 64 and a Mysql on another machine.

I have just tried to do a replica of the system on another server as part of a crash recovery test ( DB and data-store)
and I end up with a reindexing going nuts.

I tried the same with a 34b system and no luck.

I get "Reindexer   672 failed with error: Node without parents does not have root aspect: workspace://SpacesStore/5012764b-dbec-4ed9-8c35-4c0c60acdb1f"

Now it is always the same SpaceStore.
On the live system, the node browser give me an error but I do not know where or how to get rid of it.

For info: I have upgraded the system for the last 2 years with the same data and db without ever a problem.

Any help welcome:

(Snippet of catalina.out)

Nov 30, 2010 2:13:03 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Nov 30, 2010 2:13:03 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 746 ms
Nov 30, 2010 2:13:03 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Nov 30, 2010 2:13:04 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.26
Nov 30, 2010 2:13:04 PM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor host-manager.xml
Nov 30, 2010 2:13:04 PM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor alfresco.xml
Nov 30, 2010 2:13:06 PM org.apache.catalina.core.StandardContext addApplicationListener
INFO: The listener "org.apache.myfaces.webapp.StartupServletContextListener" is already configured for this context. The duplicate definition has been ignored.
14:13:13,505  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properties]
14:13:13,512  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.properties]
14:13:13,523  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [/opt/alfresco33g/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/module/tests/alfresco-global.properties]
14:13:13,532  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [/opt/alfresco33g/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/module/test/alfresco-global.properties]
14:13:13,532  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/opt/alfresco33g/tomcat/shared/classes/alfresco-global.properties]
14:13:13,615  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
14:13:30,549  INFO  [extensions.webscripts.TemplateProcessorRegistry] Registered template processor Repository Template Processor for extension ftl
14:13:30,552  INFO  [extensions.webscripts.ScriptProcessorRegistry] Registered script processor Repository Script Processor for extension js
14:13:36,900  INFO  [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
14:13:38,277  INFO  [domain.schema.SchemaBootstrap] No changes were made to the schema.
14:13:38,655  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
14:13:38,687  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
14:13:38,698  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
14:13:40,545  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'thirdparty' subsystem, ID: [thirdparty, default]
14:13:40,579  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
14:13:42,074  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'thirdparty' subsystem, ID: [thirdparty, default] complete
14:13:42,075  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'OOoDirect' subsystem, ID: [OOoDirect, default]
14:13:42,130  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
14:13:42,927  WARN  [alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.
14:13:42,951  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'OOoDirect' subsystem, ID: [OOoDirect, default] complete
14:13:44,964  INFO  [node.index.FullIndexRecoveryComponent] Index recovery started: 22,680 transactions.
14:14:07,153  ERROR [index.AbstractReindexComponent.threads] Reindexer    20 failed with error: Node without parents does not have root aspect: workspace://SpacesStore/5012764b-dbec-4ed9-8c35-4c0c60acdb1f.
14:14:07,339  INFO  [node.index.FullIndexRecoveryComponent]    10 % complete.
14:14:13,882  ERROR [index.AbstractReindexComponent.threads] Reindexer    40 failed with error: Node without parents does not have root aspect: workspace://SpacesStore/5012764b-dbec-4ed9-8c35-4c0c60acdb1f.
14:14:13,913  INFO  [node.index.FullIndexRecoveryComponent]    20 % complete.
14:14:18,238  ERROR [index.AbstractReindexComponent.threads] Reindexer    60 failed with error: Node without parents does not have root aspect: workspace://SpacesStore/5012764b-dbec-4ed9-8c35-4c0c60acdb1f.
14:14:18,307  INFO  [node.index.FullIndexRecoveryComponent]    30 % complete.
14:14:21,612  ERROR [index.AbstractReindexComponent.threads] Reindexer    80 failed with error: Node without parents does not have root aspect: workspace://SpacesStore/5012764b-dbec-4ed9-8c35-4c0c60acdb1f.
14:14:24,658  INFO  [node.index.FullIndexRecoveryComponent]    40 % complete.
14:14:26,164  ERROR [index.AbstractReindexComponent.threads] Reindexer   100 failed with error: Node without parents does not have root aspect: workspace://SpacesStore/5012764b-dbec-4ed9-8c35-4c0c60acdb1f.
14:14:27,721  INFO  [node.index.FullIndexRecoveryComponent]    50 % complete.
14:14:29,236  ERROR [index.AbstractReindexComponent.threads] Reindexer   120 failed with error: Node without parents does not have root aspect: workspace://SpacesStore/5012764b-dbec-4ed9-8c35-4c0c60acdb1f.
14:14:30,673  INFO  [node.index.FullIndexRecoveryComponent]    60 % complete.
14:14:32,423  ERROR [index.AbstractReindexComponent.threads] Reindexer   140 failed with error: Node without parents does not have root aspect: workspace://SpacesStore/5012764b-dbec-4ed9-8c35-4c0c60acdb1f.
14:14:33,633  INFO  [node.index.FullIndexRecoveryComponent]    70 % complete.
14:14:35,039  ERROR [index.AbstractReindexComponent.threads] Reindexer   160 failed with error: Node without parents does not have root aspect: workspace://SpacesStore/5012764b-dbec-4ed9-8c35-4c0c60acdb1f.
14:14:37,784  ERROR [index.AbstractReindexComponent.threads] Reindexer   180 failed with error: Node without parents does not have root aspect: workspace://SpacesStore/5012764b-dbec-4ed9-8c35-4c0c60acdb1f.
14:14:37,831  INFO  [node.index.FullIndexRecoveryComponent]    80 % complete.
14:14:40,990  ERROR [index.AbstractReindexComponent.threads] Reindexer   200 failed with error: Node without parents does not have root aspect: workspace://SpacesStore/5012764b-dbec-4ed9-8c35-4c0c60acdb1f.
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[fiferyan]

Thank you for the SQL!  Bumping because this solved my problem. Thank you.

On 3.4.8 and had to modify the queries a little bit because the node_deleted type is a tinyint and not a string.

I updated the queries a little bit and others may find this useful so I'm sharing. I hope it works for you. Please do backup before trying these though!

– Find children of nodes with no parents
SELECT *
  FROM alf_child_assoc
 WHERE parent_node_id IN(
        SELECT id FROM alf_node
        WHERE node_deleted=0
        AND id NOT IN(SELECT root_node_id FROM alf_store)
        AND id NOT IN(SELECT child_node_id FROM alf_child_assoc)
);


– if you find any, update them to 'deleted'
UPDATE alf_node
   SET node_deleted=1
 WHERE id IN (
        SELECT parent_node_id
          FROM alf_child_assoc
         WHERE parent_node_id IN(
                SELECT id
                  FROM alf_node
                 WHERE node_deleted=0
                   AND id NOT IN(SELECT root_node_id FROM alf_store)
                   AND id NOT IN(SELECT child_node_id FROM alf_child_assoc)
         )
);


– find nodes with no parent
SELECT *
  FROM alf_node
 WHERE node_deleted=0
   AND id NOT IN(SELECT root_node_id FROM alf_store)
   AND id NOT IN(SELECT child_node_id FROM alf_child_assoc);


– Update the nodes with no parent to deleted
UPDATE alf_node
  SET NODE_DELETED=1
WHERE NODE_DELETED=0
  AND id NOT IN(SELECT root_node_id FROM alf_store)
  AND id NOT IN(SELECT child_node_id FROM alf_child_assoc);
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I found many nodes with null acl_id columns but I did not touch those and after a re-index everything worked well so I'm ignoring them for now.