Page MenuHomePhabricator
Paste P7260

docker-compose logs -f
ArchivedPublic
Actions

Authored by zeljkofilipin on Jun 14 2018, 4:45 PM.
Tags
None
Referenced Files
F22240076: docker-compose logs -f
Jun 14 2018, 4:45 PM
Subscribers
None
~/Documents/github/addshore/mediawiki-docker-dev$ docker-compose logs -f
Attaching to mediawiki-docker-dev_web_1, mediawiki-docker-dev_db-configure_1, mediawiki-docker-dev_db-slave_1, mediawiki-docker-dev_phpmyadmin_1, mediawiki-docker-dev_nginx-proxy_1, mediawiki-docker-dev_graphite-statsd_1, mediawiki-docker-dev_db-master_1
db-configure_1 | ++ dirname /tmp/mysql_connector.sh
db-configure_1 | + BASE_PATH=/tmp
db-configure_1 | + echo 'Waiting for mysql to get up'
db-configure_1 | Waiting for mysql to get up
db-configure_1 | + /tmp/wait-for-it.sh db-master:3306
db-configure_1 | wait-for-it.sh: waiting 15 seconds for db-master:3306
db-configure_1 | wait-for-it.sh: db-master:3306 is available after 10 seconds
db-configure_1 | + /tmp/wait-for-it.sh db-slave:3306
db-configure_1 | wait-for-it.sh: waiting 15 seconds for db-slave:3306
db-configure_1 | wait-for-it.sh: db-slave:3306 is available after 0 seconds
db-configure_1 | + /tmp/wait-for-it.sh db-master:3306
db-configure_1 | wait-for-it.sh: waiting 15 seconds for db-master:3306
db-configure_1 | wait-for-it.sh: db-master:3306 is available after 0 seconds
db-configure_1 | + /tmp/wait-for-it.sh db-slave:3306
db-configure_1 | wait-for-it.sh: waiting 15 seconds for db-slave:3306
db-configure_1 | wait-for-it.sh: db-slave:3306 is available after 0 seconds
db-configure_1 | + echo 'Create MySQL Servers (master / slave repl)'
db-configure_1 | Create MySQL Servers (master / slave repl)
db-configure_1 | + echo -----------------
db-configure_1 | -----------------
db-configure_1 | + echo '* Create replication user'
db-configure_1 | * Create replication user
db-configure_1 | + mysql --host db-slave -uroot -ptoor -AN -e 'STOP SLAVE;'
db-configure_1 | + mysql --host db-slave -uroot -ptoor -AN -e 'RESET SLAVE ALL;'
db-configure_1 | + mysql --host db-master -uroot -ptoor -AN -e 'CREATE USER '\''repl'\''@'\''%'\'';'
db-configure_1 | + mysql --host db-master -uroot -ptoor -AN -e 'GRANT REPLICATION SLAVE ON *.* TO '\''repl'\''@'\''%'\'' IDENTIFIED BY '\''repl'\'';'
db-configure_1 | + mysql --host db-master -uroot -ptoor -AN -e 'flush privileges;'
db-configure_1 | + echo '* Set MySQL01 as master on MySQL02'
db-configure_1 | * Set MySQL01 as master on MySQL02
db-configure_1 | ++ eval 'mysql --host db-master -uroot -ptoor -e '\''show master status \G'\'' | grep Position | sed -n -e '\''s/^.*: //p'\'''
db-configure_1 | +++ sed -n -e 's/^.*: //p'
db-configure_1 | +++ grep Position
db-configure_1 | +++ mysql --host db-master -uroot -ptoor -e 'show master status \G'
db-configure_1 | + MYSQL01_Position=768
db-configure_1 | ++ eval 'mysql --host db-master -uroot -ptoor -e '\''show master status \G'\'' | grep File | sed -n -e '\''s/^.*: //p'\'''
db-configure_1 | +++ sed -n -e 's/^.*: //p'
db-configure_1 | +++ grep File
db-configure_1 | +++ mysql --host db-master -uroot -ptoor -e 'show master status \G'
db-configure_1 | + MYSQL01_File=mysql-bin.000003
db-configure_1 | ++ eval 'getent hosts db-master|awk '\''{print $1}'\'''
db-configure_1 | +++ awk '{print $1}'
db-configure_1 | +++ getent hosts db-master
db-configure_1 | + MASTER_IP=172.18.0.2
db-configure_1 | 172.18.0.2
db-configure_1 | + echo 172.18.0.2
db-configure_1 | + mysql --host db-slave -uroot -ptoor -AN -e 'CHANGE MASTER TO master_host='\''db-master'\'', master_port=3306, master_user='\''repl'\'', master_password='\''repl'\'', master_log_file='\''mysql-bin.000003'\'', master_log_pos=768;'
db-configure_1 | + echo '* Set MySQL02 as master on MySQL01'
db-configure_1 | * Set MySQL02 as master on MySQL01
db-configure_1 | ++ eval 'mysql --host db-slave -uroot -ptoor -e '\''show master status \G'\'' | grep Position | sed -n -e '\''s/^.*: //p'\'''
db-configure_1 | +++ sed -n -e 's/^.*: //p'
db-configure_1 | +++ grep Position
db-configure_1 | +++ mysql --host db-slave -uroot -ptoor -e 'show master status \G'
db-configure_1 | + MYSQL02_Position=342
db-configure_1 | ++ eval 'mysql --host db-slave -uroot -ptoor -e '\''show master status \G'\'' | grep File | sed -n -e '\''s/^.*: //p'\'''
db-configure_1 | +++ sed -n -e 's/^.*: //p'
db-configure_1 | +++ grep File
db-configure_1 | +++ mysql --host db-slave -uroot -ptoor -e 'show master status \G'
db-configure_1 | + MYSQL02_File=mysql-bin.000003
db-configure_1 | ++ eval 'getent hosts db-slave|awk '\''{print $1}'\'''
db-configure_1 | +++ awk '{print $1}'
db-configure_1 | +++ getent hosts db-slave
db-configure_1 | + SLAVE_IP=172.18.0.3
db-configure_1 | 172.18.0.3
db-configure_1 | + echo 172.18.0.3
db-configure_1 | + mysql --host db-master -uroot -ptoor -AN -e 'CHANGE MASTER TO master_host='\''db-slave'\'', master_port=3306, master_user='\''repl'\'', master_password='\''repl'\'', master_log_file='\''mysql-bin.000003'\'', master_log_pos=342;'
db-configure_1 | + echo '* Start Slave on both Servers'
db-configure_1 | * Start Slave on both Servers
db-configure_1 | + mysql --host db-slave -uroot -ptoor -AN -e 'start slave;'
db-configure_1 | + echo 'Increase the max_connections to 2000'
db-configure_1 | + mysql --host db-master -uroot -ptoor -AN -e 'set GLOBAL max_connections=2000'
db-configure_1 | Increase the max_connections to 2000
db-configure_1 | + mysql --host db-slave -uroot -ptoor -AN -e 'set GLOBAL max_connections=2000'
db-configure_1 | + mysql --host db-slave -uroot -ptoor -e 'show slave status \G'
db-configure_1 | *************************** 1. row ***************************
db-configure_1 | Slave_IO_State: Waiting for master to send event
db-configure_1 | Master_Host: db-master
web_1 | -> Executing /opt/docker/provision/entrypoint.d/05-permissions.sh
web_1 | -> Executing /opt/docker/provision/entrypoint.d/10-php-debugger.sh
web_1 | PHP-Debugger: Xdebug enabled
web_1 | - Removing PHP module blackfire
web_1 | -> Executing /opt/docker/provision/entrypoint.d/20-apache-dev.sh
web_1 | -> Executing /opt/docker/provision/entrypoint.d/20-apache.sh
web_1 | -> Executing /opt/docker/provision/entrypoint.d/20-php-fpm.sh
web_1 | -> Executing /opt/docker/provision/entrypoint.d/20-php.sh
web_1 | -> Executing /opt/docker/bin/service.d/supervisor.d//10-init.sh
web_1 | 2018-06-14 16:29:01,570 CRIT Set uid to user 0
web_1 | 2018-06-14 16:29:01,571 WARN Included extra file "/opt/docker/etc/supervisor.d/apache.conf" during parsing
web_1 | 2018-06-14 16:29:01,571 WARN Included extra file "/opt/docker/etc/supervisor.d/blackfire-agent.conf" during parsing
web_1 | 2018-06-14 16:29:01,571 WARN Included extra file "/opt/docker/etc/supervisor.d/cron.conf" during parsing
web_1 | 2018-06-14 16:29:01,571 WARN Included extra file "/opt/docker/etc/supervisor.d/dnsmasq.conf" during parsing
web_1 | 2018-06-14 16:29:01,572 WARN Included extra file "/opt/docker/etc/supervisor.d/php-fpm.conf" during parsing
web_1 | 2018-06-14 16:29:01,572 WARN Included extra file "/opt/docker/etc/supervisor.d/postfix.conf" during parsing
web_1 | 2018-06-14 16:29:01,572 WARN Included extra file "/opt/docker/etc/supervisor.d/ssh.conf" during parsing
web_1 | 2018-06-14 16:29:01,572 WARN Included extra file "/opt/docker/etc/supervisor.d/syslog.conf" during parsing
web_1 | 2018-06-14 16:29:01,580 INFO RPC interface 'supervisor' initialized
web_1 | 2018-06-14 16:29:01,581 INFO supervisord started with pid 1
web_1 | 2018-06-14 16:29:02,584 INFO spawned: 'syslogd' with pid 58
web_1 | 2018-06-14 16:29:02,586 INFO spawned: 'php-fpmd' with pid 59
web_1 | 2018-06-14 16:29:02,588 INFO spawned: 'apached' with pid 60
web_1 | 2018-06-14 16:29:02,590 INFO spawned: 'crond' with pid 61
web_1 | 2018-06-14 16:29:02,609 INFO spawned: 'postfixd' with pid 64
web_1 | 2018-06-14 16:29:02,611 INFO spawned: 'sshd' with pid 67
web_1 | -> Executing /opt/docker/bin/service.d/syslog-ng.d//10-init.sh
web_1 | -> Executing /opt/docker/bin/service.d/php-fpm.d//10-init.sh
web_1 | Setting php-fpm user to application
web_1 | -> Executing /opt/docker/bin/service.d/httpd.d//10-init.sh
web_1 | 2018-06-14 16:29:02,613 INFO success: php-fpmd entered RUNNING state, process has stayed up for > than 0 seconds (startsecs)
web_1 | 2018-06-14 16:29:02,613 INFO success: apached entered RUNNING state, process has stayed up for > than 0 seconds (startsecs)
web_1 | 2018-06-14 16:29:02,613 INFO success: crond entered RUNNING state, process has stayed up for > than 0 seconds (startsecs)
web_1 | 2018-06-14 16:29:02,613 INFO success: postfixd entered RUNNING state, process has stayed up for > than 0 seconds (startsecs)
web_1 | 2018-06-14 16:29:02,614 INFO success: sshd entered RUNNING state, process has stayed up for > than 0 seconds (startsecs)
web_1 | -> Executing /opt/docker/bin/service.d/cron.d//10-init.sh
web_1 | -> Executing /opt/docker/bin/service.d/ssh.d//10-init.sh
web_1 | -> Executing /opt/docker/bin/service.d/postfix.d//10-init.sh
web_1 | [SYSLOG] syslog-ng[58]: syslog-ng starting up; version='3.5.6'
web_1 | [SYSLOG] cron[61]: (CRON) INFO (pidfile fd = 3)
web_1 | [SYSLOG] cron[61]: (CRON) INFO (Running @reboot jobs)
web_1 | Error: No files specified
web_1 | Command: go-replace --mode=line --regex -s ^[\s]*myhostname[\s]*=.* -r myhostname = eb4aaa9ff6da
web_1 | [Thu Jun 14 16:29:02.791477 2018] [mpm_event:notice] [pid 60:tid 140690856716160] AH00489: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g configured -- resuming normal operations
web_1 | [Thu Jun 14 16:29:02.791618 2018] [core:notice] [pid 60:tid 140690856716160] AH00094: Command line: 'apache2 -D FOREGROUND -D APACHE_LOCK_DIR'
web_1 | [14-Jun-2018 16:29:02] NOTICE: fpm is running, pid 59
web_1 | [14-Jun-2018 16:29:02] NOTICE: ready to handle connections
web_1 | [14-Jun-2018 16:29:02] NOTICE: systemd monitor interval set to 10000ms
web_1 | 2018-06-14 16:29:03,812 INFO success: syslogd entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
web_1 | [SYSLOG] postfix[174]: Postfix is running with backwards-compatible default settings
web_1 | [SYSLOG] postfix[174]: See http://www.postfix.org/COMPATIBILITY_README.html for details
web_1 | [SYSLOG] postfix[174]: To disable backwards compatibility use "postconf compatibility_level=2" and "postfix reload"
web_1 | [SYSLOG] postfix/postfix-script[240]: warning: group or other writable: /usr/lib/postfix/./libpostfix-util.so.1
web_1 | [SYSLOG] postfix/postfix-script[241]: warning: group or other writable: /usr/lib/postfix/./libpostfix-tls.so.1
web_1 | [SYSLOG] postfix/postfix-script[242]: warning: group or other writable: /usr/lib/postfix/./sbin/lmtp
web_1 | [SYSLOG] postfix/postfix-script[243]: warning: group or other writable: /usr/lib/postfix/./libpostfix-master.so.1
web_1 | [SYSLOG] postfix/postfix-script[244]: warning: group or other writable: /usr/lib/postfix/./libpostfix-global.so.1
web_1 | [SYSLOG] postfix/postfix-script[245]: warning: group or other writable: /usr/lib/postfix/./libpostfix-dns.so.1
web_1 | [SYSLOG] postfix/postfix-script[246]: warning: group or other writable: /usr/lib/postfix/sbin/./lmtp
web_1 | [SYSLOG] postfix/postfix-script[270]: starting the Postfix mail system
web_1 | [SYSLOG] postfix/master[272]: daemon started -- version 3.1.0, configuration /etc/postfix
web_1 | 2018-06-14 16:34:37,453 WARN received SIGTERM indicating exit request
web_1 | 2018-06-14 16:34:37,453 INFO waiting for postfixd, php-fpmd, crond, syslogd, sshd, apached to die
web_1 | 2018-06-14 16:34:37,454 INFO stopped: sshd (exit status 0)
web_1 | [SYSLOG] postfix[604]: Postfix is running with backwards-compatible default settings
web_1 | [SYSLOG] postfix[604]: See http://www.postfix.org/COMPATIBILITY_README.html for details
web_1 | [SYSLOG] postfix[604]: To disable backwards compatibility use "postconf compatibility_level=2" and "postfix reload"
web_1 | [SYSLOG] postfix/postfix-script[610]: stopping the Postfix mail system
web_1 | [SYSLOG] postfix/master[272]: terminating on signal 15
web_1 | 2018-06-14 16:34:38,543 INFO reaped unknown pid 272
web_1 | 2018-06-14 16:34:38,543 INFO reaped unknown pid 273
web_1 | 2018-06-14 16:34:38,543 INFO reaped unknown pid 275
web_1 | 2018-06-14 16:34:38,549 INFO stopped: postfixd (exit status 0)
web_1 | 2018-06-14 16:34:38,550 INFO stopped: crond (terminated by SIGTERM)
web_1 | [Thu Jun 14 16:34:39.570004 2018] [mpm_event:notice] [pid 60:tid 140690856716160] AH00491: caught SIGTERM, shutting down
web_1 | 2018-06-14 16:34:39,583 INFO stopped: apached (exit status 0)
web_1 | [14-Jun-2018 16:34:39] NOTICE: Terminating ...
web_1 | [14-Jun-2018 16:34:39] NOTICE: exiting, bye-bye!
web_1 | 2018-06-14 16:34:39,596 INFO stopped: php-fpmd (exit status 0)
web_1 | 2018-06-14 16:34:40,597 INFO waiting for syslogd to die
web_1 | [SYSLOG] syslog-ng[58]: syslog-ng shutting down; version='3.5.6'
web_1 | 2018-06-14 16:34:40,699 INFO stopped: syslogd (exit status 0)
web_1 | -> Executing /opt/docker/provision/entrypoint.d/05-permissions.sh
web_1 | -> Executing /opt/docker/provision/entrypoint.d/10-php-debugger.sh
web_1 | PHP-Debugger: Xdebug enabled
web_1 | - Removing PHP module blackfire
web_1 | -> Executing /opt/docker/provision/entrypoint.d/20-apache-dev.sh
web_1 | -> Executing /opt/docker/provision/entrypoint.d/20-apache.sh
web_1 | -> Executing /opt/docker/provision/entrypoint.d/20-php-fpm.sh
web_1 | -> Executing /opt/docker/provision/entrypoint.d/20-php.sh
web_1 | -> Executing /opt/docker/bin/service.d/supervisor.d//10-init.sh
web_1 | 2018-06-14 16:34:59,392 CRIT Set uid to user 0
web_1 | 2018-06-14 16:34:59,392 WARN Included extra file "/opt/docker/etc/supervisor.d/apache.conf" during parsing
web_1 | 2018-06-14 16:34:59,393 WARN Included extra file "/opt/docker/etc/supervisor.d/blackfire-agent.conf" during parsing
web_1 | 2018-06-14 16:34:59,393 WARN Included extra file "/opt/docker/etc/supervisor.d/cron.conf" during parsing
web_1 | 2018-06-14 16:34:59,393 WARN Included extra file "/opt/docker/etc/supervisor.d/dnsmasq.conf" during parsing
web_1 | 2018-06-14 16:34:59,393 WARN Included extra file "/opt/docker/etc/supervisor.d/php-fpm.conf" during parsing
web_1 | 2018-06-14 16:34:59,393 WARN Included extra file "/opt/docker/etc/supervisor.d/postfix.conf" during parsing
web_1 | 2018-06-14 16:34:59,393 WARN Included extra file "/opt/docker/etc/supervisor.d/ssh.conf" during parsing
web_1 | 2018-06-14 16:34:59,394 WARN Included extra file "/opt/docker/etc/supervisor.d/syslog.conf" during parsing
web_1 | 2018-06-14 16:34:59,405 INFO RPC interface 'supervisor' initialized
web_1 | 2018-06-14 16:34:59,405 INFO supervisord started with pid 1
web_1 | 2018-06-14 16:35:00,408 INFO spawned: 'syslogd' with pid 58
web_1 | 2018-06-14 16:35:00,409 INFO spawned: 'php-fpmd' with pid 59
web_1 | 2018-06-14 16:35:00,411 INFO spawned: 'apached' with pid 60
web_1 | 2018-06-14 16:35:00,412 INFO spawned: 'crond' with pid 61
web_1 | 2018-06-14 16:35:00,414 INFO spawned: 'postfixd' with pid 63
web_1 | 2018-06-14 16:35:00,416 INFO spawned: 'sshd' with pid 64
web_1 | -> Executing /opt/docker/bin/service.d/syslog-ng.d//10-init.sh
web_1 | 2018-06-14 16:35:00,417 INFO success: php-fpmd entered RUNNING state, process has stayed up for > than 0 seconds (startsecs)
web_1 | 2018-06-14 16:35:00,418 INFO success: apached entered RUNNING state, process has stayed up for > than 0 seconds (startsecs)
web_1 | 2018-06-14 16:35:00,418 INFO success: crond entered RUNNING state, process has stayed up for > than 0 seconds (startsecs)
web_1 | 2018-06-14 16:35:00,418 INFO success: postfixd entered RUNNING state, process has stayed up for > than 0 seconds (startsecs)
web_1 | 2018-06-14 16:35:00,422 INFO success: sshd entered RUNNING state, process has stayed up for > than 0 seconds (startsecs)
web_1 | -> Executing /opt/docker/bin/service.d/php-fpm.d//10-init.sh
web_1 | Setting php-fpm user to application
web_1 | -> Executing /opt/docker/bin/service.d/httpd.d//10-init.sh
web_1 | -> Executing /opt/docker/bin/service.d/postfix.d//10-init.sh
web_1 | -> Executing /opt/docker/bin/service.d/cron.d//10-init.sh
web_1 | -> Executing /opt/docker/bin/service.d/ssh.d//10-init.sh
web_1 | Error: No files specified
web_1 | Command: go-replace --mode=line --regex -s ^[\s]*myhostname[\s]*=.* -r myhostname = eb4aaa9ff6da
web_1 | [SYSLOG] syslog-ng[58]: syslog-ng starting up; version='3.5.6'
web_1 | [Thu Jun 14 16:35:00.507087 2018] [mpm_event:notice] [pid 60:tid 140570790606720] AH00489: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g configured -- resuming normal operations
web_1 | [Thu Jun 14 16:35:00.507297 2018] [core:notice] [pid 60:tid 140570790606720] AH00094: Command line: 'apache2 -D FOREGROUND -D APACHE_LOCK_DIR'
web_1 | [14-Jun-2018 16:35:00] NOTICE: fpm is running, pid 59
web_1 | [14-Jun-2018 16:35:00] NOTICE: ready to handle connections
web_1 | [14-Jun-2018 16:35:00] NOTICE: systemd monitor interval set to 10000ms
web_1 | 2018-06-14 16:35:01,532 INFO success: syslogd entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
web_1 | [SYSLOG] postfix[175]: Postfix is running with backwards-compatible default settings
web_1 | [SYSLOG] postfix[175]: See http://www.postfix.org/COMPATIBILITY_README.html for details
web_1 | [SYSLOG] postfix[175]: To disable backwards compatibility use "postconf compatibility_level=2" and "postfix reload"
web_1 | [SYSLOG] postfix/postfix-script[250]: warning: group or other writable: /usr/lib/postfix/./libpostfix-util.so.1
web_1 | [SYSLOG] postfix/postfix-script[251]: warning: group or other writable: /usr/lib/postfix/./libpostfix-tls.so.1
web_1 | [SYSLOG] postfix/postfix-script[252]: warning: group or other writable: /usr/lib/postfix/./sbin/lmtp
web_1 | [SYSLOG] postfix/postfix-script[253]: warning: group or other writable: /usr/lib/postfix/./libpostfix-master.so.1
web_1 | [SYSLOG] postfix/postfix-script[254]: warning: group or other writable: /usr/lib/postfix/./libpostfix-global.so.1
web_1 | [SYSLOG] postfix/postfix-script[255]: warning: group or other writable: /usr/lib/postfix/./libpostfix-dns.so.1
web_1 | [SYSLOG] postfix/postfix-script[256]: warning: group or other writable: /usr/lib/postfix/sbin/./lmtp
web_1 | [SYSLOG] postfix/postfix-script[280]: starting the Postfix mail system
web_1 | [SYSLOG] postfix/master[282]: daemon started -- version 3.1.0, configuration /etc/postfix
web_1 | 2018-06-14 16:35:10,320 WARN received SIGTERM indicating exit request
web_1 | 2018-06-14 16:35:10,321 INFO waiting for postfixd, php-fpmd, crond, syslogd, sshd, apached to die
web_1 | 2018-06-14 16:35:10,322 INFO stopped: sshd (exit status 0)
web_1 | [SYSLOG] postfix[309]: Postfix is running with backwards-compatible default settings
web_1 | [SYSLOG] postfix[309]: See http://www.postfix.org/COMPATIBILITY_README.html for details
web_1 | [SYSLOG] postfix[309]: To disable backwards compatibility use "postconf compatibility_level=2" and "postfix reload"
db-configure_1 | Master_User: repl
db-configure_1 | Master_Port: 3306
db-configure_1 | Connect_Retry: 60
db-configure_1 | Master_Log_File: mysql-bin.000003
db-configure_1 | Read_Master_Log_Pos: 768
db-configure_1 | Relay_Log_File: mysqld-relay-bin.000002
db-configure_1 | Relay_Log_Pos: 555
db-configure_1 | Relay_Master_Log_File: mysql-bin.000003
db-configure_1 | Slave_IO_Running: Yes
db-configure_1 | Slave_SQL_Running: Yes
db-configure_1 | Replicate_Do_DB:
db-configure_1 | Replicate_Ignore_DB:
db-configure_1 | Replicate_Do_Table:
db-configure_1 | Replicate_Ignore_Table:
db-configure_1 | Replicate_Wild_Do_Table:
db-configure_1 | Replicate_Wild_Ignore_Table:
db-configure_1 | Last_Errno: 0
db-configure_1 | Last_Error:
db-configure_1 | Skip_Counter: 0
db-configure_1 | Exec_Master_Log_Pos: 768
db-configure_1 | Relay_Log_Space: 865
db-configure_1 | Until_Condition: None
db-configure_1 | Until_Log_File:
db-configure_1 | Until_Log_Pos: 0
db-configure_1 | Master_SSL_Allowed: No
db-configure_1 | Master_SSL_CA_File:
db-configure_1 | Master_SSL_CA_Path:
db-configure_1 | Master_SSL_Cert:
db-configure_1 | Master_SSL_Cipher:
db-configure_1 | Master_SSL_Key:
db-configure_1 | Seconds_Behind_Master: 0
db-configure_1 | Master_SSL_Verify_Server_Cert: No
db-configure_1 | Last_IO_Errno: 0
db-configure_1 | Last_IO_Error:
db-configure_1 | Last_SQL_Errno: 0
db-configure_1 | Last_SQL_Error:
db-configure_1 | Replicate_Ignore_Server_Ids:
db-configure_1 | Master_Server_Id: 1
db-configure_1 | Master_SSL_Crl:
db-configure_1 | Master_SSL_Crlpath:
web_1 | [SYSLOG] postfix/postfix-script[315]: stopping the Postfix mail system
web_1 | [SYSLOG] postfix/master[282]: terminating on signal 15
web_1 | 2018-06-14 16:35:10,940 INFO reaped unknown pid 282
web_1 | 2018-06-14 16:35:10,940 INFO reaped unknown pid 283
web_1 | 2018-06-14 16:35:10,940 INFO reaped unknown pid 284
web_1 | 2018-06-14 16:35:10,950 INFO stopped: postfixd (exit status 0)
web_1 | 2018-06-14 16:35:10,951 INFO stopped: crond (terminated by SIGTERM)
web_1 | [Thu Jun 14 16:35:11.971320 2018] [mpm_event:notice] [pid 60:tid 140570790606720] AH00491: caught SIGTERM, shutting down
web_1 | 2018-06-14 16:35:11,985 INFO stopped: apached (exit status 0)
web_1 | [14-Jun-2018 16:35:11] NOTICE: Terminating ...
web_1 | [14-Jun-2018 16:35:11] NOTICE: exiting, bye-bye!
web_1 | 2018-06-14 16:35:11,999 INFO stopped: php-fpmd (exit status 0)
web_1 | [SYSLOG] syslog-ng[58]: syslog-ng shutting down; version='3.5.6'
web_1 | 2018-06-14 16:35:13,104 INFO stopped: syslogd (exit status 0)
web_1 | -> Executing /opt/docker/provision/entrypoint.d/05-permissions.sh
web_1 | -> Executing /opt/docker/provision/entrypoint.d/10-php-debugger.sh
web_1 | PHP-Debugger: Xdebug enabled
web_1 | - Removing PHP module blackfire
web_1 | -> Executing /opt/docker/provision/entrypoint.d/20-apache-dev.sh
web_1 | -> Executing /opt/docker/provision/entrypoint.d/20-apache.sh
web_1 | -> Executing /opt/docker/provision/entrypoint.d/20-php-fpm.sh
web_1 | -> Executing /opt/docker/provision/entrypoint.d/20-php.sh
web_1 | -> Executing /opt/docker/bin/service.d/supervisor.d//10-init.sh
web_1 | 2018-06-14 16:35:21,795 CRIT Set uid to user 0
web_1 | 2018-06-14 16:35:21,795 WARN Included extra file "/opt/docker/etc/supervisor.d/apache.conf" during parsing
web_1 | 2018-06-14 16:35:21,795 WARN Included extra file "/opt/docker/etc/supervisor.d/blackfire-agent.conf" during parsing
web_1 | 2018-06-14 16:35:21,795 WARN Included extra file "/opt/docker/etc/supervisor.d/cron.conf" during parsing
web_1 | 2018-06-14 16:35:21,795 WARN Included extra file "/opt/docker/etc/supervisor.d/dnsmasq.conf" during parsing
web_1 | 2018-06-14 16:35:21,795 WARN Included extra file "/opt/docker/etc/supervisor.d/php-fpm.conf" during parsing
db-configure_1 | Using_Gtid: No
db-configure_1 | Gtid_IO_Pos:
db-configure_1 | Replicate_Do_Domain_Ids:
db-configure_1 | Replicate_Ignore_Domain_Ids:
db-configure_1 | Parallel_Mode: conservative
db-configure_1 | SQL_Delay: 0
db-configure_1 | SQL_Remaining_Delay: NULL
db-configure_1 | Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
db-configure_1 | Slave_DDL_Groups: 0
db-configure_1 | Slave_Non_Transactional_Groups: 0
db-configure_1 | Slave_Transactional_Groups: 0
db-configure_1 | + echo 'MySQL servers created!'
db-configure_1 | + echo --------------------
db-configure_1 | + echo
db-configure_1 | MySQL servers created!
db-configure_1 | --------------------
db-configure_1 |
db-configure_1 | + echo Variables available fo you :-
db-configure_1 | + echo
db-configure_1 | + echo MYSQL01_IP : db-master
db-configure_1 | Variables available fo you :-
db-configure_1 |
db-configure_1 | MYSQL01_IP : db-master
db-configure_1 | + echo MYSQL02_IP : db-slave
db-configure_1 | MYSQL02_IP : db-slave
db-configure_1 | ++ dirname /tmp/mysql_connector.sh
db-configure_1 | + BASE_PATH=/tmp
db-configure_1 | + echo 'Waiting for mysql to get up'
db-configure_1 | + /tmp/wait-for-it.sh db-master:3306
db-configure_1 | Waiting for mysql to get up
db-configure_1 | wait-for-it.sh: waiting 15 seconds for db-master:3306
db-configure_1 | wait-for-it.sh: db-master:3306 is available after 0 seconds
db-configure_1 | + /tmp/wait-for-it.sh db-slave:3306
db-configure_1 | wait-for-it.sh: waiting 15 seconds for db-slave:3306
db-configure_1 | wait-for-it.sh: db-slave:3306 is available after 0 seconds
db-configure_1 | + /tmp/wait-for-it.sh db-master:3306
db-configure_1 | wait-for-it.sh: waiting 15 seconds for db-master:3306
db-configure_1 | wait-for-it.sh: db-master:3306 is available after 0 seconds
db-configure_1 | + /tmp/wait-for-it.sh db-slave:3306
db-configure_1 | wait-for-it.sh: waiting 15 seconds for db-slave:3306
db-configure_1 | wait-for-it.sh: db-slave:3306 is available after 0 seconds
db-configure_1 | + echo 'Create MySQL Servers (master / slave repl)'
web_1 | 2018-06-14 16:35:21,796 WARN Included extra file "/opt/docker/etc/supervisor.d/postfix.conf" during parsing
web_1 | 2018-06-14 16:35:21,796 WARN Included extra file "/opt/docker/etc/supervisor.d/ssh.conf" during parsing
web_1 | 2018-06-14 16:35:21,796 WARN Included extra file "/opt/docker/etc/supervisor.d/syslog.conf" during parsing
web_1 | 2018-06-14 16:35:21,806 INFO RPC interface 'supervisor' initialized
web_1 | 2018-06-14 16:35:21,807 INFO supervisord started with pid 1
web_1 | 2018-06-14 16:35:22,810 INFO spawned: 'syslogd' with pid 58
web_1 | 2018-06-14 16:35:22,812 INFO spawned: 'php-fpmd' with pid 59
web_1 | 2018-06-14 16:35:22,813 INFO spawned: 'apached' with pid 60
web_1 | 2018-06-14 16:35:22,815 INFO spawned: 'crond' with pid 61
web_1 | 2018-06-14 16:35:22,819 INFO spawned: 'postfixd' with pid 63
web_1 | 2018-06-14 16:35:22,820 INFO spawned: 'sshd' with pid 65
web_1 | -> Executing /opt/docker/bin/service.d/syslog-ng.d//10-init.sh
web_1 | -> Executing /opt/docker/bin/service.d/php-fpm.d//10-init.sh
web_1 | Setting php-fpm user to application
web_1 | -> Executing /opt/docker/bin/service.d/httpd.d//10-init.sh
web_1 | 2018-06-14 16:35:22,831 INFO success: php-fpmd entered RUNNING state, process has stayed up for > than 0 seconds (startsecs)
web_1 | 2018-06-14 16:35:22,831 INFO success: apached entered RUNNING state, process has stayed up for > than 0 seconds (startsecs)
web_1 | 2018-06-14 16:35:22,831 INFO success: crond entered RUNNING state, process has stayed up for > than 0 seconds (startsecs)
web_1 | 2018-06-14 16:35:22,831 INFO success: postfixd entered RUNNING state, process has stayed up for > than 0 seconds (startsecs)
web_1 | 2018-06-14 16:35:22,831 INFO success: sshd entered RUNNING state, process has stayed up for > than 0 seconds (startsecs)
web_1 | -> Executing /opt/docker/bin/service.d/ssh.d//10-init.sh
web_1 | -> Executing /opt/docker/bin/service.d/postfix.d//10-init.sh
web_1 | -> Executing /opt/docker/bin/service.d/cron.d//10-init.sh
web_1 | [SYSLOG] syslog-ng[58]: syslog-ng starting up; version='3.5.6'
web_1 | [Thu Jun 14 16:35:22.882103 2018] [mpm_event:notice] [pid 60:tid 140672859563904] AH00489: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g configured -- resuming normal operations
web_1 | [Thu Jun 14 16:35:22.882487 2018] [core:notice] [pid 60:tid 140672859563904] AH00094: Command line: 'apache2 -D FOREGROUND -D APACHE_LOCK_DIR'
web_1 | Error: No files specified
web_1 | Command: go-replace --mode=line --regex -s ^[\s]*myhostname[\s]*=.* -r myhostname = eb4aaa9ff6da
web_1 | [SYSLOG] cron[61]: (CRON) INFO (pidfile fd = 3)
web_1 | [SYSLOG] cron[61]: (CRON) INFO (Skipping @reboot jobs -- not system startup)
web_1 | [14-Jun-2018 16:35:22] NOTICE: fpm is running, pid 59
web_1 | [14-Jun-2018 16:35:22] NOTICE: ready to handle connections
web_1 | [14-Jun-2018 16:35:22] NOTICE: systemd monitor interval set to 10000ms
web_1 | 2018-06-14 16:35:23,912 INFO success: syslogd entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
web_1 | [SYSLOG] postfix[152]: Postfix is running with backwards-compatible default settings
web_1 | [SYSLOG] postfix[152]: See http://www.postfix.org/COMPATIBILITY_README.html for details
web_1 | [SYSLOG] postfix[152]: To disable backwards compatibility use "postconf compatibility_level=2" and "postfix reload"
web_1 | [SYSLOG] postfix/postfix-script[208]: warning: group or other writable: /usr/lib/postfix/./libpostfix-util.so.1
web_1 | [SYSLOG] postfix/postfix-script[209]: warning: group or other writable: /usr/lib/postfix/./libpostfix-tls.so.1
web_1 | [SYSLOG] postfix/postfix-script[210]: warning: group or other writable: /usr/lib/postfix/./sbin/lmtp
web_1 | [SYSLOG] postfix/postfix-script[211]: warning: group or other writable: /usr/lib/postfix/./libpostfix-master.so.1
web_1 | [SYSLOG] postfix/postfix-script[212]: warning: group or other writable: /usr/lib/postfix/./libpostfix-global.so.1
web_1 | [SYSLOG] postfix/postfix-script[213]: warning: group or other writable: /usr/lib/postfix/./libpostfix-dns.so.1
web_1 | [SYSLOG] postfix/postfix-script[214]: warning: group or other writable: /usr/lib/postfix/sbin/./lmtp
web_1 | [SYSLOG] postfix/postfix-script[238]: starting the Postfix mail system
web_1 | [SYSLOG] postfix/master[240]: daemon started -- version 3.1.0, configuration /etc/postfix
web_1 | [SYSLOG] CRON[374]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && /usr/lib/php/sessionclean)
db-configure_1 | + echo -----------------
db-configure_1 | Create MySQL Servers (master / slave repl)
db-configure_1 | -----------------
db-configure_1 | + echo '* Create replication user'
db-configure_1 | + mysql --host db-slave -uroot -ptoor -AN -e 'STOP SLAVE;'
db-configure_1 | * Create replication user
db-configure_1 | + mysql --host db-slave -uroot -ptoor -AN -e 'RESET SLAVE ALL;'
db-configure_1 | + mysql --host db-master -uroot -ptoor -AN -e 'CREATE USER '\''repl'\''@'\''%'\'';'
db-configure_1 | ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'repl'@'%'
db-configure_1 | + mysql --host db-master -uroot -ptoor -AN -e 'GRANT REPLICATION SLAVE ON *.* TO '\''repl'\''@'\''%'\'' IDENTIFIED BY '\''repl'\'';'
db-configure_1 | + mysql --host db-master -uroot -ptoor -AN -e 'flush privileges;'
db-configure_1 | + echo '* Set MySQL01 as master on MySQL02'
db-configure_1 | * Set MySQL01 as master on MySQL02
db-configure_1 | ++ eval 'mysql --host db-master -uroot -ptoor -e '\''show master status \G'\'' | grep Position | sed -n -e '\''s/^.*: //p'\'''
db-configure_1 | +++ mysql --host db-master -uroot -ptoor -e 'show master status \G'
db-configure_1 | +++ grep Position
db-configure_1 | +++ sed -n -e 's/^.*: //p'
db-configure_1 | + MYSQL01_Position=112038
db-configure_1 | ++ eval 'mysql --host db-master -uroot -ptoor -e '\''show master status \G'\'' | grep File | sed -n -e '\''s/^.*: //p'\'''
db-configure_1 | +++ mysql --host db-master -uroot -ptoor -e 'show master status \G'
db-configure_1 | +++ grep File
db-configure_1 | +++ sed -n -e 's/^.*: //p'
db-configure_1 | + MYSQL01_File=mysql-bin.000003
db-configure_1 | ++ eval 'getent hosts db-master|awk '\''{print $1}'\'''
db-configure_1 | +++ getent hosts db-master
db-configure_1 | +++ awk '{print $1}'
db-configure_1 | + MASTER_IP=172.18.0.2
db-configure_1 | 172.18.0.2
db-configure_1 | + echo 172.18.0.2
db-configure_1 | + mysql --host db-slave -uroot -ptoor -AN -e 'CHANGE MASTER TO master_host='\''db-master'\'', master_port=3306, master_user='\''repl'\'', master_password='\''repl'\'', master_log_file='\''mysql-bin.000003'\'', master_log_pos=112038;'
db-configure_1 | + echo '* Set MySQL02 as master on MySQL01'
db-configure_1 | * Set MySQL02 as master on MySQL01
db-configure_1 | ++ eval 'mysql --host db-slave -uroot -ptoor -e '\''show master status \G'\'' | grep Position | sed -n -e '\''s/^.*: //p'\'''
db-configure_1 | +++ mysql --host db-slave -uroot -ptoor -e 'show master status \G'
db-configure_1 | +++ sed -n -e 's/^.*: //p'
db-configure_1 | +++ grep Position
db-configure_1 | + MYSQL02_Position=110894
db-configure_1 | ++ eval 'mysql --host db-slave -uroot -ptoor -e '\''show master status \G'\'' | grep File | sed -n -e '\''s/^.*: //p'\'''
db-configure_1 | +++ mysql --host db-slave -uroot -ptoor -e 'show master status \G'
db-configure_1 | +++ sed -n -e 's/^.*: //p'
db-configure_1 | +++ grep File
db-configure_1 | + MYSQL02_File=mysql-bin.000003
db-configure_1 | ++ eval 'getent hosts db-slave|awk '\''{print $1}'\'''
db-configure_1 | +++ getent hosts db-slave
db-configure_1 | +++ awk '{print $1}'
db-configure_1 | + SLAVE_IP=172.18.0.3
db-configure_1 | + echo 172.18.0.3
db-configure_1 | 172.18.0.3
db-configure_1 | + mysql --host db-master -uroot -ptoor -AN -e 'CHANGE MASTER TO master_host='\''db-slave'\'', master_port=3306, master_user='\''repl'\'', master_password='\''repl'\'', master_log_file='\''mysql-bin.000003'\'', master_log_pos=110894;'
db-configure_1 | + echo '* Start Slave on both Servers'
db-configure_1 | * Start Slave on both Servers
db-configure_1 | + mysql --host db-slave -uroot -ptoor -AN -e 'start slave;'
db-configure_1 | + echo 'Increase the max_connections to 2000'
db-configure_1 | + mysql --host db-master -uroot -ptoor -AN -e 'set GLOBAL max_connections=2000'
db-configure_1 | Increase the max_connections to 2000
db-configure_1 | + mysql --host db-slave -uroot -ptoor -AN -e 'set GLOBAL max_connections=2000'
db-configure_1 | + mysql --host db-slave -uroot -ptoor -e 'show slave status \G'
db-configure_1 | *************************** 1. row ***************************
db-configure_1 | Slave_IO_State: Waiting for master to send event
db-configure_1 | Master_Host: db-master
db-configure_1 | Master_User: repl
db-configure_1 | Master_Port: 3306
db-configure_1 | Connect_Retry: 60
db-configure_1 | Master_Log_File: mysql-bin.000003
db-configure_1 | Read_Master_Log_Pos: 112038
db-configure_1 | Relay_Log_File: mysqld-relay-bin.000002
db-configure_1 | Relay_Log_Pos: 555
db-configure_1 | Relay_Master_Log_File: mysql-bin.000003
db-configure_1 | Slave_IO_Running: Yes
db-configure_1 | Slave_SQL_Running: Yes
db-configure_1 | Replicate_Do_DB:
db-configure_1 | Replicate_Ignore_DB:
db-configure_1 | Replicate_Do_Table:
db-configure_1 | Replicate_Ignore_Table:
db-configure_1 | Replicate_Wild_Do_Table:
db-configure_1 | Replicate_Wild_Ignore_Table:
db-configure_1 | Last_Errno: 0
db-configure_1 | Last_Error:
db-configure_1 | Skip_Counter: 0
db-configure_1 | Exec_Master_Log_Pos: 112038
db-configure_1 | Relay_Log_Space: 865
db-configure_1 | Until_Condition: None
db-configure_1 | Until_Log_File:
db-configure_1 | Until_Log_Pos: 0
db-configure_1 | Master_SSL_Allowed: No
db-configure_1 | Master_SSL_CA_File:
db-configure_1 | Master_SSL_CA_Path:
db-configure_1 | Master_SSL_Cert:
db-configure_1 | Master_SSL_Cipher:
db-configure_1 | Master_SSL_Key:
db-configure_1 | Seconds_Behind_Master: 0
db-configure_1 | Master_SSL_Verify_Server_Cert: No
db-configure_1 | Last_IO_Errno: 0
db-configure_1 | Last_IO_Error:
db-configure_1 | Last_SQL_Errno: 0
db-configure_1 | Last_SQL_Error:
db-configure_1 | Replicate_Ignore_Server_Ids:
db-configure_1 | Master_Server_Id: 1
db-configure_1 | Master_SSL_Crl:
db-configure_1 | Master_SSL_Crlpath:
db-configure_1 | Using_Gtid: No
db-configure_1 | Gtid_IO_Pos:
db-configure_1 | Replicate_Do_Domain_Ids:
db-configure_1 | Replicate_Ignore_Domain_Ids:
db-configure_1 | Parallel_Mode: conservative
db-configure_1 | SQL_Delay: 0
db-configure_1 | SQL_Remaining_Delay: NULL
db-configure_1 | Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
db-configure_1 | Slave_DDL_Groups: 226
db-configure_1 | Slave_Non_Transactional_Groups: 1
db-configure_1 | Slave_Transactional_Groups: 58
db-configure_1 | + echo 'MySQL servers created!'
db-configure_1 | + echo --------------------
db-configure_1 | + echo
db-configure_1 | + echo Variables available fo you :-
db-configure_1 | + echo
db-configure_1 | + echo MYSQL01_IP : db-master
db-configure_1 | MySQL servers created!
db-configure_1 | --------------------
db-configure_1 |
db-configure_1 | Variables available fo you :-
db-configure_1 |
db-configure_1 | MYSQL01_IP : db-master
db-configure_1 | + echo MYSQL02_IP : db-slave
db-configure_1 | MYSQL02_IP : db-slave
db-configure_1 | ++ dirname /tmp/mysql_connector.sh
db-configure_1 | + BASE_PATH=/tmp
db-configure_1 | + echo 'Waiting for mysql to get up'
db-configure_1 | Waiting for mysql to get up
db-configure_1 | + /tmp/wait-for-it.sh db-master:3306
db-configure_1 | wait-for-it.sh: waiting 15 seconds for db-master:3306
db-configure_1 | wait-for-it.sh: db-master:3306 is available after 0 seconds
db-configure_1 | + /tmp/wait-for-it.sh db-slave:3306
db-configure_1 | wait-for-it.sh: waiting 15 seconds for db-slave:3306
db-configure_1 | wait-for-it.sh: db-slave:3306 is available after 1 seconds
db-configure_1 | + /tmp/wait-for-it.sh db-master:3306
db-configure_1 | wait-for-it.sh: waiting 15 seconds for db-master:3306
db-configure_1 | wait-for-it.sh: db-master:3306 is available after 0 seconds
db-configure_1 | + /tmp/wait-for-it.sh db-slave:3306
db-configure_1 | wait-for-it.sh: waiting 15 seconds for db-slave:3306
db-configure_1 | wait-for-it.sh: db-slave:3306 is available after 0 seconds
db-configure_1 | + echo 'Create MySQL Servers (master / slave repl)'
db-configure_1 | + echo -----------------
db-configure_1 | Create MySQL Servers (master / slave repl)
db-configure_1 | -----------------
db-configure_1 | + echo '* Create replication user'
db-configure_1 | * Create replication user
db-configure_1 | + mysql --host db-slave -uroot -ptoor -AN -e 'STOP SLAVE;'
db-configure_1 | + mysql --host db-slave -uroot -ptoor -AN -e 'RESET SLAVE ALL;'
db-configure_1 | + mysql --host db-master -uroot -ptoor -AN -e 'CREATE USER '\''repl'\''@'\''%'\'';'
db-configure_1 | ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'repl'@'%'
db-configure_1 | + mysql --host db-master -uroot -ptoor -AN -e 'GRANT REPLICATION SLAVE ON *.* TO '\''repl'\''@'\''%'\'' IDENTIFIED BY '\''repl'\'';'
db-configure_1 | + mysql --host db-master -uroot -ptoor -AN -e 'flush privileges;'
db-configure_1 | + echo '* Set MySQL01 as master on MySQL02'
db-configure_1 | * Set MySQL01 as master on MySQL02
db-slave_1 | Initializing database
db-slave_1 | 2018-06-14 16:29:01 6 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
db-slave_1 |
db-slave_1 | PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
db-slave_1 | To do so, start the server, then issue the following commands:
db-slave_1 |
db-slave_1 | '/usr/bin/mysqladmin' -u root password 'new-password'
db-slave_1 | '/usr/bin/mysqladmin' -u root -h password 'new-password'
db-slave_1 |
db-slave_1 | Alternatively you can run:
db-slave_1 | '/usr/bin/mysql_secure_installation'
db-slave_1 |
db-slave_1 | which will also give you the option of removing the test
db-slave_1 | databases and anonymous user created by default. This is
db-slave_1 | strongly recommended for production servers.
db-slave_1 |
db-slave_1 | See the MariaDB Knowledgebase at http://mariadb.com/kb or the
db-slave_1 | MySQL manual for more instructions.
db-slave_1 |
db-slave_1 | Please report any problems at http://mariadb.org/jira
db-slave_1 |
db-slave_1 | The latest information about MariaDB is available at http://mariadb.org/.
db-slave_1 | You can find additional information about the MySQL part at:
db-slave_1 | http://dev.mysql.com
db-slave_1 | Consider joining MariaDB's strong and vibrant community:
db-slave_1 | https://mariadb.org/get-involved/
db-slave_1 |
db-slave_1 | Database initialized
db-slave_1 | MySQL init process in progress...
db-slave_1 | 2018-06-14 16:29:03 0 [Note] mysqld (mysqld 10.3.7-MariaDB-1:10.3.7+maria~jessie-log) starting as process 103 ...
db-slave_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Using Linux native AIO
db-slave_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
db-slave_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Uses event mutexes
db-slave_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
db-slave_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Number of pools: 1
db-slave_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Using SSE2 crc32 instructions
db-slave_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
db-slave_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Completed initialization of buffer pool
db-slave_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
db-slave_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
db-slave_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
db-slave_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
db-slave_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
db-slave_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Waiting for purge to start
db-slave_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: 10.3.7 started; log sequence number 1630815; transaction id 21
db-slave_1 | 2018-06-14 16:29:03 0 [Note] Plugin 'FEEDBACK' is disabled.
db-slave_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
db-slave_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Buffer pool(s) load completed at 180614 16:29:03
db-slave_1 | 2018-06-14 16:29:03 0 [Warning] 'user' entry 'root@a69f1dff466d' ignored in --skip-name-resolve mode.
db-slave_1 | 2018-06-14 16:29:03 0 [Warning] 'user' entry '@a69f1dff466d' ignored in --skip-name-resolve mode.
db-slave_1 | 2018-06-14 16:29:03 0 [Warning] 'proxies_priv' entry '@% root@a69f1dff466d' ignored in --skip-name-resolve mode.
db-slave_1 | 2018-06-14 16:29:03 0 [Note] Reading of all Master_info entries succeded
db-slave_1 | 2018-06-14 16:29:03 0 [Note] Added new Master_info '' to hash table
db-slave_1 | 2018-06-14 16:29:03 0 [Note] mysqld: ready for connections.
db-slave_1 | Version: '10.3.7-MariaDB-1:10.3.7+maria~jessie-log' socket: '/var/run/mysqld/mysqld.sock' port: 0 mariadb.org binary distribution
db-slave_1 | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
db-slave_1 | 2018-06-14 16:29:07 11 [Warning] 'proxies_priv' entry '@% root@a69f1dff466d' ignored in --skip-name-resolve mode.
db-slave_1 |
db-slave_1 | 2018-06-14 16:29:07 0 [Note] mysqld (initiated by: unknown): Normal shutdown
db-slave_1 | 2018-06-14 16:29:07 0 [Note] InnoDB: FTS optimize thread exiting.
db-slave_1 | 2018-06-14 16:29:07 0 [Note] Event Scheduler: Purging the queue. 0 events
db-slave_1 | 2018-06-14 16:29:07 0 [Note] InnoDB: Starting shutdown...
db-slave_1 | 2018-06-14 16:29:07 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
db-slave_1 | 2018-06-14 16:29:07 0 [Note] InnoDB: Buffer pool(s) dump completed at 180614 16:29:07
db-slave_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Shutdown completed; log sequence number 1630824; transaction id 24
db-slave_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
db-slave_1 | 2018-06-14 16:29:08 0 [Note] mysqld: Shutdown complete
db-slave_1 |
db-slave_1 |
db-slave_1 | MySQL init process done. Ready for start up.
db-slave_1 |
db-slave_1 | 2018-06-14 16:29:08 0 [Note] mysqld (mysqld 10.3.7-MariaDB-1:10.3.7+maria~jessie-log) starting as process 1 ...
db-slave_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Using Linux native AIO
db-slave_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
db-slave_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Uses event mutexes
phpmyadmin_1 | 2018-06-14 16:29:01,249 CRIT Supervisor running as root (no user in config file)
phpmyadmin_1 | 2018-06-14 16:29:01,249 WARN Included extra file "/etc/supervisor.d/nginx.ini" during parsing
phpmyadmin_1 | 2018-06-14 16:29:01,249 WARN Included extra file "/etc/supervisor.d/php.ini" during parsing
phpmyadmin_1 | 2018-06-14 16:29:01,286 INFO RPC interface 'supervisor' initialized
phpmyadmin_1 | 2018-06-14 16:29:01,291 CRIT Server 'unix_http_server' running without any HTTP authentication checking
phpmyadmin_1 | 2018-06-14 16:29:01,291 INFO supervisord started with pid 1
phpmyadmin_1 | 2018-06-14 16:29:02,296 INFO spawned: 'php-fpm' with pid 19
phpmyadmin_1 | 2018-06-14 16:29:02,298 INFO spawned: 'nginx' with pid 20
phpmyadmin_1 | 2018-06-14 16:29:03,337 INFO success: php-fpm entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
phpmyadmin_1 | 2018-06-14 16:29:03,337 INFO success: nginx entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
phpmyadmin_1 | 2018-06-14 16:34:37,449 WARN received SIGTERM indicating exit request
phpmyadmin_1 | 2018-06-14 16:34:37,450 INFO waiting for nginx, php-fpm to die
phpmyadmin_1 | 2018-06-14 16:34:37,497 INFO stopped: nginx (exit status 0)
phpmyadmin_1 | 2018-06-14 16:34:37,507 INFO stopped: php-fpm (exit status 0)
phpmyadmin_1 | 2018-06-14 16:34:57,519 CRIT Supervisor running as root (no user in config file)
phpmyadmin_1 | 2018-06-14 16:34:57,520 WARN Included extra file "/etc/supervisor.d/nginx.ini" during parsing
phpmyadmin_1 | 2018-06-14 16:34:57,520 WARN Included extra file "/etc/supervisor.d/php.ini" during parsing
phpmyadmin_1 | 2018-06-14 16:34:57,539 INFO RPC interface 'supervisor' initialized
phpmyadmin_1 | 2018-06-14 16:34:57,540 CRIT Server 'unix_http_server' running without any HTTP authentication checking
phpmyadmin_1 | 2018-06-14 16:34:57,540 INFO supervisord started with pid 1
phpmyadmin_1 | 2018-06-14 16:34:58,545 INFO spawned: 'php-fpm' with pid 13
phpmyadmin_1 | 2018-06-14 16:34:58,555 INFO spawned: 'nginx' with pid 14
phpmyadmin_1 | 2018-06-14 16:34:59,634 INFO success: php-fpm entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
phpmyadmin_1 | 2018-06-14 16:34:59,634 INFO success: nginx entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
phpmyadmin_1 | 2018-06-14 16:35:10,322 WARN received SIGTERM indicating exit request
phpmyadmin_1 | 2018-06-14 16:35:10,322 INFO waiting for nginx, php-fpm to die
phpmyadmin_1 | 2018-06-14 16:35:10,397 INFO stopped: nginx (exit status 0)
phpmyadmin_1 | 2018-06-14 16:35:10,403 INFO stopped: php-fpm (exit status 0)
phpmyadmin_1 | 2018-06-14 16:35:20,247 CRIT Supervisor running as root (no user in config file)
phpmyadmin_1 | 2018-06-14 16:35:20,247 WARN Included extra file "/etc/supervisor.d/nginx.ini" during parsing
phpmyadmin_1 | 2018-06-14 16:35:20,247 WARN Included extra file "/etc/supervisor.d/php.ini" during parsing
phpmyadmin_1 | 2018-06-14 16:35:20,255 INFO RPC interface 'supervisor' initialized
phpmyadmin_1 | 2018-06-14 16:35:20,286 CRIT Server 'unix_http_server' running without any HTTP authentication checking
phpmyadmin_1 | 2018-06-14 16:35:20,286 INFO supervisord started with pid 1
phpmyadmin_1 | 2018-06-14 16:35:21,289 INFO spawned: 'php-fpm' with pid 13
phpmyadmin_1 | 2018-06-14 16:35:21,291 INFO spawned: 'nginx' with pid 14
phpmyadmin_1 | 2018-06-14 16:35:22,358 INFO success: php-fpm entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
phpmyadmin_1 | 2018-06-14 16:35:22,358 INFO success: nginx entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
db-slave_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
db-slave_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Number of pools: 1
db-slave_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Using SSE2 crc32 instructions
db-slave_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
db-slave_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Completed initialization of buffer pool
db-slave_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
db-slave_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
db-slave_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Creating shared tablespace for temporary tables
db-slave_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
db-slave_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
db-slave_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Waiting for purge to start
db-slave_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: 10.3.7 started; log sequence number 1630824; transaction id 21
db-slave_1 | 2018-06-14 16:29:08 0 [Note] Plugin 'FEEDBACK' is disabled.
db-slave_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
db-slave_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Buffer pool(s) load completed at 180614 16:29:08
db-slave_1 | 2018-06-14 16:29:08 0 [Note] Server socket created on IP: '::'.
db-slave_1 | 2018-06-14 16:29:08 0 [Warning] 'proxies_priv' entry '@% root@a69f1dff466d' ignored in --skip-name-resolve mode.
db-slave_1 | 2018-06-14 16:29:08 0 [Note] Reading of all Master_info entries succeded
db-slave_1 | 2018-06-14 16:29:08 0 [Note] Added new Master_info '' to hash table
db-slave_1 | 2018-06-14 16:29:08 0 [Note] mysqld: ready for connections.
db-slave_1 | Version: '10.3.7-MariaDB-1:10.3.7+maria~jessie-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
db-slave_1 | 2018-06-14 16:29:09 12 [Note] Deleted Master_info file '/var/lib/mysql/master.info'.
db-slave_1 | 2018-06-14 16:29:09 12 [Note] Deleted Master_info file '/var/lib/mysql/relay-log.info'.
db-slave_1 | 2018-06-14 16:29:09 13 [Note] Master connection name: '' Master_info_file: 'master.info' Relay_info_file: 'relay-log.info'
db-slave_1 | 2018-06-14 16:29:09 13 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=mysqld-relay-bin' to avoid this problem.
db-slave_1 | 2018-06-14 16:29:09 13 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='db-master', master_port='3306', master_log_file='mysql-bin.000003', master_log_pos='768'.
db-slave_1 | 2018-06-14 16:29:09 17 [Note] Slave I/O thread: Start asynchronous replication to master 'repl@db-master:3306' in log 'mysql-bin.000003' at position 768
db-slave_1 | 2018-06-14 16:29:09 18 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000003' at position 768, relay log './mysqld-relay-bin.000001' position: 4
db-slave_1 | 2018-06-14 16:29:09 17 [Note] Slave I/O thread: connected to master 'repl@db-master:3306',replication started in log 'mysql-bin.000003' at position 768
db-slave_1 | 2018-06-14 16:34:07 18 [Note] Error reading relay log event: slave SQL thread was killed
db-slave_1 | 2018-06-14 16:34:07 18 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.000003' at position 111733
db-slave_1 | 2018-06-14 16:34:07 17 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000003', position 111733
db-slave_1 | 2018-06-14 16:34:07 28 [Note] Deleted Master_info file '/var/lib/mysql/master.info'.
db-slave_1 | 2018-06-14 16:34:07 28 [Note] Deleted Master_info file '/var/lib/mysql/relay-log.info'.
db-slave_1 | 2018-06-14 16:34:07 29 [Note] Master connection name: '' Master_info_file: 'master.info' Relay_info_file: 'relay-log.info'
db-slave_1 | 2018-06-14 16:34:07 29 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='db-master', master_port='3306', master_log_file='mysql-bin.000003', master_log_pos='112038'.
db-slave_1 | 2018-06-14 16:34:07 33 [Note] Slave I/O thread: Start asynchronous replication to master 'repl@db-master:3306' in log 'mysql-bin.000003' at position 112038
db-slave_1 | 2018-06-14 16:34:07 34 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000003' at position 112038, relay log './mysqld-relay-bin.000001' position: 4
db-slave_1 | 2018-06-14 16:34:07 33 [Note] Slave I/O thread: connected to master 'repl@db-master:3306',replication started in log 'mysql-bin.000003' at position 112038
db-slave_1 | 2018-06-14 16:34:37 0 [Note] mysqld (initiated by: unknown): Normal shutdown
db-slave_1 | 2018-06-14 16:34:37 0 [Note] InnoDB: FTS optimize thread exiting.
db-slave_1 | 2018-06-14 16:34:37 0 [Note] Event Scheduler: Purging the queue. 0 events
db-slave_1 | 2018-06-14 16:34:37 34 [Note] Error reading relay log event: slave SQL thread was killed
db-slave_1 | 2018-06-14 16:34:37 34 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.000003' at position 112038
db-slave_1 | 2018-06-14 16:34:37 33 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000003', position 112038
db-slave_1 | 2018-06-14 16:34:37 0 [Note] InnoDB: Starting shutdown...
db-slave_1 | 2018-06-14 16:34:37 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
db-slave_1 | 2018-06-14 16:34:37 0 [Note] InnoDB: Buffer pool(s) dump completed at 180614 16:34:37
db-slave_1 | 2018-06-14 16:34:38 0 [Note] InnoDB: Shutdown completed; log sequence number 3018100; transaction id 2612
db-slave_1 | 2018-06-14 16:34:38 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
db-slave_1 | 2018-06-14 16:34:38 0 [Note] mysqld: Shutdown complete
db-slave_1 |
db-slave_1 | 2018-06-14 16:34:58 0 [Note] mysqld (mysqld 10.3.7-MariaDB-1:10.3.7+maria~jessie-log) starting as process 1 ...
db-slave_1 | 2018-06-14 16:34:59 0 [Note] InnoDB: Using Linux native AIO
db-slave_1 | 2018-06-14 16:34:59 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
db-slave_1 | 2018-06-14 16:34:59 0 [Note] InnoDB: Uses event mutexes
db-slave_1 | 2018-06-14 16:34:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
db-slave_1 | 2018-06-14 16:34:59 0 [Note] InnoDB: Number of pools: 1
db-slave_1 | 2018-06-14 16:34:59 0 [Note] InnoDB: Using SSE2 crc32 instructions
db-slave_1 | 2018-06-14 16:34:59 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
db-slave_1 | 2018-06-14 16:34:59 0 [Note] InnoDB: Completed initialization of buffer pool
db-slave_1 | 2018-06-14 16:34:59 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
db-slave_1 | 2018-06-14 16:34:59 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
db-slave_1 | 2018-06-14 16:34:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables
db-slave_1 | 2018-06-14 16:34:59 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
db-slave_1 | 2018-06-14 16:34:59 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
db-slave_1 | 2018-06-14 16:34:59 0 [Note] InnoDB: Waiting for purge to start
db-slave_1 | 2018-06-14 16:34:59 0 [Note] InnoDB: 10.3.7 started; log sequence number 3018100; transaction id 2614
db-slave_1 | 2018-06-14 16:34:59 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
db-slave_1 | 2018-06-14 16:34:59 0 [Note] Plugin 'FEEDBACK' is disabled.
db-slave_1 | 2018-06-14 16:34:59 0 [Note] Server socket created on IP: '::'.
db-slave_1 | 2018-06-14 16:34:59 0 [Warning] 'proxies_priv' entry '@% root@a69f1dff466d' ignored in --skip-name-resolve mode.
db-slave_1 | 2018-06-14 16:34:59 0 [Note] Reading of all Master_info entries succeded
db-slave_1 | 2018-06-14 16:34:59 0 [Note] Added new Master_info '' to hash table
db-slave_1 | 2018-06-14 16:34:59 0 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=mysqld-relay-bin' to avoid this problem.
db-slave_1 | 2018-06-14 16:34:59 10 [Note] Slave I/O thread: Start asynchronous replication to master 'repl@db-master:3306' in log 'mysql-bin.000003' at position 112038
db-slave_1 | 2018-06-14 16:34:59 0 [Note] mysqld: ready for connections.
db-slave_1 | Version: '10.3.7-MariaDB-1:10.3.7+maria~jessie-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
db-slave_1 | 2018-06-14 16:34:59 10 [Note] Slave I/O thread: connected to master 'repl@db-master:3306',replication started in log 'mysql-bin.000003' at position 112038
db-slave_1 | 2018-06-14 16:34:59 11 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000003' at position 112038, relay log './mysqld-relay-bin.000002' position: 555
db-slave_1 | 2018-06-14 16:34:59 0 [Note] InnoDB: Buffer pool(s) load completed at 180614 16:34:59
db-slave_1 | 2018-06-14 16:34:59 11 [Note] Error reading relay log event: slave SQL thread was killed
db-slave_1 | 2018-06-14 16:34:59 11 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.000004' at position 342
db-slave_1 | 2018-06-14 16:34:59 10 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000004', position 342
db-slave_1 | 2018-06-14 16:34:59 15 [Note] Deleted Master_info file '/var/lib/mysql/master.info'.
db-slave_1 | 2018-06-14 16:34:59 15 [Note] Deleted Master_info file '/var/lib/mysql/relay-log.info'.
db-slave_1 | 2018-06-14 16:34:59 16 [Note] Master connection name: '' Master_info_file: 'master.info' Relay_info_file: 'relay-log.info'
db-slave_1 | 2018-06-14 16:34:59 16 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='db-master', master_port='3306', master_log_file='mysql-bin.000004', master_log_pos='641'.
db-slave_1 | 2018-06-14 16:35:00 20 [Note] Slave I/O thread: Start asynchronous replication to master 'repl@db-master:3306' in log 'mysql-bin.000004' at position 641
db-slave_1 | 2018-06-14 16:35:00 21 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000004' at position 641, relay log './mysqld-relay-bin.000001' position: 4
db-slave_1 | 2018-06-14 16:35:00 20 [Note] Slave I/O thread: connected to master 'repl@db-master:3306',replication started in log 'mysql-bin.000004' at position 641
db-slave_1 | 2018-06-14 16:35:10 20 [Note] Slave: received end packet from server, apparent master shutdown:
db-slave_1 | 2018-06-14 16:35:10 20 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000004' at position 641
db-slave_1 | 2018-06-14 16:35:10 20 [ERROR] Slave I/O: error reconnecting to master 'repl@db-master:3306' - retry-time: 60 maximum-retries: 86400 message: Can't connect to MySQL server on 'db-master' (111 "Connection refused"), Internal MariaDB error code: 2003
db-slave_1 | 2018-06-14 16:35:10 0 [Note] mysqld (initiated by: unknown): Normal shutdown
db-slave_1 | 2018-06-14 16:35:10 0 [Note] Event Scheduler: Purging the queue. 0 events
db-slave_1 | 2018-06-14 16:35:10 21 [Note] Error reading relay log event: slave SQL thread was killed
db-slave_1 | 2018-06-14 16:35:10 0 [Note] InnoDB: FTS optimize thread exiting.
db-slave_1 | 2018-06-14 16:35:10 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.000004' at position 641
db-slave_1 | 2018-06-14 16:35:10 20 [Note] Slave I/O thread killed during or after a reconnect done to recover from failed read
db-slave_1 | 2018-06-14 16:35:10 20 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000004', position 641
db-slave_1 | 2018-06-14 16:35:10 0 [Note] InnoDB: Starting shutdown...
db-slave_1 | 2018-06-14 16:35:10 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
db-slave_1 | 2018-06-14 16:35:10 0 [Note] InnoDB: Buffer pool(s) dump completed at 180614 16:35:10
db-slave_1 | 2018-06-14 16:35:11 0 [Note] InnoDB: Shutdown completed; log sequence number 3023013; transaction id 2627
db-slave_1 | 2018-06-14 16:35:11 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
db-slave_1 | 2018-06-14 16:35:12 0 [Note] mysqld: Shutdown complete
db-slave_1 |
db-slave_1 | 2018-06-14 16:35:21 0 [Note] mysqld (mysqld 10.3.7-MariaDB-1:10.3.7+maria~jessie-log) starting as process 1 ...
db-slave_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Using Linux native AIO
db-slave_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
db-slave_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Uses event mutexes
db-slave_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
db-slave_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Number of pools: 1
db-slave_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Using SSE2 crc32 instructions
db-slave_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
db-slave_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Completed initialization of buffer pool
db-slave_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
db-slave_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
db-slave_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Creating shared tablespace for temporary tables
db-slave_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
db-slave_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
db-slave_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Waiting for purge to start
db-slave_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: 10.3.7 started; log sequence number 3023013; transaction id 2629
db-slave_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
db-slave_1 | 2018-06-14 16:35:21 0 [Note] Plugin 'FEEDBACK' is disabled.
db-slave_1 | 2018-06-14 16:35:21 0 [Note] Server socket created on IP: '::'.
db-slave_1 | 2018-06-14 16:35:21 0 [Warning] 'proxies_priv' entry '@% root@a69f1dff466d' ignored in --skip-name-resolve mode.
db-slave_1 | 2018-06-14 16:35:21 0 [Note] Reading of all Master_info entries succeded
db-slave_1 | 2018-06-14 16:35:21 0 [Note] Added new Master_info '' to hash table
db-slave_1 | 2018-06-14 16:35:21 0 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=mysqld-relay-bin' to avoid this problem.
db-slave_1 | 2018-06-14 16:35:21 10 [Note] Slave I/O thread: Start asynchronous replication to master 'repl@db-master:3306' in log 'mysql-bin.000004' at position 641
db-slave_1 | 2018-06-14 16:35:21 0 [Note] mysqld: ready for connections.
db-slave_1 | Version: '10.3.7-MariaDB-1:10.3.7+maria~jessie-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
db-slave_1 | 2018-06-14 16:35:21 11 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000004' at position 641, relay log './mysqld-relay-bin.000002' position: 555
db-slave_1 | 2018-06-14 16:35:21 12 [Warning] Access denied for user 'repl'@'172.18.0.5' (using password: YES)
db-slave_1 | 2018-06-14 16:35:21 10 [Note] Slave I/O thread: connected to master 'repl@db-master:3306',replication started in log 'mysql-bin.000004' at position 641
db-slave_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Buffer pool(s) load completed at 180614 16:35:21
db-slave_1 | 2018-06-14 16:35:21 11 [Note] Error reading relay log event: slave SQL thread was killed
db-slave_1 | 2018-06-14 16:35:21 11 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.000005' at position 342
db-slave_1 | 2018-06-14 16:35:21 10 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000005', position 342
db-slave_1 | 2018-06-14 16:35:21 16 [Note] Deleted Master_info file '/var/lib/mysql/master.info'.
db-slave_1 | 2018-06-14 16:35:21 16 [Note] Deleted Master_info file '/var/lib/mysql/relay-log.info'.
db-slave_1 | 2018-06-14 16:35:21 17 [Note] Master connection name: '' Master_info_file: 'master.info' Relay_info_file: 'relay-log.info'
db-slave_1 | 2018-06-14 16:35:21 17 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='db-master', master_port='3306', master_log_file='mysql-bin.000005', master_log_pos='641'.
db-slave_1 | 2018-06-14 16:35:22 21 [Note] Slave I/O thread: Start asynchronous replication to master 'repl@db-master:3306' in log 'mysql-bin.000005' at position 641
db-slave_1 | 2018-06-14 16:35:22 22 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000005' at position 641, relay log './mysqld-relay-bin.000001' position: 4
db-configure_1 | ++ eval 'mysql --host db-master -uroot -ptoor -e '\''show master status \G'\'' | grep Position | sed -n -e '\''s/^.*: //p'\'''
db-configure_1 | +++ grep Position
db-configure_1 | +++ sed -n -e 's/^.*: //p'
db-configure_1 | +++ mysql --host db-master -uroot -ptoor -e 'show master status \G'
db-configure_1 | + MYSQL01_Position=641
db-configure_1 | ++ eval 'mysql --host db-master -uroot -ptoor -e '\''show master status \G'\'' | grep File | sed -n -e '\''s/^.*: //p'\'''
db-configure_1 | +++ mysql --host db-master -uroot -ptoor -e 'show master status \G'
db-configure_1 | +++ sed -n -e 's/^.*: //p'
db-configure_1 | +++ grep File
db-configure_1 | + MYSQL01_File=mysql-bin.000004
db-configure_1 | ++ eval 'getent hosts db-master|awk '\''{print $1}'\'''
db-configure_1 | +++ awk '{print $1}'
db-configure_1 | +++ getent hosts db-master
db-configure_1 | + MASTER_IP=172.18.0.2
db-configure_1 | + echo 172.18.0.2
db-configure_1 | + mysql --host db-slave -uroot -ptoor -AN -e 'CHANGE MASTER TO master_host='\''db-master'\'', master_port=3306, master_user='\''repl'\'', master_password='\''repl'\'', master_log_file='\''mysql-bin.000004'\'', master_log_pos=641;'
db-configure_1 | 172.18.0.2
db-configure_1 | + echo '* Set MySQL02 as master on MySQL01'
db-configure_1 | * Set MySQL02 as master on MySQL01
db-configure_1 | ++ eval 'mysql --host db-slave -uroot -ptoor -e '\''show master status \G'\'' | grep Position | sed -n -e '\''s/^.*: //p'\'''
db-configure_1 | +++ mysql --host db-slave -uroot -ptoor -e 'show master status \G'
db-configure_1 | +++ sed -n -e 's/^.*: //p'
db-configure_1 | +++ grep Position
db-configure_1 | + MYSQL02_Position=358
db-configure_1 | ++ eval 'mysql --host db-slave -uroot -ptoor -e '\''show master status \G'\'' | grep File | sed -n -e '\''s/^.*: //p'\'''
db-configure_1 | +++ grep File
db-configure_1 | +++ mysql --host db-slave -uroot -ptoor -e 'show master status \G'
db-configure_1 | +++ sed -n -e 's/^.*: //p'
db-configure_1 | + MYSQL02_File=mysql-bin.000004
db-configure_1 | ++ eval 'getent hosts db-slave|awk '\''{print $1}'\'''
db-configure_1 | +++ getent hosts db-slave
db-configure_1 | +++ awk '{print $1}'
db-configure_1 | + SLAVE_IP=172.18.0.6
db-configure_1 | + echo 172.18.0.6
db-configure_1 | 172.18.0.6
db-configure_1 | + mysql --host db-master -uroot -ptoor -AN -e 'CHANGE MASTER TO master_host='\''db-slave'\'', master_port=3306, master_user='\''repl'\'', master_password='\''repl'\'', master_log_file='\''mysql-bin.000004'\'', master_log_pos=358;'
db-configure_1 | ERROR 1198 (HY000) at line 1: This operation cannot be performed as you have a running slave ''; run STOP SLAVE '' first
db-configure_1 | + echo '* Start Slave on both Servers'
db-configure_1 | * Start Slave on both Servers
db-configure_1 | + mysql --host db-slave -uroot -ptoor -AN -e 'start slave;'
db-configure_1 | + echo 'Increase the max_connections to 2000'
db-configure_1 | Increase the max_connections to 2000
db-configure_1 | + mysql --host db-master -uroot -ptoor -AN -e 'set GLOBAL max_connections=2000'
db-configure_1 | + mysql --host db-slave -uroot -ptoor -AN -e 'set GLOBAL max_connections=2000'
db-configure_1 | + mysql --host db-slave -uroot -ptoor -e 'show slave status \G'
db-configure_1 | *************************** 1. row ***************************
db-configure_1 | Slave_IO_State: Waiting for master to send event
db-configure_1 | Master_Host: db-master
db-configure_1 | Master_User: repl
db-configure_1 | Master_Port: 3306
db-configure_1 | Connect_Retry: 60
db-configure_1 | Master_Log_File: mysql-bin.000004
db-configure_1 | Read_Master_Log_Pos: 641
db-configure_1 | Relay_Log_File: mysqld-relay-bin.000002
db-configure_1 | Relay_Log_Pos: 555
db-configure_1 | Relay_Master_Log_File: mysql-bin.000004
db-configure_1 | Slave_IO_Running: Yes
db-configure_1 | Slave_SQL_Running: Yes
db-configure_1 | Replicate_Do_DB:
db-configure_1 | Replicate_Ignore_DB:
db-configure_1 | Replicate_Do_Table:
db-configure_1 | Replicate_Ignore_Table:
db-configure_1 | Replicate_Wild_Do_Table:
db-configure_1 | Replicate_Wild_Ignore_Table:
db-configure_1 | Last_Errno: 0
db-configure_1 | Last_Error:
db-configure_1 | Skip_Counter: 0
db-configure_1 | Exec_Master_Log_Pos: 641
db-configure_1 | Relay_Log_Space: 865
db-configure_1 | Until_Condition: None
db-configure_1 | Until_Log_File:
db-configure_1 | Until_Log_Pos: 0
db-configure_1 | Master_SSL_Allowed: No
db-configure_1 | Master_SSL_CA_File:
db-configure_1 | Master_SSL_CA_Path:
db-configure_1 | Master_SSL_Cert:
db-configure_1 | Master_SSL_Cipher:
db-configure_1 | Master_SSL_Key:
db-configure_1 | Seconds_Behind_Master: 0
db-configure_1 | Master_SSL_Verify_Server_Cert: No
db-configure_1 | Last_IO_Errno: 0
db-configure_1 | Last_IO_Error:
db-configure_1 | Last_SQL_Errno: 0
db-configure_1 | Last_SQL_Error:
db-configure_1 | Replicate_Ignore_Server_Ids:
db-configure_1 | Master_Server_Id: 1
db-configure_1 | Master_SSL_Crl:
db-configure_1 | Master_SSL_Crlpath:
db-configure_1 | Using_Gtid: No
db-configure_1 | Gtid_IO_Pos:
db-configure_1 | Replicate_Do_Domain_Ids:
db-configure_1 | Replicate_Ignore_Domain_Ids:
db-configure_1 | Parallel_Mode: conservative
db-configure_1 | SQL_Delay: 0
db-configure_1 | SQL_Remaining_Delay: NULL
db-configure_1 | Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
db-configure_1 | Slave_DDL_Groups: 0
db-configure_1 | Slave_Non_Transactional_Groups: 0
db-configure_1 | Slave_Transactional_Groups: 0
db-configure_1 | + echo 'MySQL servers created!'
db-configure_1 | MySQL servers created!
db-configure_1 | + echo --------------------
db-configure_1 | --------------------
db-configure_1 | + echo
db-configure_1 |
db-configure_1 | + echo Variables available fo you :-
db-configure_1 | Variables available fo you :-
db-configure_1 | + echo
db-configure_1 |
db-configure_1 | + echo MYSQL01_IP : db-master
db-configure_1 | MYSQL01_IP : db-master
db-configure_1 | + echo MYSQL02_IP : db-slave
db-configure_1 | MYSQL02_IP : db-slave
db-configure_1 | ++ dirname /tmp/mysql_connector.sh
db-configure_1 | + BASE_PATH=/tmp
db-configure_1 | + echo 'Waiting for mysql to get up'
db-configure_1 | Waiting for mysql to get up
db-configure_1 | + /tmp/wait-for-it.sh db-master:3306
db-configure_1 | wait-for-it.sh: waiting 15 seconds for db-master:3306
db-configure_1 | wait-for-it.sh: db-master:3306 is available after 1 seconds
db-configure_1 | + /tmp/wait-for-it.sh db-slave:3306
db-configure_1 | wait-for-it.sh: waiting 15 seconds for db-slave:3306
db-configure_1 | wait-for-it.sh: db-slave:3306 is available after 0 seconds
db-configure_1 | + /tmp/wait-for-it.sh db-master:3306
db-configure_1 | wait-for-it.sh: waiting 15 seconds for db-master:3306
db-configure_1 | wait-for-it.sh: db-master:3306 is available after 0 seconds
db-configure_1 | + /tmp/wait-for-it.sh db-slave:3306
db-configure_1 | wait-for-it.sh: waiting 15 seconds for db-slave:3306
db-configure_1 | wait-for-it.sh: db-slave:3306 is available after 0 seconds
db-configure_1 | + echo 'Create MySQL Servers (master / slave repl)'
db-configure_1 | Create MySQL Servers (master / slave repl)
db-configure_1 | + echo -----------------
db-configure_1 | -----------------
db-configure_1 | + echo '* Create replication user'
db-configure_1 | * Create replication user
db-configure_1 | + mysql --host db-slave -uroot -ptoor -AN -e 'STOP SLAVE;'
db-configure_1 | + mysql --host db-slave -uroot -ptoor -AN -e 'RESET SLAVE ALL;'
db-configure_1 | + mysql --host db-master -uroot -ptoor -AN -e 'CREATE USER '\''repl'\''@'\''%'\'';'
db-configure_1 | ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'repl'@'%'
db-configure_1 | + mysql --host db-master -uroot -ptoor -AN -e 'GRANT REPLICATION SLAVE ON *.* TO '\''repl'\''@'\''%'\'' IDENTIFIED BY '\''repl'\'';'
db-configure_1 | + mysql --host db-master -uroot -ptoor -AN -e 'flush privileges;'
db-configure_1 | + echo '* Set MySQL01 as master on MySQL02'
nginx-proxy_1 | WARNING: /etc/nginx/dhparam/dhparam.pem was not found. A pre-generated dhparam.pem will be used for now while a new one
nginx-proxy_1 | is being generated in the background. Once the new dhparam.pem is in place, nginx will be reloaded.
nginx-proxy_1 | forego | starting dockergen.1 on port 5000
nginx-proxy_1 | forego | starting nginx.1 on port 5100
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:29:00 Generated '/etc/nginx/conf.d/default.conf' from 6 containers
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:29:00 Running 'nginx -s reload'
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:29:00 Watching docker events
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:29:00 Generated '/etc/nginx/conf.d/default.conf' from 7 containers
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:29:00 Received event start for container eb4aaa9ff6da
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:29:01 Contents of /etc/nginx/conf.d/default.conf did not change. Skipping notification 'nginx -s reload'
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:29:09 Received event die for container cd0706b5aeb8
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:29:09 Contents of /etc/nginx/conf.d/default.conf did not change. Skipping notification 'nginx -s reload'
nginx-proxy_1 | 2018/06/14 16:31:06 [notice] 49#49: signal process started
nginx-proxy_1 | Generating DH parameters, 2048 bit long safe prime, generator 2
nginx-proxy_1 | This is going to take a long time
nginx-proxy_1 | dhparam generation complete, reloading nginx
nginx-proxy_1 | nginx.1 | 127.0.0.1 172.18.0.1 - - [14/Jun/2018:16:32:12 +0000] "GET /wiki/Main_Page HTTP/1.1" 503 214 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:60.0) Gecko/20100101 Firefox/60.0"
nginx-proxy_1 | nginx.1 | 127.0.0.1 172.18.0.1 - - [14/Jun/2018:16:32:12 +0000] "GET /favicon.ico HTTP/1.1" 503 214 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:60.0) Gecko/20100101 Firefox/60.0"
nginx-proxy_1 | nginx.1 | 127.0.0.1 172.18.0.1 - - [14/Jun/2018:16:32:12 +0000] "GET /favicon.ico HTTP/1.1" 503 214 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:60.0) Gecko/20100101 Firefox/60.0"
nginx-proxy_1 | nginx.1 | 127.0.0.1 172.18.0.1 - - [14/Jun/2018:16:32:17 +0000] "GET / HTTP/1.1" 503 214 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:60.0) Gecko/20100101 Firefox/60.0"
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:33:03 Received event start for container 50412141e6e6
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:33:03 Contents of /etc/nginx/conf.d/default.conf did not change. Skipping notification 'nginx -s reload'
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:33:13 Received event die for container 50412141e6e6
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:33:13 Contents of /etc/nginx/conf.d/default.conf did not change. Skipping notification 'nginx -s reload'
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:34:07 Received event start for container cd0706b5aeb8
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:34:07 Contents of /etc/nginx/conf.d/default.conf did not change. Skipping notification 'nginx -s reload'
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:34:07 Received event die for container cd0706b5aeb8
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:34:08 Contents of /etc/nginx/conf.d/default.conf did not change. Skipping notification 'nginx -s reload'
nginx-proxy_1 | Custom dhparam.pem file found, generation skipped
nginx-proxy_1 | forego | starting dockergen.1 on port 5000
nginx-proxy_1 | forego | starting nginx.1 on port 5100
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:34:58 Generated '/etc/nginx/conf.d/default.conf' from 6 containers
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:34:58 Watching docker events
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:34:59 Generated '/etc/nginx/conf.d/default.conf' from 7 containers
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:34:59 Running 'nginx -s reload'
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:34:59 Received event start for container eb4aaa9ff6da
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:34:59 Contents of /etc/nginx/conf.d/default.conf did not change. Skipping notification 'nginx -s reload'
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:35:00 Received event die for container cd0706b5aeb8
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:35:00 Contents of /etc/nginx/conf.d/default.conf did not change. Skipping notification 'nginx -s reload'
nginx-proxy_1 | Custom dhparam.pem file found, generation skipped
nginx-proxy_1 | forego | starting dockergen.1 on port 5000
nginx-proxy_1 | forego | starting nginx.1 on port 5100
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:35:20 Generated '/etc/nginx/conf.d/default.conf' from 6 containers
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:35:20 Running 'nginx -s reload'
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:35:20 Watching docker events
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:35:21 Generated '/etc/nginx/conf.d/default.conf' from 7 containers
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:35:21 Running 'nginx -s reload'
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:35:21 Received event start for container eb4aaa9ff6da
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:35:21 Contents of /etc/nginx/conf.d/default.conf did not change. Skipping notification 'nginx -s reload'
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:35:22 Received event die for container cd0706b5aeb8
nginx-proxy_1 | dockergen.1 | 2018/06/14 16:35:22 Contents of /etc/nginx/conf.d/default.conf did not change. Skipping notification 'nginx -s reload'
nginx-proxy_1 | nginx.1 | 127.0.0.1 172.18.0.1 - - [14/Jun/2018:16:35:25 +0000] "GET / HTTP/1.1" 503 214 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:60.0) Gecko/20100101 Firefox/60.0"
nginx-proxy_1 | nginx.1 | 127.0.0.1 172.18.0.1 - - [14/Jun/2018:16:35:32 +0000] "GET /w/api.php HTTP/1.1" 503 214 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:60.0) Gecko/20100101 Firefox/60.0"
nginx-proxy_1 | nginx.1 | 127.0.0.1 172.18.0.1 - - [14/Jun/2018:16:35:39 +0000] "GET /wiki/Special:Version HTTP/1.1" 503 214 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:60.0) Gecko/20100101 Firefox/60.0"
nginx-proxy_1 | nginx.1 | 127.0.0.1 172.18.0.1 - - [14/Jun/2018:16:38:09 +0000] "GET / HTTP/1.1" 503 214 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:60.0) Gecko/20100101 Firefox/60.0"
graphite-statsd_1 | *** Running /etc/my_init.d/00_regen_ssh_host_keys.sh...
graphite-statsd_1 | *** Running /etc/my_init.d/01_conf_init.sh...
graphite-statsd_1 | *** Running /etc/rc.local...
graphite-statsd_1 | *** Booting runit daemon...
graphite-statsd_1 | *** Runit started as PID 13
graphite-statsd_1 | Jun 14 16:28:59 b2e87ffc7d96 syslog-ng[27]: syslog-ng starting up; version='3.5.3'
graphite-statsd_1 | *** Shutting down runit daemon (PID 13)...
graphite-statsd_1 | *** Killing all processes...
graphite-statsd_1 | *** Running /etc/my_init.d/00_regen_ssh_host_keys.sh...
graphite-statsd_1 | *** Running /etc/my_init.d/01_conf_init.sh...
graphite-statsd_1 | *** Running /etc/rc.local...
graphite-statsd_1 | *** Booting runit daemon...
graphite-statsd_1 | *** Runit started as PID 13
graphite-statsd_1 | Jun 14 16:34:57 b2e87ffc7d96 syslog-ng[28]: syslog-ng starting up; version='3.5.3'
graphite-statsd_1 | *** Shutting down runit daemon (PID 13)...
graphite-statsd_1 | *** Killing all processes...
graphite-statsd_1 | *** Running /etc/my_init.d/00_regen_ssh_host_keys.sh...
graphite-statsd_1 | *** Running /etc/my_init.d/01_conf_init.sh...
graphite-statsd_1 | *** Running /etc/rc.local...
graphite-statsd_1 | *** Booting runit daemon...
graphite-statsd_1 | *** Runit started as PID 13
graphite-statsd_1 | Jun 14 16:35:21 b2e87ffc7d96 syslog-ng[23]: syslog-ng starting up; version='3.5.3'
db-slave_1 | 2018-06-14 16:35:22 21 [Note] Slave I/O thread: connected to master 'repl@db-master:3306',replication started in log 'mysql-bin.000005' at position 641
db-slave_1 | 2018-06-14 16:36:21 25 [Warning] Access denied for user 'repl'@'172.18.0.5' (using password: YES)
db-slave_1 | 2018-06-14 16:37:21 26 [Warning] Access denied for user 'repl'@'172.18.0.5' (using password: YES)
db-slave_1 | 2018-06-14 16:38:21 27 [Warning] Access denied for user 'repl'@'172.18.0.5' (using password: YES)
db-slave_1 | 2018-06-14 16:39:21 28 [Warning] Access denied for user 'repl'@'172.18.0.5' (using password: YES)
db-slave_1 | 2018-06-14 16:40:21 29 [Warning] Access denied for user 'repl'@'172.18.0.5' (using password: YES)
db-slave_1 | 2018-06-14 16:41:21 30 [Warning] Access denied for user 'repl'@'172.18.0.5' (using password: YES)
db-slave_1 | 2018-06-14 16:42:21 31 [Warning] Access denied for user 'repl'@'172.18.0.5' (using password: YES)
db-slave_1 | 2018-06-14 16:43:21 32 [Warning] Access denied for user 'repl'@'172.18.0.5' (using password: YES)
db-configure_1 | * Set MySQL01 as master on MySQL02
db-configure_1 | ++ eval 'mysql --host db-master -uroot -ptoor -e '\''show master status \G'\'' | grep Position | sed -n -e '\''s/^.*: //p'\'''
db-configure_1 | +++ mysql --host db-master -uroot -ptoor -e 'show master status \G'
db-configure_1 | +++ sed -n -e 's/^.*: //p'
db-configure_1 | +++ grep Position
db-configure_1 | + MYSQL01_Position=641
db-configure_1 | ++ eval 'mysql --host db-master -uroot -ptoor -e '\''show master status \G'\'' | grep File | sed -n -e '\''s/^.*: //p'\'''
db-configure_1 | +++ mysql --host db-master -uroot -ptoor -e 'show master status \G'
db-configure_1 | +++ sed -n -e 's/^.*: //p'
db-configure_1 | +++ grep File
db-configure_1 | + MYSQL01_File=mysql-bin.000005
db-configure_1 | ++ eval 'getent hosts db-master|awk '\''{print $1}'\'''
db-configure_1 | +++ getent hosts db-master
db-configure_1 | +++ awk '{print $1}'
db-configure_1 | + MASTER_IP=172.18.0.5
db-configure_1 | 172.18.0.5
db-configure_1 | + echo 172.18.0.5
db-configure_1 | + mysql --host db-slave -uroot -ptoor -AN -e 'CHANGE MASTER TO master_host='\''db-master'\'', master_port=3306, master_user='\''repl'\'', master_password='\''repl'\'', master_log_file='\''mysql-bin.000005'\'', master_log_pos=641;'
db-configure_1 | + echo '* Set MySQL02 as master on MySQL01'
db-configure_1 | * Set MySQL02 as master on MySQL01
db-configure_1 | ++ eval 'mysql --host db-slave -uroot -ptoor -e '\''show master status \G'\'' | grep Position | sed -n -e '\''s/^.*: //p'\'''
db-configure_1 | +++ mysql --host db-slave -uroot -ptoor -e 'show master status \G'
db-configure_1 | +++ grep Position
db-configure_1 | +++ sed -n -e 's/^.*: //p'
db-configure_1 | + MYSQL02_Position=358
db-configure_1 | ++ eval 'mysql --host db-slave -uroot -ptoor -e '\''show master status \G'\'' | grep File | sed -n -e '\''s/^.*: //p'\'''
db-configure_1 | +++ mysql --host db-slave -uroot -ptoor -e 'show master status \G'
db-configure_1 | +++ sed -n -e 's/^.*: //p'
db-configure_1 | +++ grep File
db-configure_1 | + MYSQL02_File=mysql-bin.000005
db-configure_1 | ++ eval 'getent hosts db-slave|awk '\''{print $1}'\'''
db-configure_1 | +++ getent hosts db-slave
db-configure_1 | +++ awk '{print $1}'
db-configure_1 | + SLAVE_IP=172.18.0.6
db-configure_1 | + echo 172.18.0.6
db-configure_1 | 172.18.0.6
db-configure_1 | + mysql --host db-master -uroot -ptoor -AN -e 'CHANGE MASTER TO master_host='\''db-slave'\'', master_port=3306, master_user='\''repl'\'', master_password='\''repl'\'', master_log_file='\''mysql-bin.000005'\'', master_log_pos=358;'
db-configure_1 | ERROR 1198 (HY000) at line 1: This operation cannot be performed as you have a running slave ''; run STOP SLAVE '' first
db-configure_1 | * Start Slave on both Servers
db-configure_1 | + echo '* Start Slave on both Servers'
db-configure_1 | + mysql --host db-slave -uroot -ptoor -AN -e 'start slave;'
db-configure_1 | + echo 'Increase the max_connections to 2000'
db-configure_1 | + mysql --host db-master -uroot -ptoor -AN -e 'set GLOBAL max_connections=2000'
db-configure_1 | Increase the max_connections to 2000
db-configure_1 | + mysql --host db-slave -uroot -ptoor -AN -e 'set GLOBAL max_connections=2000'
db-configure_1 | + mysql --host db-slave -uroot -ptoor -e 'show slave status \G'
db-configure_1 | *************************** 1. row ***************************
db-configure_1 | Slave_IO_State: Waiting for master to send event
db-configure_1 | Master_Host: db-master
db-configure_1 | Master_User: repl
db-configure_1 | Master_Port: 3306
db-configure_1 | Connect_Retry: 60
db-configure_1 | Master_Log_File: mysql-bin.000005
db-configure_1 | Read_Master_Log_Pos: 641
db-configure_1 | Relay_Log_File: mysqld-relay-bin.000002
db-configure_1 | Relay_Log_Pos: 555
db-configure_1 | Relay_Master_Log_File: mysql-bin.000005
db-configure_1 | Slave_IO_Running: Yes
db-configure_1 | Slave_SQL_Running: Yes
db-configure_1 | Replicate_Do_DB:
db-configure_1 | Replicate_Ignore_DB:
db-configure_1 | Replicate_Do_Table:
db-configure_1 | Replicate_Ignore_Table:
db-configure_1 | Replicate_Wild_Do_Table:
db-configure_1 | Replicate_Wild_Ignore_Table:
db-configure_1 | Last_Errno: 0
db-configure_1 | Last_Error:
db-configure_1 | Skip_Counter: 0
db-configure_1 | Exec_Master_Log_Pos: 641
db-configure_1 | Relay_Log_Space: 865
db-configure_1 | Until_Condition: None
db-configure_1 | Until_Log_File:
db-configure_1 | Until_Log_Pos: 0
db-configure_1 | Master_SSL_Allowed: No
db-configure_1 | Master_SSL_CA_File:
db-configure_1 | Master_SSL_CA_Path:
db-configure_1 | Master_SSL_Cert:
db-configure_1 | Master_SSL_Cipher:
db-configure_1 | Master_SSL_Key:
db-configure_1 | Seconds_Behind_Master: 0
db-configure_1 | Master_SSL_Verify_Server_Cert: No
db-configure_1 | Last_IO_Errno: 0
db-configure_1 | Last_IO_Error:
db-configure_1 | Last_SQL_Errno: 0
db-configure_1 | Last_SQL_Error:
db-configure_1 | Replicate_Ignore_Server_Ids:
db-configure_1 | Master_Server_Id: 1
db-configure_1 | Master_SSL_Crl:
db-configure_1 | Master_SSL_Crlpath:
db-master_1 | Initializing database
db-master_1 | 2018-06-14 16:29:00 6 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
db-master_1 |
db-master_1 | PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
db-master_1 | To do so, start the server, then issue the following commands:
db-master_1 |
db-master_1 | '/usr/bin/mysqladmin' -u root password 'new-password'
db-master_1 | '/usr/bin/mysqladmin' -u root -h password 'new-password'
db-master_1 |
db-master_1 | Alternatively you can run:
db-master_1 | '/usr/bin/mysql_secure_installation'
db-master_1 |
db-master_1 | which will also give you the option of removing the test
db-master_1 | databases and anonymous user created by default. This is
db-master_1 | strongly recommended for production servers.
db-master_1 |
db-master_1 | See the MariaDB Knowledgebase at http://mariadb.com/kb or the
db-master_1 | MySQL manual for more instructions.
db-master_1 |
db-master_1 | Please report any problems at http://mariadb.org/jira
db-master_1 |
db-master_1 | The latest information about MariaDB is available at http://mariadb.org/.
db-master_1 | You can find additional information about the MySQL part at:
db-master_1 | http://dev.mysql.com
db-master_1 | Consider joining MariaDB's strong and vibrant community:
db-master_1 | https://mariadb.org/get-involved/
db-master_1 |
db-master_1 | Database initialized
db-master_1 | MySQL init process in progress...
db-master_1 | 2018-06-14 16:29:03 0 [Note] mysqld (mysqld 10.3.7-MariaDB-1:10.3.7+maria~jessie-log) starting as process 103 ...
db-master_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Using Linux native AIO
db-master_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
db-master_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Uses event mutexes
db-master_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
db-master_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Number of pools: 1
db-master_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Using SSE2 crc32 instructions
db-master_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
db-master_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Completed initialization of buffer pool
db-master_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
db-master_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
db-master_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
db-master_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
db-master_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
db-master_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Waiting for purge to start
db-master_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: 10.3.7 started; log sequence number 1630815; transaction id 21
db-master_1 | 2018-06-14 16:29:03 0 [Note] Plugin 'FEEDBACK' is disabled.
db-master_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
db-master_1 | 2018-06-14 16:29:03 0 [Note] InnoDB: Buffer pool(s) load completed at 180614 16:29:03
db-master_1 | 2018-06-14 16:29:03 0 [Warning] 'user' entry 'root@04e63e646ece' ignored in --skip-name-resolve mode.
db-master_1 | 2018-06-14 16:29:03 0 [Warning] 'user' entry '@04e63e646ece' ignored in --skip-name-resolve mode.
db-master_1 | 2018-06-14 16:29:03 0 [Warning] 'proxies_priv' entry '@% root@04e63e646ece' ignored in --skip-name-resolve mode.
db-master_1 | 2018-06-14 16:29:03 0 [Note] Reading of all Master_info entries succeded
db-master_1 | 2018-06-14 16:29:03 0 [Note] Added new Master_info '' to hash table
db-master_1 | 2018-06-14 16:29:03 0 [Note] mysqld: ready for connections.
db-master_1 | Version: '10.3.7-MariaDB-1:10.3.7+maria~jessie-log' socket: '/var/run/mysqld/mysqld.sock' port: 0 mariadb.org binary distribution
db-master_1 | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
db-master_1 | 2018-06-14 16:29:06 11 [Warning] 'proxies_priv' entry '@% root@04e63e646ece' ignored in --skip-name-resolve mode.
db-master_1 |
db-master_1 | 2018-06-14 16:29:06 0 [Note] mysqld (initiated by: unknown): Normal shutdown
db-master_1 | 2018-06-14 16:29:06 0 [Note] InnoDB: FTS optimize thread exiting.
db-master_1 | 2018-06-14 16:29:06 0 [Note] Event Scheduler: Purging the queue. 0 events
db-master_1 | 2018-06-14 16:29:06 0 [Note] InnoDB: Starting shutdown...
db-master_1 | 2018-06-14 16:29:06 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
db-master_1 | 2018-06-14 16:29:06 0 [Note] InnoDB: Buffer pool(s) dump completed at 180614 16:29:06
db-master_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Shutdown completed; log sequence number 1630824; transaction id 24
db-master_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
db-master_1 | 2018-06-14 16:29:08 0 [Note] mysqld: Shutdown complete
db-master_1 |
db-master_1 |
db-master_1 | MySQL init process done. Ready for start up.
db-master_1 |
db-master_1 | 2018-06-14 16:29:08 0 [Note] mysqld (mysqld 10.3.7-MariaDB-1:10.3.7+maria~jessie-log) starting as process 1 ...
db-master_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Using Linux native AIO
db-master_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
db-master_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Uses event mutexes
db-master_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
db-master_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Number of pools: 1
db-master_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Using SSE2 crc32 instructions
db-master_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
db-master_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Completed initialization of buffer pool
db-master_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
db-master_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
db-configure_1 | Using_Gtid: No
db-configure_1 | Gtid_IO_Pos:
db-configure_1 | Replicate_Do_Domain_Ids:
db-configure_1 | Replicate_Ignore_Domain_Ids:
db-configure_1 | Parallel_Mode: conservative
db-configure_1 | SQL_Delay: 0
db-configure_1 | SQL_Remaining_Delay: NULL
db-configure_1 | Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
db-configure_1 | Slave_DDL_Groups: 0
db-configure_1 | Slave_Non_Transactional_Groups: 0
db-configure_1 | Slave_Transactional_Groups: 0
db-configure_1 | + echo 'MySQL servers created!'
db-configure_1 | + echo --------------------
db-configure_1 | + echo
db-configure_1 | + echo Variables available fo you :-
db-configure_1 | + echo
db-configure_1 | + echo MYSQL01_IP : db-master
db-configure_1 | MySQL servers created!
db-configure_1 | --------------------
db-configure_1 |
db-configure_1 | Variables available fo you :-
db-configure_1 |
db-configure_1 | MYSQL01_IP : db-master
db-configure_1 | MYSQL02_IP : db-slave
db-configure_1 | + echo MYSQL02_IP : db-slave
db-master_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Creating shared tablespace for temporary tables
db-master_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
db-master_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
db-master_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Waiting for purge to start
db-master_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: 10.3.7 started; log sequence number 1630824; transaction id 21
db-master_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
db-master_1 | 2018-06-14 16:29:08 0 [Note] Plugin 'FEEDBACK' is disabled.
db-master_1 | 2018-06-14 16:29:08 0 [Note] InnoDB: Buffer pool(s) load completed at 180614 16:29:08
db-master_1 | 2018-06-14 16:29:08 0 [Note] Server socket created on IP: '::'.
db-master_1 | 2018-06-14 16:29:08 0 [Warning] 'proxies_priv' entry '@% root@04e63e646ece' ignored in --skip-name-resolve mode.
db-master_1 | 2018-06-14 16:29:08 0 [Note] Reading of all Master_info entries succeded
db-master_1 | 2018-06-14 16:29:08 0 [Note] Added new Master_info '' to hash table
db-master_1 | 2018-06-14 16:29:08 0 [Note] mysqld: ready for connections.
db-master_1 | Version: '10.3.7-MariaDB-1:10.3.7+maria~jessie-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
db-master_1 | 2018-06-14 16:29:09 14 [Warning] 'proxies_priv' entry '@% root@04e63e646ece' ignored in --skip-name-resolve mode.
db-master_1 | 2018-06-14 16:29:09 17 [Note] Master connection name: '' Master_info_file: 'master.info' Relay_info_file: 'relay-log.info'
db-master_1 | 2018-06-14 16:29:09 17 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=mysqld-relay-bin' to avoid this problem.
db-master_1 | 2018-06-14 16:29:09 17 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='db-slave', master_port='3306', master_log_file='mysql-bin.000003', master_log_pos='342'.
db-master_1 | 2018-06-14 16:29:09 18 [Note] Start binlog_dump to slave_server(2), pos(mysql-bin.000003, 768)
db-master_1 | 2018-06-14 16:34:07 27 [Warning] 'proxies_priv' entry '@% root@04e63e646ece' ignored in --skip-name-resolve mode.
db-master_1 | 2018-06-14 16:34:07 18 [Warning] Aborted connection 18 to db: 'unconnected' user: 'repl' host: '172.18.0.3' (Got an error writing communication packets)
db-master_1 | 2018-06-14 16:34:07 30 [Note] Master connection name: '' Master_info_file: 'master.info' Relay_info_file: 'relay-log.info'
db-master_1 | 2018-06-14 16:34:07 30 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='db-slave', master_port='3306', master_log_file='mysql-bin.000003', master_log_pos='342'. New state master_host='db-slave', master_port='3306', master_log_file='mysql-bin.000003', master_log_pos='110894'.
db-master_1 | 2018-06-14 16:34:07 31 [Note] Start binlog_dump to slave_server(2), pos(mysql-bin.000003, 112038)
db-master_1 | 2018-06-14 16:34:37 0 [Note] mysqld (initiated by: unknown): Normal shutdown
db-master_1 | 2018-06-14 16:34:37 0 [Note] Event Scheduler: Purging the queue. 0 events
db-master_1 | 2018-06-14 16:34:37 0 [Note] InnoDB: FTS optimize thread exiting.
db-master_1 | 2018-06-14 16:34:37 0 [Note] InnoDB: Starting shutdown...
db-master_1 | 2018-06-14 16:34:37 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
db-master_1 | 2018-06-14 16:34:37 0 [Note] InnoDB: Buffer pool(s) dump completed at 180614 16:34:37
db-master_1 | 2018-06-14 16:34:38 0 [Note] InnoDB: Shutdown completed; log sequence number 2903602; transaction id 2135
db-master_1 | 2018-06-14 16:34:38 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
db-master_1 | 2018-06-14 16:34:38 0 [Note] mysqld: Shutdown complete
db-master_1 |
db-master_1 | 2018-06-14 16:34:58 0 [Note] mysqld (mysqld 10.3.7-MariaDB-1:10.3.7+maria~jessie-log) starting as process 1 ...
db-master_1 | 2018-06-14 16:34:58 0 [Note] InnoDB: Using Linux native AIO
db-master_1 | 2018-06-14 16:34:58 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
db-master_1 | 2018-06-14 16:34:58 0 [Note] InnoDB: Uses event mutexes
db-master_1 | 2018-06-14 16:34:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
db-master_1 | 2018-06-14 16:34:58 0 [Note] InnoDB: Number of pools: 1
db-master_1 | 2018-06-14 16:34:58 0 [Note] InnoDB: Using SSE2 crc32 instructions
db-master_1 | 2018-06-14 16:34:58 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
db-master_1 | 2018-06-14 16:34:58 0 [Note] InnoDB: Completed initialization of buffer pool
db-master_1 | 2018-06-14 16:34:58 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
db-master_1 | 2018-06-14 16:34:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
db-master_1 | 2018-06-14 16:34:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables
db-master_1 | 2018-06-14 16:34:58 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
db-master_1 | 2018-06-14 16:34:58 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
db-master_1 | 2018-06-14 16:34:58 0 [Note] InnoDB: Waiting for purge to start
db-master_1 | 2018-06-14 16:34:58 0 [Note] InnoDB: 10.3.7 started; log sequence number 2903602; transaction id 2137
db-master_1 | 2018-06-14 16:34:58 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
db-master_1 | 2018-06-14 16:34:58 0 [Note] Plugin 'FEEDBACK' is disabled.
db-master_1 | 2018-06-14 16:34:58 0 [Note] Server socket created on IP: '::'.
db-master_1 | 2018-06-14 16:34:58 0 [Warning] 'proxies_priv' entry '@% root@04e63e646ece' ignored in --skip-name-resolve mode.
db-master_1 | 2018-06-14 16:34:58 0 [Note] Reading of all Master_info entries succeded
db-master_1 | 2018-06-14 16:34:58 0 [Note] Added new Master_info '' to hash table
db-master_1 | 2018-06-14 16:34:58 0 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=mysqld-relay-bin' to avoid this problem.
db-master_1 | 2018-06-14 16:34:58 10 [Note] Slave I/O thread: Start asynchronous replication to master 'repl@db-slave:3306' in log 'mysql-bin.000003' at position 110894
db-master_1 | 2018-06-14 16:34:58 10 [ERROR] Slave I/O: error connecting to master 'repl@db-slave:3306' - retry-time: 60 maximum-retries: 86400 message: Can't connect to MySQL server on 'db-slave' (111 "Connection refused"), Internal MariaDB error code: 2003
db-master_1 | 2018-06-14 16:34:58 11 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000003' at position 110894, relay log './mysqld-relay-bin.000001' position: 4
db-master_1 | 2018-06-14 16:34:58 0 [Note] mysqld: ready for connections.
db-master_1 | Version: '10.3.7-MariaDB-1:10.3.7+maria~jessie-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
db-master_1 | 2018-06-14 16:34:58 0 [Note] InnoDB: Buffer pool(s) load completed at 180614 16:34:58
db-master_1 | 2018-06-14 16:34:59 13 [Note] Start binlog_dump to slave_server(2), pos(mysql-bin.000003, 112038)
db-master_1 | 2018-06-14 16:34:59 17 [Warning] 'proxies_priv' entry '@% root@04e63e646ece' ignored in --skip-name-resolve mode.
db-master_1 | 2018-06-14 16:34:59 13 [Warning] Aborted connection 13 to db: 'unconnected' user: 'repl' host: '172.18.0.6' (Got an error writing communication packets)
db-master_1 | 2018-06-14 16:35:00 21 [Note] Start binlog_dump to slave_server(2), pos(mysql-bin.000004, 641)
db-master_1 | 2018-06-14 16:35:10 0 [Note] mysqld (initiated by: unknown): Normal shutdown
db-master_1 | 2018-06-14 16:35:10 0 [Note] Event Scheduler: Purging the queue. 0 events
db-master_1 | 2018-06-14 16:35:10 11 [Note] Error reading relay log event: slave SQL thread was killed
db-master_1 | 2018-06-14 16:35:10 11 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.000003' at position 110894
db-master_1 | 2018-06-14 16:35:10 0 [Note] InnoDB: FTS optimize thread exiting.
db-master_1 | 2018-06-14 16:35:10 10 [Note] Slave I/O thread killed while connecting to master
db-master_1 | 2018-06-14 16:35:10 10 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000003', position 110894
db-master_1 | 2018-06-14 16:35:10 0 [Note] InnoDB: Starting shutdown...
db-master_1 | 2018-06-14 16:35:10 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
db-master_1 | 2018-06-14 16:35:10 0 [Note] InnoDB: Buffer pool(s) dump completed at 180614 16:35:10
db-master_1 | 2018-06-14 16:35:11 0 [Note] InnoDB: Shutdown completed; log sequence number 2903611; transaction id 2138
db-master_1 | 2018-06-14 16:35:11 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
db-master_1 | 2018-06-14 16:35:11 0 [Note] mysqld: Shutdown complete
db-master_1 |
db-master_1 | 2018-06-14 16:35:21 0 [Note] mysqld (mysqld 10.3.7-MariaDB-1:10.3.7+maria~jessie-log) starting as process 1 ...
db-master_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Using Linux native AIO
db-master_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
db-master_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Uses event mutexes
db-master_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
db-master_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Number of pools: 1
db-master_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Using SSE2 crc32 instructions
db-master_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
db-master_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Completed initialization of buffer pool
db-master_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
db-master_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
db-master_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Creating shared tablespace for temporary tables
db-master_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
db-master_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
db-master_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Waiting for purge to start
db-master_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: 10.3.7 started; log sequence number 2903611; transaction id 2137
db-master_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
db-master_1 | 2018-06-14 16:35:21 0 [Note] Plugin 'FEEDBACK' is disabled.
db-master_1 | 2018-06-14 16:35:21 0 [Note] Server socket created on IP: '::'.
db-master_1 | 2018-06-14 16:35:21 0 [Warning] 'proxies_priv' entry '@% root@04e63e646ece' ignored in --skip-name-resolve mode.
db-master_1 | 2018-06-14 16:35:21 0 [Note] Reading of all Master_info entries succeded
db-master_1 | 2018-06-14 16:35:21 0 [Note] Added new Master_info '' to hash table
db-master_1 | 2018-06-14 16:35:21 0 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=mysqld-relay-bin' to avoid this problem.
db-master_1 | 2018-06-14 16:35:21 10 [Note] Slave I/O thread: Start asynchronous replication to master 'repl@db-slave:3306' in log 'mysql-bin.000003' at position 110894
db-master_1 | 2018-06-14 16:35:21 0 [Note] mysqld: ready for connections.
db-master_1 | Version: '10.3.7-MariaDB-1:10.3.7+maria~jessie-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
db-master_1 | 2018-06-14 16:35:21 11 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000003' at position 110894, relay log './mysqld-relay-bin.000002' position: 4
db-master_1 | 2018-06-14 16:35:21 10 [ERROR] Slave I/O: error connecting to master 'repl@db-slave:3306' - retry-time: 60 maximum-retries: 86400 message: Access denied for user 'repl'@'172.18.0.5' (using password: YES), Internal MariaDB error code: 1045
db-master_1 | 2018-06-14 16:35:21 12 [Note] Start binlog_dump to slave_server(2), pos(mysql-bin.000004, 641)
db-master_1 | 2018-06-14 16:35:21 0 [Note] InnoDB: Buffer pool(s) load completed at 180614 16:35:21
db-master_1 | 2018-06-14 16:35:21 17 [Warning] 'proxies_priv' entry '@% root@04e63e646ece' ignored in --skip-name-resolve mode.
db-master_1 | 2018-06-14 16:35:21 12 [Warning] Aborted connection 12 to db: 'unconnected' user: 'repl' host: '172.18.0.6' (Got an error writing communication packets)
db-master_1 | 2018-06-14 16:35:22 21 [Note] Start binlog_dump to slave_server(2), pos(mysql-bin.000005, 641)
mediawiki-docker-dev_db-configure_1 exited with code 0
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL