Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

MySQL init process failed #260

Closed
roberthartung opened this issue Sep 17, 2019 · 2 comments
Closed

MySQL init process failed #260

roberthartung opened this issue Sep 17, 2019 · 2 comments
Labels
Request Request for image modification or feature

Comments

@roberthartung
Copy link

Hello,
I am using the mariadb image along with nextcloud. When everything runs locally in my VM, everything is fine. However as I switched over to NFS, writes take longer (very long actually). However, I get this lot:

docker-compose up
Creating network "nextcloud_default" with the default driver
Creating nextcloud_db ... done
Creating nextcloud    ... done
Attaching to nextcloud_db, nextcloud
nextcloud    | Initializing nextcloud 16.0.4.1 ...
db_1         | Initializing database
db_1         | 2019-09-17  7:07:00 0 [Note] /usr/sbin/mysqld (mysqld 10.4.8-MariaDB-1:10.4.8+maria~bionic) starting as process 69 ...
db_1         | 2019-09-17  7:07:00 0 [Warning] You need to use --log-bin to make --binlog-format work.
db_1         | 2019-09-17  7:07:00 0 [Note] InnoDB: Using Linux native AIO
db_1         | 2019-09-17  7:07:00 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
db_1         | 2019-09-17  7:07:00 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
db_1         | 2019-09-17  7:07:00 0 [Note] InnoDB: Uses event mutexes
db_1         | 2019-09-17  7:07:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
db_1         | 2019-09-17  7:07:00 0 [Note] InnoDB: Number of pools: 1
db_1         | 2019-09-17  7:07:00 0 [Note] InnoDB: Using SSE2 crc32 instructions
db_1         | 2019-09-17  7:07:00 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
db_1         | 2019-09-17  7:07:00 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
db_1         | 2019-09-17  7:07:00 0 [Note] InnoDB: Completed initialization of buffer pool
db_1         | 2019-09-17  7:07:00 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         | 2019-09-17  7:07:00 0 [Note] InnoDB: Setting file './ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
db_1         | 2019-09-17  7:07:41 0 [Note] InnoDB: File './ibdata1' size is now 12 MB.
db_1         | 2019-09-17  7:07:41 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 50331648 bytes
db_1         | 2019-09-17  7:07:42 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 50331648 bytes
db_1         | 2019-09-17  7:07:42 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
db_1         | 2019-09-17  7:07:42 0 [Note] InnoDB: New log files created, LSN=17992
db_1         | 2019-09-17  7:07:42 0 [Note] InnoDB: Doublewrite buffer not found: creating new
db_1         | 2019-09-17  7:07:43 0 [Note] InnoDB: Doublewrite buffer created
db_1         | 2019-09-17  7:07:43 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
db_1         | 2019-09-17  7:07:43 0 [Note] InnoDB: Creating foreign key constraint system tables.
db_1         | 2019-09-17  7:07:43 0 [Note] InnoDB: Creating tablespace and datafile system tables.
db_1         | 2019-09-17  7:07:43 0 [Note] InnoDB: Creating sys_virtual system tables.
db_1         | 2019-09-17  7:07:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables
db_1         | 2019-09-17  7:07:43 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
db_1         | 2019-09-17  7:08:25 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
db_1         | 2019-09-17  7:08:25 0 [Note] InnoDB: Waiting for purge to start
db_1         | 2019-09-17  7:08:25 0 [Note] InnoDB: 10.4.8 started; log sequence number 0; transaction id 7
db_1         | 
db_1         | 
db_1         | PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
db_1         | To do so, start the server, then issue the following commands:
db_1         | 
db_1         | '/usr/bin/mysqladmin' -u root password 'new-password'
db_1         | '/usr/bin/mysqladmin' -u root -h  password 'new-password'
db_1         | 
db_1         | Alternatively you can run:
db_1         | '/usr/bin/mysql_secure_installation'
db_1         | 
db_1         | which will also give you the option of removing the test
db_1         | databases and anonymous user created by default.  This is
db_1         | strongly recommended for production servers.
db_1         | 
db_1         | See the MariaDB Knowledgebase at http://mariadb.com/kb or the
db_1         | MySQL manual for more instructions.
db_1         | 
db_1         | Please report any problems at http://mariadb.org/jira
db_1         | 
db_1         | The latest information about MariaDB is available at http://mariadb.org/.
db_1         | You can find additional information about the MySQL part at:
db_1         | http://dev.mysql.com
db_1         | Consider joining MariaDB's strong and vibrant community:
db_1         | https://mariadb.org/get-involved/
db_1         | 
db_1         | Database initialized
db_1         | MySQL init process in progress...
db_1         | 2019-09-17  7:08:32 0 [Note] mysqld (mysqld 10.4.8-MariaDB-1:10.4.8+maria~bionic) starting as process 106 ...
db_1         | 2019-09-17  7:08:32 0 [Warning] You need to use --log-bin to make --binlog-format work.
db_1         | 2019-09-17  7:08:32 0 [Note] InnoDB: Using Linux native AIO
db_1         | 2019-09-17  7:08:32 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
db_1         | 2019-09-17  7:08:32 0 [Note] InnoDB: Uses event mutexes
db_1         | 2019-09-17  7:08:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
db_1         | 2019-09-17  7:08:32 0 [Note] InnoDB: Number of pools: 1
db_1         | 2019-09-17  7:08:32 0 [Note] InnoDB: Using SSE2 crc32 instructions
db_1         | 2019-09-17  7:08:32 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
db_1         | 2019-09-17  7:08:32 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
db_1         | 2019-09-17  7:08:32 0 [Note] InnoDB: Completed initialization of buffer pool
db_1         | 2019-09-17  7:08:32 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         | 2019-09-17  7:08:32 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
db_1         | 2019-09-17  7:08:32 0 [Note] InnoDB: Creating shared tablespace for temporary tables
db_1         | 2019-09-17  7:08:32 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process in progress...
db_1         | MySQL init process failed.
nextcloud    | Initializing finished
nextcloud    | New nextcloud instance
nextcloud    | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.31.0.5. Set the 'ServerName' directive globally to suppress this message
nextcloud    | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.31.0.5. Set the 'ServerName' directive globally to suppress this message
nextcloud    | [Tue Sep 17 07:10:35.117226 2019] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.38 (Debian) PHP/7.3.9 configured -- resuming normal operations
nextcloud    | [Tue Sep 17 07:10:35.118151 2019] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'

Writing the file of 12MB takes ~40 seconds, but after 30 seconds this timeout occurs as can be seen in docker-entrypoint.sh:110.

Increasing this limit or making it configurable with an environment variable might help. I will see if I can get a PR for this.
@wglambert wglambert added the Request Request for image modification or feature label Sep 17, 2019
@yosifkit
Copy link
Contributor

Since we try to keep the SQL images interchangeable, these issues are related: docker-library/mysql#159 and docker-library/mysql#288.

@yosifkit yosifkit mentioned this issue Mar 4, 2020
Closed
@yosifkit
Copy link
Contributor

yosifkit commented Mar 4, 2020

Apologies for the delay 🙇‍♂️

Closing in favor of docker-library/mysql#646

@yosifkit yosifkit closed this as completed Mar 4, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Request Request for image modification or feature
Milestone
No milestone
Development

No branches or pull requests
3 participants
@yosifkit @roberthartung @wglambert