maria-discuss team mailing list archive

[Max Zulio <zulioexpress@xxxxxxxxx>]

Hi Jamie,

If I kill -9 mysqld on all three of my nodes in the cluster, then start the
services simultaneously,the cluster comes back online successfully using
the gvwstate.dat file.

If I gracefully shutdown mysql on all three nodes as you mentioned the
gvwstate.dat file is deleted. This means when the cluster needs to be
restarted I am forced to edit my.cnf and replace
wsrep_cluster_address=gcomm://x.x.x.x,y.y.y.y,z.z.z.z with
wsrep_cluster_address=gcomm:// on one of the nodes before I can bring up
the cluster.

Is there anyway to have the last node that is shutdown gracefully keep it's
gvwstate.dat file so that the next time the cluster is started it can come
online without editing the config file?

Thanks,

Max

On Thu, Aug 13, 2015 at 1:34 PM, Jamie Gibbard <Jamie.Gibbard@xxxxxxxxxxxx>
wrote:

> Hi,
>
> Are you sure there are no other errors? I'm not sure that the file being
> missing is the problem there:
>
> When a node stores the Primary Component state to disk, it saves it as the
> gvwstate.dat file. The node creates and updates this file when the cluster
> forms or changes the Primary Component. This ensures that the node retains
> the latest Primary Component state that it was in. If the node loses
> connectivity, it has the file to reference. If the node shuts down
> gracefully, it deletes the file.
>
> You might want to paste the full log exert into a Pastie style website,
> give a fuller description about the node restart (for instance, were you
> expecting an IST? an SST? Do the nodes form a cluster at all? etc etc ).
> That would probably be helpful to someone willing to assist.
>
> Thanks,
>
> Jamie.
>
>
> ________________________________________
> From: Maria-discuss [maria-discuss-bounces+jamie.gibbard=
> netnames.com@xxxxxxxxxxxxxxxxxxx] on behalf of Max Zulio [
> zulioexpress@xxxxxxxxx]
> Sent: 13 August 2015 12:17
> To: maria-discuss@xxxxxxxxxxxxxxxxxxx
> Subject: [Maria-discuss] Mariadb 10.1.6,        total cluster recovery -
> gvwstate.dat
>
> Hi,
>
> I am using a Mariadb 10.1.6 three node cluster with wsrep. There is a
> gvwstate.dat file created in /var/lib/mysql, but in the log file when
> restarting the nodes I see: [Warning] WSREP: access file(gvwstate.dat)
> failed(No such file or directory).
>
> This seems to be the only thing stopping automatic cluster recovery. Where
> is mariadb looking for the file, or is there a way of configuring the file
> location?
>
> Thanks,
>
> M
> NetNames, 25 Canada Square, Canary Wharf, London E14 5LQ, UK | Tel: +44
> 207 015 9200 | NetNames Limited, Registered in England and Wales, Company
> number: 3169594, VAT Number: GB 739633893
>