[ic] PostgreSQL 8.3

[Jon Jensen]

On Thu, 19 Jun 2008, Rick Bragg wrote:

> 2008-06-19 08:57:11 EDT LOG:  00000: statement: SELECT * FROM country WHERE 2 = 1
> 2008-06-19 08:57:11 EDT LOCATION:  exec_simple_query, postgres.c:845
> 2008-06-19 08:57:11 EDT LOG:  00000: duration: 0.606 ms
> 2008-06-19 08:57:11 EDT LOCATION:  exec_simple_query, postgres.c:1051
> 2008-06-19 08:57:11 EDT LOG:  00000: statement: SELECT * FROM categories WHERE 2 = 1
> 2008-06-19 08:57:11 EDT LOCATION:  exec_simple_query, postgres.c:845
> 2008-06-19 08:57:11 EDT LOG:  00000: duration: 13.645 ms
> 2008-06-19 08:57:11 EDT LOCATION:  exec_simple_query, postgres.c:1051
> 2008-06-19 08:57:11 EDT LOG:  00000: statement: SELECT * FROM affiliate WHERE 2 = 1
> 2008-06-19 08:57:11 EDT LOCATION:  exec_simple_query, postgres.c:845
> 2008-06-19 08:57:11 EDT LOG:  00000: duration: 1.026 ms
> 2008-06-19 08:57:11 EDT LOCATION:  exec_simple_query, postgres.c:1051
> 2008-06-19 08:59:07 EDT LOG:  08P01: unexpected EOF on client connection
> 2008-06-19 08:59:07 EDT LOCATION:  SocketBackend, postgres.c:323
> 2008-06-19 08:59:07 EDT LOG:  00000: disconnection: session time: 0:01:56.460 user=harris database=harrisdev host=[local]
> 2008-06-19 08:59:07 EDT LOCATION:  log_disconnections, postgres.c:3958
>
> There are a bunch of these statements (one for each table it seems) then 
> it hangs. then when I kill IC, it generates the last 4 lines of the 
> above.
>
> I'm sure it is something with my catalog (not Pg, or IC) because this is 
> a migration from 5.4.2...

Something seriously odd is going on. I recommend you turn on DBI DataTrace 
in interchange.cfg so you can see what SQL is coming from the client side 
at the time your Interchange server is hanging, and try to pair that with 
the Postgres log.

Jon

-- 
Jon Jensen
End Point Corporation
http://www.endpoint.com/