I ma using pgcluster-1.9.0rc5, and suffering for a log problem
My setup is
Cluster 1: 172.32.1.21
Cluster 2: 172.32.5.50
Pgreplicate: 172.32.5.57
Pglb: 172.32.7.42
I am suffering form frequent data not replicating through pgreplicate, every
time I need to restart the cluster1 DB server with -R option, then goes fine.
For 1 or 2 days it working fine, then again stop replicating Database. There is
nothing problem in network.
I am pretty sure that this problem is of pgreplicate.
Pl. help me to get rid of this problem.
Here is log
2008-06-09 11:20:42 [2285] DEBUG:setTransactionTbl(): [EMAIL PROTECTED] is not
ready
2008-06-09 11:20:42 [2285]
ERROR:replicate_packet_send_internal():setTransactionTbl failed
2008-06-09 11:20:42 [2285] DEBUG:PGRis_same_host():target host
2008-06-09 11:20:42 [2285] DEBUG:start thread_send_cluster()
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)
2008-06-09 11:20:42 [2285] DEBUG:send_replicate_packet_to_server():PQexec
returns :SYSTEM_COMMAND
2008-06-09 11:20:42 [2285] DEBUG:thread_send_cluster():return value from
send_replicate_packet_to_server() is 0
2008-06-09 11:20:42 [2285] DEBUG:thread_send_cluster():pthread_exit[0]
2008-06-09 11:20:47 [2287] DEBUG:pgrecovery_loop():recovery accept port 8101
2008-06-09 11:20:47 [2287] DEBUG:read_packet():receive packet
2008-06-09 11:20:47 [2287] DEBUG:no = 1
2008-06-09 11:20:47 [2287] DEBUG:max_connect = 1803
2008-06-09 11:20:47 [2287] DEBUG:port = 5432
2008-06-09 11:20:47 [2287] DEBUG:recoveryPort = 7001
2008-06-09 11:20:47 [2287] DEBUG:hostName = comment-cluster1
2008-06-09 11:20:47 [2287] DEBUG:pg_data = /usr/local/pgsql/data
2008-06-09 11:20:47 [2287] DEBUG:pgrecovery_loop():receive packet no:1
2008-06-09 11:20:47 [2287] DEBUG:pgrecovery_loop():1st master - 0
2008-06-09 11:20:47 [2287] DEBUG:pgrecovery_loop():1st target - 0
2008-06-09 11:20:47 [2287] DEBUG:first_setup_recovery():1st setup target
comment-cluster1
2008-06-09 11:20:47 [2287] DEBUG:first_setup_recovery():1st setup port 5432
2008-06-09 11:20:47 [2287] DEBUG:first_setup_recovery():add recovery target to
host table
2008-06-09 11:20:47 [2287] DEBUG:PGRsend_load_balance_packet():host[
$û] port[0]
2008-06-09 11:20:47 [2287] ERROR:send_packet():host[
$û]
port[0]PGR_Create_Socket_Connect failed
2008-06-09 11:20:47 [2287] DEBUG:first_setup_recovery():set RECOVERY_PGDATA_REQ
packet data
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
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) )
2008-06-09 11:20:48 [2287] DEBUG:send_replicate_packet_to_server():PQexec send
:VACUUM
2008-06-09 11:20:48 [2287] DEBUG:send_replicate_packet_to_server():PQexec
returns :VACUUM
2008-06-09 11:20:48 [2287] DEBUG:first_setup_recovery():send packet to master
comment-cluster2 recoveryPort 7001
2008-06-09 11:20:48 [2287] DEBUG:first_setup_recovery():wait answer from master
server
2008-06-09 11:20:48 [2287] DEBUG:read_packet():receive packet
2008-06-09 11:20:48 [2287] DEBUG:no = 3
2008-06-09 11:20:48 [2287] DEBUG:max_connect = 1803
2008-06-09 11:20:48 [2287] DEBUG:port = 5432
2008-06-09 11:20:48 [2287] DEBUG:recoveryPort = 7001
2008-06-09 11:20:48 [2287] DEBUG:hostName = comment-cluster2
2008-06-09 11:20:48 [2287] DEBUG:pg_data = /usr/local/pgsql/data
2008-06-09 11:20:48 [2287] DEBUG:first_setup_recovery():get answer from
master:no[3]
2008-06-09 11:20:48 [2287] DEBUG:PGRsend_load_balance_packet():host[
$û] port[0]
2008-06-09 11:20:48 [2287] ERROR:send_packet():host[
$û]
port[0]PGR_Create_Socket_Connect failed
2008-06-09 11:20:48 [2287] DEBUG:pgrecovery_loop():first_setup_recovery end:0
2008-06-09 11:21:39 [2287] DEBUG:read_packet():receive packet
2008-06-09 11:21:39 [2287] DEBUG:no = 5
2008-06-09 11:21:39 [2287] DEBUG:max_connect = 1803
2008-06-09 11:21:39 [2287] DEBUG:port = 5432
2008-06-09 11:21:39 [2287] DEBUG:recoveryPort = 7001
2008-06-09 11:21:39 [2287] DEBUG:hostName = comment-cluster2
2008-06-09 11:21:39 [2287] DEBUG:pg_data = /usr/local/pgsql/data
2008-06-09 11:21:39 [2287] DEBUG:pgrecovery_loop():receive packet no:5
2008-06-09 11:21:39 [2287] DEBUG:pgrecovery_loop():2nd master comment-cluster2
- 5432
2008-06-09 11:21:39 [2287] DEBUG:pgrecovery_loop():2nd target comment-cluster1
- 5432
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
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) )
2008-06-09 11:21:40 [2287] DEBUG:send_replicate_packet_to_server():PQexec send
:VACUUM FULL
2008-06-09 11:21:40 [2287] DEBUG:send_replicate_packet_to_server():PQexec
returns :VACUUM
2008-06-09 11:21:40 [2287] DEBUG:read_packet():receive packet
2008-06-09 11:21:40 [2287] DEBUG:no = 7
2008-06-09 11:21:40 [2287] DEBUG:max_connect = 1803
2008-06-09 11:21:40 [2287] DEBUG:port = 5432
2008-06-09 11:21:40 [2287] DEBUG:recoveryPort = 7001
2008-06-09 11:21:40 [2287] DEBUG:hostName = comment-cluster2
2008-06-09 11:21:40 [2287] DEBUG:pg_data = /usr/local/pgsql/data
2008-06-09 11:21:40 [2287] DEBUG:pgrecovery_loop():second_setup_recovery end :0
2008-06-09 11:21:43 [2287] ERROR:read_packet():unexpected EOF
2008-06-09 11:21:43 [2287] DEBUG:pgrecovery_loop():receive packet no:8
2008-06-09 11:21:43 [2287] ERROR:À¹4ê3:unknown packet. abort to parse
2008-06-09 11:21:43 [2287] DEBUG:pgrecovery_loop():recovery accept port 8101
2008-06-09 11:21:43 [2287] DEBUG:read_packet():receive packet
2008-06-09 11:21:43 [2287] DEBUG:no = 9
2008-06-09 11:21:43 [2287] DEBUG:max_connect = 0
2008-06-09 11:21:43 [2287] DEBUG:port = 0
2008-06-09 11:21:43 [2287] DEBUG:recoveryPort = 0
2008-06-09 11:21:43 [2287] DEBUG:hostName =
2008-06-09 11:21:43 [2287] DEBUG:pg_data =
2008-06-09 11:21:43 [2287] DEBUG:pgrecovery_loop():receive packet no:9
2008-06-09 11:21:43 [2287] DEBUG:pgrecovery_loop():last master comment-cluster2
- 5432
2008-06-09 11:21:43 [2287] DEBUG:pgrecovery_loop():last target comment-cluster1
- 5432
2008-06-09 11:21:43 [2287] DEBUG:PGRsend_queue():master comment-cluster2 - 5432
2008-06-09 11:21:43 [2287] DEBUG:PGRsend_queue():target comment-cluster1 - 5432
2008-06-09 11:21:43 [2287] DEBUG:PGRsend_queue():send_queue return status 0
2008-06-09 11:21:43 [2287] ERROR:send_recovery_packet:send error: 9(Bad file
descriptor)
2008-06-09 11:21:43 [2287] DEBUG:send_packet():PGR_Create_Socket_Connectsock[6]
host[comment-cluster1] port[7001]
2008-06-09 11:22:25 [2290] DEBUG:quick_exit:signo = 2
Regards
Manish Singh
_______________________________________________
Pgcluster-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgcluster-general
