topic DB Schema update fails on upgrade 4.0.0->4.2.b in Alfresco Archive

DB Schema update fails on upgrade 4.0.0->4.2.b

bong0 — Fri, 26 Oct 2012 22:08:43 GMT

I'm was running alfresco 4.0.0 when I tried to upgrade to the latest community edition 4.2.b. The OS is an up-to-date debian squeeze with sun-jre. The db server (IP removed for privacy) is running mysql.When starting the updated install I get the following in catalina.out. Logins to /share are not w

Re: DB Schema update fails on upgrade 4.0.0->4.2.b

mikeh — Sat, 27 Oct 2012 08:01:58 GMT

Caused by: java.lang.ClassNotFoundException: java.nio.channels.SeekableByteChannel‍

You need to update to Java 7 on your server.

Thanks,
Mike

Re: DB Schema update fails on upgrade 4.0.0->4.2.b

bong0 — Sat, 27 Oct 2012 21:35:17 GMT

Jep, you were right Thanks!

Re: DB Schema update fails on upgrade 4.0.0->4.2.b

rheimburger — Tue, 14 May 2013 13:33:35 GMT

I have not been able to get 4.2d to come up.
I created a new database with grants, etc.
imported the 4.0e schema into the new database
modified the global properties for the MYSQL db and tested accessing the database with the alfresco user.

Any ideas?

Alfresco.log:

16:49:13,683 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Statement execution failed:
SQL: alter table JBPM_ACTION add index FK_ACTION_REFACT (REFERENCEDACTION_), add constraint FK_ACTION_REFACT foreign key (REFERENCEDACTION_) references JBPM_ACTION (ID_)
Error: Can't create table './alfresco/#sql-6c22_bc.frm' (errno: 121)

Java version
java version "1.7.0_07"
Java(TM) SE Runtime Environment (build 1.7.0_07-b10)
Java HotSpot(TM) 64-Bit Server VM (build 23.3-b01, mixed mode)

Re: DB Schema update fails on upgrade 4.0.0->4.2.b

bisana — Tue, 14 May 2013 14:06:38 GMT

U checked it by accessing the DB, but does the user have alter and other permissions to the DB
please check it

Re: DB Schema update fails on upgrade 4.0.0->4.2.b

rheimburger — Tue, 14 May 2013 15:20:06 GMT

Joseph,
Thanks for the quick response

This what I ran after creating the db:

GRANT ALL PRIVILEGES ON alfresco.* TO alfresco@localhost IDENTIFIED BY '<password>';
FLUSH PRIVILEGES;

Re: DB Schema update fails on upgrade 4.0.0->4.2.b

rheimburger — Tue, 14 May 2013 15:53:03 GMT

It looks like its failing trying to create tables that already exist:

file: /opt/alfresco-4.2.d/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-7949126811377301362.sql

create table JBPM_ACTION (ID_ bigint not null auto_increment, class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ bit, ACTIONEXPRESSION_ varchar(255), ISASYNC_ bit, REFERENCEDACTION_ bigint, ACTIONDELEGATION_ bigint, EVENT_ bigint, PROCESSDEFINITION_ bigint, TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ bigint, EXPRESSION_ text, EVENTINDEX_ integer, EXCEPTIONHANDLER_ bigint, EXCEPTIONHANDLERINDEX_ integer, primary key (ID_)) type=InnoDB;
…(snip)

Why would it recreate existing objects?

Re: DB Schema update fails on upgrade 4.0.0->4.2.b

rheimburger — Tue, 14 May 2013 16:53:01 GMT

I decided to just create a blank DB and start alfresco, this time it appears to have come up. What are the steps to import the data from the 4.0e db?