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

1 Jul 2015

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

Hi all

Finally I managed to get everything up and running by using regular
(i.e. non busybox) versions of:

* sleep
* ps
* xargs

Hope this helps.

Next steps are, not necessarily in this order:

* propose patches for optional component that do not build in buildroot
* create a buildroot package for xtrabackup
* package and use galera arbitrator
* create scripts for automating cluster initialisation and node
joining (the idea is to have mariadb galera cluster working in a very
unstable network)

I'll let you know.

Cheers,

Sylvain

On 25/06/2015 15:17, Sylvain Raybaud wrote:
...
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 to mysql daemon still fails with the same error, but at 
least lsof is now working as expected. That's progress :)
...
2015-06-25 14:41 GMT+02:00 Sylvain Raybaud 
mailto:sylvain.raybaud@green-communications.fr>:
...
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.
...
_______________________________________________ Mailing list: 
https://launchpad.net/~maria-discuss Post to     : 
maria-discuss@lists.launchpad.net 
mailto:maria-discuss@lists.launchpad.net Unsubscribe : 
https://launchpad.net/~maria-discuss More help   : 
https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list:
https://launchpad.net/~maria-discuss Post to     :
maria-discuss@lists.launchpad.net Unsubscribe :
https://launchpad.net/~maria-discuss More help   :
https://help.launchpad.net/ListHelp
- -- 
Sylvain Raybaud
www.green-communications.fr
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBAgAGBQJVk/xeAAoJEEkkwl4JtJ9yEn4QALLrpa1/oUKyRTt0kwGu61+T
dF7R87o+7h0ecK5qskzUHDanUNfioUAqdZVEbGN402YzFM/jAFNpV0yuDYWO44VC
YUeMgiPggNso3u6ySl6BaqoFJO/cXYFf4J/dOTMb/OT6/PXn3Ldcxd4I52uWDoNf
n1KuplyZyJF18NE0aOL88/5CCeHgmzrGCB2fiT76UBtikpg0e2jhN8UfJLAFu0TK
Q2Afe073OSGhOmsh+gh21vo2iWhad0rLcu7betmTeo7D6sKTDMmfGyvJoRTKgiS9
/o7S7Am0CXtGN2xO54FOozH51ir/KTw8u7nnHzCMI3ZaGAQpumIl2zymGQ9dCA3Y
qUs2I7Gp2P3eF84cdlXR3d3pVX0rGrA4Mw3A32Cpt7lEQmizXlOLLNpzqd2WRYs8
Jz/xVSXT17hFBdCkzuUvbCui85BKHm/Hy7zlDoX1NKrRMGwJow14xeniSFb6OoqW
nQbGMdbPdep5DpABFd5xb00ESl/Zw/kbKuUZs+T/cnVZ/XnLxMO3oyV21JgfPsZr
4mYwFQBpdqMU2zEGULioCiNkGwyLbAU7QnCGOzm04IJh5z30oNjsu7zwEGSeQxOG
lcgl9sOdgp8K8FijihJgidOZBDR2487smPJtWtpU9rpbEvS9iFJO52J7VrZ6Qzph
bP+YkhvOxqX9PnTgywY2
=OBu2
-----END PGP SIGNATURE-----