[ https://forge.continuent.org/jira/browse/SEQUOIA-939?page=all ]
Mathieu Peltier resolved SEQUOIA-939:
-------------------------------------
Resolution: Fixed
Fixed in BRANCH_sequoia-2_10
> Restore command of MySQLBackuper backuper may restore the wrong database
> ------------------------------------------------------------------------
>
> Key: SEQUOIA-939
> URL: https://forge.continuent.org/jira/browse/SEQUOIA-939
> Project: Sequoia
> Type: Bug
> Components: Backup System
> Versions: Sequoia 2.10.6
> Reporter: Mathieu Peltier
> Assignee: Mathieu Peltier
> Priority: Critical
> Fix For: Sequoia 2.10.7
>
>
> Workaround: make sure that same real database name is used for all backends
> of a given database.
> Test case:
> controller 1 (192.168.0.100)
> colocated backend db3
> remote backend db4 (192.168.0.102)
> - Backend backend [EMAIL PROTECTED] into
> /opt/archive/mcluster/db1_vbtest_com_Dump_1
> - Print content of [EMAIL PROTECTED]:
> [EMAIL PROTECTED] ~]# mysql -h 192.168.0.102 --port=3306 -urealuser
> --password=realpass db3
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 72 to server version: 4.1.21-standard
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> mysql> show tables;
> +---------------+
> | Tables_in_db3 |
> +---------------+
> | foo2 |
> +---------------+
> 2 rows in set (0.00 sec)
> - Restore dump on [EMAIL PROTECTED]:
> [EMAIL PROTECTED] ~]# mysql -h 192.168.0.102 --port=3306 -urealuser
> --password=realpass db4 < /opt/archive/mcluster/db1_vbtest_com_Dump_1
> - [EMAIL PROTECTED] has being restored instead of [EMAIL PROTECTED]: <-- ERROR
> [EMAIL PROTECTED] ~]# mysql -h 192.168.0.102 --port=3306 -urealuser
> --password=realpass db3
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 74 to server version: 4.1.21-standard
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> mysql> show tables;
> +---------------+
> | Tables_in_db3 |
> +---------------+
> | foo2 |
> +---------------+
> 1 row in set (0.00 sec)
> [EMAIL PROTECTED] ~]# mysql -h 192.168.0.102 --port=3306 -urealuser
> --password=realpass db4
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 75 to server version: 4.1.21-standard
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> mysql> show tables;
> Empty set (0.00 sec)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
