小记一下

昨晚一个项目上线,刚上线就在程序日志中发现以下错误.
收到开发同事同事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)