Problem with mysql database | table REPOSITORY_JOURNAL


I am trying to follow the following manual:

I have problems with the deletion when executing the DELETE statement, it is taking a long time to delete only one REVISION_ID, why?

Thank you

Perhaps some other running repository node is trying to update it at the same time?

no, only that process is running

REPOSITORY_JOURNAL table is usually big. And the where clause with NOT LIKE will probably make it slow, too.