[Pgcluster-general] about PGCluster deal with Chinese question:
Sun.betty
alanxzq at yahoo.com.cn
Fri Jan 19 10:34:05 UTC 2007
Hi! everybody here!
How are you!
test PGCluster deal with Chinese have question,Please see:
have two nodes:
node1 :hostname : cluster1
node2 :hostname : cluster2
create db:
createdb -E EUC_CN post_tc
createlang -d post_tc plpgsql
use JDBCBench.java deal with English is OK!
but use JDBCBench.java deal with Chinese will appear:
1)
if exec JDBCBench.java at node1, data was inserted in post_tc of node1.
but data wasn't inserted (rsync) post_tc of node2.
2)
if exec JDBCBench.java at node2, data was inserted in post_tc of node2.
but data wasn't inserted (rsync) post_tc of node1.
Please help me look at it!maybe it is only a configure question !
if not, hope can upgrade pgcluster and resolve this question.
------------------------------------------------------------------------
My configure is:
$ more cluster.conf (on node1)
<Replicate_Server_Info>
<Host_Name> cluster1 </Host_Name>
<Port> 8001 </Port>
<Recovery_Port> 8101 </Recovery_Port>
</Replicate_Server_Info>
#-------------------------------------------------------------
<Host_Name> cluster1 </Host_Name>
<Recovery_Port> 7001 </Recovery_Port>
<Rsync_Path> /usr/bin/rsync </Rsync_Path>
<Rsync_Option> /usr/bin/ssh -2 </Rsync_Option>
<Rsync_Compress> yes </Rsync_Compress>
<Pg_Dump_Path> /u1/pgsql/bin/pg_dump </Pg_Dump_Path>
<When_Stand_Alone> real_only </When_Stand_Alone>
<Replication_Timeout> 1min </Replication_Timeout>
#-------------------------------------------------------------
$
$ more cluster.conf (on node2)
<Replicate_Server_Info>
<Host_Name> cluster1 </Host_Name>
<Port> 8001 </Port>
<Recovery_Port> 8101 </Recovery_Port>
</Replicate_Server_Info>
#-------------------------------------------------------------
<Host_Name> cluster2 </Host_Name>
<Recovery_Port> 7001 </Recovery_Port>
<Rsync_Path> /usr/bin/rsync </Rsync_Path>
<Rsync_Option> /usr/bin/ssh -2 </Rsync_Option>
<Rsync_Compress> yes </Rsync_Compress>
<Pg_Dump_Path> /u1/pgsql/bin/pg_dump </Pg_Dump_Path>
<When_Stand_Alone> read_only </When_Stand_Alone>
<Replication_Timeout> 1min </Replication_Timeout>
#-------------------------------------------------------------
$ more pgreplicate.conf
<Cluster_Server_Info>
<Host_Name> cluster1 </Host_Name>
<Port> 5432 </Port>
<Recovery_Port> 7001 </Recovery_Port>
</Cluster_Server_Info>
<Cluster_Server_Info>
<Host_Name> cluster2 </Host_Name>
<Port> 5432 </Port>
<Recovery_Port> 7001 </Recovery_Port>
</Cluster_Server_Info>
#-------------------------------------------------------------
<Host_Name> cluster1 </Host_Name>
<Replication_Port> 8001 </Replication_Port>
<Recovery_Port> 8101 </Recovery_Port>
<RLOG_Port> 8301 </RLOG_Port>
<Response_Mode> normal </Response_Mode>
<Use_Replication_Log> no </Use_Replication_Log>
<Replication_Timeout> 1min </Replication_Timeout>
#-------------------------------------------------------------
<Log_File_Info>
<File_Name> /tmp/pgreplicate.log </File_Name>
<File_Size> 5M </File_Size>
<Rotate> 3 </Rotate>
</Log_File_Info>
$
$ more /etc/hosts
127.0.0.1 localhost
10.10.10.22 cluster2
10.10.10.21 cluster1
$
-----------------------------------------------------------------------------------------------
replication server 's log is:
2007-01-19 18:12:43 [13454] DEBUG:start thread_send_cluster()2007-01-19 18:12:43 [13454] DEBUG:
source host
2007-01-19 18:12:43 [13454] DEBUG:thread_send_cluster():return value from send_replicate_packet_to_server() is 0
2007-01-19 18:12:43 [13454] DEBUG:thread_send_cluster():pthread_exit[0]
2007-01-19 18:12:43 [13454] DEBUG:PGRreturn_result():PGRreturn_result[8,278,0,1]
2007-01-19 18:12:43 [13454] DEBUG:PGRreturn_result():128 send
2007-01-19 18:12:43 [13454] DEBUG:end thread_send_source()
2007-01-19 18:12:43 [13454] DEBUG:sem_unlock[1]
2007-01-19 18:12:43 [13454] DEBUG:PGRread_packet():PG_read_query returns .
2007-01-19 18:12:43 [13454] DEBUG:PGRreturn_result():PGRreturn_result[1]
2007-01-19 18:12:43 [13454] DEBUG:PGRreturn_result():128 send
2007-01-19 18:12:43 [13454] DEBUG:PGRread_packet():PG_read_query returns .
2007-01-19 18:12:43 [13454] DEBUG:PGRdo_replicate():query ::
2007-01-19 18:12:43 [13454] DEBUG:cmdSts=P
2007-01-19 18:12:43 [13454] DEBUG:cmdType=E
2007-01-19 18:12:43 [13454] DEBUG:rlog=0
2007-01-19 18:12:43 [13454] DEBUG:port=5432
2007-01-19 18:12:43 [13454] DEBUG:pid=5042
2007-01-19 18:12:43 [13454] DEBUG:from_host=10.10.10.22
2007-01-19 18:12:43 [13454] DEBUG:dbName=post_tc
2007-01-19 18:12:43 [13454] DEBUG:userName=test
2007-01-19 18:12:43 [13454] DEBUG:recieve sec=1169201563
2007-01-19 18:12:43 [13454] DEBUG:recieve usec=125481
2007-01-19 18:12:43 [13454] DEBUG:query_size=6
2007-01-19 18:12:43 [13454] DEBUG:request_id=4
2007-01-19 18:12:43 [13454] DEBUG:replicate_id=0
2007-01-19 18:12:43 [13454] DEBUG:recovery_status=0
2007-01-19 18:12:43 [13454] DEBUG:sem_lock [1] req
2007-01-19 18:12:43 [13454] DEBUG:sem_lock [1] got it
2007-01-19 18:12:43 [13454] DEBUG:start thread_send_cluster()
2007-01-19 18:12:43 [13454] DEBUG:source host
2007-01-19 18:12:43 [13454] DEBUG:thread_send_cluster():return value from send_replicate_packet_to_server() is 0
2007-01-19 18:12:43 [13454] DEBUG:thread_send_cluster():pthread_exit[0]
2007-01-19 18:12:43 [13454] DEBUG:PGRreturn_result():PGRreturn_result[8,279,0,1]
2007-01-19 18:12:43 [13454] DEBUG:PGRreturn_result():128 send
2007-01-19 18:12:43 [13454] DEBUG:end thread_send_source()
2007-01-19 18:12:43 [13454] DEBUG:sem_unlock[1]
2007-01-19 18:12:43 [13454] DEBUG:PGRread_packet():PG_read_query returns .
2007-01-19 18:12:43 [13454] DEBUG:PGRreturn_result():PGRreturn_result[1]
2007-01-19 18:12:43 [13454] DEBUG:PGRreturn_result():128 send
2007-01-19 18:12:43 [13454] DEBUG:PGRread_packet():PG_read_query returns .
2007-01-19 18:12:43 [13454] DEBUG:PGRdo_replicate():query ::
2007-01-19 18:12:43 [13454] DEBUG:cmdSts=P
2007-01-19 18:12:43 [13454] DEBUG:cmdType=S
2007-01-19 18:12:43 [13454] DEBUG:rlog=0
2007-01-19 18:12:43 [13454] DEBUG:port=5432
2007-01-19 18:12:43 [13454] DEBUG:pid=5042
2007-01-19 18:12:43 [13454] DEBUG:from_host=10.10.10.22
2007-01-19 18:12:43 [13454] DEBUG:dbName=post_tc
2007-01-19 18:12:43 [13454] DEBUG:userName=test
2007-01-19 18:12:43 [13454] DEBUG:recieve sec=1169201563
2007-01-19 18:12:43 [13454] DEBUG:recieve usec=129463
2007-01-19 18:12:43 [13454] DEBUG:query_size=1
2007-01-19 18:12:43 [13454] DEBUG:request_id=5
2007-01-19 18:12:43 [13454] DEBUG:replicate_id=0
2007-01-19 18:12:43 [13454] DEBUG:recovery_status=0
2007-01-19 18:12:43 [13454] DEBUG:sem_lock [1] req
2007-01-19 18:12:43 [13454] DEBUG:sem_lock [1] got it
2007-01-19 18:12:43 [13454] DEBUG:start thread_send_cluster()
2007-01-19 18:12:43 [13454] DEBUG:source host
2007-01-19 18:12:43 [13454] DEBUG:thread_send_cluster():return value from send_replicate_packet_to_server() is 0
2007-01-19 18:12:43 [13454] DEBUG:thread_send_cluster():pthread_exit[0]
2007-01-19 18:12:43 [13454] DEBUG:PGRreturn_result():PGRreturn_result[3,1169201563,129463,28373,1,280]
2007-01-19 18:12:43 [13454] DEBUG:PGRreturn_result():128 send
2007-01-19 18:12:43 [13454] DEBUG:end thread_send_source()
2007-01-19 18:12:43 [13454] DEBUG:sem_unlock[1]
2007-01-19 18:12:43 [13454] DEBUG:PGRread_packet():PG_read_query returns .
2007-01-19 18:12:43 [13456] DEBUG:PGRread_packet():PG_read_query returns .
2007-01-19 18:12:43 [13456] DEBUG:PGRreturn_result():PGRreturn_result[1]
2007-01-19 18:12:43 [13456] DEBUG:PGRreturn_result():128 send
2007-01-19 18:12:43 [13456] DEBUG:PGRread_packet():PG_read_query returns .
2007-01-19 18:12:43 [13456] DEBUG:PGRdo_replicate():query ::
2007-01-19 18:12:43 [13456] DEBUG:cmdSts=P
2007-01-19 18:12:43 [13456] DEBUG:cmdType=B
2007-01-19 18:12:43 [13456] DEBUG:rlog=0
2007-01-19 18:12:43 [13456] DEBUG:port=5432
2007-01-19 18:12:43 [13456] DEBUG:pid=5043
2007-01-19 18:12:43 [13456] DEBUG:from_host=10.10.10.22
2007-01-19 18:12:43 [13454] DEBUG:replicate_loop():session closed
2007-01-19 18:12:43 [13456] DEBUG:dbName=post_tc
2007-01-19 18:12:43 [13456] DEBUG:userName=test
2007-01-19 18:12:43 [13456] DEBUG:recieve sec=1169201563
2007-01-19 18:12:43 [13456] DEBUG:recieve usec=140736
2007-01-19 18:12:43 [13454] DEBUG:PGRdo_replicate():query :: PGR_CLOSE_CONNECTION
2007-01-19 18:12:43 [13456] DEBUG:query_size=9
2007-01-19 18:12:43 [13454] DEBUG:cmdSts=O
2007-01-19 18:12:43 [13456] DEBUG:request_id=2
2007-01-19 18:12:43 [13454] DEBUG:cmdType=x
2007-01-19 18:12:43 [13456] DEBUG:replicate_id=0
2007-01-19 18:12:43 [13454] DEBUG:rlog=0
2007-01-19 18:12:43 [13456] DEBUG:recovery_status=0
2007-01-19 18:12:43 [13454] DEBUG:port=5432
2007-01-19 18:12:43 [13456] DEBUG:sem_lock [1] req
2007-01-19 18:12:43 [13454] DEBUG:pid=5042
2007-01-19 18:12:43 [13456] DEBUG:sem_lock [1] got it
2007-01-19 18:12:43 [13454] DEBUG:from_host=10.10.10.22
2007-01-19 18:12:43 [13454] DEBUG:dbName=post_tc
2007-01-19 18:12:43 [13454] DEBUG:userName=test
2007-01-19 18:12:43 [13454] DEBUG:recieve sec=1169201563
2007-01-19 18:12:43 [13456] DEBUG:start thread_send_cluster()
2007-01-19 18:12:43 [13454] DEBUG:recieve usec=141259
2007-01-19 18:12:43 [13456] DEBUG:source host
2007-01-19 18:12:43 [13454] DEBUG:query_size=21
2007-01-19 18:12:43 [13456] DEBUG:thread_send_cluster():return value from send_replicate_packet_to_server() is 0
2007-01-19 18:12:43 [13454] DEBUG:request_id=1
2007-01-19 18:12:43 [13456] DEBUG:thread_send_cluster():pthread_exit[0]
2007-01-19 18:12:43 [13454] DEBUG:replicate_id=0
2007-01-19 18:12:43 [13454] DEBUG:recovery_status=0
2007-01-19 18:12:43 [13454] DEBUG:query=PGR_CLOSE_CONNECTION
2007-01-19 18:12:43 [13454] DEBUG:sem_lock [1] req
2007-01-19 18:12:43 [13456] DEBUG:PGRreturn_result():PGRreturn_result[3,1169201563,140736,28374,1,281]
2007-01-19 18:12:43 [13456] DEBUG:PGRreturn_result():128 send
2007-01-19 18:12:43 [13456] DEBUG:end thread_send_source()
2007-01-19 18:12:43 [13456] DEBUG:sem_unlock[1]
2007-01-19 18:12:43 [13454] DEBUG:sem_lock [1] got it
2007-01-19 18:12:43 [13454] DEBUG:pgr_createConn():PQsetdbLogin host[cluster1] port[5432] db[post_tc] user[test]
2007-01-19 18:12:43 [13456] DEBUG:PGRread_packet():PG_read_query returns P.
2007-01-19 18:12:43 [13456] DEBUG:PGRreturn_result():PGRreturn_result[1]
2007-01-19 18:12:43 [13456] DEBUG:PGRreturn_result():128 send
2007-01-19 18:12:43 [13456] DEBUG:PGRread_packet():PG_read_query returns P.
2007-01-19 18:12:43 [13456] DEBUG:PGRdo_replicate():query :: P
2007-01-19 18:12:43 [13456] DEBUG:cmdSts=P
2007-01-19 18:12:43 [13456] DEBUG:cmdType=D
2007-01-19 18:12:43 [13456] DEBUG:rlog=0
2007-01-19 18:12:43 [13456] DEBUG:port=5432
2007-01-19 18:12:43 [13456] DEBUG:pid=5043
2007-01-19 18:12:43 [13456] DEBUG:from_host=10.10.10.22
2007-01-19 18:12:43 [13456] DEBUG:dbName=post_tc
2007-01-19 18:12:43 [13456] DEBUG:userName=test
2007-01-19 18:12:43 [13456] DEBUG:recieve sec=1169201563
2007-01-19 18:12:43 [13456] DEBUG:recieve usec=143450
2007-01-19 18:12:43 [13456] DEBUG:query_size=3
2007-01-19 18:12:43 [13456] DEBUG:request_id=3
2007-01-19 18:12:43 [13456] DEBUG:replicate_id=0
2007-01-19 18:12:43 [13456] DEBUG:recovery_status=0
2007-01-19 18:12:43 [13456] DEBUG:sem_lock [1] req
2007-01-19 18:12:43 [13454] DEBUG:pgr_createConn():PQsetdbLogin ok!!
2007-01-19 18:12:43 [13454] DEBUG:replicate_packet_send_internal():connect db:post_tc port:5432 user:test host:cluster1 query:PGR_CLOSE_CONNECTION
2007-01-19 18:12:43 [13454] DEBUG:start thread_send_cluster()
2007-01-19 18:12:43 [13454] DEBUG:source host
2007-01-19 18:12:43 [13454] DEBUG:PGR_Notice_Abort():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(7))
2007-01-19 18:12:43 [13454] DEBUG:sem_unlock[1]
2007-01-19 18:12:43 [13456] DEBUG:sem_lock [1] got it
2007-01-19 18:12:43 [13454] DEBUG:replicate_loop():replicate loop exit
2007-01-19 18:12:43 [13456] DEBUG:start thread_send_cluster()
2007-01-19 18:12:43 [13456] DEBUG:source host
2007-01-19 18:12:43 [13456] DEBUG:thread_send_cluster():return value from send_replicate_packet_to_server() is 0
2007-01-19 18:12:43 [13456] DEBUG:thread_send_cluster():pthread_exit[0]
2007-01-19 18:12:43 [13456] DEBUG:PGRreturn_result():PGRreturn_result[8,283,0,1]
2007-01-19 18:12:43 [13456] DEBUG:PGRreturn_result():128 send
2007-01-19 18:12:43 [13456] DEBUG:end thread_send_source()
2007-01-19 18:12:43 [13456] DEBUG:sem_unlock[1]
2007-01-19 18:12:43 [13456] DEBUG:PGRread_packet():PG_read_query returns .
2007-01-19 18:12:43 [13456] DEBUG:PGRreturn_result():PGRreturn_result[1]
2007-01-19 18:12:43 [13456] DEBUG:PGRreturn_result():128 send
2007-01-19 18:12:43 [13456] DEBUG:PGRread_packet():PG_read_query returns .
2007-01-19 18:12:43 [13456] DEBUG:PGRdo_replicate():query ::
2007-01-19 18:12:43 [13456] DEBUG:cmdSts=P
2007-01-19 18:12:43 [13456] DEBUG:cmdType=E
2007-01-19 18:12:43 [13456] DEBUG:rlog=0
2007-01-19 18:12:43 [13456] DEBUG:port=5432
2007-01-19 18:12:43 [13456] DEBUG:pid=5043
2007-01-19 18:12:43 [13456] DEBUG:from_host=10.10.10.22
2007-01-19 18:12:43 [13456] DEBUG:dbName=post_tc
2007-01-19 18:12:43 [13456] DEBUG:userName=test
2007-01-19 18:12:43 [13456] DEBUG:recieve sec=1169201563
2007-01-19 18:12:43 [13456] DEBUG:recieve usec=157351
2007-01-19 18:12:43 [13456] DEBUG:query_size=6
2007-01-19 18:12:43 [13456] DEBUG:request_id=4
2007-01-19 18:12:43 [13456] DEBUG:replicate_id=0
2007-01-19 18:12:43 [13456] DEBUG:recovery_status=0
2007-01-19 18:12:43 [13456] DEBUG:sem_lock [1] req
2007-01-19 18:12:43 [13456] DEBUG:sem_lock [1] got it
2007-01-19 18:12:43 [13456] DEBUG:start thread_send_cluster()
2007-01-19 18:12:43 [13456] DEBUG:source host
2007-01-19 18:12:43 [13456] DEBUG:thread_send_cluster():return value from send_replicate_packet_to_server() is 0
2007-01-19 18:12:43 [13456] DEBUG:thread_send_cluster():pthread_exit[0]
2007-01-19 18:12:43 [13456] DEBUG:PGRreturn_result():PGRreturn_result[8,284,0,1]
2007-01-19 18:12:43 [13456] DEBUG:PGRreturn_result():128 send
2007-01-19 18:12:43 [13456] DEBUG:end thread_send_source()
2007-01-19 18:12:43 [13456] DEBUG:sem_unlock[1]
2007-01-19 18:12:43 [13456] DEBUG:PGRread_packet():PG_read_query returns .
2007-01-19 18:12:43 [13456] DEBUG:PGRreturn_result():PGRreturn_result[1]
2007-01-19 18:12:43 [13456] DEBUG:PGRreturn_result():128 send
2007-01-19 18:12:43 [13456] DEBUG:PGRread_packet():PG_read_query returns .
2007-01-19 18:12:43 [13456] DEBUG:PGRdo_replicate():query ::
2007-01-19 18:12:43 [13456] DEBUG:cmdSts=P
2007-01-19 18:12:43 [13456] DEBUG:cmdType=S
2007-01-19 18:12:43 [13456] DEBUG:rlog=0
2007-01-19 18:12:43 [13456] DEBUG:port=5432
2007-01-19 18:12:43 [13456] DEBUG:pid=5043
2007-01-19 18:12:43 [13456] DEBUG:from_host=10.10.10.22
2007-01-19 18:12:43 [13456] DEBUG:dbName=post_tc
2007-01-19 18:12:43 [13456] DEBUG:userName=test
2007-01-19 18:12:43 [13456] DEBUG:recieve sec=1169201563
2007-01-19 18:12:43 [13456] DEBUG:recieve usec=161297
2007-01-19 18:12:43 [13456] DEBUG:query_size=1
2007-01-19 18:12:43 [13456] DEBUG:request_id=5
2007-01-19 18:12:43 [13456] DEBUG:replicate_id=0
2007-01-19 18:12:43 [13456] DEBUG:recovery_status=0
2007-01-19 18:12:43 [13456] DEBUG:sem_lock [1] req
2007-01-19 18:12:43 [13456] DEBUG:sem_lock [1] got it
2007-01-19 18:12:43 [13456] DEBUG:start thread_send_cluster()
2007-01-19 18:12:43 [13456] DEBUG:source host
2007-01-19 18:12:43 [13456] DEBUG:thread_send_cluster():return value from send_replicate_packet_to_server() is 0
2007-01-19 18:12:43 [13456] DEBUG:thread_send_cluster():pthread_exit[0]
2007-01-19 18:12:43 [13456] DEBUG:PGRreturn_result():PGRreturn_result[3,1169201563,161297,28375,1,285]
2007-01-19 18:12:43 [13456] DEBUG:PGRreturn_result():128 send
2007-01-19 18:12:43 [13456] DEBUG:end thread_send_source()
2007-01-19 18:12:43 [13456] DEBUG:sem_unlock[1]
2007-01-19 18:12:43 [13456] DEBUG:PGRread_packet():PG_read_query returns .
2007-01-19 18:12:43 [13456] DEBUG:replicate_loop():session closed
2007-01-19 18:12:43 [13456] DEBUG:PGRdo_replicate():query :: PGR_CLOSE_CONNECTION
2007-01-19 18:12:43 [13456] DEBUG:cmdSts=O
2007-01-19 18:12:43 [13456] DEBUG:cmdType=x
2007-01-19 18:12:43 [13456] DEBUG:rlog=0
2007-01-19 18:12:43 [13456] DEBUG:port=5432
2007-01-19 18:12:43 [13456] DEBUG:pid=5043
2007-01-19 18:12:43 [13456] DEBUG:from_host=10.10.10.22
2007-01-19 18:12:43 [13456] DEBUG:dbName=post_tc
2007-01-19 18:12:43 [13456] DEBUG:userName=test
2007-01-19 18:12:43 [13456] DEBUG:recieve sec=1169201563
2007-01-19 18:12:43 [13456] DEBUG:recieve usec=173275
2007-01-19 18:12:43 [13456] DEBUG:query_size=21
2007-01-19 18:12:43 [13456] DEBUG:request_id=1
2007-01-19 18:12:43 [13456] DEBUG:replicate_id=0
2007-01-19 18:12:43 [13456] DEBUG:recovery_status=0
2007-01-19 18:12:43 [13456] DEBUG:query=PGR_CLOSE_CONNECTION
2007-01-19 18:12:43 [13456] DEBUG:sem_lock [1] req
2007-01-19 18:12:43 [13456] DEBUG:sem_lock [1] got it
2007-01-19 18:12:43 [13456] DEBUG:pgr_createConn():PQsetdbLogin host[cluster1] port[5432] db[post_tc] user[test]
2007-01-19 18:12:43 [13456] DEBUG:pgr_createConn():PQsetdbLogin ok!!
2007-01-19 18:12:43 [13456] DEBUG:replicate_packet_send_internal():connect db:post_tc port:5432 user:test host:cluster1 query:PGR_CLOSE_CONNECTION
2007-01-19 18:12:43 [13456] DEBUG:start thread_send_cluster()
2007-01-19 18:12:43 [13456] DEBUG:source host
2007-01-19 18:12:43 [13456] DEBUG:PGR_Notice_Abort():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(7))
2007-01-19 18:12:43 [13456] DEBUG:sem_unlock[1]
2007-01-19 18:12:43 [13456] DEBUG:replicate_loop():replicate loop exit
Sincerely and regards
---------------------------------
Betty
---------------------------------
雅虎免费邮箱-3.5G容量，20M附件
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgcluster-general/attachments/20070119/9e839682/attachment-0001.html
More information about the Pgcluster-general
mailing list