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

Re: "Cannot prepare error statement" error



On Thu, Oct 16, 2008 at 11:24 AM, Chris Travers <..hidden..> wrote:
> On Thu, Oct 16, 2008 at 9:19 AM, David A. Bandel <..hidden..> wrote:
>
>> I've seen this with a client.  They _insist_ on double-clicking on everything.
>
> Ok.  A couple of other questions occur to me.
>
> 1)  Are either of these installations running mod_perl?

No.

>
> 2)  Are either of these installations running apache with an MPM other
> than prefork?  IIS?  Any other multi-threaded web server?

No.  Apache 1.3 plain vanilla install with -ssl.

>
> Currently we support the latter but not the former (the scripts must
> be run via CGI), but if this is a concurrency problem, this would
> suggest a shared process space.

Chris, I didn't submit this as a bug because I don't consider it a
bug.  This is PEBCAK, plain and simple.  It is 100% reproducible if
you quickly click twice or more on a link that executes a SQL query.

I discovered this when a client told me they got this error a lot, but
I couldn't reproduce it.  Drove out, and when I saw their finger
bounce twice on the mouse button I realized what was happening.  After
that I could reproduce it anywhere, anytime just by doing the same
thing (as long as the link executed a SQL query).

I fixed the problem with a hammer (threatened to use it on their
fingers if they clicked more than once).

Ciao,

David A. Bandel
-- 
Focus on the dream, not the competition.
            - Nemesis Air Racing Team motto