From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | SF Postgres <sfpug(at)postgresql(dot)org> |
Subject: | Re: Server crash on cancelling expensive query. |
Date: | 2006-06-14 22:45:24 |
Message-ID: | 20060614224524.GB22741@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | sfpug |
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!
From | Date | Subject | |
---|---|---|---|
Next Message | Jon Asher | 2006-06-14 23:17:03 | Startup needs Apache help |
Previous Message | Steve Atkins | 2006-06-14 22:33:19 | Re: Server crash on cancelling expensive query. |