Re: process hangs using perl?

Patrick,

Can you provide the code (or at least the relevant parts) for us to look at?

Quoting Patrick Hatcher <PHatcher(at)macys(dot)com>:

> Running a perl script against my dev server (pg 7.3.4) that currently runs
> fine on the production server. And for some reason Pg always seems to hang
> during the process (see below for Top print out). This happens randomily
> throughout the script and can be on a SELECT, INSERT, or UPDATE statement,
> but doesn't cause the Pg server to go down (which is good). Any
> suggestions on where to start looking?
>
> Perl version 5.6.1
>
>
>
>
> ---Top print out
>
> 4:08pm up 23 days, 4:46, 3 users, load average: 1.00, 1.05, 1.39
> 78 processes: 75 sleeping, 2 running, 1 zombie, 0 stopped
> CPU0 states: 30.4% user, 4.0% system, 0.0% nice, 64.4% idle
> CPU1 states: 47.0% user, 3.3% system, 0.0% nice, 49.0% idle
> Mem: 513640K av, 505332K used, 8308K free, 0K shrd, 13176K
> buff
> Swap: 2044056K av, 48624K used, 1995432K free 356028K
> cached
>
> PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
> 16094 postgres 14 0 98.8M 97M 18900 R 85.2 19.4 31:38 postgres:
> phatcher mdc_oz [local] SELECT
> 16655 postgres 9 0 1052 1052 836 R 0.1 0.2 0:00 top
> 14397 postgres 8 0 1964 1840 1708 S 0.0 0.3 0:00
> /usr/local/postgresql7.3.4/bin/postmaster
> 14398 postgres 9 0 2932 2780 1700 S 0.0 0.5 0:03 postgres:
> stats buffer process
> 14399 postgres 9 0 2168 2016 1704 S 0.0 0.3 0:05 postgres:
> stats collector process
> 16074 postgres 9 0 23836 20M 18884 S 0.0 4.1 16:24 postgres:
> phatcher mdc_oz [local] SELECT waiting
> 16076 postgres 9 0 21792 20M 18916 S 0.0 4.1 644:42 postgres:
> phatcher mdc_oz [local] SELECT waiting
> 16546 postgres 9 0 17988 16M 17208 S 0.0 3.3 0:11 postgres:
> phatcher mdc_oz [local] SELECT waiting
> 16650 postgres 9 0 1332 1332 1060 S 0.0 0.2 0:00 /bin/bash
>
>
> TIA
>
> Patrick Hatcher
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
Keith C. Perry
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com