Comment 2 for bug 1850786

Revision history for this message
Robert Lyon (robertl-9) wrote :

Hi,
Looking at the line in the error info you posted

 mysqli error: [1305: PROCEDURE u57370db5nd.search_elasticsearch_queue_artefact_trigger does not exist] in EXECUTE("UPDATE "artefact"

It seems like you had a trigger on the 'artefact' table that pointed to a procedure that no longer existed.

In v19.10 we got rid of the elasticsearch triggers / procedures (instead handle things at PHP level).

So it sounds like procedure was removed before trigger during upgrade - and placing the drop_elasticsearch_triggers(); line in the code dropped them correctly

The create_elasticsearch_triggers(); doesn't actually do anything anymore as the ElasticsearchIndexing::create_triggers($type); also just calls drop_triggers()

Those function will be removed in a future release