struct
DataSource slave2
Detail Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
ErrorCode 08001
Message Error Executing Database Query.
NativeErrorCode 0
RootCause
struct
Cause
struct
Message Connection refused
StackTrace java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158) at java.net.Socket.connect(Socket.java:452) at java.net.Socket.connect(Socket.java:402) at java.net.Socket.<init>(Socket.java:309) at java.net.Socket.<init>(Socket.java:124) at org.postgresql.core.PGStream.<init>(PGStream.java:62) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76) 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:393) at org.postgresql.Driver.connect(Driver.java:267) at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:562) at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67) at java.lang.Thread.run(Thread.java:534)
TagContext
array [empty]
Type java.net.ConnectException
ErrorCode 0
Message Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
SQLState 08001
StackTrace org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:138) 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:393) at org.postgresql.Driver.connect(Driver.java:267) at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:562) at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67) at java.lang.Thread.run(Thread.java:534) Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158) at java.net.Socket.connect(Socket.java:452) at java.net.Socket.connect(Socket.java:402) at java.net.Socket.<init>(Socket.java:309) at java.net.Socket.<init>(Socket.java:124) at org.postgresql.core.PGStream.<init>(PGStream.java:62) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76) ... 9 more
TagContext
array [empty]
Type org.postgresql.util.PSQLException
SQLState 08001
Sql SELECT b.id, b.user_id AS owner_id, b.name, b.fullname, b.description, b.community, b.handle_comments, b.meta_title, b.meta_description, b.meta_keywords, ( SELECT x.username FROM users.users x WHERE x.site_id = (param 1) AND x.id = b.user_id ) AS owner_username, ( 0 ) AS is_friend FROM blog.blog b WHERE b.site_id = (param 2) AND b.name = (param 3)
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:580) at cfmain2ecfc806760630$funcGETREQUEST.runFunction(/sites/aicode.net/components/blog/main.cfc:66) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:341) at cfpost2ecfm1232530849.runPage(/sites/aicode.net/html/common/blog/post.cfm:13) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) at cfmain2ecfc1413704981$funcREQUESTSTART.runFunction(/sites/aicode.net/components/core/main.cfc:362) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:341) at cfApplication2ecfc1001765441$funcONREQUEST.runFunction(/sites/Application.cfc:13) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:169) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:74) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:180) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:215) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115) at coldfusion.CfmServlet.service(CfmServlet.java:107) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 66
RAW_TRACE at cfmain2ecfc806760630$funcGETREQUEST.runFunction(/sites/aicode.net/components/blog/main.cfc:66)
TEMPLATE /sites/aicode.net/components/blog/main.cfc
TYPE CFML
2
struct
COLUMN 0
ID CFINVOKE
LINE 13
RAW_TRACE at cfpost2ecfm1232530849.runPage(/sites/aicode.net/html/common/blog/post.cfm:13)
TEMPLATE /sites/aicode.net/html/common/blog/post.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 362
RAW_TRACE at cfmain2ecfc1413704981$funcREQUESTSTART.runFunction(/sites/aicode.net/components/core/main.cfc:362)
TEMPLATE /sites/aicode.net/components/core/main.cfc
TYPE CFML
4
struct
COLUMN 0
ID CFINVOKE
LINE 13
RAW_TRACE at cfApplication2ecfc1001765441$funcONREQUEST.runFunction(/sites/Application.cfc:13)
TEMPLATE /sites/Application.cfc
TYPE CFML
Type Database
queryError Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
where (param 1) = [type='IN', class='java.lang.String', value='166', sqltype='CF_SQL_INTEGER'] , (param 2) = [type='IN', class='java.lang.String', value='166', sqltype='CF_SQL_INTEGER'] , (param 3) = [type='IN', class='java.lang.String', value='general', sqltype='CF_SQL_VARCHAR']