topic Re: Index rebuilt failed in Alfresco Archive

Index rebuilt failed

waschbecken — Thu, 29 Mar 2007 16:43:24 GMT

hello,I also had some troubles with the ulimit.Currently it is set to 4096. I also followed the given instruction in the alfresco wiki.After removing the lucene-indexes folder and setting index.recovery.mode=FULL I get the following exception:Code:1:06:29,444 INFO [FullIndexRecoveryComponent]

Re: Index rebuilt failed

derek — Tue, 10 Apr 2007 17:19:08 GMT

Hi,

Is there a primary parent association (alf_child_assoc) for the node? Since you have a normal association to it (alf_node_assoc), I presume it is there.

Regards

Re: Index rebuilt failed

waschbecken — Thu, 12 Apr 2007 12:23:06 GMT

hi!

when I search in the alf_child_assoc table for my UUID or node_id I did not find any entries.
No entries for parent_node_id, child_node_id, child_node_name, except when I search with with the same node_id and the id from my faulty node_id from alf_node table. But I think, this entry is not the one which I should search for.

Sine I found no entry in the alf_child_assoc, should I delete this alf_node entry which leads my index-rebuilt to fail? :?:

Re: Index rebuilt failed

derek — Thu, 12 Apr 2007 13:25:31 GMT

Removing the node will do the trick.
Check that your tables are all InnoDB tables as well. Do you have any idea what might have caused the orphaned node?

Re: Index rebuilt failed

waschbecken — Thu, 12 Apr 2007 14:23:40 GMT

ok, I will try to remove it.
But I locked at the tables and there are all InnoDB engined.
How can I change it to InnoDB? (my.cnf somewhere around)

Good question about the orphaned node, the index-rebuilt faild but other usere put documents into alfresco.
I think from this CIFS and Webview began starting not synchronized.

Re: Index rebuilt failed

derek — Thu, 12 Apr 2007 15:25:54 GMT

Hi,

The problem is the use of MyISAM, really. Any transaction that rolls back will be leaving your data in a questionable state. You can issue alter table statements in MySQL to change the table type. But you should change the default table type, anyway. You could also dump and load the database after fixing up the script.

Regards