|
CBIT
|
|||
---|---|---|---|
#18+
Доброе утро. AIX 7.1 DB2 10.5.8 назрел такой вопрос. что могло вызвать данную ошибку? MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error" DIA8426C A invalid page checksum was found for page "". на пустом месте ни с чего побилась таблица. в диаге следующее: EDUID : 9768 EDUNAME: db2pfchr () 0 FUNCTION: DB2 UDB, buffer pool services, sqlb_verify_page, probe:5129 MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error" DIA8426C A invalid page checksum was found for page "". DATA #1 : String, 27 bytes CheckSum verification error DATA #2 : String, 50 bytes CheckSum values from the page header on disk are : DATA #3 : unsigned integer, 4 bytes 2401638709 DATA #4 : unsigned integer, 4 bytes 3890703214 DATA #5 : String, 68 bytes CheckSum values calculated from the page, following the read, are : DATA #6 : unsigned integer, 4 bytes 3689478264 DATA #7 : unsigned integer, 4 bytes 2604225711 EDUID : 9768 EDUNAME: db2pfchr () 0 FUNCTION: DB2 UDB, buffer pool services, sqlb_verify_page, probe:0 MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error" DIA8426C A invalid page checksum was found for page "". DATA #1 : String, 64 bytes Error encountered trying to read a page - information follows : DATA #2 : String, 23 bytes Page verification error DATA #3 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes 290399 DATA #4 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 104 bytes Obj: {pool:42;obj:1729;type:0} Parent={42;1729} lifeLSN: 00000000019937B2 tid: 0 0 0 extentAnchor: 118248 initEmpPages: 0 poolPage0: 0 poolflags: 0x 3122 objectState: 0x 80027 lastSMP: 0 pageSize: 16384 extentSize: 2 bufferPoolID: 1 partialHash: 113311786 objDescAttributes: 0 objDescEHLState: 0x0a000200337d7228 bufferPool: 0x0a00020006909be0 pdef: 0x0a0002002a3bea40 DATA #5 : Bitmask, 4 bytes 0x00000002 DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes pageHead: {tbspSeed:42;obj:1729;type:0} bphPPNum:290399 bphOPNum:146345 begoff: 48 datlen: 16336 revnum: 1280 pagelsn: 0000000013E7977B flag: 2a future32: 0 cbits1to31: dbe8f878 cbits32to63: 9b3954af DATA #7 : Bufferpool globals, PD_TYPE_SQLB_GLOBALS, 1248 bytes dbcb: 0x0780000003420080 bpcb: 0x0a000200011e50a0 ptbl: 0x0a000200011e5460 eduType: SQLB_EDU_PREFETCHER eduCB: 0x0a0002002a5ccc20 qryData: 0x0000000000000000 qryDataSz: 0 qryDataPos: 0 contQryData: 0x0000000000000000 contQryDataSz: 0 contQryDataPos: 0 bglobals_flags: 1000000 eduId: 9768 curPfQ: 60 curRemHateListCounter: 831822 debugInfo: 0x0000000000000000 pCurRecLsn: 0x0000000000000000 clnrCB: 0x0000000000000000 prefetchPriority: 0 agentPriorityWeight: 00 staticStr: numPFRequestsHeld: 1 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] 0x0900000021B203AC sqlbLogReadAttemptFailure__FUiP16SQLB_OBJECT_DESCT1P9SQLB_PAGEibUlT1PcP12SQLB_GLOBALS + 0x1E0 [1] 0x09000000222BE900 sqlb_verify_page__FP9SQLB_PAGEP16SQLB_OBJECT_DESCUiT3P12SQLB_GLOBALSPUl + 0x4F0 [2] 0x090000002228B554 sqlb_verify_page__FP9SQLB_PAGEP16SQLB_OBJECT_DESCUiT3P12SQLB_GLOBALSPUl + 0x2A8 [3] 0x090000002228AF40 sqlbReadAndReleaseBuffers__FP16SQLB_OBJECT_DESCUiUlN23P11SQLB_pfMisc + 0x2E8 [4] 0x0900000022866364 sqlbServiceListRequest__FP11SQLB_pfMiscP16SQLB_OBJECT_DESCPUiUi + 0x598 [5] 0x0900000022866C84 sqlbPFPrefetcherEntryPoint__FP16sqbPrefetcherEdu + 0x27C [6] 0x0900000022865078 RunEDU__16sqbPrefetcherEduFv + 0x30 [7] 0x0900000021D48618 EDUDriver__9sqzEDUObjFv + 0x424 [8] 0x0900000021A04FB8 sqloEDUEntry + 0x394 [9] 0x090000000057FFE8 _pthread_body + 0xE8 [10] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF 2017-12-27-14.15.58.838846+180 E12983040A892 LEVEL: Critical EDUID : 9768 EDUNAME: db2pfchr () 0 FUNCTION: DB2 UDB, buffer pool services, sqlbLogReadAttemptFailure, probe:10 MESSAGE : ADM14001C An unexpected and critical error has occurred: "BadPage". The instance may have been shutdown as a result. "Automatic" FODC (First Occurrence Data Capture) has been invoked and diagnostic information has been recorded in directory "/db2/LHP/db2dump/FODC_BadPage_2017-12-27-14.15.58.835794_0000/". Please look in this directory for detailed evidence about what happened and contact IBM support if necessary to diagnose the problem. Спасибо. ... |
|||
:
Нравится:
Не нравится:
|
|||
09.01.2018, 09:48 |
|
CBIT
|
|||
---|---|---|---|
#18+
Amiri, Добрый день. Такие ошибки DB2 связаны как правило с ошибками на системном уровне. Поищите в errpt -a ошибки, связанные с вводом/выводом. ... |
|||
:
Нравится:
Не нравится:
|
|||
09.01.2018, 10:37 |
|
|
start [/forum/topic.php?fid=43&fpage=8&tid=1600365]: |
0ms |
get settings: |
10ms |
get forum list: |
14ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
49ms |
get topic data: |
12ms |
get forum data: |
3ms |
get page messages: |
42ms |
get tp. blocked users: |
1ms |
others: | 335ms |
total: | 474ms |
0 / 0 |