MySQL Bugs: #25675: An unhandled exception has occurred.

Bug #25675	An unhandled exception has occurred.
Submitted:	17 Jan 2007 10:12	Modified:	19 Jan 2007 8:31
Reporter:	ryan m	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	3.51.12	OS:	Windows (windows 2003 server)
Assigned to:		CPU Architecture:	Any

Description:
we have installed version 3.51.12 of the odbc connector onto our site and every now and then under certain loads it shows an error 

 
Request information: 
    Request URL: removed
    Request path: /listings.aspx 
    User host address: 66.249.*.*
    User:  
    Is authenticated: False 
    Authentication Type:  
    Thread account name: NT AUTHORITY\NETWORK SERVICE 
 
Thread information: 
    Thread ID: 1 
    Thread account name: NT AUTHORITY\NETWORK SERVICE 
    Is impersonating: False 
    Stack trace:    at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
   at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.Odbc.OdbcConnection.Open()
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
   at System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments)
   at System.Web.UI.WebControls.BaseDataList.GetData()
   at System.Web.UI.WebControls.DataList.CreateControlHierarchy(Boolean useDataSource)
   at System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e)
   at System.Web.UI.WebControls.BaseDataList.DataBind()
   at System.Web.UI.WebControls.BaseDataList.EnsureDataBound()
   at System.Web.UI.WebControls.BaseDataList.CreateChildControls()
   at System.Web.UI.Control.EnsureChildControls()
   at System.Web.UI.WebControls.DataList.get_Items()
   at school_listings.Page_Load(Object sender, EventArgs e)
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

the site seems to work still but this error keeps getting logged ive tried the beta versions to see if that fixes the problems without sucess, please advise

thanks

How to repeat:
install odbc driver, then problem occurs

Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Explanation:
Hi. It is virtualy impossible to tell what's happening from info provided... A wild guess would be that you are hitting some limit and/or timeout. Also, there are known issues with IIS and pooling, please search MSDN for more info.

hi thanks for getting back

it seems to happen at random time we have disabled connection pooling when opening the recordset, 

all connections within the script are closing correctly, but it seems to happen when there is a lot of traffic on the site, I notice when searching the net a few people are having similar issues but say it is fixed in the beta version which I have tried and it still seems present,

ive tried putting the scripts directly on the database server and it works fine, so im stuck really

hope yourselves manage to get more information and if it is a bug correct it,

thanks again for your help

Ryan,

Since the release of MyODBC 3.51.12 we have made several preliminary versions of 3.51.13 driver. The most recent one was built yesterday:

ftp://ftp.mysql.com/pub/mysql/download/connectors/odbc/mysql-connector-odbc-3.51.13r145_20...

Note: the address can be separated in two lines, so, please join them into one line. Zip archive contains only the driver's dll (myodbc3.dll). You need to copy it into windows\system32 directory and replace the old file. However, in order to release write permissions for this dll it is essential to stop internet information services.

ive tried the latest build of the beta driver and the problem seems to exist still load is not to hugh probably only about 150 connections open when it messes up, pooling is disabled when opening connection, but it fails to connect at random time to the database server, 

any ideas?

Thanks