From owner-freebsd-bugs@FreeBSD.ORG Thu Mar 6 09:40:01 2008 Return-Path: Delivered-To: freebsd-bugs@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 47F89106567A for ; Thu, 6 Mar 2008 09:40:01 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id 254FF8FC1A for ; Thu, 6 Mar 2008 09:40:01 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.14.2/8.14.2) with ESMTP id m269e1Tu070051 for ; Thu, 6 Mar 2008 09:40:01 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.2/8.14.1/Submit) id m269e0Pl070050; Thu, 6 Mar 2008 09:40:00 GMT (envelope-from gnats) Resent-Date: Thu, 6 Mar 2008 09:40:00 GMT Resent-Message-Id: <200803060940.m269e0Pl070050@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Dmitry Rybin Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 431B31065670 for ; Thu, 6 Mar 2008 09:32:16 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from www.freebsd.org (www.freebsd.org [IPv6:2001:4f8:fff6::21]) by mx1.freebsd.org (Postfix) with ESMTP id 325CA8FC14 for ; Thu, 6 Mar 2008 09:32:16 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from www.freebsd.org (localhost [127.0.0.1]) by www.freebsd.org (8.14.2/8.14.2) with ESMTP id m269TCEI081166 for ; Thu, 6 Mar 2008 09:29:12 GMT (envelope-from nobody@www.freebsd.org) Received: (from nobody@localhost) by www.freebsd.org (8.14.2/8.14.1/Submit) id m269TC2T081165; Thu, 6 Mar 2008 09:29:12 GMT (envelope-from nobody) Message-Id: <200803060929.m269TC2T081165@www.freebsd.org> Date: Thu, 6 Mar 2008 09:29:12 GMT From: Dmitry Rybin To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.1 Cc: Subject: kern/121423: Cann't allocate more 2 Gb shared memory X-BeenThere: freebsd-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 06 Mar 2008 09:40:01 -0000 >Number: 121423 >Category: kern >Synopsis: Cann't allocate more 2 Gb shared memory >Confidential: no >Severity: serious >Priority: medium >Responsible: freebsd-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: sw-bug >Submitter-Id: current-users >Arrival-Date: Thu Mar 06 09:40:00 UTC 2008 >Closed-Date: >Last-Modified: >Originator: Dmitry Rybin >Release: 7.0-RELEASE >Organization: Kirgudu Co >Environment: FreeBSD cayman.asd.net 7.0-RELEASE FreeBSD 7.0-RELEASE #0: Sun Feb 24 10:35:36 UTC 2008 root@driscoll.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC amd6 >Description: Any programm which use SHARED MEMORY cann't allocate more 2 Gb of Shared memory. as example starting postgres with 2GB shmem: Mar 6 10:46:42 cayman postgres[1486]: [1-1] FATAL: could not create shared memory segment: Invalid argument Mar 6 10:46:42 cayman postgres[1486]: [1-2] DETAIL: Failed system call was shmget(key=5432001, size=2157543424, 03600). Mar 6 10:46:42 cayman postgres[1486]: [1-3] HINT: This error usually means that PostgreSQL's request for a shared memory segment exceeded your kernel's SHMMAX parameter. Mar 6 10:46:42 cayman postgres[1486]: [1-4] You can either reduce the request size or reconfigure the kernel with larger SHMMAX. To reduce the request size (currently Mar 6 10:46:42 cayman postgres[1486]: [1-5] 2157543424 bytes), reduce PostgreSQL's shared_buffers parameter (currently 256000) and/or its max_connections parameter Mar 6 10:46:42 cayman postgres[1486]: [1-6] (currently 83). Mar 6 10:46:42 cayman postgres[1486]: [1-7] If the request size is already small, it's possible that it is less than your kernel's SHMMIN parameter, in which case raising Mar 6 10:46:42 cayman postgres[1486]: [1-8] the request size or reconfiguring SHMMIN is called for. Mar 6 10:46:42 cayman postgres[1486]: [1-9] The PostgreSQL documentation contains more information about shared memory configuration. # sysctl -a|grep ipc.sem kern.ipc.semaem: 16384 kern.ipc.semvmx: 32767 kern.ipc.semusz: 104 kern.ipc.semume: 10 kern.ipc.semopm: 100 kern.ipc.semmsl: 60 kern.ipc.semmnu: 256 kern.ipc.semmns: 512 kern.ipc.semmni: 256 kern.ipc.semmap: 512 sysctl -a|grep shm kern.ipc.shm_allow_removed: 0 kern.ipc.shm_use_phys: 1 kern.ipc.shmall: 65536000 kern.ipc.shmseg: 128 kern.ipc.shmmni: 192 kern.ipc.shmmin: 1 kern.ipc.shmmax: 268435456010 Hardware: HP360R05 2 Quad Core Xeon, 8Gb mem, HP p800i raid >How-To-Repeat: 1. Install FreeBSD 7 2. Install Posgress 8.3 3 . postgresql.conf shared_buffers = 2200MB 4. edit sysctl # sysctl -a|grep ipc.sem kern.ipc.semaem: 16384 kern.ipc.semvmx: 32767 kern.ipc.semusz: 104 kern.ipc.semume: 10 kern.ipc.semopm: 100 kern.ipc.semmsl: 60 kern.ipc.semmnu: 256 kern.ipc.semmns: 512 kern.ipc.semmni: 256 kern.ipc.semmap: 512 sysctl -a|grep shm kern.ipc.shm_allow_removed: 0 kern.ipc.shm_use_phys: 1 kern.ipc.shmall: 65536000 kern.ipc.shmseg: 128 kern.ipc.shmmni: 192 kern.ipc.shmmin: 1 kern.ipc.shmmax: 268435456010 5. start postgress >Fix: >Release-Note: >Audit-Trail: >Unformatted: