[pgcluster: 1004] ロードバランサが無応答になります。
suzukiys ＠ pm.nttdata.co.jp
suzukiys ＠ pm.nttdata.co.jp
2007年 8月 29日 (水) 17:18:45 JST
$BNkLZ$H?=$7$^$9!#(J
8$B7n(J24$BF|$KEj9F$7$^$7$?!"Ii2YH/@88e$K%m!<%I%P%i%s%5$,(J
$BL51~Ez$K$J$k7o$G$9!#(J
$BA02s$NEj9F0J9_!"%+!<%M%k%Q%i%a!<%?CM$N3HD%Ey$G;n9T:x8m$7$^$7$?$,!"(J
$B2r7h$K;j$C$F$$$^$;$s!#(J
$BL51~EzH/@8;~$N%m!<%I%P%i%s%5$N%G%P%C%0%m%0$*$h$S!"8=;~E@$K$*$1$k(J
PGCluster$B$NDj5A>pJs!"%+!<%M%k%Q%i%a!<%?$O!"0J2<$NDL$j$G$9!#(J
$B#F#r#e#e#B#S#D$G$NF1N`;v>]H/@8$NM-L5$H!"(JPGCluster$B$N0BDj2TF0<B ＠ S(J
$B$N$"$k#O#S!?(JPGCluster$B%P!<%8%g%sEy$K$D$$$F!">pJs$,M-$j$^$7$?$i!"(J
$B$465<(D:$1$?$i9,$$$G$9!#(J
$B!c#O#S!?(JPGCluster$B%P!<%8%g%s!d(J
$B#O#S!'!!#F#r#e#e#B#S#D#6!%#2(J
PGCluster$B!'!!#1!%#7!%#0#r#c#7(J
$B%5!<%P#C#P#U!'!!%$%s%F%k(J Dual$B!!(JCore Xeon$B!!(J1.6GHz
$B%5!<%P%a%b%j!'!!#2(JGB
$B!cIi2Y;n83$G<B9T$7$?(JSQL$B!d(J
$B!!(JINSERT INTO test1 VALUES (nextval('test1_seq') , '$B%+%i%`#2(J' ,$B!&!&!&(J;
$B"(<B:]$N%+%i%`?t$O#2#08D$G!"#2%+%i%`L\0J9_$O#5#0%P%$%HD9$N(J
$B!!!!A43Q%F%-%9%H$r(JINSERT$B$7$^$9!#(J
$B!c%m!<%I%P%i%s%5$N%G%P%C%0%m%0!!!JL51~EzH/@8;~$rH4?h!K!d(J
DEBUG:pool_connection_pool_timer():pool_connection_pool_timer: called
DEBUG:pool_process_query():read kind from backend C
DEBUG:pool_process_query():read kind from backend pending data Z len: 5 po:
11
DEBUG:ReadyForQuery(): message length: 5
DEBUG:ReadyForQuery(): transaction state: I
DEBUG:pool_connection_pool_timer():pool_connection_pool_timer: called
DEBUG:pool_process_query():read kind from backend C
DEBUG:pool_process_query():read kind from backend pending data Z len: 5 po:
11
DEBUG:ReadyForQuery(): message length: 5
DEBUG:ReadyForQuery(): transaction state: I
DEBUG:pool_connection_pool_timer():pool_connection_pool_timer: called
$B!!!c!]!!0J9_%m%0=PNO!"(JDB$B@\B3$X$N1~EzL5$7(J
$B!c%3%s%U%#%0%l!<%7%g%s!d(J
$B#W#E#B%5!<%P!J(Jweb1/web2)
$B-!(Jpglb.conf
<Cluster_Server_Info>
<Host_Name> db1 </Host_Name>
<Port> 5440 </Port>
<Max_Connect> 64 </Max_Connect>
</Cluster_Server_Info>
<Cluster_Server_Info>
<Host_Name> db2 </Host_Name>
<Port> 5440 </Port>
<Max_Connect> 64 </Max_Connect>
</Cluster_Server_Info>
<Cluster_Server_Info>
<Host_Name> db3 </Host_Name>
<Port> 5440 </Port>
<Max_Connect> 64 </Max_Connect>
</Cluster_Server_Info>
<Host_Name> web1 </Host_Name>
<Backend_Socket_Dir> /tmp </Backend_Socket_Dir>
<Receive_Port> 5440 </Receive_Port>
<Recovery_Port> 6001 </Recovery_Port>
<Max_Cluster_Num> 3 </Max_Cluster_Num>
<Use_Connection_Pooling> yes </Use_Connection_Pooling>
<LifeCheck_Timeout> 3s </LifeCheck_Timeout>
<LifeCheck_Interval> 15s </LifeCheck_Interval>
<Log_File_Info>
<File_Name> /var/tmp/pglb.log </File_Name>
<File_Size> 1M </File_Size>
<Rotate> 7 </Rotate>
</Log_File_Info>
$B#D#B%5!<%P!J#1!K(J
$B-!(Jcluster.conf
<Replicate_Server_Info>
<Host_Name> db3 </Host_Name>
<Port> 8001 </Port>
<Recovery_Port> 8101 </Recovery_Port>
</Replicate_Server_Info>
<Replicate_Server_Info>
<Host_Name> db2 </Host_Name>
<Port> 8001 </Port>
<Recovery_Port> 8101 </Recovery_Port>
</Replicate_Server_Info>
<Host_Name> db1 </Host_Name>
<Recovery_Port> 7001 </Recovery_Port>
<Rsync_Path> /usr/local/bin/rsync </Rsync_Path>
<Rsync_Option> ssh </Rsync_Option>
<Rsync_Compress> yes </Rsync_Compress>
<Pg_Dump_Path> /usr/local/pgcluster-1.7.0rc7/bin/pg_dump </Pg_Dump_Path>
<When_Stand_Alone> read_only </When_Stand_Alone>
<Replication_Timeout> 1min </Replication_Timeout>
<LifeCheck_Timeout> 3s </LifeCheck_Timeout>
<LifeCheck_Interval> 11s </LifeCheck_Interval>
$B#D#B%5!<%P!J#2!K(J
$B-!(Jcluster.conf
<Replicate_Server_Info>
<Host_Name> db3 </Host_Name>
<Port> 8001 </Port>
<Recovery_Port> 8101 </Recovery_Port>
</Replicate_Server_Info>
<Replicate_Server_Info>
<Host_Name> db2 </Host_Name>
<Port> 8001 </Port>
<Recovery_Port> 8101 </Recovery_Port>
</Replicate_Server_Info>
<Host_Name> db2 </Host_Name>
<Recovery_Port> 7001 </Recovery_Port>
<Rsync_Path> /usr/local/bin/rsync </Rsync_Path>
<Rsync_Option> ssh </Rsync_Option>
<Rsync_Compress> yes </Rsync_Compress>
<Pg_Dump_Path> /usr/local/pgcluster-1.7.0rc7/bin/pg_dump </Pg_Dump_Path>
<When_Stand_Alone> read_only </When_Stand_Alone>
<Replication_Timeout> 1min </Replication_Timeout>
<LifeCheck_Timeout> 3s </LifeCheck_Timeout>
<LifeCheck_Interval> 11s </LifeCheck_Interval>
$B-"(Jpgreplicate.conf
<Cluster_Server_Info>
<Host_Name> db3 </Host_Name>
<Port> 5440 </Port>
<Recovery_Port> 7001 </Recovery_Port>
</Cluster_Server_Info>
<Cluster_Server_Info>
<Host_Name> db2 </Host_Name>
<Port> 5440 </Port>
<Recovery_Port> 7001 </Recovery_Port>
</Cluster_Server_Info>
<Cluster_Server_Info>
<Host_Name> db1 </Host_Name>
<Port> 5440 </Port>
<Recovery_Port> 7001 </Recovery_Port>
</Cluster_Server_Info>
<LoadBalance_Server_Info>
<Host_Name> web1 </Host_Name>
<Recovery_Port> 6001 </Recovery_Port>
</LoadBalance_Server_Info>
<LoadBalance_Server_Info>
<Host_Name> web2 </Host_Name>
<Recovery_Port> 6001 </Recovery_Port>
</LoadBalance_Server_Info>
<Host_Name> db2 </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>
<LifeCheck_Timeout> 3s </LifeCheck_Timeout>
<LifeCheck_Interval> 15s </LifeCheck_Interval>
<Log_File_Info>
<File_Name> /var/log/pgreplicate.log </File_Name>
<File_Size> 1M </File_Size>
<Rotate> 7 </Rotate>
</Log_File_Info>
$B#D#B%5!<%P!J#3!K(J
$B-!(Jcluster.conf
<Replicate_Server_Info>
<Host_Name> db3 </Host_Name>
<Port> 8001 </Port>
<Recovery_Port> 8101 </Recovery_Port>
</Replicate_Server_Info>
<Replicate_Server_Info>
<Host_Name> db2 </Host_Name>
<Port> 8001 </Port>
<Recovery_Port> 8101 </Recovery_Port>
</Replicate_Server_Info>
<Host_Name> db3 </Host_Name>
<Recovery_Port> 7001 </Recovery_Port>
<Rsync_Path> /usr/local/bin/rsync </Rsync_Path>
<Rsync_Option> ssh </Rsync_Option>
<Rsync_Compress> yes </Rsync_Compress>
<Pg_Dump_Path> /usr/local/pgcluster-1.7.0rc7/bin/pg_dump </Pg_Dump_Path>
<When_Stand_Alone> read_only </When_Stand_Alone>
<Replication_Timeout> 1min </Replication_Timeout>
<LifeCheck_Timeout> 3s </LifeCheck_Timeout>
<LifeCheck_Interval> 11s </LifeCheck_Interval>
$B-"(Jpgreplicate.conf
<Cluster_Server_Info>
<Host_Name> db3 </Host_Name>
<Port> 5440 </Port>
<Recovery_Port> 7001 </Recovery_Port>
</Cluster_Server_Info>
<Cluster_Server_Info>
<Host_Name> db2 </Host_Name>
<Port> 5440 </Port>
<Recovery_Port> 7001 </Recovery_Port>
</Cluster_Server_Info>
<Cluster_Server_Info>
<Host_Name> db1 </Host_Name>
<Port> 5440 </Port>
<Recovery_Port> 7001 </Recovery_Port>
</Cluster_Server_Info>
<LoadBalance_Server_Info>
<Host_Name> web1 </Host_Name>
<Recovery_Port> 6001 </Recovery_Port>
</LoadBalance_Server_Info>
<LoadBalance_Server_Info>
<Host_Name> web2 </Host_Name>
<Recovery_Port> 6001 </Recovery_Port>
</LoadBalance_Server_Info>
<Host_Name> db3 </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>
<LifeCheck_Timeout> 3s </LifeCheck_Timeout>
<LifeCheck_Interval> 15s </LifeCheck_Interval>
<Log_File_Info>
<File_Name> /var/log/pgreplicate.log </File_Name>
<File_Size> 1M </File_Size>
<Rotate> 7 </Rotate>
</Log_File_Info>
$B!c#O#S%+!<%M%k%3%s%U%#%0!d(J
PGCluster$B$N8!>Z$N0Y!">e8BCM$r6KC<$K3HD%$7$F$$$k%Q%i%a!<%?$,$"$j$^$9!#(J
$B-!(J/boot/loader.conf
kern.ipc.shmseg=4096
kern.ipc.semmap=1048576
kern.ipc.semmni=65536
kern.ipc.semmns=1048576
kern.ipc.semmnu=1024
kern.ipc.semopm=65536
kern.ipc.semume=128
kern.ipc.semusz=512
kern.ipc.nmbclusters=196608
vm.kmem_size_max=402653184
mac_biba_load="YES"
mac_bsdextended_load="YES"
mac_ifoff_load="YES"
mac_lomac_load="YES"
mac_mls_load="YES"
mac_none_load="YES"
mac_partition_load="YES"
mac_portacl_load="YES"
mac_seeotheruids_load="YES"
mac_stub_load="YES"
mac_test_load="YES"
security.mac.biba.enabled=0
security.mac.bsdextended.enabled=1
security.mac.mls.enabled=0
security.mac.none.enabled=0
security.mac.partition.enabled=0
security.mac.seeotheruids.enabled=1
security.mac.ifoff.enabled=0
security.mac.lomac.enabled=0
security.mac.portacl.enabled=0
security.mac.stub.enabled=0
security.mac.test.enabled=0
accf_http_load="YES"
accf_data_load="YES"
kern.maxdsiz=1024M
kern.maxssiz=1024M
$B-"(J/etc/sysctl.conf
net.inet.tcp.rexmit_min=200
kern.ipc.somaxconn=8192
kern.ipc.maxsockbuf=268435456
net.inet.ip.portrange.first=20000
net.inet.ip.portrange.last=40000
kern.ipc.shmmax=268435456
kern.ipc.shmall=65536
kern.ipc.semmsl=65536
kern.ipc.semvmx=1048576
kern.ipc.semaem=1048576
kern.threads.max_threads_per_proc=65536
kern.threads.max_groups_per_proc=65536
net.inet.ip.redirect=0
net.inet.ip.sourceroute=0
net.inet.ip.accept_sourceroute=0
net.inet.icmp.drop_redirect=1
net.inet.icmp.log_redirect=1
net.inet.icmp.bmcastecho=0
net.inet.icmp.maskrepl=0
net.inet.tcp.drop_synfin=1
net.link.ether.inet.max_age=1200
pgcluster メーリングリストの案内