Tom --
>
<...>
> WTF? That should certainly not happen. Have you perhaps got a script
> that runs around sending SIGTERM to backends that it thinks are blocking
> something? Does anything show up in the postmaster log when this
> happens?
No, we have processes that kill IDLE IN TRANSACTIONs ruthlessly, but nothing that kills any other processes. There is an outside chance that this ran at just the same time that a cronjob ran the REINDEX command for the table (unlikely but I am going to shut off the cronjob and try this again).It does not log an ERROR to the log file; I can wade intio the log and see what else it says but it will take a little while (about 800 megs per hour) to answer that.
Thanks, and I'll report back soon.Greg
-
