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@gmail.com> 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp