No connection to Server - Mailing list pgsql-bugs

<div class="Section1"><p class="MsoNormal"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:"CourierNew";mso-ansi-language:EN-GB"> </span></font><p class="MsoNormal"><font
face="CourierNew" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB">Name:<spanstyle="mso-tab-count:3">             </span><span style="mso-tab-count:1">     
</span>DennisHuebner</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:"CourierNew";mso-ansi-language:EN-GB">Email:<span
style="mso-tab-count:3">                 </span><a href="mailto:huebner@te-systems.de"
title="mailto:huebner@te-systems.de">huebner@te-systems.de</a></span></font><pclass="MsoNormal"><font face="Courier
New"size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier New";mso-ansi-language:EN-GB">PostgreSQL
version:<spanstyle="mso-tab-count:1">     </span>8.0</span></font><p class="MsoNormal"><font face="Courier New"
size="2"><spanlang="EN-GB" style="font-size:10.0pt;font-family:"Courier New";mso-ansi-language:EN-GB">Operation
system:<spanstyle="mso-tab-count:1"> </span><span style="mso-tab-count:1">      </span>Windows XP
Professional</span></font><pclass="MsoNormal"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:"CourierNew";mso-ansi-language:EN-GB">Short description:<span
style="mso-tab-count:1">     </span><span style="mso-tab-count: 
1">      </span>No connection to Server</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
lang="EN-GB"style="font-size:10.0pt;font-family:"Courier New";mso-ansi-language:EN-GB"> </span></font><p
class="MsoNormal"><fontface="Courier New" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB"> </span></font><pclass="MsoNormal"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:"CourierNew";mso-ansi-language:EN-GB">Hi there,</span></font><p
class="MsoNormal"><fontface="Courier New" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB"> </span></font><pclass="MsoNormal"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:"CourierNew";mso-ansi-language:EN-GB">I have trouble with newer versions of
postgresql.</span></font><pclass="MsoNormal"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:"CourierNew";mso-ansi-language:EN-GB"> </span></font><p class="MsoNormal"><font
face="CourierNew" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB">Onevery version of postgresql the only thing I changed at the 'postgresql.conf' is
'max_connections= 500'.</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:"CourierNew";mso-ansi-language:EN-GB">Otherwise I used default
installation.</span></font><pclass="MsoNormal"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:"CourierNew";mso-ansi-language:EN-GB"> </span></font><p class="MsoNormal"><font
face="CourierNew" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB">I'musing a telephony-system with 30 lines and I generate calls to this
system.</span></font><pclass="MsoNormal"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:"CourierNew";mso-ansi-language:EN-GB"> </span></font><p class="MsoNormal"><font
face="CourierNew" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB">Nowthe system looks into the postgres-database if the calling number is present and after
thatreceives the calls.</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:"CourierNew";mso-ansi-language:EN-GB"> </span></font><p class="MsoNormal"><font
face="CourierNew" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB">Withevery older postgres-version up to 8.0.0-rc3 (this is the last working version)
everythingis all right.</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:"CourierNew";mso-ansi-language:EN-GB"> </span></font><p class="MsoNormal"><font
face="CourierNew" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB">Thedatabase-system checks for the user and gives back the results.</span></font><p
class="MsoNormal"><fontface="Courier New" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB">Thisworks on all 30 lines parallel.</span></font><p class="MsoNormal"><font face="Courier
New"size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB"> </span></font><pclass="MsoNormal"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:"CourierNew";mso-ansi-language:EN-GB">On newer versions (higher than rc3) the
connectionswere refused or could not be established by the server.</span></font><p class="MsoNormal"><font
face="CourierNew" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB"> </span></font><pclass="MsoNormal"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:"CourierNew";mso-ansi-language:EN-GB">Here is my pg_log file:</span></font><p
class="MsoNormal"><fontface="Courier New" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB"> </span></font><pclass="MsoNormal"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:"CourierNew";mso-ansi-language:EN-GB">2005-02-02 14:28:55 LOG:<span
style="mso-spacerun:yes"> </span>database system was shut down at 2005-02-02 14:28:54 W. Europe Standard
Time</span></font><pclass="MsoNormal"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:"CourierNew";mso-ansi-language:EN-GB">2005-02-02 14:28:55 LOG:<span
style="mso-spacerun:yes"> </span>checkpoint record is at 0/CB9A70</span></font><p class="MsoNormal"><font face="Courier
New"size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier New";mso-ansi-language:EN-GB">2005-02-02
14:28:55LOG:<span style="mso-spacerun:yes">  </span>redo record is at 0/CB9A70; undo record is at 0/0; shutdown
TRUE</span></font><pclass="MsoNormal"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:"CourierNew";mso-ansi-language:EN-GB">2005-02-02 14:28:55 LOG:<span
style="mso-spacerun:yes"> </span>next transaction ID: 1548; next OID: 17948</span></font><p class="MsoNormal"><font
face="CourierNew" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB">2005-02-0214:28:56 LOG:<span style="mso-spacerun:yes">  </span>database system is
ready</span></font><pclass="MsoNormal"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:"CourierNew";mso-ansi-language:EN-GB">2005-02-02 14:30:45 LOG:<span
style="mso-spacerun:yes"> </span>server process (PID 5972) exited with unexpected status 128</span></font><p
class="MsoNormal"><fontface="Courier New" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB">2005-02-0214:30:45 LOG:<span style="mso-spacerun:yes">  </span>terminating any other
activeserver processes</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:"CourierNew";mso-ansi-language:EN-GB">2005-02-02 14:30:45 WARNING:<span
style="mso-spacerun:yes"> </span>terminating connection because of crash of another server process</span></font><p
class="MsoNormal"><fontface="Courier New" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB">2005-02-0214:30:45 DETAIL:<span style="mso-spacerun:yes">  </span>The postmaster has
commandedthis server process to roll back the current transaction and exit, because another server process exited
abnormallyand possibly corrupted shared memory.</span></font><p class="MsoNormal"><font face="Courier New"
size="2"><spanlang="EN-GB" style="font-size:10.0pt;font-family:"Courier New";mso-ansi-language:EN-GB">2005-02-02
14:30:45HINT:<span style="mso-spacerun:yes">  </span>In a moment you should be able to reconnect to the database and
repeatyour command.</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:"CourierNew";mso-ansi-language:EN-GB">.</span></font><p class="MsoNormal"><font
face="CourierNew" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB">Severaltimes...</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
lang="EN-GB"style="font-size:10.0pt;font-family:"Courier New";mso-ansi-language:EN-GB">.</span></font><p
class="MsoNormal"><fontface="Courier New" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB">2005-02-0214:30:45 WARNING:<span style="mso-spacerun:yes">  </span>terminating connection
becauseof crash of another server process</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
lang="EN-GB"style="font-size:10.0pt;font-family:"Courier New";mso-ansi-language:EN-GB">2005-02-02 14:30:45 DETAIL:<span
style="mso-spacerun:yes"> </span>The postmaster has commanded this server process to roll back the current transaction
andexit, because another server process exited abnormally and possibly corrupted shared memory.</span></font><p
class="MsoNormal"><fontface="Courier New" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB">2005-02-0214:30:45 HINT:<span style="mso-spacerun:yes">  </span>In a moment you should be
ableto reconnect to the database and repeat your command.</span></font><p class="MsoNormal"><font face="Courier New"
size="2"><spanlang="EN-GB" style="font-size:10.0pt;font-family:"Courier New";mso-ansi-language:EN-GB">2005-02-02
14:30:45LOG:<span style="mso-spacerun:yes">  </span>all server processes terminated; reinitializing</span></font><p
class="MsoNormal"><fontface="Courier New" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB">2005-02-0214:30:45 LOG:<span style="mso-spacerun:yes">  </span>database system was
interruptedat 2005-02-02 14:28:56 W. Europe Standard Time</span></font><p class="MsoNormal"><font face="Courier New"
size="2"><spanlang="EN-GB" style="font-size:10.0pt;font-family:"Courier New";mso-ansi-language:EN-GB">2005-02-02
14:30:45LOG:<span style="mso-spacerun:yes">  </span>checkpoint record is at 0/CB9A70</span></font><p
class="MsoNormal"><fontface="Courier New" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB">2005-02-0214:30:45 LOG:<span style="mso-spacerun:yes">  </span>redo record is at
0/CB9A70;undo record is at 0/0; shutdown TRUE</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
lang="EN-GB"style="font-size:10.0pt;font-family:"Courier New";mso-ansi-language:EN-GB">2005-02-02 14:30:45 LOG:<span
style="mso-spacerun:yes"> </span>next transaction ID: 1548; next OID: 17948</span></font><p class="MsoNormal"><font
face="CourierNew" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB">2005-02-0214:30:45 LOG:<span style="mso-spacerun:yes">  </span>database system was not
properlyshut down; automatic recovery in progress</span></font><p class="MsoNormal"><font face="Courier New"
size="2"><spanlang="EN-GB" style="font-size:10.0pt;font-family:"Courier New";mso-ansi-language:EN-GB">2005-02-02
14:30:45LOG:<span style="mso-spacerun:yes">  </span>record with zero length at 0/CB9AB0</span></font><p
class="MsoNormal"><fontface="Courier New" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB">2005-02-0214:30:45 LOG:<span style="mso-spacerun:yes">  </span>redo is not
required</span></font><pclass="MsoNormal"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:"CourierNew";mso-ansi-language:EN-GB">2005-02-02 14:30:45 FATAL:<span
style="mso-spacerun:yes"> </span>the database system is starting up</span></font><p class="MsoNormal"><font
face="CourierNew" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB">2005-02-0214:30:45 LOG:<span style="mso-spacerun:yes">  </span>database system is
ready</span></font><pclass="MsoNormal"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:"CourierNew";mso-ansi-language:EN-GB"> </span></font><p class="MsoNormal"><font
face="CourierNew" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB"> </span></font><pclass="MsoNormal"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:"CourierNew";mso-ansi-language:EN-GB">I hope you can help me.</span></font><p
class="MsoNormal"><fontface="Courier New" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB"> </span></font><pclass="MsoNormal"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:"CourierNew";mso-ansi-language:EN-GB"> </span></font><p class="MsoNormal"><font
face="CourierNew" size="2"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier
New";mso-ansi-language:EN-GB;
mso-no-proof:yes">Kind regards,<br /><br /> Dennis Huebner<br /><br />
************************************************<br/> TE-SYSTEMS GmbH - competence in e-communications<br />
Max-von-Laue-Weg19<span style="mso-spacerun:yes">         </span>fon +49 5361 895-120<br /> 38448 Wolfsburg<span
style="mso-spacerun:yes">            </span>fax +49 5361 895-999<br /><a href="http://www.te-systems.de/"
title="http://www.te-systems.de/">http://www.te-systems.de</a><spanstyle="mso-spacerun:yes">   </span><a
href="mailto:huebner@te-systems.de"title="mailto:huebner@te-systems.de">huebner@te-systems.de<br
title="mailto:huebner@te-systems.de"/><br title="mailto:huebner@te-systems.de" /></a>Visit also our website: <a
href="http://www.xcapi.de/"title="http://www.xcapi.de/">www.xcapi.de</a></span></font><font face="Courier New"
size="2"><spanlang="EN-GB" style="font-size:10.0pt;font-family:"Courier New"; 
mso-ansi-language:EN-GB"></span></font></div>