AnsweredAssumed Answered

Alfresco + MySQL NDB cluster

Question asked by thim on Jul 3, 2008
Hi all,

We're trying to use Alfresco (2.9b) with our MySQL cluster (5.1.25) but we've run into a MySQL error during the initial startup that causes failure.  From the alfresco log, it receives MySQL error #708 (Increase MaxNoOfAttributes ) at the command:

alter table JBPM_ACTION add index FK_ACTION_EVENT (EVENT_), add constraint FK_ACTION_EVENT foreign key (EVENT_) references JBPM_EVENT (ID_)

Increasing the MaxNoOfAttributes does not seem to resolve this issue.  Can anyone recommend a solution or if anyone has gotten Alfresco working with MySQL cluster and can point us in the right direction, that'd be helpful too. Thanks,

Here's the related output from Alfresco: 


20:38:49,532 User:System INFO  [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
20:38:51,814 User:System INFO  [domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchemaCreate-org.hibernate.dialect.MySQLInnoDBDialect-1028.sql (Generated).
20:43:40,797 User:System ERROR [domain.schema.SchemaBootstrap] Statement execution failed:
   SQL:  alter table JBPM_ACTION add index FK_ACTION_EVENT (EVENT_), add constraint FK_ACTION_EVENT foreign key (EVENT_) references JBPM_EVENT (ID_)
   Error: Error on rename of './alfresco/JBPM_ACTION' to './alfresco/#sql2-f71-7' (errno: 708)
   File: /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchemaCreate-org.hibernate.dialect.MySQLInnoDBDialect-1028.sql
   Line: 819
20:43:40,798 User:System ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
java.sql.SQLException: Error on rename of './alfresco/JBPM_ACTION' to './alfresco/#sql2-f71-7' (errno: 708)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3118)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3047)
   at com.mysql.jdbc.Statement.execute(Statement.java:692)

Outcomes