shahid.mehmood@aku.edu

--0-1101513929-975382977=:11569 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline IX VER 7.20.UC2, OS SCO UNIX VER 5. Yesterday, the ows stopped in panic. OnLine.log contains following message: ******* message starts here ******** 15:42:59 Checkpoint Completed: duration was 1 seconds. 15:46:46 Assert Failed: Internal Error - SegmentationViolation 15:46:46 Who: Session(376, sibtain@biruni, 7864, 273002216) Thread(408, sqlexec, 1043b6b8, 1) 15:46:46 Results: OnLine must abort 15:46:46 Action: Reinitialize shared memory 15:46:46 See Also: /tmp/af.198c835, shmem.198c835.0 15:46:48 rsinit.c, line 9499, thread 408, proc id27734, Segmentation Violation . 15:46:49 PANIC: Attempting to bring system down ***** message ends here ****** The two files created by the server are attached here with. one is af.198c835, and other is shmem.198c835.0 some how I am unable to attached the shmem.198c835.0 file, as yahoo allows maximum of 1.5 mb attachment. If you all wish, I can send this file using MS-OUTLOOK, which will inturn will send this file in MIME format ! We donot have any online or otherwise informix help available in our side of the world. This is why I am looking at you for the help. Your early response will be highly appreciated. Thanks in advance Shahid Mehmood Informix DBA The Aga Khan University Karachi, Pakistan. ===== Shahid Mehmood Software Designer Information Systems Department The Aga Khan University, Karachi, Pakistan __________________________________________________ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/ --0-1101513929-975382977=:11569 Content-Type: text/plain; name="af.198c835" Content-Description: af.198c835 Content-Disposition: inline; filename="af.198c835" 27:15:46 27:15:46 Assert Failed: Internal Error - Segmentation Violation 27:15:46 Who: Session(376, sibtain@biruni, 7864, 273002216) Thread(408, sqlexec, 1043b6b8, 1) 27:15:46 Results: OnLine must abort 27:15:46 Action: Reinitialize shared memory 27:15:46 See Also: /tmp/af.198c835, shmem.198c835.0 27:15:46 Stack for thread: 408 sqlexec base: 0x106804e0 len: 36864 pc: 0x00260cbd tos: 0x10688798 0x106887fc ***unknown*** (0x105197f4, 0x2, 0x404498, 0x1043b6b8) 0x0026070a mt_affail (0x10543da8, 0x10582ef8, 0x10543404, 0x1043b6b8) 0x00192ba5 rsam_affail (0x10543da8, 0x10582ef8, 0x10543404, 0x1043b6b8) 0x00010318 afsig_segv (0xb, 0x107a0000, 0x107a0000, 0x107a001f) 0x00315a84 _sigismember (0x1ffc0, 0x6, 0x10688f36, 0x1073a790) 0x002327f3 dotodecimal (0x106890e8, 0x10688f36, 0x1, 0x10688f50) 0x00232766 todecimal (0x106890e8, 0x10688f36, 0x106890e8, 0x0) 0x002322c9 tolong (0x106890e8, 0x107a36fc, 0x107a36a8, 0x10730022) 0x00231e56 rvaldata (0x106890e8, 0x1073a790, 0x2, 0x4) 0x0004e5ac loadkey (0x1073a670, 0x107a3710, 0x106892d4, 0x106892cc) 0x0004d9a1 readidx (0x1073a670, 0x100, 0x1068935e, 0x0) 0x0004d32a gettupl (0x1073a670, 0x0, 0x1082a878, 0x1082ab34) 0x0004be16 scan_next (0x1073a670, 0x0, 0x1082a878, 0x1082ab34) 0x000506f8 getrow (0x1082a878, 0x1082a878, 0x1082a878, 0x1082a878) 0x000505d2 fetchrow (0x1082a878, 0x1082a99c, 0x1082a878, 0x2) 0x0004fa72 doselect (0x1082a878, 0x400b2c, 0x463b50, 0x10) 0x000d74a1 excommand (0x1082a878, 0x1082a878, 0x5, 0x106894c4) 0x000bcd17 sq_exselect (0x0, 0x46457c, 0xa, 0x10785898) 0x000ca17f sqmain (0x0, 0x0, 0x0, 0x0) 0x0024b3ac startup (0x25, 0x1068952c, 0x106804cc, 0x4c) 0x00000000 ***unknown*** 27:15:46 ------------------ End of assertion failure 0 ----------------- --0-1101513929-975382977=:11569--

The famous 'dotodecimal' bug, upgrade Online to 7.31.UC4 or if available on your machine 7.31.UC7. Bug Number is either 99390 57835 55128 you are doing a select using where <character column> = <integer column> and it is finding an entry in the character column which is not numeric. Instead of getting a -1263 Character to numeric conversion error you get an engine crash instead! Famous for happening on one of our 7.2x engines! Shahid Mehmood wrote in message <8vvbjf$qi5$1@news.xmission.com>... > >--0-1101513929-975382977=:11569 >Content-Type: text/plain; charset=us-ascii >Content-Disposition: inline > >IX VER 7.20.UC2, OS SCO UNIX VER 5. > >Yesterday, the ows stopped in panic. OnLine.log >contains following message: > >******* message starts here ******** > >15:42:59 Checkpoint Completed: duration was 1 >seconds. >15:46:46 Assert Failed: Internal Error - Segmentation>Violation >15:46:46 Who: Session(376, sibtain@biruni, 7864, >273002216) > Thread(408, sqlexec, 1043b6b8, 1) >15:46:46 Results: OnLine must abort >15:46:46 Action: Reinitialize shared memory >15:46:46 See Also: /tmp/af.198c835, shmem.198c835.0 >15:46:48 rsinit.c, line 9499, thread 408, proc id>27734, Segmentation Violation >. >15:46:49 PANIC: Attempting to bring system down> >***** message ends here ****** > >The two files created by the server are attached here >with. one is af.198c835, and other is shmem.198c835.0 > >some how I am unable to attached the shmem.198c835.0 >file, as yahoo allows maximum of 1.5 mb attachment. > >If you all wish, I can send this file using >MS-OUTLOOK, which will inturn will send this file in >MIME format ! > >We donot have any online or otherwise informix help >available in our side of the world. This is why I am >looking at you for the help. > >Your early response will be highly appreciated. > >Thanks in advance > >Shahid Mehmood >Informix DBA >The Aga Khan University >Karachi, Pakistan. > >===== >Shahid Mehmood >Software Designer >Information Systems Department >The Aga Khan University, >Karachi, Pakistan > >__________________________________________________ >Do You Yahoo!? >Yahoo! Shopping - Thousands of Stores. Millions of Products. >http://shopping.yahoo.com/ >--0-1101513929-975382977=:11569 >Content-Type: text/plain; name="af.198c835" >Content-Description: af.198c835 >Content-Disposition: inline; filename="af.198c835" > >27:15:46 >27:15:46 Assert Failed: Internal Error - Segmentation Violation >27:15:46 Who: Session(376, sibtain@biruni, 7864, 273002216) > Thread(408, sqlexec, 1043b6b8, 1) >27:15:46 Results: OnLine must abort >27:15:46 Action: Reinitialize shared memory >27:15:46 See Also: /tmp/af.198c835, shmem.198c835.0 >27:15:46 Stack for thread: 408 sqlexec> > base: 0x106804e0 > len: 36864 > pc: 0x00260cbd > tos: 0x10688798 > >0x106887fc ***unknown*** (0x105197f4, 0x2, 0x404498, 0x1043b6b8) >0x0026070a mt_affail (0x10543da8, 0x10582ef8, 0x10543404, 0x1043b6b8) >0x00192ba5 rsam_affail (0x10543da8, 0x10582ef8, 0x10543404, 0x1043b6b8) >0x00010318 afsig_segv (0xb, 0x107a0000, 0x107a0000, 0x107a001f) >0x00315a84 _sigismember (0x1ffc0, 0x6, 0x10688f36, 0x1073a790) >0x002327f3 dotodecimal (0x106890e8, 0x10688f36, 0x1, 0x10688f50) >0x00232766 todecimal (0x106890e8, 0x10688f36, 0x106890e8, 0x0) >0x002322c9 tolong (0x106890e8, 0x107a36fc, 0x107a36a8, 0x10730022) >0x00231e56 rvaldata (0x106890e8, 0x1073a790, 0x2, 0x4) >0x0004e5ac loadkey (0x1073a670, 0x107a3710, 0x106892d4, 0x106892cc) >0x0004d9a1 readidx (0x1073a670, 0x100, 0x1068935e, 0x0) >0x0004d32a gettupl (0x1073a670, 0x0, 0x1082a878, 0x1082ab34) >0x0004be16 scan_next (0x1073a670, 0x0, 0x1082a878, 0x1082ab34) >0x000506f8 getrow (0x1082a878, 0x1082a878, 0x1082a878, 0x1082a878) >0x000505d2 fetchrow (0x1082a878, 0x1082a99c, 0x1082a878, 0x2) >0x0004fa72 doselect (0x1082a878, 0x400b2c, 0x463b50, 0x10) >0x000d74a1 excommand (0x1082a878, 0x1082a878, 0x5, 0x106894c4) >0x000bcd17 sq_exselect (0x0, 0x46457c, 0xa, 0x10785898) >0x000ca17f sqmain (0x0, 0x0, 0x0, 0x0) >0x0024b3ac startup (0x25, 0x1068952c, 0x106804cc, 0x4c) >0x00000000 ***unknown*** > > >27:15:46 >------------------ End of assertion failure 0 ----------------- > > >--0-1101513929-975382977=:11569--