[Chandler-dev] Sorted subindex...not sorted properly - Rebuilding index...installed on value...

Andre Mueninghoff andre_mueninghoff at fastmail.fm
Thu Feb 8 18:42:17 PST 2007


Hi Brian,

I see what I can do about repro steps. It has something to do with
recurring events being modified or being in multiple collections or
both, I think.

Here's the an example of a condition that ends with the text I was
getting on python crashes, but I haven't seen it again in the last 24
hours. I had been speculating that maybe this problem was resolved for
my repository when the schema changed in recent builds.

Checking repository ...
Check completed successfully in 0:00:18.640000
<DBRepositoryView: MainThread (1228)> committed 16 items (14 kbytes) in
0:00:00.
250000, 64 items/s (56 kbytes/s)
<DBRepositoryView: MainThread (1228)> pruned to 8000 items
<DBRepositoryView: Sharing (1176)> merging 8 items...
<DBRepository>: 2007-02-07 21:21:17.953000, completed checkpoint
<DBRepositoryView: Sharing (1176)> 8 notifications ran in 0:00:04.969000
<DBRepositoryView: Sharing (1178)> merging 1 items...
<DBRepositoryView: Sharing (1180)> merging 1 items...
<DBRepositoryView: Sharing (1184)> merging 5 items...
<DBRepositoryView: Sharing (1185)> merging 6 items...
<DBRepositoryView: Sharing (1188)> merging 1 items...
<DBRepositoryView: Sharing (1190)> merging 20 items...
<DBRepositoryView: Sharing (1192)> merging 26 items...
<DBRepositoryView: Sharing (1195)> merging 28 items...
<DBRepositoryView: Sharing (1195)> 194 notifications ran in
0:00:02.266000
<DBRepositoryView: Sharing (1197)> merging 2 items...
<DBRepositoryView: Sharing (1198)> merging 3 items...
<DBRepositoryView: Sharing (1199)> merging 7 items...
<DBRepositoryView: Sharing (1200)> merging 5 items...
<DBRepositoryView: Sharing (1201)> merging 5 items...
<DBRepositoryView: Sharing (1202)> merging 5 items...
<DBRepositoryView: Sharing (1203)> merging 5 items...
<DBRepositoryView: Sharing (1204)> merging 5 items...
<DBRepositoryView: Sharing (1205)> merging 5 items...
<DBRepositoryView: Sharing (1206)> merging 5 items...
<DBRepositoryView: Sharing (1207)> merging 1 items...
<DBRepositoryView: Sharing (1208)> merging 26 items...
<DBRepository>: 2007-02-07 21:31:18.406000, completed checkpoint
<DBRepositoryView: Sharing (1210)> merging 5 items...
<DBRepositoryView: Sharing (1211)> merging 3 items...
<DBRepositoryView: Sharing (1212)> merging 5 items...
<DBRepositoryView: Sharing (1215)> merging 5 items...
<DBRepositoryView: Sharing (1216)> merging 3 items...
<DBRepositoryView: Sharing (1217)> merging 3 items...
<DBRepositoryView: Sharing (1218)> merging 29 items...
<DBRepositoryView: Sharing (1218)> 194 notifications ran in
0:00:02.281000
<DBRepositoryView: Sharing (1220)> merging 5 items...
<DBRepositoryView: Sharing (1221)> merging 4 items...
<DBRepositoryView: Sharing (1222)> merging 1 items...
<DBRepositoryView: Sharing (1223)> merging 1 items...
<DBRepositoryView: Sharing (1226)> merging 5 items...
<DBRepositoryView: Sharing (1227)> merging 3 items...
<DBRepositoryView: Sharing (1228)> merging 3 items...
<DBRepositoryView: Sharing (1228)> pruned to 23445 items
<DBRepositoryView: Sharing (1228)> committing 23014 items...
Fatal Python error: This thread state must be current when releasing

This application has requested the Runtime to terminate it in an unusual
way.
Please contact the application's support team for more information.

C:\Program Files\Chandler0.7alpha5>


On Thu, 08 Feb 2007 16:32:20 -0800, "Bryan Stearns"
<stearns at osafoundation.org> said:
> Hi Andre,
> 
> Thanks for writing about this. Andi thinks the indexing problem is an 
> instance of bug 7324:
> https://bugzilla.osafoundation.org/show_bug.cgi?id=7324
> 
> If you've got a reproducible case of it, please add repro steps to that 
> bug - Andi will be grateful!
> 
> (I'm not sure what the thread-not-released thing is - maybe someone else 
> will chime in about that, or you can let us know the exact text next 
> time you see it.)
> 
> Thanks,
> ...Bryan
> 
> 
> 
> Andre Mueninghoff wrote:
> > Hi, I'm seeing a lot of this type of output, and thought I'd mention it.
> > Is this is a known issue or would more investigation on my part be
> > potentially useful? The example below is from using r13085. Also, it
> > seems if I don't run check and repair frequently I get python crashes
> > with a comment to the effect of a thread not being released or
> > something. If useful, I could forward the exact text should I see that
> > again.
> > Thanks, Andre
> >
> > Checking repository ...
> > Sorted subindex index 'osaf.views.main.summaryblocks.triageStatus'
> > installed on
> > value 'Difference((UUID('2oI5KWRzx7rbHpDovUeOsb'), 'set'),
> > (UUID('aXxYdWRyx7r9yv
> > DovUeOsb'), 'inclusions'))' of type <class
> > 'repository.item.Sets.Difference'> in
> >  attribute 'set' on <IndexedSelectionCollection:
> >  262c16ee-b58e-11db-baea-9d87f83
> > b270b> is not sorted properly: value for <UUID:
> > 5c5c4898-b713-11db-a95e-f66d830d
> > 3456> is greater than the value for <UUID:
> > 5c3ae7ac-b713-11db-a94d-f66d830d3456>
> >
> > Sorted subindex index 'osaf.views.main.summaryblocks.triageStatus'
> > installed on
> > value 'Difference((UUID('2oI5KWRzx7rbHpDovUeOsb'), 'set'),
> > (UUID('aXxYdWRyx7r9yv
> > DovUeOsb'), 'inclusions'))' of type <class
> > 'repository.item.Sets.Difference'> in
> >  attribute 'set' on <IndexedSelectionCollection:
> >  262c16ee-b58e-11db-baea-9d87f83
> > b270b> is not sorted properly: value for <UUID:
> > 56fefe18-b713-11db-a545-f66d830d
> > 3456> is greater than the value for <UUID:
> > 569616a0-b713-11db-a512-f66d830d3456>
> >
> > Sorted subindex index 'osaf.views.main.summaryblocks.triageStatus'
> > installed on
> > value 'Difference((UUID('2oI5KWRzx7rbHpDovUeOsb'), 'set'),
> > (UUID('aXxYdWRyx7r9yv
> > DovUeOsb'), 'inclusions'))' of type <class
> > 'repository.item.Sets.Difference'> in
> >  attribute 'set' on <IndexedSelectionCollection:
> >  262c16ee-b58e-11db-baea-9d87f83
> > b270b> is not sorted properly: value for <UUID:
> > 569616a0-b713-11db-a512-f66d830d
> > 3456> is greater than the value for <UUID:
> > 56b9d9e6-b713-11db-a523-f66d830d3456>
> >
> > Sorted subindex index 'osaf.views.main.summaryblocks.triageStatus'
> > installed on
> > value 'Difference((UUID('2oI5KWRzx7rbHpDovUeOsb'), 'set'),
> > (UUID('aXxYdWRyx7r9yv
> > DovUeOsb'), 'inclusions'))' of type <class
> > 'repository.item.Sets.Difference'> in
> >  attribute 'set' on <IndexedSelectionCollection:
> >  262c16ee-b58e-11db-baea-9d87f83
> > b270b> is not sorted properly: value for <UUID:
> > 55f65912-b713-11db-a4e5-f66d830d
> > 3456> is greater than the value for <UUID:
> > 565354c8-b713-11db-a4f6-f66d830d3456>
> >
> > Sorted subindex index 'osaf.views.main.summaryblocks.triageStatus'
> > installed on
> > value 'Difference((UUID('2oI5KWRzx7rbHpDovUeOsb'), 'set'),
> > (UUID('aXxYdWRyx7r9yv
> > DovUeOsb'), 'inclusions'))' of type <class
> > 'repository.item.Sets.Difference'> in
> >  attribute 'set' on <IndexedSelectionCollection:
> >  262c16ee-b58e-11db-baea-9d87f83
> > b270b> is not sorted properly: value for <UUID:
> > 52decc5a-b713-11db-a30b-f66d830d
> > 3456> is greater than the value for <UUID:
> > 53028fa0-b713-11db-a31d-f66d830d3456>
> >
> > Sorted subindex index 'osaf.views.main.summaryblocks.triageStatus'
> > installed on
> > value 'Difference((UUID('2oI5KWRzx7rbHpDovUeOsb'), 'set'),
> > (UUID('aXxYdWRyx7r9yv
> > DovUeOsb'), 'inclusions'))' of type <class
> > 'repository.item.Sets.Difference'> in
> >  attribute 'set' on <IndexedSelectionCollection:
> >  262c16ee-b58e-11db-baea-9d87f83
> > b270b> is not sorted properly: value for <UUID:
> > 4f599376-b713-11db-a0ef-f66d830d
> > 3456> is greater than the value for <UUID:
> > 4f9c554e-b713-11db-a101-f66d830d3456>
> >
> > Sorted subindex index 'osaf.views.main.summaryblocks.triageStatus'
> > installed on
> > value 'Difference((UUID('2oI5KWRzx7rbHpDovUeOsb'), 'set'),
> > (UUID('aXxYdWRyx7r9yv
> > DovUeOsb'), 'inclusions'))' of type <class
> > 'repository.item.Sets.Difference'> in
> >  attribute 'set' on <IndexedSelectionCollection:
> >  262c16ee-b58e-11db-baea-9d87f83
> > b270b> is not sorted properly: value for <UUID:
> > 4aa7f246-b713-11db-9ea9-f66d830d
> > 3456> is greater than the value for <UUID:
> > 4afb6494-b713-11db-9ebb-f66d830d3456>
> >
> > Sorted subindex index 'osaf.views.main.summaryblocks.triageStatus'
> > installed on
> > value 'Difference((UUID('2oI5KWRzx7rbHpDovUeOsb'), 'set'),
> > (UUID('aXxYdWRyx7r9yv
> > DovUeOsb'), 'inclusions'))' of type <class
> > 'repository.item.Sets.Difference'> in
> >  attribute 'set' on <IndexedSelectionCollection:
> >  262c16ee-b58e-11db-baea-9d87f83
> > b270b> is not sorted properly: value for <UUID:
> > 466fe904-b713-11db-9ca0-f66d830d
> > 3456> is greater than the value for <UUID:
> > 469149f0-b713-11db-9cb2-f66d830d3456>
> >
> > Sorted subindex index 'osaf.views.main.summaryblocks.triageStatus'
> > installed on
> > value 'Difference((UUID('2oI5KWRzx7rbHpDovUeOsb'), 'set'),
> > (UUID('aXxYdWRyx7r9yv
> > DovUeOsb'), 'inclusions'))' of type <class
> > 'repository.item.Sets.Difference'> in
> >  attribute 'set' on <IndexedSelectionCollection:
> >  262c16ee-b58e-11db-baea-9d87f83
> > b270b> is not sorted properly: value for <UUID:
> > 1260a3dd-b6a0-11db-9979-a618cc93
> > 68f7> is greater than the value for <UUID:
> > 1211f643-b6a0-11db-9969-a618cc9368f7>
> >
> > Sorted subindex index 'osaf.views.main.summaryblocks.triageStatus'
> > installed on
> > value 'Difference((UUID('2oI5KWRzx7rbHpDovUeOsb'), 'set'),
> > (UUID('aXxYdWRyx7r9yv
> > DovUeOsb'), 'inclusions'))' of type <class
> > 'repository.item.Sets.Difference'> in
> >  attribute 'set' on <IndexedSelectionCollection:
> >  262c16ee-b58e-11db-baea-9d87f83
> > b270b> is not sorted properly: value for <UUID:
> > 0c15433b-b659-11db-867e-93166596
> > c958> is greater than the value for <UUID:
> > 0bdc0acb-b659-11db-866c-93166596c958>
> >
> > Sorted subindex index 'osaf.views.main.summaryblocks.triageStatus'
> > installed on
> > value 'Difference((UUID('2oI5KWRzx7rbHpDovUeOsb'), 'set'),
> > (UUID('aXxYdWRyx7r9yv
> > DovUeOsb'), 'inclusions'))' of type <class
> > 'repository.item.Sets.Difference'> in
> >  attribute 'set' on <IndexedSelectionCollection:
> >  262c16ee-b58e-11db-baea-9d87f83
> > b270b> is not sorted properly: value for <UUID:
> > a9a6f86a-b5dc-11db-fb62-cc5f05fe
> > 1555> is greater than the value for <UUID:
> > a9c85956-b5dc-11db-fb88-cc5f05fe1555>
> >
> > Sorted subindex index 'osaf.views.main.summaryblocks.triageStatus'
> > installed on
> > value 'Difference((UUID('2oI5KWRzx7rbHpDovUeOsb'), 'set'),
> > (UUID('aXxYdWRyx7r9yv
> > DovUeOsb'), 'inclusions'))' of type <class
> > 'repository.item.Sets.Difference'> in
> >  attribute 'set' on <IndexedSelectionCollection:
> >  262c16ee-b58e-11db-baea-9d87f83
> > b270b> is not sorted properly: value for <UUID:
> > a822591c-b5dc-11db-f956-cc5f05fe
> > 1555> is greater than the value for <UUID:
> > a80f464c-b5dc-11db-f943-cc5f05fe1555>
> >
> > Sorted subindex index 'osaf.views.main.summaryblocks.triageStatus'
> > installed on
> > value 'Difference((UUID('2oI5KWRzx7rbHpDovUeOsb'), 'set'),
> > (UUID('aXxYdWRyx7r9yv
> > DovUeOsb'), 'inclusions'))' of type <class
> > 'repository.item.Sets.Difference'> in
> >  attribute 'set' on <IndexedSelectionCollection:
> >  262c16ee-b58e-11db-baea-9d87f83
> > b270b> is not sorted properly: value for <UUID:
> > 9239e982-b58f-11db-db41-9d87f83b
> > 270b> is greater than the value for <UUID:
> > 92116188-b58f-11db-dafc-9d87f83b270b>
> >
> > Sorted subindex index 'osaf.views.main.summaryblocks.triageStatus'
> > installed on
> > value 'Difference((UUID('2oI5KWRzx7rbHpDovUeOsb'), 'set'),
> > (UUID('aXxYdWRyx7r9yv
> > DovUeOsb'), 'inclusions'))' of type <class
> > 'repository.item.Sets.Difference'> in
> >  attribute 'set' on <IndexedSelectionCollection:
> >  262c16ee-b58e-11db-baea-9d87f83
> > b270b> is not sorted properly: value for <UUID:
> > 922211fe-b58f-11db-db23-9d87f83b
> > 270b> is greater than the value for <UUID:
> > 92188896-b58f-11db-db10-9d87f83b270b>
> >
> > Rebuilding index 'osaf.views.main.summaryblocks.triageStatus' installed
> > on value
> >  'Difference((UUID('2oI5KWRzx7rbHpDovUeOsb'), 'set'),
> >  (UUID('aXxYdWRyx7r9yvDovUe
> > Osb'), 'inclusions'))' of type <class 'repository.item.Sets.Difference'>
> > in attr
> > ibute 'set' on <IndexedSelectionCollection:
> > 262c16ee-b58e-11db-baea-9d87f83b270b
> >   
> > Sorted subindex index 'osaf.views.main.summaryblocks.displayDate'
> > installed on v
> > alue 'Set((UUID('eT5ZpWRzx7rcE4DovUeOsb'), 'set'))' of type <class
> > 'repository.i
> > tem.Sets.Set'> in attribute 'set' on <IndexedSelectionCollection:
> > edcaba52-b58e-
> > 11db-ca13-9d87f83b270b> is not sorted properly: value for <UUID:
> > 7cfb9598-b58f-1
> > 1db-cf29-9d87f83b270b> is greater than the value for <UUID:
> > 7cefa9d6-b58f-11db-c
> > f16-9d87f83b270b>
> > Rebuilding index 'osaf.views.main.summaryblocks.displayDate' installed
> > on value
> > 'Set((UUID('eT5ZpWRzx7rcE4DovUeOsb'), 'set'))' of type <class
> > 'repository.item.S
> > ets.Set'> in attribute 'set' on <IndexedSelectionCollection:
> > edcaba52-b58e-11db-
> > ca13-9d87f83b270b>
> > Check completed successfully in 0:00:40
> >   
> 
-- 
  Andre Mueninghoff
  andre_mueninghoff at fastmail.fm



More information about the chandler-dev mailing list