Hi! Everyone,<br>I tried to set up pgcluster and I have some problem.<br>I have two server: server1 and server2.<br>Server1 has load balance and cluster db1.<br>Server2 has cluster db2 and replicator.<br>And I am using postgres 8.1.11 and pgCluster 1.5.0.rc21<br>
The problem is that when I test the case that the server 1 is down, somtimes I can insert correctly one time into server2 but sometimes insert is done twice.<br>Each case has different stop processing message.<br>In the below, the first is the case for correct case. And second is for double inserts.<br>
Please give me any advice.<br><br>Thanks in advance.<br><br>-bash-3.00$ pg_ctl stop -D /var/lib/pgsql/data<br>LOG: received smart shutdown request<br>waiting for postmaster to shut down....lifecheck stopped<br>............FATAL: the database system is shutting down<br>
LOG: server process (PID 14659) was terminated by signal 11<br>LOG: terminating any other active server processes<br>FATAL: the database system is shutting down<br>WARNING: terminating connection because of crash of another server process<br>
DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.<br>HINT: In a moment you should be able to reconnect to the database and repeat your command.<br>
LOG: all server processes terminated; reinitializing<br>LOG: database system was interrupted at 2008-05-28 09:22:11 MDT<br>LOG: checkpoint record is at 0/4AC684<br>LOG: redo record is at 0/4AC684; undo record is at 0/0; shutdown TRUE<br>
LOG: next transaction ID: 67814; next OID: 16394<br>LOG: next MultiXactId: 1; next MultiXactOffset: 0<br>LOG: database system was not properly shut down; automatic recovery in progress<br>FATAL: the database system is shutting down<br>
FATAL: the database system is shutting down<br>FATAL: the database system is shutting down<br>FATAL: the database system is shutting down<br>LOG: redo starts at 0/4AC6C8<br>LOG: record with zero length at 0/4ADC2C<br>
LOG: redo done at 0/4ADC04<br>LOG: database system is ready<br>LOG: transaction ID wrap limit is 1073809584, limited by database "template1"<br>LOG: shutting down<br>LOG: database system is shut down<br> done<br>
postmaster stopped<br><br><br><br>-bash-3.00$ pg_ctl stop -D /var/lib/pgsql/data<br>LOG: received smart shutdown request<br>lifecheck stopped<br>waiting for postmaster to shut down...LOG: shutting down<br>.LOG: database system is shut down<br>
done<br>postmaster stopped<br>