[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::rdb_60

Title:Oracle Rdb - Still a strategic database for DEC on Alpha AXP!
Notice:RDB_60 is archived, please use RDB_70..
Moderator:NOVA::SMITHISON
Created:Fri Mar 18 1994
Last Modified:Fri May 30 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:5118
Total number of notes:28246

3424.0. "Hibernating on AIJ submission - How to continue ?" by ORAREP::TAV02::KLEIN () Mon Nov 27 1995 02:44

T.RTitleUserPersonal
Name		DateLines
3424.1it is waiting for the ALS processDUCATI::LASTOVICADoes fuzzy logic tickle?Mon Nov 27 1995 09:453
3424.2ukv031.uk.oracle.com::PICKERINGSSimon Pickering -- [email protected]Mon Nov 27 1995 11:143
3424.3DUCATI::LASTOVICADoes fuzzy logic tickle?Mon Nov 27 1995 11:225
3424.4More InfoORAREP::TAV02::GODOVNIKHaim GodovnikTue Nov 28 1995 06:1118
3424.5als status?HOTRDB::LASTOVICADoes fuzzy logic tickle?Tue Nov 28 1995 10:285
3424.6ORAREP::TAV02::KLEINWed Nov 29 1995 03:3212
3424.7ORAREP::TAV02::KLEINWed Nov 29 1995 04:4214
3424.8NOVA::R_ANDERSONOracle Corporation (603) 881-1935Wed Nov 29 1995 06:4712
3424.9ORAREP::TAV02::ARIEArie Blum - SI DEC-IsraelThu Nov 30 1995 03:3925
3424.10NOVA::R_ANDERSONOracle Corporation (603) 881-1935Thu Nov 30 1995 06:505
3424.11ARB info in AIJ statNOVA::ROTENBERGHaim - Oracle Rdb EngineeringMon Dec 04 1995 11:077
3424.12ORAREP::TAV02::ARIEArie Blum - SI DEC-IsraelTue Dec 05 1995 02:5516
3424.13Some additional questionsORAREP::STKHLM::KNORN"Stefan Knorn SI Stockholm"Fri Jan 19 1996 04:2723
3424.14NOVA::R_ANDERSONOracle Corporation (603) 881-1935Fri Jan 19 1996 06:0920
3424.15A bit more about the RMU-numbersORAREP::STKHLM::KNORN"Stefan Knorn SI Stockholm"Fri Jan 19 1996 09:0216
3424.16NOVA::R_ANDERSONOracle Corporation (603) 881-1935Fri Jan 19 1996 10:288
3424.17What happends ?ORAREP::STKHLM::KNORN"Stefan Knorn SI Stockholm"Mon Jan 22 1996 09:1312
3424.18NOVA::R_ANDERSONOracle Corporation (603) 881-1935Mon Jan 22 1996 11:2111
3424.19Another customer seeing thisM5::MMCRACKEWed Feb 28 1996 10:5854
3424.20NOVA::ROTENBERGHaim - Oracle Rdb EngineeringThu Feb 29 1996 02:166
3424.21NOVA::R_ANDERSONOracle Corporation (603) 881-1935Wed Mar 13 1996 15:1110
3424.22M5::MMCRACKEMon Mar 18 1996 09:045
3424.23NOVA::R_ANDERSONOracle Corporation (603) 881-1935Mon Mar 18 1996 16:484
3424.24later that evening...M5::JAKUHNhave woodchipper will travelFri Dec 06 1996 15:525
3424.25Rdb v6.1 ECO 4NOVA::R_ANDERSONOracle Corporation (603) 881-1935Sat Dec 07 1996 07:317
3424.26M5::JAKUHNhave woodchipper will travelMon Dec 09 1996 13:354
3424.276.1-4M5::JAKUHNhave woodchipper will travelMon Dec 09 1996 17:432
3424.28it seems to be backM5::JAKUHNhave woodchipper will travelMon Dec 16 1996 12:422
3424.29how 2 work the workaroundM5::JAKUHN[email protected]Mon Dec 16 1996 16:0623
3424.30fixed in V6.1Ajpalp1.jp.oracle.com::TANIITue Dec 17 1996 02:436
3424.31thank youM5::JAKUHN[email protected]Tue Dec 17 1996 13:021
3424.31well...M5::JAKUHN[email protected]Mon Dec 23 1996 15:523
3424.32HIBERNATING ON AIJ SUBMISSION WHEN USING ALSNOMAHS::SECRISTRdb WWS; [email protected]Fri Mar 14 1997 10:1011
    
    I have another customer with the problem under 6.1A too.  He didn't
    have the access to bugcheck it at the time, though.  This seems to
    be bugged as 380704 pending output from RMU/SHOW STAT.  I believe
    I have supplied this information in note 36.* of RDB_70.  The
    customer may still have a full listing from a SH STAT report even
    now.  I have sent email to AGODFRIN.FR.
    
    Regards,
    rcs
3424.33NOVA::R_ANDERSONOracle Corporation (603) 881-1935Fri Mar 14 1997 10:246
This problem was *supposed* to have been fixed in Rdb v6.1A.  I'm very surprised
to hear that this problem still seems to exist.

I would be interested to see the "Active User Stall Messages" screen output.

Rick
3424.34"Active User Stall Messages" for incident twoNOMAHS::SECRISTRdb WWS; [email protected]Fri Mar 14 1997 14:48101
    
    Here are the fragments we got from the customer for the second
    incident.  What are the processes in the RMU/SH LOCK called 
    "DBchkpt13:02:10" ?
    
    They happened to spool an RMU/SHOW STAT to disk all day and
    I'm also having them send me the output on tape for the day
    of incident two.
    
    I lied about incident three -- after the "wakes" everything went
    back to what it was before.
    
    
    Regards,
    rcs
    
    Process.ID Since......   Stall.reason............................. Lock.ID.
    2020108E:1s              writing AIJ sequence 442 block 51
    202010C7:1 13:13:50.03 - waiting for RTUPB list (EX)               5D008DB7
    202010C8:1 13:13:49.95 - waiting for RTUPB list (EX)               49008A6F
    202010C5:1 14:23:34.47 - waiting for freeze (PR)
    202010D0:1 13:13:49.95 - waiting for RTUPB list (EX)               07000E1B
    202010C9:1 13:13:50.01 - waiting for RTUPB list (EX)               01008FF2
    202010C6:1 13:13:49.95 - hibernating on AIJ submission
    202010CC:1 13:13:49.95 - waiting for RTUPB list (EX)               0100904B
    202010C6:2 13:13:49.95 - waiting for RTUPB list (EX)               1902E9C6
    202010C3:1 13:13:49.95 - waiting for RTUPB list (EX)               01009256
    202010CD:1 13:13:49.95 - waiting for RTUPB list (EX)               0100925C
    202010C4:1 13:08:05.31 - waiting for record 1182:97:13 (PR)        4A055300
    202010D1:1 13:13:49.95 - waiting for RTUPB list (EX)               02009C78
    202010CE:1 13:13:49.98 - waiting for RTUPB list (EX)               01009C7D
    202010CF:1 13:13:49.95 - waiting for RTUPB list (EX)               01009EAF
    202010C5:2 13:13:49.95 - waiting for RTUPB list (EX)               0100A2F0
    202010C9:2 13:13:49.95 - waiting for RTUPB list (EX)               0100A806
    
    While concurrently SHOW LOCKS/MODE=BLOCKING/OPTION=FULL:
    
    ...
    [edited]
    ...
    --------------------------------------------------------------------------------
    Resource: RTUPB list
    
              ProcessID Process Name        Lock ID   System ID Requested Granted
    
              --------- ---------------     --------- --------- --------- -------
    Waiting:  202010D0  QA_SYNCFUTXFER.     07000E1B  00010001  EX        NL
    Blocker:  202010C3  QA_BRDCASTSRV..     01009256  00010001  EX        NL
    Blocker:  202010C5  QA_TM991.......     0100A2F0  00010001  EX        NL
    Blocker:  202010D1  QA_SYNCOPTXFER.     02009C78  00010001  EX        NL
    Blocker:  202010C4  QA_TM153.......     060126A8  00010001  EX        NL
    Blocker:  202010C6  QA_952_O.......     1902E9C6  00010001  EX        EX
    ...
    --------------------------------------------------------------------------------
    Resource: RTUPB list
    
              ProcessID Process Name        Lock ID   System ID Requested Granted
    
              --------- ---------------     --------- --------- --------- -------
    Waiting:  202010C8  QA_951_O.......     49008A6F  00010001  EX        NL
    Blocker:  202010CF  QA_SYNCOPTTRD..     01009EAF  00010001  EX        NL
    Blocker:  202010CD  QA_READCECBKUP.     0100925C  00010001  EX        NL
    Blocker:  202010D0  QA_SYNCFUTXFER.     07000E1B  00010001  EX        NL
    Blocker:  202010C3  QA_BRDCASTSRV..     01009256  00010001  EX        NL
    Blocker:  202010C5  QA_TM991.......     0100A2F0  00010001  EX        NL
    Blocker:  202010D1  QA_SYNCOPTXFER.     02009C78  00010001  EX        NL
    Blocker:  202010C4  QA_TM153.......     060126A8  00010001  EX        NL
    Blocker:  202010C6  QA_952_O.......     1902E9C6  00010001  EX        EX
    ...
    --------------------------------------------------------------------------------
    Resource: termination (00DD) 2020108F:1
    
              ProcessID Process Name        Lock ID   System ID Requested Granted
    
              --------- ---------------     --------- --------- --------- -------
    Waiting:  20201028  RDMS_MONITOR61.     3C009059  00010001  PW        NL
    Blocker:  2020108F  DBchkpt13:02:10     4904DE0D  00010001  PW        PW
    ...
    --------------------------------------------------------------------------------
    Resource: RTUPB list
    
              ProcessID Process Name        Lock ID   System ID Requested Granted
    
              --------- ---------------     --------- --------- --------- -------
    Waiting:  2020108F  DBchkpt13:02:10     2C052C4C  00010001  CR        NL
    Blocker:  202010C7  QA_952_F.......     5D008DB7  00010001  EX        NL
    Blocker:  202010C9  QA_951_F.......     01008FF2  00010001  EX        NL
    Blocker:  202010CE  QA_SYNCFUTTRD..     01009C7D  00010001  EX        NL
    Blocker:  202010C7  QA_952_F.......     01010E56  00010001  EX        NL
    Blocker:  202010C9  QA_951_F.......     0100A806  00010001  EX        NL
    Blocker:  202010CC  QA_READCECTICK.     0100904B  00010001  EX        NL
    Blocker:  202010C8  QA_951_O.......     49008A6F  00010001  EX        NL
    Blocker:  202010CF  QA_SYNCOPTTRD..     01009EAF  00010001  EX        NL
    Blocker:  202010CD  QA_READCECBKUP.     0100925C  00010001  EX        NL
    Blocker:  202010D0  QA_SYNCFUTXFER.     07000E1B  00010001  EX        NL
    Blocker:  202010C3  QA_BRDCASTSRV..     01009256  00010001  EX        NL
    Blocker:  202010C5  QA_TM991.......     0100A2F0  00010001  EX        NL
    Blocker:  202010D1  QA_SYNCOPTXFER.     02009C78  00010001  EX        NL
    Blocker:  202010C4  QA_TM153.......     060126A8  00010001  EX        NL
    Blocker:  202010C6  QA_952_O.......     1902E9C6  00010001  EX        EX
    ...