SQL Server detected a logical consistency-based IO error

unable to decrypt page due to missing DEK.

公司动态 【2023-04-04 20:48】

DBCC CheckDB检查SQL Server数据库，出现如下错误：

DBCC results for 'AIS20210XXXX'.

消息 8939，级别 16，状态 98，第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -1880844493790052352 (type Unknown), page (58853:-437918235). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -14.

消息 8939，级别 16，状态 98，第 1 行

Service Broker Msg 9675, State 1: Message Types analyzed: 14.

Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.

Service Broker Msg 9667, State 1: Services analyzed: 3.

Service Broker Msg 9668, State 1: Service Queues analyzed: 3.

Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.

Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.

Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.

Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.

CHECKDB found 0 allocation errors and 10 consistency errors not associated with any single object.

DBCC results for 'sys.sysrscols'.

DBCC results for 'sys.sysexttables'.

There are 0 rows in 0 pages for object "sys.sysexttables".

消息 8978，级别 16，状态 1，第 1 行

Table error: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data). Page (1:93751) is missing a reference from previous page (1:370770). Possible chain linkage problem.

消息 8928，级别 16，状态 1，第 1 行

Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data): Page (1:370770) could not be processed. See other errors for details.

消息 8976，级别 16，状态 1，第 1 行

Table error: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data). Page (1:370770) was not seen in the scan although its parent (1:453776) and previous (1:346431) refer to it. Check any previous errors.

DBCC results for 'sys.syscolpars'.

There are 114601 rows in 8209 pages for object "sys.syscolpars".

CHECKDB found 0 allocation errors and 3 consistency errors in table 'sys.syscolpars' (object ID 41).

DBCC results for 'sys.sysxlgns'.

DBCC results for 'CMK_t_HorzScreenTabEntry'.

There are 0 rows in 0 pages for object "CMK_t_HorzScreenTabEntry".

消息 8978，级别 16，状态 1，第 1 行

Table error: Object ID 137923713, index ID 3, partition ID 72057594845921280, alloc unit ID 72057594785890304 (type In-row data). Page (1:1290856) is missing a reference from previous page (1:1290857). Possible chain linkage problem.

消息 8928，级别 16，状态 1，第 1 行

Object ID 137923713, index ID 3, partition ID 72057594845921280, alloc unit ID 72057594785890304 (type In-row data): Page (1:1290857) could not be processed. See other errors for details.

消息 8976，级别 16，状态 1，第 1 行

Table error: Object ID 137923713, index ID 3, partition ID 72057594845921280, alloc unit ID 72057594785890304 (type In-row data). Page (1:1290857) was not seen in the scan although its parent (1:1429268) and previous (1:694320) refer to it. Check any previous errors.

DBCC results for 'T_SUB_PICKMTRLDATA_LK'.

There are 127445 rows in 2817 pages for object "T_SUB_PICKMTRLDATA_LK".

CHECKDB found 0 allocation errors and 3 consistency errors in table 'T_SUB_PICKMTRLDATA_LK' (object ID 137923713).

DBCC results for 'V_HS_OUTACCTG_VH'.

There are 3089 rows in 128 pages for object "T_PLM_CFG_AUTH_INFOR".

消息 8976，级别 16，状态 1，第 1 行

Table error: Object ID 621401433, index ID 1, partition ID 72057594838188032, alloc unit ID 72057594779205632 (type In-row data). Page (1:1290853) was not seen in the scan although its parent (1:739359) and previous (1:1290852) refer to it. Check any previous errors.

消息 8978，级别 16，状态 1，第 1 行

Table error: Object ID 621401433, index ID 1, partition ID 72057594838188032, alloc unit ID 72057594779205632 (type In-row data). Page (1:1290854) is missing a reference from previous page (1:1290853). Possible chain linkage problem.

消息 8928，级别 16，状态 1，第 1 行

Object ID 621401433, index ID 1, partition ID 72057594838188032, alloc unit ID 72057594779205632 (type In-row data): Page (1:1290853) could not be processed. See other errors for details.

DBCC results for 'T_SUB_PICKMTRLDATA'.

There are 127430 rows in 8526 pages for object "T_SUB_PICKMTRLDATA".

CHECKDB found 0 allocation errors and 3 consistency errors in table 'T_SUB_PICKMTRLDATA' (object ID 621401433).

There are 0 rows in 0 pages for object "T_PRD_MASTKSCOPE".

消息 8928，级别 16，状态 1，第 1 行

Object ID 1411445713, index ID 0, partition ID 72057641066364928, alloc unit ID 72057643179180032 (type In-row data): Page (1:110483) could not be processed. See other errors for details.

消息 8928，级别 16，状态 1，第 1 行

Object ID 1411445713, index ID 0, partition ID 72057641066364928, alloc unit ID 72057643179180032 (type In-row data): Page (1:110487) could not be processed. See other errors for details.

消息 8928，级别 16，状态 1，第 1 行

Object ID 1411445713, index ID 0, partition ID 72057641066364928, alloc unit ID 72057643179180032 (type In-row data): Page (1:97727) could not be processed. See other errors for details.

消息 8928，级别 16，状态 1，第 1 行

Object ID 1411445713, index ID 0, partition ID 72057641066364928, alloc unit ID 72057643179180032 (type In-row data): Page (1:97946) could not be processed. See other errors for details.

消息 8928，级别 16，状态 1，第 1 行

Object ID 1411445713, index ID 0, partition ID 72057641066364928, alloc unit ID 72057643179180032 (type In-row data): Page (1:97950) could not be processed. See other errors for details.

消息 8939，级别 16，状态 98，第 1 行

Table error: Object ID 1411445713, index ID 0, partition ID 72057641066364928, alloc unit ID 72057643179180032 (type In-row data), page (1:1104861). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.

消息 8928，级别 16，状态 1，第 1 行

Object ID 1411445713, index ID 0, partition ID 72057641066364928, alloc unit ID 72057643179180032 (type In-row data): Page (1:1104861) could not be processed. See other errors for details.

消息 8939，级别 16，状态 98，第 1 行

Table error: Object ID 1411445713, index ID 0, partition ID 72057641066364928, alloc unit ID 72057643179180032 (type In-row data), page (1:1104869). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.

消息 8928，级别 16，状态 1，第 1 行

Object ID 1411445713, index ID 0, partition ID 72057641066364928, alloc unit ID 72057643179180032 (type In-row data): Page (1:1104869) could not be processed. See other errors for details.

DBCC results for 'TINVAGE263430BD'.

There are 167702 rows in 6537 pages for object "TINVAGE263430BD".

There are 33 rows in 1 pages for object "T_HS_SPLITTABLE".

消息 8976，级别 16，状态 1，第 1 行

Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:177668) was not seen in the scan although its parent (1:170529) and previous (1:177667) refer to it. Check any previous errors.

消息 8978，级别 16，状态 1，第 1 行

Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:177669) is missing a reference from previous page (1:177668). Possible chain linkage problem.

消息 8978，级别 16，状态 1，第 1 行

Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:486803) is missing a reference from previous page (1:988359). Possible chain linkage problem.

消息 8939，级别 16，状态 98，第 1 行

Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data), page (1:177668). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.

消息 8978，级别 16，状态 1，第 1 行

Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:507077) is missing a reference from previous page (1:988363). Possible chain linkage problem.

消息 8928，级别 16，状态 1，第 1 行

Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data): Page (1:177668) could not be processed. See other errors for details.

消息 8978，级别 16，状态 1，第 1 行

Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:171225) is missing a reference from previous page (1:988367). Possible chain linkage problem.

消息 8976，级别 16，状态 1，第 1 行

Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:505728) was not seen in the scan although its parent (1:170529) and previous (1:166862) refer to it. Check any previous errors.

消息 8928，级别 16，状态 1，第 1 行

Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data): Page (1:505728) could not be processed. See other errors for details.

消息 8928，级别 16，状态 1，第 1 行

Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data): Page (1:505732) could not be processed. See other errors for details.

消息 8978，级别 16，状态 1，第 1 行

Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:488068) is missing a reference from previous page (1:988371). Possible chain linkage problem.

消息 8976，级别 16，状态 1，第 1 行

Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:505732) was not seen in the scan although its parent (1:170529) and previous (1:486807) refer to it. Check any previous errors.

消息 8978，级别 16，状态 1，第 1 行

Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:988432) is missing a reference from previous page (1:505732). Possible chain linkage problem.

消息 8976，级别 16，状态 1，第 1 行

Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:988363) was not seen in the scan although its parent (1:170529) and previous (1:507076) refer to it. Check any previous errors.

消息 8978，级别 16，状态 1，第 1 行

Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:988377) is missing a reference from previous page (1:505728). Possible chain linkage problem.

消息 8976，级别 16，状态 1，第 1 行

Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:988371) was not seen in the scan although its parent (1:170529) and previous (1:488067) refer to it. Check any previous errors.

消息 8976，级别 16，状态 1，第 1 行

Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:988367) was not seen in the scan although its parent (1:170529) and previous (1:171224) refer to it. Check any previous errors.

消息 8939，级别 16，状态 98，第 1 行

Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data), page (1:988359). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.

消息 8928，级别 16，状态 1，第 1 行

Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data): Page (1:988359) could not be processed. See other errors for details.

消息 8939，级别 16，状态 98，第 1 行

Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data), page (1:988363). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.

消息 8928，级别 16，状态 1，第 1 行

Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data): Page (1:988363) could not be processed. See other errors for details.

消息 8939，级别 16，状态 98，第 1 行

Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data), page (1:988367). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.

消息 8928，级别 16，状态 1，第 1 行

Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data): Page (1:988367) could not be processed. See other errors for details.

消息 8939，级别 16，状态 98，第 1 行

Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data), page (1:988371). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.

消息 8928，级别 16，状态 1，第 1 行

Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data): Page (1:988371) could not be processed. See other errors for details.

消息 8976，级别 16，状态 1，第 1 行

Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:988359) was not seen in the scan although its parent (1:170529) and previous (1:486802) refer to it. Check any previous errors.

DBCC results for 'TINVAGEBAL263430'.

There are 11122 rows in 349 pages for object "TINVAGEBAL263430".

CHECKDB found 0 allocation errors and 26 consistency errors in table 'TINVAGEBAL263430' (object ID 1443445827).

DBCC results for 'T_BD_MATERIALSALE'.

Table error: Object ID 1764266136, index ID 1, partition ID 72057595120582656, alloc unit ID 72057595037417472 (type LOB data), page (1:813834). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.

消息 8928，级别 16，状态 1，第 1 行

Object ID 1764266136, index ID 1, partition ID 72057595120582656, alloc unit ID 72057595037417472 (type LOB data): Page (1:813834) could not be processed. See other errors for details.

消息 8965，级别 16，状态 1，第 1 行

Table error: Object ID 1764266136, index ID 1, partition ID 72057595120582656, alloc unit ID 72057595037417472 (type LOB data). The off-row data node at page (1:813834), slot 0, text ID 3500345393152 is referenced by page (1:813192), slot 19, but was not seen in the scan.

消息 8965，级别 16，状态 1，第 1 行

Table error: Object ID 1764266136, index ID 1, partition ID 72057595120582656, alloc unit ID 72057595037417472 (type LOB data). The off-row data node at page (1:813834), slot 1, text ID 3504258547712 is referenced by page (1:813833), slot 4, but was not seen in the scan.

消息 8929，级别 16，状态 1，第 1 行

Object ID 1764266136, index ID 1, partition ID 72057595120582656, alloc unit ID 72057595048558592 (type In-row data): Errors found in off-row data with ID 3500345393152 owned by data record identified by RID = (1:946197:63)

消息 8929，级别 16，状态 1，第 1 行

Object ID 1764266136, index ID 1, partition ID 72057595120582656, alloc unit ID 72057595048558592 (type In-row data): Errors found in off-row data with ID 3504258547712 owned by data record identified by RID = (1:946197:87)

DBCC results for 'T_BF_ARCHIVEFILES'.

There are 6882 rows in 50 pages for object "T_BF_ARCHIVEFILES".

CHECKDB found 0 allocation errors and 6 consistency errors in table 'T_BF_ARCHIVEFILES' (object ID 1764266136).

DBCC results for 'T_SUB_PTBILLTYPE'.

There are 0 rows in 0 pages for object "T_SUB_PTBILLTYPE".

消息 8939，级别 16，状态 98，第 1 行

Table error: Object ID 1968166207, index ID 4, partition ID 72057595274395648, alloc unit ID 72057595199946752 (type In-row data), page (1:381467). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.

消息 8928，级别 16，状态 1，第 1 行

Object ID 1968166207, index ID 4, partition ID 72057595274395648, alloc unit ID 72057595199946752 (type In-row data): Page (1:381467) could not be processed. See other errors for details.

消息 8976，级别 16，状态 1，第 1 行

Table error: Object ID 1968166207, index ID 4, partition ID 72057595274395648, alloc unit ID 72057595199946752 (type In-row data). Page (1:381467) was not seen in the scan although its parent (1:589083) and previous (1:703772) refer to it. Check any previous errors.

消息 8976，级别 16，状态 1，第 1 行

Table error: Object ID 1968166207, index ID 1, partition ID 72057595274330112, alloc unit ID 72057595199881216 (type In-row data). Page (1:703797) was not seen in the scan although its parent (1:449579) and previous (1:703796) refer to it. Check any previous errors.

消息 8978，级别 16，状态 1，第 1 行

Table error: Object ID 1968166207, index ID 4, partition ID 72057595274395648, alloc unit ID 72057595199946752 (type In-row data). Page (1:713968) is missing a reference from previous page (1:381467). Possible chain linkage problem.

消息 8939，级别 16，状态 98，第 1 行

Table error: Object ID 1968166207, index ID 1, partition ID 72057595274330112, alloc unit ID 72057595199881216 (type In-row data), page (1:703797). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.

消息 8928，级别 16，状态 1，第 1 行

Object ID 1968166207, index ID 1, partition ID 72057595274330112, alloc unit ID 72057595199881216 (type In-row data): Page (1:703797) could not be processed. See other errors for details.

消息 8978，级别 16，状态 1，第 1 行

Table error: Object ID 1968166207, index ID 1, partition ID 72057595274330112, alloc unit ID 72057595199881216 (type In-row data). Page (1:703798) is missing a reference from previous page (1:703797). Possible chain linkage problem.

DBCC results for 'T_STK_INVENTORYLOG'.

There are 548669 rows in 20079 pages for object "T_STK_INVENTORYLOG".

CHECKDB found 0 allocation errors and 8 consistency errors in table 'T_STK_INVENTORYLOG' (object ID 1968166207).

DBCC results for 'T_ER_REASONSREQUESTENTRY'.

There are 0 rows in 0 pages for object "CMK_LS_EventMarketRecord".

CHECKDB found 0 allocation errors and 68 consistency errors in database 'AIS202106251445741'.

repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (AIS202106251443652).

消息 824，级别 24，状态 2，第 1 行

SQL Server detected a logical consistency-based I/O error: unable to decrypt page due to missing DEK. It occurred during a read of page (1:370770) in database ID 10 at offset 0x000000b50a4000 in file 'E:\20230404\2023.04.04-bad-dbOK\AIS202106253652_Data.mdf_MSSQL_DBCC10'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

消息 824，级别 24，状态 2，第 1 行

SQL Server detected a logical consistency-based I/O error: unable to decrypt page due to missing DEK. It occurred during a read of page (1:370770) in database ID 10 at offset 0x000000b50a4000 in file 'E:\20230404\2023.04.04-bad-dbOK\AIS20210625144134_Data.mdf_MSSQL_DBCC10'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

消息 824，级别 24，状态 2，第 1 行

SQL Server detected a logical consistency-based I/O error: unable to decrypt page due to missing DEK. It occurred during a read of page (1:370770) in database ID 10 at offset 0x000000b50a4000 in file 'E:\20230404\2023.04.04-bad-dbOK\AIS20210625144134_Data.mdf_MSSQL_DBCC10'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

消息 824，级别 24，状态 2，第 1 行

SQL Server detected a logical consistency-based I/O error: unable to decrypt page due to missing DEK. It occurred during a read of page (1:370770) in database ID 10 at offset 0x000000b50a4000 in file 'E:\20230404\2023.04.04-bad-dbOK\AIS20210625144134_Data.mdf_MSSQL_DBCC10'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

消息 824，级别 24，状态 2，第 1 行

SQL Server detected a logical consistency-based I/O error: unable to decrypt page due to missing DEK. It occurred during a read of page (1:370770) in database ID 10 at offset 0x000000b50a4000 in file 'E:\20230404\2023.04.04-bad-dbOK\AIS20210625144134_Data.mdf_MSSQL_DBCC10'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

消息 824，级别 24，状态 2，第 1 行

SQL Server detected a logical consistency-based I/O error: unable to decrypt page due to missing DEK. It occurred during a read of page (1:370770) in database ID 10 at offset 0x000000b50a4000 in file 'E:\20230404\2023.04.04-bad-dbOK\AIS20210625144134_Data.mdf_MSSQL_DBCC10'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

执行Transact-SQL 语句或批处理时发生了异常。(Microsoft.SQLServer,Connectionlnfo)

SQL Server 检测到基于一致性的逻辑 I/O 错误由于缺少 DEK，无法解密页。

在文件F:\20230404\A1S202106251XXXXX_Data,mdf' 中偏移量为 0x000000650a4000 的位置

对数据库ID7 中的页(1:370770) 执行读取期间，发生了该错误。

SQL Server 错误日志或系统事件日志中的其他消息可能提供了更详细信息。

这是一个威助数据库完整性的严重错误条件，必须立即纠正。

请执行完整的数据库一致性检查(DBCC CHECKDB)。此错误可以许多因素导致 ;

有关详细信息，请参阅 SQL Server联机以书。(Microsof SQL Server，错误: 824)