locked
System.OutOfMemoryException DatabaseMail RRS feed

  • 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)

    Tuesday, April 24, 2012 5:27 PM

Answers

  • 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.

    • Proposed as answer by amber zhang Wednesday, April 25, 2012 7:46 AM
    • Marked as answer by ibgoneoften Wednesday, April 25, 2012 7:35 PM
    Wednesday, April 25, 2012 7:05 AM