Search Postgresql Archives

Re: 7.3.2 closing connections, sometimes

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

 



On Wed, Jul 06, 2005 at 02:32:31PM -0400, Bruce Momjian wrote:
> 
> This message is from the backend exiting abruptly.  Is isn't an "ERROR"
> as we define it for logging purposes.  That's why there is nothing in
> the logs.  I recommend turning on log_statement which prints before the
> query is run.

I hadn't thought of the error that way.  I do have query logging on,
and if I run that query directly, it finds the data I'd expect.  It's
a small table, or really three of them, all small for the time being.

    select it.id, it.it_class_id, it.it_code_version_id,
    it.it_data_version, it.note, it_class.class, it_class.id,
    it_code_version.version, it_code_version.id, it_class.id,
    it_code_version.id from it join it_class on (it_class.id =
    it.it_class_id) join it_code_version on (it_code_version.id =
    it.it_code_version_id) where class = ? AND version = ? AND
    it_data_version > ?

-- 
            ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
     Felix Finch: scarecrow repairman & rocket surgeon / felix@xxxxxxxxxxx
  GPG = E987 4493 C860 246C 3B1E  6477 7838 76E9 182E 8151 ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux