小记一下
昨晚一个项目上线,刚上线就在程序日志中发现以下错误.
收到开发同事同事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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7364032/viewspace-403221/