A transport-level error has occurred when receiving results from the server.
I've been getting this error in Gemini for a long time, once every 1-4 days or so at different times... Got it in v2.0.5, got it in v2.2.2. Not sure what causes it. Tends to happen sporadically - for instance on a login operation. Works fine for days/hours, then all of a sudden this happens repeatedly for several minutes, then with no human intervention, the error goes away and logins work as normal again. Can also happen while updating issues, looking at issue lists, etc.
I've contacted Gemini Support and been told "It's a SQL Server error, contact your dba". Well, I AM the dba, and I don't know why this problem exists. I have no errors logged on the SQL server, and none of my other applications encounter this problem. Has anyone got any ideas what would cause this, or how to fix it?
System info:
Gemini v2.2.2
915,948KB ram
DB/Network info:
The Gemini application is connecting to a SQL Server 2000 server in the
same physical room, though in a different IP range. The Gemini app is on a
public IP address and the sql server is on an internal address. They're separated by a Cisco 2501 router and HP Procurve 4108GL
switch. Both are behind the same firewall. The SQL box is "healthy"... low avg CPU, 3gb ram, raid5 hard drives for data, etc. It's fast for all other operations, and no other sql-intensive apps (with hundreds of concurrent users) run into problems anything like this.
It's not a blanket config/connect issue, since it tends to be random, and while this is happening, other connections from the same webserver to the same sql server work just fine. It's only Gemini, and it goes away by itself after a few minutes of frustrating all my would-be users.
Any info/help is welcome. Thanks.
Error info:
A transport-level error has occurred when receiving results from the server.
(provider: TCP Provider, error: 0 - Insufficient system resources exist to
complete the requested service.)
10/1/2007 9:41:34 AM
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection) at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,
Boolean breakConnection) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj) at
System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject
stateObj, UInt32 error) at
System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult,
TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected) at
System.Data.SqlClient.TdsParserStateObject.ReadBuffer() at
System.Data.SqlClient.TdsParserStateObject.ReadByte() at
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand
cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,
TdsParserStateObject stateObj) at
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data
.Net SqlClient Data Provider
JBroome
· 1 |
|
Monday, October 1, 2007, 4:24:37 PM |