top of page

SQL Server detected a logical consistency-based I/O error when VM is running on snapshot

We have SQL Servers getting Errors 823/824 and we found out that there is bug in ESXi 7.x U2

Note: Error Crashes with Data corruption error

To made a workaround we need to disable the Bloom filter

Here is the Steps:

- Login to the ESXi via SSH using root account

- Retrieve the value of config option BFEnabled before disabling it > Run vsish -e get /config/SE/intOpts/BFEnabled

- To disable the Bloom filter > Run esxcli system settings advanced set -i 0 -o /SE/BFEnabled

- Then Run vsish -e get /config/SE/intOpts/BFEnabled to see the changes

- We can see below the value before is 1 and after applying the workaround the value now is 0

- Now vMotion the VM to another ESXi host and back again for the changes to take affect

Note: So far with the cases attached to this bug report, this issue hasn't been reproduced with bloom filters disabled

Comments


bottom of page