Re: operating system limit was reached

It's either the number of shared memory segments per process or the maximum shared memory per process. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, 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 Fri, Feb 4, 2011 at 5:02 AM, Habichtsberg, Reinhard < RHabichtsberg@arz-emmendingen.de> wrote: > Hi all, > > IDS 11.50.FC7W3 > > I found this in the message log (sorry, it’s a bit long): > > 17:36:56 IBM Informix Dynamic Server Started. > > 17:36:56 Requested shared memory segment size rounded from 116736KB to> 131072KB > > 17:36:56 Shared memory segment will use large pages with intimate shared> memory (ISM) if available > > 17:36:56 Segment locked: addr=10a000000, size=134217728> > Sat Dec 4 17:36:56 2010 > > 17:36:56 Event alarms enabled. ALARMPROG = > '/opt/informix/etc/log_full.sh' > > 17:36:56 Booting Language <c> from module <> > > 17:36:56 Loading Module <CNULL> > > 17:36:56 Booting Language <builtin> from module <> > > 17:36:56 Loading Module <BUILTINNULL> > > 17:36:56 SQLTRACE: SQL History Tracing set to 1000 SQL statements. > > 17:37:02 DR: DRAUTO is 0 (Off) > > 17:37:02 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) > > 17:37:02 Fast poll /dev/poll enabled. > > 17:37:02 Requested shared memory segment size rounded from 560KB to 1024KB > > 17:37:02 IBM Informix Dynamic Server Version 11.50.FC7W3 Software Serial> Number AAA#B000000 > > 17:37:02 listener-thread: err = -25572: oserr = 0: errstr = : Network> driver cannot bind a name to the port. > > 17:37:02 sql_listener: ASF_LISTEN failed > > 17:37:02 Attempting to bring listener thread down. > > 17:37:03 Performance Advisory: The physical log size is smaller than the> recommended size for a > > server configured with RTO_SERVER_RESTART. > > 17:37:03 Results: Fast recovery performance might not be optimal. > > 17:37:03 Action: For best fast recovery performance when> RTO_SERVER_RESTART is enabled,> > increase the physical log size to at least 110000 KB. For servers > > configured with a large buffer pool, this might not be necessary. > > 17:37:03 IBM Informix Dynamic Server Initialized -- Shared Memory> Initialized. > > 17:37:03 Started 1 B-tree scanners. > > 17:37:03 B-tree scanner threshold set at 5000. > > 17:37:03 B-tree scanner range scan size set to -1. > > 17:37:03 B-tree scanner ALICE mode set to 6. > > 17:37:03 B-tree scanner index compression level set to med. > > 17:37:03 Physical Recovery Started at Page (1:2760). > > 17:37:03 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored. > > 17:37:03 Logical Recovery Started. > > 17:37:03 10 recovery worker threads will be started. > > 17:37:04 Logical Recovery has reached the transaction cleanup phase. > > 17:37:04 Logical Recovery Complete.> > 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks > > . > > . > > . > > 08:56:16 Dynamically allocated new virtual shared memory segment (size > 4096KB) > > 08:56:16 Dynamically allocated new virtual shared memory segment (size > 4096KB). > > 15:07:31 dynamically allocated 10000 locks > > 15:57:32 Dynamically allocated new virtual shared memory segment (size > 4096KB) > > 15:57:32 Dynamically allocated new virtual shared memory segment (size > 4096KB) > > 15:57:33 Dynamically allocated new virtual shared memory segment (size > 4096KB) > > 11:19:32 dynamically allocated 20000 locks > > 11:19:48 Dynamically allocated new virtual shared memory segment (size > 5120KB) > > 11:19:48 dynamically allocated 40000 locks > > 11:20:12 Dynamically allocated new virtual shared memory segment (size > 10240KB) > > 11:20:12 dynamically allocated 80000 locks > > 13:06:28 Dynamically allocated new virtual shared memory segment (size > 20480KB) > > 13:06:28 dynamically allocated 160000 locks > > 13:06:40 Dynamically allocated new virtual shared memory segment (size > 40960KB) > > 13:06:40 dynamically allocated 320000 locks > > 07:39:36 Dynamically allocated new virtual shared memory segment (size > 4096KB) > > 07:39:37 Dynamically allocated new virtual shared memory segment (size > 4096KB) > > 07:39:37 Dynamically allocated new virtual shared memory segment (size > 4096KB) > > 07:39:37 Dynamically allocated new virtual shared memory segment (size > 4096KB) > > 07:39:38 Dynamically allocated new virtual shared memory segment (size > 4096KB) > > 08:46:26 Dynamically allocated new virtual shared memory segment (size > 81920KB) > > 08:46:26 dynamically allocated 640000 locks > > 07:41:12 Dynamically allocated new virtual shared memory segment (size > 4096KB) > > 14:16:19 Dynamically allocated new virtual shared memory segment (size > 126976KB) > > 14:16:19 Memory sizes:resident:131072 KB, virtual:382976 KB,> SHMTOTAL:2000000 KB > > 14:16:20 dynamically allocated 1000000 locks> > . > > . > > Thu Jan 13 > > shmget: [ENOSPC][28]: key 52574815: The server could not allocate shared > memory because an operating system limit was reached > > 08:00:58 out of virtual shared memory > > 08:00:58 shmget: [ENOSPC][28]: key 52574815: The server could not allocate> shared memory because an operating system limit was reached > > 08:00:58 shmget: [ENOSPC][28]: key 52574815: The server could not allocate> shared memory because an operating system limit was reached > > 08:00:58 shmget: [ENOSPC][28]: key 52574815: The server could not allocate> shared memory because an operating system limit was reached > > 08:00:58 shmget: [ENOSPC][28]: key 52574815: The server could not allocate> shared memory because an operating system limit was reached > > 08:00:58 shmget: [ENOSPC][28]: key 52574815: The server could not allocate> shared memory because an operating system limit was reached > > 08:00:58 rsread_init: buffer error> > . > > . > > . > > Mon Jan 17 > > 10:49:16 Requested shared memory segment size rounded from 126500KB to> 126976KB > > 10:49:16 shmget: [ENOSPC][28]: key 52574815: The server could not allocate> shared memory because an operating system limit was reached > > 10:49:16 The out of shared memory error has been encountered 5 times since> it was last printed to the log. > > 10:49:16 out of virtual shared memory > > 10:49:16 Assert Warning: Lock table overflow - user id 22223, session id> 272389 > > Today Fri Feb 04 I had

On 04/02/2011 10:47, Art Kagel wrote: > It's either the number of shared memory segments per process or the > maximum shared memory per process. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com > <http://www.advancedatatools.com>) > IIUG Board of Directors (art@iiug.org <mailto:art@iiug.org>) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, 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 Fri, Feb 4, 2011 at 5:02 AM, Habichtsberg, Reinhard > <RHabichtsberg@arz-emmendingen.de > <mailto:RHabichtsberg@arz-emmendingen.de>> wrote: > > Hi all, > > IDS 11.50.FC7W3 > > I found this in the message log(sorry, it's a bit long): > > 17:36:56 IBM Informix Dynamic Server Started. > > 17:36:56 Requested shared memory segment size rounded from 116736KB > to 131072KB > > 17:36:56 Shared memory segment will use large pages with intimate > shared memory (ISM) if available > > 17:36:56 Segment locked: addr=10a000000, size=134217728 > > Sat Dec 4 17:36:56 2010 > > 17:36:56 Event alarms enabled. ALARMPROG = > '/opt/informix/etc/log_full.sh' > > 17:36:56 Booting Language <c> from module <> > > 17:36:56 Loading Module <CNULL> > > 17:36:56 Booting Language <builtin> from module <> > > 17:36:56 Loading Module <BUILTINNULL> > > 17:36:56 SQLTRACE: SQL History Tracing set to 1000 SQL statements. > > 17:37:02 DR: DRAUTO is 0 (Off) > > 17:37:02 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) > > 17:37:02 Fast poll /dev/poll enabled. > > 17:37:02 Requested shared memory segment size rounded from 560KB to > 1024KB > > 17:37:02 IBM Informix Dynamic Server Version 11.50.FC7W3 Software > Serial Number AAA#B000000 > > 17:37:02 listener-thread: err = -25572: oserr = 0: errstr = : > Network driver cannot bind a name to the port. > > 17:37:02 sql_listener: ASF_LISTEN failed > > 17:37:02 Attempting to bring listener thread down. > > 17:37:03 Performance Advisory: The physical log size is smaller > than the recommended size for a > > server configured with RTO_SERVER_RESTART. > > 17:37:03 Results: Fast recovery performance might not be optimal. > > 17:37:03 Action: For best fast recovery performance when > RTO_SERVER_RESTART is enabled,> > increase the physical log size to at least 110000 KB. For servers > > configured with a large buffer pool, this might not be necessary. > > 17:37:03 IBM Informix Dynamic Server Initialized -- Shared Memory > Initialized. > > 17:37:03 Started 1 B-tree scanners. > > 17:37:03 B-tree scanner threshold set at 5000. > > 17:37:03 B-tree scanner range scan size set to -1. > > 17:37:03 B-tree scanner ALICE mode set to 6. > > 17:37:03 B-tree scanner index compression level set to med. > > 17:37:03 Physical Recovery Started at Page (1:2760). > > 17:37:03 Physical Recovery Complete: 0 Pages Examined, 0 Pages > Restored. > > 17:37:03 Logical Recovery Started. > > 17:37:03 10 recovery worker threads will be started. > > 17:37:04 Logical Recovery has reached the transaction cleanup phase. > > 17:37:04 Logical Recovery Complete. > > 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks > > . > > . > > . > > 08:56:16 Dynamically allocated new virtual shared memory segment > (size 4096KB) > > 08:56:16 Dynamically allocated new virtual shared memory segment > (size 4096KB). > > 15:07:31 dynamically allocated 10000 locks > > 15:57:32 Dynamically allocated new virtual shared memory segment > (size 4096KB) > > 15:57:32 Dynamically allocated new virtual shared memory segment > (size 4096KB) > > 15:57:33 Dynamically allocated new virtual shared memory segment > (size 4096KB) > > 11:19:32 dynamically allocated 20000 locks > > 11:19:48 Dynamically allocated new virtual shared memory segment > (size 5120KB) > > 11:19:48 dynamically allocated 40000 locks > > 11:20:12 Dynamically allocated new virtual shared memory segment > (size 10240KB) > > 11:20:12 dynamically allocated 80000 locks > > 13:06:28 Dynamically allocated new virtual shared memory segment > (size 20480KB) > > 13:06:28 dynamically allocated 160000 locks > > 13:06:40 Dynamically allocated new virtual shared memory segment > (size 40960KB) > > 13:06:40 dynamically allocated 320000 locks > > 07:39:36 Dynamically allocated new virtual shared memory segment > (size 4096KB) > > 07:39:37 Dynamically allocated new virtual shared memory segment > (size 4096KB) > > 07:39:37 Dynamically allocated new virtual shared memory segment > (size 4096KB) > > 07:39:37 Dynamically allocated new virtual shared memory segment > (size 4096KB) > > 07:39:38 Dynamically allocated new virtual shared memory segment > (size 4096KB) > > 08:46:26 Dynamically allocated new virtual shared memory segment > (size 81920KB) > > 08:46:26 dynamically allocated 640000 locks > > 07:41:12 Dynamically allocated new virtual shared memory segment > (size 4096KB) > > 14:16:19 Dynamically allocated new virtual shared memory segment > (size 126976KB) > > 14:16:19 Memory sizes:resident:131072 KB, virtual:382976 KB, > SHMTOTAL:2000000 KB > > 14:16:20 dynamically allocated 1000000 locks > > . > > . > > Thu Jan 13 > > shmget: [ENOSPC][28]: key 52574815: The server could not allocate > shared memory because an operating system limit was reached > > 08:00:58 out of virtual shared memory > > 08:00:58 shmget: [ENOSPC][28]: key 52574815: The server could not > allocate shared memory because an operating system limit was reached > > 08:00:58 shmget: [ENOSPC][28]: key 52574815: The server could not > allocate shared memory because an operating system limit was reached > > 08:00:58 shmget: [ENOSPC][28]: key 52574815: The server could not > allocate shared memory because an operating system limit was reached > > 08:00:58 shmget: [ENOSPC][28]: key 52574815: The server could not > allocate shared memory because an operating system limit was reached > > 08:00:58 shmget: [ENOSPC][28]: key 52574815: The server could not > allocate shared memory because an operating system limit was reached > > 08:00:58 r