Re: [ADMIN] destroyed db/index (corruption) [SOLVED]

2007-02-07 Thread Achilleas Mantzios
Στις Πέμπτη 08 Φεβρουάριος 2007 00:07, ο/η Michael Monnerie έγραψε: > > But I'd like to suggest changing the ERROR to WARNING for "duplicate key > violates unique constraint", as it's not serious - but it sounds like a > big problem. > I dont think that would be appropriate. Attempt to violate a UN

Re: [ADMIN] destroyed db/index (corruption) [SOLVED]

2007-02-07 Thread Michael Monnerie
On Dienstag, 6. Februar 2007 08:46 Achilleas Mantzios wrote: > Thats what i mean, postmaster is alive, and accepting connections > during the above command, so what would prevent a 2nd client (from > your mail server setup most likely) > from inserting a value that is later present in the dump, > w

Re: [ADMIN] destroyed db/index (corruption)

2007-02-05 Thread Achilleas Mantzios
Στις Δευτέρα 05 Φεβρουάριος 2007 23:36, ο/η Michael Monnerie έγραψε: > On Montag, 5. Februar 2007 15:22 Achilleas Mantzios wrote: > > This ERROR is normally thrown when you *try* to violate a unique > > constraint. Can you demonstrate the presence of the UNIQUE constraint > > on your table and the

Re: [ADMIN] destroyed db/index (corruption)

2007-02-05 Thread Michael Monnerie
On Montag, 5. Februar 2007 15:22 Achilleas Mantzios wrote: > This ERROR is normally thrown when you *try* to violate a unique > constraint. Can you demonstrate the presence of the UNIQUE constraint > on your table and the pair of identical key values rows? > Post a description (\d) of your table, a

Re: [ADMIN] destroyed db/index (corruption)

2007-02-05 Thread Achilleas Mantzios
Στις Δευτέρα 05 Φεβρουάριος 2007 16:00, ο/η Michael Monnerie έγραψε: > dear list, > > I've found database corruptions occuring with openSUSE 10.1, postgreSQL > version # rpm -qa|grep postg > postgresql-libs-8.1.4-1.2 > postgresql-server-8.1.4-1.2 > postgresql-8.1.4-1.2 > > I found this in database

[ADMIN] destroyed db/index (corruption)

2007-02-05 Thread Michael Monnerie
dear list, I've found database corruptions occuring with openSUSE 10.1, postgreSQL version # rpm -qa|grep postg postgresql-libs-8.1.4-1.2 postgresql-server-8.1.4-1.2 postgresql-8.1.4-1.2 I found this in database logs: 2007-02-05 13:15:51 CET DB=bayes_pg3 HOST=195.202.170.130(54789) SESSTRT=2007

[ADMIN] destroyed db/index

2007-02-05 Thread Michael Monnerie
dear list, I've found database corruptions occuring with openSUSE 10.1, postgreSQL version # rpm -qa|grep postg postgresql-libs-8.1.4-1.2 postgresql-server-8.1.4-1.2 postgresql-8.1.4-1.2 I found this in database logs: 2007-02-05 13:15:51 CET DB=bayes_pg3 HOST=195.202.170.130(54789) SESSTRT=2007