[Chandler-dev] Repository errors - Rebuilding index -

[Grant Baillie]

Hi, Andre

I'm pretty sure this is bug 7895. There's a fix (of Andi's) in the  
works that I've been trying: that should make its way into the trunk  
soon.

--Grant

On 27 Jan, 2007, at 10:59, Andre Mueninghoff wrote:

> Hi,
>
> When I check and repair my repository, it completes successfully,  
> but in
> the monitor output I see these messages about improperly sorted
> subindexes and index rebuilds. After the completion of a successful
> check and repair, another immediate check and repair will complete
> usually successfully with no issues listed in the monitor. However,  
> if I
> then sync all, the sync completes without any error symbols  
> appearing in
> the collections sidebar, but the next check and repair again  
> results in
> the same sort issues being reported, sometimes more of them, sometimes
> less. A sample clip of the output is below. My speculation is that  
> these
> errors occur as a result of my adding a recurring event to another
> collection (with dnd).
>
> Using my manual approach to "dump and reload" resolves the issue, that
> is, exporting all collections from Chandler or Cosmo, deleting all
> collections on Cosmo, using --create to generate a fresh repository,
> reimporting, republishing. My experience has been, although possibly
> only coincidence, that eventually the repair function will not be able
> to repair the errors in the repository (completes with errors) and one
> or more collections will no longer sync correctly.
>
> So I guess my question is whether someone recognizes this pattern as
> being covered by a bug already logged? If so, is there a particular
> action someone might recommend I avoid to prevent this from occuring?
> Or, is this new, and would it be worthwhile to pinpoint a cause and
> effect?
>
> Another speculation is whether the availability of check and repair  
> for
> the Cosmo repositories would reduce these kinds of conditions.
>
> Thanks much, Andre
>
> <DBRepository>: 2007-01-27 13:03:48.578000, completed checkpoint
> Checking repository ...
> Sorted subindex index 'osaf.views.main.summaryblocks.triageStatus'
> installed on
> value 'Set((UUID('1t6JhqJKx7rfEBzcO_k0G9'), 'set'))' of type <class
> 'repository.
> item.Sets.Set'> in attribute 'set' on <IndexedSelectionCollection:
> 17491770-adba
> -11db-fa38-8cccbe500a89> is not sorted properly: value for <UUID:
> 122bd77e-ae2c-
> 11db-8175-d2a1447a9f4e> is greater than the value for <UUID:
> 4f30dc1e-adb9-11db-
> 908e-8cccbe500a89>
> Rebuilding index 'osaf.views.main.summaryblocks.triageStatus'  
> installed
> on value
>  'Set((UUID('1t6JhqJKx7rfEBzcO_k0G9'), 'set'))' of type <class
>  'repository.item.
> Sets.Set'> in attribute 'set' on <IndexedSelectionCollection:
> 17491770-adba-11db
> -fa38-8cccbe500a89>
> Sorted subindex index 'osaf.views.main.summaryblocks.triageStatus'
> installed on
> value 'Set((UUID('bmWchqK8h7rdT1LGTGYUaS'), 'set'))' of type <class
> 'repository.
> item.Sets.Set'> in attribute 'set' on <IndexedSelectionCollection:
> b5bc9370-ae21
> -11db-ddd2-beadeaf382b6> is not sorted properly: value for <UUID:
> 16a1dde4-ae2c-
> 11db-8289-d2a1447a9f4e> is greater than the value for <UUID:
> 16938fc8-ae2c-11db-
> 8288-d2a1447a9f4e>
> Sorted subindex index 'osaf.views.main.summaryblocks.triageStatus'
> installed on
> value 'Set((UUID('bmWchqK8h7rdT1LGTGYUaS'), 'set'))' of type <class
> 'repository.
> item.Sets.Set'> in attribute 'set' on <IndexedSelectionCollection:
> b5bc9370-ae21
> -11db-ddd2-beadeaf382b6> is not sorted properly: value for <UUID:
> 15ffbdfc-ae2c-
> 11db-8260-d2a1447a9f4e> is greater than the value for <UUID:
> 164c093c-ae2c-11db-
> 8274-d2a1447a9f4e>
> Sorted subindex index 'osaf.views.main.summaryblocks.triageStatus'
> installed on
> value 'Set((UUID('bmWchqK8h7rdT1LGTGYUaS'), 'set'))' of type <class
> 'repository.
> item.Sets.Set'> in attribute 'set' on <IndexedSelectionCollection:
> b5bc9370-ae21
> -11db-ddd2-beadeaf382b6> is not sorted properly: value for <UUID:
> 160e0c18-ae2c-
> 11db-8262-d2a1447a9f4e> is greater than the value for <UUID:
> 62a30a2e-adb9-11db-
> 9933-8cccbe500a89>
> Rebuilding index 'osaf.views.main.summaryblocks.triageStatus'  
> installed
> on value
>  'Set((UUID('bmWchqK8h7rdT1LGTGYUaS'), 'set'))' of type <class
>  'repository.item.
> Sets.Set'> in attribute 'set' on <IndexedSelectionCollection:
> b5bc9370-ae21-11db
> -ddd2-beadeaf382b6>
> Sorted subindex index 'osaf.views.main.summaryblocks.triageStatus'
> installed on
> value 'Set((UUID('5YXnMqK917r8JVLGTGYUaS'), 'set'))' of type <class
> 'repository.
> item.Sets.Set'> in attribute 'set' on <IndexedSelectionCollection:
> 5f3dc160-ae24
> -11db-8b8a-beadeaf382b6> is not sorted properly: value for <UUID:
> 1d00a65c-ae2c-
> 11db-857a-d2a1447a9f4e> is greater than the value for <UUID:
> 1caf9668-ae2c-11db-
> 856a-d2a1447a9f4e>
> Sorted subindex index 'osaf.views.main.summaryblocks.triageStatus'
> installed on
> value 'Set((UUID('5YXnMqK917r8JVLGTGYUaS'), 'set'))' of type <class
> 'repository.
> item.Sets.Set'> in attribute 'set' on <IndexedSelectionCollection:
> 5f3dc160-ae24
> -11db-8b8a-beadeaf382b6> is not sorted properly: value for <UUID:
> 00d07ee2-ae24-
> 11db-82e5-beadeaf382b6> is greater than the value for <UUID:
> caa6a6c3-83ae-11db-
> e0b9-0014a51af847>
> Sorted subindex index 'osaf.views.main.summaryblocks.triageStatus'
> installed on
> value 'Set((UUID('5YXnMqK917r8JVLGTGYUaS'), 'set'))' of type <class
> 'repository.
> item.Sets.Set'> in attribute 'set' on <IndexedSelectionCollection:
> 5f3dc160-ae24
> -11db-8b8a-beadeaf382b6> is not sorted properly: value for <UUID:
> 1d0ef478-ae2c-
> 11db-857b-d2a1447a9f4e> is greater than the value for <UUID:
> 1cc046de-ae2c-11db-
> 856a-d2a1447a9f4e>
> Rebuilding index 'osaf.views.main.summaryblocks.triageStatus'  
> installed
> on value
>  'Set((UUID('5YXnMqK917r8JVLGTGYUaS'), 'set'))' of type <class
>  'repository.item.
> Sets.Set'> in attribute 'set' on <IndexedSelectionCollection:
> 5f3dc160-ae24-11db
> -8b8a-beadeaf382b6>
> -- 
>   Andre Mueninghoff
>   andre_mueninghoff at fastmail.fm
>
> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
>
> Open Source Applications Foundation "chandler-dev" mailing list
> http://lists.osafoundation.org/mailman/listinfo/chandler-dev