I discovered why this DBG error is happening.
I reran the program that got the stalled transaction error.
Unfortunately, it is using the "old" DBG file from the aborted run because
another session had the database open via Suprtool.
So I closed that session, reran the program and the DBG problem went away.
Brian.
On Mon, 3 Jan 2005 22:41:27 -0500, Brian Donaldson <[log in to unmask]>
wrote:
>In my hurry to get things done quicker I tried to abort the job
>running the program that gave me the STALLED TRANSACTION problem.
>
>Big mistake, aborting the job just trashed the data base:
>
> TURBOIMAGE RESULT AT ???????; RETURN STATUS = 63
> DBOPEN, MODE 1, ON MUSIC
> DBG DISABLED; POTENTIAL DAMAGE; ONLY DBCLOSE ALLOWED
> HEX DUMP OF STATUS ARRAY FOLLOWS:
> 003f 0003 0000 5143 0000 0191 4164 61c4 0001 0000
>
> **** PROGRAM QUIT; PARAM = 63
> ABORT: INDEXLOD.NMPRG.MUSICAT
> NM SYS a.010061ec dbg_abort_trace+$28
> NM PROG dc.0000cf78 _start+$4b0
>
> Program terminated in an error state. (CIERR 976)
> REMAINDER OF JOB FLUSHED.
> CPU sec. = 4. elapsed min. = 1. MON, JAN 3, 2005, 7:26 PM.
>
>
>Good thing I have a good backup of the data base which I can restore
from...
>
>Brian.
>
>On Mon, 3 Jan 2005 21:28:28 -0500, Brian Donaldson <[log in to unmask]>
>wrote:
>
>>Tracy:
>>
>>A program I have been developing has encountered the same problem as
yours.
>>
>>All because I had too many DBDELETE's and DBPUT's inside a single
DBXBEGIN.
>>
>>Displays here:
>>
>> Indices Deleted=>+000000228<
>> Indices Added =>+000000228<
>> Will delete indices for catalog id=>83061-2 <
>> Indices Deleted=>+000000161<
>> Indices Added =>+000000161<
>> Will delete indices for catalog id=>83092-2 <
>>
>> **** STALLED TRANSACTION: EXCEEDED ACCUMULATED LOG DATA THRESHOLD
>>
>> WARNING ** One or more entries on the error stack have been overwritten.
>>
>> HPE Error Management message 205
>>
>> WARNING ** Message set 185, Error number 1025 was not found in the syste
>> m catalog.
>>
>>
>> ABORT: INDEXLOD.xxxxxxxx.yyyyyyyy
>> NM SYS a.010061ec dbg_abort_trace+$28
>> NM USER bb.00ee77c8 PROC'EXIT000546+$70
>> NM PUB d6.000ad250 index_delete+$78c
>> NM PROG dc.0000d55c _start+$a94
>>
>>
>>So, it's back to the drawing board (slightly)
>>
>>
>>Brian Donaldson.
>>
>>On Tue, 21 Dec 2004 17:00:55 -0500, Johnson, Tracy
>><[log in to unmask]> wrote:
>>
>>>Even the programmer don't know.
>>>
>>>:JOB TLDBLD45,MANAGER.JL,QSDB45.
>>>Priority = CS; Inpri = 8; Time = UNLIMITED seconds.
>>>Job number = #j4114.
>>>TUE, DEC 21, 2004, 1:08 PM.
>>>HP3000 Release: C.75.00 User Version: C.75.00
>>>MPE/iX HP31900 C.45.05 Copyright Hewlett-Packard 1987.
>>>All rights reserved.
>>>STREAMED BY BACKUP45,MANAGER.SYS (#J3636) ON LDEV# 10
>>> STREAM DATE: TUE, DEC 21, 2004, 1:08 PM
>>>[snip]
>>>:COMMENT STREAM FILE TLDBLD45.PUB.XACTMAN
>>>:COMMENT STREAMED BY BACKUP45,MANAGER.SYS,PUB (A JOB STREAM)
>>>:COMMENT RUNNING PROGRAM MAIN.PUB.VESOFT
>>>:COMMENT ON TUE, DEC 21, 2004, 1:08 PM
>>>:COMMENT
>>>:COMMENT *******************************************************
>>>:COMMENT * J O B S T R E A M D O C U M E N T A T I O N *
>>>:RUN UT829.PUB.XACTMAN;PARM=300
>>>
>>>
>>>
>>>Load Transaction Logs into TLDB.QSDB##
>>>
>>>Database Number?
>>>
>>>Expected a Number.
>>>
>>>Database Number?
>>>
>>>Auto Load File: TR000372.MDATAB45
>>>
>>>
>>>**** STALLED TRANSACTION: EXCEEDED ACCUMULATED LOG DATA THRESHOLD
>>>WARNING ** One or more entries on the error stack have been overwritten.
>>>HPE Error Management message 205
>>>WARNING ** Message set 185, Error number 1030 was not found in the system
>>catalo
>>>g.
>>>Intrinsic layer; an access violation occurred.
>>>File System message 3
>>>Intrinsic layer; an access violation occurred.
>>>File System message 3
>>>Intrinsic layer; an access violation occurred.
>>>File System message 3
>>>Intrinsic layer; an access violation occurred.
>>>File System message 3
>>>Intrinsic layer; an access violation occurred.
>>>File System message 3
>>>Intrinsic layer; an access violation occurred.
>>>File System message 3
>>>Intrinsic layer; an access violation occurred.
>>>File System message 3
>>>Specifying the LONG MAPPED OPTION (item# 21) for this file type is
>invalid.
>>>(FILE OPEN ERROR -299)
>>>File System message 299
>>>Specifying the LONG MAPPED OPTION (item# 21) for this file type is
>invalid.
>>>(FILE OPEN ERROR -299)
>>>File System message 299
>>>Intrinsic layer; an access violation occurred.
>>>File System message 3
>>>Intrinsic layer; an access violation occurred.
>>>File System message 3
>>>Intrinsic layer; an access violation occurred.
>>>File System message 3
>>>Intrinsic layer; an access violation occurred.
>>>File System message 3
>>>Intrinsic layer; the operation could not be completed because a
>nonexistent
>>>file was specified.
>>>File System message 38
>>>FLABELINFO intrinsic.
>>>SUBSYS_INTRIN_ID message 25
>>>ABORT: UT829.PUB.XACTMAN
>>>NM SYS a.00ff1f70 dbg_abort_trace+$28
>>>NM USER 1ef.00d5dd94 PROC'EXIT000445+$78
>>>NM PROG a22.0000bab4 upd_tl_rec+$71c
>>>
>>>
>>>
>>>Program terminated in an error state. (CIERR 976)
>>>REMAINDER OF JOB FLUSHED.
>>>CPU sec. = 919. elapsed min. = 20. TUE, DEC 21, 2004, 1:28 PM.
>>>
>>>BT
>>>
>>>
>>>Tracy Johnson
>>>MSI Schaevitz Sensors
>>>
>>>* To join/leave the list, search archives, change list settings, *
>>>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>>
>>* To join/leave the list, search archives, change list settings, *
>>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
>* To join/leave the list, search archives, change list settings, *
>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
