Servidor caido

[icomara]

Hola, llevo un tiempo haciendo uso de un servidor alfresco y un buen dia dejo de ejecutarse al arrancar la maquina, ya no consigo que se ejecute y no se muy bien por donde empezar.

Gracias y Saludos por anticipado

[angelborroy]

Lo primero es encontrar el archivo alfresco.log (Windows) o catalina.out (Linux). En ese ficheros encontrarás la causa de que el servidor no arranque.

[icomara]

Muchas gracias por la rapida respuesta.

Se me olvido cometar que el servidor corre sobre windows 

pues me salen un monton de errores.....

Dejo aqui desde la ultima fecha:

2016-12-27 02:50:00,191 ERROR [org.alfresco.repo.activities.post.cleanup.PostCleaner] [DefaultScheduler_Worker-3] Exception during cleanup of posts

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:

### Error updating database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.postgresql.util.PSQLException: El intento de conexión falló.

### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.postgresql.util.PSQLException: El intento de conexión falló.

               at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)

               at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371)

               at com.sun.proxy.$Proxy6.delete(Unknown Source)

               at org.mybatis.spring.SqlSessionTemplate.delete(SqlSessionTemplate.java:268)

               at org.alfresco.repo.domain.activities.ibatis.ActivityPostDAOImpl.deletePosts(ActivityPostDAOImpl.java:102)

               at org.alfresco.repo.activities.post.cleanup.PostCleaner.executeWithLock(PostCleaner.java:146)

               at org.alfresco.repo.activities.post.cleanup.PostCleaner.execute(PostCleaner.java:117)

               at org.alfresco.repo.activities.post.cleanup.PostCleanupJob.execute(PostCleanupJob.java:50)

               at org.quartz.core.JobRunShell.run(JobRunShell.java:216)

               at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)

Caused by: org.apache.ibatis.exceptions.PersistenceException:

### Error updating database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.postgresql.util.PSQLException: El intento de conexión falló.

### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.postgresql.util.PSQLException: El intento de conexión falló.

               at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:26)

               at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:154)

               at org.apache.ibatis.session.defaults.DefaultSqlSession.delete(DefaultSqlSession.java:165)

               at sun.reflect.GeneratedMethodAccessor516.invoke(Unknown Source)

               at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

               at java.lang.reflect.Method.invoke(Unknown Source)

               at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)

               ... 8 more

Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.postgresql.util.PSQLException: El intento de conexión falló.

               at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)

               at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:81)

               at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)

               at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:279)

               at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:72)

               at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:47)

               at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:105)

               at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:71)

               at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:152)

               ... 13 more

Caused by: org.postgresql.util.PSQLException: El intento de conexión falló.

               at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:233)

               at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)

               at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:144)

               at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)

               at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)

               at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)

               at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)

               at org.postgresql.Driver.makeConnection(Driver.java:410)

               at org.postgresql.Driver.connect(Driver.java:280)

               at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)

               at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)

               at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1188)

               at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)

               at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)

               at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)

               at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)

               ... 21 more

Caused by: java.net.SocketException: No buffer space available (maximum connections reached?): connect

               at java.net.DualStackPlainSocketImpl.connect0(Native Method)

               at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)

               at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)

               at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)

               at java.net.AbstractPlainSocketImpl.connect(Unknown Source)

               at java.net.PlainSocketImpl.connect(Unknown Source)

               at java.net.SocksSocketImpl.connect(Unknown Source)

               at java.net.Socket.connect(Unknown Source)

               at org.postgresql.core.PGStream.<init>(PGStream.java:61)

               at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:109)

               ... 36 more

Alguna idea de por donde empezar?

[cristinamr]

Sí. Fíjate concretamente en esta línea:

Caused by: java.net.SocketException: No buffer space available (maximum connections reached?): connect

Echale un vistazo a este hilo: FitProgrammer@Work: Resolution for “No buffer space available (maximum connections reached?): JVM_Bi...

Dentro de alfresco/shared/classes/alfresco-global.properties hay un apartado similar a este donde tienes la configuración:

### database connection properties ###
db.driver=org.postgresql.Driver
db.username=alfresco
db.password=admin
db.name=alfresco
db.url=jdbcostgresql://localhost:5432/${db.name}
# Note: your database must also be able to accept at least this many connections.  Please see your database documentation for instructions on how to configure this.
db.pool.max=275
db.pool.validate.query=SELECT 1

Verifica que todo es correcto (aunque no creo que vengan por aquí los tiros).

También que tienes el postgresql-9.4.1212.jar (o similar) dentro de alfresco/tomcat/bin/

Cuéntanos un poco más: ¿Qué arquitectura tienes? ¿Usas el alfresco por defecto? ¿Usas postgresql o usas otra? ¿está en el mismo servidor o en otro? ¿Qué memoria tiene el servidor donde tienes alojado Alfresco y la báse de datos?

Un saludo,

Cris.