Problem with DBI

------_=_NextPart_001_01C6AF1B.8E2016D8
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi, I'm seeing the following warning message from DBIx::ContextualFetch
intermittently.
Use of uninitialized value in null operation at
/usr/local/lib/perl5/site_perl/5.8.6/DBIx/ContextualFetch.pm line 51.=20

What does it mean? Sorry, I am not in a position to provide a simple
test case as I still can't reproduce the problem at will.

palisetk@desa0587.nyc:~$ perl -MDBI -e 'DBI->installed_versions;'
Perl : 5.008006 (i86pc-solaris)
OS : solaris (2.10)
DBI : 1.48
DBD::XBase : 0.241
DBD::Sybase : 1.02_01
DBD::Sponge : 11.10
DBD::SQLite : 1.09
DBD::Proxy : 0.2004
DBD::ODBC : 1.13
DBD::Multiplex : 1.96
DBD::FreeTDS : 0.13
DBD::File : 0.33
DBD::Excel : 0.06
DBD::ExampleP : 11.12
DBD::DBM : 0.02
DBD::CSV : 0.22
palisetk@desa0587.nyc:~$

Let me know if you need more info on this.

Thanks,
Mohan

------_=_NextPart_001_01C6AF1B.8E2016D8--

RE: Problem with DBI

Palisetti, Krishna_Mohan wrote:
> Hi, I'm seeing the following warning message from
> DBIx::ContextualFetch intermittently.
> Use of uninitialized value in null operation at
> /usr/local/lib/perl5/site_perl/5.8.6/DBIx/ContextualFetch.pm line 51.
>=20
> What does it mean? Sorry, I am not in a position to provide a simple
> test case as I still can't reproduce the problem at will.
>=20
> palisetk@desa0587.nyc:~$ perl -MDBI -e 'DBI->installed_versions;'
> Perl : 5.008006 (i86pc-solaris)
> OS : solaris (2.10)
> DBI : 1.48

What version of DBIx::ContextualFetch do you have installed?

perl -MDBIx::ContextualFetch -le 'print
$DBIx::ContextualFetch::VERSION'

Philip

RE: Problem with DBI

Thanks for looking into this.

palisetk@desa0587.nyc:~$ perl -MDBIx::ContextualFetch -le 'print
$DBIx::ContextualFetch::VERSION'
1.02
palisetk@desa0587.nyc:~$

-----Original Message-----
From: Garrett, Philip (MAN-Corporate)
[mailto:Philip.Garrett@manheim.com]=20
Sent: Monday, July 24, 2006 7:37 PM
To: Palisetti, Krishna_Mohan; dbi-users@perl.org
Subject: RE: Problem with DBI


Palisetti, Krishna_Mohan wrote:
> Hi, I'm seeing the following warning message from=20
> DBIx::ContextualFetch intermittently. Use of uninitialized value in=20
> null operation at=20
> /usr/local/lib/perl5/site_perl/5.8.6/DBIx/ContextualFetch.pm line 51.
>=20
> What does it mean? Sorry, I am not in a position to provide a simple=20
> test case as I still can't reproduce the problem at will.
>=20
> palisetk@desa0587.nyc:~$ perl -MDBI -e 'DBI->installed_versions;'
> Perl : 5.008006 (i86pc-solaris)
> OS : solaris (2.10)
> DBI : 1.48

What version of DBIx::ContextualFetch do you have installed?

perl -MDBIx::ContextualFetch -le 'print
$DBIx::ContextualFetch::VERSION'

Philip

RE: Problem with DBI

Palisetti, Krishna_Mohan wrote:
>>
>>> Hi, I'm seeing the following warning message from
>>> DBIx::ContextualFetch intermittently. Use of uninitialized value in
>>> null operation at
>>> /usr/local/lib/perl5/site_perl/5.8.6/DBIx/ContextualFetch.pm line
>>> 51. =20
>>>=20
>>> What does it mean? Sorry, I am not in a position to provide a simple
>>> test case as I still can't reproduce the problem at will.
>>>=20
>>> palisetk@desa0587.nyc:~$ perl -MDBI -e 'DBI->installed_versions;'
>>> Perl : 5.008006 (i86pc-solaris)
>>> OS : solaris (2.10)
>>> DBI : 1.48
>>=20
>> What version of DBIx::ContextualFetch do you have installed?
>=20
> palisetk@desa0587.nyc:~$ perl -MDBIx::ContextualFetch -le 'print
> $DBIx::ContextualFetch::VERSION'
> 1.02

I can't be sure, but it looks like it's probably a bug in the DBD you're
using. What driver are you using with this connection? Is it the
latest version?

Philip=20

RE: Problem with DBI

We are using, DBD::Sybase v1.02_01. The latest one seems to be v1.07. We
could try the upgrade but it would be difficult to convince the
production group unless we can say for sure that the latest version
addresses this problem.

cc:ing the author to see if he has something to offer.

-Mohan

-----Original Message-----
From: Garrett, Philip (MAN-Corporate)
[mailto:Philip.Garrett@manheim.com]=20
Sent: Monday, July 24, 2006 8:17 PM
To: Palisetti, Krishna_Mohan; dbi-users@perl.org
Subject: RE: Problem with DBI


Palisetti, Krishna_Mohan wrote:
>>
>>> Hi, I'm seeing the following warning message from=20
>>> DBIx::ContextualFetch intermittently. Use of uninitialized value in=20
>>> null operation at=20
>>> /usr/local/lib/perl5/site_perl/5.8.6/DBIx/ContextualFetch.pm line=20
>>> 51.
>>>=20
>>> What does it mean? Sorry, I am not in a position to provide a simple

>>> test case as I still can't reproduce the problem at will.
>>>=20
>>> palisetk@desa0587.nyc:~$ perl -MDBI -e 'DBI->installed_versions;'
>>> Perl : 5.008006 (i86pc-solaris)
>>> OS : solaris (2.10)
>>> DBI : 1.48
>>=20
>> What version of DBIx::ContextualFetch do you have installed?
>=20
> palisetk@desa0587.nyc:~$ perl -MDBIx::ContextualFetch -le 'print=20
> $DBIx::ContextualFetch::VERSION' 1.02

I can't be sure, but it looks like it's probably a bug in the DBD you're
using. What driver are you using with this connection? Is it the
latest version?

Philip=20

RE: Problem with DBI

Palisetti, Krishna_Mohan wrote:
>>>>> Hi, I'm seeing the following warning message from
>>>>> DBIx::ContextualFetch intermittently. Use of uninitialized value
>>>>> in null operation at
>>>>> /usr/local/lib/perl5/site_perl/5.8.6/DBIx/ContextualFetch.pm line
>>>>> 51.
>>>>>=20
>>>>> What does it mean? Sorry, I am not in a position to provide a
>>>>> simple test case as I still can't reproduce the problem at will.
>>>>>=20
>>>>> palisetk@desa0587.nyc:~$ perl -MDBI -e 'DBI->installed_versions;'
>>>>> Perl : 5.008006 (i86pc-solaris)
>>>>> OS : solaris (2.10)
>>>>> DBI : 1.48
>>>>=20
>>>> What version of DBIx::ContextualFetch do you have installed?
>>>=20
>>> palisetk@desa0587.nyc:~$ perl -MDBIx::ContextualFetch -le 'print
>>> $DBIx::ContextualFetch::VERSION' 1.02
>>=20
>> I can't be sure, but it looks like it's probably a bug in the DBD
>> you're using. What driver are you using with this connection? Is it
>> the latest version?
>
> We are using, DBD::Sybase v1.02_01. The latest one seems to be v1.07.
> We could try the upgrade but it would be difficult to convince the
> production group unless we can say for sure that the latest version
> addresses this problem.

You could try to install the latest version in a temporary test location
in your dev area and test that.

mkdir /tmp/dbd-syb-latest
perl Makefile.PL INSTALLSITELIB=3D/tmp/dbd-syb-latest
make test && make install

# from shell
export PERL5LIB=3D$HOME/dbd-syb-latest:$PERL5LIB
./your-script.pl

# from Apache:
SetEnv PERL5LIB /tmp/dbd-syb-latest
PassEnv PERL5LIB
PerlPassEnv PERL5LIB

Philip

RE: Problem with DBI

Hi,

I have no knowledge of the DBIx::ContextualFetch module, and so have no
idea whether upgrading DBD::Sybase could fix the problem.
The issue could be related to multiple-result sets, or to some other
Sybase-specific issue that isn't handled properly by DBIx::ContextualFetch,
or maybe something else entirely...

Michael




Extranet
Krishna.Mohan.Palisetti@deshaw.com - 24/07/2006 17:27

To: Philip.Garrett, dbi-users

cc: mpeppler


Subject: RE: Problem with DBI


We are using, DBD::Sybase v1.02_01. The latest one seems to be v1.07. We
could try the upgrade but it would be difficult to convince the
production group unless we can say for sure that the latest version
addresses this problem.

cc:ing the author to see if he has something to offer.

-Mohan

-----Original Message-----
From: Garrett, Philip (MAN-Corporate)
[mailto:Philip.Garrett@manheim.com]
Sent: Monday, July 24, 2006 8:17 PM
To: Palisetti, Krishna_Mohan; dbi-users@perl.org
Subject: RE: Problem with DBI


Palisetti, Krishna_Mohan wrote:
>>
>>> Hi, I'm seeing the following warning message from
>>> DBIx::ContextualFetch intermittently. Use of uninitialized value in
>>> null operation at
>>> /usr/local/lib/perl5/site_perl/5.8.6/DBIx/ContextualFetch.pm line
>>> 51.
>>>
>>> What does it mean? Sorry, I am not in a position to provide a simple

>>> test case as I still can't reproduce the problem at will.
>>>
>>> palisetk@desa0587.nyc:~$ perl -MDBI -e 'DBI->installed_versions;'
>>> Perl : 5.008006 (i86pc-solaris)
>>> OS : solaris (2.10)
>>> DBI : 1.48
>>
>> What version of DBIx::ContextualFetch do you have installed?
>
> palisetk@desa0587.nyc:~$ perl -MDBIx::ContextualFetch -le 'print
> $DBIx::ContextualFetch::VERSION' 1.02

I can't be sure, but it looks like it's probably a bug in the DBD you're
using. What driver are you using with this connection? Is it the
latest version?

Philip




This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and
immediately notify the sender. Any use not in accord with
its purpose, any dissemination or disclosure, either whole
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message.
BNP PARIBAS (and its subsidiaries) shall (will) not
therefore be liable for the message if modified.

---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses
destinataires et sont confidentiels. Si vous recevez ce
message par erreur, merci de le detruire et d'en avertir
immediatement l'expediteur. Toute utilisation de ce
message non conforme a sa destination, toute diffusion
ou toute publication, totale ou partielle, est interdite, sauf
autorisation expresse. L'internet ne permettant pas
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce
message, dans l'hypothese ou il aurait ete modifie.

RE: Problem with DBI

This part of DBIx::ContextualFetch is just a statement handle subclass.
It's trying to call $sth->SUPER::execute() which is where the error is
occurring. I suppose it could be something about DBI instead of
DBD::Sybase, but I use DBIx::ContextualFetch with Oracle and I've never
seen the error.

The offending code:
46 # local $sth->{Taint} leaks in old perls :(
47 sub _untaint_execute {
48 my $sth =3D shift;
49 my $old_value =3D $sth->{Taint};
50 $sth->{Taint} =3D 0;
51 my $ret =3D $sth->SUPER::execute(@_);
52 $sth->{Taint} =3D $old_value;
53 return $ret;
54 }

Philip

michael.peppler@bnpparibas.com wrote:
> Hi,
>=20
> I have no knowledge of the DBIx::ContextualFetch module, and so have
> no idea whether upgrading DBD::Sybase could fix the problem.
> The issue could be related to multiple-result sets, or to some other
> Sybase-specific issue that isn't handled properly by
> DBIx::ContextualFetch, or maybe something else entirely...
>=20
> Michael
>=20
>=20
> Extranet
> Krishna.Mohan.Palisetti@deshaw.com - 24/07/2006 17:27
>=20
> We are using, DBD::Sybase v1.02_01. The latest one seems to be v1.07.
> We could try the upgrade but it would be difficult to convince the
> production group unless we can say for sure that the latest version
> addresses this problem.
>=20
> cc:ing the author to see if he has something to offer.
>=20
> -Mohan
>=20
> -----Original Message-----
> From: Garrett, Philip (MAN-Corporate)
> [mailto:Philip.Garrett@manheim.com]
> Sent: Monday, July 24, 2006 8:17 PM
> To: Palisetti, Krishna_Mohan; dbi-users@perl.org
> Subject: RE: Problem with DBI
>=20
>=20
> Palisetti, Krishna_Mohan wrote:
>>>=20
>>>> Hi, I'm seeing the following warning message from
>>>> DBIx::ContextualFetch intermittently. Use of uninitialized value
>>>> in null operation at
>>>> /usr/local/lib/perl5/site_perl/5.8.6/DBIx/ContextualFetch.pm line=20
>>>> 51.
>>>>=20
>>>> What does it mean? Sorry, I am not in a position to provide a
>>>> simple=20
>=20
>>>> test case as I still can't reproduce the problem at will.
>>>>=20
>>>> palisetk@desa0587.nyc:~$ perl -MDBI -e 'DBI->installed_versions;'
>>>> Perl : 5.008006 (i86pc-solaris)
>>>> OS : solaris (2.10)
>>>> DBI : 1.48
>>>=20
>>> What version of DBIx::ContextualFetch do you have installed?
>>=20
>> palisetk@desa0587.nyc:~$ perl -MDBIx::ContextualFetch -le 'print
>> $DBIx::ContextualFetch::VERSION' 1.02
>=20
> I can't be sure, but it looks like it's probably a bug in the DBD
> you're using. What driver are you using with this connection? Is it
> the=20
> latest version?
>=20
> Philip

RE: Problem with DBI

On Tue, 2006-07-25 at 09:44 -0400, Garrett, Philip (MAN-Corporate)
wrote:
> This part of DBIx::ContextualFetch is just a statement handle subclass.
> It's trying to call $sth->SUPER::execute() which is where the error is
> occurring. I suppose it could be something about DBI instead of
> DBD::Sybase, but I use DBIx::ContextualFetch with Oracle and I've never
> seen the error.
>
> The offending code:
> 46 # local $sth->{Taint} leaks in old perls :(
> 47 sub _untaint_execute {
> 48 my $sth = shift;
> 49 my $old_value = $sth->{Taint};
> 50 $sth->{Taint} = 0;
> 51 my $ret = $sth->SUPER::execute(@_);
> 52 $sth->{Taint} = $old_value;
> 53 return $ret;
> 54 }

Thanks for the detail.

However, as I've never seen that error with DBD::Sybase on its own and I
don't really know what it refers to there isn't all that much that I can
do at this point.

If the OP can provide me with a trace that illustrates the problem then
it may be possible to identify the issue.

Michael
--
Michael Peppler - Peppler Consulting SaRL
mpeppler@peppler.org - http://www.peppler.org/
Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com/
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html