[pgcluster: 375] psqlでベータベースに入れません
kang bongsu
kang ＠ bml.co.jp
2004年 6月 17日 (木) 13:15:28 JST
This is a multi-part message in MIME format.
------=_NextPart_000_003D_01C4546D.28D6F100
Content-Type: text/plain;
charset="iso-2022-jp"
Content-Transfer-Encoding: 7bit
はじめまして！ カンボンスと申します。
今、pgcluster-1.0.6bを試してますけれとも上手く動かないのでおうかがいたいで
す。
構成は
クラスタサーバ ２台（一台はVMware）、レプリケーション１台(VMware)
です。
一応、createdbとdropdbはうまくいきますが、ｐｓｑｌでデータベースに接近する
と
以下のエラーが出ます。
長文になりますが,宜しくお願いいたします。
日本語が上手くできません。お許して下さい。 （T、T）
ーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーー
クラスタ：thisminus.postgres.j
p, mss-sv03.postgres.jp
レプリケーション：mss-sv02.postgres.jp
DEBUG(PGRgetDBServerTbl): search host is (thisminus.postgres.jp)
DEBUG(get_ip_by_name): search host(-836693332):port(5432):db(template1)
DEBUG(get_ip_by_name): found
DEBUG(replicate_loop): replicate main: selected
DEBUG(replicate_loop): wait replicate
DEBUG(replicate_loop): replicate_loop selected
DEBUG(read_packet): query size=5
DEBUG(read_packet): read query
DEBUG(read_packet): query :: BEGIN
DEBUG(replicate_packet_send): cmdSts=T
DEBUG(replicate_packet_send): cmdType=B
DEBUG(replicate_packet_send): port=5432
DEBUG(replicate_packet_send): pid=1304
DEBUG(replicate_packet_send): except_host=mss-sv03.postgres.jp
DEBUG(replicate_packet_send): from_host=mss-sv03.postgres.jp
DEBUG(replicate_packet_send): dbName=test
DEBUG(replicate_packet_send): userName=postgres
DEBUG(replicate_packet_send): recieve sec=1087324491
DEBUG(replicate_packet_send): recieve usec=663488
DEBUG(replicate_packet_send): query_size=5
DEBUG(replicate_packet_send): query=BEGIN
DEBUG(get_ip_by_name): same host:5432 ＠ ea2112ac - 5432 ＠ ea2112ac
DEBUG(get_ip_by_name): 5432 @ mss-sv03.postgres.jp return trigger
DEBUG(return_result): 128[2,1087324491,663488]
DEBUG(return_result): return_result[2,1087324491,663488]
DEBUG(return_result): 128 send
DEBUG(get_ip_by_name): not same host:5432 ＠ ea2112ac - 5432 ＠ ce2112ac
DEBUG(replicate_packet_send_each_server): except:5432 ＠ mss-sv03.postgres.jp
host:5432 ＠ thisminus.postg
res.jp
DEBUG(replicate_packet_send_each_server): send replicate
to:thisminus.postgres.jp
DEBUG(PGRsend_replicate_packet_to_server): host(thisminus.postgres.jp) :
port(5432)
DEBUG(get_ip_by_name): not found in transaction tbl host
mss-sv03.postgres.jp db:test pid:1304
DEBUG(get_ip_by_name): not found in PGRgetTransactionTbl
DEBUG(get_ip_by_name): not found in transaction tbl host
mss-sv03.postgres.jp db:test pid:1304
DEBUG(PGRcreateConn): PQsetdbLogin ok!!
DEBUG(insertTransactionTbl): db:test port:5432 user:postgres
host:thisminus.postgres.jp query:BEGIN
DEBUG(insertTransactionTbl): sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(2,1087324491,663488) )
DEBUG(insertTransactionTbl): PQexec send :BEGIN
DEBUG(insertTransactionTbl): PQstatus(0)
DEBUG(insertTransactionTbl): PQgetResult((null))
DEBUG(insertTransactionTbl): cmdStatus(BEGIN)
DEBUG(insertTransactionTbl): errMsg((null))
DEBUG(insertTransactionTbl): PQerrMsg()
DEBUG(insertTransactionTbl): resStatus(PGRES_COMMAND_OK)
DEBUG(insertTransactionTbl): cmdStatus(BEGIN)
DEBUG(insertTransactionTbl): return result(CBEGIN)
DEBUG(insertTransactionTbl): PQexec end
DEBUG(insertTransactionTbl): replicate_loop selected
DEBUG(read_packet): query size=25
DEBUG(read_packet): read query
DEBUG(read_packet): query :: PGR_QUERY_DONE_NOTICE_CMD
DEBUG(replicate_packet_send): cmdSts=
DEBUG(replicate_packet_send): cmdType=
DEBUG(replicate_packet_send): port=0
DEBUG(replicate_packet_send): pid=0
DEBUG(replicate_packet_send): except_host=
DEBUG(replicate_packet_send): from_host=
DEBUG(replicate_packet_send): dbName=
DEBUG(replicate_packet_send): userName=
DEBUG(replicate_packet_send): recieve sec=1087324491
DEBUG(replicate_packet_send): recieve usec=695325
DEBUG(replicate_packet_send): query_size=25
DEBUG(replicate_packet_send): query=PGR_QUERY_DONE_NOTICE_CMD
DEBUG(PGRis_same_host): not same host:
DEBUG(replicate_packet_send_each_server): except:0@
host:5432 ＠ mss-sv03.postgres.jp
DEBUG(replicate_packet_send_each_server): send replicate
to:mss-sv03.postgres.jp
DEBUG(PGRsend_replicate_packet_to_server): host(mss-sv03.postgres.jp) :
port(5432)
DEBUG(PGRgetDBServerTbl): search host is (mss-sv03.postgres.jp)
DEBUG(get_ip_by_name): not found
DEBUG(PGRsetDBServerTbl): host:mss-sv03.postgres.jp dbName:
DEBUG(PGRgetDBServerTbl): search host is (mss-sv03.postgres.jp)
DEBUG(get_ip_by_name): not found
ERROR(PGRcreateConn): PQsetdbLogin failed. close socket!!
ERROR(PGRcreateConn): PQsetdbLogin failed. close socket!!
ERROR(PGRcreateConn): PQsetdbLogin failed. close socket!!
ERROR(PGRcreateConn): PQsetdbLogin failed. close socket!!
ERROR(PGRcreateConn): PQsetdbLogin failed. close socket!!
ERROR(PGRcreateConn): dbPersistLogin timeout
ERROR(PGRcreateConn): PGRcreateConn failed
ERROR(PGRsend_load_balance_packet): PGRsetDBServerTbl failed
DEBUG(return_result): 128[]
DEBUG(return_result): return_result[]
DEBUG(return_result): 128 send
DEBUG(PGRis_same_host): not same host:
DEBUG(replicate_packet_send_each_server):except:0@
host:5432 ＠ thisminus.postgres.jp
------=_NextPart_000_003D_01C4546D.28D6F100
Content-Type: text/html;
charset="iso-2022-jp"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-2022-jp">
<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3D"MS UI Gothic"=20
size=3D2>=1B$B$O$8$a$^$7$F!*!!%+%s%\%s%9$H?=3D$7$^$9!#=1B(B<BR>=1B$B!!:#!=
"=1B(Bpgcluster-1.0.6b=1B$B$r;n$7$F$^$9$1$l$H$b>e<j$/F0$+$J$$$N$G$*$&$+$,=
$$$?$$$G$9!#=1B(B<BR> =1B$B9=3D ＠ .$O=1B(B<BR>=1B$B!!%/%i%9%?%5!<%P!!#=
2Bf!J0lBf$O=1B(BVMware=1B$B!K!"%l%W%j%1!<%7%g%s#1Bf=1B(B(VMware)<BR> =
;=1B$B$G$9!#=1B(B=20
<BR>=1B$B!!0l1~!"=1B(Bcreatedb=1B$B$H=1B(Bdropdb=1B$B$O$&$^$/$$$-$^$9$,!"=
#p#s#q#l$G%G!<%?%Y!<%9$K@\6a$9$k$H=1B(B<BR>=1B$B!!0J2<$N%(%i!<$,=3DP$^$9!=
#=1B(B<BR> =1B$BD9J8$K$J$j$^$9$,=1B(B,</FONT><FONT=20
face=3D"MS UI Gothic" =
size=3D2>=1B$B59$7$/$*4j$$$$$?$7$^$9!#=1B(B</FONT></DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2></FONT> </DIV>
<DIV><FONT face=3D"MS UI Gothic" =
size=3D2>=1B$BF|K\8l$,>e<j$/$G$-$^$;$s!#$*5v$7$F2<$5$$!#!!!J=1B(BT=1B$B!"=
=1B(BT=1B$B!K=1B(B</DIV>
<DIV><BR>=1B$B!<!<!<!<!<!<!<!<!<!<!<!<!<!<!<!<!<!<!<!<!<!<!<!<!<!<!<!<!<!=
<!<!<!<!<!<!<!<!<!<!<!<!<!<!<!<!<!<!<=1B(B<BR>=1B$B!!%/%i%9%?!'=1B(Bthism=
inus.postgres.jp,=20
mss-sv03.postgres.jp<BR> =
=1B$B%l%W%j%1!<%7%g%s!'=1B(Bmss-sv02.postgres.jp=1B$B!!=1B(B</FONT></DIV>=
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(PGRgetDBServerTbl): =
search host is=20
(thisminus.postgres.jp)<BR>DEBUG(get_ip_by_name): search=20
host(-836693332):port(5432):db(template1)<BR>DEBUG(get_ip_by_name):=20
found<BR>DEBUG(replicate_loop): replicate main: selected</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_loop): wait=20
replicate</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_loop): =
replicate_loop=20
selected</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(read_packet): query=20
size=3D5<BR>DEBUG(read_packet): read query<BR>DEBUG(read_packet): query =
::=20
BEGIN</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send):=20
cmdSts=3DT</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send):=20
cmdType=3DB</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send):=20
port=3D5432</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send):=20
pid=3D1304</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send):=20
except_host=3Dmss-sv03.postgres.jp</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send):=20
from_host=3Dmss-sv03.postgres.jp</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send):=20
dbName=3Dtest</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send):=20
userName=3Dpostgres</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send): =
recieve=20
sec=3D1087324491</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send): =
recieve=20
usec=3D663488</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send):=20
query_size=3D5</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send):=20
query=3DBEGIN</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(get_ip_by_name): same=20
host:5432 ＠ ea2112ac - <A=20
href=3D"mailto:5432 ＠ ea2112ac">5432 ＠ ea2112ac</A></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(get_ip_by_name): 5432 @=20
mss-sv03.postgres.jp return trigger<BR>DEBUG(return_result):=20
128[2,1087324491,663488]<BR>DEBUG(return_result):=20
return_result[2,1087324491,663488]<BR>DEBUG(return_result): 128=20
send<BR>DEBUG(get_ip_by_name): not same host:5432 ＠ ea2112ac - <A=20
href=3D"mailto:5432 ＠ ce2112ac">5432 ＠ ce2112ac</A></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" =
size=3D2>DEBUG(replicate_packet_send_each_server):=20
except:5432 ＠ mss-sv03.postgres.jp=20
host:5432 ＠ thisminus.postg<BR>res.jp</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" =
size=3D2>DEBUG(replicate_packet_send_each_server):=20
send replicate to:thisminus.postgres.jp</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" =
size=3D2>DEBUG(PGRsend_replicate_packet_to_server):=20
host(thisminus.postgres.jp) : port(5432)<BR>DEBUG(get_ip_by_name): not =
found in=20
transaction tbl host mss-sv03.postgres.jp db:test pid:1304</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(get_ip_by_name): not =
found in=20
PGRgetTransactionTbl<BR>DEBUG(get_ip_by_name): not found in transaction =
tbl host=20
mss-sv03.postgres.jp db:test pid:1304</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(PGRcreateConn): =
PQsetdbLogin=20
ok!!</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(insertTransactionTbl): =
db:test=20
port:5432 user:postgres host:thisminus.postgres.jp =
query:BEGIN</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(insertTransactionTbl):=20
sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(2,1087324491,663488)=20
)<BR>DEBUG(insertTransactionTbl): PQexec send :BEGIN</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(insertTransactionTbl):=20
PQstatus(0)<BR>DEBUG(insertTransactionTbl):=20
PQgetResult((null))<BR>DEBUG(insertTransactionTbl):=20
cmdStatus(BEGIN)<BR>DEBUG(insertTransactionTbl):=20
errMsg((null))<BR>DEBUG(insertTransactionTbl):=20
PQerrMsg()<BR>DEBUG(insertTransactionTbl):=20
resStatus(PGRES_COMMAND_OK)<BR>DEBUG(insertTransactionTbl):=20
cmdStatus(BEGIN)<BR>DEBUG(insertTransactionTbl): return=20
result(CBEGIN)<BR>DEBUG(insertTransactionTbl): PQexec end</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(insertTransactionTbl):=20
replicate_loop selected</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(read_packet): query=20
size=3D25<BR>DEBUG(read_packet): read query<BR>DEBUG(read_packet): query =
::=20
PGR_QUERY_DONE_NOTICE_CMD</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send):=20
cmdSts=3D</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send):=20
cmdType=3D</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send):=20
port=3D0</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send):=20
pid=3D0</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send):=20
except_host=3D</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send):=20
from_host=3D</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send):=20
dbName=3D</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send):=20
userName=3D</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send): =
recieve=20
sec=3D1087324491</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send): =
recieve=20
usec=3D695325</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send):=20
query_size=3D25</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(replicate_packet_send):=20
query=3DPGR_QUERY_DONE_NOTICE_CMD</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(PGRis_same_host): not =
same=20
host:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" =
size=3D2>DEBUG(replicate_packet_send_each_server):=20
except:0@ host:5432 ＠ mss-sv03.postgres.jp</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" =
size=3D2>DEBUG(replicate_packet_send_each_server):=20
send replicate to:mss-sv03.postgres.jp</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" =
size=3D2>DEBUG(PGRsend_replicate_packet_to_server):=20
host(mss-sv03.postgres.jp) : port(5432)<BR>DEBUG(PGRgetDBServerTbl): =
search host=20
is (mss-sv03.postgres.jp)<BR>DEBUG(get_ip_by_name): not=20
found<BR>DEBUG(PGRsetDBServerTbl): host:mss-sv03.postgres.jp=20
dbName:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2>DEBUG(PGRgetDBServerTbl): =
search host is=20
(mss-sv03.postgres.jp)<BR>DEBUG(get_ip_by_name): not=20
found<BR>ERROR(PGRcreateConn): PQsetdbLogin failed. close=20
socket!!<BR>ERROR(PGRcreateConn): PQsetdbLogin failed. close=20
socket!!<BR>ERROR(PGRcreateConn): PQsetdbLogin failed. close=20
socket!!<BR>ERROR(PGRcreateConn): PQsetdbLogin failed. close=20
socket!!<BR>ERROR(PGRcreateConn): PQsetdbLogin failed. close=20
socket!!<BR>ERROR(PGRcreateConn): dbPersistLogin =20
timeout<BR>ERROR(PGRcreateConn): PGRcreateConn=20
failed<BR>ERROR(PGRsend_load_balance_packet): PGRsetDBServerTbl=20
failed<BR>DEBUG(return_result): 128[]<BR>DEBUG(return_result):=20
return_result[]<BR>DEBUG(return_result): 128 =
send<BR>DEBUG(PGRis_same_host): not=20
same host:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic"=20
size=3D2>DEBUG(replicate_packet_send_each_server):except:0@=20
host:5432 ＠ thisminus.postgres.jp</FONT></DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2></FONT> </DIV>
<DIV><FONT face=3D"MS UI Gothic" size=3D2></FONT> </DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS UI Gothic" =
size=3D2>=1B$B!!=1B(B</FONT></DIV></BODY></HTML>
------=_NextPart_000_003D_01C4546D.28D6F100--
pgcluster メーリングリストの案内