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.
zomurn
Member II

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

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