Hello,
On Thu, 11 Jan 2001, Alexander Barkov wrote:
> > Author: mocha
> > Email: [EMAIL PROTECTED]
> > Message:
> > i see a lot of these errors in my postgres log:
> >
> > ERROR: Cannot insert a duplicate key into unique index url_url
...
> > ERROR: Cannot insert a duplicate key into unique index url_url
> >
> > is that normal?
>
> This is normal. indexer is trying to add documents which are already in
> the database. It ignores "duplicate key" errors after an attempt to run
>
> "INSERT INTO url ...".
Looks like indexer is sometimes "sucesfull" in inserting duplicate URL
into url table because it happens quite a few times to me that I dumped DB
for backup and when trying to restore it, I get error:
ERROR: Cannot insert a duplicate key into unique index url_url
It happens with older mnogosearch 3.1.x indexers and it also happens with
mnogosearch 3.1.12 indexer and clean database at start. I'm using
PostgreSQL 7.0.3 on Linux 2.4.3, glibc 2.2.1, threads enabled (and used 2
threads when indexing).
Sincerely
Peter Hanecak
--
===================================================================
Peter Hanecak <[EMAIL PROTECTED]>
GPG pub.key: http://www.megaloman.com/gpg/hanecak-megaloman.txt
===================================================================
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
