Re: $DBI::errstr == (no error string)

On Sat, Dec 24, 2005 at 10:00:50AM -0800, Aaron Turner wrote:
> Hash: SHA1
>
> Here's what I got... not sure what it all means, but I don't see
> anything which jumps out as borked:
>
> -> connect for DBD::Pg::dr (DBI::dr=HASH(0x9c012d4)~0xa66df00
> 'database=*****;host=*******;port=5432' 'muuser' **** HASH
> (0xa6889b4)) thr#9a3e020
> New DBI::db (for DBD::Pg::db, parent=DBI::dr=HASH(0xa66df00), id=)
> dbih_setup_handle(DBI::db=HASH(0xa66dedc)=>DBI::db=HASH
> (0xa688a44), DBD::Pg::db, 9bfdfdc, Null!)
> dbd_db_login
> dbdpg: login connection string: (dbname=****** host=******
> port=5432 user='muuser' password='****')

Trying to connect here.

> >> DESTROY DISPATCH (DBI::db=HASH(0xa66dedc) rc1/1 @1 g0
> ima4 pid#9839) at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-
> multi/DBI.pm line 617 via /var/www/html/mulder/lib/Mu/DBI.pm line 65
> <> DESTROY(DBI::db=HASH(0xa66dedc)) ignored for outer handle
> (inner DBI::db=HASH(0xa688a44) has ref cnt 1)
> >> DESTROY DISPATCH (DBI::db=HASH(0xa688a44) rc1/1 @1 g0
> ima4 pid#9839) at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-
> multi/DBI.pm line 617 via /var/www/html/mulder/lib/Mu/DBI.pm line 65
> -> DESTROY for DBD::Pg::db (DBI::db=HASH(0xa688a44)~INNER)
> thr#9a3e020
> rollback
> dbd_db_disconnect
> rollback
> dbd_db_disconnect: AutoCommit=off -> rollback
> dbd_db_destroy
> <- DESTROY= undef at /usr/lib/perl5/site_perl/5.8.5/i386-linux-
> thread-multi/DBI.pm line 617 via /var/www/html/mulder/lib/Mu/DBI.pm
> line 65
> DESTROY (dbih_clearcom) (dbh 0xa688a44, com 0xa689e90, imp
> DBD::Pg::db):
> FLAGS 0x100011: COMSET Warn PrintWarn
> PARENT DBI::dr=HASH(0xa66df00)
> KIDS 0 (0 Active)
> IMP_DATA undef
> dbih_clearcom 0xa688a44 (com 0xa689e90, type 2) done.

The above relates to the database handle being destroyed.

> <- connect= undef at /usr/lib/perl5/site_perl/5.8.5/i386-linux-
> thread-multi/DBI.pm line 617 via /var/www/html/mulder/www/syshandler line 8

That's the connect returning.

> -> $DBI::errstr (&) FETCH from lasth=HASH
> >> DBD::Pg::dr::errstr
> <- $DBI::errstr= undef
> DBI connect
> ('database=****;host=*****;port=5432','muuser',...) failed: (no error
> string)
>
> Any ideas? Thanks,

Whatever the underlying issue is, there's clearly a bug in DBD::Pg in
that there's some path through the code that doesn't record an error
when it should.

Tim.
.

Relevant Pages

  • Re: UpdateBatch - taking a while
    ... the ado recordset to see how many "changed" records are there and force an ... If done inside a transaction, ... the opportunity to rollback the whole set .. ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • RE: System restore ?
    ... Does the system restore also rollback new services which have been started ... by newly installed program? ... Prev by Date: ...
    (microsoft.public.windowsxp.general)
  • Re: cost of probe to Pluto?
    ... > Would have been $2.39 at Walmart ... LAMAO ... Rollback days are here again!! ... Prev by Date: ...
    (sci.astro.amateur)
  • Re: OOPPSS !! help please ...........
    ... If you are using XP use system restore to rollback to a time prior to ... Prev by Date: ...
    (microsoft.public.windowsmedia.player)
  • Re: mount question...
    ... rollback. ... rvs's Profile: http://www.unicyclist.com/profile/11360 ... Prev by Date: ...
    (rec.sport.unicycling)