Alfresco 3.2.0r et derby : probleme initialisation de la bas

cancel
Showing results for 
Search instead for 
Did you mean: 
zomurn
Member II

Alfresco 3.2.0r et derby : probleme initialisation de la bas

Juste une question : hibernate contenu dans alfresco 320r, il est compatible avec la dernière version de derby ?
A priori les instruction de bootstrap SQL pour initialiser un alfresco vierge petent  :shock:

16:35:50,161 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
16:40:37,739 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properties]
16:40:37,742 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.properties]
16:40:37,742 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/home/alfresco320r/alfresco/tomcat/shared/classes/alfresco-global.properties]
16:40:37,914 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
16:41:04,423 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.DerbyDialect.
16:41:04,431 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Alfresco is using the Apache Derby default database. Please only use this while evaluating Alfresco, it is NOT recommended for production or deployment!
16:41:05,011 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /home/alfresco320r/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-DerbyDialect-Update-591755655431057608.sql (Generated).
16:41:14,067 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /home/alfresco320r/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-DerbyDialect-Update-6208651634846918610.sql (Copied from classpath:alfresco/dbscripts/create/2.2/org.hibernate.dialect.DerbyDialect/AlfrescoPostCreate-2.2-Extra.sql).
16:41:14,352 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /home/alfresco320r/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-DerbyDialect-Update-2652481196973358687.sql (Copied from classpath:alfresco/dbscripts/create/2.2/org.hibernate.dialect.DerbyDialect/post-create-indexes-04.sql).
16:41:14,373 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /home/alfresco320r/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-DerbyDialect-Update-3473221981315504264.sql (Copied from classpath:alfresco/dbscripts/create/3.0/org.hibernate.dialect.DerbyDialect/create-activities-extras.sql).
16:41:14,501 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /home/alfresco320r/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-DerbyDialect-Update-3630102151278311685.sql (Copied from classpath:alfresco/dbscripts/create/3.2/org.hibernate.dialect.DerbyDialect/AlfrescoPostCreate-3.2-LockTables.sql).
16:41:14,663 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /home/alfresco320r/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-DerbyDialect-Update-3636291223334325198.sql (Copied from classpath:alfresco/dbscripts/create/3.2/org.hibernate.dialect.DerbyDialect/AlfrescoPostCreate-3.2-ContentTables.sql).
16:41:15,030 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /home/alfresco320r/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-DerbyDialect-Update-7928970871939892845.sql (Copied from classpath:alfresco/dbscripts/create/3.2/org.hibernate.dialect.DerbyDialect/AlfrescoPostCreate-3.2-PropertyValueTables.sql).
16:41:15,512 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /home/alfresco320r/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-DerbyDialect-Update-5089074558416457801.sql (Copied from classpath:alfresco/dbscripts/create/3.2/org.hibernate.dialect.DerbyDialect/AlfrescoPostCreate-3.2-AuditTables.sql).
16:41:15,792 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /home/alfresco320r/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-DerbyDialect-Update-3114536194041270250.sql (Copied from classpath:alfresco/dbscripts/create/3.2/org.hibernate.dialect.DerbyDialect/AlfrescoPostCreate-3.2-AvmTables.sql).
16:41:17,072 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /home/alfresco320r/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-DerbyDialect-Update-6211492963161036077.sql (Copied from classpath:alfresco/dbscripts/create/3.2/org.hibernate.dialect.DerbyDialect/AlfrescoPostCreate-3.2-Indexes.sql).
16:41:17,155 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /home/alfresco320r/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-DerbyDialect-Update-6496522929514064788.sql (Copied from classpath:alfresco/dbscripts/create/3.2/org.hibernate.dialect.DerbyDialect/AlfrescoPostCreate-3.2-JBPM-Extra.sql).
16:41:17,167 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Statement execution failed:
   SQL: ALTER TABLE jbpm_delegation ALTER COLUMN configuration_ SET DATA TYPE CLOB(4000)
   Error: Seule la longueur des colonnes de type VARCHAR peut être modifiée.
   File: /home/alfresco320r/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-DerbyDialect-Update-6496522929514064788.sql
   Line: 15
16:41:17,169 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failed
java.sql.SQLSyntaxErrorException: Seule la longueur des colonnes de type VARCHAR peut être modifiée.
        at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
        at org.apache.derby.client.am.Statement.execute(Unknown Source)
        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:1114)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:1068)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptUrl(SchemaBootstrap.java:863)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:728)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1280)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
        at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
        at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
        at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
        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:525)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:627)
        at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
        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:516)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
        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:288)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: org.apache.derby.client.am.SqlException: Seule la longueur des colonnes de type VARCHAR peut être modifiée.
        at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
        at org.apache.derby.client.am.Statement.completeExecuteImmediate(Unknown Source)
        at org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(Unknown Source)
        at org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(Unknown Source)
        at org.apache.derby.client.net.StatementReply.readExecuteImmediate(Unknown Source)
        at org.apache.derby.client.net.NetStatement.readExecuteImmediate_(Unknown Source)
        at org.apache.derby.client.am.Statement.readExecuteImmediate(Unknown Source)
        at org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
        at org.apache.derby.client.am.Statement.executeX(Unknown Source)
        … 43 more
16:41:17,174 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 01180000 Schema auto-update failed
        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1408)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
        at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
        at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
        at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
        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:525)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:627)
        at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
        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:516)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
        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:288)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: java.sql.SQLSyntaxErrorException: Seule la longueur des colonnes de type VARCHAR peut être modifiée.
        at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
        at org.apache.derby.client.am.Statement.execute(Unknown Source)
        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:1114)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:1068)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptUrl(SchemaBootstrap.java:863)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:728)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1280)
        … 35 more
Caused by: org.apache.derby.client.am.SqlException: Seule la longueur des colonnes de type VARCHAR peut être modifiée.
        at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
        at org.apache.derby.client.am.Statement.completeExecuteImmediate(Unknown Source)
        at org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(Unknown Source)
        at org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(Unknown Source)
        at org.apache.derby.client.net.StatementReply.readExecuteImmediate(Unknown Source)
        at org.apache.derby.client.net.NetStatement.readExecuteImmediate_(Unknown Source)
        at org.apache.derby.client.am.Statement.readExecuteImmediate(Unknown Source)
        at org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
        at org.apache.derby.client.am.Statement.executeX(Unknown Source)
        … 43 more
16:41:24,162 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
2 Replies
michaelh
Active Member

Re: Alfresco 3.2.0r et derby : probleme initialisation de la bas

Bonjour,

A ma connaissance Derby n'est plus supporté. Il posait des problèmes de lock (entre autres) et les gens avaient une très fâcheuse tendance à le garder en production …
La base par défaut est MySQL depuis la 3.2, ce qui n'est pas une mauvaise chose si j'en crois la disparition des problèmes d'installation sur ce sujet.
Highlighted
zomurn
Member II

Re: Alfresco 3.2.0r et derby : probleme initialisation de la bas

OK merci, c'est ce que j'ai fait.