forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Memory Corruption
- This topic is empty.
-
AuthorPosts
-
-
October 10, 2006 at 5:35 pm #9958AnonymousGuest
Hi,
i have 2 server
A) local server [SO Suse 9.3 – Mysql 4.1.10a ]
😎 remote server [SO Debian 3.1 – Mysql 5.0.24a]
i'm using SQLyog Job Agent Version 5.18
i need 2 kind of sync
1) Item – one way sync – ok
2) Order – two way sync – not ok
this is the error… i have that error in two-wy sync and in one way sync…
i have the error always in ordini_testa ( head of order ) and ordini_corpo ( body of order ) tables.
Table SrcRows TgtRows Inserted Updated Deleted
========================= ======= ======= ======== ======= =======
clienti 54668 54668 0 0 0
clienti_rubrica 0 0 0 0 0
note_ordini 30416 30416 0 0 0
ordini_testa 42954 30013 *** glibc detected *** malloc(): memory corruption: 0x08260620 ***
Abortito
can you help me to correct that error???
my glibc is updated… 4.1.10a is the newest mysql package in suse repository…
if i can solve that problem without recompile mysql i prefere… now i've only the package of the distribution…
i made the MD5 test…
on remote
mysql> select md5(concat_ws('A','B',''));
+
+| md5(concat_ws('A','B','')) |
+
+| 5fc810cf62601df84b7923b9964c53e6 |
+
+1 row in set (0.00 sec)
and on local too
mysql> select md5(concat_ws('A','B',''));
+
+| md5(concat_ws('A','B','')) |
+
+| 5fc810cf62601df84b7923b9964c53e6 |
+
+1 row in set (0,00 sec)
i've try to truncate the ordini_testa and ordini_corpo tables on local server… ( i try on a test DB, a duplicate of real DB )
well if i try sync now i have no error
Table SrcRows TgtRows Inserted Updated Deleted
========================= ======= ======= ======== ======= =======
clienti 54668 54668 0 0 No change
clienti 54668 54668 0 0 No change
clienti_rubrica 0 0 0 0 0
clienti_rubrica 0 0 0 0 0
note_ordini 30416 30416 0 0 No change
note_ordini 30416 30416 0 0 No change
ordini_testa 42954 42954 0 0 No change
ordini_testa 42954 42954 0 0 No change
ordini_corpo 69097 69097 0 0 No change
ordini_corpo 69097 69097 0 0 No change
but if i add a new record on local table
Table SrcRows TgtRows Inserted Updated Deleted
========================= ======= ======= ======== ======= =======
clienti 54668 54668 0 0 No change
clienti 54668 54668 0 0 No change
clienti_rubrica 0 0 0 0 0
clienti_rubrica 0 0 0 0 0
note_ordini 30416 30416 0 0 No change
note_ordini 30416 30416 0 0 No change
ordini_testa 42955 42954 *** glibc detected *** malloc(): memory corruption: 0x08260620 ***
Abortito
-
October 13, 2006 at 10:57 am #22764adarshMember
hi
we are not able to reproduce here so please provide
above mentioned table create statement.
Adarsh
WebYog
-
October 13, 2006 at 1:13 pm #22765AnonymousGuestadi1 wrote on Oct 13 2006, 10:57 AM:hi
we are not able to reproduce here so please provide
above mentioned table create statement.
i've attach a zip file with the schema and some few data
and here i've put the xml shema for sync
job version=”5.2″>
syncjob>
abortonerror abort=”yes” />
fkcheck check=”no” />
twowaysync twoway=”yes” />
source>
host>xxxxxx
user>xxxxxx
pwd>xxxxxx
port>xxxx
database>xxxxxx
/source>
target>
host>xxxxxx
user>xxxxxx
pwd>xxxxxx
port>xxxx
database>xxxxxx
/target>
tables all=”no”>
table>
clienti /table>
table>
clienti_rubrica /table>
table>
note_ordini /table>
table>
ordini_testa /table>
table>
ordini_corpo /table>
/tables>
/syncjob>
/job>
-
October 13, 2006 at 3:00 pm #22766adarshMember
bug is confirmed!
we will fix this in next beta.
thanks for reporting.
bye
Adarsh
Webyog
-
October 13, 2006 at 3:09 pm #22767AnonymousGuestadi1 wrote on Oct 13 2006, 03:00 PM:bug is confirmed!
we will fix this in next beta.
thanks for reporting.
bye
Adarsh
Webyog
well… can you tell me when you think release next beta?
-
October 13, 2006 at 3:31 pm #22768ManojMember
Hello,
The bug is fixed in the 5.2 Beta6 development tree.
Expect a release on next Monday or Tuesday.
Regards,
Manoj
Webyog
-
October 13, 2006 at 4:22 pm #22769AnonymousGuestManoj wrote on Oct 13 2006, 03:31 PM:Hello,
The bug is fixed in the 5.2 Beta6 development tree.
Expect a release on next Monday or Tuesday.
Regards,
Manoj
Webyog
very good…
i'm wait for next release
regards
Michele
-
October 13, 2006 at 9:22 pm #22770peterlaursenParticipant
Please refer to:
-
October 16, 2006 at 1:20 pm #22771adarshMember
hi
today we released SQLyog 5.2 beta6 version you can download from this link.
http://www.webyog.com/forums//index.php?showtopic=2507
bye
Adarsh
Webyog
-
-
AuthorPosts
- You must be logged in to reply to this topic.