Status: Unverified
SYMPTOM(s):
Running monthly reports crashes the (4GL) client session
Only running some queries crashes the 4GL client session. Other queries referring to the same tables run without problem.
Client protrace file reads as follows:
PROGRESS stack trace as of Wed Apr 6 14:13:11 2011 Command line arguments are /opt/dlc/OE101C/bin/_progres -pf <parameter file>
Startup parameters:
-pf /opt/dlc/OE101C/startup.pf,-cpinternal ISO8859-1,-cpstream ISO8859-1,-cpcoll Basic,-cpcase Basic,-d dmy,-numsep 44,-numdec 46,(end .pf),-pf <parameter file>,-T <temp directory> convmap .. convmap.cp,-cpstream iso8859-1,-cpterm iso8859-1,-d dmy,-h 3,-p m0000.p,-rereadnolock,-s 80,-yy 1950,-db <database name>,(end .pf)
( 0) 0x400000000084d74c uttraceback + 0x24 [/opt/dlc/OE101C/bin/_progres]
( 1) 0x4000000000840620 uttrace + 0x178 [/opt/dlc/OE101C/bin/_progres]
( 2) 0x4000000000840454 utcore + 0x11c [/opt/dlc/OE101C/bin/_progres]
( 3) 0x4000000000218314 drexit + 0x24c [/opt/dlc/OE101C/bin/_progres]
( 4) 0x4000000000283f10 drSigFatal + 0x88 [/opt/dlc/OE101C/bin/_progres]
( 5) 0xc0000000001f8ed8 _sigreturn [/usr/lib/pa20_64/libc.2]
( 6) 0x40000000006a7c88 cxRowidFind + 0x370 [/opt/dlc/OE101C/bin/_progres]
( 7) 0x40000000006e3c2c dsmCursorFindAndGet + 0x654 [/opt/dlc/OE101C/bin/_progres]
( 8) 0x40000000006e3138 dsmCursorFind + 0x40 [/opt/dlc/OE101C/bin/_progres]
( 9) 0x400000000076b678 qrIxGet + 0x130 [/opt/dlc/OE101C/bin/_progres]
(10) 0x400000000076ca58 qrNext + 0x160 [/opt/dlc/OE101C/bin/_progres]
(11) 0x4000000000281aa8 dbqry + 0x188 [/opt/dlc/OE101C/bin/_progres]
(12) 0x40000000004eec8c proqry + 0xd4 [/opt/dlc/OE101C/bin/_progres]
(13) 0x40000000004ee900 profnd + 0x360 [/opt/dlc/OE101C/bin/_progres]
(14) 0x400000000021be30 fdfnd + 0x1b0 [/opt/dlc/OE101C/bin/_progres]
(15) 0x400000000054f3a0 bfFindRow + 0x580 [/opt/dlc/OE101C/bin/_progres]
(16) 0x40000000005c691c rnbfnxtDoit + 0x7cc [/opt/dlc/OE101C/bin/_progres]
(17) 0x40000000005c5f38 rnbfnxtBody + 0x4a8 [/opt/dlc/OE101C/bin/_progres]
(18) 0x40000000005c5800 rnbfnxt + 0x110 [/opt/dlc/OE101C/bin/_progres]
(19) 0x40000000005cbed4 rnexec_entry + 0x5fc [/opt/dlc/OE101C/bin/_progres]
(20) 0x40000000005ce1b0 rninterpret + 0x68 [/opt/dlc/OE101C/bin/_progres]
(21) 0x400000000040faa4 umeDispatchEvent + 0x1454 [/opt/dlc/OE101C/bin/_progres]
(22) 0x40000000007b4500 wvRunDispatcher + 0x1a8 [/opt/dlc/OE101C/bin/_progres]
(23) 0x400000000050c0dc iodispatch + 0xec [/opt/dlc/OE101C/bin/_progres]
(24) 0x4000000000261a78 rnrq + 0x90 [/opt/dlc/OE101C/bin/_progres]
(25) 0x40000000002110c4 main + 0x2ac [/opt/dlc/OE101C/bin/_progres]
(26) 0xc00000000000b7a8 $START$ + 0xa0 [/usr/lib/pa20_64/dld.sl]
** ABL Stack Trace **
--> /opt/coins/tmp/p12011_cph_fm002.ped
--> (/opt/coins/tmp/p12011_cph_fm002.ped) at line 2
adecomm/_runcode.p (adecomm/_runcode.r) at line 659
ExecuteRun adeedit/_proedit.p (adeedit/_proedit.r) at line 3560
RunFile adeedit/_proedit.p (adeedit/_proedit.r) at line 10571
USER-INTERFACE-TRIGGER adeedit/_proedit.p (adeedit/_proedit.r) at line 1985
adeedit/_proedit.p (adeedit/_proedit.r) at line 12226
** Persistent procedures/Classes **
FACT(s) (Environment):
OpenEdge Category: Database
HP-UX 11.x
OpenEdge 10.1C
CAUSE:
Index corruption
FIX:
Perform an index rebuild on the database