IDS Forum

Re: Invalid Handle

Posted By: MIKE CADDY
Date: Friday, 28 August 2009, at 1:46 p.m.

In Response To: Re: Invalid Handle (MIKE CADDY)

HELP

I've been looking into my error in a little more detail it seems there is not one single source of the error. See bellow for the code being run and some stack traces from the application

I Think I've also got a memory leak, when calling into the code aproximalty 600 times I get about 80-100 mb of leaked memory that is not released until the worker processes are restarted.

http://localhost:8013/DevStaffPicture.ashx?StaffNumber=12345&MaxWidth=100
System.ArgumentException Invalid Handle
at IBM.Data.Informix.IfxConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at IBM.Data.Informix.IfxSmartLOB.internalClose()
at IBM.Data.Informix.IfxSmartLOB.Close()
at IBM.Data.Informix.IfxDataReader.internalGetBlobData(Int32 i)
at IBM.Data.Informix.IfxDataReader.GetBytes(Int32 i, Int64 dataIndex, Byte[] buffer, Int32 bufferIndex, Int32 length)
at StaffDetails.DevStaffPicture.ProcessRequest(HttpContext context) in C:\WorkSpace\StaffPicTest\DevStaffPicture.ashx.cs:line 49

http://localhost:8013/DevStaffPicture.ashx?StaffNumber=12345&MaxWidth=100
System.ArgumentException Invalid Handle
at IBM.Data.Informix.IfxConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at IBM.Data.Informix.IfxDataReader.get_FieldCount()
at IBM.Data.Informix.IfxDataReader.BuildMetaDataInfo()
at IBM.Data.Informix.IfxDataReader.IfxRowSet.InitiateRowWiseBinding()
at IBM.Data.Informix.IfxDataReader.IfxRowSet..ctor(IfxDataReader dataReader)
at IBM.Data.Informix.IfxDataReader.Read()
at StaffDetails.DevStaffPicture.ProcessRequest(HttpContext context) in C:\WorkSpace\StaffPicTest\DevStaffPicture.ashx.cs:line 45

http://localhost:8013/DevStaffPicture.ashx?StaffNumber=12345&MaxWidth=100
System.ArgumentException Invalid Handle
at IBM.Data.Informix.IfxConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at IBM.Data.Informix.IfxSmartLOB.internalRead(Object buff, Int64 buffOffset, Int64 numBytesToRead, Int64 smartLOBOffset, IfxSmartLOBWhence whence)
at IBM.Data.Informix.IfxSmartLOB.internalRead(Object buff)
at IBM.Data.Informix.IfxDataReader.internalGetBlobData(Int32 i)
at IBM.Data.Informix.IfxDataReader.GetBytes(Int32 i, Int64 dataIndex, Byte[] buffer, Int32 bufferIndex, Int32 length)
at StaffDetails.DevStaffPicture.ProcessRequest(HttpContext context) in C:\WorkSpace\StaffPicTest\DevStaffPicture.ashx.cs:line 49

http://localhost:8013/DevStaffPicture.ashx?StaffNumber=12345&MaxWidth=100
System.ArgumentException Invalid Handle
at IBM.Data.Informix.IfxConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at IBM.Data.Informix.IfxSmartLOB.get_internalPosition()
at IBM.Data.Informix.IfxSmartLOB.internalRead(Object buff)
at IBM.Data.Informix.IfxDataReader.internalGetBlobData(Int32 i)
at IBM.Data.Informix.IfxDataReader.GetBytes(Int32 i, Int64 dataIndex, Byte[] buffer, Int32 bufferIndex, Int32 length)
at StaffDetails.DevStaffPicture.ProcessRequest(HttpContext context) in C:\WorkSpace\StaffPicTest\DevStaffPicture.ashx.cs:line 49

http://localhost:8013/DevStaffPicture.ashx?StaffNumber=12345&MaxWidth=100
System.AccessViolationException Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
at IBM.Data.Common.UnsafeNativeMethods.Ifx32.SQLFreeStmt(IntPtr StatementHandle, Int16 Option)
at IBM.Data.Informix.IfxDataReader.Dispose(Boolean disposing)
at IBM.Data.Informix.IfxDataReader.System.IDisposable.Dispose()
at IBM.Data.Informix.IfxCommand.ExecuteScalar()
at StaffDetails.StaffPicture.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Source

using System;
using System.Configuration;
using System.Data;
using System.Drawing;
using System.Drawing.Imaging;
using System.IO;
using System.Web;
using IBM.Data.Informix;

namespace StaffDetails
{
/// <summary>
/// Staff Picture Web Handler to return image from Informix DB
/// </summary>
public class DevStaffPicture : IHttpHandler
{
/// <summary>
/// Process the Request - Get the blob from the DB, resize if required and render
/// </summary>
/// <param name="context">the HttpContext</param>
public void ProcessRequest(HttpContext context)
{
//Get Execution Parameters
int StaffNum = ValidateNumberQueryStringParameter(context.Request);
int MaxHeight = ValidateNumberQueryStringParameter(context.Request);
int MaxWidth = ValidateNumberQueryStringParameter(context.Request);

//Set Jpeg Response content type
context.Response.ContentType = "image/jpeg";
context.Response.Buffer = false;

byte[] staffPic = null;

try
{
using (IfxConnection InformixConnection = new IfxConnection(ConfigurationManager.ConnectionStrings.ConnectionString))
{
InformixConnection.Open();
using (IfxCommand StaffPictureConnnection = new IfxCommand("get_staff_photo", InformixConnection))
{
StaffPictureConnnection.CommandType = CommandType.StoredProcedure;
StaffPictureConnnection.Parameters.Add("staffnumber", StaffNum);

IfxDataReader staffPicReader = StaffPictureConnnection.ExecuteReader();
if (staffPicReader.Read()) <<<<<< Line 45 >>>>>>>
{
if (!staffPicReader.IsDBNull(0))
{
int BlobSize = (int)staffPicReader.GetBytes(0, 0, null, 0, 0); <<<<<< Line 49 >>>>>>>
staffPic = new byteBlobSize;
staffPicReader.GetBytes(0, 0, staffPic, 0, BlobSize);
}
}
//Also tested with
//staffPic = StaffPictureConnnection.ExecuteScalar() as byte[];
//We might get null if we feed the DB an invalid Staff number
}
}
}
catch (IfxException ex)
{
SendErrorEmail("Staff Pic Ifx Exception", ex.Message + "\r\n" + ex.StackTrace, "PicTest", ConfigurationManager.AppSettings,
ConfigurationManager.AppSettings, ConfigurationManager.AppSettings);
}
catch (Exception ex)
{
SendErrorEmail("Staff Pic Exception", ex.GetType().ToString() + "\r\n" + ex.Message + "\r\n" + ex.StackTrace, "PicTest", ConfigurationManager.AppSettings,
ConfigurationManager.AppSettings, ConfigurationManager.AppSettings);
}

if (staffPic == null)
{
//Load a "Invalid User" Image
staffPic = File.ReadAllBytes(context.Server.MapPath("~/images/noPhoto.jpg"));
}

//Check If we have been asked to resize
if ((MaxHeight > 0) || (MaxWidth > 0))
{
staffPic = ResizeImage(staffPic, MaxHeight, MaxWidth);
}
//Write it out to the user
context.Response.OutputStream.Write(staffPic, 0, staffPic.Length);
context.Response.End();
staffPic = null;
}

Messages In This Thread

• Invalid Handle
  MIKE CADDY -- Wednesday, 19 August 2009, at 5:13 a.m.
  • Re: Invalid Handle
    Art Kagel -- Wednesday, 19 August 2009, at 7:10 a.m.
    • Re: Invalid Handle
      MIKE CADDY -- Wednesday, 19 August 2009, at 7:48 a.m.
      • Re: Invalid Handle
        MIKE CADDY -- Friday, 28 August 2009, at 1:46 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.