Hi Guys, Yesterday I deployed 3.0.1 to one of our connection pool servers, however the machine appears to have crashed after running out of memory.
I've just run a simple test here, with pgpool in raw mode. All I've done is write a program to connect, prepare, execute and deallocate a statement over and over in a loop. The program has been running for about hour and the child pgpool process is using 600Mb of memory and increasing (see below). Any ideas how to track this down? Thanks Glyn Way5-pool:/var/log# cat /proc/2885/status Name: pgpool State: S (sleeping) Tgid: 2885 Pid: 2885 PPid: 2852 TracerPid: 0 Uid: 1000 1000 1000 1000 Gid: 1 1 1 1 FDSize: 64 Groups: 1 VmPeak: 629344 kB VmSize: 629344 kB VmLck: 0 kB VmHWM: 561736 kB VmRSS: 561736 kB VmData: 560780 kB VmStk: 88 kB VmExe: 824 kB VmLib: 6840 kB VmPTE: 1224 kB Threads: 1 SigQ: 0/16375 SigPnd: 0000000000000000 ShdPnd: 0000000000000000 SigBlk: 0000000000000000 SigIgn: 0000000000003000 SigCgt: 0000000180004a07 CapInh: 0000000000000000 CapPrm: 0000000000000000 CapEff: 0000000000000000 CapBnd: ffffffffffffffff Cpus_allowed: 0000000f Cpus_allowed_list: 0-3 Mems_allowed: 00000000,00000003 Mems_allowed_list: 0-1 voluntary_ctxt_switches: 2314936 nonvoluntary_ctxt_switches: 77355 _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general