create_vp: cannot allocate semaphore
Abrar Rashid got 'semget: errno = 28' and 'create_vp: cannot allocate semaphore' after restarting a secondary on IDS 11.50.FC8W3, Solaris SPARC. Art Kagel said OS semaphores must be increased, later naming semsys:seminfo_semmni and semsys:seminfo_semmns tuned with prctl. Doug Lawry noted errno 28 means no space left on device and suggested checking ipcs for stale IPC entries to remove with ipcrm. No confirmation of the fix.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hello, We are getting following error after restarting secondary instance . 01:50:44 IBM Informix Dynamic Server Started. 01:50:44 semget: errno = 28 01:50:44 create_vp: cannot allocate semaphore We are using IDS11.50FC8W3 with solaris spark. Can any one help us to resolve this issue. Thanks.
You have to increase the number of available semaphores in the OS. The Solaris tunable should be semmax IB. Not a system admin, but check the Informix release notes, it should be listed there. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Feb 19, 2014 at 5:22 AM, ABRAR RASHID <mabrar@i2cinc.com> wrote: > Hello, > > We are getting following error after restarting secondary instance . > > 01:50:44 IBM Informix Dynamic Server Started. > 01:50:44 semget: errno = 28 > > 01:50:44 create_vp: cannot allocate semaphore > > We are using IDS11.50FC8W3 with solaris spark. > > Can any one help us to resolve this issue. > > Thanks. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0122797a0b862304f2c08327
thanks art for quick response, i am unable to find this parameter from document , can you guide me for finding this value.
The error number description is:
$ finderr 28-28 No space left on device.
An operating-system error code with the meaning shown was unexpectedly
returned to the database server. Either a database table or an ASCII
output file has probably filled the available disk space. Look for
other operating-system error messages that might give more
information.
You might also want to check for existing shared memory entries,
e.g. from SunOS 5.10 running IDS 11.50.FC9:
$ ipcs # (add "-a" for more detail)T ID KEY MODE OWNER GROUP
Message Queues:
Shared Memory:
m 2 0x52574803 --rw-rw-rw- root informix
m 1 0x52574802 --rw-rw---- root informix
m 0 0x52574801 --rw-rw---- root informix
Semaphores:
s 1 0 --ra-ra-ra- root informix
s 0 0 --ra-ra---- root informix
Any that shouldn't be there can be removed with "ipcrm".
Regards,
Doug Lawry
You are looking to tune semsys:seminfo_semmni and semsys:seminfo_semmns using prctl Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Feb 19, 2014 at 6:27 AM, ABRAR RASHID <mabrar@i2cinc.com> wrote: > thanks art for quick response, > > i am unable to find this parameter from document , can you guide me for > finding this value. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7b3431eac0f51804f2c13758