maria-discuss team mailing list archive

[Sylvain Raybaud <sylvain.raybaud@xxxxxxxxxxxxxxxxxxxxxxx>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 24/06/2015 14:38, Guillaume Lefranc wrote:
> Sylvain,
> 
> the logs tell that node 2 and 3 have joined the cluster, but that
> they are not yet in sync. This is very clear in logs of node 2:
> 
> 700101  0:00:35 [Note] WSREP: *State transfer required:* Group
> state: 7cf7113a-1dd3-11b2-a623-76b507fb8ed5:0 Local state:
> 00000000-0000-0000-0000-000000000000:-1 700101  0:00:35 [Note]
> WSREP: New cluster view: global state: 
> 7cf7113a-1dd3-11b2-a623-76b507fb8ed5:0, view# 11: Primary, number
> of nodes: 3, my index: 0, protocol version 3 700101  0:00:35
> [Warning] WSREP: *Gap in state sequence. Need state transfer.* 
> 700101  0:00:35 [Note] WSREP: Running: 'wsrep_sst_rsync --role
> 'joiner' --address '192.168.1.80' --auth '' --datadir
> '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --parent
> '420' --binlog '/var/lib/mysql/mariadb-bin' '
> 
> I assumed that you started your cluster empty, which might not be
> the case. If you have several gigabytes of data on the first node,
> you have to allow some time until rsync has finished copying the
> data to the other nodes. You can do that by tailing the error log
> of node 2 until the SYNCED state keyword appears. Also if I'm
> correct, you must have rsync running on the processlist of node 2.

Nope, the database is empty (I just created it with mysql_install_db;
also all nodes are fresh installs). Only the first node has SYNCED in
its log indeed:
# grep SYNCED buildroot.err
700101  0:01:10 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)

The two others show neither SYNCED or any reference to mysql.sock.



I forgot to mention in my previous mail that after starting mariadb in
the first node I run:

mysql -u root --execute="SET GLOBAL wsrep_cluster_address='gcomm://';"

but you probably guessed since I'd get a different error if I hadn't.

- -- 
Sylvain Raybaud
www.green-communications.fr
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBAgAGBQJViqhmAAoJEEkkwl4JtJ9y7ioP/A5sGSaNrJ8jJhPaaN38XIEQ
UAjUxUFyQQBEuzmvo3LY5PoTXKNXjWzhMHL6+bFqvIYb7RXa2mC/jm/gowuNIE8v
jBz8NOjUbH/nayWFQquguEOe1EBO2671CNWsGmpqzKkxj5CVq4SykTk34+d6xUye
7EubHiOUKYK5BuILY3zBaVzxGeBlHaZsZCx7C65a81bgB+0wOMFQED2u5u24VbwA
pm6+q+psR8O0H6EdeMzgPCvxgQZeGi+HahXWAZuts3/mkTbFpEgFeg/xt8x9jIg9
vz6K6Q5TD43NaMs+XD86Z4mgGPBaEapZKc9YQV8Ge58gngkgZt9L4q+mi//ISZ1z
CCbsQlUd6JqLethWLAIr0VdXLU26P28kVza4aAqjnkl9Pz1s4CmweSg4tuo7avXk
DDV9//7kOFbAKdLJX+egpHu+fb+WwgWeSKNzdauKjTGfH+qPSPb10j2GSowedEK/
WzCWsZb0GZyn8gHRPMDC6olSs+daCp8imWqKw70LOAjCzMcBrFG/ynMWB8vBoHqU
Q5KgEhfUStDLMMZkqgI1Ov91LZDPPG2zr0mjwe7+k7xc5GO6gtih/F8atruT2PRu
cdgEvapcR8Qp+fsBlzVdeK15yVrxaWrZDDhh+YaYuLS2kzDW3KGwqHUNYykhyLcl
QgaIDguJcH4ye95Sb2Cv
=CpJL
-----END PGP SIGNATURE-----