Confluence stopped working restarted but got error as follows

[Mark Gerber]

Proxy Error

The proxy server received an invalid response from an upstream server.
The proxy server could not handle the request GET /confluence/.

Reason: Error reading from remote server

---

Apache/2.2.15 (Red Hat) Server at confluence01.ber.office.redknee.com Port 80

[Nic Brough -Adaptavist-]

That's a proxy server essentially saying "I asked Confluence, but it didn't want to talk to me".  The proxy logs might tell you the basics (no response, or got rubbish), but you should start with the application logs.

Look for <confluence home>/logs/atlassian-confluence.log first - that will usually have errors in it to tell you what is going wrong in Confluence.  (If not, then check other files in that directory and <confluence install>/log/catalina.out)

[Mark Gerber]

Hi thanks Nic...I am not a confluence expert nor admin...just trying to start it up...I did notice the following in the logs...catalina.out

SEVERE: The web application [/confluence] created a ThreadLocal with key of type [com.atlassian.confluence.concurrent.ThreadLocalMap] (value [com.atlassian.confluence.concurrent.ThreadLocalMap@3d72abea]) and a valu
e of type [java.util.HashMap] (value [{}]) but failed to remove it when the web application was stopped. This is very likely to create a memory leak.

[Nic Brough -Adaptavist-]

Those errors almost always happen on shutting down, rather than starting up.  Although they're a bit of a pain, we're more interested in the server start process.  Was there much in atlassian-confluence.log?

[Mark Gerber]

Nothing of much interest in that confluence.log im afraid to say.

I dont even know where or what to look at. And our entire environment is down people cant work! What a disaster!

[Mark Gerber]

anything to do with httpd.conf timeout setting??

[Mark Gerber]

Last known info:

018-01-18 06:58:08,294 ERROR [scheduler_Worker-5] [org.quartz.core.ErrorLogger] schedulerError Job (DEFAULT.IndexQueueFlusher threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is net
.sf.hibernate.TransactionException: Rollback failed with SQL exception: ]
at org.quartz.core.JobRunShell.run(JobRunShell.java:210)
at com.atlassian.confluence.schedule.quartz.ConfluenceQuartzThreadPool$1.run(ConfluenceQuartzThreadPool.java:20)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
Caused by: org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is net.sf.hibernate.TransactionException: Rollback failed with SQL exception:
at org.springframework.orm.hibernate.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:532)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:823)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:691)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy47.flushQueue(Unknown Source)
at com.atlassian.confluence.search.lucene.IndexQueueFlusher.executeJob(IndexQueueFlusher.java:30)
at com.atlassian.confluence.setup.quartz.AbstractClusterAwareQuartzJobBean.surroundJobExecutionWithLogging(AbstractClusterAwareQuartzJobBean.java:64)
at com.atlassian.confluence.setup.quartz.AbstractClusterAwareQuartzJobBean.executeInternal(AbstractClusterAwareQuartzJobBean.java:46)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
... 2 more
Caused by: net.sf.hibernate.TransactionException: Rollback failed with SQL exception:
at net.sf.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:91)
at org.springframework.orm.hibernate.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:529)
... 14 more
Caused by: org.postgresql.util.PSQLException: This connection has been closed.
at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:822)
at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:839)
at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:855)
at net.sf.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:86)
... 15 more

[Mark Gerber]

strange that confluence log shows log info from 18th of Jan, then today....i guess when it was restarted

[Mark Gerber]

Should I just restart all services?

[Nic Brough -Adaptavist-]

That's an error with Confluence trying to talk to the database.  There are several things that could be the problem - is there any more below the error you have posted?

But yes, a restart might help