This discussion is archived
9 Replies Latest reply: Feb 4, 2013 7:50 AM by Joe Weinstein RSS

JDBC Error In WL Managed Server Log:<BEA-001112> <Test "SELECT 1 FROM DUAL"

818997 Newbie
Currently Being Moderated
Hi ,
Frequently,I am coming accross this error in my weblogic server log "<BEA-001112> <Test "SELECT 1 FROM DUAL" set up for pool "Reporting Connection Pool Prod" failed with exception: "java.sql.SQLException: Io exception: Connection reset by peer: socket write error".>". Any pointers on how to resolve this?


<<WLS Kernel>> <> <BEA-170018> <The log file has been rotated to MyOwnServer_Managed_Server.log01317. Log messages will continue to be logged in .\MyOwnServer_Managed_Server\MyOwnServer_Managed_Server.log.>
####<Dec 8, 2010 11:00:00 PM PST> <Info> <null> <unknown> <unknown> <ExecuteThread: '2' for queue: 'weblogic.kernel.System'> <null> <null> <000000> <LogRotation trigger for logfile .\MyOwnServer_Managed_Server\MyOwnServer_Managed_Server.log>
####<Dec 8, 2010 11:01:01 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <Thread-9> <<WLS Kernel>> <> <BEA-001128> <Connection for pool "Cp Connection Pool" closed.>
####<Dec 8, 2010 11:01:01 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <Thread-9> <<WLS Kernel>> <> <BEA-001128> <Connection for pool "Cp Connection Pool" closed.>
####<Dec 8, 2010 11:01:01 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <Thread-9> <<WLS Kernel>> <> <BEA-001128> <Connection for pool "Cp Connection Pool" closed.>
####<Dec 8, 2010 11:01:01 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <Thread-9> <<WLS Kernel>> <> <BEA-001128> <Connection for pool "Cp Connection Pool" closed.>
####<Dec 8, 2010 11:03:33 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '23' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001068> <Connection for pool "Cp Connection Pool" created.>
####<Dec 8, 2010 11:03:33 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '23' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "Cp Connection Pool".>
####<Dec 8, 2010 11:03:34 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '23' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001068> <Connection for pool "Cp Connection Pool" created.>
####<Dec 8, 2010 11:03:34 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '23' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "Cp Connection Pool".>
####<Dec 8, 2010 11:03:34 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '23' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001068> <Connection for pool "Cp Connection Pool" created.>
####<Dec 8, 2010 11:03:34 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '23' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "Cp Connection Pool".>
####<Dec 8, 2010 11:03:34 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '23' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001068> <Connection for pool "Cp Connection Pool" created.>
####<Dec 8, 2010 11:03:34 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '23' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "Cp Connection Pool".>
####<Dec 8, 2010 11:03:34 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '23' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001068> <Connection for pool "Cp Connection Pool" created.>
####<Dec 8, 2010 11:03:34 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '23' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "Cp Connection Pool".>
####<Dec 8, 2010 11:03:34 PM PST> <Info> <Common> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '23' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-000628> <Created "5" resources for pool "Cp Connection Pool", out of which "5" are available and "0" are unavailable.>
####<Dec 8, 2010 11:16:01 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <Thread-9> <<WLS Kernel>> <> <BEA-001128> <Connection for pool "Cp Connection Pool" closed.>
####<Dec 8, 2010 11:16:01 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <Thread-9> <<WLS Kernel>> <> <BEA-001128> <Connection for pool "Cp Connection Pool" closed.>
####<Dec 8, 2010 11:16:01 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <Thread-9> <<WLS Kernel>> <> <BEA-001128> <Connection for pool "Cp Connection Pool" closed.>
####<Dec 8, 2010 11:16:01 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <Thread-9> <<WLS Kernel>> <> <BEA-001128> <Connection for pool "Cp Connection Pool" closed.>
####<Dec 8, 2010 11:16:01 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <Thread-9> <<WLS Kernel>> <> <BEA-001128> <Connection for pool "Cp Connection Pool" closed.>
####<Dec 8, 2010 11:19:28 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '6' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001068> <Connection for pool "Cp Connection Pool" created.>
####<Dec 8, 2010 11:19:28 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '6' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "Cp Connection Pool".>
####<Dec 8, 2010 11:19:28 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '6' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001068> <Connection for pool "Cp Connection Pool" created.>
####<Dec 8, 2010 11:19:28 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '6' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "Cp Connection Pool".>
####<Dec 8, 2010 11:19:29 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '6' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001068> <Connection for pool "Cp Connection Pool" created.>
####<Dec 8, 2010 11:19:29 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '6' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "Cp Connection Pool".>
####<Dec 8, 2010 11:19:29 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '6' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001068> <Connection for pool "Cp Connection Pool" created.>
####<Dec 8, 2010 11:19:29 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '6' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "Cp Connection Pool".>
####<Dec 8, 2010 11:19:29 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '6' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001068> <Connection for pool "Cp Connection Pool" created.>
####<Dec 8, 2010 11:19:29 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '6' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "Cp Connection Pool".>
####<Dec 8, 2010 11:19:29 PM PST> <Info> <Common> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '6' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-000628> <Created "5" resources for pool "Cp Connection Pool", out of which "5" are available and "0" are unavailable.>
####<Dec 8, 2010 11:22:51 PM PST> <Debug> <Common> <MyOwnServer> <MyOwnServer_Managed_Server> <Thread-9> <<WLS Kernel>> <> <BEA-000610> < RP(Cp Connection Pool):timeoutInactiveRes (20)>
####<Dec 8, 2010 11:22:51 PM PST> <Debug> <Common> <MyOwnServer> <MyOwnServer_Managed_Server> <Thread-9> <<WLS Kernel>> <> <BEA-000610> < RP(Cp Connection Pool):timeoutInactiveRes (30)>
####<Dec 8, 2010 11:22:51 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <Thread-9> <<WLS Kernel>> <> <BEA-001128> <Connection for pool "Cp Connection Pool" closed.>
####<Dec 8, 2010 11:22:51 PM PST> <Warning> <Common> <MyOwnServer> <MyOwnServer_Managed_Server> <Thread-9> <<WLS Kernel>> <> <BEA-000620> <Forcibly releasing inactive resource "weblogic.jdbc.common.internal.ConnectionEnv@17072ab" back into the pool "Cp Connection Pool".>
####<Dec 8, 2010 11:31:01 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <Thread-9> <<WLS Kernel>> <> <BEA-001128> <Connection for pool "Cp Connection Pool" closed.>
####<Dec 8, 2010 11:31:01 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <Thread-9> <<WLS Kernel>> <> <BEA-001128> <Connection for pool "Cp Connection Pool" closed.>
####<Dec 8, 2010 11:31:01 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <Thread-9> <<WLS Kernel>> <> <BEA-001128> <Connection for pool "Cp Connection Pool" closed.>
####<Dec 8, 2010 11:31:01 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <Thread-9> <<WLS Kernel>> <> <BEA-001128> <Connection for pool "Cp Connection Pool" closed.>
####<Dec 8, 2010 11:34:59 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '6' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001068> <Connection for pool "Cp Connection Pool" created.>
####<Dec 8, 2010 11:34:59 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '6' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "Cp Connection Pool".>
####<Dec 8, 2010 11:34:59 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '6' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001068> <Connection for pool "Cp Connection Pool" created.>
####<Dec 8, 2010 11:34:59 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '6' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "Cp Connection Pool".>
####<Dec 8, 2010 11:34:59 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '6' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001068> <Connection for pool "Cp Connection Pool" created.>
####<Dec 8, 2010 11:34:59 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '6' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "Cp Connection Pool".>
####<Dec 8, 2010 11:34:59 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '6' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001068> <Connection for pool "Cp Connection Pool" created.>
####<Dec 8, 2010 11:34:59 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '6' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "Cp Connection Pool".>
####<Dec 8, 2010 11:34:59 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '6' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001068> <Connection for pool "Cp Connection Pool" created.>
####<Dec 8, 2010 11:34:59 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '6' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "Cp Connection Pool".>
####<Dec 8, 2010 11:34:59 PM PST> <Info> <Common> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '6' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-000628> <Created "5" resources for pool "Cp Connection Pool", out of which "5" are available and "0" are unavailable.>
####<Dec 8, 2010 11:35:11 PM PST> <Error> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '31' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001112> <Test "SELECT 1 FROM DUAL" set up for pool "Reporting Connection Pool Prod" failed with exception: "java.sql.SQLException: Io exception: Connection reset by peer: socket write error".>
####<Dec 8, 2010 11:35:11 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '31' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001128> <Connection for pool "Reporting Connection Pool Prod" closed.>
####<Dec 8, 2010 11:35:11 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '31' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001067> <Connection for pool "Reporting Connection Pool Prod" refreshed.>
####<Dec 8, 2010 11:46:01 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <Thread-9> <<WLS Kernel>> <> <BEA-001128> <Connection for pool "Cp Connection Pool" closed.>
####<Dec 8, 2010 11:46:01 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <Thread-9> <<WLS Kernel>> <> <BEA-001128> <Connection for pool "Cp Connection Pool" closed.>
####<Dec 8, 2010 11:46:01 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <Thread-9> <<WLS Kernel>> <> <BEA-001128> <Connection for pool "Cp Connection Pool" closed.>
####<Dec 8, 2010 11:46:01 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <Thread-9> <<WLS Kernel>> <> <BEA-001128> <Connection for pool "Cp Connection Pool" closed.>
####<Dec 8, 2010 11:46:01 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <Thread-9> <<WLS Kernel>> <> <BEA-001128> <Connection for pool "Cp Connection Pool" closed.>
####<Dec 8, 2010 11:52:17 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '31' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001068> <Connection for pool "Cp Connection Pool" created.>
####<Dec 8, 2010 11:52:17 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '31' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "Cp Connection Pool".>
####<Dec 8, 2010 11:52:17 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '31' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001068> <Connection for pool "Cp Connection Pool" created.>
####<Dec 8, 2010 11:52:17 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '31' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "Cp Connection Pool".>
####<Dec 8, 2010 11:52:17 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '31' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001068> <Connection for pool "Cp Connection Pool" created.>
####<Dec 8, 2010 11:52:17 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '31' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "Cp Connection Pool".>
####<Dec 8, 2010 11:52:17 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '31' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001068> <Connection for pool "Cp Connection Pool" created.>
####<Dec 8, 2010 11:52:17 PM PST> <Info> <JDBC> <MyOwnServer> <MyOwnServer_Managed_Server> <ExecuteThread: '31' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "Cp Connection Pool".>

Edited by: user9372428 on Dec 10, 2010 2:04 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points