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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
