Q&A
実現したいこと前提
現在自分はrailsアプリをdocker開発環境で開発しています。
bundle exec cap production deploy
実行時に
Caused by: Mysql2::Error::ConnectionError: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
とエラーが出ました
最初はdatabase.ymlの設定が間違っていると思いましたが、
どんな設定を試しても上手くいかなかったので、
MySQLが起動していない問題があると調べていて発見しました。
そこでEC2にsshログインして
[ec2-user@ip-10-0-10-10 ~]$ sudo service mysqld start Redirecting to /bin/systemctl start mysqld.service [ec2-user@ip-10-0-10-10 ~]$ systemctl status mysqld.service ● mysqld.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: active (running) since 月 2021-05-10 02:28:07 UTC; 17min ago Docs: man:mysqld(8) http://dev.mysql.com/doc/refman/en/using-systemd.html Main PID: 5266 (mysqld) Status: "Server is operational" CGroup: /system.slice/mysqld.service └─5266 /usr/sbin/mysqld 5月 10 02:28:00 ip-10-0-10-10.ap-northeast-1.compute.internal systemd[1]: Starting MySQL Server... 5月 10 02:28:07 ip-10-0-10-10.ap-northeast-1.compute.internal systemd[1]: Started MySQL Server.
上記のような実行結果になりました。
https://qiita.com/miriwo/items/e7afd5e1ae0de94f27c2
この記事を参考にして、この記事の44番でつまずいます。
エラー内容
[ec2-user@ip-10-0-10-10 ~]$ sudo vi /var/log/mysqld.log 2021-05-10T02:26:22.138121Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.24) starting as process 5100 2021-05-10T02:26:22.286607Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory. 2021-05-10T02:26:22.287188Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2021-05-10T02:26:22.434840Z 1 [ERROR] [MY-013090] [InnoDB] Unsupported redo log format (0). The redo log was created before MySQL 5.7.9 2021-05-10T02:26:22.434950Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2021-05-10T02:26:22.888612Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine. 2021-05-10T02:26:22.888918Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2021-05-10T02:26:22.889086Z 0 [ERROR] [MY-010119] [Server] Aborting 2021-05-10T02:26:22.910115Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.24) MySQL Community Server - GPL. 2021-05-10T02:26:55.103791Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.24) starting as process 5157 2021-05-10T02:26:55.111769Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory. 2021-05-10T02:26:55.112278Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2021-05-10T02:26:55.221302Z 1 [ERROR] [MY-013090] [InnoDB] Unsupported redo log format (0). The redo log was created before MySQL 5.7.9 2021-05-10T02:26:55.221399Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2021-05-10T02:26:55.670396Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine. 2021-05-10T02:26:55.670701Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2021-05-10T02:26:55.670862Z 0 [ERROR] [MY-010119] [Server] Aborting 2021-05-10T02:26:55.671794Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.24) MySQL Community Server - GPL. 2021-05-10T02:28:00.793246Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.24) initializing of server in progress as process 5222 2021-05-10T02:28:00.800596Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2021-05-10T02:28:01.514853Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2021-05-10T02:28:03.220756Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: )xi%_:x2auIE 2021-05-10T02:28:07.416855Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.24) starting as process 5266 2021-05-10T02:28:07.425976Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2021-05-10T02:28:07.666891Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2021-05-10T02:28:07.803043Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock 2021-05-10T02:28:07.963959Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2021-05-10T02:28:07.964132Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2021-05-10T02:28:07.999381Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.24' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server - GPL. ~
これがmysqldの起動ログです。
該当のソースコード
database.yml
default: &default adapter: mysql2 encoding: utf8 pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %> username: root password: <%= ENV['MYSQL_ROOT_PASSWORD'] %> socket: /tmp/mysql.sock host: <%= ENV['MYSQL_HOST'] || 'localhost' %> development: <<: *default database: coffee_passport_development # Warning: The database defined as "test" will be erased and # re-generated from your development database when you run "rake". # Do not set this db to the same as development or production. test: <<: *default database: coffee_passport_test # As with config/credentials.yml, you never want to store sensitive information, # like your database password, in your source code. If your source code is # ever seen by anyone, they now have access to your database. # # Instead, provide the password as a unix environment variable when you boot # the app. Read https://guides.rubyonrails.org/configuring.html#configuring-a-database # for a full rundown on how to provide these environment variables in a # production deployment. # # On Heroku and other platform providers, you may have a full connection URL # available as an environment variable. For example: # # DATABASE_URL="mysql2://myuser:mypass@localhost/somedatabase" # # You can use this database configuration with: # # production: # url: <%= ENV['DATABASE_URL'] %> # production: <<: *default database: coffee_passport_production username: root password: <%= ENV['MYSQL_ROOT_PASSWORD'] %> host: <%= ENV['MYSQL_HOST'] %> socket: /var/lib/mysql/mysql.sock
docker-compose.yml
version: '3' services: db: image: mysql:5.7 environment: MYSQL_ROOT_PASSWORD: ${MYSQL_ROOT_PASSWORD} MYSQL_HOST: db ports: - '3306:3306' volumes: - ./tmp/db:/var/lib/mysql web: build: . command: bash -c "rm -f tmp/pids/server.pid && bundle exec rails s -p 3000 -b '0.0.0.0'" volumes: - .:/coffee_passport ports: - "3000:3000" depends_on: - db environment: MYSQL_ROOT_PASSWORD: ${MYSQL_ROOT_PASSWORD} RAILS_MASTER_KEY: ${RAILS_MASTER_KEY} SENDGRID_API_KEY: ${SENDGRID_API_KEY} ADMIN_USER_PASSWORD: ${ADMIN_USER_PASSWORD} AWS_ACCESS_KEY_ID: ${AWS_ACCESS_KEY_ID} AWS_SECRET_ACCESS_KEY: ${AWS_SECRET_ACCESS_KEY} GOOGLE_USER_NAME: ${GOOGLE_USER_NAME} GOOGLE_PASSWORD: ${GOOGLE_PASSWORD} SENDGRID_USER_NAME: ${SENDGRID_USER_NAME} SENDGRID_PASSWORD: ${SENDGRID_PASSWORD} PAYJP_SECRET_KEY: ${PAYJP_SECRET_KEY} PAYJP_PUBLIC_KEY: ${PAYJP_PUBLIC_KEY} MYSQL_HOST: db # selenium_chrome を使うために以下の行を追加 SELENIUM_DRIVER_URL: http://selenium_chrome:4444/wd/hub" selenium_chrome: image: selenium/standalone-chrome-debug logging: driver: none
試したこと
私の行った手順は以下です。
(1)https://qiita.com/miriwo/items/e7afd5e1ae0de94f27c2
44番で上手くいきませんでした。
すると、上記のような結果になりました。
Unsupported redo log format (0). The redo log was created before MySQL 5.7.9
とあってdocker-compose.ymlに
version: '3' services: db: image: mysql:5.7
とあるので、もしかしたらそれが関係あるのかもしれません
環境
MacOS,ruby 2.6.5p114,Rails 6.1.3.1,Docker version 20.10.5
回答1件
0
ベストアンサー
タイトルにしているメッセージは古いserviceコマンドをsystemctlにリダイレクトしているだけで特に問題ありません。
記載の通りserviceコマンドは古いので、できればsystemctlを使うように慣れてください。
そして、見ての通りrunningなのでMySQL Serverは問題なく起動しています。
エラーの内容を見ると、ソケットファイルのパスが間違っているのではという気がします。
本当に/var/lib/mysql/mysql.sockですか？
ちゃんと/etc/my.cnfの設定内容を確認してみてください。
特に言及してませんけど、デプロイ先でもdocker-composeで動かすんでしょうか？
もしそうでないならdocker-composeは何も関係ないですね。
逆にもしdocker-composeで動かすつもりならデプロイ先でMySQLサーバが動いていても関係ありません。
というより、現状の設定だとポートがバッティングしてうまく起動できないでしょうね。
投稿2021/05/10 03:54
総合スコア7447
あなたの回答
tips
プレビュー
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。
2021/05/10 04:37