I am playing git tip on windows 7/32 bits, with the backend compiled with visual studio 2005 (I know, it is very old :-( ).
I encountered avl shutdown slowness twice, last night and this morning: after a ctrl_c is hit, wait for another 60 seconds, server shuts down. Here is one log: D:\pgsql\bin>postgres -D../data --log_line_prefix="%t %p" 2015-04-07 10:30:04 PDT 3148LOG: database system was shut down at 2015-04-07 10:29:24 PDT 2015-04-07 10:30:04 PDT 19548LOG: database system is ready to accept connections 2015-04-07 10:30:04 PDT 27008LOG: autovacuum launcher started 2015-04-07 10:30:08 PDT 19548LOG: received fast shutdown request 2015-04-07 10:30:08 PDT 19548LOG: aborting any active transactions 2015-04-07 10:30:08 PDT 27008LOG: autovacuum launcher shutting down 2015-04-07 10:30:08 PDT 27008ERROR: canceling statement due to user request 2015-04-07 10:31:09 PDT 27008LOG: autovacuum launcher shutting down 2015-04-07 10:31:09 PDT 15656LOG: shutting down 2015-04-07 10:31:09 PDT 15656LOG: database system is shut down The interesting part is on PID 27008: avl first ereport() shutdown, which is at the very end of the main loop and just one step away from proc_exit(). Then it seems honors a SIGINT within ereport(), longjmp to the loop head, and waits for another 60 seconds. After timeout, it ereports shutdown again, and finally exits. Not sure if this is windows only or general. I can hardly repro it. Anyone has ever seen this? Regards, Qingqing -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
