Segmentation Fault

[Anonymous]

i have a problem with two way sync with two mysql server.

A) local server [SO Suse 9.3 – Mysql 4.1.10a ]

😎 web server [SO Red Hat 9 – Mysql 4.1.15-standard ]

first to try the sync i did a little test:

on server A

mysql> select md5(concat_ws('A','B',''));

+

---

+

| md5(concat_ws('A','B','')) |

+

---

+

| 5fc810cf62601df84b7923b9964c53e6 |

+

---

+

1 row in set (0.00 sec)

on server B

mysql> select md5(concat_ws('A','B',''));

+

---

+

| md5(concat_ws('A','B','')) |

+

---

+

| 5fc810cf62601df84b7923b9964c53e6 |

+

---

+

1 row in set (0,00 sec)

well

i have two group of tables that needing syncronization, the first group need one way sync fron A to B

it works right

the second group of tables need two way sync… the data is inserted into server B but are also modified into the server A.. i want to have the two DB sync…

but i have an error

if i start my two way sync with fkcheck = no

# /var/www/utility/sja /var/www/utility/sjaconf/sync-ordini-clienti.xml

=================================================================

SQLyog Job Agent Version 5.0

Copyright © Webyog Softworks Pvt. Ltd.. All Rights Reserved.

Sync started at Mon Jan 30 18:27:34 2006

Table SrcRows TgtRows Inserted Updated Deleted

========================= ======= ======= ======== ======= =======

clienti 47057 47057 0 0 No change

clienti 47057 47057 0 0 No change

clienti_rubrica 0 0 0 0 0

clienti_rubrica 0 0 0 0 0

note_ordini 20148 20148 0 0 No change

note_ordini 20148 20148 0 0 No change

ordini_corpo 30261 30261 0 0 No change

ordini_corpo 30261 30261 0 0 No change

ordini_testa 19076 19077 *** glibc detected *** corrupted double-linked list: 0x0825c798 ***

Abortito

if i start my two way sync with fkcheck = yes

=================================================================

# /var/www/utility/sja /var/www/utility/sjaconf/sync-ordini-clienti.xml

SQLyog Job Agent Version 5.0

Copyright © Webyog Softworks Pvt. Ltd.. All Rights Reserved.

Sync started at Mon Jan 30 18:28:43 2006

Table SrcRows TgtRows Inserted Updated Deleted

========================= ======= ======= ======== ======= =======

clienti 47057 47057 0 0 No change

clienti 47057 47057 0 0 No change

clienti_rubrica 0 0 0 0 0

clienti_rubrica 0 0 0 0 0

note_ordini 20148 20148 0 0 No change

note_ordini 20148 20148 0 0 No change

ordini_corpo 30261 30261 0 0 No change

ordini_corpo 30261 30261 0 0 No change

ordini_testa 19076 19077 Segmentation fault

if i try to set the XML conf with one way…. i have an error too

=================================================================

# /var/www/utility/sja /var/www/utility/sjaconf/sync-ordini-clienti.xml

SQLyog Job Agent Version 5.0

Copyright © Webyog Softworks Pvt. Ltd.. All Rights Reserved.

Sync started at Mon Jan 30 18:42:43 2006

Table SrcRows TgtRows Inserted Updated Deleted

========================= ======= ======= ======== ======= =======

clienti 47057 47057 0 0 0

clienti_rubrica 0 0 0 0 0

note_ordini 20148 20148 0 0 0

ordini_corpo 30261 30261 0 0 0

ordini_testa 19077 19076 *** glibc detected *** corrupted double-linked list: 0x0825c798 ***

i'm using the SJA agent for linux version 5.2 from local server

this is the XML conf

job version=”5.2″>

syncjob>

abortonerror abort=”yes” />

fkcheck check=”yes” />

twowaysync twoway=”yes” />

source>

host>xxxxx

user>xxxxx

pwd>xxxxx

port>xxxxx

database>xxxxx

/source>

target>

host>yyyyy

user>yyyyy

pwd>yyyyy

port>yyyyy

database>yyyyy

/target>

tables all=”no”>

table>

name>clienti

columns all=”yes” />

/table>

table>

name>clienti_rubrica

columns all=”yes”/>

/table>

table>

name>note_ordini

columns all=”yes”/>

/table>

table>

name>ordini_corpo

columns all=”yes”/>

/table>

table>

name>ordini_testa

columns all=”yes”/>

/table>

/tables>

/syncjob>

/job>

the table that don't work is the follow:

mysql> desc ordini_testa;

+

---

+

---

+

---

+

---

+

---

+

---

+

| Field | Type | Null | Key | Default | Extra |

+

---

+

---

+

---

+

---

+

---

+

---

+

| ord_anno | year(4) | | PRI | 0000 | |

| ord_numero | int(11) | | PRI | NULL | auto_increment |

| ord_lingua | char(3) | YES | | NULL | |

| ord_cliente | mediumint(9) | YES | | NULL | |

| ord_data | datetime | | | 0000-00-00 00:00:00 | |

| ord_pagamento | tinyint(4) | YES | | NULL | |

| ord_pagamentook | tinyint(4) | YES | | NULL | |

| ord_trasporto | float(13,2) | YES | | NULL | |

| ord_vettore | smallint(6) | YES | | NULL | |

| ord_acconto | float(13,2) | YES | | NULL | |

| ord_evaso | datetime | YES | | NULL | |

| ord_status | smallint(6) | YES | | NULL | |

| ord_conteggiato | datetime | YES | | NULL | |

| ord_scontopromo | float(13,2) | YES | | NULL | |

| ord_scontoemail | float(13,2) | YES | | NULL | |

| ord_persconto | float(5,2) | YES | | NULL | |

| ord_codpromo | varchar(16) | YES | | NULL | |

| ord_fattura | varchar(30) | YES | | NULL | |

| ord_datafattura | date | YES | | NULL | |

| ord_letvet | varchar(25) | YES | | NULL | |

| ord_scaricato | datetime | YES | | NULL | |

| ord_cognome | varchar(25) | YES | | NULL | |

| ord_nome | varchar(25) | YES | | NULL | |

| ord_indir | varchar(50) | YES | | NULL | |

| ord_cap | varchar(5) | YES | | NULL | |

| ord_localita | varchar(40) | YES | | NULL | |

| ord_localita_id | int(11) | YES | | NULL | |

| ord_prov | char(2) | YES | | NULL | |

| ord_prov_estero | varchar(25) | YES | | NULL | |

| ord_naz | char(3) | YES | | NULL | |

| ord_datanascita | date | YES | | NULL | |

| ord_luogonascita | varchar(40) | YES | | NULL | |

| ord_luogonascita_id | int(11) | YES | | NULL | |

| ord_codfisc | varchar(16) | YES | | NULL | |

| ord_sesso | enum('m','f') | | | m | |

| ord_tel1 | varchar(12) | YES | | NULL | |

| ord_tel2 | varchar(12) | YES | | NULL | |

| ord_email | varchar(64) | YES | | NULL | |

| ord_cognomefat | varchar(25) | YES | | NULL | |

| ord_nomefat | varchar(25) | YES | | NULL | |

| ord_indirfat | varchar(50) | YES | | NULL | |

| ord_capfat | varchar(5) | YES | | NULL | |

| ord_localitafat | varchar(40) | YES | | NULL | |

| ord_localita_idfat | int(11) | YES | | NULL | |

| ord_provfat | char(2) | YES | | NULL | |

| ord_prov_esterofat | varchar(25) | YES | | NULL | |

| ord_nazfat | char(3) | YES | | NULL | |

| ord_tel1fat | varchar(20) | YES | | NULL | |

| ord_tel2fat | varchar(20) | YES | | NULL | |

| ord_emailfat | varchar(64) | YES | | NULL | |

| ord_cognomespe | varchar(25) | YES | | NULL | |

| ord_nomespe | varchar(25) | YES | | NULL | |

| ord_indirspe | varchar(50) | YES | | NULL | |

| ord_capspe | varchar(5) | YES | | NULL | |

| ord_localitaspe | varchar(40) | YES | | NULL | |

| ord_localita_idspe | int(11) | YES | | NULL | |

| ord_provspe | char(2) | YES | | NULL | |

| ord_prov_esterospe | varchar(25) | YES | | NULL | |

| ord_nazspe | char(3) | YES | | NULL | |

| ord_tel1spe | varchar(20) | YES | | NULL | |

| ord_tel2spe | varchar(20) | YES | | NULL | |

| ord_emailspe | varchar(64) | YES | | NULL | |

| ord_piva | varchar(16) | YES | | NULL | |

| ord_deleted | tinyint(3) | YES | | NULL | |

| ord_ip | varchar(16) | | | | |

| ord_fatturarichiesta | tinyint(4) | | | 0 | |

| ord_filiale | varchar(24) | YES | | NULL | |

+

---

+

---

+

---

+

---

+

---

+

---

+

67 rows in set (0.00 sec)

i'm waiting for help…. i hope to solve my ync problem…

thanks

Michele Menciassi

[Ritesh]

Quote:

*** glibc detected *** corrupted double-linked list: 0x0825c798 ***

Looks to me a corrupt glibc libarary. Did you check the windows version of SJA? You can run SQLyog in Linux using WINE and it works great.

Can you check once and let me know how things progress? We have not received any segmentation fault error for v5.x yet.

[peterlaursen]

Links:

http://webyog.com/faq/31_71_en.html

http://webyog.com/faq/15_47_en.html

[Anonymous]

Ritesh wrote on Jan 31 2006, 02:53 AM:

Looks to me a corrupt glibc libarary. Did you check the windows version of SJA? You can run SQLyog in Linux using WINE and it works great.

Can you check once and let me know how things progress? We have not received any segmentation fault error for v5.x yet.

[post=”8634″]<{POST_SNAPBACK}>[/post]

well….

i have other questions…

1) can i solve the problem undating my glibc library on my local server? (the server that lunch sync script) or not?

2) i don't check windows version because i havent… i'll try to download the evaluation copy and then i'll try

[Ritesh]

Quote:

1) can i solve the problem undating my glibc library on my local server? (the server that lunch sync script) or not?

From the error code, it looks like updating your glibc will solve the problem. Meanwhile, how did working with the windows version go?

[Anonymous]

i've downloaded the enterprise trial edition for windows.

i've installed that package with wine.

but if i lunch with wine the sja.exe i have an error in the same table that generete the error with sja for linux.

this is the error:

# .wine/drive_c/Program Files/SQLyog Enterprise Trial # wine sja.exe /var/www/utility/sjaconf/sync-ordini-clienti.xml

SQLyog Job Agent Version 5.01

Copyright © Webyog Softworks Pvt. Ltd.. All Rights Reserved.

Sync started at Wed Feb 01 15:07:20 2006

Table SrcRows TgtRows Inserted Updated Deleted

========================= ======= ======= ======== ======= =======

clienti 47057 47057 0 0 No change

clienti 47057 47057 0 0 No change

clienti_rubrica 0 0 0 0 0

clienti_rubrica 0 0 0 0 0

note_ordini 20148 20148 0 0 No change

note_ordini 20148 20148 0 0 No change

ordini_corpo 30261 30261 0 0 No change

ordini_corpo 30261 30261 0 0 No change

ordini_testa 19077 19076 wine: Unhandled exception (thread 0009), starting debugger…

WineDbg starting on pid 0x8

Unhandled exception: page fault on write access to 0x0000002b in 32-bit code (0x0044886c).

In 32 bit mode.

Register dump:

CS:0023 SS:002b DS:002b ES:002b FS:0063 GS:005b

EIP:0044886c ESP:55c5954c EBP:55c59568 EFLAGS:00010206( – 00 – RIP1)

EAX:571a01e0 EBX:36303032 ECX:27203d30 EDX:00000027

ESI:572b52cc EDI:00000000

Stack dump:

0x55c5954c: 572b52d0 0000001b 572b52d0 571a0324

0x55c5955c: 27203d20 00000010 00000010 55c595a0

0x55c5956c: 00442fdc 571a0098 572b52dc 0000001b

0x55c5957c: 00000000 572b52d0 571a0098 55c59578

0x55c5958c: 55c590f8 55c5f88c 004472b8 0045c480

0x55c5959c: 00000000 00000002 00406aca 572b52d0

Backtrace:

=>1 0x0044886c in sja (+0x4886c) (0x55c59568)

2 0x00442fdc in sja (+0x42fdc) (0x55c595a0)

3 0x00406aca in sja (+0x6aca) (0x00000002)

4 0x00000000 (0x00000000)

0x0044886c: movl %ebx,0x4(%edx)

Wine-dbg>

[Anonymous]

i've updated my glibc (glibc-2.3.4-23.4.x86_64 suse 9.3 rpm)

but i have the same problem in syncronization with linux sja and windows sja…

[peterlaursen]

hmmm…

that is a 64 bit system. I have a 32 bit SuSE 10. But I don't think it will make much use to test with it.

However SuSE 64 bit systems should be pretty safe with 32 bit code – unlike Debian64 for instance.

@ritesh: on what system is it compiled ?

[peterlaursen]

I believe there are statically linked as well as a dynamically linked version available of the MySQL server, and versions that use the glic library and some that don't. Further if you have C-compiler there are sources available as a RPM-package.

With the YaST installer on SuSE it is a 5 minutes show to change the server. Even to compile it from source.

Something to choose from here

(5.0 -versions): ftp://sunsite.dk/mirrors/mysql/Downloads/MySQL-5.0/

(4.1 -versions): ftp://sunsite.dk/mirrors/mysql/Downloads/MySQL-4.1/

64-bit versions 4.1.18 compiled on SuSE 9 (non glibc-versions):

ftp://sunsite.dk/mirrors/mysql/Downloads/&#8230;.sles9.ia64.rpm (Intel)

ftp://sunsite.dk/mirrors/mysql/Downloads/…les9.x86_64.rpm (AMD).

Glibc versions:

ftp://sunsite.dk/mirrors/mysql/Downloads/…libc23.ia64.rpm

ftp://sunsite.dk/mirrors/mysql/Downloads/…bc23.x86_64.rpm

this is a statically linked 32 bit version (??):

ftp://sunsite.dk/mirrors/mysql/Downloads/…1.18-0.i386.rpm (this is what I would use on my system, since there is no build for SuSE 10 yet. Every version from 4.1.10 to 5.0.18 has installed fine! But a 64 bit version like this does not seem to be available yet!)

And a source for Suse: ftp://sunsite.dk/mirrors/mysql/Downloads/…0.sles9.src.rpm. It compiles with a single mouse-click if you have the compiler installed.

(those are standard server binaries only, you will probably need the clients as well and the max-binaries. And of course you may check what is available from SuSE online-update).

I would consider reinstalling MySQL. Then you will get it updated too. But only of course if you have safe backup routines, in case something goes wrong.

[Ritesh]

We compile SJA for Linux in FC4 machine. We statically link the binary with C libraries so that it does not have dependency problem in other systems.

[peterlaursen]

Still I would try to re-install/re-compile the MySQL server. I think recompiling using a generic RPM-source would solve any problems with incompatible updates.

[Ritesh]

Can you send me the table structure with some sample data of the concerned table?

I will try to reproduce the problem at my side. I want to be sure if theres an issue with SJA or your system.

[Author]

Posts