こんにちは，しののめ(@Shinogasa)です．
仕事でDocker for Windows上にMySQLを立てていたのですが，都合によりMariaDBに移行することになりました．
そうしたら何か色々エラーが出て使えなかったのでその時の状況をメモ．
docker-compose使っていたので下記のような設定
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
#mysql: # build: ./mysql # volumes: # - ./mysql/data:/var/lib/mysql # ports: # - 3306:3306 # environment: # MYSQL_ROOT_PASSWORD: hoge # MYSQL_DATABASE: fuga mariadb: build: ./mariadb volumes: - ./mariadb/data:/var/lib/mysql ports: - 3306:3306 environment: MYSQL_ROOT_PASSWORD: hoge MYSQL_DATABASE: fuga |
mysqlの設定をそのままmariadbに書き換えただけ．
dockerfileはこう
|
1 2 3 4 5 |
FROM mariadb:latest EXPOSE 3306 CMD ["mysqld"] |
ビルドして立ち上げてみたらこんなエラーが．
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
docker-conpose up mariadb mariadb_1 | 2018-06-08 7:59:41 140105323919296 [Note] mysqld (mysqld 10.1.22-MariaDB-1~jessie) starting as process 1 ... mariadb_1 | 2018-06-08 7:59:41 140105323919296 [Note] InnoDB: Using mutexes to ref count buffer pool pages mariadb_1 | 2018-06-08 7:59:41 140105323919296 [Note] InnoDB: The InnoDB memory heap is disabled mariadb_1 | 2018-06-08 7:59:41 140105323919296 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins mariadb_1 | 2018-06-08 7:59:41 140105323919296 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier mariadb_1 | 2018-06-08 7:59:41 140105323919296 [Note] InnoDB: Compressed tables use zlib 1.2.8 mariadb_1 | 2018-06-08 7:59:41 140105323919296 [Note] InnoDB: Using Linux native AIO mariadb_1 | 2018-06-08 7:59:41 140105323919296 [Note] InnoDB: Using SSE crc32 instructions mariadb_1 | 2018-06-08 7:59:41 140105323919296 [Note] InnoDB: Initializing buffer pool, size = 256.0M mariadb_1 | 2018-06-08 7:59:41 140105323919296 [Note] InnoDB: Completed initialization of buffer pool mariadb_1 | 2018-06-08 7:59:41 140105323919296 [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 0 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages! mariadb_1 | 2018-06-08 7:59:41 140105323919296 [ERROR] 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! mariadb_1 | 2018-06-08 7:59:41 140105323919296 [ERROR] Plugin 'InnoDB' init function returned error. mariadb_1 | 2018-06-08 7:59:41 140105323919296 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. mariadb_1 | 2018-06-08 7:59:41 140105323919296 [Note] Plugin 'FEEDBACK' is disabled. mariadb_1 | 2018-06-08 7:59:41 140105323919296 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded mariadb_1 | 2018-06-08 7:59:41 140105323919296 [ERROR] Unknown/unsupported storage engine: InnoDB mariadb_1 | 2018-06-08 7:59:41 140105323919296 [ERROR] Aborting |
/mariadb/data にあるファイル，ディレクトリ(mysql,aria_log.00000001,aria_log.control,ibdta1)を削除して再度起動
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 |
mariadb_1 | Initializing database mariadb_1 | 2018-06-08 8:19:53 139628971603904 [Note] /usr/sbin/mysqld (mysqld 10.1.22-MariaDB-1~jessie) starting as process 60 ... mariadb_1 | 2018-06-08 8:19:53 139628971603904 [Note] InnoDB: Using mutexes to ref count buffer pool pages mariadb_1 | 2018-06-08 8:19:53 139628971603904 [Note] InnoDB: The InnoDB memory heap is disabled mariadb_1 | 2018-06-08 8:19:53 139628971603904 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins mariadb_1 | 2018-06-08 8:19:53 139628971603904 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier mariadb_1 | 2018-06-08 8:19:53 139628971603904 [Note] InnoDB: Compressed tables use zlib 1.2.8 mariadb_1 | 2018-06-08 8:19:53 139628971603904 [Note] InnoDB: Using Linux native AIO mariadb_1 | 2018-06-08 8:19:53 139628971603904 [Note] InnoDB: Using SSE crc32 instructions mariadb_1 | 2018-06-08 8:19:53 139628971603904 [Note] InnoDB: Initializing buffer pool, size = 256.0M mariadb_1 | 2018-06-08 8:19:53 139628971603904 [Note] InnoDB: Completed initialization of buffer pool mariadb_1 | 2018-06-08 8:19:53 139628971603904 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! mariadb_1 | 2018-06-08 8:19:53 139628971603904 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB mariadb_1 | 2018-06-08 08:19:53 7efde740b7c0 InnoDB: Error: Write to file ./ibdata1 failed at offset 0. mariadb_1 | InnoDB: 1048576 bytes should have been written, only 0 were written. mariadb_1 | InnoDB: Operating system error number 22. mariadb_1 | InnoDB: Check that your OS and file system support files of this size. mariadb_1 | InnoDB: Check also that the disk is not full or a disk quota exceeded. mariadb_1 | InnoDB: Error number 22 means 'Invalid argument'. mariadb_1 | InnoDB: Some operating system error numbers are described at mariadb_1 | InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html mariadb_1 | 2018-06-08 8:19:53 139628971603904 [ERROR] InnoDB: Error in creating ./ibdata1: probably out of disk space mariadb_1 | 2018-06-08 8:19:53 139628971603904 [ERROR] 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! mariadb_1 | 2018-06-08 8:19:53 139628971603904 [ERROR] Plugin 'InnoDB' init function returned error. mariadb_1 | 2018-06-08 8:19:53 139628971603904 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. mariadb_1 | 2018-06-08 8:19:53 139628971603904 [ERROR] Unknown/unsupported storage engine: InnoDB mariadb_1 | 2018-06-08 8:19:53 139628971603904 [ERROR] Aborting mariadb_1 | mariadb_1 | mariadb_1 | Installation of system tables failed! Examine the logs in mariadb_1 | /var/lib/mysql/ for more information. mariadb_1 | mariadb_1 | The problem could be conflicting information in an external mariadb_1 | my.cnf files. You can ignore these by doing: mariadb_1 | mariadb_1 | shell> /usr/scripts/scripts/mysql_install_db --defaults-file=~/.my.cnf mariadb_1 | mariadb_1 | You can also try to start the mysqld daemon with: mariadb_1 | mariadb_1 | shell> /usr/sbin/mysqld --skip-grant --general-log & mariadb_1 | mariadb_1 | and use the command line tool /usr/bin/mysql mariadb_1 | to connect to the mysql database and look at the grant tables: mariadb_1 | mariadb_1 | shell> /usr/bin/mysql -u root mysql mariadb_1 | mysql> show tables; mariadb_1 | mariadb_1 | Try 'mysqld --help' if you have problems with paths. Using mariadb_1 | --general-log gives you a log in /var/lib/mysql/ that may be helpful. mariadb_1 | mariadb_1 | The latest information about mysql_install_db is available at mariadb_1 | https://mariadb.com/kb/en/installing-system-tables-mysql_install_db mariadb_1 | MariaDB is hosted on launchpad; You can find the latest source and mariadb_1 | email lists at http://launchpad.net/maria mariadb_1 | mariadb_1 | Please check all of the above before submitting a bug report mariadb_1 | at http://mariadb.org/jira mariadb_1 | multi_endpoint_room_management_server_mariadb_1 exited with code 1 |
なんか再びエラーが．
色々調べていたらGithubにIssueが立ってました
i have same problem. Percona(or mariadb or mysql) can not start. Docker stats: docker -v Docker version 17.03.0-ce, build 60ccb22 docker-compose -v docker-compo...
Tried running a mariadb container by means of docker-compose. This trouble similar to this issue #38 docker-library/mysql#99 (comment) it doesn't solve the ...
これ見た感じだとDocker for WindowsではMariaDBが使えないっぽい？
というかMySQL立てた後にそのままMariaDB使うとダメなのかな．
色々試行錯誤してたらvolumesの値を/var/lib/mysqlから/var/lib/mariadbに変えたら問題なく起動してしまいました．
|
1 2 3 4 5 6 7 8 9 |
mariadb: build: ./mariadb volumes: - ./mariadb/data:/var/lib/mariadb ports: - 3306:3306 environment: MYSQL_ROOT_PASSWORD: hoge MYSQL_DATABASE: fuga |
dockerコンテナ上の同じディレクトリを使うとダメなのかもしれないっすね．
でもそのせいで今までMySQLに入れていたデータはMariaDBに引き継ぐことはできませんでした・・・．
やはりCentOS上にDocker立てるのが正解かもしれないですね．
