RE: semaphore tuning
Hi Floyd.
Sounds like IDS bug.
Not semahpore issue.
Contact IBM and open case with this assert failt.
Regards.
--
Tsutomu Ogiwara from Tokyo Japan.
ICQ#:168106592
>From: Floyd Wellershaus <fwellers@yahoo.com>
>To: Tsutomu Ogiwara <tsutomu_ogiwara@hotmail.com>, informix-list@iiug.org
>Subject: RE: semaphore tuning
>Date: Thu, 20 Jan 2005 17:33:45 -0800 (PST)
>
>Thanks. The online log and one of the af files is attached
>
>Tsutomu Ogiwara <tsutomu_ogiwara@hotmail.com> wrote: Hi Floyd.
>
>Post your online.log and af file (e.g /tmp/af.1234567).
>
>Regards.
>
>--
>Tsutomu Ogiwara from Tokyo Japan.
>ICQ#:168106592
>
>
>
>
> >From: Floyd Wellershaus
> >To: informix-list@iiug.org
> >Subject: semaphore tuning
> >Date: Thu, 20 Jan 2005 14:58:31 -0800 (PST)
> >
> >We are running Informix9.4-UC4 on Solaris 9.
> >We are getting intermittent semctl: errno = 22 errors that are causing
> >assert failures.
> >
> >Our current kernel settings for semaphores are:
> >set semsys:seminfo_semmap=64
> >set semsys:seminfo_semmni=4096
> >set semsys:seminfo_semmns=4096
> >set semsys:seminfo_semmnu=4096
> >set semsys:seminfo_semume=64
> >set semsys:seminfo_semmsl=500
> >set shmsys:shminfo_shmmax=4294967296
> >set shmsys:shminfo_shmmin=100
> >set shmsys:shminfo_shmmni=500
> >set shmsys:shminfo_shmseg=100
> >
> >Is there any recommendation to determine what to up the semaphore values
>to
> >? Which value is it, is it the semmns value ?
> >
> >Thanks,
> >Floyd
> >
> >
> >
> >========================
> >-<>-
> >Database Administrator
> >Unix Administrator
> >
> >email: fwellers@yahoo.com
> >Work: 703-733-4126
> >Pager: 703-705-9241
> >Email Pager: 7037059241@my2way.com
> >Home: 703-430-0805
> >Cell: 703-477-6045
> >========================
> >
>
>
>
>
>
>
>========================
>-<<Floyd Wellershaus>>-
>Database Administrator
>Unix Administrator
>
>email: fwellers@yahoo.com
>Work: 703-733-4126
>Pager: 703-705-9241
>Email Pager: 7037059241@my2way.com
>Home: 703-430-0805
>Cell: 703-477-6045
>========================
>
>13:39:42
>13:39:42 IBM Informix Dynamic Server Version 9.40.UC4 Software Serial>Number AAA#B000000
>
>13:39:42 Assert Failed: No Exception Handler
>13:39:42 Who: Session(21611, informix@froggerweb2, -1, 3f2fa12c)
> Thread(21889, sqlexec, 3f2d7ab0, 3)
> File: mtex.c Line: 431
>13:39:42 Results: Exception Caught. Type: MT_EX_OS, Context: mem
>13:39:42 Action: Please notify IBM Informix Technical Support.
>13:39:42 Stack for thread: 21889 sqlexec>
> base: 0x41b92000
> len: 69632
> pc: 0x007201c4
> tos: 0x41ba1cc0
>state: running
> vp: 3
>
>0x0071f5a8 (oninit)afhandler(0xb88400, 0x9fd000, 0x3f00a640, 0x1, 0x601,
>0x601)
>0x0071ed9c (oninit)afcrash_interface(0xafb4b4, 0x41ba2450, 0x3f00a640,
>0xafb4cc, 0x1af, 0x0)
>0x0072370c (oninit)mt_ex_throw_sig(0x9fbfd0, 0xaf8644, 0xb859e0, 0xafb488,
>0x403e3ed0, 0x0)
>0x006f01f8 (oninit)afsig_handler(0xa, 0x41ba2a28, 0x41ba2770, 0x0,
>0x41ba273d, 0x0)
>0x00703e54 (oninit)free_pools(0x9fd800, 0xac, 0xb76888, 0xb76888, 0x9fbfa4,
>0xffffe0b8)
>0x00702438 (oninit)destroy_session(0x9fac00, 0xb76400, 0x9fef3c, 0xb767b8,
>0x418950d0, 0x418950d0)
>0x003d8148 (oninit)sq_exit (0xb76400, 0x0, 0x41ba2b58, 0x4, 0x1000,
>0xb76480)
>0x003d38e4 (oninit)sqmain (0x38, 0xb92400, 0x9fac00, 0x1020, 0xb7f97c,
>0x1000)
>0x00741a80 (oninit)listen_verify(0xa2ed10, 0xa, 0x9faef0, 0x0, 0x402cb0d8,
>0xafe6d0)
>0x006fd960 (oninit)startup (0xb885a4, 0x7, 0x0, 0x3f00c8e0, 0x11,
>0x3f00c8a0)
>0x006f63fc (oninit)mt_poll_yield(0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
>0x00000000 (*nosymtab*)0x0
>
>
>13:39:42 See Also: /informix/logs/tmp/af.5969a96e>
>---------------------------------
>Begin System Alarm Program Output
>---------------------------------
>
>Assertion Failure Type: CRASH
>Host Name: vceb0a
>Database Server Name: uolvceb0a
>Time of failure: Wed Jan 19 13:39:43 EST 2005
>AF file: /informix/logs/tmp/af.5969a96e
>Shared memory file: None
>System Blocking: OFF
>
>
>===========------------- - - - - - -
>tail -100 /informix/logs/online.log:
>
>12:57:51 (-1): ERROR: Loading Routine <checkemail> procid=290
>12:59:57 ERROR: C Language Symbol <check> (procid 290) not found in
></informix/ccs/usrfunc/NEWFUNCTIONS/email/check.so>
>12:59:57 (-1): ERROR: Loading Routine <checkemail> procid=290
>13:00:37 Checkpoint Completed: duration was 1 seconds.
>13:00:37 Checkpoint loguniq 150, logpos 0xf24018, timestamp: 118418253
>
>13:00:37 Maximum server connections 60
>13:05:44 Logical Log 150 Complete, timestamp:118471566.
>13:05:44 Process exited with return code 1: /bin/sh /bin/sh -c>/usr/informix/etc/alarmprogram.sh 2 23 "Logical Log 150 Complete,
>timestamp:118471566." "Logical Log 1
>13:05:48 Logical Log 150 - Backup Started
>13:05:49 Logical Log 150 - Backup Completed
>13:10:38 Checkpoint Completed: duration was 1 seconds.
>13:10:38 Checkpoint loguniq 151, logpos 0x4d9018, timestamp: 118525199
>
>13:10:38 Maximum server connections 60
>13:20:39 Checkpoint Completed: duration was 1 seconds.
>13:20:39 Checkpoint loguniq 151, logpos 0xf73018, timestamp: 118630705
>
>13:20:39 Maximum server connections 60
>13:25:03 Logical Log 151 Complete, timestamp:118679164.
>13:25:03 Process exited with return code 1: /bin/sh /bin/sh -c>/usr/informix/etc/alarmprogram.sh 2 23 "Logical Log 151 Complete,
>timestamp:118679164." "Logical Log 1
>13:25:04 Logical Log 151 - Backup Started
>13:25:06 Logical Log 151 - Backup Completed
>13:28:59 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem
>13:28:59 IBM Informix Dynamic Server Version 9.40.UC4
>13:28:59 Who: Session(21601, informix@lms2, 429, 3f2fe41c)
> Thread(21879, sqlexec, 3f2d37a8, 3)
> File: mtex.c Line: 377
>13:28:59 Action: Please notify IBM Informix Technical Support.
>13:28:59 stack trace for pid 11474 written to
>/informix/logs/tmp/af.595fa6eb
>13:28:59 See Also: /informix/logs/tmp/af.595fa6eb
>13:29:03 Exception Caught. Type: MT_EX_OS, Context: mem
>13:29:03 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem
>13:29:03 IBM Informix Dynamic Server Version 9.40.UC4
>13:29:03 Who: Session(21604, informix@hercules, 604, 3f2ff890)
> Thread(21882, sqlexec, 3f2dd000, 1)
> File: mtex.c Line: 377
>13:29:03 Action: Please notify IBM Informix Technical Support.
>13:29:03 stack trace for pid 11472 written to
>/informix/logs/tmp/af.5962a6ef
>13:29:03 See Also: /informix/logs/tmp/af.5962a6ef
>13:29:06 Exception Caught. Type: MT_EX_OS, Context: mem
>13:29:07 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem
>13:29:07 IBM Informix Dynamic Server Version 9.40.UC4
>13:29:07 Who: Session(21607, informix@lms2, 429, 3f2fa89c)
> Thread(21885, sqlexec, 3f2e1f38, 3)
> File: mtex.c Line: 377
>13:29:07 Action: Please notify IBM Info