Skip Menu |

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBD-Oracle CPAN distribution.

Report information
The Basics
Id: 46761
Status: resolved
Priority: 0/
Queue: DBD-Oracle

People
Owner: Nobody in particular
Requestors: alois.wiedenhofer [...] culturall.com
Cc:
AdminCc:

Bug Information
Severity: Normal
Broken in: 1.23
Fixed in: (no value)



Subject: Perl 32 bit on Solaris x86 64 bit with Oracle 64 bit Problems
1) Problem Linkage Problem with woring ELF class... Setting LD_LIBRARY_PATH to $ORACLE_HOME/lib32 can cause troubles to other programs .. Solaris therefor provides LD_LIBRARY_PATH_32 which is only evaluated by 32 bit Programs With that I was able to make but got follwoign warning Your LD_LIBRARY_PATH env var is set to '' WARNING: Your LD_LIBRARY_PATH env var doesn't include '/opt/oracle/product/10.2.0/lib32' but probably needs to. To get rid of this warning yout must improve your check on Solaris for 32 bit to LD_LLD_LIBRARY_PATH_32 too and for the future with 64 Bit LD_LIBRARY_PATH_64 2) make test still produces following Errors cpan[3]> test DBD::Oracle Running test for module 'DBD::Oracle' Running make for P/PY/PYTHIAN/DBD-Oracle-1.23.tar.gz Has already been unwrapped into directory /.cpan/build/DBD-Oracle- 1.23-36Z0xw Has already been made Running make test PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "- e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/01base.t .............. # Test loading DBI, DBD::Oracle and version t/01base.t .............. ok t/10general.t ........... 1/31 t/10general.t ........... Dubious, test returned 2 (wstat 512, 0x200) Failed 2/31 subtests t/12impdata.t ........... ok t/14threads.t ........... skipped: this solaris perl 5.010000 not configured to support iThreads t/15nls.t ............... ok t/20select.t ............ ok t/21nchar.t ............. ok t/22nchar_al32utf8.t .... ok t/22nchar_utf8.t ........ ok t/23wide_db.t ........... skipped: Database character set is not Unicode t/23wide_db_8bit.t ...... skipped: Database character set is not Unicode t/23wide_db_al32utf8.t .. skipped: Database character set is not Unicode t/24implicit_utf8.t ..... ok t/25plsql.t ............. ok t/26exe_array.t ......... ok t/28array_bind.t ........ ok t/30long.t .............. ok t/31lob.t ............... ok t/31lob_extended.t ...... ok t/32xmltype.t ........... ok t/34pres_lobs.t ......... ok t/40ph_type.t ........... 1/19 Placeholder behaviour for ora_type=1 VARCHAR2 (the default) varies with Oracle version. Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x Your system doesn't. If that seems odd, let us know. t/40ph_type.t ........... ok t/50cursor.t ............ Can't determine open_cursors from v$parameter, so using default t/50cursor.t ............ ok t/51scroll.t ............ ok t/55nested.t ............ ok t/56embbeded.t .......... ok t/58object.t ............ ok t/60reauth.t ............ skipped: ORACLE_USERID_2 not defined. t/70meta.t .............. ok t/80ora_charset.t ....... ok Test Summary Report ------------------- t/10general.t (Wstat: 512 Tests: 31 Failed: 2) Failed tests: 1-2 Non-zero exit status: 2 Files=30, Tests=1118, 20 wallclock secs ( 0.24 usr 0.10 sys + 8.63 cusr 1.34 csys = 10.31 CPU) Result: FAIL Failed 1/30 test programs. 2/1118 subtests failed. *** Error code 255 make: Fatal error: Command failed for target `test_dynamic' PYTHIAN/DBD-Oracle-1.23.tar.gz /usr/ccs/bin/make test -- NOT OK //hint// to see the cpan-testers results for installing this module, try: reports PYTHIAN/DBD-Oracle-1.23.tar.gz Failed during this command: PYTHIAN/DBD-Oracle-1.23.tar.gz : make_test NO How can I geht rid of this errors to get this Test OK ? Regards Alois
On Tue Jun 09 05:07:18 2009, Alois wrote: Show quoted text
> Test Summary Report > ------------------- > t/10general.t (Wstat: 512 Tests: 31 Failed: 2) > Failed tests: 1-2 > Non-zero exit status: 2 > Files=30, Tests=1118, 20 wallclock secs ( 0.24 usr 0.10 sys + 8.63 > cusr 1.34 csys = 10.31 CPU) > Result: FAIL > Failed 1/30 test programs. 2/1118 subtests failed. > *** Error code 255 > make: Fatal error: Command failed for target `test_dynamic' > PYTHIAN/DBD-Oracle-1.23.tar.gz > /usr/ccs/bin/make test -- NOT OK > //hint// to see the cpan-testers results for installing this module, > try: > reports PYTHIAN/DBD-Oracle-1.23.tar.gz > Failed during this command: > PYTHIAN/DBD-Oracle-1.23.tar.gz : make_test NO > > How can I geht rid of this errors to get this Test OK ? > > Regards > Alois
Try looking at t/10general.t around line 30 as there are some Solaris specific skips which may not be being picked up on your system. You can see exactly which tests are failing and the output with prove. Unpack DBD::Oracle, do the make and make test then when a test fails do: prove -vb t/10general.t and you will get individual test output. Martin
We have Solaris and Oracle version 10.2.0.4 the line in 10general.t skip "solaris with OCI>9.x", 2 unless ($^O eq "solaris") and (scalar (ORA_OCI) ge 10); This test is not skipped. If you want to skip this Test in that case you must code skip "solaris with OCI>9.x", 2 if ($^O eq "solaris") and (scalar(ORA_OCI ) ge 10); Did you want to run this test, or even skip it ? regards Alois
On Tue Jun 09 06:15:15 2009, Alois wrote: Show quoted text
> We have Solaris and Oracle version 10.2.0.4 > > the line in 10general.t > skip "solaris with OCI>9.x", 2 unless ($^O eq "solaris") and (scalar > (ORA_OCI) ge 10); > > This test is not skipped. > If you want to skip this Test in that case you must code > skip "solaris with OCI>9.x", 2 if ($^O eq "solaris") and (scalar(ORA_OCI > ) ge 10); > > Did you want to run this test, or even skip it ?
I've no idea (I was just trying to help you and the maintainer, John). I didn't write that test but I noticed the 2 tests using system following it fail on your system and your system is Solaris and there was a skip above. If you change the test to skip IF solaris do you get 10general.t to complete successfully? If you do then I'd think that may have meant to be if solaris instead of unless solaris. In any case, the 2 tests failing having nothing to do with actual DBD::Oracle usage and performing them or skipping them makes no difference to the rest of the test at all so they seem redundant. I have no comments on the other issues you reported. Martin -- Martin J. Evans Wetherby, UK
Hello Martin, to me it works now, thank you very much. perhaps a developer takes care of this two issues, that other people do not run into the same troubles on Solaris x86 10 with Oracle 10 both 64 bit regards Alois
patch for point #2 has been applied to the master branch, and will be back of v1.32.
poing #1 also patched in master. Slotted for v1.32
part of v1.32