{"action":"closed","issue":{"url":"https://api.github.com/repos/Homebrew/homebrew-versions/issues/1404","repository_url":"https://api.github.com/repos/Homebrew/homebrew-versions","labels_url":"https://api.github.com/repos/Homebrew/homebrew-versions/issues/1404/labels{/name}","comments_url":"https://api.github.com/repos/Homebrew/homebrew-versions/issues/1404/comments","events_url":"https://api.github.com/repos/Homebrew/homebrew-versions/issues/1404/events","html_url":"https://github.com/Homebrew/homebrew-versions/issues/1404","id":180304529,"number":1404,"title":"Unable to connect to percona-server","user":{"login":"craigcarnell","id":1188869,"avatar_url":"https://avatars.githubusercontent.com/u/1188869?v=3","gravatar_id":"","url":"https://api.github.com/users/craigcarnell","html_url":"https://github.com/craigcarnell","followers_url":"https://api.github.com/users/craigcarnell/followers","following_url":"https://api.github.com/users/craigcarnell/following{/other_user}","gists_url":"https://api.github.com/users/craigcarnell/gists{/gist_id}","starred_url":"https://api.github.com/users/craigcarnell/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/craigcarnell/subscriptions","organizations_url":"https://api.github.com/users/craigcarnell/orgs","repos_url":"https://api.github.com/users/craigcarnell/repos","events_url":"https://api.github.com/users/craigcarnell/events{/privacy}","received_events_url":"https://api.github.com/users/craigcarnell/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-09-30T13:32:04Z","updated_at":"2016-10-03T07:59:44Z","closed_at":"2016-10-03T07:59:44Z","body":"It was working.. did a brew update/brew upgrade/brew doctor.\r\n\r\nPercona wasn't updated recently.\r\n\r\n/var/log/system.log when running brew services restart percona-server\r\n```\r\nSep 30 14:24:46 Craigs-MacBook-Pro com.apple.xpc.launchd[1] (com.apple.quicklook[14664]): Endpoint has been activated through legacy launch(3) APIs. Please switch to XPC or bootstrap_check_in(): com.apple.quicklook\r\nSep 30 14:26:08 Craigs-MacBook-Pro com.apple.xpc.launchd[1] (com.apple.ReportCrash[15552]): Endpoint has been activated through legacy launch(3) APIs. Please switch to XPC or bootstrap_check_in(): com.apple.ReportCrash\r\nSep 30 14:26:09 Craigs-MacBook-Pro spindump[8829]: Saved memory_resource.diag report for helpd version (null) to /Library/Logs/DiagnosticReports/helpd_2016-09-30-142609_Craigs-MacBook-Pro.memory_resource.diag\r\nSep 30 14:26:30 Craigs-MacBook-Pro com.apple.xpc.launchd[1] (com.apple.quicklook[15561]): Endpoint has been activated through legacy launch(3) APIs. Please switch to XPC or bootstrap_check_in(): com.apple.quicklook\r\nSep 30 14:28:31 Craigs-MacBook-Pro com.apple.xpc.launchd[1] (com.apple.PubSub.Agent[15756]): Endpoint has been activated through legacy launch(3) APIs. Please switch to XPC or bootstrap_check_in(): com.apple.pubsub.ipc\r\nSep 30 14:28:31 Craigs-MacBook-Pro com.apple.xpc.launchd[1] (com.apple.PubSub.Agent[15756]): Endpoint has been activated through legacy launch(3) APIs. Please switch to XPC or bootstrap_check_in(): com.apple.pubsub.notification\r\nSep 30 14:28:59 Craigs-MacBook-Pro syslogd[54]: ASL Sender Statistics\r\nSep 30 14:29:09 Craigs-MacBook-Pro com.apple.xpc.launchd[1] (com.apple.ReportCrash[15768]): Endpoint has been activated through legacy launch(3) APIs. Please switch to XPC or bootstrap_check_in(): com.apple.ReportCrash\r\nSep 30 14:29:42 Craigs-MacBook-Pro com.apple.xpc.launchd[1] (com.apple.quicklook[15790]): Endpoint has been activated through legacy launch(3) APIs. Please switch to XPC or bootstrap_check_in(): com.apple.quicklook\r\nSep 30 14:29:43 Craigs-MacBook-Pro login[15793]: USER_PROCESS: 15793 ttys000\r\nSep 30 14:31:34 Craigs-MacBook-Pro com.apple.xpc.launchd[1] (homebrew.mxcl.percona-server[405]): Service did not exit 5 seconds after SIGTERM. Sending SIGKILL.\r\nSep 30 14:31:34 Craigs-MacBook-Pro com.apple.xpc.launchd[1] (homebrew.mxcl.percona-server): This service is defined to be constantly running and is inherently inefficient.\r\n```\r\n\r\nps aux | grep percona\r\n```\r\nccarnell        16930   0.0  0.8  2778232 128624   ??  U     2:34pm   0:00.22 /usr/local/Cellar/percona-server/5.7.14-7/bin/mysqld --basedir=/usr/local/Cellar/percona-server/5.7.14-7 --datadir=/usr/local/var/mysql --plugin-dir=/usr/local/Cellar/percona-server/5.7.14-7/lib/mysql/plugin --log-error=/usr/local/var/mysql/Craigs-MacBook-Pro.local.err --pid-file=/usr/local/var/mysql/Craigs-MacBook-Pro.local.pid\r\nccarnell        16802   0.0  0.0  2452852   2536   ??  S     2:34pm   0:00.03 /bin/sh /usr/local/opt/percona-server/bin/mysqld_safe\r\n```\r\n\r\nmysql\r\n```\r\nERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)\r\n```\r\n\r\n/etc/my.cnf\r\n```\r\n# For advice on how to change settings please see\r\n# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html\r\n# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the\r\n# *** default location during install, and will be replaced if you\r\n# *** upgrade to a newer version of MySQL.\r\n\r\n[mysqld]\r\nmax_allowed_packet=512M # default is 4194304\r\nconnect_timeout=60 # default 10\r\ninnodb_file_per_table = OFF\r\ntable_open_cache = 250\r\n\r\n# Remove leading # and set to the amount of RAM for the most important data\r\n# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.\r\n# innodb_buffer_pool_size = 128M\r\n\r\n# Remove leading # to turn on a very important data integrity option: logging\r\n# changes to the binary log between backups.\r\n# log_bin\r\n\r\n# These are commonly set, remove the # and set as required.\r\n# basedir = .....\r\n# datadir = .....\r\n# port = .....\r\n# server_id = .....\r\n# socket = .....\r\n\r\n# Remove leading # to set options mainly useful for reporting servers.\r\n# The server defaults are faster for transactions and fast SELECTs.\r\n# Adjust sizes as needed, experiment to find the optimal values.\r\n# join_buffer_size = 128M\r\n# sort_buffer_size = 2M\r\n# read_rnd_buffer_size = 2M \r\n\r\nsql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES\r\n```\r\n\r\nUsing sequel Pro:\r\n```\r\nMySQL said: Can't connect to MySQL server on '127.0.0.1' (61)\r\n```"}}
{"actor":{"display_login":"craigcarnell"}}