upgrade from 8.0.3 to 8.1.10 crash
От | Boergesson, Cheryl |
---|---|
Тема | upgrade from 8.0.3 to 8.1.10 crash |
Дата | |
Msg-id | 258593F548C79D4AB7CBA2AE72DEBEC803D0D6F6@HQ-EXVS02.anteon.com обсуждение исходный текст |
Ответы |
Re: upgrade from 8.0.3 to 8.1.10 crash
("Boergesson, Cheryl" <Cheryl.Boergesson@gdit.com>)
|
Список | pgsql-hackers |
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Hello. I am trying to upgrade from PostgreSQL 8.0.3 to PostgreSQL 8.1.10. <font color="navy"><span style="color:navy">I’mon WindowsXP and I’m compiling with Visual C++ 6.0.</span></font></span></font><p class="MsoNormal"><fontcolor="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">I have a very simple routine that works fine with the 8.0.3 version:</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal" style="text-autospace:none"><font face="Courier New" size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"">int easy_connect()</span></font><p class="MsoNormal" style="text-autospace:none"><fontface="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New"">{</span></font><pclass="MsoNormal" style="text-indent:.5in;text-autospace:none"><font face="Courier New" size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"">exec sql connect to my_db as my_cnxtn;</span></font><p class="MsoNormal"style="text-indent:.5in;text-autospace:none"><font face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"CourierNew"">printf ("connection results:\n");</span></font><p class="MsoNormal" style="text-indent:.5in;text-autospace:none"><fontface="Courier New" size="2"><span style="font-size:10.0pt;font-family:"CourierNew"">printf ("code: %d\n", sqlca.sqlcode);</span></font><p class="MsoNormal"style="text-indent:.5in;text-autospace:none"><font face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"CourierNew"">printf ("state: %s\n", sqlca.sqlstate);</span></font><p class="MsoNormal"style="text-indent:.5in;text-autospace:none"><font face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"CourierNew"">printf ("warn: %s\n", sqlca.sqlwarn);</span></font><p class="MsoNormal"style="text-indent:.5in;text-autospace:none"><font face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"CourierNew"">exec sql begin work;</span></font><p class="MsoNormal" style="text-indent:.5in;text-autospace:none"><fontface="Courier New" size="2"><span style="font-size:10.0pt;font-family:"CourierNew"">exec sql commit work;</span></font><p class="MsoNormal" style="text-indent:.5in;text-autospace:none"><fontface="Courier New" size="2"><span style="font-size:10.0pt;font-family:"CourierNew"">return 0;</span></font><p class="MsoNormal" style="text-autospace:none"><fontface="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New"">}</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">When I use the 8.1.10 version, the connection works ( sqlca.sqlcode is 0, sqlca.sqlstate is 0000 and sqlca.sqlwarnis blank). But it then crashes on the “exec sql begin work” line.</span></font><p class="MsoNormal"><font face="Arial"size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">I get the following error in a window:</span></font><p class="MsoNormal"><font face="Arial" size="2"><spanstyle="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal" style="text-indent:.5in"><font face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial">RuntimeError!</span></font><p class="MsoNormal"><font face="Arial" size="2"><spanstyle="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal" style="text-indent:.5in"><font face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial">Program:C:\testSQL.exe</span></font><p class="MsoNormal"><font face="Arial" size="2"><spanstyle="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal" style="text-indent:.5in"><font face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial">Thisapplication has requested the Runtime to terminate it in an unusual way.</span></font><pclass="MsoNormal" style="text-indent:.5in"><font face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial">Pleasecontact the application’s support team for more information.</span></font><pclass="MsoNormal" style="text-indent:.5in"><font face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial"> </span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">I removed the 8.0.3 version using “remove program” from the control panel. I then went and removed myC:\Program Files\PostgreSQL\8.0 folder, just to make sure I was not including the wrong header files, linking to the wronglibraries, or calling the wrong version of ecpg.exe.</span></font><p class="MsoNormal"><font face="Arial" size="2"><spanstyle="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Thanks for any help.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">-Cheryl</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font></div>
В списке pgsql-hackers по дате отправления: