Assert Failed: WARNING! Internal Error - Arithmeti

Posted in 2009

Summary

A user on IDS 7.13 under HP-UX 10.01 reported repeated "Assert Failed: WARNING! Internal Error - Arithmetic Exception" messages (SIGFPE in the optimizer, sqoptim/opinit), followed by CPU pegged at 99% and errors even on SELECTs. Advice given: restart the engine (onmode -ky, oninit) to clear it, keep the af file, and identify/stop the offending user's query. John Miller noted HP-UX 10 had cases where multiplying small floats raised arithmetic exceptions, with corrections made in IDS 7.3. Others stressed the version and OS are long out of support, so upgrading (e.g. via 7.31 to 10.00) plus a newer OS was the real remedy. No confirmed fix is recorded in the thread.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Error Codes & Troubleshooting, Versions, Editions & End-of-Life, Jobs, Consulting & Announcements

DEEPAK JOSHI — Fri, 18 Sep 2009 14:41:45 — source: IIUG Forums & Mailing Lists

Can anybody help me to understand the Problem below and how to resolve this problem and what to do in this situation. 08:41:25 08:41:25 Assert Failed: WARNING! Internal Error - Arithmetic Exception 08:41:25 Who:Session(102, hoopingk@speedway, 16363, -2147114748) Thread(246, sqlexec, 8003fed4, 3) 08:41:25 Results: Internally corrected 08:41:25 See Also: /tmp/af.f667f4 08:41:25 Stack for thread: 246 sqlexec base: 0x828ac010 len: 36864 pc: 0x00000000 tos: 0x828ad288 ( 0) 0x002ae608 afstack + 0xf0 [/informix/bin/oninit] ( 1) 0x002ade64 mt_affail + 0x2ec [/informix/bin/oninit] ( 2) 0x002ae07c mt_afwarn + 0x84 [/informix/bin/oninit] ( 3) 0x0003ec08 sqsig_fpe + 0x80 [/informix/bin/oninit] ( 4) 0x0001edbc afsig_fpe + 0x14 [/informix/bin/oninit] ( 5) 0xc011c7d8 _sigreturn [/usr/lib/libc.1] ( 6) 0x00030d30 opinit + 0x2c8 [/informix/bin/oninit] ( 7) 0x00030244 sqoptim + 0x634 [/informix/bin/oninit] ( 8) 0x00030458 sqoptim + 0x848 [/informix/bin/oninit] ( 9) 0x00139ae4 sq_bind + 0x2fc [/informix/bin/oninit] (10) 0x000fbc90 sqmain + 0x170 [/informix/bin/oninit] (11) 0x002b234c startup + 0x9c [/informix/bin/oninit] (12) 0x002aa86c resume + 0xd4 [/informix/bin/oninit] After this error, our DB Server CPU usage reached to 99% and after that continously error on informix logs:-- i.e errorneous even on select...... continously. We are using IDS 7.13 running on HP-UNIX 10.01.

↪ replying to DEEPAK JOSHI

Keith — Sun, 20 Sep 2009 21:49:55 — source: IIUG Forums & Mailing Lists

2009/9/18 DEEPAK JOSHI <djoshih@hotmail.com>: > Can anybody help me to understand the Problem below and how to resolve this > problem and what to do in this situation. > > 08:41:25 > 08:41:25 Assert Failed: WARNING! Internal Error - Arithmetic Exception > 08:41:25 Who:Session(102, hoopingk@speedway, 16363, -2147114748) > > Thread(246, sqlexec, 8003fed4, 3) > 08:41:25 Results: Internally corrected > 08:41:25 See Also: /tmp/af.f667f4 > 08:41:25 Stack for thread: 246 sqlexec > > base: 0x828ac010 > len: 36864 > > pc: 0x00000000 > tos: 0x828ad288 > > ( 0) 0x002ae608 afstack + 0xf0 [/informix/bin/oninit] > ( 1) 0x002ade64 mt_affail + 0x2ec [/informix/bin/oninit] > ( 2) 0x002ae07c mt_afwarn + 0x84 [/informix/bin/oninit] > ( 3) 0x0003ec08 sqsig_fpe + 0x80 [/informix/bin/oninit] > ( 4) 0x0001edbc afsig_fpe + 0x14 [/informix/bin/oninit] > ( 5) 0xc011c7d8 _sigreturn [/usr/lib/libc.1] > ( 6) 0x00030d30 opinit + 0x2c8 [/informix/bin/oninit] > ( 7) 0x00030244 sqoptim + 0x634 [/informix/bin/oninit] > ( 8) 0x00030458 sqoptim + 0x848 [/informix/bin/oninit] > ( 9) 0x00139ae4 sq_bind + 0x2fc [/informix/bin/oninit] > (10) 0x000fbc90 sqmain + 0x170 [/informix/bin/oninit] > (11) 0x002b234c startup + 0x9c [/informix/bin/oninit] > (12) 0x002aa86c resume + 0xd4 [/informix/bin/oninit] > > After this error, our DB Server CPU usage reached to 99% and after that > continously error on informix logs:-- i.e errorneous even on select...... > continously. We are using IDS 7.13 running on HP-UNIX 10.01. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > Raise a call on support and have the af file ready to send. If you need to get the engine running again quickly then onmode -ky and oninit. Keith

↪ replying to Keith

tilleul17@web.de — Mon, 21 Sep 2009 07:47:19 — source: IIUG Forums & Mailing Lists

>> >> After this error, our DB Server CPU usage reached to 99% and after that >> continously error on informix logs:-- i.e errorneous even on select...... >> continously. We are using IDS 7.13 running on HP-UNIX 10.01. >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > Raise a call on support and have the af file ready to send. If you > need to get the engine running again quickly then onmode -ky and > oninit. > > Keith > If the above version info is not a typo (i.e. should read 7.31) I guess it is futile trying to open a call with IBM Support . 7.13 had been out of support even before IBM bought Informix. I suggest to upgrade the system to a supported IDS version - along with the operating system and hardware - HP-UX 10.01 doesn't sound supported either. Get an Informix consultant to help you with the task if your are unsure how to do it. Rgds Tilman

↪ replying to tilleul17@web.de

John Miller — Mon, 21 Sep 2009 15:38:13 — source: IIUG Forums & Mailing Lists

In HPUX version 10 there were many times when you multiplied small floating numbers and the result was a arithmetic exception. Version 7.3 had some corrections to alleviate this situation. John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 09/21/2009 12:47:19 AM: > [image removed] > > Re: Assert Failed: WARNING! Internal Error - A.... [17120] > > tilleul17@web.de > > to: > > ids > > 09/21/2009 12:48 AM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > >> > >> After this error, our DB Server CPU usage reached to 99% and after that > >> continously error on informix logs:-- i.e errorneous even on select...... > >> continously. We are using IDS 7.13 running on HP-UNIX 10.01. > >> > >> > >> > > > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > >> > > > > Raise a call on support and have the af file ready to send. If you > > need to get the engine running again quickly then onmode -ky and > > oninit. > > > > Keith > > > > If the above version info is not a typo (i.e. should read 7.31) I guess > it is futile trying to open a call with IBM Support . > 7.13 had been out of support even before IBM bought Informix. > I suggest to upgrade the system to a supported IDS version - along with > the operating system and hardware - HP-UX 10.01 doesn't sound supported > either. > Get an Informix consultant to help you with the task if your are unsure > how to do it. > Rgds > Tilman > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to John Miller

DEEPAK JOSHI — Thu, 24 Sep 2009 19:45:15 — source: IIUG Forums & Mailing Lists

Today again we get the error below and I have no clue how to tackle this situation and how to resolve this problem. We are using IDS 7.13 running on HP-UNIX 10.01? Can anybody help me to troubleshoot this? 13:43:13 Assert Failed: WARNING! Internal Error - Arithmetic Exception 13:43:13 Who:Session(8426, careyj@speedway, 27900, -2101595908) Thread(30690, sqlexec, 80040fa4, 3) 13:43:13 Results: Internally corrected 13:43:13 See Also: /tmp/af.77e2afb1 13:43:13 Stack for thread: 30690 sqlexec base: 0x86eb6010 len: 36864 pc: 0x00000000 tos: 0x86eb7288 ( 0) 0x002ae608 afstack + 0xf0 [/informix/bin/oninit] ( 1) 0x002ade64 mt_affail + 0x2ec [/informix/bin/oninit] ( 2) 0x002ae07c mt_afwarn + 0x84 [/informix/bin/oninit] ( 3) 0x0003ec08 sqsig_fpe + 0x80 [/informix/bin/oninit] ( 4) 0x0001edbc afsig_fpe + 0x14 [/informix/bin/oninit] ( 5) 0xc011c7d8 _sigreturn [/usr/lib/libc.1] ( 6) 0x00030d30 opinit + 0x2c8 [/informix/bin/oninit] ( 7) 0x00030244 sqoptim + 0x634 [/informix/bin/oninit] ( 8) 0x00030458 sqoptim + 0x848 [/informix/bin/oninit] ( 9) 0x00139ae4 sq_bind + 0x2fc [/informix/bin/oninit] (10) 0x000fbc90 sqmain + 0x170 [/informix/bin/oninit] (11) 0x002b234c startup + 0x9c [/informix/bin/oninit] (12) 0x002aa86c resume + 0xd4 [/informix/bin/oninit] 13:43:13 ------------------ End of assertion failure 0 -----------------

↪ replying to DEEPAK JOSHI

Jonathan — Fri, 25 Sep 2009 00:45:42 — source: IIUG Forums & Mailing Lists

On Thu, Sep 24, 2009 at 12:45, DEEPAK JOSHI <djoshih@hotmail.com> wrote: > Today again we get the error below and I have no clue how to tackle this > situation and how to resolve this problem. We are using IDS 7.13 running on > HP-UNIX 10.01? Can anybody help me to troubleshoot this? > > 13:43:13 Assert Failed: WARNING! Internal Error - Arithmetic Exception > 13:43:13 Who:Session(8426, careyj@speedway, 27900, -2101595908) > > Thread(30690, sqlexec, 80040fa4, 3) > 13:43:13 Results: Internally corrected > 13:43:13 See Also: /tmp/af.77e2afb1 > 13:43:13 Stack for thread: 30690 sqlexec > > base: 0x86eb6010 > len: 36864 > > pc: 0x00000000 > tos: 0x86eb7288 > > ( 0) 0x002ae608 afstack + 0xf0 [/informix/bin/oninit] > ( 1) 0x002ade64 mt_affail + 0x2ec [/informix/bin/oninit] > ( 2) 0x002ae07c mt_afwarn + 0x84 [/informix/bin/oninit] > ( 3) 0x0003ec08 sqsig_fpe + 0x80 [/informix/bin/oninit] > ( 4) 0x0001edbc afsig_fpe + 0x14 [/informix/bin/oninit] > ( 5) 0xc011c7d8 _sigreturn [/usr/lib/libc.1] > ( 6) 0x00030d30 opinit + 0x2c8 [/informix/bin/oninit] > ( 7) 0x00030244 sqoptim + 0x634 [/informix/bin/oninit] > ( 8) 0x00030458 sqoptim + 0x848 [/informix/bin/oninit] > ( 9) 0x00139ae4 sq_bind + 0x2fc [/informix/bin/oninit] > (10) 0x000fbc90 sqmain + 0x170 [/informix/bin/oninit] > (11) 0x002b234c startup + 0x9c [/informix/bin/oninit] > (12) 0x002aa86c resume + 0xd4 [/informix/bin/oninit] > > 13:43:13 > ------------------ End of assertion failure 0 ----------------- > > Well, if you were using a version of Informix which was supported, you would contact Tech Support. Since the version you are using is seriously out of support, you have a problem. Does rebooting the server instance clear the problem? The error says that there was an arithmetic exception in someone's thread (one careyj@speedway). What was he (or she) doing at the time? Can you stop them doing it? There's no denying it should not be happening; the trouble is, the only way to get a fix is to upgrade to a supported version of IDS. And even that is not guaranteed to be easy - I'm not sure that IBM supports an in situ upgrade from 7.13 to 10.00 or later. If you upgrade to 7.31.xDy (you have about 5 days of support left on that!) and then move to 10.00, you should be OK. But you need to get moving swiftly...and you will need a more recent O/S than HP-UX 10.01 too. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even. Ogden Nash <http://www.brainyquote.com/quotes/authors/o/ogden_nash.html>; - "The trouble with a kitten is that when it grows up, it's always a cat." --000feae9c6a34613bc04745c4425

Glossary

IDS (Informix Dynamic Server)