I can't believe that. The only thing that I can realize is that
it is the PostgreSQL  who sometimes is "successul" in inserting
duplicate keys. 


Peter Hanecak wrote:
> 
> 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).
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]

Reply via email to