maria-discuss team mailing list archive

[Sylvain Raybaud <sylvain.raybaud@xxxxxxxxxxxxxxxxxxxxxxx>]

-----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 
>> <sylvain.raybaud@xxxxxxxxxxxxxxxxxxxxxxx 
>> <mailto:sylvain.raybaud@xxxxxxxxxxxxxxxxxxxxxxx>>:
> 
>> 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@xxxxxxxxxxxxxxxxxxx 
>> <mailto:maria-discuss@xxxxxxxxxxxxxxxxxxx> Unsubscribe : 
>> https://launchpad.net/~maria-discuss More help   : 
>> https://help.launchpad.net/ListHelp
> 
> 
> 
> 
> _______________________________________________ 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
> 

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