[pgcluster: 825] Re^2: Re^2: Can't createdb on PGCluster 1.0.10rc1
Masaichi Hasegawa
hasegawa.masaichi @ lab.ntt.co.jp
2005年 9月 26日 (月) 12:18:03 JST
三谷さん、はせがわです。
//英語が苦手なので、こちらのMLに送ります。
2005/09/23 19:19:07, "Atsushi Mitani" <a.mitani @ sra-europe.com> was wrote
> pgFoundryの方にも書きましたが、手元の環境ではcreatdbは問題なく出来ました。
> 環境かオプションが何かが違うのかもしれません。
pgFoundryからダウンロードして、以下のオプションをつけて環境構築して、
make ; make install をしました。
./configure --prefix=/usr/local/pgcl_1-0-10rc1
> これまでのバージョンでは、1つのクエリーをレプリケーションする場合、クラスタDBへのレプリケーションをスレッドで同時に実行していたため、どのクラスタDBからレプリケーションされるか不定でした。
> このバージョンでは少なくともクエリーを受け付けたクラスタDBでの実行が一番最後になるように変更しています。
> はせがわさんのログにはその部分がありませんので、どこかのサーバのバージョンが合っていないのかも知れません。
念の為に、リコンパイルしてみましたが、同じ状況になります。
バージョンも確認してみましたが、同じに見えます。システムの環境が違うのでしょうか。
また、joker01はHT OFF(kernel, CPUともに)にしてあり、spade01とspade02は
HT ONにしてあります。
●OS情報です。
Linux joker01 2.4.21-15.0.2.EL #1 Wed Jun 16 23:12:30 EDT 2004 i686 i686 i386 GNU/Linux
Linux spade01 2.4.21-15.0.2.ELsmp #1 SMP Wed Jun 16 22:52:07 EDT 2004 i686 i686 i386 GNU/Linux
Linux spade02 2.4.21-15.0.2.ELsmp #1 SMP Wed Jun 16 22:52:07 EDT 2004 i686 i686 i386 GNU/Linux
●less config.log
This file contains any messages produced by compilers while
running configure, to aid debugging if configure makes a mistake.
It was created by PostgreSQL configure 7.3.10, which was
generated by GNU Autoconf 2.53. Invocation command line was
$ ./configure --prefix=/usr/local/pgcl_1-0-10rc1
## --------- ##
## Platform. ##
## --------- ##
hostname = joker01
uname -m = i686
uname -r = 2.4.21-15.0.2.EL
uname -s = Linux
uname -v = #1 Wed Jun 16 23:12:30 EDT 2004
/usr/bin/uname -p = unknown
/bin/uname -X = unknown
/bin/arch = i686
/usr/bin/arch -k = unknown
/usr/convex/getsysinfo = unknown
hostinfo = unknown
/bin/machine = unknown
/usr/bin/oslevel = unknown
/bin/universe = unknown
PATH: /usr/kerberos/sbin
PATH: /usr/kerberos/bin
PATH: /bin
PATH: /sbin
PATH: /usr/bin
PATH: /usr/sbin
PATH: /usr/local/bin
PATH: /usr/local/sbin
PATH: /usr/bin/X11
PATH: /usr/X11R6/bin
PATH: /root/bin
## ----------- ##
## Core tests. ##
## ----------- ##
configure:1295: checking build system type
configure:1313: result: i686-pc-linux-gnu
configure:1321: checking host system type
configure:1335: result: i686-pc-linux-gnu
configure:1345: checking which template to use
configure:1444: result: linux
configure:1563: checking whether to build with 64-bit integer date/time support
configure:1594: result: no
configure:1600: checking whether to build with recode support
configure:1631: result: no
configure:1638: checking whether NLS is wanted
configure:1672: result: no
configure:1680: checking for default port number
configure:1709: result: 5432
configure:1727: checking for default soft limit on number of connections
configure:1756: result: 32
configure:1947: checking for gcc
configure:1963: found /usr/bin/gcc
configure:1973: result: gcc
configure:1992: checking for C compiler version
configure:1995: gcc --version </dev/null >&5
gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-20)
Copyright (C) 2002 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
configure:1998: $? = 0
configure:2000: gcc -v </dev/null >&5
Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2.3/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/u
sr/share/info --enable-shared --enable-threads=posix --disable-checking --with-s
ystem-zlib --enable-__cxa_atexit --host=i386-redhat-linux
Thread model: posix
gcc version 3.2.3 20030502 (Red Hat Linux 3.2.3-20)
●リコンパイル後にcreatedbした時のログ...
[postgres @ joker01 pgcl1010rc1]$ less pgrep_joker01_dbt2_200509.log
DEBUG:./pgreplicate.log open ok
DEBUG:./pgreplicate.sts open ok
DEBUG:PGR_Get_Conf_Data ok
DEBUG:LoadBalanceTbl allocate ok
DEBUG:PGRset_Conf_Data():CascadeTbl shmget ok
DEBUG:PGRset_Conf_Data():CascadeTbl shmat ok
DEBUG:PGRset_Conf_Data():CascadeInf shmget ok
DEBUG:PGRset_Conf_Data():CascadeInf shmat ok
DEBUG:PGRset_Conf_Data():CommitLog shmget ok
DEBUG:PGRset_Conf_Data():Commit_Log_Tbl shmat ok
DEBUG:registering hostname spade01
DEBUG:resolved name is 192.168.10.30
DEBUG:registering hostname spade02
DEBUG:resolved name is 192.168.10.40
DEBUG:Conf data read ok
DEBUG:PGRset_Conf_Data():HostTbl shmget ok
DEBUG:PGRset_Conf_Data():HostTbl shmat ok
DEBUG:PGRrecovery_main():PGRrecovery_main bind port 8101
DEBUG:replicate_main() 8001 port bind OK
DEBUG:cmdSts=N
DEBUG:port=0
DEBUG:pid=0
DEBUG:from_host=joker01
DEBUG:dbName=template1
DEBUG:userName=postgres
DEBUG:recieve sec=0
DEBUG:recieve usec=0
DEBUG:query_size=57
DEBUG:query=SELECT PGR_SYSTEM_COMMAND_FUNCTION(1,'joker01',8001,8101)
DEBUG:sem_lock [1] req
DEBUG:sem_lock [1] got it
DEBUG:PGRis_same_host():not same host
DEBUG:pgr_createConn():PQsetdbLogin host[192.168.10.30] port[5435] db[template1] user[postgres]
DEBUG:pgr_createConn():PQsetdbLogin ok!!
DEBUG:start thread_send_cluster()
DEBUG:send_replicate_packet_to_server():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(8,1,0,1) )
DEBUG:PGRis_same_host():not same host
DEBUG:pgr_createConn():PQsetdbLogin host[192.168.10.40] port[5435] db[template1] user[postgres]
DEBUG:send_replicate_packet_to_server():sync_command returns (null)
DEBUG:deleteTransactionTbl():
DEBUG:thread_send_cluster():pthread_exit[0]
DEBUG:pgr_createConn():PQsetdbLogin ok!!
DEBUG:start thread_send_cluster()
DEBUG:send_replicate_packet_to_server():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(8,1,0,1) )
DEBUG:send_replicate_packet_to_server():sync_command returns (null)
DEBUG:deleteTransactionTbl():
DEBUG:thread_send_cluster():pthread_exit[1]
DEBUG:sem_unlock[1]
DEBUG:PGRdo_replicate():query :: CREATE DATABASE "test_db2"
DEBUG:transaction_status: 0,0
DEBUG:cmdSts=Q
DEBUG:cmdType=O
DEBUG:port=5435
DEBUG:pid=4297
DEBUG:from_host=127.0.0.1
DEBUG:dbName=template1
DEBUG:userName=postgres
DEBUG:recieve sec=1127700143
DEBUG:recieve usec=74234
DEBUG:query_size=26
DEBUG:query=CREATE DATABASE "test_db2"
DEBUG:sem_lock [1] req
DEBUG:sem_lock [1] got it
DEBUG:pgr_createConn():PQsetdbLogin host[192.168.10.30] port[5435] db[template1] user[postgres]
DEBUG:pgr_createConn():PQsetdbLogin ok!!
DEBUG:start thread_send_cluster()
DEBUG:send_replicate_packet_to_server():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1127700143,74234,1) )
DEBUG:pgr_createConn():PQsetdbLogin host[192.168.10.40] port[5435] db[template1] user[postgres]
DEBUG:(null) sync_command returns SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1127700143,74234,1)
DEBUG:send_replicate_packet_to_server():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(8,2,0,1) )
DEBUG:send_replicate_packet_to_server():sync_command returns (null)
DEBUG:pgr_createConn():PQsetdbLogin ok!!
DEBUG:start thread_send_cluster()
DEBUG:send_replicate_packet_to_server():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1127700143,74234,1) )
DEBUG:(null) sync_command returns SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1127700143,74234,1)
DEBUG:send_replicate_packet_to_server():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(8,2,0,1) )
DEBUG:send_replicate_packet_to_server():sync_command returns (null)
DEBUG:send_replicate_packet_to_server():PQexec send :CREATE DATABASE "test_db2"
DEBUG:send_replicate_packet_to_server():PQexec returns :
DEBUG:deleteTransactionTbl():
DEBUG:deleteTransactionTbl():
DEBUG:deleteTransactionTbl():
DEBUG:thread_send_cluster():pthread_exit[1]
DEBUG:send_replicate_packet_to_server():PQexec send :CREATE DATABASE "test_db2"
DEBUG:send_replicate_packet_to_server():PQexec returns :CREATE DATABASE
DEBUG:deleteTransactionTbl():
DEBUG:deleteTransactionTbl():
DEBUG:deleteTransactionTbl():
DEBUG:thread_send_cluster():pthread_exit[0]
DEBUG:sem_unlock[1]
DEBUG:PGRdo_replicate():query :: DROP DATABASE "test_db2"
DEBUG:transaction_status: 0,0
DEBUG:cmdSts=Q
DEBUG:cmdType=O
DEBUG:port=5435
DEBUG:pid=4301
DEBUG:from_host=127.0.0.1
DEBUG:dbName=template1
DEBUG:userName=postgres
DEBUG:recieve sec=1127700153
DEBUG:recieve usec=480010
DEBUG:query_size=24
DEBUG:query=DROP DATABASE "test_db2"
DEBUG:sem_lock [1] req
DEBUG:sem_lock [1] got it
DEBUG:pgr_createConn():PQsetdbLogin host[192.168.10.30] port[5435] db[template1] user[postgres]
DEBUG:pgr_createConn():PQsetdbLogin ok!!
DEBUG:start thread_send_cluster()
DEBUG:send_replicate_packet_to_server():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1127700153,480010,1) )
DEBUG:pgr_createConn():PQsetdbLogin host[192.168.10.40] port[5435] db[template1] user[postgres]
DEBUG:(null) sync_command returns SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1127700153,480010,1)
DEBUG:send_replicate_packet_to_server():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(8,3,0,1) )
DEBUG:send_replicate_packet_to_server():sync_command returns (null)
DEBUG:pgr_createConn():PQsetdbLogin ok!!
DEBUG:start thread_send_cluster()
DEBUG:send_replicate_packet_to_server():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1127700153,480010,1) )
DEBUG:(null) sync_command returns SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1127700153,480010,1)
DEBUG:send_replicate_packet_to_server():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(8,3,0,1) )
DEBUG:send_replicate_packet_to_server():sync_command returns (null)
DEBUG:send_replicate_packet_to_server():PQexec send :DROP DATABASE "test_db2"
DEBUG:send_replicate_packet_to_server():PQexec returns :
DEBUG:deleteTransactionTbl():
DEBUG:deleteTransactionTbl():
DEBUG:deleteTransactionTbl():
DEBUG:thread_send_cluster():pthread_exit[1]
DEBUG:send_replicate_packet_to_server():PQexec send :DROP DATABASE "test_db2"
DEBUG:send_replicate_packet_to_server():PQexec returns :DROP DATABASE
DEBUG:deleteTransactionTbl():
DEBUG:deleteTransactionTbl():
DEBUG:deleteTransactionTbl():
DEBUG:thread_send_cluster():pthread_exit[0]
DEBUG:sem_unlock[1]
DEBUG:quick_exit:signo = 2
DEBUG:quick_exit:signo = 2
DEBUG:quick_exit:signo = 2
●Version
●spade01
[postgres @ spade01 bin]$ ./pgreplicate --version
./pgreplicate: invalid option -- -
PGReplicate version [1.0.10rc1]
A replication server for cluster DB servers (based on PostgreSQL)
usage: pgreplicate [-D path_of_config_file] [-W path_of_work_files] [-U login us
er][-l][-n][-v][-h][stop]
config file default path: ./pgreplicate.conf
-l: print error logs in the log file.
-n: don't run in daemon mode.
-v: debug mode. need '-n' flag
-h: print this help
stop: stop pgreplicate
[postgres @ spade01 bin]$ ./pglb --version
./pglb: invalid option -- -
pglb version [1.0.10rc1]
A load balancer for PostgreSQL
usage: pglb [-D path_of_config_file] [-W path_of_work_files] [-n][-v][-h][stop |
restart]
config file default path: ./pglb.conf
-l: print error logs in the log file.
-n: don't run in daemon mode.
-v: debug mode. need '-n' flag
-h: print this help
stop: stop pglb
restart: restart pglb
●spade02
[postgres @ spade02 bin]$ ./postmaster --version
postmaster (PostgreSQL) 7.3.10
[postgres @ spade02 bin]$ ./pgreplicate --version
./pgreplicate: invalid option -- -
PGReplicate version [1.0.10rc1]
A replication server for cluster DB servers (based on PostgreSQL)
usage: pgreplicate [-D path_of_config_file] [-W path_of_work_files] [-U login us
er][-l][-n][-v][-h][stop]
config file default path: ./pgreplicate.conf
-l: print error logs in the log file.
-n: don't run in daemon mode.
-v: debug mode. need '-n' flag
-h: print this help
stop: stop pgreplicate
[postgres @ spade02 bin]$ ./pglb --version
./pglb: invalid option -- -
pglb version [1.0.10rc1]
A load balancer for PostgreSQL
usage: pglb [-D path_of_config_file] [-W path_of_work_files] [-n][-v][-h][stop |
restart]
config file default path: ./pglb.conf
-l: print error logs in the log file.
-n: don't run in daemon mode.
-v: debug mode. need '-n' flag
-h: print this help
stop: stop pglb
restart: restart pglb
[postgres @ spade02 bin]$
●joker01
[postgres @ joker01 pgrp]$ ./pgreplicate --version
./pgreplicate: invalid option -- -
PGReplicate version [1.0.10rc1]
A replication server for cluster DB servers (based on PostgreSQL)
pgcluster メーリングリストの案内