What is a deadlock and what conditions cause deadlock? A deadlock is a state in which each member of a group is waiting for another member. An example of deadlock is the dining philosophers problem. Each philosopher will pick up the left fork and wait for the right fork to become available, but it never does. This week, I encountered mysql deadlock when running multiple “INSERT… ON DUPLICATE KEY U