← Back to team overview

maria-discuss team mailing list archive

Re: 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 gives me the following sequence repating forever:

+ check_pid_and_port /var/lib/mysql//rsync_sst.pid 20189 4444
+ local pid_file=/var/lib/mysql//rsync_sst.pid
+ local rsync_pid=20189
+ local rsync_port=4444
+ which lsof
++ lsof -i :4444 -Pn
++ grep '(LISTEN)'
+ local port_info=
++ echo
++ grep -w '^rsync[[:space:]]\+20189'
+ local is_rsync=
+ '[' -n '' -a -z '' ']'

It seems to correspond to lines 281--284:
until check_pid_and_port $RSYNC_PID $RSYNC_REAL_PID $RSYNC_PORT
    do
        sleep 0.2
    done

check_pid_and_port seems to be checking that rsync is running and
listening, basically. Strange thing is: lsof -i :4444 -Pn doesn't
return anything although ps shows that rsync was invoked correctly:
rsync --daemon --no-detach --port 4444 --config
/var/lib/mysql//rsync_sst.conf

Actually, lsof -i :4444 -Pn seems to behave rather differently on my
laptop (ubuntu) and on buildroot. Indeed, lsof in buildroot is
provided by busybox by default. This sometimes leads to significant
differences. I'm going to rebuild my system with the real lsof package
and see if it gets better. I'll let you know.

> 
> You can also try to run the SST command manually on the nodes, and
> see what it does. You can get the full command output in ps so
> you're free to start a donor on one node and a joiner on another
> node and follow the script output.

I did, and it fails because some variables are unbound. I think this
is specific to manual invokation.

- -- 
Sylvain Raybaud
www.green-communications.fr

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBAgAGBQJVi/bfAAoJEEkkwl4JtJ9y2VQP/08Fa6NVtKwH2tlgJN5TOyqB
TNKOEqvSW9LFIjCSpAbxANqkWRmHPbSfoxwK9Komqtp4B4YdIkHSDMxIgx5e8j+W
VPJL9nLqB26g+jn3KkKS1N/uqK5O5DwUCBxT3+XtQkk0PpboemIQeE/pKpqoWCtG
BMYEcFxO8pj91ICyy8dGHwQfmza5jLjnWQmJoqDlxNJs42YnDAnYVAIFgX6tsu0O
lwWNHComc6dov+dEe6IgMow9sL9GyQBmeUg+jeB+7RpmtParPY9ISb0HRCwDQ9K/
4nkgq9gJaCKUXnTwoIU8SIPLuEeXIqpBJNwQSpB6Sz9QlNGb11bH2y1Z/tEF/aQ9
rbp4F3VbWds66fJzBp9NbjqOP1/ZLkucwJN3EBVGqF8R2HfVMwGsjF3Mhz4iDajJ
gOmKnAf3lgdyfA1zD0lGVqZlm+V/c13ODlDlutqpOJ7a6BUZ3rDEYtecLgAzEjNt
eA7pBPXPARTS/ploYEHmUhFqw/oxRacnmScFrQgF0N/v3xal2CFSZD900oOKhs32
bfBTgqCvrCCrOSxWVV+4BdUUC+AS7S/pfQyJo1NyeK9aUy/wX+f7T3RtuZiyAzNM
9j2ewgM7WEYrLIJmEbBjYR4KYJ0EETc3Pw3di2E7k0tP8n790hSuDO3tYe8Y7Om2
1CyL46/Rd0HpSfyk9n81
=y4Fn
-----END PGP SIGNATURE-----


Follow ups

References