Crash when synchronizing through http tunnel

[juchli]

When using synchronization from a local mySQL database to a remote one through http tunnel I get a crash of sja.exe. I tried both version 4.01 and 4.02 of SQLyog.

This is the log from dr.watson I got; maybe it helps:

Code:

Microsoft (R) Windows 2000 (R) Version 5.00 DrWtsn32
Copyright (C) 1985-1999 Microsoft Corp. Alle Rechte vorbehalten.

Anwendungsausnahme aufgetreten:
       Anwendung:  (pid=1336)
       Wann: 08.02.2005 @ 21:40:29.195
       Ausnahmenummer: c0000005 (Zugriffsverletzung)

*—-> Systeminformationen <----*
       Computername: BA-W1201
       Benutzername: juchli
       Prozessoranzahl: 1
       Prozessortyp: x86 Family 15 Model 0 Stepping 10
       Windows 2000-Version: 5.0
       Aktuelles Build: 2195
       Service Pack: 4
       Aktueller Typ: Uniprocessor Free
       Firma: –
       Besitzer: –

*—-> Taskliste <----*
  0 Idle.exe
  8 System.exe
152 SMSS.exe
180 CSRSS.exe
200 WINLOGON.exe
228 SERVICES.exe
240 LSASS.exe
428 svchost.exe
452 spoolsv.exe
516 AVGUARD.exe
544 AVWUPSRV.exe
564 svchost.exe
608 openvpnserv.exe
628 regsvc.exe
640 openvpn.exe
716 mstask.exe
728 scsiaccess.exe
356 stisvc.exe
864 WinMgmt.exe
884 svchost.exe
896 YEDIScan.exe
1088 explorer.exe
1176 mapisnd.exe
1200 opera.exe
1260 AVGNT.exe
1268 internat.exe
1272 audevicemgr.exe
1280 TASKMGR.exe
692 CONNMN~1.exe
652 mRouterRuntime..exe
1416 EPMWOR~1.exe
500 CMD.exe
940 bash.exe
1332 ssh.exe
1420 CMD.exe
1080 mysqld.exe
988 FileMaker Pro.e.exe
132 SQLyogEnt.exe
1336 sja.exe
1432 DRWTSN32.exe
  0 _Total.exe

(00400000 – 00514000)
(77880000 – 77903000)
(74FC0000 – 74FC9000)
(77E70000 – 77F35000)
(74FA0000 – 74FB4000)
(78000000 – 78045000)
(79350000 – 793B2000)
(77D20000 – 77D91000)
(74F90000 – 74F98000)
(63000000 – 63072000)
(77C70000 – 77CB8000)
(77F40000 – 77F7E000)
(77E00000 – 77E65000)
(77830000 – 7783C000)
(77970000 – 77994000)
(77310000 – 77323000)
(774F0000 – 774F5000)
(772F0000 – 77307000)
(750C0000 – 750CF000)
(750E0000 – 7512F000)
(79430000 – 7943F000)
(77BE0000 – 77BF1000)
(77940000 – 7796B000)
(75130000 – 75136000)
(77A40000 – 77B2F000)
(779A0000 – 77A3B000)
(77380000 – 773B0000)
(77350000 – 77373000)
(77820000 – 7782E000)
(78310000 – 783A1000)
(791A0000 – 79202000)
(774B0000 – 774E3000)
(77490000 – 774A1000)
(77500000 – 77522000)
(77B40000 – 77BC9000)
(77330000 – 77349000)
(777D0000 – 777D8000)
(777E0000 – 777E5000)
(74F40000 – 74F5E000)
(74F80000 – 74F87000)
(77580000 – 777CB000)
(75A40000 – 75A45000)

Statusabbild für Threadkennung 0x5f4

eax=00000000 ebx=008a8e18 ecx=00000000 edx=00000000 esi=008a8dd8 edi=00de5dc0
eip=0040de39 esp=0012d114 ebp=0012d57c iopl=0         nv up ei pl nz na pe nc
cs=001b  ss=0023  ds=0023  es=0023  fs=0038  gs=0000             efl=00000202

Funktion:
       0040de29 cc               int     3
       0040de2a cc               int     3
       0040de2b cc               int     3
       0040de2c cc               int     3
       0040de2d cc               int     3
       0040de2e cc               int     3
       0040de2f cc               int     3
       0040de30 803900           cmp     byte ptr [ecx],0x0           ds:00000000=??
       0040de33 740c             jz      00416941
       0040de35 8b4c2404         mov     ecx,[esp+0x4]          ss:00bb6ffb=????????
FEHLER ->0040de39 8b01             mov     eax,[ecx]              ds:00000000=????????
       0040de3b 8b5104           mov     edx,[ecx+0x4]          ds:00a89ee6=????????
       0040de3e c20400           ret     0x4
       0040de41 e97a560000       jmp     004134c0
       0040de46 cc               int     3
       0040de47 cc               int     3
       0040de48 cc               int     3
       0040de49 cc               int     3
       0040de4a cc               int     3
       0040de4b cc               int     3
       0040de4c cc               int     3
       0040de4d cc               int     3

*—-> Stack Back Trace <----* FramePtr ReturnAd Param#1  Param#2  Param#3  Param#4  Function Name
0012D57C 004071C6 008A8DD8 008A9898 0012EC18 008A8E18 !
0012F830 0040920C 0012F868 00000211 00510100 00510120 !
0012FEE4 0042F5A6 00000002 008A2A08 008A2A30 00000094 !
0012FFC0 77E81AF6 00000000 00000000 7FFDF000 C0000005 !
0012FFF0 00000000 0042F43A 00000000 000000C8 00000100 kernel32!OpenEventA

*—-> Raw Stack Dump <----*
0012d114  fe 10 40 00 00 00 00 00 – d7 12 40 00 18 8e 8a 00  ..@…….@…..
0012d124  00 00 00 00 d8 8d 8a 00 – c0 5d de 00 18 8e 8a 00  ………]……
0012d134  58 9c 8a 00 68 30 de 00 – d8 8d 8a 00 18 8e 8a 00  X…h0……….
0012d144  00 00 00 00 c0 5d de 00 – 20 20 20 20 18 00 00 00  …..]..    ….
0012d154  00 00 00 00 02 00 00 00 – 05 00 00 00 02 00 00 00  …………….
0012d164  05 00 00 00 03 00 00 00 – 03 00 00 00 70 64 61 74  …………pdat
0012d174  65 64 20 20 73 68 6f 77 – 20 66 75 6c 6c 20 66 69  ed  show full fi
0012d184  65 6c 64 73 20 66 72 6f – 6d 20 60 6d 6f 64 65 6c  elds from `model
0012d194  6c 65 20 61 6c 74 60 00 – 00 00 00 00 00 00 00 00  le alt`………
0012d1a4  00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00  …………….
0012d1b4  00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00  …………….
0012d1c4  00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00  …………….
0012d1d4  00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00  …………….
0012d1e4  00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00  …………….
0012d1f4  00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00  …………….
0012d204  00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00  …………….
0012d214  00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00  …………….
0012d224  00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00  …………….
0012d234  00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00  …………….
0012d244  00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00  …………….

Statusabbild für Threadkennung 0x614

eax=778221fe ebx=00000004 ecx=0012c7b0 edx=00000000 esi=77882873 edi=00000004
eip=7788287e esp=00dcfd24 ebp=00dcfd70 iopl=0         nv up ei pl zr na po nc
cs=001b  ss=0023  ds=0023  es=0023  fs=0038  gs=0000             efl=00000246

Funktion: NtWaitForMultipleObjects
       77882873 b8e9000000       mov     eax,0xe9
       77882878 8d542404         lea     edx,[esp+0x4]          ss:01859c0b=adf00d0b
       7788287c cd2e             int     2e
       7788287e c21400           ret     0x14

*—-> Stack Back Trace <----* FramePtr ReturnAd Param#1  Param#2  Param#3  Param#4  Function Name
00DCFD70 77E78F0D 00DCFD48 00000001 00000000 00000000 ntdll!NtWaitForMultipleObjects
00DCFFB4 77E7438B 00000005 000B000A 793A5107 00132678 kernel32!WaitForMultipleObjects
00DCFFEC 00000000 778221FE 00132678 00000000 000000C8 kernel32!TlsSetValue

*—-> Raw Stack Dump <----*
00dcfd24  23 3c e7 77 04 00 00 00 – 48 fd dc 00 01 00 00 00  #<.w....H.......
00dcfd34  00 00 00 00 00 00 00 00 – 01 00 00 00 78 26 13 00  …………x&..
00dcfd44  01 00 00 00 44 03 00 00 – 40 03 00 00 30 03 00 00  ….D…@…0…
00dcfd54  c4 02 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00  …………….
00dcfd64  00 00 00 00 00 00 00 00 – 00 00 00 00 b4 ff dc 00  …………….
00dcfd74  0d 8f e7 77 48 fd dc 00 – 01 00 00 00 00 00 00 00  …wH………..
00dcfd84  00 00 00 00 00 00 00 00 – b2 22 82 77 04 00 00 00  ………”.w….
00dcfd94  b0 fe dc 00 00 00 00 00 – ff ff ff ff 78 26 13 00  …………x&..
00dcfda4  07 51 3a 79 0a 00 0b 00 – c8 f5 a0 e4 cc f5 a0 e4  .Q:y…………
00dcfdb4  e0 f3 0a 82 00 00 00 00 – 01 00 00 00 38 00 00 00  …………8…
00dcfdc4  23 00 00 00 23 00 00 00 – 0a 00 0b 00 07 51 3a 79  #…#……..Q:y
00dcfdd4  78 26 13 00 ff ff ff ff – b0 c7 12 00 fe 21 82 77  x&………..!.w
00dcfde4  f8 eb fd 7f 33 43 e7 77 – 1b 00 00 00 00 02 00 00  ….3C.w……..
00dcfdf4  fc ff dc 00 23 00 00 00 – 0c db 50 bc 05 00 00 00  ….#…..P…..
00dcfe04  51 f5 40 80 98 00 00 00 – f8 00 00 00 98 00 00 00  Q.@………….
00dcfe14  00 db 50 bc 05 00 00 00 – 24 00 01 e1 05 00 00 00  ..P…..$…….
00dcfe24  fe ff f8 00 38 5c a1 81 – 34 00 00 c0 48 86 43 e3  ….8..4…H.C.
00dcfe34  02 00 00 00 49 03 00 00 – 48 86 43 e3 5c db 50 bc  ….I…H.C..P.
00dcfe44  90 33 0b 82 b4 db 50 bc – 5e 1a 45 80 08 85 00 e1  .3….P.^.E…..
00dcfe54  e0 f3 0a 82 a0 db 46 80 – 28 33 0b 82 b0 dc 50 bc  ……F.(3….P.

[Ritesh]

Can you tell me more about your setup?

Sample data to reproduce the error will be very helpful.

[juchli]

I think I found the mistake I made: I have not defined a primary key in the tables to synchronize. After defining the primary key it works fine. However, I think the synchronization still should not crash in this way :-).

But anyway, thanks for a really great, nice to use and powerful piece of software! It really saves me a lot of time managing a remote mySQL server that is behind a firewall.

Thanks for your work!

[Ritesh]

Quote:

However, I think the synchronization still should not crash in this way :-).

It should not crash under any circumstances. It means that there is a bug in SJA which needs to addressed. Can you tell me your sync setup? Sample table structure and data to reproduce the bug will be appreciated.

[Author]

Posts