<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal>I ma using pgcluster-1.9.0rc5, and suffering for a log
problem<o:p></o:p></p>
<p class=MsoNormal>My setup is <o:p></o:p></p>
<p class=MsoNormal>Cluster 1: 172.32.1.21<o:p></o:p></p>
<p class=MsoNormal>Cluster 2: 172.32.5.50<o:p></o:p></p>
<p class=MsoNormal>Pgreplicate: 172.32.5.57<o:p></o:p></p>
<p class=MsoNormal>Pglb: 172.32.7.42<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I am suffering form frequent data not replicating
through <b>pgreplicate</b>, every time I need to restart the cluster1 DB server
with <b>–R </b> option, then goes fine.<o:p></o:p></p>
<p class=MsoNormal>For 1 or 2 days it working fine, then again stop replicating
Database. There is nothing problem in network.<o:p></o:p></p>
<p class=MsoNormal>I am pretty sure that this problem is of <b>pgreplicate.</b><o:p></o:p></p>
<p class=MsoNormal>Pl. help me to get rid of this problem.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Here is log<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>2008-06-09 11:20:42 [2285] DEBUG:setTransactionTbl():
5432@172.32.1.24 is not ready<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:42 [2285]
ERROR:replicate_packet_send_internal():setTransactionTbl failed<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:42 [2285] DEBUG:PGRis_same_host():target
host<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:42 [2285] DEBUG:start thread_send_cluster()<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:42 [2285]
DEBUG:send_replicate_packet_to_server():PQexec send :SELECT
PGR_SYSTEM_COMMAND_FUNCTION(1,'172.32.5.77',8001,8101)<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:42 [2285]
DEBUG:send_replicate_packet_to_server():PQexec returns :SYSTEM_COMMAND<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:42 [2285]
DEBUG:thread_send_cluster():return value from send_replicate_packet_to_server()
is 0<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:42 [2285]
DEBUG:thread_send_cluster():pthread_exit[0]<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:47 [2287] DEBUG:pgrecovery_loop():recovery
accept port 8101<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:47 [2287] DEBUG:read_packet():receive
packet<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:47 [2287] DEBUG:no = 1<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:47 [2287] DEBUG:max_connect = 1803<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:47 [2287] DEBUG:port = 5432<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:47 [2287] DEBUG:recoveryPort = 7001<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:47 [2287] DEBUG:hostName = comment-cluster1<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:47 [2287] DEBUG:pg_data =
/usr/local/pgsql/data<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:47 [2287] DEBUG:pgrecovery_loop():receive
packet no:1<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:47 [2287] DEBUG:pgrecovery_loop():1st master
- 0<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:47 [2287] DEBUG:pgrecovery_loop():1st
target - 0<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:47 [2287] DEBUG:first_setup_recovery():1st
setup target comment-cluster1<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:47 [2287] DEBUG:first_setup_recovery():1st
setup port 5432<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:47 [2287] DEBUG:first_setup_recovery():add
recovery target to host table<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:47 [2287]
DEBUG:PGRsend_load_balance_packet():host[<o:p></o:p></p>
<p class=MsoNormal>
$­û] port[0]<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:47 [2287] ERROR:send_packet():host[<o:p></o:p></p>
<p class=MsoNormal>
$­û] port[0]PGR_Create_Socket_Connect failed<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:47 [2287] DEBUG:first_setup_recovery():set
RECOVERY_PGDATA_REQ packet data<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:48 [2287] DEBUG:PGRsend_replicate_packet_to_server():connect
db:template1 port:5432 user:postgres host:172.32.5.57 query:VACUUM<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:48 [2287]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,0,0,0,1,1) )<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:48 [2287]
DEBUG:send_replicate_packet_to_server():PQexec send :VACUUM<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:48 [2287]
DEBUG:send_replicate_packet_to_server():PQexec returns :VACUUM<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:48 [2287] DEBUG:first_setup_recovery():send
packet to master comment-cluster2 recoveryPort 7001<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:48 [2287] DEBUG:first_setup_recovery():wait
answer from master server<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:48 [2287] DEBUG:read_packet():receive
packet<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:48 [2287] DEBUG:no = 3<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:48 [2287] DEBUG:max_connect = 1803<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:48 [2287] DEBUG:port = 5432<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:48 [2287] DEBUG:recoveryPort = 7001<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:48 [2287] DEBUG:hostName = comment-cluster2<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:48 [2287] DEBUG:pg_data =
/usr/local/pgsql/data<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:48 [2287] DEBUG:first_setup_recovery():get
answer from master:no[3]<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:48 [2287]
DEBUG:PGRsend_load_balance_packet():host[<o:p></o:p></p>
<p class=MsoNormal>
$­û] port[0]<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:48 [2287] ERROR:send_packet():host[<o:p></o:p></p>
<p class=MsoNormal>
$­û] port[0]PGR_Create_Socket_Connect failed<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:20:48 [2287]
DEBUG:pgrecovery_loop():first_setup_recovery end:0 <o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:39 [2287] DEBUG:read_packet():receive
packet<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:39 [2287] DEBUG:no = 5<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:39 [2287] DEBUG:max_connect = 1803<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:39 [2287] DEBUG:port = 5432<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:39 [2287] DEBUG:recoveryPort = 7001<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:39 [2287] DEBUG:hostName = comment-cluster2<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:39 [2287] DEBUG:pg_data =
/usr/local/pgsql/data<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:39 [2287] DEBUG:pgrecovery_loop():receive
packet no:5<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:39 [2287] DEBUG:pgrecovery_loop():2nd
master comment-cluster2 - 5432<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:39 [2287] DEBUG:pgrecovery_loop():2nd target
comment-cluster1 - 5432<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:40 [2287]
DEBUG:PGRsend_replicate_packet_to_server():connect db:template1 port:5432
user:postgres host:172.32.5.57 query:VACUUM FULL<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:40 [2287]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,0,0,0,1,1) )<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:40 [2287]
DEBUG:send_replicate_packet_to_server():PQexec send :VACUUM FULL<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:40 [2287]
DEBUG:send_replicate_packet_to_server():PQexec returns :VACUUM<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:40 [2287] DEBUG:read_packet():receive
packet<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:40 [2287] DEBUG:no = 7<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:40 [2287] DEBUG:max_connect = 1803<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:40 [2287] DEBUG:port = 5432<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:40 [2287] DEBUG:recoveryPort = 7001<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:40 [2287] DEBUG:hostName = comment-cluster2<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:40 [2287] DEBUG:pg_data =
/usr/local/pgsql/data<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:40 [2287]
DEBUG:pgrecovery_loop():second_setup_recovery end :0 <o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:43 [2287] ERROR:read_packet():unexpected
EOF<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:43 [2287] DEBUG:pgrecovery_loop():receive
packet no:8<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:43 [2287]
ERROR:À¹4ê3:unknown packet. abort to parse<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:43 [2287] DEBUG:pgrecovery_loop():recovery
accept port 8101<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:43 [2287] DEBUG:read_packet():receive
packet<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:43 [2287] DEBUG:no = 9<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:43 [2287] DEBUG:max_connect = 0<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:43 [2287] DEBUG:port = 0<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:43 [2287] DEBUG:recoveryPort = 0<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:43 [2287] DEBUG:hostName = <o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:43 [2287] DEBUG:pg_data = <o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:43 [2287] DEBUG:pgrecovery_loop():receive
packet no:9<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:43 [2287] DEBUG:pgrecovery_loop():last
master comment-cluster2 - 5432<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:43 [2287] DEBUG:pgrecovery_loop():last
target comment-cluster1 - 5432<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:43 [2287] DEBUG:PGRsend_queue():master
comment-cluster2 - 5432<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:43 [2287] DEBUG:PGRsend_queue():target
comment-cluster1 - 5432<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:43 [2287] DEBUG:PGRsend_queue():send_queue
return status 0<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:43 [2287] ERROR:send_recovery_packet:send
error: 9(Bad file descriptor)<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:21:43 [2287]
DEBUG:send_packet():PGR_Create_Socket_Connectsock[6] host[comment-cluster1]
port[7001]<o:p></o:p></p>
<p class=MsoNormal>2008-06-09 11:22:25 [2290] DEBUG:quick_exit:signo = 2<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Regards <o:p></o:p></p>
<p class=MsoNormal>Manish Singh<o:p></o:p></p>
</div>
</body>
</html>