{"action":"created","issue":{"url":"https://api.github.com/repos/codership/mysql-wsrep/issues/198","labels_url":"https://api.github.com/repos/codership/mysql-wsrep/issues/198/labels{/name}","comments_url":"https://api.github.com/repos/codership/mysql-wsrep/issues/198/comments","events_url":"https://api.github.com/repos/codership/mysql-wsrep/issues/198/events","html_url":"https://github.com/codership/mysql-wsrep/issues/198","id":108114920,"number":198,"title":"Multi-table OPTIMIZE, REPAIR leads to BF-BF conflict, node abort","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},"labels":[{"url":"https://api.github.com/repos/codership/mysql-wsrep/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/codership/mysql-wsrep/labels/lowhanging%20fruit","name":"lowhanging fruit","color":"d4c5f9"},{"url":"https://api.github.com/repos/codership/mysql-wsrep/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/codership/mysql-wsrep/milestones/8","html_url":"https://github.com/codership/mysql-wsrep/milestones/5.6.x-25.12","labels_url":"https://api.github.com/repos/codership/mysql-wsrep/milestones/8/labels","id":1272863,"number":8,"title":"5.6.x-25.12","description":"","creator":{"login":"temeo","id":6009633,"avatar_url":"https://avatars.githubusercontent.com/u/6009633?v=3","gravatar_id":"","url":"https://api.github.com/users/temeo","html_url":"https://github.com/temeo","followers_url":"https://api.github.com/users/temeo/followers","following_url":"https://api.github.com/users/temeo/following{/other_user}","gists_url":"https://api.github.com/users/temeo/gists{/gist_id}","starred_url":"https://api.github.com/users/temeo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/temeo/subscriptions","organizations_url":"https://api.github.com/users/temeo/orgs","repos_url":"https://api.github.com/users/temeo/repos","events_url":"https://api.github.com/users/temeo/events{/privacy}","received_events_url":"https://api.github.com/users/temeo/received_events","type":"User","site_admin":false},"open_issues":5,"closed_issues":1,"state":"open","created_at":"2015-08-26T06:40:51Z","updated_at":"2015-10-09T08:29:36Z","due_on":null,"closed_at":null},"comments":7,"created_at":"2015-09-24T11:47:56Z","updated_at":"2015-10-14T18:53:38Z","closed_at":null,"body":"With multi-table OPTIMIZE TABLE:\r\n\r\n```\r\nSep 23 19:36:13 mysqld: 150923 19:36:13 [Note] WSREP: MDL BF-BF conflict\r\nSep 23 19:36:13 mysqld: request: (3 #011seqno 2188616 #011wsrep (1, 1, 0) cmd 0 45 #011OPTIMIZE TABLE t1,t2,t3)\r\nSep 23 19:36:13 mysqld: granted: (1 #011seqno 2188623 #011wsrep (1, 0, 0) cmd 0 146 #011(null))\r\nSep 23 19:36:13 mysqld: 150923 19:36:13 [ERROR] WSREP: Trx 2188616 tries to abort slave trx 2188623. This could be caused by:\r\n```\r\n\r\nTeemu says:\r\n\r\n```\r\n[13:30:09] Teemu Ollakka: so, optimize is executed in TOI\r\n[13:30:14] Teemu Ollakka: and there is BF-BF conflict\r\n[13:30:36] Teemu Ollakka: which suggests that it does not take all table names as keys\r\n\r\n[13:34:32] Teemu Ollakka:   WSREP_TO_ISOLATION_BEGIN(first_table->db, first_table->table_name, NULL)\r\n[13:34:45] Teemu Ollakka: in Sql_cmd_optimize_table::execute()\r\n[13:34:57] Teemu Ollakka: so full table list is not passed to OPTIMIZE TOI\r\n```"},"comment":{"url":"https://api.github.com/repos/codership/mysql-wsrep/issues/comments/148155439","html_url":"https://github.com/codership/mysql-wsrep/issues/198#issuecomment-148155439","issue_url":"https://api.github.com/repos/codership/mysql-wsrep/issues/198","id":148155439,"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-10-14T18:53:38Z","updated_at":"2015-10-14T18:53:38Z","body":"@mmpower . You will need to disable the Broken Link Checker WordPress plugin until this is fixed. Alternatively you can edit the source of the plugin to not perform multi-table OPTIMIZE TABLEs."}}