[pgpool-general: 475] Re: abnormal behavior pgpool on drop

[Евгений Селявка]

Yes i can drop database when i directly connect to master server. I do not
understand why pgpool sent command to postgresql master server to shutdown
and then initiates failover procedure? Nobody can't access to master
server except
me and i don't restart the master db by myself. Those behavior i see for
the second time.

2012/5/21 Lazaro Ruben Garcia Martinez <lgarciam at uci.cu>

> When there are open connections in a database, it can not be dropped.
> Maybe pgpool connects to the database server for balancing some query or
> there are other user connected to the database. Can you try to drop the
> database directly?
>
> Regards.
>
> ------------------------------
>
> I have pgpool-II version 3.1.3 installed and three db postgresql 9.1.3 in
> streaming replication. When i try to drop database i see this in pgpool log:
>
> 2012-05-21 15:01:48 LOG:   pid 15484: pool_send_and_wait: Error or notice
> message from backend: : DB node id: 1 backend pid: 6769 statement: DROP
> DATABASE xxx; message: database "xxx" is being accessed by other users
> 2012-05-21 15:02:20 LOG:   pid 26326: postmaster on DB node 1 was shutdown
> by administrative command
> 2012-05-21 15:02:20 LOG:   pid 26326: degenerate_backend_set: 1 fail over
> request from pid 26326
> 2012-05-21 15:02:20 LOG:   pid 4975: starting degeneration. shutdown host
> 10.141.2.54(5432)
> 2012-05-21 15:02:20 LOG:   pid 4975: Restart all children
> 2012-05-21 15:02:20 LOG:   pid 4975: execute command:
> /etc/pgpool.d/failover.sh 1 10.141.2.54 5432 /var/lib/postgresql/9.1/main 0
> 10.141.2.53 0 1
> 2012-05-21_15:02:20 failover: Master failed at 10.141.2.54 (0). New master
> is 10.141.2.53 (0)
> 2012-05-21_15:02:20 failover: New master start triggered.
>
> Why pgpool initiated failover procedure on statement drop database? I add
> drop statement in black_function_list may be this helps me.
>
>
> --
> С уважением Селявка Евгений
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
>
>   <http://www.uci.cu/>
>
>


-- 
С уважением Селявка Евгений
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120521/8b1c3796/attachment.html>