[FractalizeR]

The following is the output of cronjob /usr/local/sphinx/cron/delta.sh:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Please look at ThreadPostDelta indexing:

WARNING: duplicate document ids found message appears. Is that a normal behavior of Sphinx? What is the document id used?

[sung]

I got the warning as well (so glad it isn't just me), which I've reported in the vbulletin.com forums.

It can cause all sorts of nasty problems with Sphinx.

There are a few different restrictions imposed on the source data which is going to be indexed by Sphinx, of which the single most important one is:

ALL DOCUMENT IDS MUST BE UNIQUE UNSIGNED NON-ZERO INTEGER NUMBERS (32-BIT OR 64-BIT, DEPENDING ON BUILD TIME SETTINGS).

If this requirement is not met, different bad things can happen. For instance, Sphinx can crash with an internal assertion while indexing; or produce strange results when searching due to conflicting IDs. Also, a 1000-pound gorilla might eventually come out of your display and start throwing barrels at you. You've been warned.

[FractalizeR]

The following combination is used in configuration file to make so-called Document ID, that MUST be unique:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

On some reason, it appears non-unique. However, I don't see how it can be other than really duplicating rows are returned by complete query

[graham_w]

Did you ever sort this out - i'm noticing the same error.

Cheers

[FractalizeR]

No, but it looks like it doesn't affect search quality.

[graham_w]

Thanks for the reply - yeah I did find a thread saying similar on the sphinx website.

Cheers

[JesterP]

Originally Posted by graham_w

Thanks for the reply - yeah I did find a thread saying similar on the sphinx website.

Cheers

I recieved in my inbox this morning:

--->8---

### SAVE ORDERED IDS TO SEARCH CACHE ###;

MySQL Error : Duplicate entry '92f3f32f09b269797e91242ce55639a6-lastpost-DESC' for key 2
Error Number : 1062
Request Date : Sunday, June 20th 2010 @ 10:44:01 AM

---8<---
Everything is still running and I am not seeing anything bad happening. No errors since.