[Pgcluster-general] pgreplicate problem

Manish Singh manish.singh at network18online.com
Mon Jun 9 06:38:02 UTC 2008 

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(): 5432 at 172.32.1.24 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgcluster-general/attachments/20080609/aab2e679/attachment-0001.html

More information about the Pgcluster-general mailing list