專案上線, 連線出錯

小記一下

昨晚一個專案上線,剛上線就在程式日誌中發現以下錯誤.
收到開發同事同事MAIL後,看到錯誤,猜想應該是接連出了問題
登入資料庫主機top了一把,
啊,連線多了300多個,哪來的?
馬上進入資料庫看了一下,Kao.
10幾臺webserver過來的連線數正好都是webconfig中限定的值大小.(平時只有限定值的1/4)
明白了,肯定是建立連線時出了問題.(其實下面錯誤已經提示得很清楚了)

通知開發同事,檢視程式中所有建立新連線處是否有問題?
半小時後,結果是程式只新開連線,但沒有去close.
哈哈!

 

07/17/2008 18:19:15 Error  : Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.

 SQL : Select f1,f2 From Txxxx Where id = :ID

  : :ID ='1114294'     at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OracleClient.OracleConnection.Open()
   at eHR.BLL.OracleDBBase.OpenCn()
   at eHR.BLL.OracleDBBase.ExecuteReader(CommandType objCmdType, String p_strSQL, OracleParameter[] p_arrparmCmdParms) 
  
07/17/2008 18:19:25 Error : Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.

 SQL :  SELECT  f1,f2,f3  FROM Txxxx WHERE ID=:ID

 : ID='1394205'     at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OracleClient.OracleConnection.Open()
   at eHR.BLL.OracleDBBase.OpenCn()
   at eHR.BLL.OracleDBBase.ExecuteDataSetTable(String p_strSQL, OracleParameter[] p_arrparmCmdParms)

 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/7364032/viewspace-403221/，如需轉載，請註明出處，否則將追究法律責任。