4GL crashing my Online Engine

4GL crashing my Online Engine

Post by Paul K. Wat » Sun, 31 Dec 1899 09:00:00



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 |

+-------------------------------------------------------------------+

 
 
 

4GL crashing my Online Engine

Post by Paul K. Wat » Sun, 31 Dec 1899 09:00:00


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.


>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 |

>+-------------------------------------------------------------------+

+-------------------------------------------------------------------+
| Paul K. Watje                              4GL/Fourgen Programmer |
| AEC Data Systems                         UNIX system administator |
| San Antonio, TX                            Database Administrator |

+-------------------------------------------------------------------+

 
 
 

1. Informix 7.10.UD1 Online Engine Crashed Big Time

Fellow 7.1 Administrators:

This afternoon, we had a development instance of Informix 7.10 come
crashing down around our heads.  At around 2:30, we had an assert fail and
Online aborted.  Several developers got the message that both the primary
chunk and it's mirror were corrupt.  Since it was chunk 2 and the only
chunk whe have mirrored is rootdbs, I assume it was rootdbs.  Below is a
copy of the log.  I wonder if any of you have experienced similar
problems?  Or does anyone know if this is due to a bug which is fixed in a
more recent version?

Thanks for your help.

Tim

14:03:37  Checkpoint Completed:  duration was 0 seconds.
14:08:37  Checkpoint Completed:  duration was 0 seconds.
14:31:56  Checkpoint Completed:  duration was 1 seconds.
14:32:18  Assert Failed: Buffer modified in inconsistent chunk.

  Thread(97278, sqlexec, b00c5e4, 1)
14:32:18   Results: Chunk 2 is being taken OFFLINE.
14:32:18   Action: Restore chunk from archive.
14:32:18   See Also: /tmp/af.10781b6
14:32:18  Assert Failed: WARNING! Chunk 2 is being taken OFFLINE.

  Thread(97278, sqlexec, b00c5e4, 1)
14:32:18   Results: DBspace online_general is disabled.
14:32:18   Action: Restore DBspace online_general
14:32:18   See Also: /tmp/af.10781b6
14:32:18  Assert Failed: Page Check Error in getslot:bad page

  Thread(97278, sqlexec, b00c5e4, 1)
14:32:18   Results: Possible inconsistencies in 'TBLSpace 2097685'
14:32:18   Action: Run 'oncheck -cD 2097685'
14:32:18   See Also: /tmp/af.10781b6
14:32:18  Message 1772 not found.

14:32:18  Message 1772 not found.

14:37:06  Checkpoint Completed:  duration was 0 seconds.
14:48:39  INFORMIX-OnLine Stopped.
14:48:55  The number of configured CPU poll threads exceeds 'NUMCPUVPS'.
   NETTYPE 'hardhat_mainsm' poll threads started on NET VPs.

Tim Helton

Amgen doesn't believe a word I say, maybe they know something you don't?

2. SQL Security - hiding passwords

3. 4GL program crashes engine!

4. Informix/4GL P/A opportunity in Dallas, TX!

5. Online Engine vs Standard Engine

6. >>>Toronto - Uniface/Sybase Developer - Permanent

7. Can online engine access SE engine with triggers ?

8. Informix P/A's & DBA's needed in Raleigh, NC

9. Standard Engine Vs Online Engine

10. Jet Engine Crashes

11. Jet Engine crashes

12. Jet Engine Crashing