Jim C. Nasby wrote:
> We tried reproducing this on a backup server. We haven't been able to
> wedge the system into a state where there's tons of sblock processes
> and nothing's getting done, but we were able to get some processes into
> sblock and get stack traces:
>
> #0 0x000000080135bd2c in recvfrom () from /lib/libc.so.6
> #1 0x00000000004f9898 in secure_read ()
> #2 0x00000000004fed7b in TouchSocketFile ()
> #3 0x00000000004fee27 in pq_getbyte ()
> #4 0x000000000055febf in PostgresMain ()
> #5 0x000000000053a487 in ClosePostmasterPorts ()
> #6 0x000000000053bab7 in PostmasterMain ()
> #7 0x0000000000500436 in main ()
This stack trace doesn't make any sense. ClosePostmasterPorts is not
calling PostgresMain. And pq_getbyte is not calling TouchSocketFile,
which in turn isn't calling secure_read.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.