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 по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: max_prepared_transactions default ... why 5?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: max_prepared_transactions default ... why 5?