← Back to team overview

maria-discuss team mailing list archive

Re: 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.raybaud@xxxxxxxxxxxxxxxxxxxxxxx>:

> -----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-----
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>

Follow ups

References