Schema auto-update failed: CE 3.3g on OS X with Mysql

huima — Sun, 05 Sep 2010 23:26:05 GMT

Warning to anyone having Alfresco on OS X.I lost few hours today trying to debug why Alfresco was giving me hard time and complaining about schema update failed, when starting fresh install of Alfresco. I debugged my own setup configurations and tried to even use clean Alfresco distribution bundle i

Re: Schema auto-update failed: CE 3.3g on OS X with Mysql

mdahlman — Tue, 30 Nov 2010 19:07:44 GMT

Thanks for posting your issue. It helped assure me of my sanity when I got nearly the same thing. In my case it's coming during an install of JasperReports Server.

[advanced-sql] Failed to execute: alter table JIDomainDatasourceDSRef add index FKFDA42FC7106B699 (ref_id), add constraint FKFDA42FC7106B699 foreign key (ref_id) references JIResource (id)
[advanced-sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate key name 'FKFDA42FC7106B699'

After getting this error while executing a large SQL script, I can successfully run the exact same alter table statement manually. I cannot figure out why MySQL occasionally rejects some alter table statements. Restarting MySQL indeed solves the problem [for an unspecified but temporary time period].

I'm using exactly the same build of MySQL on Mac OS. We could optimistically hope that this is a MySQL problem limited to version 5.1.48 and/or limited to Mac OS… but I would feel a lot more comfortable if I could track down a bug report in the MySQL tracker.

If any MySQL gurus come across this thread… I love an opinion on what is causing this problem.

Regards,
Matt

topic Schema auto-update failed: CE 3.3g on OS X with Mysql in Alfresco Archive

Schema auto-update failed: CE 3.3g on OS X with Mysql

Re: Schema auto-update failed: CE 3.3g on OS X with Mysql