Re: postgres idle process and other problems

From: "Steve Brett" <steve(dot)brett(at)e-mis(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: postgres idle process and other problems
Date: 2001-12-03 13:39:48
Message-ID: 9ufvie$2273$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

what's Orion Application Server ?

i've had this kind of error before and traced it to a bug in some Zeos
Delphi Postgres components.

it (in my case) was caused by a transaction not comitting and then postgres
waiting for the transaction to commit and everything else in the transaction
queue piling up behind it.

i noticed by realising postgresql was locking up when i tried to vacuum.

it sounds like a buggy bit of transaction code in Orion app server ....

Steve

"Peter Peltonen" <peter(dot)peltonen(at)fivetec(dot)com> wrote in message
news:20011203144814(dot)G1859(at)pihlaja(dot)kotilo(dot)(dot)(dot)
> We've had postgresql 7.1.2 and Orion application server 1.4.7 serving our
> app successfully for a few months now without any problems on Red Hat 7.1
> system.
>
> Recently we found out that our app was not responding. We stopped postgres
> and orion and tried starting them. The app wouldn't work. After each site
> loaded we find these strange idle postgres processes:
>
> --<snip>--
> tcp_da S pts/1 0:00 postgres: postgres ourapp <our-public-ip>
> idle
> tcp_da S pts/1 0:00 postgres: postgres ourapp <our-public-ip>
> idle in
> transaction
> tcp_da S pts/1 0:00 postgres: postgres designforum <our-public-ip>
> idle
> in transaction
> --</snip>--
>
> After bunch of restarts the app suddenly started working.
>
> In postgres log we see this:
>
> --<snip>--
> DEBUG: database system was shut down at 2001-11-30 21:06:03 EET
> DEBUG: CheckPoint record at (0, 144404276)
> DEBUG: Redo record at (0, 144404276); Undo record at (0, 0); Shutdown
> TRUE
> DEBUG: NextTransactionId: 1290155; NextOid: 44983
> DEBUG: database system is in production state
> Server process (pid 14764) exited with status 9 at Fri Nov 30 21:12:18
> 2001
> Terminating any active server processes...
> Server processes were terminated at Fri Nov 30 21:12:18 2001
> Reinitializing shared memory and semaphores
> DEBUG: database system was interrupted at 2001-11-30 21:11:58 EET
> DEBUG: CheckPoint record at (0, 144437508)
> DEBUG: Redo record at (0, 144437508); Undo record at (0, 0); Shutdown
> FALSE
> DEBUG: NextTransactionId: 1290586; NextOid: 53175
> DEBUG: database system was not properly shut down; automatic recovery in
> progress...
> DEBUG: ReadRecord: record with zero len at (0, 144437572)
> DEBUG: redo is not required
> The Data Base System is starting up
> The Data Base System is starting up
> The Data Base System is starting up
> The Data Base System is starting up
> DEBUG: database system is in production state
> pq_recvbuf: unexpected EOF on client connection
> pq_recvbuf: unexpected EOF on client connection
> ERROR: Bad date external representation 'date(2001-1111-9)'
> pq_recvbuf: recv() failed: Connection reset by peer
> pq_recvbuf: unexpected EOF on client connection
> pq_recvbuf: unexpected EOF on client connection
> ERROR: parser: parse error at or near "k"
> ERROR: parser: parse error at or near "k"
> ERROR: parser: parse error at or near "k"
> ERROR: parser: parse error at or near "k"
> pq_recvbuf: unexpected EOF on client connection
> pq_recvbuf: unexpected EOF on client connection
> --</snip>--
>
> Those pq_recvbuf there is a bunch more in the log.
>
> What are those ERRORs? Any ideas what has happened and is going on?
>
> Regards,
> Peter
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2001-12-03 13:53:53 Re: which physical file does postgreSQL stores data?
Previous Message Peter Peltonen 2001-12-03 12:48:14 postgres idle process and other problems