Re: Help needed (assert failures, segemntation violations,..)
In article <35430918.2D78C022@glamus.de>, Marc Mielke <mielke@glamus.de>
writes
>Hello to all,
>
>we do have serious problems (as outlined below) and really require some
>help on this.
>I would be more than happy if anybody could point me the way how
>to get around this.
>
>All relevant information is provided below. If additinal input is
>required
>I will be happy to provide it.
>
Talk to Informix Technical Support. It looks like a bug or hardware
problem..
>The error only occurs randomly under a certain load in terms of hit
>frequency.
>
>Thank you very much
>Regards
>Marc
>......................................
>
>Application/Runtime Environment:
>
>1) Request from HTTP client
>2) Apache
>3) mod_informix (ESQL/C)
> (code excerpt):
> struct sqlda *udesc;
> EXEC SQL connect to :iconnectstring AS :iconnectstring;
> EXEC SQL whenever SQLERROR call boom;
> EXEC SQL set connection :iconnectstring;
> if(1802,"Connection name in use) EXEC SQL set connection
>:iconnectstring;
> EXEC SQL set pdqpriority off;
> EXEC SQL set optimization low;
> EXEC SQL prepare usqlobj from :iprocedure; (always a "execute
>procedure sp_xxx(...)")
> EXEC SQL describe usqlobj into udesc;
> /* initialize/alloc udesc */
> EXEC SQL declare usqlcurs cursor for usqlobj;
> EXEC SQL open usqlcurs;
> EXEC SQL fetch usqlcurs using descriptor udesc;
> while(records) EXEC SQL fetch usqlcurs using descriptor udesc;
> EXEC SQL close usqlcurs;
> EXEC SQL free usqlcurs;
> EXEC SQL free usqlobj;
> free(udesc);
> EXEC SQL set connection :iconnectstring dormant;
>
>Errors (from the various /tmp/af.*)
>------
>
>14:26:14
>14:26:14 Assert Failed: Internal Error - Segmentation Violation
>14:26:14 Who: Session(15, root@bluebox, 9668, 844222188)
> Thread(40, sqlexec, 324faed8, 3)
>14:26:14 Results: OnLine must abort
>14:26:14 Action: Reinitialize shared memory
>14:26:14 See Also: /tmp/af.284a65
>14:26:14 Stack for thread: 40 sqlexec>
> base: 0x328cc030
> len: 39936
> pc: 0x007f0c04
> tos: 0x328d4d60
>
>0x007f0300 mt_affail
>0x0069e5d4 rsam_affail
>0x0048a1d8 hang_thread
>0x00489fec afsig_segv
>09:25:48
>--------------------------------------------------------------------
>09:25:48 Assert Failed: Internal Error - Segmentation Violation
>09:25:48 Who: Session(17, root@bluebox, 21473, 844223064)
> Thread(43, sqlexec, 324fbb98, 3)
>09:25:48 Results: OnLine must abort
>09:25:48 Action: Reinitialize shared memory
>09:25:48 See Also: /tmp/af.2b9b7b
>09:25:48 Stack for thread: 43 sqlexec>
> base: 0x328a8018
> len: 39936
> pc: 0x007f0c04
> tos: 0x328b05e8
>
>0x007f0300 mt_affail
>0x0069e5d4 rsam_affail
>0x0048a1d8 hang_thread
>0x00489fec afsig_segv
>------------------------------------------------------------------------
>11:43:10 Found during mt_shm_free 1
>11:43:10 Pool '21' (0x3293c018)
>11:43:10 Bad block header 0x33e03820
>blk-64
>33e037e0: 33e03810 00000000 00010000 0018516e 3.8..... ......Qn
>33e037f0: 00000000 33e10678 00000008 33e03820 ....3..x ....3.8
>33e03800: 33e037a8 00000028 67c06ff0 00000000 3.7....( g.o.....
>33e03810: 00000000 00000000 66d1bf4c 00000000 ........ f..L....
>blk+64
>33e03820: 00000048 33e03858 33e037f8 00000038 ...H3.8X 3.7....8
>33e03830: 000003a5 00000071 343dbf00 00000000 .......q 4=......
>33e03840: 66d1bff4 00000000 34265b00 00000000 f....... 4&[.....
>33e03850: 00000000 00000000 ffffffff 33e03f88 ........ ....3.?.
>11:43:10 Bad block removed from pool
>11:43:10
>11:43:10 Assert Failed: Memory block header corruption detected in
>mt_shm_free 1
>11:43:10 Who: Session(21, root@bluebox, 5362, 0)
> Thread(47, sqlexec, 0, 3)
>11:43:10 Results: Pool repaired
>11:43:10 Action: Please notify Informix Technical Support.
>11:43:10 See Also: /tmp/af.2f812d
>11:43:10 Stack for thread: 47 sqlexec>
> base: 0x3288c030
> len: 39936
> pc: 0x007f0c04
> tos: 0x32894de8
>
>0x007f0300 mt_affail
>0x007ef934 recover_pool_bad_block
>0x007ed214 mt_shm_free
>0x00868120 fm_closefrags
>0x0085c2e8 fmclose
>0x00497ad8 sqisclose
>0x0057752c closerel
>0x005b5a68 scan_free
>0x005d6104 sort_free
>0x00576ac0 closecb
>0x005769c0 close_cb_subtree
>0x005769f4 close_cb_subtree
>0x005769f4 close_cb_subtree
>0x005768c4 closesdb
>0x005766a4 releasesdb
>0x00511df0 drpcurlist
>0x00513860 clean_proc
>0x0051363c rmstproc
>0x004f8268 sqscb_cleanup
>0x007f7134 destroy_session
>0x004a7d70 sqsetconerr
>0x004e1e40 asf_recv
>0x004e1f04 _iread
>0x004e0ee4 _igetint
>0x004f8e10 sqmain
>0x007fb644 startup
>0x007fb580 mt_show_bbitmap
>0x00000000 __dso_displacement
>
>
>11:43:14
>------------------ End of assertion failure 0 -----------------
>
>11:43:14
>11:43:14 Assert Failed: Memory freed at bad boundary. 1960 bytes at>33e03858
>
>11:43:14 Who: Session(21, root@bluebox, 5362, 0)
> Thread(47, sqlexec, 0, 1)
>11:43:14 Results: Memory lost
>11:43:14 Action: Action: %s
>11:43:14 See Also: /tmp/af.2f812d
>11:43:14 Stack for thread: 47 sqlexec>
> base: 0x3288c030
> len: 39936
> pc: 0x007f0c04
> tos: 0x32895288
>
>0x007f0300 mt_affail
>0x007fb22c freeblks
>0x007eba54 mt_shm_free_pool
>0x007f72f8 destroy_session
>0x004a7d70 sqsetconerr
>0x004e1e40 asf_recv
>0x004e1f04 _iread
>0x004e0ee4 _igetint
>0x004f8e10 sqmain
>0x007fb644 startup
>0x007fb580 mt_show_bbitmap
>0x00000000 __dso_displacement
>
>
>11:43:14
>------------------ End of assertion failure 1 -----------------
>
>14:26:14
>14:26:14 Assert Failed: Internal Error - Bus Error
>14:26:14 Who: Session(26, root@bluebox, 10394, 844226276)
> Thread(51, sqlexec, 324fe1d8, 1)
>14:26:14 Results: OnLine must abort
>14:26:14 Action: Reinitialize shared memory
>14:26:14 See Also: /tmp/af.334a65
>14:26:14 Stack for thread: 51 sqlexec>
> base: 0x328f2670
> len: 39936
> pc: 0x007f0c04
> tos: 0x328fb148
>
>0x007f0300 mt_affail
>0x0069e5d4 rsam_affail
>0x0048a1d8 hang_thread
>0x00489e30 afsig_bus
>18:59:18
>18:59:18 Assert Failed: Internal Error - Bus Error
>18:59:18 Who: Session(27, root@bluebox, 13850, 844226860)
> Thread(52, sqlexec, 324fe618, 1)
>18:59:18 Results: OnLine must abort
>18:59:18 Action: Reinitialize shared memory
>18:59:18 See Also: /tmp/af.348a65
>18:59:18 Stack for thread: 52 sqlexec>
> base: 0x32ac6018
> len: 39936
> pc: 0x007f0c04
> tos: 0x32ace648
>
>0x007f0300 mt_affail
>0x0069e5d4 rsam_affail
>0x0048a1d8 hang_thread
>0x00489e30 afsig_bus
>11:58:29
>11:58:29 Assert Failed: Internal Error - Arithmetic Exception
>11:58:29 Who: Session(35, root@bluebox, 26746, 844229780)
> Thread(61, sqlexec, 32500818, 1)
>11:58:29 Results: OnLine must abort
>11:58:29 Actio