エラー内容
h2tomo:potepanec meotomohiro$ bundle exec rails s -p 3001
WARNING: Nokogiri was built against LibXML version 2.9.7, but has dynamically loaded 2.9.4
=> Booting Puma
=> Rails 5.1.4 application starting in development
=> Run `rails server -h` for more startup options
Exiting
/Users/tomohiro/work/ec/vendor/bundle/ruby/2.4.0/gems/mysql2-0.4.9/lib/mysql2/client.rb:89:in `connect': Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38) (Mysql2::Error)
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/mysql2-0.4.9/lib/mysql2/client.rb:89:in `initialize'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/mysql2_adapter.rb:21:in `new'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/mysql2_adapter.rb:21:in `mysql2_connection'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:759:in `new_connection'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:803:in `checkout_new_connection'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:782:in `try_to_checkout_new_connection'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:743:in `acquire_connection'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:500:in `checkout'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:374:in `connection'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:931:in `retrieve_connection'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_handling.rb:116:in `retrieve_connection'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_handling.rb:88:in `connection'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.4/lib/active_record/model_schema.rb:331:in `table_exists?'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/solidus_core-2.3.0/app/models/spree/preferences/store.rb:82:in `should_persist?'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/solidus_core-2.3.0/app/models/spree/preferences/store.rb:31:in `get'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/solidus_core-2.3.0/app/models/spree/preferences/scoped_store.rb:13:in `fetch'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/solidus_core-2.3.0/app/models/spree/preferences/preferable_class_methods.rb:26:in `block in preference'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/solidus_auth_devise-1.6.4/config/routes.rb:4:in `block in <top (required)>'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/routing/mapper.rb:629:in `instance_exec'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/routing/mapper.rb:629:in `block in with_default_scope'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/routing/mapper.rb:866:in `scope'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/routing/mapper.rb:628:in `with_default_scope'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/routing/route_set.rb:424:in `eval_block'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/routing/route_set.rb:408:in `draw'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/solidus_auth_devise-1.6.4/config/routes.rb:1:in `<top (required)>'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:286:in `load'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:286:in `block in load'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:258:in `load_dependency'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:286:in `load'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/application/routes_reloader.rb:55:in `block in load_paths'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/application/routes_reloader.rb:55:in `each'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/application/routes_reloader.rb:55:in `load_paths'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/application/routes_reloader.rb:18:in `reload!'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/application/routes_reloader.rb:41:in `block in updater'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.4/lib/active_support/file_update_checker.rb:81:in `execute'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/application/routes_reloader.rb:42:in `updater'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/application/routes_reloader.rb:31:in `execute_if_updated'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/application/finisher.rb:128:in `block in <module:Finisher>'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/initializable.rb:30:in `instance_exec'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/initializable.rb:30:in `run'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/initializable.rb:59:in `block in run_initializers'
from /Users/meotomohiro/.rbenv/versions/2.4.1/lib/ruby/2.4.0/tsort.rb:228:in `block in tsort_each'
from /Users/meotomohiro/.rbenv/versions/2.4.1/lib/ruby/2.4.0/tsort.rb:350:in `block (2 levels) in each_strongly_connected_component'
from /Users/meotomohiro/.rbenv/versions/2.4.1/lib/ruby/2.4.0/tsort.rb:431:in `each_strongly_connected_component_from'
from /Users/meotomohiro/.rbenv/versions/2.4.1/lib/ruby/2.4.0/tsort.rb:349:in `block in each_strongly_connected_component'
from /Users/meotomohiro/.rbenv/versions/2.4.1/lib/ruby/2.4.0/tsort.rb:347:in `each'
from /Users/meotomohiro/.rbenv/versions/2.4.1/lib/ruby/2.4.0/tsort.rb:347:in `call'
from /Users/meotomohiro/.rbenv/versions/2.4.1/lib/ruby/2.4.0/tsort.rb:347:in `each_strongly_connected_component'
from /Users/meotomohiro/.rbenv/versions/2.4.1/lib/ruby/2.4.0/tsort.rb:226:in `tsort_each'
from /Users/meotomohiro/.rbenv/versions/2.4.1/lib/ruby/2.4.0/tsort.rb:205:in `tsort_each'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/initializable.rb:58:in `run_initializers'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/application.rb:353:in `initialize!'
from /Users/meotomohiro/work/potepanec/config/environment.rb:5:in `<top (required)>'
from config.ru:3:in `require_relative'
from config.ru:3:in `block in <main>'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/builder.rb:55:in `instance_eval'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/builder.rb:55:in `initialize'
from config.ru:in `new'
from config.ru:in `<main>'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/builder.rb:49:in `eval'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/builder.rb:49:in `new_from_string'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/builder.rb:40:in `parse_file'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/server.rb:319:in `build_app_and_options_from_config'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/server.rb:219:in `app'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/commands/server/server_command.rb:24:in `app'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/server.rb:354:in `wrapped_app'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/commands/server/server_command.rb:80:in `log_to_stdout'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/commands/server/server_command.rb:42:in `start'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/commands/server/server_command.rb:135:in `block in perform'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/commands/server/server_command.rb:130:in `tap'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/commands/server/server_command.rb:130:in `perform'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/thor-0.20.0/lib/thor/command.rb:27:in `run'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/thor-0.20.0/lib/thor/invocation.rb:126:in `invoke_command'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/thor-0.20.0/lib/thor.rb:387:in `dispatch'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/command/base.rb:63:in `perform'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/command.rb:44:in `invoke'
from /Users/meotomohiro/work/potepanec/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/commands.rb:16:in `<top (required)>'
from bin/rails:4:in `require'
from bin/rails:4:in `<main>'
h2tomo:potepanec meotomohiro$ sudo mysql.server restart ERROR! MySQL server PID file could not be found! Starting MySQL .. ERROR! The server quit without updating PID file (/usr/local/var/mysql/h2tomo.pid).
解決策
起動していたmysqlのプロセスを削除する
h2tomo:var tomohiro$ ps ax | grep mysql
534 ?? S 0:00.06 /bin/sh /usr/local/opt/mysql/bin/mysqld_safe --bind-address=127.0.0.1 --datadir=/usr/local/var/mysql
689 ?? S 1:11.38 /usr/local/Cellar/mysql/5.7.17/bin/mysqld --basedir=/usr/local/Cellar/mysql/5.7.17 --datadir=/usr/local/var/mysql --plugin-dir=/usr/local/Cellar/mysql/5.7.17/lib/plugin --bind-address=127.0.0.1 --log-error=/usr/local/var/mysql/h2tomo.local.err --pid-file=/usr/local/var/mysql/h2tomo.local.pid
89650 ?? S 0:00.04 /bin/sh /usr/local/opt/mysql@5.7/bin/mysqld_safe --datadir=/usr/local/var/mysql
89737 ?? S 0:00.29 /usr/local/opt/mysql@5.7/bin/mysqld --basedir=/usr/local/opt/mysql@5.7 --datadir=/usr/local/var/mysql --plugin-dir=/usr/local/opt/mysql@5.7/lib/plugin --log-error=h2tomo.err --pid-file=h2tomo.pid
89750 s001 S+ 0:00.00 grep mysql
h2tomo:var meotomohiro$ kill -9 534
h2tomo:var meotomohiro$ kill -9 689
-bash: kill: (689) - No such process
h2tomo:var meotomohiro$ kill -9 89650
-bash: kill: (89650) - No such process
h2tomo:var meotomohiro$ kill -9 89737
-bash: kill: (89737) - No such process
h2tomo:var meotomohiro$ ps ax | grep mysql
89768 ?? S 0:00.04 /bin/sh /usr/local/opt/mysql@5.7/bin/mysqld_safe --datadir=/usr/local/var/mysql
89855 ?? S 0:00.31 /usr/local/opt/mysql@5.7/bin/mysqld --basedir=/usr/local/opt/mysql@5.7 --datadir=/usr/local/var/mysql --plugin-dir=/usr/local/opt/mysql@5.7/lib/plugin --log-error=h2tomo.err --pid-file=h2tomo.pid
89861 ?? S 0:00.04 /bin/sh /usr/local/opt/mysql/bin/mysqld_safe --bind-address=127.0.0.1 --datadir=/usr/local/var/mysql
89969 ?? S 0:00.62 /usr/local/Cellar/mysql/5.7.17/bin/mysqld --basedir=/usr/local/Cellar/mysql/5.7.17 --datadir=/usr/local/var/mysql --plugin-dir=/usr/local/Cellar/mysql/5.7.17/lib/plugin --bind-address=127.0.0.1 --log-error=/usr/local/var/mysql/h2tomo.err --pid-file=/usr/local/var/mysql/h2tomo.pid
89974 s001 S+ 0:00.00 grep mysql
h2tomo:var meotomohiro$ kill -9 89768
h2tomo:var meotomohiro$ ps ax | grep mysql
89855 ?? S 0:00.31 /usr/local/opt/mysql@5.7/bin/mysqld --basedir=/usr/local/opt/mysql@5.7 --datadir=/usr/local/var/mysql --plugin-dir=/usr/local/opt/mysql@5.7/lib/plugin --log-error=h2tomo.err --pid-file=h2tomo.pid
89861 ?? S 0:00.04 /bin/sh /usr/local/opt/mysql/bin/mysqld_safe --bind-address=127.0.0.1 --datadir=/usr/local/var/mysql
89969 ?? S 0:00.62 /usr/local/Cellar/mysql/5.7.17/bin/mysqld --basedir=/usr/local/Cellar/mysql/5.7.17 --datadir=/usr/local/var/mysql --plugin-dir=/usr/local/Cellar/mysql/5.7.17/lib/plugin --bind-address=127.0.0.1 --log-error=/usr/local/var/mysql/h2tomo.err --pid-file=/usr/local/var/mysql/h2tomo.pid
90047 s001 S+ 0:00.00 grep mysql
h2tomo:var meotomohiro$ kill -9 89855
h2tomo:var meotomohiro$ ps ax | grep mysql
89861 ?? S 0:00.04 /bin/sh /usr/local/opt/mysql/bin/mysqld_safe --bind-address=127.0.0.1 --datadir=/usr/local/var/mysql
89969 ?? S 0:00.63 /usr/local/Cellar/mysql/5.7.17/bin/mysqld --basedir=/usr/local/Cellar/mysql/5.7.17 --datadir=/usr/local/var/mysql --plugin-dir=/usr/local/Cellar/mysql/5.7.17/lib/plugin --bind-address=127.0.0.1 --log-error=/usr/local/var/mysql/h2tomo.err --pid-file=/usr/local/var/mysql/h2tomo.pid
90120 s001 R+ 0:00.00 grep mysql
h2tomo:var meotomohiro$ kill -9 89861
h2tomo:var meotomohiro$ ps ax | grep mysql
90282 s001 S+ 0:00.00 grep mysql
h2tomo:var meotomohiro$ ps ax | grep mysql
90284 s001 S+ 0:00.00 grep mysql
h2tomo:var meotomohiro$ cd
h2tomo:~ meotomohiro$ cd work/potepanec/
h2tomo:potepanec meotomohiro$ sudo mysql.server start
Starting MySQL
SUCCESS!
h2tomo:potepanec meotomohiro$ usage: grep [-abcDEFGHhIiJLlmnOoqRSsUVvwxZ] [-A num] [-B num] [-C[num]]
[-e pattern] [-f file] [--binary-files=value] [--color=when]
[--context[=num]] [--directories=action] [--label] [--line-buffered]
[--null] [pattern] [file ...]
2018-07-21T05:03:36.6NZ mysqld_safe A mysqld process already exists
参考にしたサイト
https://qiita.com/YamKenta/items/a33499a7db7946a43381 https://qiita.com/mogetarou/items/e34ca51d3756d55d7800