Re: segmentation fault on Dynamic query using C

I have a code(mention below), when i run this code on Intel machine it works
perfectly fine, but when i use AMD machine it giving me segmentation fault
at "EXEC SQL EXECUTE IMMEDIATE :qqq;" line. what could be the problem??

int main(int argc,char *argv[])
{

EXEC SQL BEGIN DECLARE SECTION;
const char *qqq = "insert into strands (id,filename,length,seq)
values(0,\'1\',2,\'{\"C\",\"A\"}\')";
char database[256],target[1024],host[256],user[256];
EXEC SQL END DECLARE SECTION;

exec sql whenever sqlerror sqlprint;

sprintf(target,"mydb(at)localhost");
ECPGdebug(1, stdout);

EXEC SQL CONNECT TO :target user priyank;

printf("1..\n");
EXEC SQL EXECUTE IMMEDIATE :qqq;
printf("2..\n");
EXEC SQL COMMIT;
printf("3..\n");

EXEC SQL DISCONNECT;
return 1;
}

i am using followinf command to make executable file

ecpg filename.pgc
gcc -Wall -o filename filename.o -lecpg -L/usr/local/pgsql/lib
-I/usr/local/pgsql/include -lcrypt

Thanks
Priyank Raj

On Thu, Jan 22, 2009 at 11:40:22AM +0530, Priyank Raj wrote:
> I have a code(mention below), when i run this code on Intel machine it works
> perfectly fine, but when i use AMD machine it giving me segmentation fault
> at "EXEC SQL EXECUTE IMMEDIATE :qqq;" line. what could be the problem??

Difficult to say without digging into it more. Could you run under gdb? Also to
reproduce this, could you please give us the exact table definition you use?
Otherwise we might guess wrong, which might have an impact.

Does it fail on ALL amd machines or just on one (hoping that you have more than
one to test)? Do you recompile on amd or use the same binary? This might be a
compiler optimization problem as well, could you try using different -O values
for gcc?

I can do some debugging as well, but have to either reproduce this on my system
or getting onto yours. :-)

Michael
--
Michael Meskes
Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
Michael at BorussiaFan dot De, Meskes at (Debian|Postgresql) dot Org
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes(at)jabber(dot)org
Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!