[Zope] Re: Index Problem - Index randomly breaks/changes

[Tres Seaver]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Ryan Smith wrote:
> Posted this to the Plone Mailing-list, but this is more of a problem I
> am having with Zope.  There will be additional information here -
> http://www.nabble.com/Indexing-Bug---Index-changes-and-is-not-always-correct.-td15830136s6742.html
> 
> Basically the problem I am having is that I create an index, but
> sometimes this index changes and is incorrect.
> 
> To test this I would constantly click the 'Clear and Rebuild' button
> under the Advanced Tab.
> Then I would browse my index under the Indexes tab.
> 
> After repeating this many many times, I would get 2 different results
> for my index (1 correct, the other completely wrong). I didn't change
> anything else, I just kept clicking rebuild.


We need more information:

 - What kind of index?

 - What objects are you indexing?

 - What kind of query are you making against the index?

 - What does "completely wrong" mean?


> I noticed something interesting in my debugging window.
> All rebuilds that resulted in a correct index had this -
> DEBUG txn.-1223402608 commit <Connection at 0b5a01ec>
> All rebuilds that resulted in an incorrect index had this -
> DEBUG txn.-1244382320 commit <Connection at 0965020c>
> 
> Something different is being done, I'm just not sure what or why.
> 
> Any suggestions as to why this is happening or where I should look to
> fix this would be greatly appreciated.

The two log messages you post are effectively identical:  some get
served from different ZODB connections, but that shouldn't cause any
difference in behavior.  If you have one connection with "stale" data
for some objects (that would be a bug somewhere), then restarting Zope
might make the problem disappear, although we still wouldn't know how
that connection got into that state.


Tres.
- --
===================================================================
Tres Seaver          +1 540-429-0999          tseaver at palladion.com
Palladion Software   "Excellence by Design"    http://palladion.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFH0BOw+gerLs4ltQ4RAk7HAJ0c5dHw964LnCVxTDevHhm/zhPDAgCfX1me
/Y9SIhh2PYLicWgCvLLwh24=
=H0lL
-----END PGP SIGNATURE-----