Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2016
    Posts
    29

    Unanswered: DB2 diaglog errors after db upgrade to 10.5 fp8 from 9.7

    Hello All,

    I have upgraded db2 form 9.7 to 10.5 recently. after the upgrade all the testing was fine.
    I have noticed below diaglog, But nothing was reported by application team.
    I did not got much information from IBM sites or google related to 10.5 about this error.

    Please let me know any if any of u faced same error. Thanks in advance.

    2017-07-13-08.00.33.675517+120 E56535582A1413 LEVEL: Error (OS)
    PID : 23855170 TID : 15822 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : DEVDB
    APPHDL : 0-23066 APPID: *LOCAL.DB2.170713060047
    AUTHID : DB2ECCAD HOSTNAME: dcpaix21309882
    EDUID : 15822 EDUNAME: db2taskp (DEVDB) 0
    FUNCTION: DB2 UDB, oper system services, sqloReadBlocks, probe:60
    MESSAGE : ZRC=0x800F0003=-2146500605=SQLO_INTRP "Interrupt. User Cancel."
    DIA8003C The interrupt has been received.
    CALLED : OS, -, pread
    OSERR : EINTR (4) "Interrupted system call"
    DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
    File Handle = 60
    File System Block Size = 4096 bytes
    File System Type = nfs
    File Handle Flags :
    Require Sector Align = No
    DIO/CIO Mode = Yes
    Raw Block Device = No
    Reserved Handle = No
    Flush On Close = No
    Thread-Level Lock = No
    Write-through Mode = Yes
    File Not Tracked = Yes
    DATA #2 : unsigned integer, 8 bytes
    31220
    DATA #3 : unsigned integer, 8 bytes
    1
    DATA #4 : unsigned integer, 4 bytes
    12
    DATA #5 : File Offset, 8 bytes
    4096
    DATA #6 : File Offset, 8 bytes
    127877120
    DATA #7 : String, 105 bytes
    Search for ossError*Analysis probe point after this log entry for further
    self-diagnosis of this problem.

    2017-07-13-08.00.33.747930+120 I56536996A2972 LEVEL: Error (OS)
    PID : 23855170 TID : 15822 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : DEVDB
    APPHDL : 0-23066 APPID: *LOCAL.DB2.170713060047
    AUTHID : DB2ECCAD HOSTNAME: dcpaix21309882
    EDUID : 15822 EDUNAME: db2taskp (DEVDB) 0
    FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100
    CALLED : OS, -, pread
    OSERR : EINTR (4) "Interrupted system call"
    DATA #1 : String, 116 bytes
    A total of 3 analysis will be performed :
    - User info
    - Target file info
    - I/O attempt

    Target file handle = 60
    DATA #2 : String, 192 bytes
    Real user ID of current process = 50658
    Effective user ID of current process = 50658
    Real group ID of current process = 50111
    Effective group ID of current process = 50111
    DATA #3 : String, 41 bytes
    current sbrk(0) value: 0x000000011d867a00
    DATA #4 : String, 267 bytes
    Target File Information :
    Size = 1040187392
    Link = No
    Reference path = N/A
    Type = 0x8000
    Permissions = rw-------
    UID = 50658
    GID = 50111
    Last modified time = 1499925349
    DATA #5 : String, 33 bytes
    I/O attempt not implemented yet.
    CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
    [0] 0x090000003473A6CC pdOSSeLoggingCallback + 0x59C
    [1] 0x090000002746B77C oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1BC
    [2] 0x090000002746BBF0 ossLogSysRC + 0x70
    [3] 0x09000000274940BC ossErrorIOAnalysis__FCPC21OSSErrorAnalysisParam + 0xD7C
    [4] 0x0900000035F10328 sqloSystemErrorHandler + 0x518
    [5] 0x09000000347C6824 sqlbReadPageInternal + 0x174
    [6] 0x09000000347C7374 sqlbReadPageInternal + 0xCC4
    [7] 0x09000000347C7374 sqlbReadPageInternal + 0xCC4
    [8] 0x09000000347CFC0C sqlbGetPageFromDisk__FP11SQLB_FIX_CBi + 0x17D4
    [9] 0x09000000347CEB3C sqlbGetPageFromDisk__FP11SQLB_FIX_CBi + 0x704
    [10] 0x090000003487D954 sqlbfix__FP11SQLB_FIX_CB + 0x1FF4
    [11] 0x0900000033EB0CBC @114@sqldFetchNext__FP13SQLD_DFM_WORK + 0x3C0
    [12] 0x0900000034CA09A8 sqldfrd__FP13SQLD_DFM_WORK + 0x1160
    [13] 0x0900000034897FEC sqldRowFetch__FP8sqeAgentP8SQLD_CCBUlT3PP10SQLD_VA LUEP8SQLZ_RIDT3P12SQLD_ID_LISTP9SQLP_LSN8 + 0xA4
    [14] 0x0900000034412AF0 fetch__16sqlrlCatalogScanFv + 0x184
    [15] 0x0900000034782174 anonBlockPurgeTaskProcessor + 0x364
    [16] 0x0900000033B27AE8 sqleIndCoordProcessRequest__FP8sqeAgent + 0x7820
    [17] 0x0900000033B27190 sqleIndCoordProcessRequest__FP8sqeAgent + 0x6EC8
    [18] 0x0000000000000000 ?unknown + 0x0
    [19] 0x0900000033B05F2C sqleIndCoordProcessRequest__FP8sqeAgent + 0xB60
    [20] 0x090000003528A64C RunEDU__8sqeAgentFv + 0x138
    [21] 0x090000003409F9E4 EDUDriver__9sqzEDUObjFv + 0x130
    [22] 0x0900000033D311D4 sqloEDUEntry + 0x3A0
    [23] 0x09000000004C7E10 _pthread_body + 0xF0
    [24] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF

    2017-07-13-08.00.33.819230+120 I56539969A3958 LEVEL: Severe
    PID : 23855170 TID : 15822 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : DEVDB
    APPHDL : 0-23066 APPID: *LOCAL.DB2.170713060047
    AUTHID : DB2ECCAD HOSTNAME: dcpaix21309882
    EDUID : 15822 EDUNAME: db2taskp (DEVDB) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbReadPage, probe:1140
    MESSAGE : ZRC=0x800F0003=-2146500605=SQLO_INTRP "Interrupt. User Cancel."
    DIA8003C The interrupt has been received.
    DATA #1 : String, 64 bytes
    Error encountered trying to read a page - information follows :
    DATA #2 : String, 29 bytes
    Failed to read data from disk
    DATA #3 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes
    31216
    DATA #4 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 104 bytes
    Obj: {pool:0;obj:6;type:0} Parent={0;6}
    lifeLSN: 00000063BB7C3E72
    tid: 0 0 0
    extentAnchor: 216
    initEmpPages: 0
    poolPage0: 0
    poolflags: 0x 3102
    objectState: 0x 80027
    lastSMP: 0
    pageSize: 4096
    extentSize: 4
    bufferPoolID: 1
    partialHash: 393216
    objDescAttributes: 0
    objDescEHLState: 0x0a000b0056aadba8
    bufferPool: 0x0a000b000750bbc0
    pdef: 0x0a000b000921d940
    DATA #5 : Bitmask, 4 bytes
    0x00000002
    DATA #6 : Bufferpool globals, PD_TYPE_SQLB_GLOBALS, 1248 bytes
    dbcb: 0x0780000002d00080
    bpcb: 0x0a000b0001212320
    ptbl: 0x0a000b00012126e0
    eduType: SQLB_EDU_AGENT
    eduCB: 0x078000000364ce00
    qryData: 0x0000000000000000
    qryDataSz: 0
    qryDataPos: 0
    contQryData: 0x0000000000000000
    contQryDataSz: 0
    contQryDataPos: 0
    bglobals_flags: 200
    eduId: 15822
    curPfQ: 3
    curRemHateListCounter: 15839
    debugInfo: 0x0000000000000000
    pCurRecLsn: 0x0000000000000000
    clnrCB: 0x0000000000000000
    prefetchPriority: 1
    agentPriorityWeight: 00
    staticStr:
    numPFRequestsHeld: 0
    memAccessCount:
    m_bIsInitialized: true
    m_iDisabled: 2222
    m_iAccessCount: 0
    CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
    [0] 0x0900000036591D64 sqlbLogReadAttemptFailure__FUiP16SQLB_OBJECT_DESCT 1P9SQLB_PAGEibUlT1PcP12SQLB_GLOBALS + 0x3168
    [1] 0x09000000347BB3F8 sqlbGetPageFromDisk__FP11SQLB_FIX_CBi + 0x78C
    [2] 0x09000000347CEB3C sqlbGetPageFromDisk__FP11SQLB_FIX_CBi + 0x704
    [3] 0x090000003487D954 sqlbfix__FP11SQLB_FIX_CB + 0x1FF4
    [4] 0x0900000033EB0CBC @114@sqldFetchNext__FP13SQLD_DFM_WORK + 0x3C0
    [5] 0x0900000034CA09A8 sqldfrd__FP13SQLD_DFM_WORK + 0x1160
    [6] 0x0900000034897FEC sqldRowFetch__FP8sqeAgentP8SQLD_CCBUlT3PP10SQLD_VA LUEP8SQLZ_RIDT3P12SQLD_ID_LISTP9SQLP_LSN8 + 0xA4
    [7] 0x0900000034412AF0 fetch__16sqlrlCatalogScanFv + 0x184
    [8] 0x0900000034782174 anonBlockPurgeTaskProcessor + 0x364
    [9] 0x0900000033B27AE8 sqleIndCoordProcessRequest__FP8sqeAgent + 0x7820
    [10] 0x0900000033B27190 sqleIndCoordProcessRequest__FP8sqeAgent + 0x6EC8
    [11] 0x0000000000000000 ?unknown + 0x0
    [12] 0x0900000033B05F2C sqleIndCoordProcessRequest__FP8sqeAgent + 0xB60
    [13] 0x090000003528A64C RunEDU__8sqeAgentFv + 0x138
    [14] 0x090000003409F9E4 EDUDriver__9sqzEDUObjFv + 0x130
    [15] 0x0900000033D311D4 sqloEDUEntry + 0x3A0
    [16] 0x09000000004C7E10 _pthread_body + 0xF0
    [17] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF

    2017-07-13-08.00.35.268423+120 E56555979A1080 LEVEL: Warning
    PID : 23855170 TID : 15822 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : DEVDB
    APPHDL : 0-23066 APPID: *LOCAL.DB2.170713060047
    AUTHID : DB2ECCAD HOSTNAME: dcpaix21309882
    EDUID : 15822 EDUNAME: db2taskp (DEVDB) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbReadPage, probe:1180
    MESSAGE : ADM6000E DB2 encountered a read error while reading page "31216"
    from tablespace "0" for object "6" (located at offset "31220" of
    container
    "/data/dababase_dir/db2/DB2ECCAD/devdb/data1/db2inst1/NODE0000/DEVDB
    /T0000000/C0000000.CAT"). DB2 was able to bypass the error by
    re-reading the page, but this may indicate the presence of a serious
    problem that could result in a future outage. You may wish to begin
    an investigation of the hardware (such as disk, controllers, network)
    and/or the filesystem involved in accessing the container.

  2. #2
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    294
    Provided Answers: 45
    Hello,

    What's the OS, nfs mount options of the file system, where this container resides?
    /data/dababase_dir/db2/DB2ECCAD/devdb/data1/db2inst1/NODE0000/DEVDB/T0000000/C0000000.CAT

    Seems, that you mounted it with the intr option, and db2 gets EINTR sometimes reading this file...
    Regards,
    Mark.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •