Re: "Cannot prepare error statement" error

["Chris Travers" <..hidden..>]

On Thu, Oct 16, 2008 at 3:14 AM, ..hidden.. <..hidden..> wrote:
> I'm getting the same issue.
> *
> menu.pl:88: Cannot prepare empty statement at /usr/lib/perl5/DBD/Pg.pm
> line 249.
>
> *I increased the timeout and that doesn't appear help. I can't reliably
> reproduce the error but it doesn't seem to be limited by inactivity. If
> I randomly click pages then shortly I will get the error, and a relog is
> required.
>
> The database is logging lines like:
> 2008-10-15 20:12:49 BST LOG:  could not receive data from client:
> Connection reset by peer
> 2008-10-15 20:12:49 BST LOG:  unexpected EOF on client connection
>
> This is a fresh install from a Debian package.
> Package: ledgersmb
> Version: 1.2.16-1

I have never seen this problem before.  However, this looks like a
hardware or a libpq or a DBD::Pg library issue.  I.e. what is
evidently happening is that the connection from the CGI script to the
db is dropping for some reason.  This could be caused by a network
issue between the web and database servers if they are on separate
boxes, a kernel issue (involving networking support), or a library
which sits between the systems (these are, in order, DBI, DBD::Pg, and
libpq).  As I have never had issues of this sort from the Linux kernel
in the absence of hardware failures, I am inclined to look to other
causes first.

Typically everything we do is quite a bit higher on the stack than
resetting network connections, so this is unlikely to be an issue with
LSMB.

Best Wishes,
Chris Travers