Good Morning,
I'm repeatedly getting a session killed error while trying to run a series of queries:
/opt/postgres/9.1/bin/psql: line 30: 5560 Killed LD_PRELOAD=$PLL LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$PG_BIN_PATH/../lib "$PG_BIN_PATH/psql.bin" "$@"
/opt/postgres/9.1/bin/psql: line 30: 5701 Killed LD_PRELOAD=$PLL LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$PG_BIN_PATH/../lib "$PG_BIN_PATH/psql.bin" "$@"
/opt/postgres/9.1/bin/psql: line 30: 5781 Killed LD_PRELOAD=$PLL LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$PG_BIN_PATH/../lib "$PG_BIN_PATH/psql.bin" "$@"
I'm not seeing a whole lot about this error online. Has anyone else run into this issue? I'm thinking it is a memory problem but am not sure. I'm not the system administrator, just the dba.
Here's a vmstat run:
[postgres@vmdb05-qa dump]$ vmstat 10 5
procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu-----
r b swpd free buff cache si so bi bo in cs us sy id wa st
1 1 458008 167648 6280 7208016 0 0 330 271 1 1 1 0 97 2 0
0 1 458008 148304 6272 7227352 0 0 22074 139 1029 1657 4 1 50 45 0
0 1 458008 147548 5996 7228640 0 0 21304 141 986 1543 5 1 50 44 0
0 1 458008 165776 5984 7210004 0 0 19110 138 892 1389 4 1 50 45 0
0 1 458008 130808 5992 7245164 0 0 12104 138 575 996 2 1 50 47 0
Top stats:
top - 08:54:11 up 270 days, 19:42, 3 users, load average: 1.00, 0.95, 0.59
Tasks: 240 total, 1 running, 239 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.2%us, 0.2%sy, 0.0%ni, 97.1%id, 1.5%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 8062088k total, 7918524k used, 143564k free, 6184k buffers
Swap: 2047992k total, 457864k used, 1590128k free, 7159444k cached
Here are some configuration details:
The PostgreSQL version is 9.1.9. The server is Red Hat Enterprise Linux Server release 6.2 (Santiago) on a VM machine - 8 GB RAM with 2 CPUs:
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 2
On-line CPU(s) list: 0,1
Thread(s) per core: 1
Core(s) per socket: 2
CPU socket(s): 1
NUMA node(s): 1
Vendor ID: GenuineIntel
CPU family: 6
Model: 44
Stepping: 2
CPU MHz: 2660.000
BogoMIPS: 5320.00
L1d cache: 32K
L1i cache: 32K
L2 cache: 256K
L3 cache: 12288K
NUMA node0 CPU(s): 0,1
Thanks,
Johnh