EAC problems

System Error

A system error has occurred — our apologies!

Please ask your Confluence administrator to create a support issue on Atlassian's support system at
 http://support.atlassian.com with the following information:

   1. a description of your problem and what you were doing at the time it occurred
   2. a copy of the error and system information found below
   3. a copy of the application logs (if possible).

Your Confluence administrator can use the support request form to create a support ticket which will include this information.

We will respond as promptly as possible.
Thank you!

Return to site homepage...
Cause

org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction;
 nested exception is net.sf.hibernate.exception.GenericJDBCException:
 Cannot open connection
    at org.springframework.orm.hibernate.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:473)

caused by: net.sf.hibernate.exception.GenericJDBCException:
 Cannot open connection
    at net.sf.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:80)

caused by: org.postgresql.util.PSQLException:
 FATAL: connection limit exceeded for non-superusers
    at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:443)
Stack Trace:[hide]

org.springframework.transaction.CannotCreateTransactionException:
 Could not open Hibernate Session for transaction; nested exception is net.sf.hibernate.exception.GenericJDBCException:
 Cannot open connection
Caused by: net.sf.hibernate.exception.GenericJDBCException: Cannot open connection
	at net.sf.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:80)
	at net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
	at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
	at net.sf.hibernate.impl.BatcherImpl.convert(BatcherImpl.java:328)
	at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:295)
	at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3373)
	at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3333)
	at org.springframework.orm.hibernate.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:422)
	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.TransactionInterceptor.invoke(TransactionInterceptor.java:101)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	at $Proxy33.getUser(Unknown Source)
	at com.atlassian.confluence.util.UserThreadLocalFilter.getUserFromRequest(UserThreadLocalFilter.java:59)
	at com.atlassian.confluence.util.UserThreadLocalFilter.doFilter(UserThreadLocalFilter.java:35)
	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:206)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98)
	at com.atlassian.confluence.util.AbstractBootstrapHotSwappingFilter.doFilter(AbstractBootstrapHotSwappingFilter.java:30)
	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:131)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66)
	at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:69)
	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74)
	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.atlassian.confluence.util.ClusterHeaderFilter.doFilter(ClusterHeaderFilter.java:35)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:170)
	at com.atlassian.spring.filter.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:29)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.atlassian.confluence.util.ConfluenceErrorFilter.doFilter(ConfluenceErrorFilter.java:22)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:99)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.atlassian.confluence.core.datetime.RequestTimeThreadLocalFilter.doFilter(RequestTimeThreadLocalFilter.java:34)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.atlassian.confluence.util.RequestCacheThreadLocalFilter.doFilter(RequestCacheThreadLocalFilter.java:25)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:81)
	at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter(AbstractCachingFilter.java:33)
	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66)
	at com.atlassian.confluence.extra.webdav.servlet.filter.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:427)
	at com.atlassian.confluence.extra.webdav.servlet.filter.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:34)
	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74)
	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:41)
	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:44)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
	at java.lang.Thread.run(Thread.java:619)
Caused by: org.postgresql.util.PSQLException: FATAL: connection limit exceeded for non-superusers
	at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:443)
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:98)
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
	at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
	at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
	at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
	at org.postgresql.Driver.makeConnection(Driver.java:382)
	at org.postgresql.Driver.connect(Driver.java:260)
	at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
	at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
	at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974)
	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
	at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:59)
	at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:292)
	... 92 more

        

Referer URL

https://extranet.atlassian.com/pages/viewpage.action?pageId=1789362526&replyToComment=1790214392
Confluence Application Information
Build Information

baseUrl: https://extranet.atlassian.com
home: /opt/j2ee/domains/atlassian.com/extranet/webapps/atlassian-confluence/data
buildNumber: 1716
upTime: 5 hours, 57 minutes, 23 seconds
devMode: false
serverId: ALY2-P1PN-IZEU-7CL7
supportEntitlementNumber: null
version: 3.1-beta2
Unique ID: 45af90d2-b5a9-431d-bc8e-8345d632c575
Server information

Application Server: Apache Tomcat/6.0.20
Servlet Version: 2.5
Database Dialect: net.sf.hibernate.dialect.PostgreSQLDialect
Database Driver Name: null
Memory Information

Maximum Heap: 2024 MB
Allocated Heap: 2024 MB
Used Memory: 740 MB
Unused Allocated Memory: 1283 MB
Available Memory: 1283 MB

Maximum Permgen: 256 MB
Used Permgen: 110 MB
System Information

favouriteColour: Lemon chiffon
javaRuntime: Java(TM) SE Runtime Environment
operatingSystem: Linux 2.6.9-78.0.17.ELsmp
jvmVersion: 1.0
fileSystemEncoding: ANSI_X3.4-1968
javaVm: Java HotSpot(TM) Server VM
javaVendor: Sun Microsystems Inc.
jvmImplementationVersion: 14.2-b01
systemTimezone: America/Chicago
appServer: Apache Tomcat
tempDirectory: /opt/j2ee/domains/atlassian.com/extranet/tomcat/temp
date: Monday, 23 Nov 2009
jvmInputArguments: -Djava.util.logging.config.file=/opt/j2ee/domains/atlassian.com/extranet/tomcat/conf/logging.properties
 -Xms2048m -Xmx2048m -Dinstance.id=extranet.atlassian.com -Djava.awt.headless=true -XX:+UseParallelGC -XX:+UseParallelOldGC
 -XX:+HeapDumpOnOutOfMemoryError -XX:MaxPermSize=256m -Xloggc:/var/log/java/extranet.atlassian.com/gc.log -XX:+PrintGCTimeStamps
 -verbose:gc -Dcom.sun.management.snmp.port=10161 -Dcom.sun.management.snmp.interface=172.16.3.110
 -Dcom.sun.management.snmp.acl.file=/service/j2ee_extranet.atlassian.com/user_env/snmp.acl
 -Dconfluence.home=/opt/j2ee/domains/atlassian.com/extranet/webapps/atlassian-confluence/data
 -javaagent:/opt/j2ee/domains/atlassian.com/extranet/newrelic/newrelic.jar
 -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
 -Djava.endorsed.dirs=/opt/j2ee/domains/atlassian.com/extranet/tomcat/endorsed
 -Dcatalina.base=/opt/j2ee/domains/atlassian.com/extranet/tomcat
 -Dcatalina.home=/opt/j2ee/domains/atlassian.com/extranet/tomcat
 -Djava.io.tmpdir=/opt/j2ee/domains/atlassian.com/extranet/tomcat/temp
time: 17:28:15
jvmVendor: Sun Microsystems Inc.
userName: j2ee_extranet.atlassian.com
javaVersion: 1.6.0_16
systemLanguage: en
operatingSystemArchitecture: i386
workingDirectory: /opt/j2ee/domains/atlassian.com/extranet/apache-tomcat-6.0.20
Cluster Information

Name: extranet
Description: TangosolClusterInformation: extranet, listening on 235.54.69.161:32357
Members:
- Member(Id=2, Timestamp=2009-11-23 11:35:39.091, Address=172.16.3.10:8088, MachineId=57135, Location=process:14314@atlassian10.managed.conteg)
- Member(Id=3, Timestamp=2009-11-23 11:30:57.478, Address=172.16.3.11:8088, MachineId=57136, Location=process:20973@atlassian11.managed.conteg)
Plugins

    * Error retrieving plugin information: org.springframework.transaction.CannotCreateTransactionException:
 Could not open Hibernate Session for transaction; nested exception is net.sf.hibernate.exception.GenericJDBCException:
 Cannot open connection

Request
Information

URL
    https://extranet.atlassian.com/500page.jsp 
URI
    /500page.jsp 
Context Path
Servlet Path
    /500page.jsp
Query String
    pageId=1789362526&parentId=1790214392

Headers (Limited subset)

host
    extranet.atlassian.com
x-forwarded-for
    59.167.164.33
user-agent
    Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.5) Gecko/20091109 Ubuntu/9.10 (karmic) Firefox/3.5.5
connection
    Keep-Alive

Attributes

javax.servlet.forward.request_uri
    /pages/doaddcomment.action
javax.servlet.forward.context_path
javax.servlet.forward.servlet_path
    /pages/doaddcomment.action
javax.servlet.forward.path_info
    /500page.jsp
javax.servlet.forward.query_string
    pageId=1789362526&parentId=1790214392
os_securityfilter_already_filtered
    true
atlassian.core.seraph.original.url
    /pages/doaddcomment.action?pageId=1789362526&parentId=1790214392
javax.servlet.error.status_code
    500
javax.servlet.error.servlet_name
    action
com.atlassian.gzipfilter.GzipFilter_already_filtered
    true
loginfilter.already.filtered
    true
com.atlassian.confluence.web.ConfluenceJohnsonFilter_already_filtered
    true
Confluence-Request-Time
    1259018894907
javax.servlet.error.message
com.atlassian.core.filters.HeaderSanitisingFilter_already_filtered
    true
sessioninview.FILTERED
    true
javax.servlet.error.exception
    org.springframework.transaction.CannotCreateTransactionException:
 Could not open Hibernate Session for transaction; nested exception is net.sf.hibernate.exception.GenericJDBCException:
 Cannot open connection
javax.servlet.error.request_uri
    /pages/doaddcomment.action

Parameters (Limited subset)

content
inPreview
    $action.inPreview
parentId
    1790214392
sel1
xhtml
    true
pageId
    1789362526
sel2
confirm
    Post
wysiwygcontent
    <p>I did and didnt see it.&nbsp; Which one describes closures?<br mce_bogus="1"></p>
selectedText
mode
    richtext

Confluence User

bbaker
Logging:

1 log statements generated by this request:
[ERROR] Mon Nov 23 17:28:14 CST 2009 [net.sf.hibernate.util.JDBCExceptionReporter]
 FATAL: connection limit exceeded for non-superusers