{"action":"created","issue":{"url":"https://api.github.com/repos/lando/lando/issues/908","repository_url":"https://api.github.com/repos/lando/lando","labels_url":"https://api.github.com/repos/lando/lando/issues/908/labels{/name}","comments_url":"https://api.github.com/repos/lando/lando/issues/908/comments","events_url":"https://api.github.com/repos/lando/lando/issues/908/events","html_url":"https://github.com/lando/lando/issues/908","id":316416561,"number":908,"title":"Docker mysql:latest has updated to 8.x and crashes database containers.","user":{"login":"sk33lz","id":376006,"avatar_url":"https://avatars2.githubusercontent.com/u/376006?v=4","gravatar_id":"","url":"https://api.github.com/users/sk33lz","html_url":"https://github.com/sk33lz","followers_url":"https://api.github.com/users/sk33lz/followers","following_url":"https://api.github.com/users/sk33lz/following{/other_user}","gists_url":"https://api.github.com/users/sk33lz/gists{/gist_id}","starred_url":"https://api.github.com/users/sk33lz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sk33lz/subscriptions","organizations_url":"https://api.github.com/users/sk33lz/orgs","repos_url":"https://api.github.com/users/sk33lz/repos","events_url":"https://api.github.com/users/sk33lz/events{/privacy}","received_events_url":"https://api.github.com/users/sk33lz/received_events","type":"User","site_admin":false},"labels":[{"id":909736337,"url":"https://api.github.com/repos/lando/lando/labels/mysqlgeddon","name":"mysqlgeddon","color":"dd7799","default":false},{"id":884999792,"url":"https://api.github.com/repos/lando/lando/labels/upstream%20bug","name":"upstream bug","color":"d4c5f9","default":false}],"state":"open","locked":false,"assignee":{"login":"dustinleblanc","id":3948808,"avatar_url":"https://avatars3.githubusercontent.com/u/3948808?v=4","gravatar_id":"","url":"https://api.github.com/users/dustinleblanc","html_url":"https://github.com/dustinleblanc","followers_url":"https://api.github.com/users/dustinleblanc/followers","following_url":"https://api.github.com/users/dustinleblanc/following{/other_user}","gists_url":"https://api.github.com/users/dustinleblanc/gists{/gist_id}","starred_url":"https://api.github.com/users/dustinleblanc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dustinleblanc/subscriptions","organizations_url":"https://api.github.com/users/dustinleblanc/orgs","repos_url":"https://api.github.com/users/dustinleblanc/repos","events_url":"https://api.github.com/users/dustinleblanc/events{/privacy}","received_events_url":"https://api.github.com/users/dustinleblanc/received_events","type":"User","site_admin":false},"assignees":[{"login":"dustinleblanc","id":3948808,"avatar_url":"https://avatars3.githubusercontent.com/u/3948808?v=4","gravatar_id":"","url":"https://api.github.com/users/dustinleblanc","html_url":"https://github.com/dustinleblanc","followers_url":"https://api.github.com/users/dustinleblanc/followers","following_url":"https://api.github.com/users/dustinleblanc/following{/other_user}","gists_url":"https://api.github.com/users/dustinleblanc/gists{/gist_id}","starred_url":"https://api.github.com/users/dustinleblanc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dustinleblanc/subscriptions","organizations_url":"https://api.github.com/users/dustinleblanc/orgs","repos_url":"https://api.github.com/users/dustinleblanc/repos","events_url":"https://api.github.com/users/dustinleblanc/events{/privacy}","received_events_url":"https://api.github.com/users/dustinleblanc/received_events","type":"User","site_admin":false}],"milestone":null,"comments":11,"created_at":"2018-04-20T21:25:52Z","updated_at":"2018-04-26T16:39:13Z","closed_at":null,"author_association":"NONE","body":"Bug Report\r\n==========\r\n# Setup\r\nOS: Mac 10.13.4\r\nDocker: 18.03.0-ce-mac60\r\nLando: v3.0.0-beta.40\r\n\r\n# Problem\r\nRunning `lando start` on a new project ends up in a loop waiting for the database service to start. Running `lando destroy` and `lando rebuild` does not resolve the issue.\r\n\r\nRebuilding an existing Lando app on a previous version Lando (v3.0.0-beta.39) or installing Lando v3.0.0-beta.40 causes the mysql:latest docker tag to install MySQL 8.x. This causes lando mysql containers to fail to start with a repeating loop of the following message:\r\n\r\n`Waiting until database service is ready...`\r\n\r\nI did a `docker ps -a` to figure out what the container ID was for the mysql database container and ran `docker start $CONTAINERID -a` to see what the issue was. I ended up with a bunch of errors during the mysqld startup process at the docker-entrypoint.sh step.\r\n\r\n```\r\nRunning command docker-entrypoint.sh mysqld\r\n2018-04-20T19:56:07.344153Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.\r\n2018-04-20T19:56:07.344245Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.\r\n2018-04-20T19:56:07.344359Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.11) starting as process 103\r\nReading package lists...mbind: Operation not permitted\r\nmbind: Operation not permitted\r\nmysqld: Table 'mysql.plugin' doesn't exist...\r\n```\r\n\r\nThe error continues on until mysqld shuts itself down.\r\n\r\nI noticed in the output that `mysql Ver 8.0.11` was installed. It turns out that the docker:latest tag was updated yesterday from 5.x to 8.x. See https://github.com/docker-library/mysql/commit/ff627942605ce08a32fa527993337df0e9856760.\r\n\r\n# Workaround\r\nI was able to workaround this issue for now by adding database service with `mysql:5.7` defined.\r\n\r\n```\r\nservices:\r\n  database:\r\n    type: mysql:5.7\r\n```\r\n\r\n# Proposed Solution\r\nI feel that given the `mysql:latest` docker tag can change at any time, perhaps Lando should pin a specific mysql version as the default mysql version based on the current Debian release, or something clever so that the mysql version can't change behind the scenes."},"comment":{"url":"https://api.github.com/repos/lando/lando/issues/comments/384708538","html_url":"https://github.com/lando/lando/issues/908#issuecomment-384708538","issue_url":"https://api.github.com/repos/lando/lando/issues/908","id":384708538,"user":{"login":"jacine","id":60979,"avatar_url":"https://avatars2.githubusercontent.com/u/60979?v=4","gravatar_id":"","url":"https://api.github.com/users/jacine","html_url":"https://github.com/jacine","followers_url":"https://api.github.com/users/jacine/followers","following_url":"https://api.github.com/users/jacine/following{/other_user}","gists_url":"https://api.github.com/users/jacine/gists{/gist_id}","starred_url":"https://api.github.com/users/jacine/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jacine/subscriptions","organizations_url":"https://api.github.com/users/jacine/orgs","repos_url":"https://api.github.com/users/jacine/repos","events_url":"https://api.github.com/users/jacine/events{/privacy}","received_events_url":"https://api.github.com/users/jacine/received_events","type":"User","site_admin":false},"created_at":"2018-04-26T16:39:13Z","updated_at":"2018-04-26T16:39:13Z","author_association":"NONE","body":"Is there a workaround for the Pantheon recipe?  None of the above has worked for me. Thanks!"}}
{"actor":{"display_login":"jacine"}}