cancel
Showing results for 
Search instead for 
Did you mean: 

error in upgrading from 1.2.1 to 1.3.0dev

cts_sergiu_dunc
Champ in-the-making
Champ in-the-making
Hello,

I've read the upgrade document.

I did the following steps:
- stop alfresco 1.2.1
- unpack alfresco-tomcat-1.3.0dev.tar.gz in a clean /opt/alfresco
- copy ./alf_data from 1.2.1 to the fresh /opt/alfresco
- run the migration schema script

# mysql alfresco < AlfrescoSchemaMigrate-1.3-mysql.sql
ERROR 1146 (42S02) at line 174: Table 'alfresco.t_version_count' doesn't exist

run ./alfresco.sh start
Output from catalina.out:

14:02:22,528 ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.service.cmr.repository.InvalidStoreRefException: Store does not have a root node
        at org.alfresco.repo.node.db.DbNodeServiceImpl.getRootNode(DbNodeServiceImpl.java:214)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:213)
        at $Proxy2.getRootNode(Unknown Source)
        at org.alfresco.repo.descriptor.DescriptorServiceImpl.getDescriptorNodeRef(DescriptorServiceImpl.java:291)
        at org.alfresco.repo.descriptor.DescriptorServiceImpl.updateCurrentRepositoryDescriptor(DescriptorServiceImpl.java:254)
        at org.alfresco.repo.descriptor.DescriptorServiceImpl.access$300(DescriptorServiceImpl.java:61)
        at org.alfresco.repo.descriptor.DescriptorServiceImpl$1.doWork(DescriptorServiceImpl.java:185)
        at org.alfresco.repo.descriptor.DescriptorServiceImpl$1.doWork(DescriptorServiceImpl.java:176)
        at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:168)
        at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransaction(TransactionUtil.java:74)
        at org.alfresco.repo.descriptor.DescriptorServiceImpl.onApplicationEvent(DescriptorServiceImpl.java:191)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:45)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:225)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:323)
        at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3692)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4127)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:804)
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:693)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1118)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
        at org.apache.catalina.core.StandardService.start(StandardService.java:450)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:680)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:536)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)

.. and 2 more exceptions after that. The tail of catalina.out looks like:

INFO: Server startup in 27403 ms
Jun 19, 2006 2:03:21 PM org.apache.catalina.loader.WebappClassLoader loadClass
INFO: Illegal access: this web application instance has been stopped already.  Could not load org.quartz.StatefulJob.  The eventual following stack trace is c
aused by an error thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access, and has no functional impact.
Jun 19, 2006 2:08:13 PM org.apache.coyote.http11.Http11BaseProtocol pause
INFO: Pausing Coyote HTTP/1.1 on http-8080
Jun 19, 2006 2:08:14 PM org.apache.catalina.core.StandardService stop
INFO: Stopping service Catalina
Jun 19, 2006 2:08:14 PM org.apache.coyote.http11.Http11BaseProtocol destroy
INFO: Stopping Coyote HTTP/1.1 on http-8080
Jun 19, 2006 2:08:14 PM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: Failed shutdown of Apache Portable Runtime

Tomcat is running but the /alfresco context is not accesible.

A fresh installation of 1.3.0dev works fine in the same environment ( fresh db installation, non existing previous alf_data).

Can you tell me please if I did something wrong - and how can I successfully migrate to 1.3.0 ?

Thank you,
Sergiu
16 REPLIES 16

trying2alfresco
Champ in-the-making
Champ in-the-making
Hey Cludt,

I am having the same problem as you. Have you figured out how to get around it? Sure wouldn't mind some help.

Thanks.

cludt
Champ in-the-making
Champ in-the-making
If you are talking about the mysql script, I have been given a new one from the alfresco support (my company is a registered partner). I am not sure if I am allowed to provide others with this script. I will check.

trying2alfresco
Champ in-the-making
Champ in-the-making
cool. thanks.

lmouillart
Champ in-the-making
Champ in-the-making
Hi trying2alfresco, i have the same error as you : 'Duplicate entry '0-1-GROUP_EVERYONE' for key 2'.  Have you allready resolve this issue ?

Regards,
Laurent

cludt
Champ in-the-making
Champ in-the-making
Hi Laurent,

this will also be solved by the new mysql script. I am still awaiting a post-reply from the support.

Chris

derek
Star Contributor
Star Contributor
The scripts are kept up to date on HEAD.

Regards

legba
Champ in-the-making
Champ in-the-making
Hi derek,
apparently the scripts are not anymore on HEAD: as far as I see the old revision are not accessible from the public svn (am I missing something?).

I tried the ones inside the old releases but the duplicate key problem is still there.

I also tried the script from this post:
http://forums.alfresco.com/viewtopic.php?t=2892
but to no avail.

Is there a script that correclty patches the database?

I am trying to upgrade from version 1.2 to version 2.1; following the path 1.2 -> 1.2.1 -> 1.3 -> 1.4 -> 2.0 -> 2.1 ( http://forums.alfresco.com/viewtopic.php?t=6199 )

Thanks in advance for your assistance.

Fabio