Index partially cleared when running "EPiServer Find Content Indexing Job" and you get SQL exception/timeout

Found in

EPiServer.Find 12.5.0

Fixed in

EPiServer.Find 12.5.3

Created

May 31 2017

Updated

Aug 28 2017

Area

Indexing Job

State

Closed, Fixed and tested


Description

Steps to reproduce

1. Make sure the index contains data.
2. Run the "EPiServer Find Content Indexing Job".
3. Trigger a timeout on the database for one of the queries that belongs to the indexing job. (Can happen on exceptions as well).

Expected:
Job should stop or warn that there's been a timeout while indexing, and that some data might not have been updated.

Actual:
Part of the index is cleared.

Note:
Problem was observed in two cases. In one, this happened due to timeouts. The other case was due to an exception where a SHUTDOWN was in progress.