Oninit cdi / Archive
Talk to an expert →

874 exception error

Posted in 2008

Topics: Performance & Tuning, Error Codes & Troubleshooting, Platform-Specific Issues, Cloud, Docker & Containers, Versions, Editions & End-of-Life

alberto rodriguez — — source: IIUG Forums & Mailing Lists

Hello list, Executing a procedure the engine response "874 general exception error has ocurred in the optimizer"; online.log say ... Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem IBM Informix Dynamic Server Version 11.10.UC1 Who: Session(123, informix@svc01, 3751, 0x457bdd68) Thread(179, sqlexec, 457909e8, 3) File: mtex.c Line: 420 Action:Please notify IBM Informix Technical Support. stack trace for pid 5355 written to /d1/informix/tmp/af.49b57c1 See Also: /d1/informix/tmp/af.49b57c1, shmem.49b57c1.0 Exception Caught. Type: MT_EX_OS, Context: mem ... and /d1/informix/tmp/af.46b57c1 .. 15:27:45 Who: Session(123, informix@svc01, 3751, 0x457bdd68) Thread(179, sqlexec, 457909e8, 3) File: mtex.c Line: 420 15:27:45 Action: Please notify IBM Informix Technical Support. 15:27:45 Raw hex dump of stack located in /d1/informix/tmp/af.49b57c1.rawstk 15:27:45 Stack for thread: 179 sqlexec base: 0x4a205000 len: 36864 pc: 0x088b27c1 tos: 0x4a20a410 state: running vp: 3 --------------------------------------------------------------- engine : ids 11.10 UC1 o.s. : redhat Enterprise linux 5 same procedure work fine in ids 9.21 on openserver 6. Can somebody tell me what happend?, any idea? thanks _________________________________________________________________ Stop squinting -- view your photos on your TV. Learn more. http://www.microsoft.com/windows/digitallife/default.mspx?deepLink=photos

↪ replying to alberto rodriguez
alberto rodriguez — — source: IIUG Forums & Mailing Lists

update statistics for table ... low drop distributions ,,,, fix the problem > To: ids@iiug.org> From: sqlweb@hotmail.com> Subject: 874 exception error [12282]> Date: Mon, 2 Jun 2008 17:10:21 -0400> > Hello list, > Executing a procedure the engine response > "874 general exception error has ocurred in the optimizer"; > > online.log say ... > > Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem IBM Informix > Dynamic Server Version 11.10.UC1 Who: Session(123, informix@svc01, 3751, > 0x457bdd68) Thread(179, sqlexec, 457909e8, 3) File: mtex.c Line: 420 Action: > Please notify IBM Informix Technical Support. stack trace for pid 5355 written > to /d1/informix/tmp/af.49b57c1 See Also: /d1/informix/tmp/af.49b57c1, > shmem.49b57c1.0 Exception Caught. Type: MT_EX_OS, Context: mem > > .... and /d1/informix/tmp/af.46b57c1 .. > > 15:27:45 Who: Session(123, informix@svc01, 3751, 0x457bdd68) Thread(179, > sqlexec, 457909e8, 3) File: mtex.c Line: 420 15:27:45 Action: Please notify > IBM Informix Technical Support. 15:27:45 Raw hex dump of stack located in > /d1/informix/tmp/af.49b57c1.rawstk 15:27:45 Stack for thread: 179 sqlexec > base: 0x4a205000 len: 36864 pc: 0x088b27c1 tos: 0x4a20a410 state: running vp: > 3 --------------------------------------------------------------- > engine : ids11.10 UC1 > o.s. : redhat Enterprise linux 5 > > same procedure work fine in ids 9.21 on openserver 6. > > Can somebody tell me what happend?, any idea? > > thanks > > _________________________________________________________________ > Stop squinting -- view your photos on your TV. Learn more. > http://www.microsoft.com/windows/digitallife/default.mspx?deepLink=photos > > > ****************************************************************************** * > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ Send funny voice messages packed with tidbits from MSN. Everyone wants to be ready. http://www.noonewantstolookdumb.com?OCID=T001MSN54N1613A

↪ replying to alberto rodriguez
Art Kagel — — source: IIUG Forums & Mailing Lists

Had you dropped and recreated all of your data distributions and recompiled all of your stored procedures after the upgrade? On Mon, Jun 2, 2008 at 10:57 PM, alberto rodriguez <sqlweb@hotmail.com> wrote: > update statistics for table ... low drop distributions ,,,, fix the problem> > > To: ids@iiug.org> From: sqlweb@hotmail.com> Subject: 874 exception error > [12282]> Date: Mon, 2 Jun 2008 17:10:21 -0400> > Hello list, > Executing a > procedure the engine response > "874 general exception error has ocurred in > the optimizer"; > > online.log say ... > > Assert Failed: Exception Caught. > Type: MT_EX_OS, Context: mem IBM Informix > Dynamic Server Version > 11.10.UC1 > Who: Session(123, informix@svc01, 3751, > 0x457bdd68) Thread(179, sqlexec, > 457909e8, 3) File: mtex.c Line: 420 Action: > Please notify IBM Informix > Technical Support. stack trace for pid 5355 written > to > /d1/informix/tmp/af.49b57c1 See Also: /d1/informix/tmp/af.49b57c1, > > shmem.49b57c1.0 Exception Caught. Type: MT_EX_OS, Context: mem > > .... and > /d1/informix/tmp/af.46b57c1 .. > > 15:27:45 Who: Session(123, > informix@svc01, > 3751, 0x457bdd68) Thread(179, > sqlexec, 457909e8, 3) File: mtex.c Line: > 420 > 15:27:45 Action: Please notify > IBM Informix Technical Support. 15:27:45 > Raw > hex dump of stack located in > /d1/informix/tmp/af.49b57c1.rawstk 15:27:45 > Stack for thread: 179 sqlexec > base: 0x4a205000 len: 36864 pc: 0x088b27c1 > tos: 0x4a20a410 state: running vp: > 3 > --------------------------------------------------------------- > engine :> ids > 11.10 UC1 > o.s. : redhat Enterprise linux 5 > > same procedure work fine > in > ids 9.21 on openserver 6. > > Can somebody tell me what happend?, any idea? > > > > thanks > > > _________________________________________________________________ > > Stop squinting -- view your photos on your TV. Learn more. > > http://www.microsoft.com/windows/digitallife/default.mspx?deepLink=photos>; > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > _________________________________________________________________ > Send funny voice messages packed with tidbits from MSN. Everyone wants to > be > ready. > http://www.noonewantstolookdumb.com?OCID=T001MSN54N1613A > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

Related threads

Glossary