AnsweredAssumed Answered

'Schema auto-update failed' after installation (OS X/MySQL)

Question asked by bcm on Jul 23, 2008
Latest reply on Jul 24, 2008 by bcm
I installed the Tomcat-bundled version of Alfresco Community 2.9.0B on a MacBook Pro running Leopard and configured it to use a MySQL database. Like many others apparently, I get that "Schema auto-update failed" exception when I start the server. The nested exception message is "A previous schema upgrade failed.  Revert to the original database before attempting the upgrade again."

Having searched through these forums at length, I've tried all the different suggestions like: remove your alf_data directory, drop and recreate your database, etc. I didn't expect any of these things to help, since I've never gotten the server to start up or create a table in the database, and of course they didn't.

After the message "Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect" is logged, there is a noticeable hang of several seconds before the exception is logged. I suspect that this is the period of time in which Tomcat is waiting for its attempt at connecting to the database server to time out.

I read somewhere in these forums that earlier versions of Alfresco swallowed an exception that actually provided information as to what's going wrong with the database connection attempt, and that recent builds are no longer swallowing it. Can anybody confirm what build or version this occurred in? Is 2.9.0B not recent enough?

I created the database with the db_setup.sql script. The relevant bits of the various config files are excerpted below.

Is there anything else I can do to diagnose the problem?

Thanks!

== custom-repository.properties

db.driver=org.gjt.mm.mysql.Driver                                                                                                                                                      
db.url=jdbc:mysql://localhost/alfresco  

== custom-hibernate-dialect.properties

hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

Outcomes