Unix Technical Forum

BUG #1549: initdb doesn't work

This is a discussion on BUG #1549: initdb doesn't work within the pgsql Bugs forums, part of the PostgreSQL category; --> The following bug has been logged online: Bug reference: 1549 Logged by: Daniel van Eeden Email address: daniel_e@dds.nl PostgreSQL ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Bugs

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-10-2008, 09:39 AM
Daniel van Eeden
 
Posts: n/a
Default BUG #1549: initdb doesn't work


The following bug has been logged online:

Bug reference: 1549
Logged by: Daniel van Eeden
Email address: daniel_e@dds.nl
PostgreSQL version: 8.0.1
Operating system: Debian GNU/Linux for SPARC (sarge)
Description: initdb doesn't work
Details:

creating template1 database in /opt/postgresql/data/base/1 ... FATAL:
semctl(10977333, 16, SETVAL, 536) failed: Invalid argument
child process exited with exit code 1
initdb: removing data directory "/opt/postgresql/data"

Postgresql is compiled from the official sources in 64-bit mode.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-10-2008, 09:39 AM
Bruce Momjian
 
Posts: n/a
Default Re: BUG #1549: initdb doesn't work

Daniel van Eeden wrote:
>
> The following bug has been logged online:
>
> Bug reference: 1549
> Logged by: Daniel van Eeden
> Email address: daniel_e@dds.nl
> PostgreSQL version: 8.0.1
> Operating system: Debian GNU/Linux for SPARC (sarge)
> Description: initdb doesn't work
> Details:
>
> creating template1 database in /opt/postgresql/data/base/1 ... FATAL:
> semctl(10977333, 16, SETVAL, 536) failed: Invalid argument
> child process exited with exit code 1
> initdb: removing data directory "/opt/postgresql/data"


That is a problem with semaphores in your kernel. Have you modified
your postgresql.conf from the default? If so, you should read the
PostgreSQL documentation on how to modify your kernel for larger
settings.

--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-10-2008, 09:39 AM
Tom Lane
 
Posts: n/a
Default Re: BUG #1549: initdb doesn't work

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Daniel van Eeden wrote:
>> creating template1 database in /opt/postgresql/data/base/1 ... FATAL:
>> semctl(10977333, 16, SETVAL, 536) failed: Invalid argument


> That is a problem with semaphores in your kernel. Have you modified
> your postgresql.conf from the default? If so, you should read the
> PostgreSQL documentation on how to modify your kernel for larger
> settings.


But it's failing at semctl() not semget(). So it seems he hasn't run
out of semaphores. I wonder if SEMVMX is unusually small on his setup
(ie, less than 536). My Linux semctl man page says that that case would
return ERANGE not EINVAL, but ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 03:07 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com