Date: Wed, 5 Dec 2007 23:59:32 +0100 From: Gergely CZUCZY <phoemix@harmless.hu> To: Mark Tinguely <tinguely@casselton.net> Cc: freebsd-questions@freebsd.org Subject: Re: more then 2G shm on RELENG_7 Message-ID: <20071205225932.GB15474@harmless.hu> In-Reply-To: <200712051701.lB5H12Ih058055@casselton.net> References: <20071205114619.GA32423@harmless.hu> <200712051701.lB5H12Ih058055@casselton.net>
next in thread | previous in thread | raw e-mail | index | archive | help
--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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20071205225932.GB15474>