create_vp: cannot allocate semaphore

Posted in 2014

ABRAR RASHID — Wed, 19 Feb 2014 10:22:36 — source: IIUG Forums & Mailing Lists

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.

↪ replying to ABRAR RASHID

Art Kagel — Wed, 19 Feb 2014 11:16:00 — source: IIUG Forums & Mailing Lists

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

↪ replying to Art Kagel

ABRAR RASHID — Wed, 19 Feb 2014 11:27:36 — source: IIUG Forums & Mailing Lists

thanks art for quick response, i am unable to find this parameter from document , can you guide me for finding this value.

↪ replying to ABRAR RASHID

DOUG LAWRY — Wed, 19 Feb 2014 11:28:10 — source: IIUG Forums & Mailing Lists

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

↪ replying to ABRAR RASHID

Art Kagel — Wed, 19 Feb 2014 12:06:29 — source: IIUG Forums & Mailing Lists

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