FIX: Error message when a System.Data thread tries to open a pooled connection in the .NET Framework 2.0: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool

FIX: Error message when a System.Data thread tries to open a pooled connection in the .NET Framework 2.0: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool

Article ID : 948868
Last Review : April 2, 2008
Revision : 1.0
On This Page

SYMPTOMS

Consider the following scenario. In the Microsoft .NET Framework 2.0, a System.Data thread tries to open a pooled connection. At the same time, another thread tries to clear that pool by using the ClearPool method or the ClearAllPools method. In this scenario, you receive the following error message:

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.

This problem occurs in the following versions of the .NET Framework 2.0:

• The release version of the .NET Framework 2.0
• The .NET Framework 2.0 Service Pack 1

Back to the top

CAUSE

This problem occurs because of a race condition in the internal call of the GetConnection method. After both the connection pool group and the connection pool are obtained, the GetConnection method is called on the pool. If the ClearPool method is called between the GetConnectionPool method and the GetConnection method, the pool state is changed to ShuttingDown, and the GetConnection method returns the null value. These things occur because of the race condition. Then, because the null value is interpreted as a time-out, you receive the error message that is mentioned in the Symptoms section.

Back to the top

RESOLUTION

Hotfix information

To resolve this problem, install the hotfix that is mentioned in the following article in the Microsoft Knowledge Base:

948815 (/Feedback.aspx?kbNumber=948815/) Availability of the .NET Framework 2.0 post-Service Pack 1 hotfix rollup package for System.Data.dll and System.Data.OracleClient.dll

Prerequisites

You must have the .NET Framework 2.0 Service Pack 1 installed to apply this hotfix.

Restart requirement

You do not have to restart the computer after you apply this hotfix.

Hotfix replacement information

This hotfix does not replace any other hotfixes.

File information

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

The .NET Framework 2.0, x86 versions
File name File version File size Date Time Platform
System.data.dll 2.0.50727.1813 2,998,272 04-Feb-2008 20:49 x86
System.data.oracleclient.dll 2.0.50727.1813 484,352 04-Feb-2008 20:49 x86
The .NET Framework 2.0, x64 versions
File name File version File size Date Time Platform
System.data.dll 2.0.50727.1813 2,998,272 04-Feb-2008 20:49 x86
System.data.oracleclient.dll 2.0.50727.1813 484,352 04-Feb-2008 20:49 x86
System.data.dll 2.0.50727.1810 3,113,472 14-Jan-2008 15:36 x64
System.data.oracleclient.dll 2.0.50727.1810 499,712 14-Jan-2008 15:36 x64
The .NET Framework 2.0, Itanium-based versions
File name File version File size Date Time Platform
System.data.dll 2.0.50727.1813 2,998,272 04-Feb-2008 20:49 x86
System.data.oracleclient.dll 2.0.50727.1813 484,352 04-Feb-2008 20:49 x86
System.data.dll 2.0.50727.1813 3,208,192 04-Feb-2008 17:25 IA-64
System.data.oracleclient.dll 2.0.50727.1813 503,808 04-Feb-2008 17:25 IA-64

Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the Applies to section.

Back to the top

MORE INFORMATION

For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:

824684 (/Feedback.aspx?kbNumber=824684/) Description of the standard terminology that is used to describe Microsoft software updates

Back to the top

Call stack information

System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)System.Data.SqlClient.SqlConnection.Open()

Back to the top


APPLIES TO
• Microsoft .NET Framework 2.0

Back to the top

Keywords: 
kbexpertiseadvanced kbpubtypekc kbqfe kbhotfixserver KB948868

Back to the top

 

Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
Microsoft Corporation. All rights reserved. Terms of Use | Trademarks


You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

AddThis Social Bookmark Button

Leave a Reply

*
To prove that you're not a bot, enter this code
Anti-Spam Image