<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<meta name="generator" content="SuSE Linux Openexchange Server 4">
<title></title>
</head>
<body>
Hi all,<BR><BR>me again, this time with another interesting problem:<BR><BR>We attempted to install a simple cluster:<BR>1 replicator<BR>2 cluster dbs<BR><BR>This behavior occured to me twice today in comparable but idfferent<BR>setups:<BR>Setup 1 included three machines, with pgcluster 1.7.0rc7 patch applied<BR>to postgresql 8.2.4. The database files and binaries were in non<BR>standard locations, we had basically no root access. System was a Debian<BR>Etch (64bit) with 16GByte main memory and two dual core (64 bit) Intel<BR>CPUs.<BR><BR>Setup 2 included two machines, with pgcluster 1.7.0rc7 patch applied to<BR>postgresql 8.2.4. The database files and binaries were in debian standrd<BR>ocations, we have root access. System is a Debian Etch (64bit) with<BR>unknown amount of main memory and (I think) 2 AMD 64 bit CPUs<BR><BR>While the databases in setup 1 had the following problem from the very<BR>beginning, I was at least able to create as well as drop a database<BR>(just for kicks) on our system 2 until it stopped working. The only<BR>difference is, setup 1 never showed me any EOF messages but simply<BR>stopped working. (I could attempt to cut the important parts from the<BR>logfiles and the tcpdumps from setup 1, if it helps.) Now here is the<BR>problem:<BR>- Start Cluster DB 1<BR>- Start Cluster DB 2<BR>- Start the pgreplicate<BR>- Start a psql connection to any one of the two dbs directly<BR>- Attempt to create a tablespace (or later on a database)<BR>- psql hangs and waits for a reply<BR>- The pgreplicate replicates the sql command<BR>- The backends do their work<BR>- You can see the results being sent to pgreplicate<BR>- pgreplicate sends the same sql command over and over again to the<BR>cluster dbs which now return errors, since the databases or tablespaces<BR>have been created before<BR>- psql still hangs and waits for a reply<BR>- If you kill pgreplicate, psql returns with "command not allowed, since<BR>cluster fell down ..."<BR>- If you check both hosts directly, you can see that the create command<BR>was successful, even the oids are the same<BR><BR>So what went wrong ? Do I have to setup rsync already ? I mean, I was<BR>just tesing it out slowly. If I understood correctly, rsync is needed<BR>once I want to restart a cluster DB in recovery mode and not a minute<BR>earlier ?<BR><BR>I have attached plenty of log and config files.<BR>If you guys are interested, I can send more logfiles and tcpdumps from<BR>the first attempt with setup 1, but the behaviour and the logfiles were<BR>basically the same. And the tcpdumps show the same messages the logfiles<BR>written by the postmaster contain.<BR><BR>As always, thanks in advance :-)<BR><BR>Regards,<BR>Holger<BR><BR>--<BR>This e-mail and any attachments is confidential and solely intended for<BR>the indicated addressee. If you are not the intended recipient or an<BR>authorized person, please note, that any form of notice, disclosure,<BR>reproduction or circulation of the contents of this mail is prohibited.<BR>In this case, please immediately inform the sender of the e-mail an<BR>destroy this e-mail. We use updated antivirus protection software. We do<BR>not accept any responsibility for damages caused anyhow by viruses.<BR>
<br><p>Diese Information ist ausschließlich für den Adressaten bestimmt und kann
vertraulich oder gesetzlich geschützte Informationen enthalten. Wenn Sie nicht
der bestimmungsgemässe Adressat sind, unterrichten Sie bitte den Absender und
vernichten Sie diese Mail.<br>
Anderen als dem bestimmungsgemässen Adressaten ist es untersagt, diese E-Mail
weiterzuleiten oder ihren Inhalt auf welche Weise auch immer zu verwenden. Wir
verwenden aktuelle Virenschutzprogramme und Content-Filter.<br>
Für Schäden, die dem Empfänger gleichwohl durch von uns zugesandte mit Viren
befallene E-Mails entstehen, schließen wir jede Haftung aus.<br>
-<br>
This e-mail and any attachments is confidential and solely intended for the
indicated addressee. If you are not the intended recipient or an authorized
person, please note, that any form of notice, disclosure, reproduction or
circulation of the contents of this mail is prohibited. In this case, please
immediately inform the sender of the e-mail an destroy this e-mail. We use
updated antivirus protection software. We do not accept any responsibility for
damages caused anyhow by viruses.<br>
-<br>
catWorkX GmbH: Sitz der Gesellschaft in Hamburg, HRB: 71494, USt-IdNr.: <br>
DE201625856, Geschäftsführung: Dipl. Kfm. Andreas Girnuweit, Dipl.-Ing. Oliver
Groht, Dr. Wolfgang Tank</p>
<br></body>
</html>