02-02-2024, 11:02 AM
This is the blocking warning:
FATAL webservice Lock wait timeout exceeded; try restarting transaction
we have to understand which query is blocking and why. This will appear in MySQL, it is a MySQL issue. there is an overlap of two or more queries accessing the same table for modifications. There are some MySQL commands to see those blocking queries but I don't remember exactly which ones they are right now and on cell phone.
It may very well be the session, but we have to ask MySQL to be sure.
I'll give more information when I have better access but that is the first thing I would look into
FATAL webservice Lock wait timeout exceeded; try restarting transaction
we have to understand which query is blocking and why. This will appear in MySQL, it is a MySQL issue. there is an overlap of two or more queries accessing the same table for modifications. There are some MySQL commands to see those blocking queries but I don't remember exactly which ones they are right now and on cell phone.
It may very well be the session, but we have to ask MySQL to be sure.
I'll give more information when I have better access but that is the first thing I would look into
Joe
TSolucio
TSolucio