problem

On saving a segment the meta data cache is also updated. Due a missing DB index when changing segment addressing by TRANSLATE-3303 from transunitId to transunitHash on each segment save all segments of a task were searched through two times.

This was leading to a very long running operation finishing worker which was doing a save per each segment.

solution

Optimize segment meta table index.