Bug 970914
Summary: | Mysql big data snapshot restore failed | |||
---|---|---|---|---|
Product: | OpenShift Online | Reporter: | nsun <nsun> | |
Component: | Containers | Assignee: | Fotios Lindiakos <fotios> | |
Status: | CLOSED CURRENTRELEASE | QA Contact: | libra bugs <libra-bugs> | |
Severity: | medium | Docs Contact: | ||
Priority: | medium | |||
Version: | 2.x | CC: | fotios, jkeck, mpatel, xtian | |
Target Milestone: | --- | |||
Target Release: | --- | |||
Hardware: | Unspecified | |||
OS: | Unspecified | |||
Whiteboard: | ||||
Fixed In Version: | Doc Type: | Bug Fix | ||
Doc Text: | Story Points: | --- | ||
Clone Of: | ||||
: | 978344 (view as bug list) | Environment: | ||
Last Closed: | 2013-06-24 14:51:00 UTC | Type: | Bug | |
Regression: | --- | Mount Type: | --- | |
Documentation: | --- | CRM: | ||
Verified Versions: | Category: | --- | ||
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | ||
Cloudforms Team: | --- | Target Upstream Version: | ||
Embargoed: | ||||
Bug Depends On: | ||||
Bug Blocks: | 978344 |
Description
nsun
2013-06-05 08:16:10 UTC
I am trying to reproduce this. This script will create the data quicker because it's only making a single mysql call. ruby -e "1000000.times{puts 'INSERT INTO info VALUES(NULL,\'This is testing data for testing snapshoting and restoring big data in mysql database.\');'}" > /tmp/insert.sql && mysql -D $OPENSHIFT_APP_NAME < /tmp/insert.sql I've modified the mysql dump to be a little smaller using --extended-insert as well as speeding up the restore by turning off autocommit and some data checks. This is working in my manual testing. I will run the extended database tests and then submit a pull request. Testing this PR now: https://github.com/openshift/origin-server/pull/2891 PR is currently merging, should be available for testing shortly Commit pushed to master at https://github.com/openshift/origin-server https://github.com/openshift/origin-server/commit/24fbcce38965191489916c30736927300350eeca Bug 970914 - Mysql big data snapshot restore failed Verfied on devenv_3383. |