Sessions being killed - out of memory?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux