{"action":"created","issue":{"url":"https://api.github.com/repos/datacharmer/mysql-sandbox/issues/33","repository_url":"https://api.github.com/repos/datacharmer/mysql-sandbox","labels_url":"https://api.github.com/repos/datacharmer/mysql-sandbox/issues/33/labels{/name}","comments_url":"https://api.github.com/repos/datacharmer/mysql-sandbox/issues/33/comments","events_url":"https://api.github.com/repos/datacharmer/mysql-sandbox/issues/33/events","html_url":"https://github.com/datacharmer/mysql-sandbox/issues/33","id":215957652,"number":33,"title":"Failed make_replication_sandbox creation with -> [ERROR] /home/shahriyar.rzaev/percona-server/5.7.17/bin/mysqld: Can't find file: '/tmp/#sqlc05_c_0.frm' (errno: 13 - Permission denied)","user":{"login":"ShahriyarR","id":3852029,"avatar_url":"https://avatars1.githubusercontent.com/u/3852029?v=3","gravatar_id":"","url":"https://api.github.com/users/ShahriyarR","html_url":"https://github.com/ShahriyarR","followers_url":"https://api.github.com/users/ShahriyarR/followers","following_url":"https://api.github.com/users/ShahriyarR/following{/other_user}","gists_url":"https://api.github.com/users/ShahriyarR/gists{/gist_id}","starred_url":"https://api.github.com/users/ShahriyarR/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ShahriyarR/subscriptions","organizations_url":"https://api.github.com/users/ShahriyarR/orgs","repos_url":"https://api.github.com/users/ShahriyarR/repos","events_url":"https://api.github.com/users/ShahriyarR/events{/privacy}","received_events_url":"https://api.github.com/users/ShahriyarR/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2017-03-22T05:33:06Z","updated_at":"2017-03-22T06:29:09Z","closed_at":null,"body":"It seems to be the `make_replication_sandbox` failing if there are temporary files from another mysql run inside `/tmp`.\r\n\r\nAny idea how to avoid this? :\r\n\r\n```\r\n$ make_replication_sandbox percona-server-5.7.17-11-linux-x86_64.tar.gz\r\ninstalling and starting master\r\nerror while creating grant tables\r\n2017-03-21T14:58:57.543129Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)\r\n2017-03-21T14:58:57.543196Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)\r\n2017-03-21T14:58:57.543372Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).\r\n2017-03-21T14:59:03.121654Z 0 [Warning] InnoDB: New log files created, LSN=45790\r\n2017-03-21T14:59:04.780440Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.\r\n2017-03-21T14:59:05.645718Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: edb208fd-0e46-11e7-bfac-002590e9b448.\r\n2017-03-21T14:59:06.010342Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.\r\n2017-03-21T14:59:06.297322Z 0 [Warning] CA certificate ca.pem is self signed.\r\n2017-03-21T14:59:06.400261Z 0 [ERROR] /home/shahriyar.rzaev/percona-server/5.7.17/bin/mysqld: Can't find file: '/tmp/#sqlc05_c_0.frm' (errno: 13 - Permission denied)\r\n2017-03-21T14:59:06.400292Z 0 [ERROR] /home/shahriyar.rzaev/percona-server/5.7.17/bin/mysqld: Can't find file: '/tmp/#sqlc2d_a_f.frm' (errno: 13 - Permission denied)\r\n2017-03-21T14:59:06.400302Z 0 [ERROR] /home/shahriyar.rzaev/percona-server/5.7.17/bin/mysqld: Can't find file: '/tmp/#sqlc58_a_7.frm' (errno: 13 - Permission denied)\r\n2017-03-21T14:59:06.400315Z 0 [ERROR] /home/shahriyar.rzaev/percona-server/5.7.17/bin/mysqld: Can't find file: '/tmp/#sqlc58_a_9.frm' (errno: 13 - Permission denied)\r\n2017-03-21T14:59:06.400325Z 0 [ERROR] /home/shahriyar.rzaev/percona-server/5.7.17/bin/mysqld: Can't find file: '/tmp/#sqlc05_c_5.frm' (errno: 13 - Permission denied)\r\n2017-03-21T14:59:06.400334Z 0 [ERROR] /home/shahriyar.rzaev/percona-server/5.7.17/bin/mysqld: Can't find file: '/tmp/#sqlc2d_a_0.frm' (errno: 13 - Permission denied)\r\n2017-03-21T14:59:06.400344Z 0 [ERROR] /home/shahriyar.rzaev/percona-server/5.7.17/bin/mysqld: Can't find file: '/tmp/#sqlc58_a_2.frm' (errno: 13 - Permission denied)\r\n2017-03-21T14:59:06.400363Z 0 [ERROR] /home/shahriyar.rzaev/percona-server/5.7.17/bin/mysqld: Can't find file: '/tmp/#sqlc05_c_7.frm' (errno: 13 - Permission denied)\r\n2017-03-21T14:59:06.400381Z 0 [ERROR] /home/shahriyar.rzaev/percona-server/5.7.17/bin/mysqld: Can't find file: '/tmp/#sqlc05_c_1.frm' (errno: 13 - Permission denied)\r\n2017-03-21T14:59:06.400391Z 0 [ERROR] /home/shahriyar.rzaev/percona-server/5.7.17/bin/mysqld: Can't find file: '/tmp/#sqlc58_a_3.frm' (errno: 13 - Permission denied)\r\n2017-03-21T14:59:06.400401Z 0 [ERROR] /home/shahriyar.rzaev/percona-server/5.7.17/bin/mysqld: Can't find file: '/tmp/#sqlc2d_a_3.frm' (errno: 13 - Permission denied)\r\n2017-03-21T14:59:06.400410Z 0 [ERROR] /home/shahriyar.rzaev/percona-server/5.7.17/bin/mysqld: Can't find file: '/tmp/#sqlc58_a_b.frm' (errno: 13 - Permission denied)\r\n2017-03-21T14:59:06.400420Z 0 [ERROR] /home/shahriyar.rzaev/percona-server/5.7.17/bin/mysqld: Can't find file: '/tmp/#sqlc58_a_11.frm' (errno: 13 - Permission denied)\r\n2017-03-21T14:59:06.400429Z 0 [ERROR] /home/shahriyar.rzaev/percona-server/5.7.17/bin/mysqld: Can't find file: '/tmp/#sqlc2d_a_5.frm' (errno: 13 - Permission denied)\r\n2017-03-21T14:59:06.400438Z 0 [ERROR] /home/shahriyar.rzaev/percona-server/5.7.17/bin/mysqld: Can't find file: '/tmp/#sqlc58_a_c.frm' (errno: 13 - Permission denied)\r\n2017-03-21T14:59:06.400824Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.\r\n\r\nerror installing the master\r\n\r\n(65280 )\r\n```"},"comment":{"url":"https://api.github.com/repos/datacharmer/mysql-sandbox/issues/comments/288310349","html_url":"https://github.com/datacharmer/mysql-sandbox/issues/33#issuecomment-288310349","issue_url":"https://api.github.com/repos/datacharmer/mysql-sandbox/issues/33","id":288310349,"user":{"login":"ShahriyarR","id":3852029,"avatar_url":"https://avatars1.githubusercontent.com/u/3852029?v=3","gravatar_id":"","url":"https://api.github.com/users/ShahriyarR","html_url":"https://github.com/ShahriyarR","followers_url":"https://api.github.com/users/ShahriyarR/followers","following_url":"https://api.github.com/users/ShahriyarR/following{/other_user}","gists_url":"https://api.github.com/users/ShahriyarR/gists{/gist_id}","starred_url":"https://api.github.com/users/ShahriyarR/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ShahriyarR/subscriptions","organizations_url":"https://api.github.com/users/ShahriyarR/orgs","repos_url":"https://api.github.com/users/ShahriyarR/repos","events_url":"https://api.github.com/users/ShahriyarR/events{/privacy}","received_events_url":"https://api.github.com/users/ShahriyarR/received_events","type":"User","site_admin":false},"created_at":"2017-03-22T06:29:09Z","updated_at":"2017-03-22T06:29:09Z","body":"Trying with sbdebug=1:\r\n\r\n```\r\n[shahriyar.rzaev@qaserver-02 MySQL_Servers]$ export SBDEBUG=1\r\n[shahriyar.rzaev@qaserver-02 MySQL_Servers]$ make_replication_sandbox mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz\r\ninstalling and starting master\r\nerror while creating grant tables\r\n2017-03-22T06:26:55.942459Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)\r\n2017-03-22T06:26:55.942523Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)\r\n2017-03-22T06:26:55.942612Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).\r\n2017-03-22T06:26:59.482015Z 0 [Warning] InnoDB: New log files created, LSN=45790\r\n2017-03-22T06:27:00.437932Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.\r\n2017-03-22T06:27:01.026502Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 8ecef38a-0ec8-11e7-a55f-002590e9b448.\r\n2017-03-22T06:27:01.342647Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.\r\n2017-03-22T06:27:01.342810Z 0 [ERROR] /home/shahriyar.rzaev/MySQL_Servers/5.7.17/bin/mysqld: Can't find file: '/tmp/#sql314e_a_0.frm' (errno: 13 - Permission denied)\r\n2017-03-22T06:27:01.342997Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.\r\n\r\nerror installing the master\r\n\r\n(65280 )\r\n````"}}
{"actor":{"display_login":"ShahriyarR"}}