Hi, list. I use pgcluster-1.9.0rc5 with 2 nodes. node1: pglb & pgreplicate & postmaster node2: pgreplicate & postmaster
Parent pglb process is killed when I use "DROP DATABASE" or "dropdb"command through pglb. After this state occour, I cannot connect to postmaster through pglb. Except DROP DATABASE , pgcluster works fine. I have a misconfiguration? pglb debuglog: 2008-07-29 19:46:30 [3144] DEBUG:PGRscan_cluster:2 ClusterDB can be used 2008-07-29 19:46:30 [3144] DEBUG:PGRscan_cluster:node2 [5433],useFlag->2 max->32 use_num->0 2008-07-29 19:46:30 [3183] DEBUG:I am 3183 2008-07-29 19:46:30 [3183] DEBUG:I am 3183 accept fd 6 2008-07-29 19:46:30 [3183] DEBUG:Protocol Major: 3 Minor: 0 database: postgres user: pgcluster 2008-07-29 19:46:30 [3183] DEBUG:pool_read_message_length: lenghth: 8 2008-07-29 19:46:30 [3183] DEBUG:pool_read_message_length2: master lenghth: 30 2008-07-29 19:46:30 [3183] DEBUG:name: client_encoding value: SQL_ASCII 2008-07-29 19:46:30 [3183] DEBUG:pool_read_message_length2: master lenghth: 23 2008-07-29 19:46:30 [3183] DEBUG:name: DateStyle value: ISO, MDY 2008-07-29 19:46:30 [3183] DEBUG:pool_read_message_length2: master lenghth: 26 2008-07-29 19:46:30 [3183] DEBUG:name: integer_datetimes value: off 2008-07-29 19:46:30 [3183] DEBUG:pool_read_message_length2: master lenghth: 20 2008-07-29 19:46:30 [3183] DEBUG:name: is_superuser value: on 2008-07-29 19:46:30 [3183] DEBUG:pool_read_message_length2: master lenghth: 30 2008-07-29 19:46:30 [3183] DEBUG:name: server_encoding value: SQL_ASCII 2008-07-29 19:46:30 [3183] DEBUG:pool_read_message_length2: master lenghth: 25 2008-07-29 19:46:30 [3183] DEBUG:name: server_version value: 8.3.0 2008-07-29 19:46:30 [3183] DEBUG:pool_read_message_length2: master lenghth: 36 2008-07-29 19:46:30 [3183] DEBUG:name: session_authorization value: pgcluster 2008-07-29 19:46:30 [3183] DEBUG:pool_read_message_length2: master lenghth: 36 2008-07-29 19:46:30 [3183] DEBUG:name: standard_conforming_strings value: off 2008-07-29 19:46:30 [3183] DEBUG:pool_read_message_length2: master lenghth: 19 2008-07-29 19:46:30 [3183] DEBUG:name: TimeZone value: Japan 2008-07-29 19:46:30 [3183] DEBUG:pool_read_message_length: lenghth: 12 2008-07-29 19:46:30 [3183] DEBUG:pool_send_auth_ok: send pid 3582 to frontend 2008-07-29 19:46:30 [3183] DEBUG:read kind from backend pending data Z len: 5 po: 272 2008-07-29 19:46:30 [3183] DEBUG:pool_process_query: kind from backend: Z 2008-07-29 19:46:30 [3183] DEBUG:pool_read_message_length: lenghth: 5 2008-07-29 19:46:30 [3183] DEBUG:ReadyForQuery: message length: 5 2008-07-29 19:46:30 [3183] DEBUG:ReadyForQuery: transaction state: I 2008-07-29 19:46:30 [3183] DEBUG:read kind from frontend Q(51) 2008-07-29 19:46:30 [3183] DEBUG:statement: DROP DATABASE test1; 2008-07-29 19:46:30 [3183] DEBUG:Query: sending HUP signal to parent 2008-07-29 19:46:30 [3183] DEBUG:child receives close idle connection request 2008-07-29 19:46:35 [3183] DEBUG:read kind from backend C 2008-07-29 19:46:35 [3183] DEBUG:pool_process_query: kind from backend: C 2008-07-29 19:46:35 [3183] DEBUG:read kind from backend pending data Z len: 5 po: 19 2008-07-29 19:46:35 [3183] DEBUG:pool_process_query: kind from backend: Z 2008-07-29 19:46:35 [3183] DEBUG:pool_read_message_length: lenghth: 5 2008-07-29 19:46:35 [3183] DEBUG:ReadyForQuery: message length: 5 2008-07-29 19:46:35 [3183] DEBUG:ReadyForQuery: transaction state: I 2008-07-29 19:46:35 [3183] DEBUG:read kind from frontend X(58) Thanks, NamaT _______________________________________________ Pgcluster-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgcluster-general
