[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Database down

To: Michael Sallman <msallman@pro-ns.net>
Subject: Re: Database down
From: Peter Mount <peter@retep.org.uk>
Date: Thu, 22 Jul 2004 11:31:18 +0100
Cc: Tass <tass@listserv.wwa.com>
In-reply-to: <40FF1841.8090909@pro-ns.net>
References: <40FF1841.8090909@pro-ns.net>
Sender: owner-tass@listserv.wwa.com
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040510

Michael Sallman wrote:
> Hi guys.
> 
> It looks like the database blew up! Well, probably not really.
> I was processing the new data from TR 20, and it looks like the script 
> just stopped loading the data, being unable to access one of the tables 
> in the database.
> Consequently, the database may be down for a while as I try to figure 
> out what happened and fix the problem.

This sounds like another transaction had locked that table, and the 
transaction was still open.

A normal update would lock a single row, but some (like vacuum) do lock 
the entire table.

One place to look.

Peter


-- 
Peter Mount
peter@retep.org.uk
http://retep.org/
http://retep.net/
    Tel: +44 (0) 1622 749439
    Fax: +44 (0) 8701 361620
Mobile: +44 (0) 7838 191423
IM-MSN: retep207@hotmail.com

References:
- Database down
  - From: Michael Sallman <msallman@pro-ns.net>

Prev by Date: Database down
Next by Date: List Test
Prev by thread: Database down
Next by thread: List Test
Index(es):
- Date
- Thread