Re: [Maria-discuss] Can't connect to local MySQL server through socket

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 25/06/2015 14:42, Guillaume Lefranc wrote: > Well, if you had said that your shell was busybox in the first > place, that would have saved us a lot of time... :-) It's not my shell, my shell is regular bash, but many other tools, yes. Connecting t

Re: [Maria-discuss] Can't connect to local MySQL server through socket

Well, if you had said that your shell was busybox in the first place, that would have saved us a lot of time... :-) 2015-06-25 14:41 GMT+02:00 Sylvain Raybaud < sylvain.rayb...@green-communications.fr>: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Guillaume, > > On 25/06/2015 13:40, Guil

Re: [Maria-discuss] Can't connect to local MySQL server through socket

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Guillaume, On 25/06/2015 13:40, Guillaume Lefranc wrote: > Just a suggestion, you can try adding "set -x" to > /usr/bin/wsrep_sst_rsync, so the script will dump its output in the > log. You should be able to know where it hangs precisely then. It gi

Re: [Maria-discuss] Can't connect to local MySQL server through socket

Sylvain, I don't know much what buildroot does, so I don't know if you're hitting any limitation that buildroot might have. Just a suggestion, you can try adding "set -x" to /usr/bin/wsrep_sst_rsync, so the script will dump its output in the log. You should be able to know where it hangs precisel

Re: [Maria-discuss] Can't connect to local MySQL server through socket

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi I'll try hard to fix the problem with rsync, even if I switch to mysqldump or xtrabackup-v2 in the future. Some context : mariadb and galera are built in buildroot and run on raspberry pis (ARMv6). Mariadb is started manually. I fixed the config f

Re: [Maria-discuss] Can't connect to local MySQL server through socket

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Guillaume, Nirbhay, On 24/06/2015 15:35, Guillaume Lefranc wrote: > If you want to try xtrabackup SST: * xtrabackup must be installed > on all servers * you need to set wsrep_sst_method=xtrabackup-v2 > (the older method is full of horrible bugs) * you

Re: [Maria-discuss] Can't connect to local MySQL server through socket

On Wed, Jun 24, 2015 at 9:30 AM, Sylvain Raybaud < sylvain.rayb...@green-communications.fr> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 24/06/2015 15:11, Guillaume Lefranc wrote: > > Sylvain, > > > > On Wed, Jun 24, 2015 at 3:06 PM, Sylvain Raybaud > > >

Re: [Maria-discuss] Can't connect to local MySQL server through socket

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 24/06/2015 15:11, Guillaume Lefranc wrote: > Sylvain, > > On Wed, Jun 24, 2015 at 3:06 PM, Sylvain Raybaud > > wrote: > > >> >> I forgot to mention in my previous mail that after starting >> mari

Re: [Maria-discuss] Can't connect to local MySQL server through socket

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 24/06/2015 15:00, Guillaume Lefranc wrote: > > > 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

Re: [Maria-discuss] Can't connect to local MySQL server through socket

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 24/06/2015 14:38, Guillaume Lefranc wrote: > Also if I'm correct, you must have rsync running on the processlist > of node 2. As mentioned in my previous email, I don't have much data in this db. However, I do have rsync running on nodes #2 and #3,

Re: [Maria-discuss] Can't connect to local MySQL server through socket

-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 require

Re: [Maria-discuss] Can't connect to local MySQL server through socket

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi On 24/06/2015 14:13, Guillaume Lefranc wrote: > Hello Sylvain, > > the last lines of the error log of nodes 2 and 3 would be more > helpful. Here are the last 20 lines of error log on node #2: http://pastebin.com/XQduzP18 and node #3: http://pas

Re: [Maria-discuss] Can't connect to local MySQL server through socket

Hello Sylvain, the last lines of the error log of nodes 2 and 3 would be more helpful. Also how do you start your cluster? Do you bootstrap the first node correctly then start the two other nodes? Thanks Guillaume 2015-06-24 14:04 GMT+02:00 Sylvain Raybaud < sylvain.rayb...@green-communications.