VMware vCenter Server fails with the error: Attempt to fetch logical page (1:981035) in database 6 failed

Products

• VMware vCenter Server

Issue/Introduction

Symptoms:

• VMware vCenter Server service fails to start.
• In the /Var/Log/vpxd.log file, you see entries similar to:
  
  
  [02412 error 'Default'] [VdbStatement] SQLError was thrown: "ODBC error: (HY000) - [Microsoft][SQL Server Native Client 10.0][SQL Server]Attempt to fetch logical page (1:981035) in database 6 failed. It belongs to allocation unit 72057594149732352 not to 72057594181648384." is returned when executing SQL statement "select MAX(GEN_NUMBER) AS MAX_GEN from VPX_PROPERTY_BULLETIN"
  [02412 error 'vpxdvpxdMain'] [Vpxd::ServerApp::Init] Init failed: "ODBC error: (HY000) - [Microsoft][SQL Server Native Client 10.0][SQL Server]Attempt to fetch logical page (1:981035) in database 6 failed. It belongs to allocation unit 72057594149732352 not to 72057594181648384." is returned when executing SQL statement "select MAX(GEN_NUMBER) AS MAX_GEN from VPX_PROPERTY_BULLETIN"
  --> Backtrace:
  -->
  <YYYY-MM-DD>T<time>.028-04:00 [02412 error 'Default'] Failed to intialize VMware VirtualCenter. Shutting down...
  </time>

Environment

VMware vCenter Server 5.1.x
VMware vCenter Server 5.5.x

Cause

This issue occurs because of an hardware error or when operating system fails causing database to corrupt resulting in the failure of vCenter Server.

Resolution

To resolve this issue, run the dbcc checkdb command on the Microsoft SQL server database to check that the database is corrupt or not and follow the output recommendations to resolve the database corruption.

Note: Engage your local database Administrator or Microsoft, if needed.

If the database is completely corrupted and can not be recovered, you see output similar to:

Msg 7985, Level 16, State 2, Line 1
System table pre-checks: Object ID 3. Could not read and latch page (1:249) with latch type SH. Check statement terminated due to unrepairable error.
DBCC results for 'VIM_VCDB'.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:249) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 1 consistency errors in database 'VIM_VCDB'.
is the minimum repair level for the errors found by DBCC CHECKDB (VIM_VCDB).


In this case, restore the database from the backup. However, all latest changes would be lost.

Additional Information

VMware vCenter Server が次のエラーで停止する： Attempt to fetch logical page (1:981035) in database 6 failed

Impact/Risks:

Database corruption can cause vCenter Server connection to be lost completely.