Hi,
We have a problem in using DBIx::Recordset module.
Whenever we run the following script through Apache, the first
invocation works fine. The second invocation causes Oracle
to dump core. The script joins two tables (ie., destination
and atomic_destination) and prints a column
named DESTINATION_NAME from the first table. There is no problem,
if I remove the join condition and Select and print the same
column from the first table only.
Another interesting observation is that this problem does
not happen if we run the just the perl part of the script
at command line, any number of times. Moreover, the
problem does not occur if we disable caching of connections
by apache. (i.e., by commenting out "PerlModule Apache::DBI" line
in httpd.conf).
The script is:
------------------------------------------------------------
[-
use DBIx::Recordset;
$DB_source = "dbi:Oracle:MAVS";
$DB_user = "test";
$DB_password = "test";
*set = DBIx::Recordset->Setup({
'!DataSource' => $DB_source,
'!Table' => "DESTINATION, ATOMIC_DESTINATION",
'!TabRelation' =>
"DESTINATION.DESTINATION_ID=ATOMIC_DESTINATION.DESTINATION_ID"
'!Username' => $DB_user,
'!Password' => $DB_password
});
$set->Select();
-]
<table>
<tr><th>Destination Name</th></tr>
<tr><td>[+$set[$row]{destination_name}+]</td></tr>
</table>
[- DBIx::Recordset::Undef('set'); -]
------------------------------------------------------------
The error in the alert log of oracle is:
Thu Dec 2 16:29:50 1999
Errors in file /usr/oracle/admin/MAVS/udump/mavs_ora_19460.trc:
ORA-07445: exception encountered: core dump [kkrhsync()+16] [SIGSEGV]
[Address not mapped to object] [24] [] []
----------------------------------------------------------------
The versions of the dependant modules are:
DBI: 1.11
DBIx::Recordset: 0.18-beta
DBD::Oracle: 1.02
Apache: 1.3.6
modperl: 1.20-4
Platform: Sun Solaris
Any help in this regard would be highly appreciated.
Thanks,
dhanabal
