+++ This bug was initially created as a clone of Bug #1414571 +++ Description of problem: When latest image is used for Mysql dc, mysql pod errors out with following error. This happens when using PV. root@ip-172-31-41-173: ~/svt/openshift_scalability # oc logs -n eap64-mysql0 eap-app-mysql-1-k89cp ---> 19:28:51 Processing MySQL configuration files ... ---> 19:28:51 Initializing database ... ---> 19:28:51 Running mysqld --initialize-insecure ... 2017-01-18T19:28:51.134868Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-01-18T19:28:51.144948Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting. 2017-01-18T19:28:51.144970Z 0 [ERROR] Aborting Version-Release number of selected component (if applicable): openshift v3.5.0.5+8f2840d kubernetes v1.5.2+43a9be4 etcd 3.1.0-rc.0 How reproducible: Always Steps to Reproduce: 1. Create an app using mysql using PV 2. Make sure to use the latest image tag for mysql dc 3. See the error in the mysql pod logs Actual results: Pod doesnt come up and shows above error, when changing the image tag to 5.6 works and pod comes up. Expected results: Pod should start without any error. Additional info:
I've cloned this bug here because it needs to be investigated by the SCL team that owns the image. We're keeping the original bug open as a tracker for our release.
Vikas, we'll need some more information, since just blindly running the container outside of OpenShift works fine: docker run --rm -v '/root/testmysql:/var/lib/mysql/data:Z' -e MYSQL_ROOT_PASSWORD=aaaaaa registry.access.redhat.com/rhscl/mysql-57-rhel7 (In reply to Ben Parees from comment #0) > 2017-01-18T19:28:51.144948Z 0 [ERROR] --initialize specified but the data > directory has files in it. Aborting. > 2017-01-18T19:28:51.144970Z 0 [ERROR] Aborting Initialization phase is a bit different in this regard in MySQL 5.7, compared to 5.6. (mysql_install_db run in 5.6). Any idea what files and why there are in the directory, that is mounted to the container? (I expect the container is run the first time, right? nothing like restarting container with same data that were used before already..) > Steps to Reproduce: > 1. Create an app using mysql using PV Would it be possible to provide more concrete steps for the first step? Although even if we reproduce it, since the container run alone seems to work fine, I don't think we'll be able to debug what is happening inside OpenShift, so we'll need help here to tell what is going on. Ideally if you'd be able to reproduce the same failure with `docker run`. > 2. Make sure to use the latest image tag for mysql dc Which tag exactly, please? CentOS or RHEL variant?
> Any idea what files and why there are in the directory, that is mounted to > the container? (I expect the container is run the first time, right? nothing > like restarting container with same data that were used before already..) Yes, I am trying to create a new app and running this container for the first time. > > > Steps to Reproduce: > > 1. Create an app using mysql using PV > > Would it be possible to provide more concrete steps for the first step? > Although even if we reproduce it, since the container run alone seems to > work fine, I don't think we'll be able to debug what is happening inside > OpenShift, so we'll need help here to tell what is going on. Ideally if > you'd be able to reproduce the same failure with `docker run`. > > > 2. Make sure to use the latest image tag for mysql dc > > Which tag exactly, please? CentOS or RHEL variant? Here is the template I am using to create new app https://raw.githubusercontent.com/openshift/svt/master/openshift_scalability/content/quickstarts/eap/eap64-mysql-pv.json
*** Bug 1414571 has been marked as a duplicate of this bug. ***
In accordance with the Red Hat Software Collections Product Life Cycle, the support period for this collection has ended. New bug fix, enhancement, and security errata updates, as well as technical support services will no longer be made available for this collection. Customers are encouraged to upgrade to a later release. Please contact Red Hat Support if you have further questions, or refer to the support lifecycle page for more information. https://access.redhat.com/support/policy/updates/rhscl/