Re: [Lxr-dev] Further testing

[Jan-Benedict G. <jb...@lu...>]

On Sun, 2001-08-19 17:11:50 +0200, Jan-Benedict Glaw <jb...@lu...>
wrote in message <200...@lu...>:
> On Sun, 2001-08-19 23:40:42 +0900, Malcolm Box <ma...@br...>
> wrote in message <3B7...@br...>:
> > Jan-Benedict Glaw wrote:
> > > 10874 pts/0    S      0:00  \_ postgres: www-data lxr-cvs [local] idle in transaction
> > 
> > So you're seeing idle postgres processes during a execution of
> > "source"?  I don't know enough about psql to know if this is normal, nor
> > what sort of error this is.  Do you have any clues?
> 
> If I remember correctly you can see this between sending a request
> and fetching the last resulting row. So you haven't fetched all
> the data.

Testing some more lets me conclude that you see this if you only
have an opened connection which served some data at any given time
before. So this is a stale (once used, but not closed) DB handle
on Perl's DBI side.

MfG, JBG

-- 
Jan-Benedict Glaw . jb...@lu... . +49-172-7608481