Skip site navigation (1) Skip section navigation (2)

what is WaitOnLock Error

From: "Bryan White" <bryan(at)arcamax(dot)com>
To: <pgsql-general(at)postgreSQL(dot)org>
Subject: what is WaitOnLock Error
Date: 1998-12-17 16:40:38
Message-ID: 008d01be29db$fa3e0de0$a3f0f6ce@bryan.arcamax.com (view raw or flat)
Thread:
Lists: pgsql-general
I get this error: WaitOnLock: error on wakeup - Aborting this transaction
What does it mean?

Background:
Running Postgres 6.4 on Linux.  I have a process to handle subscription
requests via email.  We are running QMail and it directs the mail to this
'c' program I wrote.  It parses the message and tries to add the user to the
database.

This is the sequence that occurs when the process fails:
    begin work
    select from customer .... returns 0 row (not on file).
    select nextval('seqcuscustid') returns next custid
    insert into customer ( custid, email ) values ( 9999,
'user(at)somedomain(dot)com');
This is where the error occurs

The process works all the time when I test it with single messages.  It
fails 75% of the time when I redirect a bunch of messages (These messages
have been accumulating in a Eudora mailbox while I got the process setup).

Might this be some sort of resource problem?

Bryan White
ArcaMax Inc.
Yorktown VA
www.arcamax.com


pgsql-general by date

Next:From: Hal SnyderDate: 1998-12-17 17:10:04
Subject: Re: [GENERAL] Why PostgreSQL is better than other commerial softwares?
Previous:From: HowieDate: 1998-12-17 16:29:13
Subject: Re: [GENERAL] Why PostgreSQL is better than other commerial softwares?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group