create_tcb: cannot allocate memory
User encountered "create_tcb: cannot allocate memory" error in Informix 11.70.FC8W1, blocking the server in CKPT REQ state and preventing connections. NETTYPE ipcshm was set to 4,100,CPU (too low). A suggestion was made to increase it to 4,150,CPU to match tlitcp settings, but user ultimately resolved it by rebooting the server.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Greetings
I have the next error in my log. The server stays in a CKPT REQ, and I can´t
connect to the database.
¿ Can I shutdown the server in a CKPT REQ ?
¿ Is there an other possibility to solve tho¿is ?
Thanks
/informix/ids1150 [casiopea2] (informix): onstat -m
IBM Informix Dynamic Server Version 11.70.FC8W1 -- On-Line (CKPT REQ) -- Up 2
days 07:49:34 -- 19000320 KbytesBlocked:CKPT
Message Log File: /informix/tmp/online.log
11:54:07 Requested shared memory segment size rounded from 250000KB to 250880KB
11:54:07 create_tcb: cannot allocate memory
11:54:07 (544745) connection rejected - too many users, o
Sounds like you are using SHM connections, what are your NETTYPE settings
Cheers
Paul
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of HUGO
PADILLA
Sent: Tuesday, February 07, 2017 12:06 PM
To: ids@iiug.org
Subject: create_tcb: cannot allocate memory [38592]
Greetings
I have the next error in my log. The server stays in a CKPT REQ, and I can´t
connect to the database.
¿ Can I shutdown the server in a CKPT REQ ?
¿ Is there an other possibility to solve tho¿is ?
Thanks
/informix/ids1150 [casiopea2] (informix): onstat -m
IBM Informix Dynamic Server Version 11.70.FC8W1 -- On-Line (CKPT REQ) -- Up2
days 07:49:34 -- 19000320 Kbytes
Blocked:CKPT
Message Log File: /informix/tmp/online.log
11:54:07 Requested shared memory segment size rounded from 250000KB to
250880KB
11:54:07 create_tcb: cannot allocate memory
11:54:07 (544745) connection rejected - too many users, o
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
> On 7 Feb 2017, at 18:21, HUGO PADILLA <hugo_padilla@terra.com.mx> wrote:
>
> The settings are:
>
> NETTYPE ipcshm,4,100,CPU
> NETTYPE tlitcp,8,150,NET>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Change NETTYPE ipcshm,4,100,CPU to NETTYPE ipcshm,4,150,CPU
The decision was finally reboot the server, and fortunately runs OK Thanks a lot fiends
The thread control block (TCB) is in virtual memory. What is the output of
onstat -g seg??? Also what are the settings for
SHMVIRTSIZE, SHMADD, EXTSHMADD and SHMTOTAL
Madison Pruet
Retired and Loving it
On Tuesday, February 7, 2017 12:06 PM, HUGO PADILLA
<hugo_padilla@terra.com.mx> wrote:
Greetings
I have the next error in my log. The server stays in a CKPT REQ, and I can´t
connect to the database.
¿ Can I shutdown the server in a CKPT REQ ?
¿ Is there an other possibility to solve tho¿is ?
Thanks
/informix/ids1150 [casiopea2] (informix): onstat -m
IBM Informix Dynamic Server Version 11.70.FC8W1 -- On-Line (CKPT REQ) -- Up 2
days 07:49:34 -- 19000320 KbytesBlocked:CKPT
Message Log File: /informix/tmp/online.log
11:54:07 Requested shared memory segment size rounded from 250000KB to
250880KB
11:54:07 create_tcb: cannot allocate memory
11:54:07 (544745) connection rejected - too many users, o
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.