Re: Server crash on cancelling expensive query.

On Wed, Jun 14, 2006 at 03:12:33PM -0700, Larry Wissink wrote:
> Hi all,
>
> I'm not sure what the proper protocol for this question is, but here
> goes:
>
> A developer at my company was running some queries that shouldn't
> have been run because they selected from a very large table and
> ordered by an unindexed field. The odd thing is that when the
> developer cancelled the query the whole server rebooted.

Sounds like hardware problems. If you're lucky, it's just bad RAM.

> Details on crash:
>
> Postgres Version 7.4.7 (Yes I know that's very old. I'm sure an
> upgrade will fix the problem.)

I'm not, but it will fix other problems. You can do the upgrade now
that you have some down time ;)

Cheers,
D
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!