myshoes icon indicating copy to clipboard operation
myshoes copied to clipboard

Published 20 hours ago • verified publisher icon whywaita

Delete LOCK from MySQL

Open whywaita opened this issue 3 years ago • 1 comments

myshoes check the status of LOCK in MySQL during starting. https://github.com/whywaita/myshoes/blob/a0c7eabcfcdca2b1e392eea5bba9c5b95eed42a1/cmd/server/cmd.go#L78

But this implementation has a bug. A deadlock occurred in some environments like Kubernetes (from high-frequency restart).

whywaita avatar Jun 22 '22 01:06 whywaita

Proposal:

  • Add new column owner to job
    • myshoes will update CONNECTION_ID() in MySQL.

whywaita avatar Jun 22 '22 01:06 whywaita