{"action":"created","issue":{"url":"https://api.github.com/repos/codership/mysql-wsrep/issues/337","repository_url":"https://api.github.com/repos/codership/mysql-wsrep","labels_url":"https://api.github.com/repos/codership/mysql-wsrep/issues/337/labels{/name}","comments_url":"https://api.github.com/repos/codership/mysql-wsrep/issues/337/comments","events_url":"https://api.github.com/repos/codership/mysql-wsrep/issues/337/events","html_url":"https://github.com/codership/mysql-wsrep/issues/337","id":340472729,"node_id":"MDU6SXNzdWUzNDA0NzI3Mjk=","number":337,"title":"This filter will cause sst failed at applying undo log when set mysql variable 'innodb_undo_tablespaces' larger than 0.","user":{"login":"bhcblc683","id":16534321,"node_id":"MDQ6VXNlcjE2NTM0MzIx","avatar_url":"https://avatars1.githubusercontent.com/u/16534321?v=4","gravatar_id":"","url":"https://api.github.com/users/bhcblc683","html_url":"https://github.com/bhcblc683","followers_url":"https://api.github.com/users/bhcblc683/followers","following_url":"https://api.github.com/users/bhcblc683/following{/other_user}","gists_url":"https://api.github.com/users/bhcblc683/gists{/gist_id}","starred_url":"https://api.github.com/users/bhcblc683/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bhcblc683/subscriptions","organizations_url":"https://api.github.com/users/bhcblc683/orgs","repos_url":"https://api.github.com/users/bhcblc683/repos","events_url":"https://api.github.com/users/bhcblc683/events{/privacy}","received_events_url":"https://api.github.com/users/bhcblc683/received_events","type":"User","site_admin":false},"labels":[{"id":780972910,"node_id":"MDU6TGFiZWw3ODA5NzI5MTA=","url":"https://api.github.com/repos/codership/mysql-wsrep/labels/5.6-v25","name":"5.6-v25","color":"f9d0c4","default":false}],"state":"open","locked":false,"assignee":{"login":"vasild","id":266751,"node_id":"MDQ6VXNlcjI2Njc1MQ==","avatar_url":"https://avatars2.githubusercontent.com/u/266751?v=4","gravatar_id":"","url":"https://api.github.com/users/vasild","html_url":"https://github.com/vasild","followers_url":"https://api.github.com/users/vasild/followers","following_url":"https://api.github.com/users/vasild/following{/other_user}","gists_url":"https://api.github.com/users/vasild/gists{/gist_id}","starred_url":"https://api.github.com/users/vasild/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vasild/subscriptions","organizations_url":"https://api.github.com/users/vasild/orgs","repos_url":"https://api.github.com/users/vasild/repos","events_url":"https://api.github.com/users/vasild/events{/privacy}","received_events_url":"https://api.github.com/users/vasild/received_events","type":"User","site_admin":false},"assignees":[{"login":"vasild","id":266751,"node_id":"MDQ6VXNlcjI2Njc1MQ==","avatar_url":"https://avatars2.githubusercontent.com/u/266751?v=4","gravatar_id":"","url":"https://api.github.com/users/vasild","html_url":"https://github.com/vasild","followers_url":"https://api.github.com/users/vasild/followers","following_url":"https://api.github.com/users/vasild/following{/other_user}","gists_url":"https://api.github.com/users/vasild/gists{/gist_id}","starred_url":"https://api.github.com/users/vasild/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vasild/subscriptions","organizations_url":"https://api.github.com/users/vasild/orgs","repos_url":"https://api.github.com/users/vasild/repos","events_url":"https://api.github.com/users/vasild/events{/privacy}","received_events_url":"https://api.github.com/users/vasild/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2018-07-12T03:03:10Z","updated_at":"2018-07-17T09:44:36Z","closed_at":null,"author_association":"NONE","body":"https://github.com/codership/mysql-wsrep/blob/a7118c24e778bca79f861b0ac4c7486a102256ef/scripts/wsrep_sst_rsync.sh#L111\r\n\r\nWhen set variable 'innodb_undo_tablespaces' larger than 0 in mysql, mysql will use independent undo log table space rather then system table space. But this file filter rule excludes independent undo table space and will cause sst failed and error log will look like this:\r\n\r\n```[ERROR] InnoDB: Trying to access page number 29510 in space 1, space name innodb_undo001, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server.```\r\n\r\nThe reason that cause this error is that when doing sst with this file filter rule, donor that set  'innodb_undo_tablespaces' larger than 0 doesn't sync its independent undo table space  to the its joiner and the joiner applies  incorrect undo log tablespace when trying to start.\r\n\r\nIt is easy to fix this bug, add `-f '+ undo *'`  in the file filter rule."},"comment":{"url":"https://api.github.com/repos/codership/mysql-wsrep/issues/comments/405524222","html_url":"https://github.com/codership/mysql-wsrep/issues/337#issuecomment-405524222","issue_url":"https://api.github.com/repos/codership/mysql-wsrep/issues/337","id":405524222,"node_id":"MDEyOklzc3VlQ29tbWVudDQwNTUyNDIyMg==","user":{"login":"vasild","id":266751,"node_id":"MDQ6VXNlcjI2Njc1MQ==","avatar_url":"https://avatars2.githubusercontent.com/u/266751?v=4","gravatar_id":"","url":"https://api.github.com/users/vasild","html_url":"https://github.com/vasild","followers_url":"https://api.github.com/users/vasild/followers","following_url":"https://api.github.com/users/vasild/following{/other_user}","gists_url":"https://api.github.com/users/vasild/gists{/gist_id}","starred_url":"https://api.github.com/users/vasild/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vasild/subscriptions","organizations_url":"https://api.github.com/users/vasild/orgs","repos_url":"https://api.github.com/users/vasild/repos","events_url":"https://api.github.com/users/vasild/events{/privacy}","received_events_url":"https://api.github.com/users/vasild/received_events","type":"User","site_admin":false},"created_at":"2018-07-17T09:44:36Z","updated_at":"2018-07-17T09:44:36Z","author_association":"CONTRIBUTOR","body":"@bhcblc683 fixed in:\r\n\r\n```\r\ncommit a0b056aecbe\r\nAuthor:     Vasil Dimov <vasil.dimov@galeracluster.com>\r\nAuthorDate: Mon Jul 16 09:42:53 2018 +0200\r\nCommit:     Vasil Dimov <vasil.dimov@galeracluster.com>\r\nCommitDate: Mon Jul 16 11:04:03 2018 +0200\r\n\r\n\r\n    Also include InnoDB undo tablespaces in rsync sst\r\n\r\n    If --innodb-undo-tablespaces is used, then InnoDB stores undo in a\r\n    separate file(s) which whould also be replicated.\r\n\r\n    This fixes\r\n    Issue#337 This filter will cause sst failed at applying undo...\r\n    https://github.com/codership/mysql-wsrep/issues/337\r\n```\r\n\r\nand will be part of the next release.\r\n\r\nThank you!"}}
{"actor":{"display_login":"vasild"}}