cancel
Showing results for 
Search instead for 
Did you mean: 

MySQL Error on Installation 3.3

boulderdash
Champ in-the-making
Champ in-the-making
Hi,

I'm starting with a fresh installation of alfresco 3.3. using sles 10 and mysql 5.0.84.
I tried the quick installation and the tomcat packaged versions. Both stop with the same error.


17:18:40,918  INFO  [domain.schema.SchemaBootstrap] Executing database script /home/me/dev/opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-6820922338029924516.sql (Copied from classpath:alfresco/dbscripts/create/3.2/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoPostCreate-3.2-AvmTables.sql).
17:18:41,026  ERROR [domain.schema.SchemaBootstrap] Statement execution failed:
   SQL:     alter table avm_history_links
        add index fk_avm_hl_ancestor (ancestor),
        add constraint fk_avm_hl_ancestor
        foreign key (ancestor)
        references avm_nodes (id)
   Error: Can't create table './alfresco/#sql-1012_204.frm' (errno: 135)
   File: /home/me/dev/opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-6820922338029924516.sql
   Line: 152
17:18:41,027  ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
java.sql.SQLException: Can't create table './alfresco/#sql-1012_204.frm' (errno: 135)

Any suggestions?
2 REPLIES 2

janv
Employee
Employee
Can you confirm that you're using InnoDB rather than MyISAM ?

Thanks,
Jan

boulderdash
Champ in-the-making
Champ in-the-making
Hi Jan,

yes, all tables use InnoDB.

Thanks,
Tobias