<br>Many thanks for quick reaction!<br><br>described behaviour does not repeat with pgcluster-1.9.0rc2. I proceed with testing :)<br><br><br><div><span class="gmail_quote">2008/2/14, At.Mitani <<a href="mailto:mitani@sraw.co.jp">mitani@sraw.co.jp</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi Filip,<br> <br><br> > First I am trying to test pgcluster in "degraded" mode:<br> <br>> 3) fire up pgbench -i (db population mode)<br> > $ pgbench -h lb_3 -p 5433 -U pgcluster -i -s100 pgbench100<br>
> 4) while pgbench is running, I put cluster_1 down with<br> > cluster_1 $ pg_ctl stop -m fast<br> ><br> > pgbench fails ( I take it as normal behaviour ) with:<br> > ...<br> > 260000 tuples done.<br>
> 270000 tuples done.<br> > server closed the connection unexpectedly<br> > This probably means the server terminated abnormally<br> > before or while processing the request.<br> > PQendcopy failed<br>
<br> <br>This is a specification of pgbench.<br> pgbench uses one session during create initial table data.<br> Therefore, initial transaction rollbacked when first session was disconnected.<br> <br><br> > But, this is not the case. First probe works:<br>
> $ psql -h lb_3 -p 5433 -U pgcluster postgres -qAtc 'select 1'<br> > 1<br> > but next probe fails:<br> > $ psql -h lb_3 -p 5433 -U pgcluster postgres -qAtc 'select 1'<br> > psql: expected authentication request from server, but received S<br>
> this is not acceptable, at least R/O traffic should work...<br> <br> <br>Yha... I also got same situation with two sets of cluster DBs.<br> But it not occured in three sets of cluster DBs.<br> It's a terrible bug!<br>
<br> I'm going to create patch tonight.<br> <br> Thank you for report us!<br> <br> Best Regards,<br> <br>--<br> At.Mitani <<a href="mailto:mitani@sraw.co.jp">mitani@sraw.co.jp</a>><br> _______________________________________________<br>
Pgcluster-general mailing list<br> <a href="mailto:Pgcluster-general@pgfoundry.org">Pgcluster-general@pgfoundry.org</a><br> <a href="http://pgfoundry.org/mailman/listinfo/pgcluster-general">http://pgfoundry.org/mailman/listinfo/pgcluster-general</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Filip Rembiałkowski