Red Hat Bugzilla – Bug 866416
Failed to connect mysql after snapshot restored to a new created scalable app
Last modified: 2015-05-14 19:00:47 EDT
Description of problem:
Mysql data couldn't be resotred to a new scalable jbossews app, it can't connect to mysql shell as below:
[myscalapp1-jingdev1.dev.rhcloud.com ~]\> mysql
ERROR 1130 (HY000): Host '127.0.254.129' is not allowed to connect to this MySQL server
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1.Create an scaling jbossews app
rhc app create -a app1 -t jbossews-1.0 -s
2. Disable auto scaling by:
create new file $APP_Dir/.openshift/markers/disable_auto_scaling
git commit -a -m "disable_auto_scaling"
3. Scale up by rest API
4. Add mysql to the app
#rhc cartridge add mysql-5.10 -a app1
5. Write some data to mysql
6. Snapshot save this app
#rhc snapshot save app1 -p xx
7. Delete this app
#rhc delete app app1 --confirm
8. Repeat step 1 to 4 to create a new scalable app with mysql added.
9. Restore snapshot
#rhc snapshot restore app1 -f ./app1.tar.gz
10. SSH into the app and check mysql data
It can't connect to mysql.
Mysql shell can be accessed, and data is restored.
1. It works well if snapshot restored to an existing scalable app.
2. It's also reproduced in other cartridges, like php-5.3.
Fix awaiting merge: https://github.com/openshift/origin-server/pull/691
(In reply to comment #1)
> Fix awaiting merge: https://github.com/openshift/origin-server/pull/691
Above is merged in devenv-2340, move it to ON_QA to verify
This bug has been verified on devenv_2340 with rhc-0.99.7.gem client. It's fixed. mysql can be accessed after the new created scalable app restored, and data is back as well. So mark it as Verified.Thanks.
Move it to verified according to comment 3.