[Postgres-list] constraint violation

[Dr. Martin Körfer]

Hi,

On our "mailserver" I'm running
Horde 2.2.5
IMP 3.2.3
Turba 1.2.2
UW-IMAP 2002e
based on
PostgreSQL 7.4

After a System-Crash, when logging in, some users (not all) received a:

DB Error: constraint violation

 [line 332 of /usr/opt/IAE630/usr/internet/horde/lib/Prefs/sql.php]

After a "smart" restart of thr postgres_DB the following message occurred
permantly:

ERROR:  xlog flush request 0/12305270 is not satisfied --- flushed only to 0/122
B3B40
CONTEXT:  writing block 423 of relation 17143/25286
ERROR:  xlog flush request 0/12305270 is not satisfied --- flushed only to 0/122
B3B40
CONTEXT:  writing block 423 of relation 17143/25286
WARNING:  could not write block 423 of 17143/25286
DETAIL:  Multiple failures --- write error may be permanent.
ERROR:  xlog flush request 0/12305270 is not satisfied --- flushed only to 0/122
B3B40
CONTEXT:  writing block 423 of relation 17143/25286
WARNING:  could not write block 423 of 17143/25286
DETAIL:  Multiple failures --- write error may be permanent.


This seemed to be an inconsistency in the postgres-DB
Can anybody tell me what to do to make the database accessible again for all
users??
Any hint would be welcome.
Thanks in advance

Martin
--
Dr. Martin Körfer
MPI f. Chemie
EDV
J.J.Becherweg 27
D-55128 Mainz

Tel. -49-6131/305541
Fax  -49-6131/305318

-------------------------------------------------
This mail sent through IMP: webmail.mpch-mainz.mpg.de