27歳未経験でエンジニア転職した元営業マン

アルバイトで半年間をドブに捨てた後、2ヶ月でエンジニア転職した記録

lib/mysql2/client.rb:89:in `connect': Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38) (Mysql2::Error)

エラー内容

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