{"action":"created","issue":{"url":"https://api.github.com/repos/codership/galera/issues/295","labels_url":"https://api.github.com/repos/codership/galera/issues/295/labels{/name}","comments_url":"https://api.github.com/repos/codership/galera/issues/295/comments","events_url":"https://api.github.com/repos/codership/galera/issues/295/events","html_url":"https://github.com/codership/galera/issues/295","id":90606758,"number":295,"title":"Insert on duplicate key update error","user":{"login":"AlineaSol","id":6941613,"avatar_url":"https://avatars.githubusercontent.com/u/6941613?v=3","gravatar_id":"","url":"https://api.github.com/users/AlineaSol","html_url":"https://github.com/AlineaSol","followers_url":"https://api.github.com/users/AlineaSol/followers","following_url":"https://api.github.com/users/AlineaSol/following{/other_user}","gists_url":"https://api.github.com/users/AlineaSol/gists{/gist_id}","starred_url":"https://api.github.com/users/AlineaSol/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AlineaSol/subscriptions","organizations_url":"https://api.github.com/users/AlineaSol/orgs","repos_url":"https://api.github.com/users/AlineaSol/repos","events_url":"https://api.github.com/users/AlineaSol/events{/privacy}","received_events_url":"https://api.github.com/users/AlineaSol/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-06-24T08:24:13Z","updated_at":"2015-06-24T11:27:34Z","closed_at":null,"body":"When we execute queries like \r\n>     INSERT into table (col1, col2, col3) values(value1, value2, value3) ON DUPLICATE KEY UPDATE\r\n\r\nAlways  abort and throw the next error message:\r\n>     ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction\r\n\r\nThe only way to execute this kind of query is inside a transaction.\r\n\r\nMoreover, when we execute these queries in MySQL (without Galera WSREP), are processed without problems.\r\n\r\n\r\nOur MySQL Galera cluster has 4 nodes with versions: Server version: 5.5.37-log MySQL Community Server (GPL), wsrep_25.10.r3990"},"comment":{"url":"https://api.github.com/repos/codership/galera/issues/comments/114836513","html_url":"https://github.com/codership/galera/issues/295#issuecomment-114836513","issue_url":"https://api.github.com/repos/codership/galera/issues/295","id":114836513,"user":{"login":"philip-galera","id":8738032,"avatar_url":"https://avatars.githubusercontent.com/u/8738032?v=3","gravatar_id":"","url":"https://api.github.com/users/philip-galera","html_url":"https://github.com/philip-galera","followers_url":"https://api.github.com/users/philip-galera/followers","following_url":"https://api.github.com/users/philip-galera/following{/other_user}","gists_url":"https://api.github.com/users/philip-galera/gists{/gist_id}","starred_url":"https://api.github.com/users/philip-galera/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/philip-galera/subscriptions","organizations_url":"https://api.github.com/users/philip-galera/orgs","repos_url":"https://api.github.com/users/philip-galera/repos","events_url":"https://api.github.com/users/philip-galera/events{/privacy}","received_events_url":"https://api.github.com/users/philip-galera/received_events","type":"User","site_admin":false},"created_at":"2015-06-24T11:27:34Z","updated_at":"2015-06-24T11:27:34Z","body":"Hello,\r\n\r\nThank you for reporting the issue. Can you please try increasing the wsrep_retry_autocommit variable to 3 and see if it increases the percentage of successful queries? This will help us pin-point the source of the problem."}}