-------------8<---------- Start Bug Report ------------8<----------
1. Problem Description:

I'm trying to use stored procedures in a mysql database from within a perl
script.
A simple test script runs fine from a command-line perl interpreter, and
runs fine
when invoked via CGI.

The same script always fails when run under mod_perl, receiving:
ERROR: 1312 'PROCEDURE ceres_bt.create_inventory_lot can't return a result
set in the given context'

I'm running a patched version of DBD::mysql 3.0006 which supports
mysql_multi_results and mysql_multi_statements.

DBI tracing shows mysql_dr_connect is passed client_flags = 196610, which
seems to confirm the patched
version is invoked.

2. Used Components and their Configuration:

*** mod_perl version 2.000002

*** using /usr/lib/perl5/Apache2/BuildConfig.pm

*** Makefile.PL options:
MP_APR_LIB => aprext
MP_APXS => /usr/bin/apxs2
MP_CCOPTS => -g -Wall
MP_COMPAT_1X => 1
MP_GENERATE_XS => 1
MP_INCLUDE_DIR => /usr/include/apache2 /usr/include/apr-0
MP_LIBNAME => mod_perl
MP_TRACE => 0
MP_USE_DSO => 1
MP_USE_GTOP => 1
MP_USE_STATIC => 0

*** The httpd binary was not found

*** (apr|apu)-config linking info

-L/usr/lib -laprutil-0 -lldap -llber -ldb-4.3 -lexpat
-L/usr/lib -lapr-0 -lrt -lm -lcrypt -lnsl -lpthread -ldl

*** /usr/bin/perl -V
Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
Platform:
osname=linux, osvers=2.6.15.4, archname=i486-linux-gnu-thread-multi
uname='linux ninsei 2.6.15.4 #1 smp preempt mon feb 20 09:48:53 pst 2006
i686 gnulinux '
config_args='-Dusethreads -Duselargefiles -Dccflags=-DDEBIAN
-Dcccdlflags=-fPIC -Darchname=i486-linux-gnu -Dprefix=/usr
-Dprivlib=/usr/share/perl/5.8 -Darchlib=/usr/lib/perl/5.8
-Dvendorprefix=/usr -Dvendorlib=/usr/share/perl5 -Dvendorarch=/usr/lib/perl5
-Dsiteprefix=/usr/local -Dsitelib=/usr/local/share/perl/5.8.8
-Dsitearch=/usr/local/lib/perl/5.8.8 -Dman1dir=/usr/share/man/man1
-Dman3dir=/usr/share/man/man3 -Dsiteman1dir=/usr/local/man/man1
-Dsiteman3dir=/usr/local/man/man3 -Dman1ext=1 -Dman3ext=3perl
-Dpager=/usr/bin/sensible-pager -Uafs -Ud_csh -Uusesfio -Uusenm -Duseshrplib
-Dlibperl=libperl.so.5.8.8 -Dd_dosuid -des'
hint=recommended, useposix=true, d_sigaction=define
usethreads=define use5005threads=undef useithreads=define
usemultiplicity=define
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='cc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS
-DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64',
optimize='-O2',
cppflags='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBIAN
-fno-strict-aliasing -pipe -I/usr/local/include'
ccversion='', gccversion='4.0.3 (Debian 4.0.3-1)', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=4, prototype=define
Linker and Libraries:
ld='cc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib
libs=-lgdbm -lgdbm_compat -ldb -ldl -lm -lpthread -lc -lcrypt
perllibs=-ldl -lm -lpthread -lc -lcrypt
libc=/lib/libc-2.3.6.so, so=so, useshrplib=true,
libperl=libperl.so.5.8.8
gnulibc_version='2.3.6'
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
cccdlflags='-fPIC', lddlflags='-shared -L/usr/local/lib'


Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY PERL_IMPLICIT_CONTEXT
PERL_MALLOC_WRAP THREADS_HAVE_PIDS USE_ITHREADS
USE_LARGE_FILES USE_PERLIO USE_REENTRANT_API
Built under linux
Compiled at Apr 4 2006 22:23:52
%ENV:
PERL_LWP_USE_HTTP_10="1"
[at] INC:
/etc/perl
/usr/local/lib/perl/5.8.8
/usr/local/share/perl/5.8.8
/usr/lib/perl5
/usr/share/perl5
/usr/lib/perl/5.8
/usr/share/perl/5.8
/usr/local/lib/site_perl
.

*** Packages of interest status:

Apache2 : -
Apache2::Request : 2.07
CGI : 3.15
ExtUtils::MakeMaker: 6.30
LWP : 5.803
mod_perl : -
mod_perl2 : 2.000002


3. This is the core dump trace: (if you get a core dump):

[CORE TRACE COMES HERE]

This report was generated by /usr/bin/mp2bug on Wed Jul 26 18:57:19 2006
GMT.

-------------8<---------- End Bug Report --------------8<----------

> -------------8<---------- Start Bug Report ------------8<----------
> 1. Problem Description:
>
> I'm trying to use stored procedures in a mysql database from within a =
perl
> script.
> A simple test script runs fine from a command-line perl interpreter, =
and
> runs fine
> when invoked via CGI.
>
> The same script always fails when run under mod_perl, receiving:
> ERROR: 1312 'PROCEDURE ceres_bt.create_inventory_lot can't return a =
result
> set in the given context'

Has someone replied to this? If so, sorry for this double post. If not: =
this is not a mod_perl bug. It is caused by an imcompatibility between =
DBD::MySQL (production branch) and new features in MySQL, see =
http://forums.mysql.com/read.php?51,63934,63934#msg-63934. As you can =
see from http://www.nntp.perl.org/group/perl.dbi.announce/298, support =
for resultsets from procedures is available through the development =
version (3.0006_1).

Regards,
Frank

Thanks for your reply; it is the only one so far. I will give 3.0006_1 a
try, but I'm not hopeful, as I think we probably are dealing with a mod_perl
bug. I am using 3.0006, but as I stated it has been patched for multiple
result set (procedure) support, and it is calling procedures successfully in
both straight Perl command line use and via fcgid.

-----Original Message-----
From: Frank Maas [mailto:frank.maas [at] cheiron-it.nl]
Sent: Monday, July 31, 2006 5:16 AM
To: jhl [at] bonipak.com; modperl [at] perl.apache.org
Subject: RE: Can't use mysql stored procedures under mod_perl (although they
work directly from Perl)

> -------------8<---------- Start Bug Report ------------8<----------
> 1. Problem Description:
>
> I'm trying to use stored procedures in a mysql database from within a perl
> script.
> A simple test script runs fine from a command-line perl interpreter, and
> runs fine
> when invoked via CGI.
>
> The same script always fails when run under mod_perl, receiving:
> ERROR: 1312 'PROCEDURE ceres_bt.create_inventory_lot can't return a result
> set in the given context'

Has someone replied to this? If so, sorry for this double post. If not: this
is not a mod_perl bug. It is caused by an imcompatibility between DBD::MySQL
(production branch) and new features in MySQL, see
http://forums.mysql.com/read.php?51,63934,63934#msg-63934. As you can see
from http://www.nntp.perl.org/group/perl.dbi.announce/298, support for
resultsets from procedures is available through the development version
(3.0006_1).

Regards,
Frank



!DSPAM:44cdf48833612134717754!