Informix 10 crash
Posted in 2007
Topics: Platform-Specific Issues
Hi all,
we have an instance (IDS10FC6, Solaris 9 SPARC) which crashes every now and
then (after some days).
The af File shows different operations which were executed last, but always a
call at the end to
some thread/semaphore functions (sema_post und setitimer).
Could this be a semaphore related problem, or did we touch a Solaris bug ?
Semaphore parameters are like this:
set semsys:seminfo_semmns=4096
set semsys:seminfo_semmni=4096
set semsys:seminfo_semmsl=500
set semsys:seminfo_semmnu=4096
set semsys:seminfo_semmap=64
set semsys:seminfo_semopm=10
set semsys:seminfo_semume=64
set semsys:seminfo_semusz=96
set semsys:seminfo_semvmx=32767
set semsys:seminfo_semaem=16384
Any idea on this ?
Thanks, Marcus
Examples:
0x1009caa34 oninit :: afstack + 0x34 sp=0x1558de4f0(0x15528d028, 0x151cb6028,
0x
100000b, 0x0, 0x0, 0x0)
0x1009cf5e4 oninit :: mt_ex_throw_sig + 0x320 sp=0x1558de7c0
delta_sp=720(0x100f
2c4f8, 0x101109ea0, 0x0, 0x1011d3ab0, 0x10110da90, 0x15528d028)
0x10098b8c8 oninit :: afsig_handler + 0x158 sp=0x1558de980
delta_sp=448(0x1011cd
030, 0x41b0, 0x101109e60, 0x101109ea0, 0x4000, 0x0)
0xffffffff7f218530 /usr/lib/sparcv9/libthread.so.1 :: _setitimer + 0xb4
sp=0x155
8dea40 delta_sp=192(0xb, 0x1558df070, 0x1558ded90, 0x10098b770, 0x0, 0x0)
0xffffffff7f212074 /usr/lib/sparcv9/libthread.so.1 :: _sema_post + 0x530
sp=0x15
58deaf0 delta_sp=176(0xffffffff7d000000, 0x1558df070, 0x1558ded90, 0x0, 0x0,
0x0
)
0xffffffff7f212238 /usr/lib/sparcv9/libthread.so.1 :: _sema_post + 0x6f4
sp=0x15
58dec20 delta_sp=304(0xb, 0x1558df070, 0x1558ded90, 0x1558df940, 0x102f53, 0x0)
0x10087aa5c oninit :: log_put + 0xed4 sp=0x1558decd0 delta_sp=176(0x1011b318c,
0
x1011de714, 0x1011de048, 0x8112, 0x16c, 0x10a072800)
0x100873b90 oninit :: logm_write + 0x534 sp=0x1558df780
delta_sp=2736(0x1011de04
8, 0x8102, 0x1504c71e4, 0x2a, 0x102f53, 0x1558df920)
0x1006ea96c oninit :: logvimage_new + 0x2a0 sp=0x1558df840 delta_sp=192(0x109,
0
x1b905, 0x1011cc590, 0x1558dfb90, 0x1558dfb88, 0x0)
0x1006eae48 oninit :: logdimage + 0x4c8 sp=0x1558df950 delta_sp=272(0x8002,
0x10
9, 0x0, 0x6, 0x109, 0x12fb3e42e)
0x100616114 oninit :: rew_home + 0x5a4 sp=0x1558dfa70 delta_sp=288(0x1b905,
0x10
11de048, 0x1011ccec0, 0x1558dfb88, 0x12fb3e42e, 0x0)
0x1006155e8 oninit :: rewrecord + 0x578 sp=0x1558dfba0 delta_sp=304(0x1600,
0x10
11de500, 0x1011de714, 0x1000, 0x1011ccec0, 0x1011de048)
0x100613e54 oninit :: rsrewrec + 0x184 sp=0x1558dfc60 delta_sp=192(0x1011de048,
0x1b905, 0x151ab5878, 0x15176259c, 0x151762598, 0x151ab5878)
0x100a9e110 oninit :: fmrewrec + 0x3c4 sp=0x1558dfd30 delta_sp=208(0x4,
0x151a58
ab8, 0x151762598, 0x151ab5878, 0x102f53, 0x0)
0x1001fe1b4 oninit :: aud_sqisrewrec + 0x50 sp=0x1558dfe60 delta_sp=304(0x4,
0x8
4, 0x1011e7318, 0x1b905, 0x151e0a038, 0x151ab5878)
0x100343f70 oninit :: doupdate + 0x64c sp=0x1558dff30 delta_sp=208(0x1561535f8,
------------------------------------------------------
0x1009caa34 oninit :: afstack + 0x34 sp=0x15dd081b0(0x1569d5028, 0x15150bea0,
0x
1000021, 0x0, 0x0, 0x0)
0x1009cf5e4 oninit :: mt_ex_throw_sig + 0x320 sp=0x15dd08480
delta_sp=720(0x100f
2c4f8, 0x101109ea0, 0x0, 0x1011d3ab0, 0x10110da90, 0x1569d5028)
0x10098b8c8 oninit :: afsig_handler + 0x158 sp=0x15dd08640
delta_sp=448(0x1011cd
030, 0x41b0, 0x101109e60, 0x101109ea0, 0x4000, 0x0)
0xffffffff7f218530 /usr/lib/sparcv9/libthread.so.1 :: _setitimer + 0xb4
sp=0x15d
d08700 delta_sp=192(0xb, 0x15dd08d30, 0x15dd08a50, 0x10098b770, 0x0, 0x0)
0xffffffff7f212074 /usr/lib/sparcv9/libthread.so.1 :: _sema_post + 0x530
sp=0x15
dd087b0 delta_sp=176(0xffffffff7d000000, 0x15dd08d30, 0x15dd08a50, 0x0, 0x0,
0x0
)
0xffffffff7f212238 /usr/lib/sparcv9/libthread.so.1 :: _sema_post + 0x6f4
sp=0x15
dd088e0 delta_sp=304(0xb, 0x15dd08d30, 0x15dd08a50, 0xfffffffffffffffe, 0x4,
0x0
)
0x100770160 oninit :: isxattach + 0x158 sp=0x15dd08990
delta_sp=176(0x155050fd0,
0x1, 0x156a4b984, 0x1011de048, 0x0, 0x1011de500)
0x10076e520 oninit :: xa_end + 0x320 sp=0x15dd08f00 delta_sp=1392(0x1011de048,
0
x155050fa8, 0x2000000, 0x153566598, 0x2000000, 0x1)
0x10046e614 oninit :: xendsub + 0x150 sp=0x15dd08fd0 delta_sp=208(0x155050fd0,
0
x1, 0x2000000, 0x1, 0x155050fd0, 0x0)
0x10047185c oninit :: ifx_common_xcommit + 0xf4 sp=0x15dd09080
delta_sp=176(0x15
5050fd0, 0x1, 0x40000000, 0x1011e7240, 0x40000000, 0x1)
0x10046e45c oninit :: sq_xcommit + 0x40 sp=0x15dd09130
delta_sp=176(0x1011e7318,
0x1011d9dd0, 0x0, 0x30, 0x1011e7240, 0x106c)
Looks like a bug in the Solaris libthread _setitimer or _sema_post function.
Art S. Kagel
----- Original Message -----
From: Marcus Haarmann <ids@iiug.org>
At: 6/30 4:15:39
Hi all,
we have an instance (IDS10FC6, Solaris 9 SPARC) which crashes every now and
then (after some days).
The af File shows different operations which were executed last, but always a
call at the end to
some thread/semaphore functions (sema_post und setitimer).
Could this be a semaphore related problem, or did we touch a Solaris bug ?
Semaphore parameters are like this:
set semsys:seminfo_semmns=4096
set semsys:seminfo_semmni=4096
set semsys:seminfo_semmsl=500
set semsys:seminfo_semmnu=4096
set semsys:seminfo_semmap=64
set semsys:seminfo_semopm=10
set semsys:seminfo_semume=64
set semsys:seminfo_semusz=96
set semsys:seminfo_semvmx=32767
set semsys:seminfo_semaem=16384
Any idea on this ?
Thanks, Marcus
Examples:
0x1009caa34 oninit :: afstack + 0x34 sp=0x1558de4f0(0x15528d028, 0x151cb6028,
0x
100000b, 0x0, 0x0, 0x0)
0x1009cf5e4 oninit :: mt_ex_throw_sig + 0x320 sp=0x1558de7c0
delta_sp=720(0x100f
2c4f8, 0x101109ea0, 0x0, 0x1011d3ab0, 0x10110da90, 0x15528d028)
0x10098b8c8 oninit :: afsig_handler + 0x158 sp=0x1558de980
delta_sp=448(0x1011cd
030, 0x41b0, 0x101109e60, 0x101109ea0, 0x4000, 0x0)
0xffffffff7f218530 /usr/lib/sparcv9/libthread.so.1 :: _setitimer + 0xb4
sp=0x155
8dea40 delta_sp=192(0xb, 0x1558df070, 0x1558ded90, 0x10098b770, 0x0, 0x0)
0xffffffff7f212074 /usr/lib/sparcv9/libthread.so.1 :: _sema_post + 0x530
sp=0x15
58deaf0 delta_sp=176(0xffffffff7d000000, 0x1558df070, 0x1558ded90, 0x0, 0x0,
0x0
)
0xffffffff7f212238 /usr/lib/sparcv9/libthread.so.1 :: _sema_post + 0x6f4
sp=0x15
58dec20 delta_sp=304(0xb, 0x1558df070, 0x1558ded90, 0x1558df940, 0x102f53,
0x0)
0x10087aa5c oninit :: log_put + 0xed4 sp=0x1558decd0 delta_sp=176(0x1011b318c,
0
x1011de714, 0x1011de048, 0x8112, 0x16c, 0x10a072800)
0x100873b90 oninit :: logm_write + 0x534 sp=0x1558df780
delta_sp=2736(0x1011de04
8, 0x8102, 0x1504c71e4, 0x2a, 0x102f53, 0x1558df920)
0x1006ea96c oninit :: logvimage_new + 0x2a0 sp=0x1558df840 delta_sp=192(0x109,
0
x1b905, 0x1011cc590, 0x1558dfb90, 0x1558dfb88, 0x0)
0x1006eae48 oninit :: logdimage + 0x4c8 sp=0x1558df950 delta_sp=272(0x8002,
0x10
9, 0x0, 0x6, 0x109, 0x12fb3e42e)
0x100616114 oninit :: rew_home + 0x5a4 sp=0x1558dfa70 delta_sp=288(0x1b905,
0x10
11de048, 0x1011ccec0, 0x1558dfb88, 0x12fb3e42e, 0x0)
0x1006155e8 oninit :: rewrecord + 0x578 sp=0x1558dfba0 delta_sp=304(0x1600,
0x10
11de500, 0x1011de714, 0x1000, 0x1011ccec0, 0x1011de048)
0x100613e54 oninit :: rsrewrec + 0x184 sp=0x1558dfc60
delta_sp=192(0x1011de048,
0x1b905, 0x151ab5878, 0x15176259c, 0x151762598, 0x151ab5878)
0x100a9e110 oninit :: fmrewrec + 0x3c4 sp=0x1558dfd30 delta_sp=208(0x4,
0x151a58
ab8, 0x151762598, 0x151ab5878, 0x102f53, 0x0)
0x1001fe1b4 oninit :: aud_sqisrewrec + 0x50 sp=0x1558dfe60 delta_sp=304(0x4,
0x8
4, 0x1011e7318, 0x1b905, 0x151e0a038, 0x151ab5878)
0x100343f70 oninit :: doupdate + 0x64c sp=0x1558dff30
delta_sp=208(0x1561535f8,
------------------------------------------------------
0x1009caa34 oninit :: afstack + 0x34 sp=0x15dd081b0(0x1569d5028, 0x15150bea0,
0x
1000021, 0x0, 0x0, 0x0)
0x1009cf5e4 oninit :: mt_ex_throw_sig + 0x320 sp=0x15dd08480
delta_sp=720(0x100f
2c4f8, 0x101109ea0, 0x0, 0x1011d3ab0, 0x10110da90, 0x1569d5028)
0x10098b8c8 oninit :: afsig_handler + 0x158 sp=0x15dd08640
delta_sp=448(0x1011cd
030, 0x41b0, 0x101109e60, 0x101109ea0, 0x4000, 0x0)
0xffffffff7f218530 /usr/lib/sparcv9/libthread.so.1 :: _setitimer + 0xb4
sp=0x15d
d08700 delta_sp=192(0xb, 0x15dd08d30, 0x15dd08a50, 0x10098b770, 0x0, 0x0)
0xffffffff7f212074 /usr/lib/sparcv9/libthread.so.1 :: _sema_post + 0x530
sp=0x15
dd087b0 delta_sp=176(0xffffffff7d000000, 0x15dd08d30, 0x15dd08a50, 0x0, 0x0,
0x0
)
0xffffffff7f212238 /usr/lib/sparcv9/libthread.so.1 :: _sema_post + 0x6f4
sp=0x15
dd088e0 delta_sp=304(0xb, 0x15dd08d30, 0x15dd08a50, 0xfffffffffffffffe, 0x4,
0x0
)
0x100770160 oninit :: isxattach + 0x158 sp=0x15dd08990
delta_sp=176(0x155050fd0,
0x1, 0x156a4b984, 0x1011de048, 0x0, 0x1011de500)
0x10076e520 oninit :: xa_end + 0x320 sp=0x15dd08f00 delta_sp=1392(0x1011de048,
0
x155050fa8, 0x2000000, 0x153566598, 0x2000000, 0x1)
0x10046e614 oninit :: xendsub + 0x150 sp=0x15dd08fd0 delta_sp=208(0x155050fd0,
0
x1, 0x2000000, 0x1, 0x155050fd0, 0x0)
0x10047185c oninit :: ifx_common_xcommit + 0xf4 sp=0x15dd09080
delta_sp=176(0x15
5050fd0, 0x1, 0x40000000, 0x1011e7240, 0x40000000, 0x1)
0x10046e45c oninit :: sq_xcommit + 0x40 sp=0x15dd09130
delta_sp=176(0x1011e7318,
0x1011d9dd0, 0x0, 0x30, 0x1011e7240, 0x106c)
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
If you are running fully patched Solaris then you should be fine (subject to
a bug unique to hardware combinations) We have a number of customers on FC6
and Solaris 9
Cheers
Paul
Paul Watson
Tel: +44 1414161772 +1 913-400-2620
Mob: +44 7818003457 +1 913-387-7529
Web: www.oninit.com
Failure is not as frightening as regret.
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> Behalf Of ART KAGEL, BLOOMBERG/ 731 LEXIN
> Sent: 02 July 2007 08:20
> To: ids@iiug.org
> Subject: Re: Informix 10 crash [9484]
>
> Looks like a bug in the Solaris libthread _setitimer or
> _sema_post function.
>
> Art S. Kagel
> ----- Original Message -----
> From: Marcus Haarmann <ids@iiug.org>
> At: 6/30 4:15:39
>
> Hi all,
>
> we have an instance (IDS10FC6, Solaris 9 SPARC) which crashes
> every now and then (after some days).
> The af File shows different operations which were executed
> last, but always a call at the end to some thread/semaphore
> functions (sema_post und setitimer).
> Could this be a semaphore related problem, or did we touch a
> Solaris bug ?
> Semaphore parameters are like this:
> set semsys:seminfo_semmns=4096
> set semsys:seminfo_semmni=4096
> set semsys:seminfo_semmsl=500
> set semsys:seminfo_semmnu=4096
> set semsys:seminfo_semmap=64
> set semsys:seminfo_semopm=10
> set semsys:seminfo_semume=64
> set semsys:seminfo_semusz=96
> set semsys:seminfo_semvmx=32767
> set semsys:seminfo_semaem=16384
>
> Any idea on this ?
>
> Thanks, Marcus
> Examples:
> 0x1009caa34 oninit :: afstack + 0x34
> sp=0x1558de4f0(0x15528d028, 0x151cb6028, 0x 100000b, 0x0, 0x0, 0x0)
> 0x1009cf5e4 oninit :: mt_ex_throw_sig + 0x320 sp=0x1558de7c0
> delta_sp=720(0x100f 2c4f8, 0x101109ea0, 0x0, 0x1011d3ab0,
> 0x10110da90, 0x15528d028)
> 0x10098b8c8 oninit :: afsig_handler + 0x158 sp=0x1558de980
> delta_sp=448(0x1011cd 030, 0x41b0, 0x101109e60, 0x101109ea0,
> 0x4000, 0x0) 0xffffffff7f218530
> /usr/lib/sparcv9/libthread.so.1 :: _setitimer + 0xb4
> sp=0x155
> 8dea40 delta_sp=192(0xb, 0x1558df070, 0x1558ded90,
> 0x10098b770, 0x0, 0x0)
> 0xffffffff7f212074 /usr/lib/sparcv9/libthread.so.1 ::
> _sema_post + 0x530
> sp=0x15
> 58deaf0 delta_sp=176(0xffffffff7d000000, 0x1558df070,
> 0x1558ded90, 0x0, 0x0, 0x0
> )
> 0xffffffff7f212238 /usr/lib/sparcv9/libthread.so.1 ::
> _sema_post + 0x6f4
> sp=0x15
> 58dec20 delta_sp=304(0xb, 0x1558df070, 0x1558ded90,
> 0x1558df940, 0x102f53,
> 0x0)
> 0x10087aa5c oninit :: log_put + 0xed4 sp=0x1558decd0
> delta_sp=176(0x1011b318c, 0 x1011de714, 0x1011de048, 0x8112,
> 0x16c, 0x10a072800) 0x100873b90 oninit :: logm_write + 0x534
> sp=0x1558df780
> delta_sp=2736(0x1011de04
> 8, 0x8102, 0x1504c71e4, 0x2a, 0x102f53, 0x1558df920)
> 0x1006ea96c oninit :: logvimage_new + 0x2a0 sp=0x1558df840
> delta_sp=192(0x109, 0 x1b905, 0x1011cc590, 0x1558dfb90,
> 0x1558dfb88, 0x0)
> 0x1006eae48 oninit :: logdimage + 0x4c8 sp=0x1558df950
> delta_sp=272(0x8002, 0x10 9, 0x0, 0x6, 0x109, 0x12fb3e42e)
> 0x100616114 oninit :: rew_home + 0x5a4 sp=0x1558dfa70
> delta_sp=288(0x1b905, 0x10 11de048, 0x1011ccec0, 0x1558dfb88,
> 0x12fb3e42e, 0x0)
> 0x1006155e8 oninit :: rewrecord + 0x578 sp=0x1558dfba0
> delta_sp=304(0x1600, 0x10 11de500, 0x1011de714, 0x1000,
> 0x1011ccec0, 0x1011de048)
> 0x100613e54 oninit :: rsrewrec + 0x184 sp=0x1558dfc60
> delta_sp=192(0x1011de048, 0x1b905, 0x151ab5878, 0x15176259c,
> 0x151762598, 0x151ab5878) 0x100a9e110 oninit :: fmrewrec +
> 0x3c4 sp=0x1558dfd30 delta_sp=208(0x4,
> 0x151a58
> ab8, 0x151762598, 0x151ab5878, 0x102f53, 0x0)
> 0x1001fe1b4 oninit :: aud_sqisrewrec + 0x50 sp=0x1558dfe60
> delta_sp=304(0x4,
> 0x8
> 4, 0x1011e7318, 0x1b905, 0x151e0a038, 0x151ab5878)
> 0x100343f70 oninit :: doupdate + 0x64c sp=0x1558dff30
> delta_sp=208(0x1561535f8,
>
> ------------------------------------------------------
>
> 0x1009caa34 oninit :: afstack + 0x34
> sp=0x15dd081b0(0x1569d5028, 0x15150bea0, 0x 1000021, 0x0, 0x0, 0x0)
> 0x1009cf5e4 oninit :: mt_ex_throw_sig + 0x320 sp=0x15dd08480
> delta_sp=720(0x100f 2c4f8, 0x101109ea0, 0x0, 0x1011d3ab0,
> 0x10110da90, 0x1569d5028)
> 0x10098b8c8 oninit :: afsig_handler + 0x158 sp=0x15dd08640
> delta_sp=448(0x1011cd 030, 0x41b0, 0x101109e60, 0x101109ea0,
> 0x4000, 0x0) 0xffffffff7f218530
> /usr/lib/sparcv9/libthread.so.1 :: _setitimer + 0xb4 sp=0x15d
> d08700 delta_sp=192(0xb, 0x15dd08d30, 0x15dd08a50,
> 0x10098b770, 0x0, 0x0)
> 0xffffffff7f212074 /usr/lib/sparcv9/libthread.so.1 ::
> _sema_post + 0x530
> sp=0x15
> dd087b0 delta_sp=176(0xffffffff7d000000, 0x15dd08d30,
> 0x15dd08a50, 0x0, 0x0, 0x0
> )
> 0xffffffff7f212238 /usr/lib/sparcv9/libthread.so.1 ::
> _sema_post + 0x6f4
> sp=0x15
> dd088e0 delta_sp=304(0xb, 0x15dd08d30, 0x15dd08a50,
> 0xfffffffffffffffe, 0x4, 0x0
> )
> 0x100770160 oninit :: isxattach + 0x158 sp=0x15dd08990
> delta_sp=176(0x155050fd0, 0x1, 0x156a4b984, 0x1011de048, 0x0,
> 0x1011de500) 0x10076e520 oninit :: xa_end + 0x320
> sp=0x15dd08f00 delta_sp=1392(0x1011de048, 0 x155050fa8,
> 0x2000000, 0x153566598, 0x2000000, 0x1)
> 0x10046e614 oninit :: xendsub + 0x150 sp=0x15dd08fd0
> delta_sp=208(0x155050fd0, 0 x1, 0x2000000, 0x1, 0x155050fd0,
> 0x0) 0x10047185c oninit :: ifx_common_xcommit + 0xf4 sp=0x15dd09080
> delta_sp=176(0x15
> 5050fd0, 0x1, 0x40000000, 0x1011e7240, 0x40000000, 0x1)
> 0x10046e45c oninit :: sq_xcommit + 0x40 sp=0x15dd09130
> delta_sp=176(0x1011e7318, 0x1011d9dd0, 0x0, 0x30,
> 0x1011e7240, 0x106c)
>
>
> **************************************************************
> *****************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> **************************************************************
> *****************
> Forum Note: Use "Reply" to post a response in the
> discussion forum.
Hi all,
First thank you for your hints on our problem.
For anybody who is interested in why our database crashed, I want to
give a short summary of what really happened (as far as we know by now).
First of all, it was not a real Informix problem but a Client setup
problem.
The point was that we run two instances of our application server on the
same machine, accessing the same Database instance.
Our application server is Jboss and DB Access is done vie JDBC, latest
version, using XA Transactions with a connection pool. This is standard
(at least for Jboss). It is also not forbidden to run twon instances on
the same machine, as long as the TCP Ports are unique per instance.
The specific problem was found inside the transcation manager of Jboss,
which implements the Xid generation (which is the transaction identifier
for an XA transaction). This identifier is build by using the hostname
and a counter, which always starts at zero.
It occurred that both instances have a transaction with the same Xid at
nearly the same time, especially when both instances are started at the
same time.
Now if one instance does a commit and the other a rollback, Informix
tried to rollback a transaction, which was not existing any more
(because the other Jboss instance had already commited the transaction.
This lead to the crash.
The solution is simple: Jboss supports setting the base for the Xid
identifier in its jboss-service.xml file, where the XidFactory is
instanciated. For the second instance we have set a value very different
from the first instance and now the problem cannot occur any more. Since
this setting has been done, IDS has not crashed any more.
Just to mention: we have switched to another machine, patched Solaris
multiple times, modified system parameters, modified IDS parameters,
upgraded to IDS 10.0FC6W5. Of course, none of these could help us to get
rid of the problem.
Maybe this helps somebody in the future.
Marcus
-----Original Message-----
From: Paul Watson [mailto:paul@oninit.com]
Sent: Monday, July 02, 2007 3:29 PM
To: ids@iiug.org
Subject: RE: Informix 10 crash [9485]
If you are running fully patched Solaris then you should be fine
(subject to a bug unique to hardware combinations) We have a number of
customers on FC6 and Solaris 9
Cheers
Paul
Paul Watson
Tel: +44 1414161772 +1 913-400-2620
Mob: +44 7818003457 +1 913-387-7529
Web: www.oninit.com
Failure is not as frightening as regret.
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> ART KAGEL, BLOOMBERG/ 731 LEXIN
> Sent: 02 July 2007 08:20
> To: ids@iiug.org
> Subject: Re: Informix 10 crash [9484]
>
> Looks like a bug in the Solaris libthread _setitimer or _sema_post
> function.
>
> Art S. Kagel
> ----- Original Message -----
> From: Marcus Haarmann <ids@iiug.org>
> At: 6/30 4:15:39
>
> Hi all,
>
> we have an instance (IDS10FC6, Solaris 9 SPARC) which crashes every
> now and then (after some days).
> The af File shows different operations which were executed last, but
> always a call at the end to some thread/semaphore functions (sema_post
> und setitimer).
> Could this be a semaphore related problem, or did we touch a Solaris
> bug ?
> Semaphore parameters are like this:
> set semsys:seminfo_semmns=4096
> set semsys:seminfo_semmni=4096
> set semsys:seminfo_semmsl=500
> set semsys:seminfo_semmnu=4096
> set semsys:seminfo_semmap=64
> set semsys:seminfo_semopm=10
> set semsys:seminfo_semume=64
> set semsys:seminfo_semusz=96
> set semsys:seminfo_semvmx=32767
> set semsys:seminfo_semaem=16384
>
> Any idea on this ?
>
> Thanks, Marcus
> Examples:
> 0x1009caa34 oninit :: afstack + 0x34
> sp=0x1558de4f0(0x15528d028, 0x151cb6028, 0x 100000b, 0x0, 0x0, 0x0)
> 0x1009cf5e4 oninit :: mt_ex_throw_sig + 0x320 sp=0x1558de7c0
> delta_sp=720(0x100f 2c4f8, 0x101109ea0, 0x0, 0x1011d3ab0, 0x10110da90,
> 0x15528d028)
> 0x10098b8c8 oninit :: afsig_handler + 0x158 sp=0x1558de980
> delta_sp=448(0x1011cd 030, 0x41b0, 0x101109e60, 0x101109ea0, 0x4000,
> 0x0) 0xffffffff7f218530
> /usr/lib/sparcv9/libthread.so.1 :: _setitimer + 0xb4
> sp=0x155
> 8dea40 delta_sp=192(0xb, 0x1558df070, 0x1558ded90, 0x10098b770, 0x0,
> 0x0)
> 0xffffffff7f212074 /usr/lib/sparcv9/libthread.so.1 ::
> _sema_post + 0x530
> sp=0x15
> 58deaf0 delta_sp=176(0xffffffff7d000000, 0x1558df070, 0x1558ded90,
> 0x0, 0x0, 0x0
> )
> 0xffffffff7f212238 /usr/lib/sparcv9/libthread.so.1 ::
> _sema_post + 0x6f4
> sp=0x15
> 58dec20 delta_sp=304(0xb, 0x1558df070, 0x1558ded90, 0x1558df940,
> 0x102f53,
> 0x0)
> 0x10087aa5c oninit :: log_put + 0xed4 sp=0x1558decd0
> delta_sp=176(0x1011b318c, 0 x1011de714, 0x1011de048, 0x8112, 0x16c,
> 0x10a072800) 0x100873b90 oninit :: logm_write + 0x534 sp=0x1558df780
> delta_sp=2736(0x1011de04
> 8, 0x8102, 0x1504c71e4, 0x2a, 0x102f53, 0x1558df920) 0x1006ea96c
> oninit :: logvimage_new + 0x2a0 sp=0x1558df840 delta_sp=192(0x109, 0
> x1b905, 0x1011cc590, 0x1558dfb90, 0x1558dfb88, 0x0)
> 0x1006eae48 oninit :: logdimage + 0x4c8 sp=0x1558df950
> delta_sp=272(0x8002, 0x10 9, 0x0, 0x6, 0x109, 0x12fb3e42e)
> 0x100616114 oninit :: rew_home + 0x5a4 sp=0x1558dfa70
> delta_sp=288(0x1b905, 0x10 11de048, 0x1011ccec0, 0x1558dfb88,
> 0x12fb3e42e, 0x0)
> 0x1006155e8 oninit :: rewrecord + 0x578 sp=0x1558dfba0
> delta_sp=304(0x1600, 0x10 11de500, 0x1011de714, 0x1000, 0x1011ccec0,
> 0x1011de048)
> 0x100613e54 oninit :: rsrewrec + 0x184 sp=0x1558dfc60
> delta_sp=192(0x1011de048, 0x1b905, 0x151ab5878, 0x15176259c,
> 0x151762598, 0x151ab5878) 0x100a9e110 oninit :: fmrewrec +
> 0x3c4 sp=0x1558dfd30 delta_sp=208(0x4,
> 0x151a58
> ab8, 0x151762598, 0x151ab5878, 0x102f53, 0x0)
> 0x1001fe1b4 oninit :: aud_sqisrewrec + 0x50 sp=0x1558dfe60
> delta_sp=304(0x4,
> 0x8
> 4, 0x1011e7318, 0x1b905, 0x151e0a038, 0x151ab5878) 0x100343f70 oninit
> :: doupdate + 0x64c sp=0x1558dff30 delta_sp=208(0x1561535f8,
>
> ------------------------------------------------------
>
> 0x1009caa34 oninit :: afstack + 0x34
> sp=0x15dd081b0(0x1569d5028, 0x15150bea0, 0x 1000021, 0x0, 0x0, 0x0)
> 0x1009cf5e4 oninit :: mt_ex_throw_sig + 0x320 sp=0x15dd08480
> delta_sp=720(0x100f 2c4f8, 0x101109ea0, 0x0, 0x1011d3ab0, 0x10110da90,
> 0x1569d5028)
> 0x10098b8c8 oninit :: afsig_handler + 0x158 sp=0x15dd08640
> delta_sp=448(0x1011cd 030, 0x41b0, 0x101109e60, 0x101109ea0, 0x4000,
> 0x0) 0xffffffff7f218530
> /usr/lib/sparcv9/libthread.so.1 :: _setitimer + 0xb4 sp=0x15d d08700
> delta_sp=192(0xb, 0x15dd08d30, 0x15dd08a50, 0x10098b770, 0x0, 0x0)
> 0xffffffff7f212074 /usr/lib/sparcv9/libthread.so.1 ::
> _sema_post + 0x530
> sp=0x15
> dd087b0 delta_sp=176(0xffffffff7d000000, 0x15dd08d30, 0x15dd08a50,
> 0x0, 0x0, 0x0
> )
> 0xffffffff7f212238 /usr/lib/sparcv9/libthread.so.1 ::
> _sema_post + 0x6f4
> sp=0x15
> dd088e0 delta_sp=304(0xb, 0x15dd08d30, 0x15dd08a50,
> 0xfffffffffffffffe, 0x4, 0x0
> )
> 0x100770160 oninit :: isxattach + 0x158 sp=0x15dd08990
> delta_sp=176(0x155050fd0, 0x1, 0x156a4b984, 0x1011de048, 0x0,
> 0x1011de500) 0x10076e520 oninit :: xa_end + 0x320