You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by GitBox <gi...@apache.org> on 2022/05/26 23:59:23 UTC
[GitHub] [dolphinscheduler] lordk911 commented on issue #10251: [Bug] [api] delete process_definition cause Lock wait timeout exceeded Exception
lordk911 commented on issue #10251:
URL: https://github.com/apache/dolphinscheduler/issues/10251#issuecomment-1139160265
> Hi @lordk911 , please check the performance of MySQL database. I tried to delete the table of 10 million workflow instances without similar problems.
yes, maybe it's not a performance problem. maybe cause by dead lock.
almost the same time other opertion like inser into or update process_instance table also got MySQLTransactionRollbackException
'MySQLTransactionRollbackException: Lock wait timeout exceeded' error keep throw out from 2022-05-25 18:05 to 2022-05-25 20:xx , after that no more process can be run by quartz or manually.
cause it's urgent to recover the ETL jobs, I restarted the dolphinscheduler , and the problem is goneļ¼so I have no time to check what happen in database.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org