Re: DBD::Sybase question
You can interact with an ASE 15 server with a 12.5.1 client with no particular problems. There may be some issues with the more esoteric OpenClient functionality, but as DBD::Sybase doesn't use this it shouldn't be a problem. So the short answer is that you can keep your current environment and add the ASE 15 server to the interfaces file. Moving forward however you should consider upgrading the client and DBD::Sybase, so to answer your other questions: - DBD::Sybase 1.00 will not build with OCS 15 due to changes in the library names (and maybe other problems as well - I have never tried it). - A DBD::Sybase binary should only be used at run-time with the same OCS version that was used to build it (note: EBF changes are OK without a rebuild) - To have multiple DBD::Sybase binaries with a single perl installation you need to set the PERL5_LIB env. variable or use the use lib directive in your scripts to point to the directory that holds the DBD::Sybase binary that you want to use. It is certainly feasible, but you obviously need to set something up so that these settings are automatic (i.e. you don't want to have to edit your scripts to set the correct environment :-) That being said I only have a 15.0 installation here, and use it to interface with all sorts of Sybase servers (including an antique 4.9.2 server!) and I have yet to see any problems. Michael Extranet [EMAIL PROTECTED] - 24/04/2006 10:14 To:dbi-users, sybperl-l cc: Subject:DBD::Sybase question Hi, We are conducting a proof of concept to upgrade Sybase ASE 12.5.1 and OpenClient 12.5.1 to Sybase ASE 15.0 and SDK 15.0 on Solaris 2.8. Our current environment details are as follows: Perl 5.005 (5.0 patchlevel 5 subversion 3) Sybase OC 12.5.1 Sybase ASE 12.5.1 DBI 1.37 DBD::Sybase 1.00 We'd like to retain Sybase 12.5.1 and it's perl environment as described above but create a new environment for Sybase 15.0.0 and have the following questions (any feedback will be greatly appreciated): - do we need an entirely separate perl, DBI and DBD installation for the Sybase 15.0.0 side of things? - do we need DBD::Sybase 1.07 for Sybase 15.0.0 - is there anyway we can use the same perl installation but point it to either DBD::Sybase 1.00 or DBD::Sybase 1.07 Thanks Regards, Minesh Thaker _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ http://www.dstinternational.com Notice: This e-mail and any attachments are intended only for the individual or company to which it is addressed and may contain information which is privileged, confidential and prohibited from disclosure or unauthorized use under applicable law. If you are not the intended recipient of this e-mail, you are hereby notified that any use, dissemination or copying of this e-mail or the information contained in this e-mail is strictly prohibited by the sender. Whilst we run anti-virus software on all internet e-mails we are not liable for any loss or damage. The recipient is advised to run their own anti-virus software. If you have received this transmission in error, please return the material received to the sender and delete all copies from your system. Thank you. 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.
Segmentation fault (core dumped) make test for t/50cursor.t
I realised people may not have been able to read my attachment from last time, so here it is again, but cut down, thanks, I've had a problem when I try to run the perl -Mblib t/50cursor.t in DBD-ORACLE 1.16. It just creates a core on the 8th test. I've tried 1.17 also and had the same problem so I've no idea what the problem could be, so I just thought I'd post here to see if it's something obvious. I've included my the output from the make test, also a truss of the perl -Mblib t/50cursor.t I'm using solaris 2.6 perl 5.8.1 DBI 1.5 oracle 8.0.3 Everything else should be included in my printouts. In the output deliminated by *** are perl -Mblib t/50cursor.t truss -e -a perl -Mblib t/50cursor.t perl -v perl -V Thanks, *** merlin:root:16perl -Mblib t/50cursor.t DynaLoader.pm loaded (/export/home/beacon/dave/pc/transfer/DBD-Oracle-1.16/blib/arch /export/home/beacon/dave/pc/transfer/DBD-Oracle-1.16/blib/lib /usr/local/lib/perl5/5.8.1/sun4-solaris /usr/local/lib/perl5/5.8.1 /usr/local/lib/perl5/site_perl/5.8.1/sun4-solaris /usr/local/lib/perl5/site_perl/5.8.1 /usr/local/lib/perl5/site_perl/5.6.2 /usr/local/lib/perl5/site_perl ., /usr/local/lib /usr/lib /usr/ccs/lib /u01/app/oracle/product/8.0.3/lib /usr/openwin/lib /opt/software/SUNWspro/lib /opt/lib /opt/software/hpnpl/lib) DynaLoader::bootstrap for DBI (auto/DBI/DBI.so) DynaLoader::bootstrap for List::Util (auto/List/Util/Util.so) DynaLoader::bootstrap for DBD::Oracle (auto/DBD/Oracle/Oracle.so) Max cursors: 46 1..462 opening cursors ok 1 opening cursor 1 ok 2 ok 3 ok 4 ok 5 ok 6 ok 7 Segmentation fault (core dumped) *** write(1, o k 7\n, 5) = 5 Incurred fault #6, FLTBOUNDS %pc = 0xEF10B458 siginfo: SIGSEGV SEGV_MAPERR addr=0x0010 Received signal #11, SIGSEGV [default] siginfo: SIGSEGV SEGV_MAPERR addr=0x0010 *** process killed *** *** merlin:root:18perl -v This is perl, v5.8.1 built for sun4-solaris Copyright 1987-2003, Larry Wall Perl may be copied only under the terms of either the Artistic License or the GNU General Public License, which may be found in the Perl 5 source kit. Complete documentation for Perl, including FAQ lists, should be found on this system using `man perl' or `perldoc perl'. If you have access to the Internet, point your browser at http://www.perl.com/, the Perl Home Page. *** merlin:root:19perl -V Summary of my perl5 (revision 5.0 version 8 subversion 1) configuration: Platform: osname=solaris, osvers=2.6, archname=sun4-solaris uname='sunos merlin 5.6 generic_105181-03 sun4m sparc sunw,sparcstation-20 ' config_args='-Dcc=gcc -des' hint=recommended, useposix=true, d_sigaction=define usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef useperlio=define d_sfio=undef uselargefiles=define usesocks=undef use64bitint=undef use64bitall=undef uselongdouble=undef usemymalloc=n, bincompat5005=undef Compiler: cc='gcc', ccflags ='-fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64', optimize='-O', cppflags='-fno-strict-aliasing -I/usr/local/include' ccversion='', gccversion='3.3.2', gccosandvers='solaris2.6' intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16 ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8 alignbytes=8, prototype=define Linker and Libraries: ld='gcc', ldflags =' -L/usr/local/lib ' libpth=/usr/local/lib /usr/lib /usr/ccs/lib libs=-lsocket -lnsl -ldb -ldl -lm -lc perllibs=-lsocket -lnsl -ldl -lm -lc libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a gnulibc_version='' Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' -z ignore -z lazyload -z combreloc' cccdlflags='-fPIC', lddlflags=' -G -z ignore -z lazyload -z combreloc -L/usr/local/lib' Characteristics of this binary (from libperl): Compile-time options: USE_LARGE_FILES Built under solaris Compiled at Apr 12 2006 10:40:51 %ENV: PERL_DL_DEBUG=2 @INC: /usr/local/lib/perl5/5.8.1/sun4-solaris /usr/local/lib/perl5/5.8.1 /usr/local/lib/perl5/site_perl/5.8.1/sun4-solaris /usr/local/lib/perl5/site_perl/5.8.1 /usr/local/lib/perl5/site_perl/5.6.2 /usr/local/lib/perl5/site_perl .
Re: DBD::Sybase question
Many thanks for the reply and the information Michael - it's been very
useful.
It may interest you to know that we've successfully been able to run our
regression tests (which use DBD::Sybase 1.00) without changing anything
EXCEPT following the Sybase SDK 15 documentation and running
$SYBASE/OCS-15_0/scripts/lnsyblibs create - which creates soft-links
under $SYBASE/OCS-15_0/lib for backward-compatability (as you quite rightly
pointed out that Sybase have changed their lib names by adding a 'syb'
suffix to each one - eg. libct.so is now libsybct.so - the soft-links allow
a preservation reference of 'libct.so').
By the way, please note that there seems to be a bug in
$SYBASE/OCS-15_0/scripts/lnsyblibs as follows:
BUG in red:
createlinks()
{
ls libsyb*.s[o|l] |\
awk '{
print ln -s $1 lib substr($1, 7, length($1) - 6)
}' | sh
}
FIX in blue:
createlinks()
{
ls libsyb*.s[ol] |\
awk '{
print ln -s $1 lib substr($1, 7, length($1) - 6)
}' | sh
}
Once again, many thanks for your valuable feedback.
Regards,
Minesh
[EMAIL PROTECTED]
npparibas.com
To
25/04/2006 07:07 [EMAIL PROTECTED]
cc
dbi-users@perl.org,
[EMAIL PROTECTED]
Subject
Re: DBD::Sybase question
You can interact with an ASE 15 server with a 12.5.1 client with no
particular problems. There may be some issues with the more esoteric
OpenClient functionality, but as DBD::Sybase doesn't use this it shouldn't
be a problem.
So the short answer is that you can keep your current environment and add
the ASE 15 server to the interfaces file.
Moving forward however you should consider upgrading the client and
DBD::Sybase, so to answer your other questions:
- DBD::Sybase 1.00 will not build with OCS 15 due to changes in the library
names (and maybe other problems as well - I have never tried it).
- A DBD::Sybase binary should only be used at run-time with the same OCS
version that was used to build it (note: EBF changes are OK without a
rebuild)
- To have multiple DBD::Sybase binaries with a single perl installation you
need to set the PERL5_LIB env. variable or use the use lib directive in
your scripts to point to the directory that holds the DBD::Sybase binary
that you want to use. It is certainly feasible, but you obviously need to
set something up so that these settings are automatic (i.e. you don't want
to have to edit your scripts to set the correct environment :-)
That being said I only have a 15.0 installation here, and use it to
interface with all sorts of Sybase servers (including an antique 4.9.2
server!) and I have yet to see any problems.
Michael
Extranet
[EMAIL PROTECTED] - 24/04/2006 10:14
To:dbi-users, sybperl-l
cc:
Subject:DBD::Sybase question
Hi,
We are conducting a proof of concept to upgrade Sybase ASE 12.5.1 and
OpenClient 12.5.1 to Sybase ASE 15.0 and SDK 15.0 on Solaris 2.8. Our
current environment details are as follows:
Perl 5.005 (5.0 patchlevel 5 subversion 3)
Sybase OC 12.5.1
Sybase ASE 12.5.1
DBI 1.37
DBD::Sybase 1.00
We'd like to retain Sybase 12.5.1 and it's perl environment as described
above but create a new environment for Sybase 15.0.0 and have the following
questions (any feedback will be greatly appreciated):
- do we need an entirely separate perl, DBI and DBD installation for the
Sybase 15.0.0 side of things?
- do we need DBD::Sybase 1.07 for Sybase 15.0.0
- is there anyway we can use the same perl installation but point it to
either DBD::Sybase 1.00 or DBD::Sybase 1.07
Thanks Regards,
Minesh Thaker
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
http://www.dstinternational.com
Notice: This e-mail and any attachments are intended only for the
individual
or company to which it is addressed and may contain information which is
privileged, confidential and prohibited from disclosure or unauthorized
use under applicable law. If
DBD-Oracle.ppd
Hi there, Im trying to access your FTP site at ftp://ftp.esoftmatic.com/outgoing/DBI to download DBD-Oracle.ppd for 5.8 but Im unable to get on the server. Every web link I've found thus far points to your repository, but I cant seem to ping the server or anything. Does this repo still exist? If not, could you possibly point me in the right direction to downloading the built ppd for Oracle? Your help is greatly appreciated, Ben Cole
RE: Oracle connect hangs forever
Get a 10046 trace of the process. This will tell you exactly what the DB is waiting for. I have had no issues with the TNS listener to date.l -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Scott T. Hildreth [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 25, 2006 2:28 PM To: dbi-users@perl.org Subject: Oracle connect hangs forever I plan on using Sys::SigAction to wrap an alarm around the connect, but I thought I would post to see if anyone else has seen this problem. I have a process that runs in cron every 2 minutes, it processes files that are ftp'd into our site. I set a lock file so that if the previous run is still running it will not start up and send an email indicating that a previous process is still running. Well we moved to this processing was moved to a new server which is running Oracle version 10.2.0.1.0. I've been having a problem where this process is hanging for serveral hours (occurs over night) until it is killed. I run an strace on the pid and it is hanging on a read of fd 6, which is the Oracle tns listener. I don't believe any thing has processed, because there are no raised errors. I think that it has to be hanging on the connect, since I believe the tns listener accepts a connection and then gives the connect process a direct socket to Oracle. As I stated earlier, I was wondering if anyone else on the list has problems with 10g tns listener? Perl: 5.008008(i686-linux) OS : linux (2.6.14.6) DBI : 1.50 DBD::mysql : 3.0002 DBD::Sponge : 11.10 DBD::SQLite : 1.11 DBD::Proxy : 0.2004 DBD::Oracle : 1.16 DBD::Multiplex : 1.98 DBD::File : 0.33 DBD::ExampleP : 11.12 DBD::DBM: 0.03 LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 25-APR-2006 15:27:25 Thanks, STH -- Scott T. Hildreth [EMAIL PROTECTED] This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
RE: Oracle connect hangs forever
On Tue, 2006-04-25 at 15:19 -0600, Reidy, Ron wrote: Get a 10046 trace of the process. This will tell you exactly what the DB is waiting for. What makes it worse or harder to track down is it seems to be momentary problem. While this process hangs, others are connecting no problem. It's almost as the Listener drops a packet or something to that effect and the DBI connect is still waiting for it to return. This is a high traffic DB so it may be easier to work around, unless the problem worsens. Trace files would be huge. I have had no issues with the TNS listener to date.l -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Scott T. Hildreth [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 25, 2006 2:28 PM To: dbi-users@perl.org Subject: Oracle connect hangs forever I plan on using Sys::SigAction to wrap an alarm around the connect, but I thought I would post to see if anyone else has seen this problem. I have a process that runs in cron every 2 minutes, it processes files that are ftp'd into our site. I set a lock file so that if the previous run is still running it will not start up and send an email indicating that a previous process is still running. Well we moved to this processing was moved to a new server which is running Oracle version 10.2.0.1.0. I've been having a problem where this process is hanging for serveral hours (occurs over night) until it is killed. I run an strace on the pid and it is hanging on a read of fd 6, which is the Oracle tns listener. I don't believe any thing has processed, because there are no raised errors. I think that it has to be hanging on the connect, since I believe the tns listener accepts a connection and then gives the connect process a direct socket to Oracle. As I stated earlier, I was wondering if anyone else on the list has problems with 10g tns listener? Perl: 5.008008(i686-linux) OS : linux (2.6.14.6) DBI : 1.50 DBD::mysql : 3.0002 DBD::Sponge : 11.10 DBD::SQLite : 1.11 DBD::Proxy : 0.2004 DBD::Oracle : 1.16 DBD::Multiplex : 1.98 DBD::File : 0.33 DBD::ExampleP : 11.12 DBD::DBM: 0.03 LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 25-APR-2006 15:27:25 Thanks, STH -- Scott T. Hildreth [EMAIL PROTECTED]
RE: Oracle connect hangs forever
-Original Message- From: Scott T. Hildreth [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 25, 2006 3:43 PM To: Reidy, Ron Cc: dbi-users@perl.org Subject: RE: Oracle connect hangs forever On Tue, 2006-04-25 at 15:19 -0600, Reidy, Ron wrote: Get a 10046 trace of the process. This will tell you exactly what the DB is waiting for. What makes it worse or harder to track down is it seems to be momentary problem. While this process hangs, others are connecting no problem. It's almost as the Listener drops a packet or something to that effect and the DBI connect is still waiting for it to return. This is a high traffic DB so it may be easier to work around, unless the problem worsens. Trace files would be huge. [rr] Do other processes experience this issue? I suggest this course of action because it only happens at a certain period of the day/night, and because you do not seem sure where the issue is. If the program cannot contact the DB (i.e. the dedicated server process is not created), then a trace file will show this (actually, it will show nothing). You could then move on to setting listener trace parameters. Of course, this runs the risk of creating many large files and slowing down your listener connections, but, at least you will be closer to discovering the problem. This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
RE: Oracle connect hangs forever
Hi, Note:340091.1 may be of interest to you concerning listener hanging on 10g. Regards, Michael Date: Tue, 25 Apr 2006 15:19:27 -0600 From: Reidy, Ron [EMAIL PROTECTED] To: [EMAIL PROTECTED], dbi-users@perl.org Subject: RE: Oracle connect hangs forever Get a 10046 trace of the process. This will tell you exactly what the DB is waiting for. I have had no issues with the TNS listener to date.l -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Scott T. Hildreth [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 25, 2006 2:28 PM To: dbi-users@perl.org Subject: Oracle connect hangs forever I plan on using Sys::SigAction to wrap an alarm around the connect, but I thought I would post to see if anyone else has seen this problem. I have a process that runs in cron every 2 minutes, it processes files that are ftp'd into our site. I set a lock file so that if the previous run is still running it will not start up and send an email indicating that a previous process is still running. Well we moved to this processing was moved to a new server which is running Oracle version 10.2.0.1.0. I've been having a problem where this process is hanging for serveral hours (occurs over night) until it is killed. I run an strace on the pid and it is hanging on a read of fd 6, which is the Oracle tns listener. I don't believe any thing has processed, because there are no raised errors. I think that it has to be hanging on the connect, since I believe the tns listener accepts a connection and then gives the connect process a direct socket to Oracle. As I stated earlier, I was wondering if anyone else on the list has problems with 10g tns listener? Perl: 5.008008(i686-linux) OS : linux (2.6.14.6) DBI : 1.50 DBD::mysql : 3.0002 DBD::Sponge : 11.10 DBD::SQLite : 1.11 DBD::Proxy : 0.2004 DBD::Oracle : 1.16 DBD::Multiplex : 1.98 DBD::File : 0.33 DBD::ExampleP : 11.12 DBD::DBM: 0.03 LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 25-APR-2006 15:27:25 Thanks, STH ---//--- He who learns must suffer. And even in our sleep, pain that cannot forget, falls drop by drop upon the heart; and, in our own despair, against our will, comes wisdom to us by the awful grace of God. --- Aeschylus
