birt - Postgresql - could not create shared memory segment: Cannot allocate memory -
this question has been asked many times, response given / worked not working me. so, suspicious else missing.
os: $ cat /proc/version linux version 2.6.32-431.29.2.el6.x86_64 (mockbuild@x86-026.build.eng.bos.redhat.com) (gcc version 4.4.7 20120313 (red hat 4.4.7-4) (gcc) ) #1 smp sun jul 27 15:55:46 edt 2014
when try start postgresql, following error :
[reportadmin /opt/birt/modules/birtihub]$ ./startpostgresql.sh starting startpostgresql @ fri 05/15/2015 08:03:29 ac_server_home=/opt/birtihubftype/modules/birtihub/ihub 2015-05-15 12:03:30 utc 27379 log: loaded library "pg_stat_statements" 2015-05-15 12:03:30 utc 27379 fatal: not create shared memory segment: cannot allocate memory 2015-05-15 12:03:30 utc 27379 detail: failed system call shmget(key=8433001, size=290635776, 03600). 2015-05-15 12:03:30 utc 27379 hint: error means postgresql's request shared memory segment exceeded available memory or swap space, or exceeded kernel's shmall parameter. can either reduce request size or reconfigure kernel larger shmall. reduce request size (currently 290635776 bytes), reduce postgresql's shared memory usage, perhaps reducing shared_buffers or max_connections. postgresql documentation contains more information shared memory configuration. pg_ctl: not start server examine log output.
also, have adjusted shmmax , shmall values greater , less (respect) requested value.
[root /opt/birt]$ sysctl -p .... kernel.msgmnb = 65536 kernel.msgmax = 65536 kernel.shmmax = 68719476736 kernel.shmall = 134217728
in other words:
shmall =134217728 requested =290635776 shmmax =68719476736
any idea wrong ?
d
Comments
Post a Comment