MySQL Forums :: Workbench - Schema Compare, Diff, Synch :: Workbench, Gnome crashes when Synchronizing

Hello,

Has anybody experienced this? While synchronizing model to source on remote server over SSH Workbench crashes fatally, gnome crashes and becomes unstable. This is done through the synchronizing wizard. I have synchronized this schema before with tables just as large without issue. Also crashes instantly when selecting “Synchronize with Any Source”. I checked for reported bugs but did not see anything like this. But I could have missed it. The server is running Ubuntu Server 10.10 and the client is running Ubuntu 10.10. The SSH is local.

Could the size of the sql be the issue

Thanks for the help

See sql below

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;

SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;

SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';



ALTER TABLE `Test`.`actrec` CHANGE COLUMN `RECNUM,N,10,0` `RECNUM,N,10,0` INT(10) NOT NULL DEFAULT NULL , CHANGE COLUMN `CLNNUM,N,10,0` `CLNNUM,N,10,0` INT(10) NULL DEFAULT NULL , CHANGE COLUMN `CONTCT,C,30` `CONTCT,C,30` VARCHAR(30) NULL DEFAULT NULL , CHANGE COLUMN `ADDRS1,C,30` `ADDRS1,C,30` VARCHAR(30) NULL DEFAULT NULL , CHANGE COLUMN `ADDRS2,C,30` `ADDRS2,C,30` VARCHAR(30) NULL DEFAULT NULL , CHANGE COLUMN `CTYNME,C,25` `CTYNME,C,25` VARCHAR(25) NULL DEFAULT NULL , CHANGE COLUMN `ZIPCDE,C,10` `ZIPCDE,C,10` VARCHAR(10) NULL DEFAULT NULL , CHANGE COLUMN `PHNNUM,C,14` `PHNNUM,C,14` VARCHAR(14) NULL DEFAULT NULL , CHANGE COLUMN `ACHTCT,N,10,0` `ACHTCT,N,10,0` INT(10) NULL DEFAULT NULL , CHANGE COLUMN `LENDER,N,10,0` `LENDER,N,10,0` INT(10) NULL DEFAULT NULL , CHANGE COLUMN `SPRVSR,N,10,0` `SPRVSR,N,10,0` INT(10) NULL DEFAULT NULL , CHANGE COLUMN `SLSEMP,N,10,0` `SLSEMP,N,10,0` INT(10) NULL DEFAULT NULL , CHANGE COLUMN `ESTEMP,N,10,0` `ESTEMP,N,10,0` INT(10) NULL DEFAULT NULL , CHANGE COLUMN `USRDF1,C,30` `USRDF1,C,30` VARCHAR(30) NULL DEFAULT NULL , CHANGE COLUMN `USRDF2,C,30` `USRDF2,C,30` VARCHAR(30) NULL DEFAULT NULL , CHANGE COLUMN `LCLTAX,N,6,0` `LCLTAX,N,6,0` INT(6) NULL DEFAULT NULL , CHANGE COLUMN `SLSTAX,N,6,0` `SLSTAX,N,6,0` INT(6) NULL DEFAULT NULL , CHANGE COLUMN `LGRACT,N,10,0` `LGRACT,N,10,0` INT(10) NULL DEFAULT NULL , CHANGE COLUMN `DPTMNT,N,10,0` `DPTMNT,N,10,0` INT(10) NULL DEFAULT NULL , CHANGE COLUMN `DSCDTE,C,6` `DSCDTE,C,6` VARCHAR(6) NULL DEFAULT NULL , CHANGE COLUMN `DUEDTE,C,6` `DUEDTE,C,6` VARCHAR(6) NULL DEFAULT NULL , CHANGE COLUMN `DSCCNT,N,5,2` `DSCCNT,N,5,2` DECIMAL(5,2) NULL DEFAULT NULL , CHANGE COLUMN `FINCHG,N,5,2` `FINCHG,N,5,2` DECIMAL(5,2) NULL DEFAULT NULL , CHANGE COLUMN `RETAIN,N,5,2` `RETAIN,N,5,2` DECIMAL(5,2) NULL DEFAULT NULL , CHANGE COLUMN `CNTRCT,N,12,2` `CNTRCT,N,12,2` DECIMAL(12,2) NULL DEFAULT NULL , CHANGE COLUMN `BEGBAL,N,12,2` `BEGBAL,N,12,2` DECIMAL(12,2) NULL DEFAULT NULL , CHANGE COLUMN `ENDBAL,N,12,2` `ENDBAL,N,12,2` DECIMAL(12,2) NULL DEFAULT NULL , CHANGE COLUMN `BIDDTE,D` `BIDDTE,D` DATE NULL DEFAULT NULL , CHANGE COLUMN `PLNRCV,D` `PLNRCV,D` DATE NULL DEFAULT NULL , CHANGE COLUMN `ACTBID,D` `ACTBID,D` DATE NULL DEFAULT NULL , CHANGE COLUMN `CTCDTE,D` `CTCDTE,D` DATE NULL DEFAULT NULL , CHANGE COLUMN `PRELEN,D` `PRELEN,D` DATE NULL DEFAULT NULL , CHANGE COLUMN `STTDTE,D` `STTDTE,D` DATE NULL DEFAULT NULL , CHANGE COLUMN `CMPDTE,D` `CMPDTE,D` DATE NULL DEFAULT NULL , CHANGE COLUMN `LENFLD,D` `LENFLD,D` DATE NULL DEFAULT NULL , CHANGE COLUMN `LENRLS,D` `LENRLS,D` DATE NULL DEFAULT NULL , CHANGE COLUMN `JOBTYP,N,3,0` `JOBTYP,N,3,0` INT(3) NULL DEFAULT NULL , CHANGE COLUMN `STATUS,N,2,0` `STATUS,N,2,0` INT(2) NULL DEFAULT NULL , CHANGE COLUMN `PSTWIP,N,2,0` `PSTWIP,N,2,0` INT(2) NULL DEFAULT NULL , CHANGE COLUMN `CRTFID,N,2,0` `CRTFID,N,2,0` INT(2) NULL DEFAULT NULL , CHANGE COLUMN `CONNUM,C,15` `CONNUM,C,15` VARCHAR(15) NULL DEFAULT NULL , CHANGE COLUMN `PCHORD,C,15` `PCHORD,C,15` VARCHAR(15) NULL DEFAULT NULL , CHANGE COLUMN `IMGFLE,M` `IMGFLE,M` MEDIUMBLOB NULL DEFAULT NULL , CHANGE COLUMN `CSTTYM,C,1` `CSTTYM,C,1` VARCHAR(1) NULL DEFAULT NULL , CHANGE COLUMN `CSTTYL,C,1` `CSTTYL,C,1` VARCHAR(1) NULL DEFAULT NULL , CHANGE COLUMN `CSTTYE,C,1` `CSTTYE,C,1` VARCHAR(1) NULL DEFAULT NULL , CHANGE COLUMN `CSTTYS,C,1` `CSTTYS,C,1` VARCHAR(1) NULL DEFAULT NULL , CHANGE COLUMN `CSTTYO,C,1` `CSTTYO,C,1` VARCHAR(1) NULL DEFAULT NULL , CHANGE COLUMN `USRCS6,C,1` `USRCS6,C,1` VARCHAR(1) NULL DEFAULT NULL , CHANGE COLUMN `USRCS7,C,1` `USRCS7,C,1` VARCHAR(1) NULL DEFAULT NULL , CHANGE COLUMN `USRCS8,C,1` `USRCS8,C,1` VARCHAR(1) NULL DEFAULT NULL , CHANGE COLUMN `USRCS9,C,1` `USRCS9,C,1` VARCHAR(1) NULL DEFAULT NULL , CHANGE COLUMN `NTETXT,M` `NTETXT,M` MEDIUMTEXT NULL DEFAULT NULL , CHANGE COLUMN `EXPORT,M` `EXPORT,M` MEDIUMTEXT NULL DEFAULT NULL , CHANGE COLUMN `LOTCLR,C,15` `LOTCLR,C,15` VARCHAR(15) NULL DEFAULT NULL , CHANGE COLUMN `LOTPRM,N,12,2` `LOTPRM,N,12,2` DECIMAL(12,2) NULL DEFAULT NULL , CHANGE COLUMN `PLNPRC,N,12,2` `PLNPRC,N,12,2` DECIMAL(12,2) NULL DEFAULT NULL , CHANGE COLUMN `ACTPRC,N,12,2` `ACTPRC,N,12,2` DECIMAL(12,2) NULL DEFAULT NULL , CHANGE COLUMN `ESTDTE,D` `ESTDTE,D` DATE NULL DEFAULT NULL , CHANGE COLUMN `ACTDTE,D` `ACTDTE,D` DATE NULL DEFAULT NULL , CHANGE COLUMN `MODNME,C,15` `MODNME,C,15` VARCHAR(15) NULL DEFAULT NULL , CHANGE COLUMN `SQARFT,N,10,0` `SQARFT,N,10,0` INT(10) NULL DEFAULT NULL

, ADD PRIMARY KEY (`RECNUM,N,10,0`)

, ADD UNIQUE INDEX `RECNUM,N,10,0_UNIQUE` (`RECNUM,N,10,0` ASC) ;





SET SQL_MODE=@OLD_SQL_MODE;

SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;

SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

Mysql 5.1.49-1ubuntu8.1 Workbench 5.2.34 rev 7780 Ubuntu Server 10.10