[Chandler-dev] Repository errors - Rebuilding index -

Andi Vajda vajda at osafoundation.org
Sat Jan 27 16:55:28 PST 2007


On Sat, 27 Jan 2007, Andre Mueninghoff wrote:

> Let me know if having a copy of my current repository (which contains
> only events at the moment) would be helpful. The current repository
> exhibits this subindex issue on check and repair.

Like Grant said earlier, I too believe this is bug is 7895.

If you want to try the potential fix out before it is committed, and have 
installed chandler from svn sources, you can edit chandler/Makefile, change 
chandlerdb's version to 0.6-78 and run 'make chandlerdb'.

We should have it checked in soon, however, and I expect to be in the next 
checkpoint build.

Andi..

> On Sat, 27 Jan 2007 11:14:24 -0800 (PST), "Andi Vajda"
> <vajda at osafoundation.org> said:
>>
>> On Sat, 27 Jan 2007, Andre Mueninghoff wrote:
>>
>>> 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).
>>
>> Are you running trunk or alpha 4 ?
>>
>> Andi..
>>
>>>
>>> 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
>>>
> --
>  Andre Mueninghoff
>  andre_mueninghoff at fastmail.fm
>
>


More information about the chandler-dev mailing list