株ブログ

とりあえず自分用ノート

MySQL8.0ほど糞な代物はない

5.x系に比べて速度が2倍になったとかほざいているけど

動作しなかったら意味ないよね・・・

/usr/local/var/mysql内の

MacBook-puro.local.errを

開いたらこんな感じのエラー

 

本当にエラーをトレースしてもトレースしても・・・

次々に不具合が出てくる。もうやっつけるのに疲れました。

ダウングレードすることにしました。

socketやらユーザー認証やら・・・etc

 

リリースしたばかりでは、互換性がないので導入は慎重に考えましょう!

StackOverFlow界隈でもハマってる人ばかりでダウングレードする人が多かったのもギブアップする要因になりました( ・∇・)

 

 

2018-07-18T14:17:41.209694Z 0 [System] [MY-010931] [Server] /usr/local/Cellar/mysql/8.0.11/bin/mysqld: ready for connections. Version: '8.0.11'  socket: '/tmp/mysql.sock'  port: 3306  Homebrew.

2018-07-20T13:51:22.6NZ mysqld_safe Logging to '/usr/local/var/mysql/macbookpuro.err'.

2018-07-20T13:51:23.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql

2018-07-20T13:51:23.651744Z 0 [System] [MY-010116] [Server] /usr/local/Cellar/mysql/8.0.11/bin/mysqld (mysqld 8.0.11) starting as process 10283

2018-07-20T13:51:23.685666Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive

2018-07-20T13:51:23.867461Z 1 [ERROR] [MY-012574] [InnoDB] InnoDB: Unable to lock ./ibdata1 error: 35

2018-07-20T13:51:24.867879Z 1 [ERROR] [MY-012574] [InnoDB] InnoDB: Unable to lock ./ibdata1 error: 35

2018-07-20T13:51:25.869374Z 1 [ERROR] [MY-012574] [InnoDB] InnoDB: Unable to lock ./ibdata1 error: 35

2018-07-20T13:51:26.869812Z 1 [ERROR] [MY-012574] [InnoDB] InnoDB: Unable to lock ./ibdata1 error: 35

2018-07-20T13:51:27.870095Z 1 [ERROR] [MY-012574] [InnoDB] InnoDB: Unable to lock ./ibdata1 error: 35

2018-07-20T13:51:28.871659Z 1 [ERROR] [MY-012574] [InnoDB] InnoDB: Unable to lock ./ibdata1 error: 35

2018-07-20T13:51:29.874531Z 1 [ERROR] [MY-012574] [InnoDB] InnoDB: Unable to lock ./ibdata1 error: 35

2018-07-20T13:51:30.876362Z 1 [ERROR] [MY-012574] [InnoDB] InnoDB: Unable to lock ./ibdata1 error: 35

2018-07-20T13:51:31.876658Z 1 [ERROR] [MY-012574] [InnoDB] InnoDB: Unable to lock ./ibdata1 error: 35

 

 

2018-07-20T13:53:04.174389Z 1 [ERROR] [MY-012574] [InnoDB] InnoDB: Unable to lock ./ibdata1 error: 35

2018-07-20T13:53:04.174526Z 1 [ERROR] [MY-012592] [InnoDB] InnoDB: Operating system error number 35 in a file operation.

2018-07-20T13:53:04.174595Z 1 [ERROR] [MY-012596] [InnoDB] InnoDB: Error number 35 means 'Resource temporarily unavailable'

2018-07-20T13:53:04.174661Z 1 [ERROR] [MY-012215] [InnoDB] InnoDB: Cannot open datafile './ibdata1'

2018-07-20T13:53:04.174732Z 1 [ERROR] [MY-012959] [InnoDB] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!

 

$ php artisan migrate

 

   Illuminate\Database\QueryException : SQLSTATE[HY000] [1044] Access denied for user 'laravel'@'localhost' to database 'test' (SQL: select * from information_schema.tables where table_schema = test and table_name = migrations)

 

  at /Users/potato/test/test/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664

    660|         // If an exception occurs when attempting to run a query, we'll format the error

    661|         // message to include the bindings with SQL, which will make this exception a

    662|         // lot more helpful to the developer instead of just the database's errors.

    663|         catch (Exception $e) {

  > 664|             throw new QueryException(

    665|                 $query, $this->prepareBindings($bindings), $e

    666|             );

    667|         }

    668|

 

  Exception trace:

 

  1   PDOException::("SQLSTATE[HY000] [1044] Access denied for user 'laravel'@'localhost' to database 'test'")

      /Users/potato/test/test/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:68

 

  2   PDO::__construct("mysql:unix_socket=/tmp/mysql.sock;dbname=test", "laravel", "laravel", [])

      /Users/potato/test/test/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:68

 

  Please use the argument -v to see more details.