3472
社区成员
求助，各位高手解决下问题，关于System.InvalidOperationException: Timeout expired.
回答问题的大虾，请先看我说明的情况，再写你的答案，以免耽误大家的时间！
现在系统（.net+oracle+IIs6.0+win2003 sp2）经常出现如下异常（见异常详细信息），导致系统无非登陆和运行，数据库oracle 10g,12月28号在测试服务器做过一次数据库变动，在同一个服务中建了一个新用户，将数据库导入新用户下，以后便经常出现下面的异常，而且非常频繁，基本上半个小时可能就出现一次，每次将应用池手动回收一次就可以了，期间解决方式改过进程数为800，但依然不好用，改IIS应用池回收时间为300分钟依然不好用，查询数据库的连接session，因为是测试环境，最多才达到140多，但同样的系统在UAT服务器上没有任何问题，（所以不是系统连接未释放的原因）
希望各位大虾能给找到原因，谢谢
详细异常如下
[15] [Error] System.InvalidOperationException: 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.
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 App.Data.OracleClient.OracleProvider.GetConnection(String connectionString) in E:\Applications\AppFX\V0.3.5\App.Data.OracleClient\OracleProvider.cs:line 121
at App.Data.OracleClient.OracleProvider.CreateDataContext(DataSource source, IsolationLevel isoLevel) in E:\Applications\AppFX\V0.3.5\App.Data.OracleClient\OracleProvider.cs:line 74
at App.Services.TransactionContext.GetDataContext(DataSource ds, IsolationLevel iso) in E:\Applications\AppFX\V0.3.5\App\Services\TransactionContext.cs:line 121
at App.Services.TransactionContext.SelectOne(SelectQuery query) in E:\Applications\AppFX\V0.3.5\App\Services\TransactionContext.cs:line 646
at App.Services.TransactionContext.SelectOne[T](String where, String spans, Boolean forUpdate) in E:\Applications\AppFX\V0.3.5\App\Services\TransactionContext.cs:line 694
at App.Services.ServiceExecutor.Execute() in E:\Applications\AppFX\V0.3.5\App\Services\ServiceExecutor.cs:line 227
现在系统（.net+oracle+IIs6.0+win2003 sp2）经常出现如下异常（见异常详细信息），导致系统无非登陆和运行，数据库oracle 10g,12月28号在测试服务器做过一次数据库变动，在同一个服务中建了一个新用户，将数据库导入新用户下，以后便经常出现下面的异常，而且非常频繁，基本上半个小时可能就出现一次，每次将应用池手动回收一次就可以了，期间解决方式改过进程数为800，但依然不好用，改IIS应用池回收时间为300分钟依然不好用，查询数据库的连接session，因为是测试环境，最多才达到140多，但同样的系统在UAT服务器上没有任何问题，（所以不是系统连接未释放的原因）
希望各位大虾能给找到原因，谢谢
详细异常如下
[15] [Error] System.InvalidOperationException: 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.
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 App.Data.OracleClient.OracleProvider.GetConnection(String connectionString) in E:\Applications\AppFX\V0.3.5\App.Data.OracleClient\OracleProvider.cs:line 121
at App.Data.OracleClient.OracleProvider.CreateDataContext(DataSource source, IsolationLevel isoLevel) in E:\Applications\AppFX\V0.3.5\App.Data.OracleClient\OracleProvider.cs:line 74
at App.Services.TransactionContext.GetDataContext(DataSource ds, IsolationLevel iso) in E:\Applications\AppFX\V0.3.5\App\Services\TransactionContext.cs:line 121
at App.Services.TransactionContext.SelectOne(SelectQuery query) in E:\Applications\AppFX\V0.3.5\App\Services\TransactionContext.cs:line 646
at App.Services.TransactionContext.SelectOne[T](String where, String spans, Boolean forUpdate) in E:\Applications\AppFX\V0.3.5\App\Services\TransactionContext.cs:line 694
at App.Services.ServiceExecutor.Execute() in E:\Applications\AppFX\V0.3.5\App\Services\ServiceExecutor.cs:line 227
...全文
请发表友善的回复…
发表回复