maria-discuss team mailing list archive

[l vic <lvic4594@xxxxxxxxx>]

Found the problem: didn't shutdown mysqld before i attempted restore

On Mon, Dec 19, 2016 at 7:02 PM, Stephane VAROQUI <stephane@xxxxxxxxxxx>
wrote:

> Hi Vic,
>
> May be that is the type of life in a cluster, how did you restart you node
> after restoring backup:  did you tell the system it’s a new cluster ?
>
> /svar
>
> Stéphane Varoqui, Senior Consultant
> Phone: +33 695-926-401, skype: svaroqui
> http://www.mariadb.com
>
> Le 19 Dec 2016 à 22:25, l vic <lvic4594@xxxxxxxxx> a écrit :
>
> i have installed mariadb 1.10.13 cluster with user "root", password "pass"
> I have created test database "galeratest":
>
> CREATE DATABASE galeratest;USE galeratest;CREATE TABLE test_table (
>         id INT PRIMARY KEY AUTO_INCREMENT,
>         msg TEXT ) ENGINE=InnoDB;INSERT INTO test_table (msg)
>         VALUES ("Hello cluster.");
>
> backup:
> xtrabackup --user=root --password=pass --backup --target-dir=/media
> 161219 21:06:00  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/var/run/mysqld/mysqld.sock' as 'root'  (using password: YES).
> 161219 21:06:00  version_check Connected to MySQL server
> 161219 21:06:00  version_check Executing a version check against the server...
> ...
>
> ok
> ..
>
> At this point i drop my database : DROP DATABASE galeratest;
>
> and trying to restore:
> xtrabackup --user=root --password=pass --prepare --target-dir=/media
>
>
> cd /media/
> rsync -rvt --exclude 'xtrabackup_checkpoints' --exclude 'xtrabackup_logfile' \
>    ./ /var/lib/mysql
> chown -R mysql:mysql /var/lib/mysql/
>
> MariaDB [galeratest]> show tables;
> +----------------------+
> | Tables_in_galeratest |
> +----------------------+
> | test_table           |
> +----------------------+
> 1 row in set (0.00 sec)
>
> MariaDB [galeratest]> select * from test_table;
>
>
> *ERROR 1932 (42S02): Table 'galeratest.test_table' doesn't exist in engine*
>
> *Any idea what the problem is? *
>
> Thanks,
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>
>