Actualización de la version Enterprise 3.1 a 3.3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2010 06:39 AM
Bueno, comentaros que estoy intentando actualizar mi Alfresco de la versión 3.1.1 a la versión 3.3.1
Os cuento lo que he hecho:
- He guardado el contenido de alf_data de la versión 3.1.1 y he hecho un backup de la base de datos mysql (mysqldump)
- He instalado la versión 3.3 en un directorio diferente, he borrado la base de datos y he arrancado la nueva versión.
- Ha arrancado sin problemas y funciona bien.
Una vez que he visto que la versión 3.3 funcionaba correctamente
- He copiado el contenido de la carpeta alf_data de la versión 3.1.1 en la versión 3.3
- He restaurado la base de datos y he copiado todos los ficheros de la carpeta extension
Cuando he arrancado la versión 3.3 me ha dado el siguiente error:
12:06:57,854 ERROR [domain.schema.SchemaBootstrap] Ejecuci¾n de comandos fallida:SQL: CREATE TABLE alf_lock_resource( id BIGINT NOT NULL AUTO_INCREMENT, version BIGINT NOT NULL, qname_ns_id BIGINT NOT NULL, qname_localname VARCHAR(255) NOT NULL, CONSTRAINT fk_alf_lockr_ns FOREIGN KEY (qname_ns_id) REFERENCES alf_namespace (id), PRIMARY KEY (id), UNIQUE INDEX idx_alf_lockr_key (qname_ns_id, qname_localname)) TYPE=InnoDBError: Table 'alf_lock_resource' already existsFile: C:\ALFRES~2\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Update-23278.sqlLine: 1912:06:57,854 ERROR [domain.schema.SchemaBootstrap] Actualizaci¾n automßtica deesquema fallidacom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'alf_lock_resource' already exists at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:1120) at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:1074) at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptUrl(SchemaBootstrap.java:860) at org.alfresco.repo.domain.schema.SchemaBootstrap.checkSchemaPatchScripts(SchemaBootstrap.java:831) at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:733) at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1280) at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97) at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:78) at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:294) at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:858) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:419) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47) at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:785) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:519) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:581) 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:597) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)12:06:57,963 ERROR [web.context.ContextLoader] Context initialization failedorg.alfresco.error.AlfrescoRuntimeException: 07190000 Actualizaci¾n automßtica de esquema fallida at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1411) at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97) at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:78) at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:294) at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:858) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:419) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47) at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:785) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:519) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:581) 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:597) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'alf_lock_resource' already exists at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:1120) at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:1074) at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptUrl(SchemaBootstrap.java:860) at org.alfresco.repo.domain.schema.SchemaBootstrap.checkSchemaPatchScripts(SchemaBootstrap.java:831) at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:733) at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1280) … 34 more19-ago-2010 12:06:58 org.apache.catalina.core.StandardContext startGRAVE: Error listenerStart19-ago-2010 12:06:58 org.apache.catalina.core.StandardContext startGRAVE: Fall¾ en arranque del Contexto [/alfresco] debido a errores previos19-ago-2010 12:06:58 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbcGRAVE: A web application registered the JBDC driver [org.postgresql.Driver] butfailed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
Creo que he hecho mal lo de la base de datos, he seguido los pasos de la wiki (http://wiki.alfresco.com/wiki/General_Upgrade_Process) pero igual no lo he entendido bien…
alguna ayudita por favor¿
- Labels:
-
Archive
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2010 07:05 AM
¿Qué SP de la 3.1 tenías instalada? Porque si te fijas en la tabla de compatibilidades, para hacerlo directo debes tenes instalado 3.1SP2:
Target: Version 3.3
Version 2.1 SP7 to Version 3.3.0 FCS
Version 2.2 SP7 to Version 3.3.0 FCS
Version 3.1 SP2 to Version 3.3.0 FCS
Version 3.2 SP1.2 to Version 3.3.0 FCS
Version 2.1 SP7 to Version 3.3 SP1
Version 2.2 SP8 to Version 3.3 SP1
Version 3.1 SP2 to Version 3.3 SP1
Version 3.2 SP1 to Version 3.3 SP1
A lo mejor viene el problema de ahí 😕
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2010 07:33 AM
al final lo que he hecho ha sido borrar la base de datos y restaurarla de nuevo, pero al arrancar me da un problema de licencia… la cosa es que lo estoy probando con una versión trial.. tenemos en otro servidor instalada la 3.1 con la licencia buena, y también tenemos la licencia de la 3.3 pero antes queria probar con unos trial para ver que problemas me podia generar…
La versión que tengo es la 3.1.1 significa eso que es la 3.1 SP1??
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2010 07:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2010 07:57 AM
Si al final era que yo no lo habia entendido bien
Voy a hacer lo que comentas y a ver que tal…
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2010 08:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2010 08:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2010 08:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2010 08:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-20-2010 03:28 AM
me he fijado en las trazas y veo esto:
09:14:38,649 User:System INFO [node.index.AVMFullIndexRecoveryComponent] Reindex 100% complete09:14:38,649 User:System INFO [node.index.AVMFullIndexRecoveryComponent] Finished rebuilding indexes for AVM Stores09:14:38,790 User:System WARN [service.descriptor.DescriptorService] Alfresco license: Failed to verify license - Invalid License!09:14:38,790 User:System WARN [service.descriptor.DescriptorService] Alfresco license: Restricted Alfresco Repository to read-only capability09:14:39,025 User:System INFO [repo.admin.ConfigurationChecker] El directorio raÝz de Alfresco ('dir.root') es: C:\AlfrescoSP2\alf_data09:14:39,056 User:System ERROR [repo.admin.ConfigurationChecker] ERROR DE INTEGRIDAD DE CONTENIDO: Contenido del sistema no hallado en el almacÚn de contenidos.09:14:39,056 User:System ERROR [repo.admin.ConfigurationChecker] Confirme que la propiedad "dir.root" apunta a la ubicaci¾n correcta.09:14:39,056 User:System ERROR [web.context.ContextLoader] Context initialization failedorg.alfresco.error.AlfrescoRuntimeException: Confirme que la propiedad "dir.root" apunta a la ubicaci¾n correcta. at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:312) at org.alfresco.repo.admin.ConfigurationChecker.access$000(ConfigurationChecker.java:72) at org.alfresco.repo.admin.ConfigurationChecker$1.execute(ConfigurationChecker.java:178)
Me da error de licencia, asique supongo que tendré que migrar Alfresco en la versión que tengo con las licencias