I have been developing two sites which revolve around the management and workflow of complex forms. On one of these sites, I created a content type using CCK. The content contains about 40 varied fields, some in groups. Some of the fields contain long text with complex medical terms. I loaded the database with 5000 forms and ran cron to get everything indexed.
The search results were incomplete. If I searched for a keyword that should find 13 documents, I might only find 7. If I touch the missing document (edit/save) and re-run cron. The search returns 13 documents.
I have tried re-indexing the whole database - resulting in different, incomplete results.
Clearly something is going on during the cron, but I get no errors.
I put in an issue with Drupal core. They think the problem is in CCK.
The last reply I got was "I'm sorry, but I cannot troubleshoot your site in any way."
So now I need your help. How DO I troubleshoot this problem?
How do I break down what's happening in the cron to find this problem?
Drupal 6.19
CCK 6.x-3.x-dev