AnsweredAssumed Answered

New install was working, now broken

Question asked by andy_ukgrid on Mar 26, 2008
Latest reply on Mar 26, 2008 by andy_ukgrid
Hi all,

  I installed and successfully start Alfresco yesterday, but now it won't start anymore :(

This is what Im seeing in catalina.out:

INFO: Initializing Coyote HTTP/1.1 on http-8080
Mar 26, 2008 6:24:38 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1512 ms
Mar 26, 2008 6:24:38 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Mar 26, 2008 6:24:38 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.23
Mar 26, 2008 6:24:38 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Mar 26, 2008 6:24:39 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive alfresco.war
18:25:09,672 User:System ERROR [transform.magick.AbstractImageMagickContentTransformer] ImageMagickContentTransformer not available: Failed to perform ImageMagick transformation:
Execution result:
   os:         Linux
   command:    convert /opt/alfresco/tomcat/temp/Alfresco/ImageMagickContentTransformer_init_source_54286.gif  /opt/alfresco/tomcat/temp/Alfresco/ImageMagickContentTransformer_init_target_54287.png
   succeeded:  false
   exit code:  1
   out:
   err:        Cannot run program "convert": java.io.IOException: error=2, No such file or directory
18:25:12,413 User:System WARN  [remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
18:25:16,911 User:System ERROR [web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'usageQuotaProtector' defined in class path resource [alfresco/usage-services-context.xml]: Invocation of init method failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
(Database does not exists: file:/opt/alfresco/tomcat/conf/alf_data/hsql_data/alfresco)

Caused by: java.sql.SQLException: Database does not exists: file:/opt/alfresco/tomcat/conf/alf_data/hsql_data/alfresco

18:25:16,919 User:System ERROR [[Catalina].[localhost].[/alfresco]] Exception sending context initialized
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Database does not exists: file:/opt/alfresco/tomcat/conf/alf_data/hsql_data/alfresco)

Caused by: java.sql.SQLException: Database does not exists: file:/opt/alfresco/tomcat/conf/alf_data/hsql_data/alfresco

18:25:16,924 User:System ERROR [[Catalina].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'usageQuotaProtector' defined in class path resource [alfresco/usage-services-context.xml]: Invocation of init method failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Database does not exists: file:/opt/alfresco/tomcat/conf/alf_data/hsql_data/alfresco)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
        at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
        … 54 more
Caused by: java.sql.SQLException: Database does not exists: file:/opt/alfresco/tomcat/conf/alf_data/hsql_data/alfresco
        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
        at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
        at org.hsqldb.jdbcDriver.connect(Unknown Source)
        at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
        at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
        … 57 more
Mar 26, 2008 6:25:16 PM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Mar 26, 2008 6:25:16 PM org.apache.catalina.core.StandardContext start
SEVERE: Context [/alfresco] startup failed due to previous errors
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
Mar 26, 2008 6:25:19 PM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Mar 26, 2008 6:25:19 PM org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
Mar 26, 2008 6:25:19 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 41560 ms


Main issues seem to be some RMI errro and a SEVER error starting listener?? :S
Any help!?
thanks Andy.

Outcomes