Re: ECPG crash - upgrade from 8.0.3 to 8.1.10 - Mailing list pgsql-hackers
From | Boergesson, Cheryl |
---|---|
Subject | Re: ECPG crash - upgrade from 8.0.3 to 8.1.10 |
Date | |
Msg-id | 258593F548C79D4AB7CBA2AE72DEBEC803D0DB66@HQ-EXVS02.anteon.com Whole thread Raw |
In response to | upgrade from 8.0.3 to 8.1.10 crash ("Boergesson, Cheryl" <Cheryl.Boergesson@gdit.com>) |
Responses |
Re: ECPG crash - upgrade from 8.0.3 to 8.1.10
|
List | pgsql-hackers |
<div class="Section1"><p class="MsoNormal"><font color="black" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:black">The program below works with PostgreSQL 8.0.3, but not 8.1.10. The error I receiveis:</span></font><p class="MsoNormal"><font color="black" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:black"> </span></font><p class="MsoNormal" style="text-indent:.5in"><font color="black" face="Arial"size="2"><span style="font-size:10.0pt;font-family:Arial;color:black">Runtime Error!</span></font><p class="MsoNormal"><fontcolor="black" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:black"> </span></font><p class="MsoNormal" style="text-indent:.5in"><font color="black" face="Arial"size="2"><span style="font-size:10.0pt;font-family:Arial;color:black">Program: C:\testSQL.exe</span></font><pclass="MsoNormal"><font color="black" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:black"> </span></font><p class="MsoNormal" style="text-indent:.5in"><font color="black" face="Arial"size="2"><span style="font-size:10.0pt;font-family:Arial;color:black">This application has requested the Runtimeto terminate it in an unusual way.</span></font><p class="MsoNormal" style="text-indent:.5in"><font color="black"face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:black">Please contact the application’ssupport team for more information.</span></font><p class="MsoNormal"><font color="black" face="Arial" size="2"><spanstyle="font-size: 10.0pt;font-family:Arial;color:black"> </span></font><p class="MsoNormal"><font color="black" face="Arial" size="2"><spanstyle="font-size: 10.0pt;font-family:Arial;color:black">This happens on the “exec sql commit work” line. If I remove the comments, it workswith both 8.0.3 and 8.1.10. If I change the comments (add a line, delete a line, etc.) it continues to crash, but sometimesit will crash on the “exec sql begin work” line. The connection works fine -</span></font><font color="black"><spanstyle="color:black">sqlca.sqlcode is 0, sqlca.sqlstate is 0000 and sqlca.sqlwarn is blank</span></font><fontcolor="black" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:black"></span></font><pclass="MsoNormal"><font color="black" face="Arial"size="2"><span style="font-size: 10.0pt;font-family:Arial;color:black"> </span></font><p class="MsoNormal"><font color="black" face="Arial" size="2"><spanstyle="font-size: 10.0pt;font-family:Arial;color:black">I am running on WindowsXP and compiling with Visual C++ 6.0.</span></font><p class="MsoNormal"><fontcolor="black" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:black"> </span></font><p class="MsoNormal"><font color="black" face="Arial" size="2"><spanstyle="font-size: 10.0pt;font-family:Arial;color:black">I ran ecpg versions 8.0.3 and 8.1.10 on the file, then compared the created .c files. According to KDiff, the files are identical, except for the first comment line saying which version of ecpg was used.</span></font><pclass="MsoNormal"><font color="black" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:black"> </span></font><p class="MsoNormal"><font color="black" face="Arial" size="2"><spanstyle="font-size: 10.0pt;font-family:Arial;color:black">Here’s the testSQL.pgc code:</span></font><p class="MsoNormal"><font color="black"face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:black"> </span></font><p class="MsoNormal" style="text-autospace:none"><font color="black"face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; color:black">/* add a comment */</span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="CourierNew" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; color:black"> </span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="Courier New" size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"; color:black">/* and another */</span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="CourierNew" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; color:black"> </span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="Courier New" size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"; color:black">/* one more */</span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="CourierNew" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; color:black"> </span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="Courier New" size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"; color:black">main (int argc, char **argv)</span></font><p class="MsoNormal" style="text-autospace:none"><font color="black"face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; color:black">{</span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="Courier New" size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"; color:black"> printf ("connect\n");</span></font><p class="MsoNormal" style="text-autospace:none"><font color="black"face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; color:black"> exec sql connect to mdllt_db as mdllt_cnxtn;</span></font><p class="MsoNormal" style="text-autospace:none"><fontcolor="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"CourierNew"; color:black"> printf ("connection results:\n");</span></font><p class="MsoNormal" style="text-autospace:none"><fontcolor="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"CourierNew"; color:black"> printf ("code: %d\n", sqlca.sqlcode);</span></font><p class="MsoNormal" style="text-autospace:none"><fontcolor="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"CourierNew"; color:black"> printf ("state: %s\n", sqlca.sqlstate);</span></font><p class="MsoNormal" style="text-autospace:none"><fontcolor="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"CourierNew"; color:black"> printf ("warn: %s\n", sqlca.sqlwarn);</span></font><p class="MsoNormal" style="text-autospace:none"><fontcolor="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"CourierNew"; color:black"> </span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="Courier New"size="2"><span style="font-size:10.0pt;font-family:"Courier New"; color:black"> exec sql begin work;</span></font><p class="MsoNormal" style="text-autospace:none"><font color="black"face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; color:black"> printf ("begin results:\n");</span></font><p class="MsoNormal" style="text-autospace:none"><font color="black"face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; color:black"> printf ("code: %d\n", sqlca.sqlcode);</span></font><p class="MsoNormal" style="text-autospace:none"><fontcolor="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"CourierNew"; color:black"> printf ("state: %s\n", sqlca.sqlstate);</span></font><p class="MsoNormal" style="text-autospace:none"><fontcolor="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"CourierNew"; color:black"> printf ("warn: %s\n", sqlca.sqlwarn);</span></font><p class="MsoNormal" style="text-autospace:none"><fontcolor="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"CourierNew"; color:black"> </span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="Courier New"size="2"><span style="font-size:10.0pt;font-family:"Courier New"; color:black"> exec sql commit work;</span></font><p class="MsoNormal" style="text-autospace:none"><font color="black"face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; color:black"> printf ("end\n");</span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="CourierNew" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; color:black"> return 0;</span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="CourierNew" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; color:black">}</span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="Courier New" size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"; color:black"> </span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="Courier New" size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"; color:black">Thanks for any help.</span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="CourierNew" size="2"><span style="font-size:10.0pt;font-family:"Courier New"; color:black">-Cheryl</span></font><p class="MsoNormal" style="text-autospace:none"><font color="black" face="Courier New"size="2"><span style="font-size:10.0pt;font-family:"Courier New"; color:black"> </span></font><p class="MsoNormal"><font color="black" face="Times New Roman" size="3"><span style="font-size:12.0pt;color:black"> </span></font></div>
pgsql-hackers by date: