From: | Eduardo Piombino <drakorg(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | PGSQL Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: select now() problem? |
Date: | 2010-09-02 18:15:57 |
Message-ID: | AANLkTi=G1+DSyWDp_eXHSPGuVAvnTEwqo6TS56uDdzXV@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>The only difference from the database point of view, is that PCs
transactions, since they are much more complex, usually start with a
ROLLBACK (arguable, it will be eventually removed) and for devices they
usually just start with a COMMIT.
Correction ... and for devices they usually just start with a BEGIN
TRANSACTION.
Real thing is that when this happens, I'm several kilometers away, with no
remote access (yet at least), and since it is a production system as soon as
something like this happens they need to get it back up asap. I find it
extremely difficult to be able to gather that data. Besides that I'm not
familiar with the procedure of attaching to someone else's process in
windows.
It is a 8.4.2 postgres running in windows 2003 server.
Im tempted in upgrading to 8.4.latest, since it should not require a full
backup/restore and practically no server downtime.
But i'm not sure about the real gain of that.
On Thu, Sep 2, 2010 at 2:56 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Eduardo Piombino <drakorg(at)gmail(dot)com> writes:
> > Do you have any idea on what could be causing a SELECT NOW() to never
> come
> > back?
>
> That's truly bizarre. Can you attach to one of these stuck processes
> with a debugger and get a stack trace?
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | Phil Jackson | 2010-09-02 21:12:31 | Problems with ODBC Driver |
Previous Message | Tom Lane | 2010-09-02 17:56:34 | Re: select now() problem? |