[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:Thu May 29 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:5118
Total number of notes:28246

4971.0. "PIOFETCH$WITHIN_POOL_GB + 00000BC0" by CHSR36::JSUBRI (Focus on Open/Rdb++) Tue Jan 28 1997 09:35

The customer as turned on page transfert via memory and encontered a new
bugcheck (ie not related to BUG#432133 'PIOUTL$DO_IORB') during a recovery when 
the "dead process transaction 0:0 was not active", he his running with 
12000 GB of 12 Blocks each.

Already known or/and related to transfert via memory ?
/Jean-Luc

22-JAN-1997 23:44:46.14 - received user image termination from 20401E4E:1
  - abnormal user termination detected
  - database monitor created recovery process RDM_RB_1 (2040084F)
  - user termination suspended until recovery ready

22-JAN-1997 23:44:46.88 - received recovery attach from 2040084F:1
  - process name RDM_RB_1, user SYSTEM
  - user freed 48 global buffers, 6957 free out of 12000
  - 60 global buffers allocated to recovery process, 6897 free out of 12000
  - sending normal recovery attach reply to 2040084F:1

22-JAN-1997 23:44:46.94 - received recovery ready from 2040084F:1
  - process name RDM_RB_1, user SYSTEM
  - sending normal recovery ready reply to 2040084F:1
22-JAN-1997 23:44:48.11 - received recovery status from 2040084F:1
  - process name RDM_RB_1, user SYSTEM
  - Dead process transaction 0:0 was not active

  ===>>> bugcheck

22-JAN-1997 23:44:48.49 - received recovery image termination from 2040084F:1
  - user freed 60 global buffers, 6957 free out of 12000
  - recovery failed
  - starting delete-process shutdown of database
"_DSA4:[KUDA_DB20.KUDA_DB]KUDA_DATABASE.RDB;2":
    - "%RDMS-F-DBRABORTED, database recovery process terminated abnormally"
  - sending process deletion to process 204048E1
  - sending process deletion to process .....



================================================================================
          Bugcheck dump DSA4:[RDBBUGCHECK]RDMDBRBUG.DMP;
================================================================================

This file was generated by Oracle Rdb V7.0-0 upon detection of a
fatal, unexpected, error.  Please return this file, the query or
program that produced the bugcheck, the database, monitor log,
and any other pertinent information to your Oracle support
representative for assistance.

This is a AlphaServer 8400 Model 5/300 running VMS  V6.2    

Current time is 22-JAN-1997 23:44:48.39

27-SEP-1996 17:10:56.05: Linked DBR (RDBVMS) RDMS$ALPHA_V0700_STD:[KODABLD]
26-SEP-1996 12:29:44.03: Compiled KOD$DBR (KODA) KOD$ALPHA_V0700:[DBR]
26-SEP-1996 12:29:33.68: Compiled KOD$LIBRARY (KODA) KOD$ALPHA_V0700:[CODE]

================================================================================
          Stack Dump
================================================================================

R0  (V  ) 000000007EF01038: 00000000001D3828 000000007EF01038 000000007EF01038
R1  (T0 ) 000000007EF01038: 00000000001D3828 000000007EF01038 000000007EF01038
R2  (S0 ) 00000000001D3828: 0000000000000350 000000000018BCE0 0000000003283089
R3  (S1 ) 000000007EF018D0: 0000000000000001 0000001B00129D50 0000041400000003
R4  (S2 ) 0000000000000000
R5  (S3 ) 000000007EF018D0: 0000000000000001 0000001B00129D50 0000041400000003
R6  (S4 ) 00000000001DE324: 454C4946244D4E4C 454C4241545F4D45 54535953244D4E4C
R7  (S5 ) 0000000000213378: 0000000000000001 0000000000000000 0000000100000000
R8  (S6 ) 0000000067754215
R9  (S7 ) 0000000000000001
R10 (S8 ) 0000000005D8F270: 0000000000000000 009AEC46B77FD80F 0000000000000000
R11 (S9 ) 00000000001D4A80: 0000000000002560 0000000000192B50 0000000025203089
R12 (S10) 0000000000213250: 010E0010001DE340 010E0010001DE324 010E00107FFFFBFF
R13 (S11) 0000000067754200
R14 (S12) 0000000005D8F2E0: 434755424244525B 3A34415344203A6B 636568636775423F
R15 (S13) 0000000000000012
R16 (P1 ) 000000007EF01018: 000000000018BDBC 00000000001D3828 0100000000000220
R17 (P2 ) 000000007EF00FE0: 7642037776420377 7642037776420377 7642037776420377
R18 (P3 ) 000000007EF00F20: 00000000001D3828 000000007EF01038 000000007EF01038
R19 (P4 ) 0000000000000000
R20 (P5 ) 000000007EF01010: 00000000001D3828 0100000000000220 7642037776420377
R21 (P6 ) 000000007EF00F20: 00000000001D3828 000000007EF01038 000000007EF01038
R22 (T1 ) 0000000000000000
R23 (T2 ) 00000000001B7220: 0000000000000000 0000000000000000 0000000000000000
R24 (T3 ) 00000000001F2010: 434154535F534D56 5F4148504C415F50 4D55442444545318
R25 (AI ) 0000000000000001
R26 (RA ) FFFFFFFF8087450C: B263000023030018 D35FFE0D26DF0100 A2030108227F0220
R27 (PV ) 000000007F012378: FFFFFFFFCD088EB0 FFFFFFFF80876A8C 0000001A00003008
R28 (VS ) 2A23211D0000004B
R29 (FP ) 000000007EF00F10: 000000007EF01038 FFFFFFFF00000000 00000000001D3828
R30 (SP ) 000000007EF00F10: 000000007EF01038 FFFFFFFF00000000 00000000001D3828

Saved PC = 0018BDBC : STD$DUMP_ALPHA_VMS_STACK + 000000DC

Saved PC = 00169FFC : KOD$BUGCHECK_DUMP + 00000D9C
R2  (S0 ) 00000000001C8538: 0000000000000420 0000000000169260 00000000037030D9
R3  (S1 ) 000000007EF01260: 00000000001C8538 0000000000000000 7EF018D000000002
R4  (S2 ) 0000000000000001
R29 (FP ) 000000007EF01270: 0000000000000000 7EF012787EF01278 00000000001C8538
R30 (SP ) 000000007EF01260: 00000000001C8538 0000000000000000 7EF018D000000002

Saved PC = 000A9488 : KOD$BUGCHECK_AND_EXIT_HNDLR + 000000A8
R2  (S0 ) 00000000001C8120: 0000000000000040 00000000000A93E0 0000000000183089
R3  (S1 ) 000000007EF018D4: 0000041400000000 000000010000001B 00129D5000000414
R4  (S2 ) 0000000000000002
R5  (S3 ) 0000000000000001
R6  (S4 ) 0000000000000001
R7  (S5 ) 0000000000000001
R8  (S6 ) 0000000000213378: 0000000000000001 0000000000000000 0000000100000000
R9  (S7 ) 0000000000000058
R10 (S8 ) 0000000000000000
R11 (S9 ) 0000000005E78EB0: 0200000000000000 0000000000000013 3C01C8B5056EA060
R12 (S10) 0000000005E78CCC: 0000000000000000 FFFFFFFF56005735 056E80D100000006
R13 (S11) 0000000000000003
R14 (S12) 0000000000000002
R29 (FP ) 000000007EF01690: 000000000000001B 000000007EF018D0 00000000001C8120
R30 (SP ) 000000007EF01690: 000000000000001B 000000007EF018D0 00000000001C8120

Saved PC = 80895D44 : symbol not found
R2  (S0 ) 00000000001D0548: 00000000000000F0 0000000000129190 00000000007030D9
R3  (S1 ) 0000000005E78EB0: 0200000000000000 0000000000000013 3C01C8B5056EA060
R29 (FP ) 000000007EF016D0: 00000000001D0548 FFFFFFFFCD2902BC 000000007F079460
R30 (SP ) 000000007EF016D0: 00000000001D0548 FFFFFFFFCD2902BC 000000007F079460

Saved PC = CD2902BC : symbol not found
R29 (FP ) 000000007EF01700: FFFFFFFFCD28E5CC 0000000000000000 FFFFFFFFCD088DA8
R30 (SP ) 000000007EF016F0: FFFFFFFFCD088DA8 00000000001D0548 FFFFFFFFCD088DA8

***** Exception at 00129D50 : PIOFETCH$WITHIN_POOL_GB + 00000BC0
%COSI-F-BUGCHECK, internal consistency failure
R0  (V  ) 0000000005E78EB0: 0200000000000000 0000000000000013 3C01C8B5056EA060
R1  (T0 ) 0000000000000002
R2  (S0 ) 00000000001D0548: 00000000000000F0 0000000000129190 00000000007030D9
R3  (S1 ) 0000000005E78EB0: 0200000000000000 0000000000000013 3C01C8B5056EA060
R4  (S2 ) 0000000000000002
R5  (S3 ) 0000000000000001
R6  (S4 ) 0000000000000001
R7  (S5 ) 0000000000000001
R8  (S6 ) 0000000000213378: 0000000000000001 0000000000000000 0000000100000000
R9  (S7 ) 0000000000000058
R10 (S8 ) 0000000000000000
R11 (S9 ) 0000000005E78EB0: 0200000000000000 0000000000000013 3C01C8B5056EA060
R12 (S10) 0000000005E78CCC: 0000000000000000 FFFFFFFF56005735 056E80D100000006
R13 (S11) 0000000000000003
R14 (S12) 0000000000000002
R15 (S13) 0000000000000012
R16 (P1 ) 0000000000000050
R17 (P2 ) 0000000000000001
R18 (P3 ) 0000000000000002
R19 (P4 ) 0000000000000013
R20 (P5 ) 0000000000000000
R21 (P6 ) 0000000000000000
R22 (T1 ) 0000000000000001
R23 (T2 ) 0000000000000001
R24 (T3 ) 0000000005E78EB0: 0200000000000000 0000000000000013 3C01C8B5056EA060
R25 (AI ) 000000000533C6F0: 0200000000000000 0000000000000000 2100DBB7056E80D1
R26 (RA ) 0000000000000000
R27 (PV ) 0000000005D3DFF0: 000002CE00003DFC 0000000000000142 0000056300000000
R28 (VS ) 000000000012992C: 48A3B73047FF041F C3E00017F8A00002 A4BD006047FF0400
R29 (FP ) 000000007EF01940: 0000000000000000 00000000001D04F8 00000000001D0548
R30 (SP ) 000000007EF01940: 0000000000000000 00000000001D04F8 00000000001D0548

Saved PC = 001266E4 : PIOFETCH$WITHIN_POOL + 00000114
R2  (S0 ) 00000000001D05E0: 00000000000000E0 00000000001265D0 00000000005830D9
R3  (S1 ) 000000007EF01D98: 0000000000000001 00010001EAC30000 0000000000000004
R4  (S2 ) 0000000005E78EB0: 0200000000000000 0000000000000013 3C01C8B5056EA060
R5  (S3 ) 00000000001FE120: 006C000000680000 005C000000600030 FFFFFFFFFFFFFFFF
R6  (S4 ) 0000000000213378: 0000000000000001 0000000000000000 0000000100000000
R7  (S5 ) 0000000005E8FEB8: 4144554B5D42445F 4144554B5B3A3233 42445F4144554B20
R8  (S6 ) 0000000005E78C78: 05E78C8805E78C88 05E785C8002134E0 002134C805E60010
R9  (S7 ) 0000000005E78CCC: 0000000000000000 FFFFFFFF56005735 056E80D100000006
R10 (S8 ) 0000000005E78EB0: 0200000000000000 0000000000000013 3C01C8B5056EA060
R12 (S10) 00000000002132F4: 0049600000497F80 002132FC002132FC 000020003FFFFFFF
R13 (S11) 0000000000213378: 0000000000000001 0000000000000000 0000000100000000
R14 (S12) 0000000005E78EB0: 0200000000000000 0000000000000013 3C01C8B5056EA060
R15 (S13) 0000000000000001
R29 (FP ) 000000007EF01A30: 0000000000000000 00000000001D04F8 00000000001D05E0
R30 (SP ) 000000007EF01A30: 0000000000000000 00000000001D04F8 00000000001D05E0

Saved PC = 00122540 : PIO$FETCH_UPD + 000003C0
R2  (S0 ) 00000000001D07F8: 00000000000000E0 0000000000122180 0000000000583089
R3  (S1 ) 0000000000000088
R4  (S2 ) 0000000000000088
R5  (S3 ) 0000000000000001
R6  (S4 ) 0000000005E78EB0: 0200000000000000 0000000000000013 3C01C8B5056EA060
R7  (S5 ) 00000000001FE120: 006C000000680000 005C000000600030 FFFFFFFFFFFFFFFF
R8  (S6 ) 000000007EF01DA0: 000000000003C164 0000000000000001 00010001EAC30000
R9  (S7 ) 0000000000213378: 0000000000000001 0000000000000000 0000000100000000
R10 (S8 ) 0000000000000000
R11 (S9 ) 00000000002132F0: 00497F80002132FC 002132FC00002000 3FFFFFFF3FFFFFFF
R29 (FP ) 000000007EF01B30: 000000007EF01D98 0000000000000088 00000000001D07F8
R30 (SP ) 000000007EF01B10: 00000000001CE580 0000000005E78EB0 000000007EF01B20

Saved PC = 0012059C : PIO$FETCH + 0000044C
R2  (S0 ) 00000000001D0898: 00000000000000B0 0000000000120150 0000000000283089
R3  (S1 ) 0000000000000000
R5  (S3 ) 000000007EF01DA0: 000000000003C164 0000000000000001 00010001EAC30000
R6  (S4 ) 0000000000000080
R7  (S5 ) 0000000000000052
R8  (S6 ) 0000000000010001: 2847E03416B75E00 20422007A1B77E00 0047E0940023DEFF
R9  (S7 ) 0000000000000000
R11 (S9 ) 000000007EF01D98: 0000000000000001 00010001EAC30000 0000000000000004
R12 (S10) 0000000000000000
R29 (FP ) 000000007EF01C20: 00000000FFFFFFFF 0000000005E78C78 00000000001D0898
R30 (SP ) 000000007EF01C10: 00000000001D0898 0000000000000000 0000000000213378

Saved PC = 00120DE0 : PIO$FETCH + 00000C90
R4  (S2 ) 0000000000000000
R6  (S4 ) 0000000005E78C78: 05E78C8805E78C88 05E785C8002134E0 002134C805E60010
R7  (S5 ) 0000000005E78EB0: 0200000000000000 0000000000000013 3C01C8B5056EA060
R14 (S12) 0000000000000001
R15 (S13) 0000000005D8F268: 009AEC46B77FD80F 0000000000000000 FFFFE018FFFFE018
R29 (FP ) 000000007EF01CE0: 00000000001D3C00 0000040000000000 00000000001D0898
R30 (SP ) 000000007EF01CD0: 00000000001D0898 FFFFFFFF001D8E00 FFFFFFFF8008C9DC

Saved PC = 000429B0 : DBR$REFETCH_TPL + 00000250
R2  (S0 ) 00000000001C0778: 0000000000000090 0000000000042760 0000000000203089
R3  (S1 ) 0000000000213378: 0000000000000001 0000000000000000 0000000100000000
R4  (S2 ) 0000000000002EDF
R5  (S3 ) 00000000000016F0
R6  (S4 ) 0000000000000570
R7  (S5 ) 0000000004B70C00: 0005780000000002 0027A26000FEE228 FB94740000000570
R8  (S6 ) 000000000533C530: 0200000000000000 0000000000000000 3003C311056E80D1
R9  (S7 ) 0000000000000570
R10 (S8 ) 0000000000000001
R11 (S9 ) 000000000533C6F0: 0200000000000000 0000000000000000 2100DBB7056E80D1
R12 (S10) 0000000000000001
R13 (S11) FFFFFFFFCD2CD1B0: 0000000000000040 FFFFFFFFCD2BDB20 0000000000183099
R14 (S12) 00000000001C1388: 0000000000001770 0000000000033D20 00000000170030D9
R15 (S13) 00000000009AEC46: 0000000000000000 0000000000000000 0000000000000000
R29 (FP ) 000000007EF01D90: 00010001EAC30000 0000000000000004 00000000001C0778
R30 (SP ) 000000007EF01D90: 00010001EAC30000 0000000000000004 00000000001C0778

Saved PC = 0003C164 : DBR$RECOVER + 000016F4
R2  (S0 ) 00000000001C0C80: 00000000000004F0 000000000003AA70 00000000048830D9
R4  (S2 ) 0000000005E8C700: 05E8C62005E8C620 05E8C62005E8C620 05E8C62000000040
R5  (S3 ) 0000000000217DA0: 05DE4200004B0800 0000000000000000 00217DA000217DA0
R6  (S4 ) 0000000000000000
R7  (S5 ) 000000000000000B
R8  (S6 ) 0000000000000000
R9  (S7 ) 0000000005D8F268: 009AEC46B77FD80F 0000000000000000 FFFFE018FFFFE018
R10 (S8 ) 0000000000000000
R11 (S9 ) 000000000000000C
R12 (S10) 0000000000509800: FFFFFFFF00000004 0011000105F30001 0000000120401E4E
R29 (FP ) 000000007EF01E50: 0000000000000000 7EF01E587EF01E58 00000000001C0C80
R30 (SP ) 000000007EF01E20: 0000000000000000 0000000000000000 0000000000000000

Saved PC = 00034EBC : DBR + 0000119C
R2  (S0 ) 00000000001C1388: 0000000000001770 0000000000033D20 00000000170030D9
R3  (S1 ) 00000000001F59E0: 54535953244D4E4C 000047554245445F 52424424444F4B0D
R4  (S2 ) 0000000000000011
R5  (S3 ) 0000000000000001
R6  (S4 ) 0000000005F30001
R7  (S5 ) 0000000000213378: 0000000000000001 0000000000000000 0000000100000000
R8  (S6 ) 0000000000213354: 0049E0000049A000 0000000000000000 002132FC002132FC
R9  (S7 ) 0000000000000080
R10 (S8 ) 0000000020401E4E
R11 (S9 ) 0000000005F30000
R29 (FP ) 000000007EF02350: 0000000000000000 0000000000000000 00000000001C1388
R30 (SP ) 000000007EF02340: 00000000001C1388 0000000000000000 00000000004AE600

Saved PC = 000207F4 : BLI$CALLG + 000000BC
R2  (S0 ) 000000007FFBF880: 0000000000000000 00000000001C0000 0000000000000030
R3  (S1 ) 000000007FFBF944: 0000002A00000000 0000000000000020 00000000001C0046
R4  (S2 ) FFFFFFFF86DE5FC0
R5  (S3 ) 000000007FF46000: 000000C8000000C5 000000BE00000000 FFFFFFFFFFFFFFFF
R6  (S4 ) FFFFFFFFCCC3BC80
R7  (S5 ) 0000000000001000
R8  (S6 ) 0000000000000000
R9  (S7 ) FFFFFFFFCD2CD2C8: 0000000000000080 FFFFFFFFCD2BDDD0 0000000000203089
R10 (S8 ) 000000007FFBF800: 4553595300000000 0000000000000000 7FFBF9447FFBF818
R11 (S9 ) 000000007FF181A2: 8050000000000040 00507FF189880000 0000313030303030
R12 (S10) 0000000000000000
R29 (FP ) 000000007EF03AC0: 0000000000000000 0000000000033D00 00000000001D9510
R30 (SP ) 000000007EF03AC0: 0000000000000000 0000000000033D00 00000000001D9510

Saved PC = 00033D00 : DBR$MAIN + 00000120
R14 (S12) 0000000000000000
R29 (FP ) 000000007EF03B00: 0000000000000000 000000007EF03B50 00000000001C0000
R30 (SP ) 000000007EF03AE0: 000000287FFBF944 7FFBF818CD2CD230 7FFBF88800000006

Saved PC = CD2BDC44 : symbol not found
R29 (FP ) 000000007EF03BA0: 0000000000000000 00000000CD2CD2C8 FFFFFFFFCD2CD1B0
R30 (SP ) 000000007EF03B80: 000000287FFBF944 7FFBF818CD2CD230 7FFBF88886DE5FC0


        ------------------------------------------------
          Entire KODA section omitted.
          See definition of RDM$BUGCHECK_IGNORE_FLAGS.
        ------------------------------------------------


================================================================================
          End of Bugcheck Dump
================================================================================
T.RTitleUserPersonal
Name		DateLines
4971.1ORAREP::HERON::VIGIERPhilippe\Rdb EngineeringTue Jan 28 1997 10:505
    From source code :
    You're dumping because page has been transfered from one process to
    another and lock value block is invalid.
    lock value block is the culprid ...
    \Philippe.
4971.2CHSR36::JSUBRIFocus on Open/Rdb++Wed Jan 29 1997 05:353
    RE:1 thanks to the reply, Bug/feature Rdb or VMS ?
    
    /Jean-Luc
4971.3NOVA::R_ANDERSONOracle Corporation (603) 881-1935Wed Jan 29 1997 07:219
Hard to say.  

The problem is that we rely on the lock value block being correct during a "page
transfer".  An invalid lock value block probably means the transferring process
died during the transferral operation...

File an Rdb bug...

Rick
4971.4CHSR36::JSUBRIFocus on Open/Rdb++Wed Jan 29 1997 07:4610
    RE:.3
    
    > File an Rdb bug...
    
    The customer use RDM$BUGCHECK_IGNORE_FLAGS to avoid Giga bytes per
    dump, is the bugcheck in .0 sufficient ?
    This problem was mentionned in 4815.0 closeness to pioutl$do_iorb, in
    my case the piofetch$within_pool_gb was alone .
    
/Jean-Luc
4971.5NOVA::R_ANDERSONOracle Corporation (603) 881-1935Wed Jan 29 1997 09:538
The problem is determining what caused the "transferring" process to die, and to
determine what happened to the lock value block (DBR should have rebuilt it), so
I think that bugcheck dump should be sufficient for this bug (the page contents
are not really important).  

I *think* the PIB_ENT is still dumped even though the page buffer is not...

Rick
4971.6bug#445312CHSR36::JSUBRIFocus on Open/Rdb++Wed Jan 29 1997 10:084
    Bugdb 445312 Priority 3
    
    Thanks and best regards
    /Jean-Luc
4971.7Another oneCHSR36::LCONSThu Jan 30 1997 03:275
I've the same bug on another customer site who is also working with the transfer
via memory.
If you need more informations from this bug, please ask me.

Louis
4971.8probably anotherUKVMS3::SHISCOCKstand and deliverTue Feb 04 1997 05:007
     
    I have customer with this exception piofetch$within_pool_gb + f94 
    different offset but on vax. Again with transfer enabled. So I
    guess I've joined the queue?
    
    
    Steve
4971.9ORAREP::HERON::VIGIERPhilippe\Rdb EngineeringTue Feb 04 1997 08:165
    Welcome in the gang Steve :-)
    Now to be much more basic, does one of you in the queue get a
    reproducer on which we could really work ? Obviously this question is
    just in case this cause some real trouble to your customer :-)
    \Philippe.
4971.10CHSR36::LCONSTue Feb 04 1997 09:376
The only trouble is that these customers cannot use Page Transfer via Memory...
In Switzerland, the two biggest customers using Rdb7 have this problem.
I'll check if i can have a way to reproduce the bug. Also, they meet this error
many times.

Louis
4971.11status anyoneukvms3.uk.oracle.com::SHISCOCKstand and deliverTue Mar 11 1997 10:008
    
    Was this ever bugged? Did anyone provide a reproducible case? 
    
    Any bug number?
    
    
    cheers,
    Steve
4971.12ukvms3.uk.oracle.com::PJACKSONOracle UK Rdb SupportTue Mar 11 1997 10:145
    re .11
    
    See .6
    
    Peter
4971.13ukvms3.uk.oracle.com::SHISCOCKstand and deliverTue Mar 11 1997 10:327
    
    Oopps missed that. 
    
    From the bug I see no reproducible case or any further developments.
    Will see what I can do.
    
    ta,
4971.14always...CHSR36::LCONSWed Mar 12 1997 05:134
A ct met this bug yesterday (rdb7.0, vms7.1)
I've asked him to try again with pre-ECO1 and i'll keep you inform.

Louis