Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Admin > Re: duplicate p...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 9 of 17 Topic 4908 of 5167
Post > Topic >>

Re: duplicate primary index in bayes db from SpamAssassin

by michael.monnerie@[EMAIL PROTECTED] (Michael Monnerie) Apr 17, 2008 at 09:45 AM

--nextPart71089827.4eRB2LC9p7
Content-Type: text/plain;
  charset="iso-8859-15"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On Mittwoch, 16. April 2008 Michael Monnerie wrote:
> problem with duplicate primary index entries...

I created the bayes db fresh, named it bayes_pg_v2 and re-relearned all=20
ham/spam from 3 concurrent connections into the db. No problem so far.

But I renamed the old, broken db and tried a=20
and got this:
INFO:  =BBbayes_token=AB: 20567514 entfernbare, 4752337 nicht
entfernbare=20
Zeilenversionen in 186274 Seiten gefunden
DETAIL:  0 tote Zeilenversionen k=F6nnen noch nicht entfernt werden.
Nicht entfernbare Zeilenversionen sind zwischen 56 und 56 Bytes lang.
Es gibt 0 unbenutzte Itemzeiger.
Gesamter freier Platz (einschlie=DFlich entfernbare Zeilenversionen)
ist=20
1154820852 Bytes.
33480 Seiten sind leer oder werden leer werden, einschlie=DFlich 0 am
Ende=
=20
der Tabelle.
186149 Seiten mit 1154819352 freien Bytes sind m=F6gliche Ziele zum=20
Verschieben.

It looks like autovacuum - which is on - could not be run, and the db=20
growed a lot, and now a VACUUM cannot finish because of the duplicate=20
index:
INFO:  Index =BBbayes_token_pkey=AB enth=E4lt 2539650 Zeilenversionen in
76=
273=20
Seiten
DETAIL:  0 Indexzeilenversionen wurde entfernt.
11727 Indexseiten wurden gel=F6scht, 11727 sind gegenw=E4rtig=20
wiederverwendbar.
CPU 10.44s/2.49u sec elapsed 172.59 sec.
WARNUNG:  Index =BBbayes_token_pkey=AB enth=E4lt 2539650 Zeilenversionen,
a=
ber=20
Tabelle enth=E4lt 4752337 Zeilenversionen
TIP:  Bauen Sie den Index mit REINDEX neu.

But REINDEX doesn't work of course, because of the duplicates...

I'd like to drop that broken db, or should I keep it for analyzation?

mfg zmi
=2D-=20
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0676/846 914 666                      .network.your.ideas.
// PGP Key:         "curl -s http://zmi.at/zmi.asc
| gpg --im****t"
// Fingerprint: AC19 F9D5 36ED CD8A EF38  500E CE14 91F7 1C12 09B4
// Keyserver: www.keyserver.net                   Key-ID: 1C1209B4

--nextPart71089827.4eRB2LC9p7
Content-Type: application/pgp-signature; name=signature.asc 
Content-Description: This is a digitally signed message part.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4-svn0 (GNU/Linux)

iD8DBQBIBwAvzhSR9xwSCbQRAq4uAKCSqqoN/HP0URn5CUeMHaqGqu8OJACgtvxU
QkHAepyFbTa3K31HbPxrIBs=
=4Jcp
-----END PGP SIGNATURE-----

--nextPart71089827.4eRB2LC9p7--
 




 17 Posts in Topic:
duplicate primary index in bayes db from SpamAssassin
michael.monnerie@[EMAIL P  2008-04-14 17:57:11 
Re: duplicate primary index in bayes db from SpamAssassin
tgl@[EMAIL PROTECTED] (T  2008-04-14 12:00:01 
Re: duplicate primary index in bayes db from SpamAssassin
michael.monnerie@[EMAIL P  2008-04-14 21:31:10 
Re: duplicate primary index in bayes db from SpamAssassin
michael.monnerie@[EMAIL P  2008-04-15 08:26:31 
Re: duplicate primary index in bayes db from SpamAssassin
alvherre@[EMAIL PROTECTED  2008-04-14 12:03:25 
Re: duplicate primary index in bayes db from SpamAssassin
michael.monnerie@[EMAIL P  2008-04-14 22:10:42 
Re: duplicate primary index in bayes db from SpamAssassin
michael.monnerie@[EMAIL P  2008-04-15 20:27:30 
Re: duplicate primary index in bayes db from SpamAssassin
michael.monnerie@[EMAIL P  2008-04-16 01:56:39 
Re: duplicate primary index in bayes db from SpamAssassin
michael.monnerie@[EMAIL P  2008-04-17 09:45:50 
Re: duplicate primary index in bayes db from SpamAssassin
tgl@[EMAIL PROTECTED] (T  2008-04-17 11:41:31 
Re: duplicate primary index in bayes db from SpamAssassin
michael.monnerie@[EMAIL P  2008-04-18 01:20:24 
Re: duplicate primary index in bayes db from SpamAssassin
tgl@[EMAIL PROTECTED] (T  2008-04-17 20:15:23 
Re: duplicate primary index in bayes db from SpamAssassin
michael.monnerie@[EMAIL P  2008-04-18 01:28:14 
Re: duplicate primary index in bayes db from SpamAssassin
tgl@[EMAIL PROTECTED] (T  2008-04-30 16:25:49 
Re: duplicate primary index in bayes db from SpamAssassin
michael.monnerie@[EMAIL P  2008-05-07 11:03:53 
Re: duplicate primary index in bayes db from SpamAssassin
tgl@[EMAIL PROTECTED] (T  2008-05-07 10:32:54 
Re: duplicate primary index in bayes db from SpamAssassin
michael.monnerie@[EMAIL P  2008-05-07 16:42:38 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Aug 20 7:53:59 CDT 2008.