problem

Large imports (many target languages, big translation task) leads to:

E9999 TimeOut on waiting for the following materialized view to be filled  

and

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sourceMd5' in 'field list', query was: SELECT v1.id,v1.sourceMd5 

reason

If a match analysis was queued directly with the import, the matchanalysis worker was not added with state scheduled. So the worker was started regardless of the basically configured worker dependencies (to wait for task import worker). The analysis worker then created an empty segment view which was then endlessly checked for filling in the import worker.

solution

Add the match analysis worker with the correct initial state.