From owner-freebsd-questions@FreeBSD.ORG Wed Dec 5 22:59:36 2007 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 478E016A41A for ; Wed, 5 Dec 2007 22:59:36 +0000 (UTC) (envelope-from gergely.czuczy@harmless.hu) Received: from marvin.harmless.hu (marvin.harmless.hu [195.56.55.204]) by mx1.freebsd.org (Postfix) with ESMTP id CA05F13C469 for ; Wed, 5 Dec 2007 22:59:35 +0000 (UTC) (envelope-from gergely.czuczy@harmless.hu) Received: from localhost (marvin-mail [192.168.0.2]) by marvin.harmless.hu (Postfix) with ESMTP id 3A5A07C0BBF; Wed, 5 Dec 2007 23:59:34 +0100 (CET) X-Virus-Scanned: by amavisd-new-2.4.2 (20060627) (Debian) at harmless.hu Received: from marvin.harmless.hu ([192.168.0.2]) by localhost (marvin.harmless.hu [192.168.0.2]) (amavisd-new, port 10024) with ESMTP id LICtm-sS69-n; Wed, 5 Dec 2007 23:59:33 +0100 (CET) Received: from marvin.harmless.hu (localhost [127.0.0.1]) by marvin.harmless.hu (Postfix) with ESMTP id 37A967C0B47; Wed, 5 Dec 2007 23:59:32 +0100 (CET) Date: Wed, 5 Dec 2007 23:59:32 +0100 From: Gergely CZUCZY To: Mark Tinguely Message-ID: <20071205225932.GB15474@harmless.hu> References: <20071205114619.GA32423@harmless.hu> <200712051701.lB5H12Ih058055@casselton.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=x-unknown; protocol="application/pgp-signature"; boundary="1UWUbFP1cBYEclgG" Content-Disposition: inline In-Reply-To: <200712051701.lB5H12Ih058055@casselton.net> User-Agent: mutt-ng/devel-r804 (FreeBSD) Cc: freebsd-questions@freebsd.org Subject: Re: more then 2G shm on RELENG_7 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 05 Dec 2007 22:59:36 -0000 --1UWUbFP1cBYEclgG Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Dec 05, 2007 at 11:01:02AM -0600, Mark Tinguely wrote: >=20 > on Wed Dec 5 12:11:15 2007, Gergely Czuczy asks: > > > > I'm to test PostgreSQL on a 7-BETA3. The box has 12GB of memory in it, > > I've adjusted the sysctls, but postgresql always fails to allocate the > > SHM if it's bigger then 2GB. > > > > How can I make it to allocate more SHM than 2G at once? > > > > sysctl.conf: > > kern.ipc.shmall=3D3D1572864 > > kern.ipc.shmmax=3D3D6442450944 > > kern.ipc.semmap=3D3D1024 > > kern.ipc.shm_use_phys=3D3D1 > > > > /boot/loader.conf: > > zfs_load=3D3D"YES" > > vm.kmem_size=3D3D"1073741824" > > vm.kmem_size_max=3D3D"1073741824" > > kern.ipc.semmni=3D3D1024 > > kern.ipc.semmns=3D3D2048 > > kern.ipc.semmnu=3D3D1024 > > > > I've also hit a similar issue with qemu, but that wasn't shared memory, > > I had just tried to make it allocate more than 2GBs for a single vm, b= ut > > that also failed. Still haven't figured out why was that. >=20 > Is this an i386 or amd64 arch? >=20 > What is the returned error code? (this might tell a lot). >=20 > I notice that the allocation size for the syscall is an "int". Amd64, of course. Dec 5 11:43:11 sqltest postgres[1091]: [1-1] FATAL: could not create shar= ed memory segment: Cannot allocate memory Dec 5 11:43:11 sqltest postgres[1091]: [1-2] DETAIL: Failed system call w= as shmget(key=3D5432001, size=3D2151309312, 03600). That's all I got from the logs. Sincerely, Gergely Czuczy mailto: gergely.czuczy@harmless.hu --=20 Weenies test. Geniuses solve problems that arise. --1UWUbFP1cBYEclgG Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) owGVVc9rJEUUzu6iYMMe8g/II5esZLrTPdOTmbRMYpLJZgMb/JGBICGEmp433eV0 V02qqjOZHPQq4kHUm4IXQTwIgrI3L+JVvXgWQUEET/oP+Ko7k2xI9iBkDql673vf q/e9rz+4f2/u7vxPX397uPT+h5/c+er57/pLeWGMSNycqVMu3MD3Azdohq3QDQK3 Gbf7rf6qPxww1h6u7hy4vS0pDArj9qZjjMDgmVkeZ4yLlyFOmdJoOoUZum1nFtfl eiw1N1yKCLjIuMDLu55iQg9RudsilgMukghOCmlw4I4VF4b1M3ScVwUc4KAGXYzB b9ag7vstYAaCIPLpr76xB66/4vs12GNqBD2CKTCbwkQRUuSsdeq+swZSgIUpUaAJ QT2i/KBZotVgB1Vic7bOi/h8CkyPNGXCmv0B7C7mYCT1qg28JrVJFO6//thCMmi5 m9u9jYYHvRShL88gZZrQdzZBDiHHXKopdQ3c1GZYpwhs8FahqU0wlKSnOjaZrkG/ MDCu4PVJBiybsKmGIeOZtuVZlsmYGbRJFdb+oz3gQ8Je1NDnSYLK3gmg6t4V+0dy AjETsAs5GyFFXwMjglgCmZTZTPuyUsS4fgVQEfRiKYZRdTJCJTw+jj2d5oTUaXQb 3aDZqrdXwpsBOTsrA1bCsB42/dXwRgxSzLgC8eu3IBwXGo/H6VRXMVfMlvtSmuVM sgGqp/mdD/WxPS3jF97c3l+ozk9zb0QzOdb8HKu7wG81WmHQroe3hBzPqN8Mu0Ze 8GeSt7cV7boftm+7La7lPi2STEtIaVwMNM95xhRwrQuECTcpnGBeVJKhwRmYMC0W DWhaQZJVpbuZ4kiSA7CCA6O4FZ28VMJ1GVxIYJNEJ1VZViQZ0pNQoY5TmAqvrFeS s9LEgQf7hmcZVTlFy2HIk8KSkMRtkk4ttTLHm63irv2fa6BivNFeAVsrH6yEwFSc rs+iDmwZrssVUWgKJQgTlaJo8gpchwclSM6TlBpDIsAgk+alqzIgpOExVoQtzEW3 5ERgx1t2OdtAuoOK0wI5z4LnbFhKNbvFsSzI1zzHmXlHEIUNsg+gLS09Yba0h4G/ GhxFcEgOegQPN3objyOw6dnAcoFYoX1rO6SOczkm0Jjk5IYRbDFhw66GUt7/n7L1 I+iSHe3aug/L6djmDOZQNjjpODQM2qgEzYMRTkl6zbBBFhjU4GIn6kEzaPirjaBe A79BtkoP6vToBcljLMQuJERxqGRePl0mE00B+5wsQ5GD1hznupc6OdEwMoKkOvbi 8vgVeoM8Q629tHAc17UjO0AUHHXpsx5ZsuC090RXZrQNYyXpa5DrC/kpbify7vq9 5+bsR2n2RZu/+/aLc5++8M9f9788uTMffAQ/vvHDr+99/GT757nP3pnr9v/4ZuHv 35Y+/+IX/f2fT37n//4H =5vFv -----END PGP SIGNATURE----- --1UWUbFP1cBYEclgG--