Garbage collector error

[squad]

Hi team i'm having this problem in one of my clients, i'm new using Alfresco and i'm very impressed with its power.
Can you please guide me on the solution of this issue?

(Im using the community version)

Thanks in advance!
——
00:00:01,660 ERROR [org.alfresco.repo.avm.OrphanReaper] Garbage collector error
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Cannot open connection
Caused by: org.hibernate.exception.JDBCConnectionException: Cannot open connection
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
   at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
   at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
   at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
   at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
   at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
   at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:510)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:350)
   at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:262)
   at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:219)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.begin(SpringAwareUserTransaction.java:406)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:315)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:233)
   at org.alfresco.repo.avm.OrphanReaper.doBatch(OrphanReaper.java:351)
   at org.alfresco.repo.avm.OrphanReaper.execute(OrphanReaper.java:58)
   at org.alfresco.repo.avm.OrphanReaperJob.execute(OrphanReaperJob.java:44)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
   at sun.reflect.GeneratedConstructorAccessor1017.newInstance(Unknown Source)
   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.SQLError.createCommunicationsException(SQLError.java:1074)
   at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2120)
   at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723)
   at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
   at sun.reflect.GeneratedConstructorAccessor1018.newInstance(Unknown Source)
   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.ConnectionImpl.getInstance(ConnectionImpl.java:302)
   at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
   at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
   at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
   at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974)
   at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
   at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
   at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
   at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
   … 16 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

[jpfi]

hi,
that's not a garbage collector error.
Alfresco cannot connect to your MySQL-DB.

http://wiki.alfresco.com/wiki/Database_Configuration
cheers, jan

[squad]

Hi jpfi (jan)

Thank you for your reply, i'm going to ready the information on the link you gave me and then i'll reply back.

Cheers, squad

[squad]

hi,
that's not a garbage collector error.
Alfresco cannot connect to your MySQL-DB.

http://wiki.alfresco.com/wiki/Database_Configuration
cheers, jan

Hi Jan, i have to assume that all the information there is confusing me  ops:  and i'm not sure of what to do, can you please show me a step by step process.
thank you i still have the problem.

Regards

[squad]

Thats whats happen with most of ALFRESCO Issues, no one is able to guide people to solutions.

very sad with this comunity.

[mrogers]

But being unable to connect to your database is not an Alfresco issue.

You could start by posting your alfresco-global.properties and check whether your database is running.

[squad]

Hi mrogers,
The dabase is running well, as im using Windows XP i can access it via c:\alfresco\mysql\bin\mysqld. using alfresco user and connect to DB.
the alfresco-global.properties is using the dafault configuarations and the server runned for one year or so without any issue.

[squad]

you have to improve the support you have.
i had to implement this solution a very big company, but with this kind of support.
im looking for another solutions.

Please remove this post from the list.

THANKS FOR NOTHING.

ciau

[mrogers]

Just to clarify, these is a discussion forum, not Alfresco support.

If you want "support" or a guaranteed response time, then you should buy Alfresco Enterprise or use an Alfresco Business partner.

[squad]

Thank you for your advise.
Cheers!!