Operating System - HP-UX
1748011 Members
3784 Online
108757 Solutions
New Discussion юеВ

Re: DBD::Oracle causes core dumps

 
SOLVED
Go to solution
H.Merijn Brand (procura
Honored Contributor

Re: DBD::Oracle causes core dumps

binutils-2.12 please
Enjoy, Have FUN! H.Merijn
Markus Bonet
Advisor

Re: DBD::Oracle causes core dumps

Ok, ok,

binutils2.12.
But, where can I get it?
On the HPUX Porting page there is currently only 2.11.2 available.
Or do I have to 'make' binutils from the source as well?


Markus
PS: Back on monday, now it's weekend :-))
H.Merijn Brand (procura
Honored Contributor

Re: DBD::Oracle causes core dumps

A quick search revealed the same to me, so I guess you'll have to rebuild that too :(
Enjoy, Have FUN! H.Merijn
Markus Bonet
Advisor

Re: DBD::Oracle causes core dumps

 
H.Merijn Brand (procura
Honored Contributor

Re: DBD::Oracle causes core dumps

Can the core dumps tell you wether it is /Oracle/, /DBD-Oracle/, /DBI/, or /perl/ that's getting confused and dumps core?
Enjoy, Have FUN! H.Merijn
Markus Bonet
Advisor

Re: DBD::Oracle causes core dumps

This perl-script:

#!/opt/perl5/bin/perl
use DBI;


$dbh=DBI->connect('dbi:Oracle:host=localhost;sid=xlab;port=2629', 'xxxxxx', 'xxxxxx') or die "Unable to connect: $DBI::errstr";
print "Connect!\n";
$sth = $dbh->prepare("select * from tbar_account");
$sth->execute();

while (@row = $sth->fetchrow_array) #### Die Werte in das Array @row schreiben
{
print "@row";
# $SHARENAME = $row[0]; #### Den Pfad in eine Variable schreiben
# $ARR_PFAD_PERM[$ARR_GROESSE_PERM] = $SHARENAME; #### Dann den verM-dnderten Datenstring wieder in ein Array schreiben,
# $ARR_GROESSE_PERM += "1"; #### dieses Array wird in den Subroutinen hold_rights und get_old_rights verwendet.
}
# print @ARR_PFAD_PERM;


causes this core-dump:

perl /www/cgi-bin/1test.pl
Segmentation fault (core dumped)
root@U8POA:/home/bonet/DBD-Oracle-1.12# file core
core: core file from 'perl' - received SIGSEGV



Markus
H.Merijn Brand (procura
Honored Contributor

Re: DBD::Oracle causes core dumps

Still don't see what version of Oracle you are using.

ALWAYS:

1. use strict;
2. use warnings;

In this case:

a. use DBI debugging to see where the script realy fails


#!/opt/perl5/bin/perl -w

use strict;

use DBI;

DBI->trace (99);
$dbh=DBI->connect ('dbi:Oracle:host=localhost;sid=xlab;port=2629', 'xxxxxx', 'xxxxxx') or die "Unable to connect: $DBI::errstr";
print "Connect!\n";
$sth = $dbh->prepare ("select * from tbar_account");
$sth->execute ();
while (@row = $sth->fetchrow_array) {
print "@row\n";
}


# gdb /opt/perl5/bin/perl core
:
:
:
gdb > where

????
Enjoy, Have FUN! H.Merijn
Markus Bonet
Advisor

Re: DBD::Oracle causes core dumps

 
H.Merijn Brand (procura
Honored Contributor

Re: DBD::Oracle causes core dumps

So you,ve got Oracle 8. But which? 8.1.7?

Check the README of Oracle installation guide, it states that there are some HP-UX patches are to be installed (pthread related?)

Check the README.hpux for DBD::Oracle

Check the libpthread lib, and if there are still patches available that you did not install

a5:/usr/lib 102 # what libpthread.sl
libpthread.sl:
mutex.c $Date: 2002/01/02 14:04:08 $Revision: r11ros/4 PATCH_11.00 (PHCO_26000)
libpthread.c $Date: 2002/01/10 10:24:01 $Revision: r11ros/8 PATCH_11.00 (PHCO_26000)
Pthread Interfaces
libpthread HP-UX (Release B.11.00): Thu Jul 5 15:26:27 PDT 2001
a5:/usr/lib 103 # ll libcl*
1890 lrwxr-xr-x 1 root sys 9 Sep 24 2001 libcl.0 -> ./libcl.1
1891 -r-xr-xr-x 1 bin bin 1388160 Jun 22 2001 libcl.1
7129 -r-xr-xr-x 1 bin bin 1253376 Jun 12 2001 libcl.2
4500 -r--r--r-- 1 bin bin 1463012 Jun 12 2001 libcl.a
1893 lrwxr-xr-x 1 root sys 9 Sep 24 2001 libcl.sl -> ./libcl.2
a5:/usr/lib 104 # what libcl.2
libcl.2:
Trap Library version UX.11.01.03(GS IB4) - November 16, 1998
Unwind Library version UX.11.01.05 - 00/08/15
fs_amod.s $Revision: 1.9.1.1 $
libcl.sl version B.11.01.08 - Jun 15, 2001
a5:/usr/lib 105 #

Asign points to the answers
Enjoy, Have FUN! H.Merijn
Markus Bonet
Advisor

Re: DBD::Oracle causes core dumps

It's Oracle 8.0.0.3 EE.

I looked around for patches. Might this be the needed one?

http://support4.itrc.hp.com/service/patch/patchDetail.do?patchid=PHCO_23792&context=hpux:800:11:00



Markus