MEMO：Docker for WindowsでMariaDBが使えない？

こんにちは，しののめ(@Shinogasa)です．

仕事でDocker for Windows上にMySQLを立てていたのですが，都合によりMariaDBに移行することになりました．

そうしたら何か色々エラーが出て使えなかったのでその時の状況をメモ．

docker-compose使っていたので下記のような設定

#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:

# 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はこう

FROM mariadb:latest

EXPOSE 3306

CMD ["mysqld"]

FROMmariadb:latest

EXPOSE3306

CMD["mysqld"]

ビルドして立ち上げてみたらこんなエラーが．

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

docker-conposeupmariadb

mariadb_1 |2018-06-08 7:59:41140105323919296[Note]mysqld(mysqld10.1.22-MariaDB-1~jessie)startingasprocess1...

mariadb_1 |2018-06-08 7:59:41140105323919296[Note]InnoDB:Usingmutexestorefcountbufferpoolpages

mariadb_1 |2018-06-08 7:59:41140105323919296[Note]InnoDB:TheInnoDBmemoryheapisdisabled

mariadb_1 |2018-06-08 7:59:41140105323919296[Note]InnoDB:Mutexesandrw_locksuseGCCatomicbuiltins

mariadb_1 |2018-06-08 7:59:41140105323919296[Note]InnoDB:GCCbuiltin__atomic_thread_fence()isusedformemorybarrier

mariadb_1 |2018-06-08 7:59:41140105323919296[Note]InnoDB:Compressedtablesusezlib1.2.8

mariadb_1 |2018-06-08 7:59:41140105323919296[Note]InnoDB:UsingLinuxnativeAIO

mariadb_1 |2018-06-08 7:59:41140105323919296[Note]InnoDB:UsingSSEcrc32instructions

mariadb_1 |2018-06-08 7:59:41140105323919296[Note]InnoDB:Initializingbufferpool,size=256.0M

mariadb_1 |2018-06-08 7:59:41140105323919296[Note]InnoDB:Completedinitializationofbufferpool

mariadb_1 |2018-06-08 7:59:41140105323919296[ERROR]InnoDB:auto-extendingdatafile./ibdata1isofadifferentsize0pages(roundeddowntoMB)thanspecifiedinthe.cnffile:initial768pages,max0(relevantifnon-zero)pages!

mariadb_1 |2018-06-08 7:59:41140105323919296[ERROR]InnoDB:Couldnotopenorcreatethesystemtablespace.Ifyoutriedtoaddnewdatafilestothesystemtablespace,anditfailedhere,youshouldnoweditinnodb_data_file_pathinmy.cnfbacktowhatitwas,andremovethenewibdatafilesInnoDBcreatedinthisfailedattempt.InnoDBonlywrotethosefilesfullofzeros,butdidnotyetusetheminanyway.Butbecareful:donotremoveolddatafileswhichcontainyourpreciousdata!

mariadb_1 |2018-06-08 7:59:41140105323919296[ERROR]Plugin'InnoDB'initfunctionreturnederror.

mariadb_1 |2018-06-08 7:59:41140105323919296[ERROR]Plugin'InnoDB'registrationasaSTORAGEENGINEfailed.

mariadb_1 |2018-06-08 7:59:41140105323919296[Note]Plugin'FEEDBACK'isdisabled.

mariadb_1 |2018-06-08 7:59:41140105323919296[ERROR]Couldnotopenmysql.plugintable.Somepluginsmaybenotloaded

mariadb_1 |2018-06-08 7:59:41140105323919296[ERROR]Unknown/unsupportedstorageengine:InnoDB

mariadb_1 |2018-06-08 7:59:41140105323919296[ERROR]Aborting

/mariadb/data にあるファイル，ディレクトリ(mysql,aria_log.00000001,aria_log.control,ibdta1)を削除して再度起動

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

mariadb_1 |Initializingdatabase

mariadb_1 |2018-06-08 8:19:53139628971603904[Note]/usr/sbin/mysqld(mysqld10.1.22-MariaDB-1~jessie)startingasprocess60...

mariadb_1 |2018-06-08 8:19:53139628971603904[Note]InnoDB:Usingmutexestorefcountbufferpoolpages

mariadb_1 |2018-06-08 8:19:53139628971603904[Note]InnoDB:TheInnoDBmemoryheapisdisabled

mariadb_1 |2018-06-08 8:19:53139628971603904[Note]InnoDB:Mutexesandrw_locksuseGCCatomicbuiltins

mariadb_1 |2018-06-08 8:19:53139628971603904[Note]InnoDB:GCCbuiltin__atomic_thread_fence()isusedformemorybarrier

mariadb_1 |2018-06-08 8:19:53139628971603904[Note]InnoDB:Compressedtablesusezlib1.2.8

mariadb_1 |2018-06-08 8:19:53139628971603904[Note]InnoDB:UsingLinuxnativeAIO

mariadb_1 |2018-06-08 8:19:53139628971603904[Note]InnoDB:UsingSSEcrc32instructions

mariadb_1 |2018-06-08 8:19:53139628971603904[Note]InnoDB:Initializingbufferpool,size=256.0M

mariadb_1 |2018-06-08 8:19:53139628971603904[Note]InnoDB:Completedinitializationofbufferpool

mariadb_1 |2018-06-08 8:19:53139628971603904[Note]InnoDB:Thefirstspecifieddatafile./ibdata1didnotexist:anewdatabasetobecreated!

mariadb_1 |2018-06-08 8:19:53139628971603904[Note]InnoDB:Settingfile./ibdata1sizeto12MB

mariadb_1 |2018-06-0808:19:537efde740b7c0InnoDB:Error:Writetofile./ibdata1failedatoffset0.

mariadb_1 |InnoDB:1048576bytesshouldhavebeenwritten,only0werewritten.

mariadb_1 |InnoDB:Operatingsystemerrornumber22.

mariadb_1 |InnoDB:CheckthatyourOSandfilesystemsupportfilesofthissize.

mariadb_1 |InnoDB:Checkalsothatthediskisnotfulloradiskquotaexceeded.

mariadb_1 |InnoDB:Errornumber22means'Invalid argument'.

mariadb_1 |InnoDB:Someoperatingsystemerrornumbersaredescribedat

mariadb_1 |InnoDB:http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html

mariadb_1 |2018-06-08 8:19:53139628971603904[ERROR]InnoDB:Errorincreating./ibdata1:probablyoutofdiskspace

mariadb_1 |2018-06-08 8:19:53139628971603904[ERROR]InnoDB:Couldnotopenorcreatethesystemtablespace.Ifyoutriedtoaddnewdatafilestothesystemtablespace,anditfailedhere,youshouldnoweditinnodb_data_file_pathinmy.cnfbacktowhatitwas,andremovethenewibdatafilesInnoDBcreatedinthisfailedattempt.InnoDBonlywrotethosefilesfullofzeros,butdidnotyetusetheminanyway.Butbecareful:donotremoveolddatafileswhichcontainyourpreciousdata!

mariadb_1 |2018-06-08 8:19:53139628971603904[ERROR]Plugin'InnoDB'initfunctionreturnederror.

mariadb_1 |2018-06-08 8:19:53139628971603904[ERROR]Plugin'InnoDB'registrationasaSTORAGEENGINEfailed.

mariadb_1 |2018-06-08 8:19:53139628971603904[ERROR]Unknown/unsupportedstorageengine:InnoDB

mariadb_1 |2018-06-08 8:19:53139628971603904[ERROR]Aborting

mariadb_1 |

mariadb_1 |Installationofsystemtablesfailed! Examinethelogsin

mariadb_1 |/var/lib/mysql/formoreinformation.

mariadb_1 |

mariadb_1 |Theproblemcouldbeconflictinginformationinanexternal

mariadb_1 |my.cnffiles.Youcanignorethesebydoing:

mariadb_1 |

mariadb_1 | shell>/usr/scripts/scripts/mysql_install_db--defaults-file=~/.my.cnf

mariadb_1 |

mariadb_1 |Youcanalsotrytostartthemysqlddaemonwith:

mariadb_1 |

mariadb_1 | shell>/usr/sbin/mysqld--skip-grant--general-log&

mariadb_1 |

mariadb_1 |andusethecommandlinetool/usr/bin/mysql

mariadb_1 |toconnecttothemysqldatabaseandlookatthegranttables:

mariadb_1 |

mariadb_1 | shell>/usr/bin/mysql-urootmysql

mariadb_1 | mysql>showtables;

mariadb_1 |

mariadb_1 |Try'mysqld --help'ifyouhaveproblemswithpaths. Using

mariadb_1 |--general-loggivesyoualogin/var/lib/mysql/thatmaybehelpful.

mariadb_1 |

mariadb_1 |Thelatestinformationaboutmysql_install_dbisavailableat

mariadb_1 |https://mariadb.com/kb/en/installing-system-tables-mysql_install_db

mariadb_1 |MariaDBishostedonlaunchpad;Youcanfindthelatestsourceand

mariadb_1 |emaillistsathttp://launchpad.net/maria

mariadb_1 |

mariadb_1 |Pleasecheckalloftheabovebeforesubmittingabugreport

mariadb_1 |athttp://mariadb.org/jira

mariadb_1 |

multi_endpoint_room_management_server_mariadb_1exitedwithcode1

なんか再びエラーが．

色々調べていたらGithubにIssueが立ってました

can mount volumes from host for MySQL data on Windows Docker · Issue #42 · docker-library/percona

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...

on windows, cannot start a container with host directory as /var/lib/mysql mount · Issue #95 · docker-library/mariadb

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に変えたら問題なく起動してしまいました．

mariadb:
    build: ./mariadb
    volumes:
      - ./mariadb/data:/var/lib/mariadb
    ports:
      - 3306:3306
    environment:
      MYSQL_ROOT_PASSWORD: hoge
      MYSQL_DATABASE: fuga

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立てるのが正解かもしれないですね．