Re: [BUGS] BUG #3858: psql hangs if called as postgres is coming online

2008-01-13 Thread Faisal N. Jawdat
the system in question has made itself inoperable for the time being. as soon as i have it up again i'll get a dtruss report to the list. i am using 10.5, so that may be the issue. -faisal ---(end of broadcast)--- TIP 2: Don't 'kill -9' the

Re: [BUGS] BUG #3858: psql hangs if called as postgres is coming online

2008-01-12 Thread Tom Lane
"Faisal N. Jawdat" <[EMAIL PROTECTED]> writes: > If I use psql on a local database while the daemon is coming online, psql > hangs and most be killed. Subsequent psql processes will connect without > incident. FWIW, I just spent some time trying to duplicate this on OSX 10.4.11, without success.

Re: [BUGS] BUG #3858: psql hangs if called as postgres is coming online

2008-01-09 Thread Alvaro Herrera
Faisal N. Jawdat wrote: > Using a Mac, so no strace. dtruss of any use? Any luck with either dtruss or ktrace? -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(end of broadcast)-

Re: [BUGS] BUG #3858: psql hangs if called as postgres is coming online

2008-01-09 Thread Faisal N. Jawdat
ktrace apparently didn't make it to osx 10.5.1. hrm. let me dig around. -faisal On Jan 8, 2008, at 9:13 PM, Tom Lane wrote: Alvaro Herrera <[EMAIL PROTECTED]> writes: Faisal N. Jawdat wrote: Using a Mac, so no strace. dtruss of any use? Sure. Or ktrace, which seems standard on my M

Re: [BUGS] BUG #3858: psql hangs if called as postgres is coming online

2008-01-09 Thread Faisal N. Jawdat
Using a Mac, so no strace. dtruss of any use? -faisal On Jan 8, 2008, at 7:03 PM, Tom Lane wrote: Alvaro Herrera <[EMAIL PROTECTED]> writes: Can you get a backtrace of the hung psql process? strace'ing it up to the point of the hang might be informative too. regard

Re: [BUGS] BUG #3858: psql hangs if called as postgres is coming online

2008-01-08 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Faisal N. Jawdat wrote: >> Using a Mac, so no strace. dtruss of any use? > Sure. Or ktrace, which seems standard on my Macs whereas I don't see dtruss. Take your pick, we just want to see the sequence of kernel calls ... regar

Re: [BUGS] BUG #3858: psql hangs if called as postgres is coming online

2008-01-08 Thread Alvaro Herrera
Faisal N. Jawdat wrote: > Using a Mac, so no strace. dtruss of any use? Sure. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---(end of broadcast)---

Re: [BUGS] BUG #3858: psql hangs if called as postgres is coming online

2008-01-08 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Can you get a backtrace of the hung psql process? strace'ing it up to the point of the hang might be informative too. regards, tom lane ---(end of broadcast)--- TIP 1: if posting/

Re: [BUGS] BUG #3858: psql hangs if called as postgres is coming online

2008-01-08 Thread Faisal N. Jawdat
(gdb) backtrace #0 0x91542152 in poll$UNIX2003 () #1 0x0004867a in pqSocketCheck () #2 0x00048a41 in pqWaitTimed () #3 0x00042cbc in connectDBComplete () #4 0x00044b02 in PQsetdbLogin () #5 0xd30f in main () -faisal On Jan 8, 2008, at 6:34 PM, Alvaro Herrera wrote: Faisal N. Jawdat

Re: [BUGS] BUG #3858: psql hangs if called as postgres is coming online

2008-01-08 Thread Alvaro Herrera
Faisal N. Jawdat wrote: > If I use psql on a local database while the daemon is coming online, psql > hangs and most be killed. Subsequent psql processes will connect without > incident. This is strange. When the postmaster is not ready to receive connections, psql is supposed to die with an er

[BUGS] BUG #3858: psql hangs if called as postgres is coming online

2008-01-08 Thread Faisal N. Jawdat
The following bug has been logged online: Bug reference: 3858 Logged by: Faisal N. Jawdat Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Mac OS X Description:psql hangs if called as postgres is coming online Details: If I use psql on a