System.OutOfMemoryException DatabaseMail

Question

After a reboot of our server we are seeing the error below in our event logs. We are running SQL 2008 SP3 on

Windows 2008 R2. We have tried reducing the MaxServer memory but the problem still exists. The process does finally die after some time.

Any insight would be appreciated.

Database Engine Instance=<removed>;Mail PID=6836;Error Message:

1) Exception Information

===================

Exception Type: System.OutOfMemoryException

Message: Exception of type 'System.OutOfMemoryException' was thrown.

Data: System.Collections.ListDictionaryInternal

TargetSite: Int32 ReadPlpUnicodeChars(Char[] ByRef, Int32, Int32, System.Data.SqlClient.TdsParserStateObject)

HelpLink: NULL

Source: System.Data

StackTrace Information

===================

   at System.Data.SqlClient.TdsParser.ReadPlpUnicodeChars(Char[]& buff, Int32 offst, Int32 len, TdsParserStateObject stateObj)

   at System.Data.SqlClient.TdsParser.ReadSqlStringValue(SqlBuffer value, Byte type, Int32 length, Encoding encoding, Boolean isPlp, TdsParserStateObject stateObj)

   at System.Data.SqlClient.TdsParser.ReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj)

   at System.Data.SqlClient.SqlDataReader.ReadColumnData()

   at System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean setTimeout)

   at System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i)

   at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)

   at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.GetSendMailItem(SqlDataReader itemReader)

   at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession)

   at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)

   at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o)

Answer 1

It seems you have a stuck mail in the Queue.Check out the below link

http://www.sqlservercentral.com/Forums/Topic1045743-146-1.aspx

---

Mohd Sufian www.sqlship.wordpress.com Please mark the post as Answered if it helped.