Stack trace.
Tim.
On Mon, Sep 30, 2002 at 03:21:53PM +1200, Glen Eustace wrote:
> Tim, Is there any thing I can provide that may help resolve this issue.
> Now that I don't get perl dieing, would the DBI trace help ?
>
> On Thu, 2002-09-26 at 10:11, Glen Eustace wrote:
> > Spoke too soon :-(
> >
> > With Perl5.8.0 instead of 5.6.0, I am no longer getting a SEGV, but
> > things are still broken.
> >
> > The connects apparently succeed, but when I try to use the 2nd
> > connection, the first is used.
> >
> > NB: the table, 'site' only exists in the second database.
> >
> > DBD::Pg is using the Ingres database
> >
> > -----------------------
> > use DBI;
> > $oDBase1 = DBI->connect( "dbi:Ingres:its-admin1::csadminp", 'dbguest',
> > '', {AutoCommit=>0})
> > or die "Cannot connect to first database: " .
> > $DBI::errstr;
> > $oDBase2 =
> > DBI->connect('dbi:Pg:dbname=netdbase;host=its-dev2.massey.ac.nz',
> > 'netdbase', '')
> > or die "Cannot connect to second database: " . $DBI::errstr;
> >
> > $oSql = $oDBase2->prepare( "select count(*) from site" ) or
> > die "Prep failed" . $DBI::errstr;
> > $oSql->execute() or
> > die "Exec failed" . $DBI::errstr;
> > ( $iCnt ) = $oSql->fetchrow();
> > print "Sites = ", $iCnt, "\n";
> >
> > T1.(its-dev1)work: /usr/local/bin/perl5.8.0 DBITest
> > E_LQ00BE Attempt to switch to a non-existent session.
> >
> > DBD::Pg::db prepare failed: E_US0845 Table 'site' does not exist or is
> > not owned by you.
> > (Thu Sep 26 10:09:10 2002) at DBITest line 8.
> > Prep failedE_US0845 Table 'site' does not exist or is not owned by you.
> > (Thu Sep 26 10:09:10 2002) at DBITest line 8.
> > E_LQ00BE Attempt to switch to a non-existent session.
> >
> >
> > --
> > .*. | Glen Eustace, Systems Engineer - Networking.
> > /V\ | Information Technology Services PN460, Turitea,
> > (/ \) | Massey University, Palmerston North, New Zealand.
> > ( ) | Ph: +64 6 350 5799 x 2707, Fax: +64 6 350 5607
> > ^^-^^ |------------------------------------------------------------
> --
> .*. | Glen Eustace, Systems Engineer - Networking.
> /V\ | Information Technology Services PN460, Turitea,
> (/ \) | Massey University, Palmerston North, New Zealand.
> ( ) | Ph: +64 6 350 5799 x 2707, Fax: +64 6 350 5607
> ^^-^^ |------------------------------------------------------------
>
