Re: Bizarre ASE bug triggered by latest test DBD::Sybase
Michael Peppler <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.dbi.sybase |
|---|---|
| Message-ID | <[email protected]> |
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 > Sybase. Do you have statement caching turned on for that server? I haven't had time to try to reproduce it yet... Michael -- Michael Peppler - [email protected] - http://www.peppler.org/ Sybase DBA/Developer Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html