SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-12-2008, 05:35 AM
| ||||
| ||||
 Failure on tapir / only 10 max connections? Tapir appears to be failing because make check wants more than 10 connections for testing. What I don't understand is why it's being limited to 10. initdb -d doesn't help either... .... selecting default max_connections ... 10 selecting default shared_buffers/max_fsm_pages ... 32MB/204800 creating configuration files ... ok .... AFAIK, my shared memory settings should be high enough to support more than 10 connections... kern.ipc.shmall: 524288 kern.ipc.shmseg: 128 kern.ipc.shmmni: 192 kern.ipc.shmmin: 1 kern.ipc.shmmax: 1073741824 Is 10 just the new default? BTW, does make check log it's initdb output anywhere? It'd be handy if it did... -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match      |
|
04-12-2008, 05:35 AM
| |||
| |||
| Re: Failure on tapir / only 10 max connections? "Jim C. Nasby" <jim@nasby.net> writes: > Tapir appears to be failing because make check wants more than 10 > connections for testing. What I don't understand is why it's being > limited to 10. Your SysV IPC limits are too small --- apparently it's not so much shared memory as semaphores that are the problem. See the FreeBSD-specific notes in http://developer.postgresql.org/pgdo...resources.html regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq |
|
04-12-2008, 05:35 AM
| |||
| |||
| Re: Failure on tapir / only 10 max connections? On Fri, 2006-11-10 at 23:31 -0600, Jim C. Nasby wrote: > BTW, does make check log it's initdb output anywhere? It'd be handy if > it did... They are logged in src/test/regress/log/initdb.log but the make check failure message gives a relative filename, so you have to know what the upper part of the path is to find it. It would be useful to have it say the full path for the failure log, so it could be more easily located. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match |
|
04-12-2008, 05:35 AM
| ||||
| ||||
| Re: Failure on tapir / only 10 max connections? Simon Riggs wrote: > On Fri, 2006-11-10 at 23:31 -0600, Jim C. Nasby wrote: > >> BTW, does make check log it's initdb output anywhere? It'd be handy if >> it did... > > They are logged in src/test/regress/log/initdb.log > but the make check failure message gives a relative filename, so you > have to know what the upper part of the path is to find it. > > It would be useful to have it say the full path for the failure log, so > it could be more easily located. > But for a buildfarm member this is scarcely necessary - the initdb output is included in the make check log. See http://www.pgbuildfarm.org/cgi-bin/s...0500&stg=check and search for 'initdb.log'. We have had a mechanism for limiting parallelism in make check for quite a while, and this too is supported by the buildfarm script - just set MAX_CONNECTIONS in the config. This is pretty much required for Cygwin, but can also be used for any resource starved machine. cheers andrew ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings |
Linear Mode
