Thx for u'r response
here is the sample code which works fine and prints column
lengths in HP-UX PA machines and breaks in HP-UX IA machines.
I tried tusc (I sent that o/p in previuos mail.
Client opens a socket and starts to write.but after some send receive it
goes to SLEEPING state)
void FMconnection::insertlargedata()
{
const char * command="insert into
rawlog(event_type,event_source,event_rawdata,event_version) values
($1,$2,$3,$4);";
int nParams = 4;
const Oid paramTypes[] = {NULL,NULL,17,NULL};
int paramFormats[] = {0,0,1,0};
int resultFormat = 0;
const int paramLengths[]={100,200,3000000,10};
char *a = new char[3000000];
const char* paramValues[]={"cpu.event","cpu",a,"1"};
res1=PQexecParams(conn,command,nParams,paramTypes,paramValues,paramLengt
hs,paramFormats,resultFormat);
res1=PQexec(conn,"select * from rawlog");
for(int kk=0;kk<PQntuples(res1);kk++)
cout<<"the size of binary data is
"<<PQgetlength(res1,kk,3)<<endl;
delete a;
}
Hope to see u'r mail soon,
Thx,
Prasanna.
-----Original Message-----
From: Michael Fuhr [mailto:mike@fuhr.org]
Sent: Friday, September 02, 2005 7:45 PM
To: Mavinakuli, Prasanna (STSD)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] LOG: unexpected EOF within message length word
On Fri, Sep 02, 2005 at 09:30:31AM +0530, Mavinakuli, Prasanna (STSD)
wrote:
> When I try to insert the data of size 40764 bytes(data type bytea) the
> call PQexecparams won't return and when I kill that one it gives The
> log:"LOG: unexpected EOF within message length word"
> Or "Log:Incomplete message transfer from client".
>
> If I try to insert data of size 40760 bytes (data type:bytea) Then it
> will insert the data succesfully.
Works fine here -- could you post a simple but complete program that
demonstrates the problem? Have you used a debugger or process trace to
see what the program is doing?
--
Michael Fuhr