[Zope] ZCatalog: Possibly corrupted Date Field Indexes in Zope 2.3.3

Johan Carlsson [Torped] johanc@torped.se
Thu, 21 Feb 2002 09:09:05 +0100


Hi all,
We have just experienced a strange phenomena in the ZCatalog of Zope 2.3.3.

Everything seems to work alright except for searches using range:min,=
 range:max
and range:min:max on field indexes indexing dates.

Using ranges on field indexes with dates result in empty result sets.

To solve the problem we just had to remove the ZCatalog, re add it and
re index all items. The it worked perfect again.

The web master for the site claims that the error occurred sometime
during the night. (This might be a false observation from his account.)
Anyway, undoing all transaction one day back past the supposed
"event" that might have triggered the corruption didn't solve the problem.

So I wonder:

1. What could have happen?
2. Could it be that something not of Date type had been indexed?
3. How could I investigate what did happen?
     Is there any logging capability that might trap this kind of failures?
     (I'm currently waiting for a CD with all log files and the corrupted=20
Data.fs.)

Thanks in advance,
Johan Carlsson


torped strategi och kommunikation ab
johan carlsson
johanc@torped.se
birkagatan 9
113 36 stockholm
v=E4stmannagatan 67
http://www.torped.se
http://easypublisher.torped.se