Re: 4GL crashing my Online Engine

Well, I was able to close and free about 5 cursors in some custom routines, and the program started to run fine. So I need to remember that fix for error 208. watjep@ferrari.netxpress.com (Paul K. Watje) wrote: >I am having a problem with a 4GL progam that is causing my Online >engin to crash under certain conditions. Here is the background: >This is the Online version we are running: >RSAM Version 5.02.UC6 -- On-Line -- Up 00:00:12 -- 1552 Kbytes >on a 3.2v4.2 duel pentium SCO box >and the RDS version >INFORMIX-4GL Version 4.11.UC4 >Pcode Version 8 >We had a Fourgen screen that was running fine. We changed several >table and columns names in the database and converted the program over >to the new names. It compiles and runs, but under certain conditions >I can consistantly generate the following error in the error log > >Date: 04/16/1996 Time: 16:48:03 >Program error at "custom.4gl", line number 664. >SQL statement error number -208. >Memory allocation failed during query processing. >This is a cursor prepartion statement, I can consistantly cause the >error in different places, depending on the steps I take, but the >error alway occurs on a database statement, prepare, fetch, select, >foreach, etc >The following Online error displays on the screen >16:48:07 420394: 02000000 d4014200 ......B. >16:48:07 -- Fail Consistency Check>-- Drop was refused: Dropping wrong TBLSpace, > requested 0 != actual 16777219 -- pid=21294 user=203 us=80401b40 >In the online logs the following message appears >16:41:36 On-Line Mode >16:46:42 Checkpoint Completed >16:48:16 Process Aborted Abnormally: pid=21294 user=203 us=80401b40 >flags=101 >16:48:16 Process Aborted Abnormally (critical section): pid=21294 >user=203 flags=101 >16:48:16 INFORMIX-OnLine entering ABORT mode!!! >16:48:16 -- Online Aborting -- us=804019f0, pid=20424, uid=778 >16:48:19 INFORMIX-OnLine Stopped >I am really at my wits end. I have tried everything I know to fix the >problem. >I talk to Informix Tech support, and they said to reset some shared >memory kernel parameters. >I upgraded the engine to the most current one I have in the shop. >I tried compiling to C and got the exact same error in the same place. >I recompiled everything. >The only suggestion left if freeing all closed cursors, but since this >is Fourgen, that will be a pain to modify all of the generated code. >Does anyone have any other suggestions? >Any help will be greatly appreciated. >Thanx >+-------------------------------------------------------------------+ >| Paul K. Watje 4GL/Fourgen Programmer | >| AEC Data Systems UNIX system administator | >| San Antonio, TX Database Administrator | >| watjep@NetXpress.com Blah, Blah, Blah, Blah | >+-------------------------------------------------------------------+ +-------------------------------------------------------------------+ | Paul K. Watje 4GL/Fourgen Programmer | | AEC Data Systems UNIX system administator | | San Antonio, TX Database Administrator | | watjep@NetXpress.com Blah, Blah, Blah, Blah | +-------------------------------------------------------------------+