Bug #10657 Not enough storage is available to process this command

• Submitted: 16 May 2005 8:27
• Modified: 18 May 2005 6:16
• Reporter: mark Richardson
• Status: Can't repeat
• Category: Connector / ODBC
• Severity: S1 (Critical)
• Version: 4.0.24-nt
• OS: Windows (Windows 2003 web SP1)
• CPU Architecture: Any

[16 May 2005 8:27] mark Richardson

Description:
after several hours of server activity the webserver will send this error

Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[MySQL][ODBC 3.51 Driver]Not enough storage is available to process this command. 

/include/Openconnection.asp, line 7

caused on this line  [ObjDB.Open "DSN=TREASUREBOX"]

**************code from Openconnection.asp**************

If not IsObject(ObjDB) Then
    set ObjDB=Server.CreateObject("ADODB.Connection")
    ObjDB.ConnectionTimeout = 15
    ObjDB.CommandTimeout = 10
    ObjDB.Mode = 3 'adModeReadWrite 
    If ObjDB.state = 0 Then
	ObjDB.Open "DSN=TREASUREBOX"
    End If
End If

******************************************************

How to repeat:
using the the MyODBC drivers 3.51.11 the error appears after several hours.

Suggested fix:
Documentation, or patch

[18 May 2005 6:16] Vasily Kishkin

I tried to repeat the bug but all worked fine.

[18 May 2005 9:37] mark Richardson

As you can see below the number of visitors is gradually increasing, am i asking too much from mysql, it`s averaging 65 queries a second.

Month Unique visitors Number of visits Pages Hits Bandwidth 
Jan 2005 11013 18868 917517 2362925 15.07 GB 
Feb 2005 12665 22843 1704376 3979627 24.41 GB 
Mar 2005 15983 28346 3101267 6471300 35.70 GB 
Apr 2005 19328 33291 3941751 7921752 42.46 GB

[18 May 2005 9:42] mark Richardson

maybe there is a way to completly remove all odbc driver, and the mysql engine, and re-install.