Segmentation Fault: Sja 6.07 Running On Ubuntu 7.04

[Big Dane]

I've just download SJA and when I try to do a “twowaysync” on my Ubuntu 7.04 server:

Code:

I get the following Segmentation fault error:

Code:

SQLyog Job Agent Version 6.07
Copyright(c)Webyog Softworks Pvt. Ltd.. All Rights Reserved.

Sync started at Tue Oct 9 08:47:05 2007

Segmentation fault

My server is running:

Code:

Linux ServerName 2.6.20-16-server #2 SMP Thu Aug 30 23:21:48 UTC 2007 x86_64 GNU/Linux

Any idea, how to solve this problem? And how can I debug to get more knowledge about the cause?

[peterlaursen]

please tell: Is it a 32 bit or 64 bit Ubuntu?

Also always tell the MySQL versions involved (bothand )

First you should find out if the error is specific for a host, a database or if it happens all the time. los tell if it happens with 'two-way' only and not 'one-way'. As many details as you are able to find out!

If it is specific for some data:

best of all if you reproduce it with a small test case including

* a DUMP fromand

* the job-file

Please ZIP (or TAR) everything. Attach here or create a ticket if you want privacy. You may of course fake passwords …

If it is specific for some host it would be nice if we could have temporary access to that server.

[Big Dane]

Hi Peter, I have gathered the following information:

TARGET server info: YES, 64bit Ubuntu

Code:

Linux ServerName 2.6.20-16-server #2 SMP Thu Aug 30 23:21:48 UTC 2007 x86_64 GNU/Linux

MySQL SOURCE info:

Code:

Welcome to the MySQL monitor. Commands end with; or g.
Your MySQL connection id is 127344
Server version: 5.0.27-standard-log MySQL Community Edition – Standard (GPL)

MySQL TARGET info:

Code:

Welcome to the MySQL monitor. Commands end with; or g.
Your MySQL connection id is 37889
Server version: 5.0.38-Ubuntu_0ubuntu1-log Ubuntu 7.04 distribution

SJA job describtion:

Code:

host
user pass 3306 dbname

localhost
user pass 3306 dbname

TEST case:

As a test I've tried to do a SJA job, at my localhost (source=target) and nothing happens:

– the SJA.LOG is empty: “Sync started at Tue Oct 9 15:06:23 2007” – nothing more than that.

– the SJASESSION.XML has this info: ““

Can I call SJA in debug or some kind of verbose log mode?

[peterlaursen]

I think I recall something similar happening before on Ubuntu 64 bit.

I will research details ….

[peterlaursen]

No – I am confusing this with an issue with MONyog on 64 bit Gentoo.

Do you have full 32 bit support installed?

(we have tested on Ubuntu 64 with 32 bit support installed and had no issues). Now we have replaced the OS on that machine with a Fedora 64 bit.

It is very hard for you to debug such thing .. practically impossible I think. It is a compiled binary, not a script.

Test case and/or temporary access to the server(s) would be best solution

[Big Dane]

With help from a more (than me) decent Linux admin, we managed to debug the problem (used gdb to debug) and it seems that SJA is looking for the MySQL socket in the wrong location.

This is how my MySQL is configured (/etc/mysql/my.cnf):

Code:

socket = /var/run/mysqld/mysqld.sock

But this is where SJA looks for the socket:

Code:

socket = /var/lib/mysql/mysql.sock

So, the short term solution is, to make a softlink, like described here: http://www.webyog.com/forums//index.php?showtopic=1367

[Author]

Posts