Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: Bizarre ASE bug triggered by latest test DBD::Sybase
Date: Apr 26 2005 6:24PM
On Mon, 2005-04-25 at 18:32, Avis, Ed wrote:
> I believe the current (1.05.xx) test release of DBD::Sybase has changed
> to use 'chained mode' if AutoCommit is off. This has tickled a Sybase
> bug which didn't appear with earlier DBD::Sybase versions. Here's the
> test program:
> This gives the error
> DBD::Sybase::db do failed: Server message number=7713 severity=16 state=2 line=1 server=IT_LN text=Stored procedure '*ss1492368299_0739474268ss*' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode.
> Bizarre - I didn't call any stored procedure. What is odder still is
> that any change to the SQL text, even adding a newline on the end, stops
> the error happening. So I suspect some horrible memory trampling inside
Do you have statement caching turned on for that server?
I haven't had time to try to reproduce it yet...
Michael Peppler - firstname.lastname@example.org - http://www.peppler.org/
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html