Created
December 17, 2015 17:13
-
-
Save polds/d806aea6a58304092bf8 to your computer and use it in GitHub Desktop.
Docker MySQL
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
docker run --name db -e MYSQL_ROOT_PASSWORD=root -d mysql:5.7.10 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Initializing database | |
2015-12-17T17:12:15.977840Z 0 [Warning] InnoDB: New log files created, LSN=45790 | |
2015-12-17T17:12:16.004856Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. | |
2015-12-17T17:12:16.059803Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 525577dc-a4e1-11e5-a2e3-0242ac110002. | |
2015-12-17T17:12:16.062632Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. | |
2015-12-17T17:12:16.063166Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. | |
2015-12-17T17:12:16.401815Z 1 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. | |
2015-12-17T17:12:16.402029Z 1 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
2015-12-17T17:12:16.402344Z 1 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
2015-12-17T17:12:16.402568Z 1 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. | |
2015-12-17T17:12:16.403070Z 1 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
Database initialized | |
MySQL init process in progress... | |
2015-12-17T17:12:18.138565Z 0 [Note] mysqld (mysqld 5.7.10) starting as process 40 ... | |
2015-12-17T17:12:18.142738Z 0 [Note] InnoDB: PUNCH HOLE support available | |
2015-12-17T17:12:18.142993Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins | |
2015-12-17T17:12:18.143207Z 0 [Note] InnoDB: Uses event mutexes | |
2015-12-17T17:12:18.143427Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier | |
2015-12-17T17:12:18.143580Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 | |
2015-12-17T17:12:18.143781Z 0 [Note] InnoDB: Using Linux native AIO | |
2015-12-17T17:12:18.144167Z 0 [Note] InnoDB: Number of pools: 1 | |
2015-12-17T17:12:18.144439Z 0 [Note] InnoDB: Using CPU crc32 instructions | |
2015-12-17T17:12:18.157984Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M | |
2015-12-17T17:12:18.171043Z 0 [Note] InnoDB: Completed initialization of buffer pool | |
2015-12-17T17:12:18.173730Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). | |
2015-12-17T17:12:18.189801Z 0 [Note] InnoDB: Highest supported file format is Barracuda. | |
2015-12-17T17:12:18.197663Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables | |
2015-12-17T17:12:18.197911Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... | |
2015-12-17T17:12:18.225231Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. | |
2015-12-17T17:12:18.227986Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. | |
2015-12-17T17:12:18.228505Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. | |
2015-12-17T17:12:18.230643Z 0 [Note] InnoDB: 5.7.10 started; log sequence number 2491156 | |
2015-12-17T17:12:18.231089Z 0 [Note] Plugin 'FEDERATED' is disabled. | |
2015-12-17T17:12:18.232576Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key | |
2015-12-17T17:12:18.233170Z 0 [Note] InnoDB: not started | |
2015-12-17T17:12:18.233204Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool | |
2015-12-17T17:12:18.234917Z 0 [Note] InnoDB: Buffer pool(s) load completed at 151217 17:12:18 | |
2015-12-17T17:12:18.237143Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. | |
2015-12-17T17:12:18.237354Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
2015-12-17T17:12:18.237558Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
2015-12-17T17:12:18.237802Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. | |
2015-12-17T17:12:18.239336Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
2015-12-17T17:12:18.246990Z 0 [Note] Event Scheduler: Loaded 0 events | |
2015-12-17T17:12:18.249558Z 0 [Note] mysqld: ready for connections. | |
Version: '5.7.10' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server (GPL) | |
Warning: Unable to load '/usr/share/zoneinfo/Factory' as time zone. Skipping it. | |
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it. | |
Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it. | |
Warning: Unable to load '/usr/share/zoneinfo/posix/Factory' as time zone. Skipping it. | |
Warning: Unable to load '/usr/share/zoneinfo/right/Factory' as time zone. Skipping it. | |
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it. | |
2015-12-17T17:12:20.410609Z 4 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
2015-12-17T17:12:20.411073Z 4 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. | |
2015-12-17T17:12:20.411485Z 4 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
/entrypoint.sh: ignoring /docker-entrypoint-initdb.d/* | |
2015-12-17T17:12:20.413309Z 0 [Note] Giving 0 client threads a chance to die gracefully | |
2015-12-17T17:12:20.413517Z 0 [Note] Shutting down slave threads | |
2015-12-17T17:12:20.413802Z 0 [Note] Forcefully disconnecting 0 remaining clients | |
2015-12-17T17:12:20.414010Z 0 [Note] Event Scheduler: Purging the queue. 0 events | |
2015-12-17T17:12:20.414964Z 0 [Note] Binlog end | |
2015-12-17T17:12:20.415686Z 0 [Note] Shutting down plugin 'ngram' | |
2015-12-17T17:12:20.416038Z 0 [Note] Shutting down plugin 'ARCHIVE' | |
2015-12-17T17:12:20.416224Z 0 [Note] Shutting down plugin 'partition' | |
2015-12-17T17:12:20.416230Z 0 [Note] Shutting down plugin 'BLACKHOLE' | |
2015-12-17T17:12:20.416233Z 0 [Note] Shutting down plugin 'MyISAM' | |
2015-12-17T17:12:20.416239Z 0 [Note] Shutting down plugin 'MRG_MYISAM' | |
2015-12-17T17:12:20.416242Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' | |
2015-12-17T17:12:20.416244Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' | |
2015-12-17T17:12:20.416246Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' | |
2015-12-17T17:12:20.416247Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' | |
2015-12-17T17:12:20.416249Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' | |
2015-12-17T17:12:20.416251Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' | |
2015-12-17T17:12:20.416253Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' | |
2015-12-17T17:12:20.416254Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' | |
2015-12-17T17:12:20.416256Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' | |
2015-12-17T17:12:20.416258Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' | |
2015-12-17T17:12:20.416261Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' | |
2015-12-17T17:12:20.416264Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' | |
2015-12-17T17:12:20.416267Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' | |
2015-12-17T17:12:20.416269Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' | |
2015-12-17T17:12:20.416705Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' | |
2015-12-17T17:12:20.416710Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' | |
2015-12-17T17:12:20.416711Z 0 [Note] Shutting down plugin 'INNODB_METRICS' | |
2015-12-17T17:12:20.416712Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' | |
2015-12-17T17:12:20.416713Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' | |
2015-12-17T17:12:20.416714Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' | |
2015-12-17T17:12:20.416715Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' | |
2015-12-17T17:12:20.416716Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' | |
2015-12-17T17:12:20.416717Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' | |
2015-12-17T17:12:20.416718Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' | |
2015-12-17T17:12:20.416719Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' | |
2015-12-17T17:12:20.416720Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' | |
2015-12-17T17:12:20.416721Z 0 [Note] Shutting down plugin 'INNODB_CMP' | |
2015-12-17T17:12:20.416722Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' | |
2015-12-17T17:12:20.416723Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' | |
2015-12-17T17:12:20.416724Z 0 [Note] Shutting down plugin 'INNODB_TRX' | |
2015-12-17T17:12:20.416725Z 0 [Note] Shutting down plugin 'InnoDB' | |
2015-12-17T17:12:20.416760Z 0 [Note] InnoDB: FTS optimize thread exiting. | |
2015-12-17T17:12:20.417082Z 0 [Note] InnoDB: Starting shutdown... | |
2015-12-17T17:12:20.517527Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool | |
2015-12-17T17:12:20.517699Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 151217 17:12:20 | |
2015-12-17T17:12:22.134748Z 0 [Note] InnoDB: Shutdown completed; log sequence number 11990130 | |
2015-12-17T17:12:22.136424Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" | |
2015-12-17T17:12:22.136541Z 0 [Note] Shutting down plugin 'CSV' | |
2015-12-17T17:12:22.136857Z 0 [Note] Shutting down plugin 'MEMORY' | |
2015-12-17T17:12:22.137098Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' | |
2015-12-17T17:12:22.137370Z 0 [Note] Shutting down plugin 'sha256_password' | |
2015-12-17T17:12:22.137626Z 0 [Note] Shutting down plugin 'mysql_native_password' | |
2015-12-17T17:12:22.138052Z 0 [Note] Shutting down plugin 'binlog' | |
2015-12-17T17:12:22.138834Z 0 [Note] mysqld: Shutdown complete | |
MySQL init process done. Ready for start up. | |
2015-12-17T17:12:22.345473Z 0 [Note] mysqld (mysqld 5.7.10) starting as process 1 ... | |
2015-12-17T17:12:22.348763Z 0 [Note] InnoDB: PUNCH HOLE support available | |
2015-12-17T17:12:22.349009Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins | |
2015-12-17T17:12:22.349265Z 0 [Note] InnoDB: Uses event mutexes | |
2015-12-17T17:12:22.349588Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier | |
2015-12-17T17:12:22.349800Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 | |
2015-12-17T17:12:22.349971Z 0 [Note] InnoDB: Using Linux native AIO | |
2015-12-17T17:12:22.350764Z 0 [Note] InnoDB: Number of pools: 1 | |
2015-12-17T17:12:22.351105Z 0 [Note] InnoDB: Using CPU crc32 instructions | |
2015-12-17T17:12:22.358295Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M | |
2015-12-17T17:12:22.363340Z 0 [Note] InnoDB: Completed initialization of buffer pool | |
2015-12-17T17:12:22.364660Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). | |
2015-12-17T17:12:22.375992Z 0 [Note] InnoDB: Highest supported file format is Barracuda. | |
2015-12-17T17:12:22.385030Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables | |
2015-12-17T17:12:22.385343Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... | |
2015-12-17T17:12:22.399625Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. | |
2015-12-17T17:12:22.400408Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. | |
2015-12-17T17:12:22.400740Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. | |
2015-12-17T17:12:22.401163Z 0 [Note] InnoDB: Waiting for purge to start | |
2015-12-17T17:12:22.451484Z 0 [Note] InnoDB: 5.7.10 started; log sequence number 11990130 | |
2015-12-17T17:12:22.452241Z 0 [Note] Plugin 'FEDERATED' is disabled. | |
2015-12-17T17:12:22.453515Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key | |
2015-12-17T17:12:22.453747Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 | |
2015-12-17T17:12:22.453976Z 0 [Note] IPv6 is available. | |
2015-12-17T17:12:22.454183Z 0 [Note] - '::' resolves to '::'; | |
2015-12-17T17:12:22.454621Z 0 [Note] Server socket created on IP: '::'. | |
2015-12-17T17:12:22.455003Z 0 [Note] InnoDB: not started | |
2015-12-17T17:12:22.455762Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool | |
2015-12-17T17:12:22.457436Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
2015-12-17T17:12:22.457647Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. | |
2015-12-17T17:12:22.459432Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
2015-12-17T17:12:22.461957Z 0 [Note] InnoDB: Buffer pool(s) load completed at 151217 17:12:22 | |
2015-12-17T17:12:22.465416Z 0 [Note] Event Scheduler: Loaded 0 events | |
2015-12-17T17:12:22.466003Z 0 [Note] mysqld: ready for connections. | |
Version: '5.7.10' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
db_1 | 2015-12-17T17:00:02.530194Z 0 [Note] mysqld (mysqld 5.7.10) starting as process 1 ... | |
db_1 | 2015-12-17T17:00:02.537287Z 0 [Warning] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive | |
db_1 | 2015-12-17T17:00:02.540212Z 0 [Note] InnoDB: PUNCH HOLE support available | |
db_1 | 2015-12-17T17:00:02.540243Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins | |
db_1 | 2015-12-17T17:00:02.540268Z 0 [Note] InnoDB: Uses event mutexes | |
db_1 | 2015-12-17T17:00:02.540408Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier | |
db_1 | 2015-12-17T17:00:02.540434Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 | |
db_1 | 2015-12-17T17:00:02.540450Z 0 [Note] InnoDB: Using Linux native AIO | |
db_1 | 2015-12-17T17:00:02.541575Z 0 [Note] InnoDB: Number of pools: 1 | |
db_1 | 2015-12-17T17:00:02.541839Z 0 [Note] InnoDB: Using CPU crc32 instructions | |
db_1 | 2015-12-17T17:00:02.557289Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M | |
db_1 | 2015-12-17T17:00:02.562134Z 0 [Note] InnoDB: Completed initialization of buffer pool | |
db_1 | 2015-12-17T17:00:02.563113Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). | |
db_1 | 2015-12-17T17:00:02.573650Z 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created! | |
db_1 | 2015-12-17T17:00:02.574302Z 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. | |
db_1 | 2015-12-17T17:00:02.574319Z 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory. | |
db_1 | 2015-12-17T17:00:02.574323Z 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. | |
db_1 | 2015-12-17T17:00:02.574325Z 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory. | |
db_1 | 2015-12-17T17:00:02.574328Z 0 [ERROR] InnoDB: Cannot open datafile './ibdata1' | |
db_1 | 2015-12-17T17:00:02.574331Z 0 [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! | |
db_1 | 2015-12-17T17:00:02.574334Z 0 [ERROR] InnoDB: InnoDB Database creation was aborted with error Cannot open a file. You may need to delete the ibdata1 file before trying to start up again. | |
db_1 | 2015-12-17T17:00:03.176131Z 0 [ERROR] Plugin 'InnoDB' init function returned error. | |
db_1 | 2015-12-17T17:00:03.176157Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. | |
db_1 | 2015-12-17T17:00:03.176161Z 0 [ERROR] Failed to initialize plugins. | |
db_1 | 2015-12-17T17:00:03.176163Z 0 [ERROR] Aborting | |
db_1 | | |
db_1 | 2015-12-17T17:00:03.176166Z 0 [Note] Binlog end | |
db_1 | 2015-12-17T17:00:03.176221Z 0 [Note] Shutting down plugin 'CSV' | |
db_1 | 2015-12-17T17:00:03.176598Z 0 [Note] mysqld: Shutdown complete | |
db_1 | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
db: | |
image: mysql:5.7.10 | |
environment: | |
- MYSQL_ROOT_PASSWORD=root |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment