Return-Path: postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id KAA01678 for postgres-dist; Thu, 20 Jan 1994 10:22:09 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199401201822.KAA01678@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from faerie.CS.Berkeley.EDU (faerie.CS.Berkeley.EDU [128.32.149.14]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id KAA01669 for ; Thu, 20 Jan 1994 10:22:08 -0800 Received: from localhost (aoki@localhost) by faerie.CS.Berkeley.EDU (8.6.4/8.1B) id KAA18189; Thu, 20 Jan 1994 10:22:00 -0800 Message-Id: <199401201822.KAA18189@faerie.CS.Berkeley.EDU> From: aoki@postgres.Berkeley.EDU (Paul M. Aoki) To: Gerhard Daub Cc: postgres@postgres.Berkeley.EDU Subject: Re: xid table corrupted Reply-To: postgres-bugs@postgres.Berkeley.EDU In-reply-to: Your message of Thu, 20 Jan 1994 10:56:04 +0100 <"irafs2.ira.842:20.00.94.09.55.54"@ira.uka.de> Date: Thu, 20 Jan 1994 10:22:00 -0800 X-Sender: aoki@postgres.Berkeley.EDU Resent-To: postgres-dist@postgres.Berkeley.EDU Resent-Date: Thu, 20 Jan 94 10:22:09 -0800 Resent-XMts: smtp Gerhard Daub writes: > When I run 2 transactions with begin/end-blocks at the same time > I obtain the following error message: > NOTICE:Jan 20 10:26:35:LockReplace: xid table corrupted > Can anyone give me a hint how I can recover from this error. this occurs when an entry is not found in the shared memory transaction id hash table. restarting the postmaster should clear the problem but i've never seen this in 4.1. please reply to postgres-bugs and specify the platform and version of postgres you are using. -- Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU | Berkeley, CA 94720 | ...!uunet!ucbvax!aoki