Re: mod_perl + Apache 1.3.28

[David Wheeler]

On Wednesday, August 13, 2003, at 08:27  PM, Rudy Lippan wrote:

So then it is nothing that I did ;)
No, probably something I did. :-)

Intermittent.
But always on the second requst to the first process?
Nope.

It looks like something is happening to the Postgresql connection,  
which
is throwing off DBD::Pg and it gets into a weird state, so when it  
goes to
excute "BEGIN" pg is throwing an error -- Does the BEGIN even make it  
to
the databaes  server?  What do your pg server logs say?
On the hang, I get this:

  LOG:  pq_recvbuf: unexpected EOF on client connection

I did not see any ping releated info in the log file. Did you re-enable
the ping in _connect()?
Oops, I didn't. Re-enabling for the next try.

What is the first process doing (Process #4627), Because I don't see it
executing any SQL statements other than flipping the state of  
Autocommit?
It's just redirecting the browser, I believe.

I tried pulling a copy of Bric/Util/DBI.pm off of CVS on sourceforge  
but
the line numbers were not matching what was in the trace -- which  
version
should I be looking at?
I'm using the rev_1_6 branch, Revision 1.21.2.14. You can easily grab  
just that file here:

   
http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/bricolage/bricolage/lib/ 
Bric/Util/DBI.pm

Do you think that you might be able to put together a script that does  
not
require Bric -- it is a bit of a large hairy beast to install just to  
try
and duplicate the problem.
I was trying, but couldn't. Which is leading me think that somehow the  
problem _is_ with Bricolage. This is good. Or bad, depending on your  
POV. I could perhaps give you access to one of my systems running it...

Something I noticed while looking at Bric::Util::DBI:

sub commit {
    return 1 unless TRANSACTIONAL;
    return 1 if $ENV{MOD_PERL} && !$_[0];
    _connect();                             #rl: <--- Back to  
autocommit.
    my $ret;
    eval { $ret = $dbh->commit };           #rl: <---- Roll back what?  
if
                                            #rl: you needed to  
reconnect?
    throw_da(error => "Unable to commit transactions", payload => $@)
      if $@;
    eval { $ret = $dbh->{AutoCommit} = 1 };
    throw_da(error => "Unable to turn AutoCommit on", payload => $@)
      if $@;
    return $ret;
}

Another case is where the DB server is restarted after a begin():

$bric_dbh->begin();
### Database server is restarted. ###
$bric_dbh->prepare(); # You _connect() here and are back in autocommit  
mode

DO_STUF: {
  # everthing is automatically commited.
}
$bric_dbh->rollback() # does not do jack because you are in autocommit.
D'oh! Three years using this code and I never noticed that! I've  
commented out the calls to _connect() in commit() and rollback().

The above could could be what casues the commit ineffective in  
autocommit
mode error messages.  My guess is that things were getting stuck in  
ping,
when you hit stop you poped out of whatever was blocking (on a signal?)
and then the next db call you made automatically reconnected to the db
which caused some of the other error messages that you were seeing in  
the
logs?
Maybe, but with the above change, I'm still getting failures. I attach  
a new log. Look for my comments where the hang occurred, marked by  
"#########################################"

Thanks for the help with this, Rudy!

Regards,

David

--
David Wheeler                                     AIM: dwTheory
[EMAIL PROTECTED]                              ICQ: 15726394
http://www.kineticode.com/                     Yahoo!: dew7e
                                               Jabber: [EMAIL PROTECTED]
Kineticode. Setting knowledge in motion.[sm]
646: Checking for DB handle.
646: No handle, connecting.
    -> DBI->connect(DBI:Pg:dbname=sharky, castellan, ****, HASH(0x4157c4))
    -> DBI->install_driver(Pg) for darwin perl=5.008 pid=646 ruid=-2 euid=-2
       install_driver: DBD::Pg version 1.31_2 loaded from 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBD/Pg.pm
    New DBI::dr (for DBD::Pg::dr, parent=, id=)
    dbih_setup_handle(DBI::dr=HASH(0x5f94a0)=>DBI::dr=HASH(0x1d915d0), DBD::Pg::dr, 0, 
Null!)
    dbih_make_com(Null!, 0, DBD::Pg::dr, 84, 0) thr#0
    dbih_setup_attrib(DBI::dr=HASH(0x1d915d0), Err, Null!) SCALAR(0x5c9e74) (already 
defined)
    dbih_setup_attrib(DBI::dr=HASH(0x1d915d0), State, Null!) SCALAR(0x5fc2ac) (already 
defined)
    dbih_setup_attrib(DBI::dr=HASH(0x1d915d0), Errstr, Null!) SCALAR(0x5c9e50) 
(already defined)
    dbih_setup_attrib(DBI::dr=HASH(0x1d915d0), TraceLevel, Null!) 0 (already defined)
    dbih_setup_attrib(DBI::dr=HASH(0x1d915d0), FetchHashKeyName, Null!) 'NAME' 
(already defined)
    <- install_driver= DBI::dr=HASH(0x5f94a0)
    >> connect     DISPATCH (DBI::dr=HASH(0x5f94a0) rc2/3 @5 g0 ima1 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 582 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> connect for DBD::Pg::dr (DBI::dr=HASH(0x5f94a0)~0x1d915d0 'dbname=sharky' 
'castellan' **** HASH(0x9aaffc))
    New DBI::db (for DBD::Pg::db, parent=DBI::dr=HASH(0x1d915d0), id=)
    dbih_setup_handle(DBI::db=HASH(0x1c64aa0)=>DBI::db=HASH(0x9aafe4), DBD::Pg::db, 
5f6e44, Null!)
    dbih_make_com(DBI::dr=HASH(0x1d915d0), 1c67cf0, DBD::Pg::db, 120, 0) thr#0
    dbih_setup_attrib(DBI::db=HASH(0x9aafe4), Err, DBI::dr=HASH(0x1d915d0)) 
SCALAR(0x5fe7bc) (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x9aafe4), State, DBI::dr=HASH(0x1d915d0)) 
SCALAR(0x5fe81c) (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x9aafe4), Errstr, DBI::dr=HASH(0x1d915d0)) 
SCALAR(0x5fe7ec) (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x9aafe4), TraceLevel, DBI::dr=HASH(0x1d915d0)) 0 
(already defined)
    dbih_setup_attrib(DBI::db=HASH(0x9aafe4), FetchHashKeyName, 
DBI::dr=HASH(0x1d915d0)) 'NAME' (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x9aafe4), HandleError, DBI::dr=HASH(0x1d915d0)) 
undef (not defined)
pg_db_login
pg_db_login: conn_str = >dbname=sharky user=castellan password=nalletsac<
    <- connect= DBI::db=HASH(0x1c64aa0) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 582 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x9aafe4) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x9aafe4)~INNER 'RaiseError' 1)
dbd_db_STORE
    STORE DBI::db=HASH(0x9aafe4) 'RaiseError' => 1
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x9aafe4) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x9aafe4)~INNER 'PrintError' 0)
dbd_db_STORE
    STORE DBI::db=HASH(0x9aafe4) 'PrintError' => 0
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x9aafe4) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x9aafe4)~INNER 'AutoCommit' 1)
dbd_db_STORE
dbd_db_STORE: initialize AutoCommit to on
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x9aafe4) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x9aafe4)~INNER 'LongTruncOk' 0)
dbd_db_STORE
    STORE DBI::db=HASH(0x9aafe4) 'LongTruncOk' => 0
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x9aafe4) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x9aafe4)~INNER 'ChopBlanks' 1)
dbd_db_STORE
    STORE DBI::db=HASH(0x9aafe4) 'ChopBlanks' => 1
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x9aafe4) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x9aafe4)~INNER 'LongReadLen' 32768)
dbd_db_STORE
    STORE DBI::db=HASH(0x9aafe4) 'LongReadLen' => 32768
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x9aafe4) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x9aafe4)~INNER 'Username' 'castellan')
dbd_db_STORE
    STORE DBI::db=HASH(0x9aafe4) 'Username' => 'castellan'
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x9aafe4) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x9aafe4)~INNER 'ShowErrorStatement' 1)
dbd_db_STORE
    STORE DBI::db=HASH(0x9aafe4) 'ShowErrorStatement' => 1
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    <- connect= DBI::db=HASH(0x1c64aa0)
    >> STORE       DISPATCH (DBI::db=HASH(0x9aafe4) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 639 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1659
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x9aafe4)~INNER 'dbi_connect_closure' 
CODE(0x385944))
dbd_db_STORE
    STORE DBI::db=HASH(0x9aafe4) 'dbi_connect_closure' => CODE(0x385944)
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 639 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1659
    >> STORE       DISPATCH (DBI::db=HASH(0x9aafe4) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x9aafe4)~INNER 'AutoCommit' 0)
dbd_db_STORE
dbd_db_STORE: switch AutoCommit to off: begin
    <- STORE= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    >> FETCH       DISPATCH (DBI::db=HASH(0x9aafe4) rc2/1 @2 g0 ima404 pid#646) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    -> FETCH for DBD::Pg::db (DBI::db=HASH(0x9aafe4)~INNER 'AutoCommit')
dbd_db_FETCH
    <- FETCH= '' at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    >> commit      DISPATCH (DBI::db=HASH(0x1c64aa0) rc14/1 @1 g0 imac81 pid#646) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 571
    -> commit for DBD::Pg::db (DBI::db=HASH(0x1c64aa0)~0x9aafe4)
dbd_db_commit
    <- commit= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 571
    >> STORE       DISPATCH (DBI::db=HASH(0x9aafe4) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 574
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x9aafe4)~INNER 'AutoCommit' 1)
dbd_db_STORE
dbd_db_STORE: switch AutoCommit to on: commit
    <- STORE= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 574
    >> FETCH       DISPATCH (DBI::db=HASH(0x9aafe4) rc2/1 @2 g0 ima404 pid#646) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 574
    -> FETCH for DBD::Pg::db (DBI::db=HASH(0x9aafe4)~INNER 'AutoCommit')
dbd_db_FETCH
    <- FETCH= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 574
647: Checking for DB handle.
647: No handle, connecting.
    -> DBI->connect(DBI:Pg:dbname=sharky, castellan, ****, HASH(0x4157c4))
    -> DBI->install_driver(Pg) for darwin perl=5.008 pid=647 ruid=-2 euid=-2
       install_driver: DBD::Pg version 1.31_2 loaded from 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBD/Pg.pm
    New DBI::dr (for DBD::Pg::dr, parent=, id=)
    dbih_setup_handle(DBI::dr=HASH(0x5f94a0)=>DBI::dr=HASH(0x1c6483c), DBD::Pg::dr, 0, 
Null!)
    dbih_make_com(Null!, 0, DBD::Pg::dr, 84, 0) thr#0
    dbih_setup_attrib(DBI::dr=HASH(0x1c6483c), Err, Null!) SCALAR(0x5c9e74) (already 
defined)
    dbih_setup_attrib(DBI::dr=HASH(0x1c6483c), State, Null!) SCALAR(0x5fc2ac) (already 
defined)
    dbih_setup_attrib(DBI::dr=HASH(0x1c6483c), Errstr, Null!) SCALAR(0x5c9e50) 
(already defined)
    dbih_setup_attrib(DBI::dr=HASH(0x1c6483c), TraceLevel, Null!) 0 (already defined)
    dbih_setup_attrib(DBI::dr=HASH(0x1c6483c), FetchHashKeyName, Null!) 'NAME' 
(already defined)
    <- install_driver= DBI::dr=HASH(0x5f94a0)
    >> connect     DISPATCH (DBI::dr=HASH(0x5f94a0) rc2/3 @5 g0 ima1 pid#647) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 582 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> connect for DBD::Pg::dr (DBI::dr=HASH(0x5f94a0)~0x1c6483c 'dbname=sharky' 
'castellan' **** HASH(0x1d9184c))
    New DBI::db (for DBD::Pg::db, parent=DBI::dr=HASH(0x1c6483c), id=)
    dbih_setup_handle(DBI::db=HASH(0x385aac)=>DBI::db=HASH(0x1d91834), DBD::Pg::db, 
5f6e44, Null!)
    dbih_make_com(DBI::dr=HASH(0x1c6483c), 1d8ba90, DBD::Pg::db, 120, 0) thr#0
    dbih_setup_attrib(DBI::db=HASH(0x1d91834), Err, DBI::dr=HASH(0x1c6483c)) 
SCALAR(0x5fe7bc) (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x1d91834), State, DBI::dr=HASH(0x1c6483c)) 
SCALAR(0x5fe81c) (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x1d91834), Errstr, DBI::dr=HASH(0x1c6483c)) 
SCALAR(0x5fe7ec) (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x1d91834), TraceLevel, DBI::dr=HASH(0x1c6483c)) 0 
(already defined)
    dbih_setup_attrib(DBI::db=HASH(0x1d91834), FetchHashKeyName, 
DBI::dr=HASH(0x1c6483c)) 'NAME' (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x1d91834), HandleError, DBI::dr=HASH(0x1c6483c)) 
undef (not defined)
pg_db_login
pg_db_login: conn_str = >dbname=sharky user=castellan password=nalletsac<
    <- connect= DBI::db=HASH(0x385aac) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 582 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1d91834) rc2/1 @3 g0 ima418 pid#647) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d91834)~INNER 'RaiseError' 1)
dbd_db_STORE
    STORE DBI::db=HASH(0x1d91834) 'RaiseError' => 1
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1d91834) rc2/1 @3 g0 ima418 pid#647) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d91834)~INNER 'PrintError' 0)
dbd_db_STORE
    STORE DBI::db=HASH(0x1d91834) 'PrintError' => 0
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1d91834) rc2/1 @3 g0 ima418 pid#647) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d91834)~INNER 'AutoCommit' 1)
dbd_db_STORE
dbd_db_STORE: initialize AutoCommit to on
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1d91834) rc2/1 @3 g0 ima418 pid#647) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d91834)~INNER 'LongTruncOk' 0)
dbd_db_STORE
    STORE DBI::db=HASH(0x1d91834) 'LongTruncOk' => 0
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1d91834) rc2/1 @3 g0 ima418 pid#647) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d91834)~INNER 'ChopBlanks' 1)
dbd_db_STORE
    STORE DBI::db=HASH(0x1d91834) 'ChopBlanks' => 1
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1d91834) rc2/1 @3 g0 ima418 pid#647) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d91834)~INNER 'LongReadLen' 32768)
dbd_db_STORE
    STORE DBI::db=HASH(0x1d91834) 'LongReadLen' => 32768
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1d91834) rc2/1 @3 g0 ima418 pid#647) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d91834)~INNER 'Username' 'castellan')
dbd_db_STORE
    STORE DBI::db=HASH(0x1d91834) 'Username' => 'castellan'
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1d91834) rc2/1 @3 g0 ima418 pid#647) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d91834)~INNER 'ShowErrorStatement' 1)
dbd_db_STORE
    STORE DBI::db=HASH(0x1d91834) 'ShowErrorStatement' => 1
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    <- connect= DBI::db=HASH(0x385aac)
    >> STORE       DISPATCH (DBI::db=HASH(0x1d91834) rc2/1 @3 g0 ima418 pid#647) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 639 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1659
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d91834)~INNER 'dbi_connect_closure' 
CODE(0x385920))
dbd_db_STORE
    STORE DBI::db=HASH(0x1d91834) 'dbi_connect_closure' => CODE(0x385920)
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 639 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1659

    >> STORE       DISPATCH (DBI::db=HASH(0x1d91834) rc2/1 @3 g0 ima418 pid#647) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d91834)~INNER 'AutoCommit' 0)
dbd_db_STORE
dbd_db_STORE: switch AutoCommit to off: begin
    <- STORE= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    >> FETCH       DISPATCH (DBI::db=HASH(0x1d91834) rc2/1 @2 g0 ima404 pid#647) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    -> FETCH for DBD::Pg::db (DBI::db=HASH(0x1d91834)~INNER 'AutoCommit')
dbd_db_FETCH
    <- FETCH= '' at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
647: Checking for DB handle.
    >> ping        DISPATCH (DBI::db=HASH(0x385aac) rc14/1 @1 g0 ima405 pid#647) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1657 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> ping for DBD::Pg::db (DBI::db=HASH(0x385aac)~0x1d91834)
dbd_db_ping
before PQexec
result: 31096816
status: 0
PQclear
    <- ping= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 1657 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655

    >> prepare_cached DISPATCH (DBI::db=HASH(0x385aac) rc14/1 @4 g0 ima1 pid#647) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 470
    -> prepare_cached in DBD::_::db for DBD::Pg::db (DBI::db=HASH(0x385aac)~0x1d91834 '
        SELECT name, value
        FROM   pref
    ' undef 1)
    >> FETCH       DISPATCH (DBI::db=HASH(0x1d91834) rc1/2 @2 g0 ima404 pid#647) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 1423 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 470
1   -> FETCH for DBD::Pg::db (DBI::db=HASH(0x1d91834)~INNER 'CachedKids')
dbd_db_FETCH
    .. FETCH DBI::db=HASH(0x1d91834) 'CachedKids' = undef
1   <- FETCH= undef at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 1423 
via /usr/local/bricolage/lib/Bric/Util/DBI.pm line 470
    >> STORE       DISPATCH (DBI::db=HASH(0x1d91834) rc1/2 @3 g0 ima418 pid#647) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 1424 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 470
1   -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d91834)~INNER 'CachedKids' 
HASH(0x9abe84))
dbd_db_STORE
    STORE DBI::db=HASH(0x1d91834) 'CachedKids' => HASH(0x9abe84)
1   <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 1424 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 470
    >> prepare     DISPATCH (DBI::db=HASH(0x1d91834) rc1/2 @3 g0 ima201 pid#647) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 1436 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 470
1   -> prepare for DBD::Pg::db (DBI::db=HASH(0x1d91834)~INNER '
        SELECT name, value
        FROM   pref
    ' undef)
    New DBI::st (for DBD::Pg::st, parent=DBI::db=HASH(0x1d91834), id=)
    dbih_setup_handle(DBI::st=HASH(0x1c67a1c)=>DBI::st=HASH(0x9abe3c), DBD::Pg::st, 
1c67a28, Null!)
    dbih_make_com(DBI::db=HASH(0x1d91834), 1c67e70, DBD::Pg::st, 140, 0) thr#0
    dbih_setup_attrib(DBI::st=HASH(0x9abe3c), Err, DBI::db=HASH(0x1d91834)) 
SCALAR(0x5fe7bc) (already defined)
    dbih_setup_attrib(DBI::st=HASH(0x9abe3c), State, DBI::db=HASH(0x1d91834)) 
SCALAR(0x5fe81c) (already defined)
    dbih_setup_attrib(DBI::st=HASH(0x9abe3c), Errstr, DBI::db=HASH(0x1d91834)) 
SCALAR(0x5fe7ec) (already defined)
    dbih_setup_attrib(DBI::st=HASH(0x9abe3c), TraceLevel, DBI::db=HASH(0x1d91834)) 0 
(already defined)
    dbih_setup_attrib(DBI::st=HASH(0x9abe3c), FetchHashKeyName, 
DBI::db=HASH(0x1d91834)) 'NAME' (already defined)
    dbih_setup_attrib(DBI::st=HASH(0x9abe3c), HandleError, DBI::db=HASH(0x1d91834)) 
undef (not defined)
dbd_st_prepare: statement = >
        SELECT name, value
        FROM   pref
    <
1   <- prepare= DBI::st=HASH(0x1c67a1c) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 1436 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 470
    <- prepare_cached= DBI::st=HASH(0x1c67a1c) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 470
    >> execute     DISPATCH (DBI::st=HASH(0x1c67a1c) rc1/3 @1 g0 ima41 pid#647) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 999
    -> execute for DBD::Pg::st (DBI::st=HASH(0x1c67a1c)~0x9abe3c)
dbd_st_execute
dbd_st_execute: statement = >                                              SELECT 
name, value FROM pref <
    <- execute= 7 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 999
    >> bind_columns DISPATCH (DBI::st=HASH(0x1c67a1c) rc1/3 @3 g0 ima1 pid#647) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1033
    -> bind_columns in DBD::_::st for DBD::Pg::st (DBI::st=HASH(0x1c67a1c)~0x9abe3c 
SCALAR(0xa1c4a4) SCALAR(0xa1c498))
    dbih_setup_fbav for 2 fields => 0x9abe78
    dbih_sth_bind_col 1 => SCALAR(0xa1c4a4)
    dbih_sth_bind_col 2 => SCALAR(0xa1c498)
    <- bind_columns= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 1033
    >> fetch       DISPATCH (DBI::st=HASH(0x1c67a1c) rc1/3 @1 g0 ima0 pid#647) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1135
    -> fetch for DBD::Pg::st (DBI::st=HASH(0x1c67a1c)~0x9abe3c)
dbd_st_fetch
    <- fetch= [ 'Time Zone' 'America/Los_Angeles' ] row1 at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1135
    >> fetch       DISPATCH (DBI::st=HASH(0x1c67a1c) rc1/3 @1 g0 ima0 pid#647) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1135
    -> fetch for DBD::Pg::st (DBI::st=HASH(0x1c67a1c)~0x9abe3c)
dbd_st_fetch
    <- fetch= [ 'List Name Format' '%l%, f' ] row2 at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1135
    >> fetch       DISPATCH (DBI::st=HASH(0x1c67a1c) rc1/3 @1 g0 ima0 pid#647) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1135
    -> fetch for DBD::Pg::st (DBI::st=HASH(0x1c67a1c)~0x9abe3c)
dbd_st_fetch
    <- fetch= [ 'Name Format' '%f% l' ] row3 at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1135
    >> fetch       DISPATCH (DBI::st=HASH(0x1c67a1c) rc1/3 @1 g0 ima0 pid#647) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1135
    -> fetch for DBD::Pg::st (DBI::st=HASH(0x1c67a1c)~0x9abe3c)
dbd_st_fetch
    <- fetch= [ 'Date/Time Format' '%Y-%m-%d %T' ] row4 at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1135
    >> fetch       DISPATCH (DBI::st=HASH(0x1c67a1c) rc1/3 @1 g0 ima0 pid#647) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1135
    -> fetch for DBD::Pg::st (DBI::st=HASH(0x1c67a1c)~0x9abe3c)
dbd_st_fetch
    <- fetch= [ 'Permissions Widget' 'radio' ] row5 at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1135
    >> fetch       DISPATCH (DBI::st=HASH(0x1c67a1c) rc1/3 @1 g0 ima0 pid#647) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1135
    -> fetch for DBD::Pg::st (DBI::st=HASH(0x1c67a1c)~0x9abe3c)
dbd_st_fetch
    <- fetch= [ 'Search Results / Page' '0' ] row6 at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1135
    >> fetch       DISPATCH (DBI::st=HASH(0x1c67a1c) rc1/3 @1 g0 ima0 pid#647) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1135
    -> fetch for DBD::Pg::st (DBI::st=HASH(0x1c67a1c)~0x9abe3c)
dbd_st_fetch
    <- fetch= [ 'Bricolage Instance Name' 'Bricolage' ] row7 at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1135
    >> fetch       DISPATCH (DBI::st=HASH(0x1c67a1c) rc1/3 @1 g0 ima0 pid#647) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1135
    -> fetch for DBD::Pg::st (DBI::st=HASH(0x1c67a1c)~0x9abe3c)
dbd_st_fetch
    <- fetch= undef row7 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 1135
    >> commit      DISPATCH (DBI::db=HASH(0x385aac) rc14/1 @1 g0 imac81 pid#647) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 571
    -> commit for DBD::Pg::db (DBI::db=HASH(0x385aac)~0x1d91834)
dbd_db_commit
    <- commit= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 571
    >> STORE       DISPATCH (DBI::db=HASH(0x1d91834) rc2/3 @3 g0 ima418 pid#647) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 574
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d91834)~INNER 'AutoCommit' 1)
dbd_db_STORE
dbd_db_STORE: switch AutoCommit to on: commit
    <- STORE= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 574
    >> FETCH       DISPATCH (DBI::db=HASH(0x1d91834) rc2/3 @2 g0 ima404 pid#647) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 574
    -> FETCH for DBD::Pg::db (DBI::db=HASH(0x1d91834)~INNER 'AutoCommit')
dbd_db_FETCH
    <- FETCH= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 574
647: Checking for DB handle.
    >> ping        DISPATCH (DBI::db=HASH(0x385aac) rc14/1 @1 g0 ima405 pid#647) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1657 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> ping for DBD::Pg::db (DBI::db=HASH(0x385aac)~0x1d91834)
dbd_db_ping
before PQexec
result: 30897456
status: 0
PQclear
    <- ping= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 1657 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655

    >> STORE       DISPATCH (DBI::db=HASH(0x1d91834) rc2/3 @3 g0 ima418 pid#647) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d91834)~INNER 'AutoCommit' 0)
dbd_db_STORE
dbd_db_STORE: switch AutoCommit to off: begin
    <- STORE= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    >> FETCH       DISPATCH (DBI::db=HASH(0x1d91834) rc2/3 @2 g0 ima404 pid#647) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    -> FETCH for DBD::Pg::db (DBI::db=HASH(0x1d91834)~INNER 'AutoCommit')
dbd_db_FETCH
    <- FETCH= '' at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    >> commit      DISPATCH (DBI::db=HASH(0x385aac) rc14/1 @1 g0 imac81 pid#647) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 571
    -> commit for DBD::Pg::db (DBI::db=HASH(0x385aac)~0x1d91834)
dbd_db_commit
    <- commit= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 571
    >> STORE       DISPATCH (DBI::db=HASH(0x1d91834) rc2/3 @3 g0 ima418 pid#647) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 574
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d91834)~INNER 'AutoCommit' 1)
dbd_db_STORE
dbd_db_STORE: switch AutoCommit to on: commit
    <- STORE= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 574
    >> FETCH       DISPATCH (DBI::db=HASH(0x1d91834) rc2/3 @2 g0 ima404 pid#647) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 574
    -> FETCH for DBD::Pg::db (DBI::db=HASH(0x1d91834)~INNER 'AutoCommit')
dbd_db_FETCH
    <- FETCH= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 574
648: Checking for DB handle.
648: No handle, connecting.
    -> DBI->connect(DBI:Pg:dbname=sharky, castellan, ****, HASH(0x4157c4))
    -> DBI->install_driver(Pg) for darwin perl=5.008 pid=648 ruid=-2 euid=-2
       install_driver: DBD::Pg version 1.31_2 loaded from 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBD/Pg.pm
    New DBI::dr (for DBD::Pg::dr, parent=, id=)
    dbih_setup_handle(DBI::dr=HASH(0x5f94a0)=>DBI::dr=HASH(0x1c64b9c), DBD::Pg::dr, 0, 
Null!)
    dbih_make_com(Null!, 0, DBD::Pg::dr, 84, 0) thr#0
    dbih_setup_attrib(DBI::dr=HASH(0x1c64b9c), Err, Null!) SCALAR(0x5c9e74) (already 
defined)
    dbih_setup_attrib(DBI::dr=HASH(0x1c64b9c), State, Null!) SCALAR(0x5fc2ac) (already 
defined)
    dbih_setup_attrib(DBI::dr=HASH(0x1c64b9c), Errstr, Null!) SCALAR(0x5c9e50) 
(already defined)
    dbih_setup_attrib(DBI::dr=HASH(0x1c64b9c), TraceLevel, Null!) 0 (already defined)
    dbih_setup_attrib(DBI::dr=HASH(0x1c64b9c), FetchHashKeyName, Null!) 'NAME' 
(already defined)
    <- install_driver= DBI::dr=HASH(0x5f94a0)
    >> connect     DISPATCH (DBI::dr=HASH(0x5f94a0) rc2/3 @5 g0 ima1 pid#648) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 582 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> connect for DBD::Pg::dr (DBI::dr=HASH(0x5f94a0)~0x1c64b9c 'dbname=sharky' 
'castellan' **** HASH(0x1d91900))
    New DBI::db (for DBD::Pg::db, parent=DBI::dr=HASH(0x1c64b9c), id=)
    dbih_setup_handle(DBI::db=HASH(0x1c6755c)=>DBI::db=HASH(0x1d918e8), DBD::Pg::db, 
5f6e44, Null!)
    dbih_make_com(DBI::dr=HASH(0x1c64b9c), 1d8bd70, DBD::Pg::db, 120, 0) thr#0
    dbih_setup_attrib(DBI::db=HASH(0x1d918e8), Err, DBI::dr=HASH(0x1c64b9c)) 
SCALAR(0x5fe7bc) (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x1d918e8), State, DBI::dr=HASH(0x1c64b9c)) 
SCALAR(0x5fe81c) (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x1d918e8), Errstr, DBI::dr=HASH(0x1c64b9c)) 
SCALAR(0x5fe7ec) (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x1d918e8), TraceLevel, DBI::dr=HASH(0x1c64b9c)) 0 
(already defined)
    dbih_setup_attrib(DBI::db=HASH(0x1d918e8), FetchHashKeyName, 
DBI::dr=HASH(0x1c64b9c)) 'NAME' (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x1d918e8), HandleError, DBI::dr=HASH(0x1c64b9c)) 
undef (not defined)
pg_db_login
pg_db_login: conn_str = >dbname=sharky user=castellan password=nalletsac<
    <- connect= DBI::db=HASH(0x1c6755c) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 582 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1d918e8) rc2/1 @3 g0 ima418 pid#648) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d918e8)~INNER 'RaiseError' 1)
dbd_db_STORE
    STORE DBI::db=HASH(0x1d918e8) 'RaiseError' => 1
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1d918e8) rc2/1 @3 g0 ima418 pid#648) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d918e8)~INNER 'PrintError' 0)
dbd_db_STORE
    STORE DBI::db=HASH(0x1d918e8) 'PrintError' => 0
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1d918e8) rc2/1 @3 g0 ima418 pid#648) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d918e8)~INNER 'AutoCommit' 1)
dbd_db_STORE
dbd_db_STORE: initialize AutoCommit to on
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1d918e8) rc2/1 @3 g0 ima418 pid#648) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d918e8)~INNER 'LongTruncOk' 0)
dbd_db_STORE
    STORE DBI::db=HASH(0x1d918e8) 'LongTruncOk' => 0
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1d918e8) rc2/1 @3 g0 ima418 pid#648) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d918e8)~INNER 'ChopBlanks' 1)
dbd_db_STORE
    STORE DBI::db=HASH(0x1d918e8) 'ChopBlanks' => 1
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1d918e8) rc2/1 @3 g0 ima418 pid#648) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d918e8)~INNER 'LongReadLen' 32768)
dbd_db_STORE
    STORE DBI::db=HASH(0x1d918e8) 'LongReadLen' => 32768
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1d918e8) rc2/1 @3 g0 ima418 pid#648) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d918e8)~INNER 'Username' 'castellan')
dbd_db_STORE
    STORE DBI::db=HASH(0x1d918e8) 'Username' => 'castellan'
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1d918e8) rc2/1 @3 g0 ima418 pid#648) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d918e8)~INNER 'ShowErrorStatement' 1)
dbd_db_STORE
    STORE DBI::db=HASH(0x1d918e8) 'ShowErrorStatement' => 1
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    <- connect= DBI::db=HASH(0x1c6755c)
    >> STORE       DISPATCH (DBI::db=HASH(0x1d918e8) rc2/1 @3 g0 ima418 pid#648) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 639 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1659
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d918e8)~INNER 'dbi_connect_closure' 
CODE(0x385ae8))
dbd_db_STORE
    STORE DBI::db=HASH(0x1d918e8) 'dbi_connect_closure' => CODE(0x385ae8)
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 639 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1659

    >> STORE       DISPATCH (DBI::db=HASH(0x1d918e8) rc2/1 @3 g0 ima418 pid#648) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d918e8)~INNER 'AutoCommit' 0)
dbd_db_STORE
dbd_db_STORE: switch AutoCommit to off: begin
    <- STORE= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    >> FETCH       DISPATCH (DBI::db=HASH(0x1d918e8) rc2/1 @2 g0 ima404 pid#648) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    -> FETCH for DBD::Pg::db (DBI::db=HASH(0x1d918e8)~INNER 'AutoCommit')
dbd_db_FETCH
    <- FETCH= '' at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    >> commit      DISPATCH (DBI::db=HASH(0x1c6755c) rc14/1 @1 g0 imac81 pid#648) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 571
    -> commit for DBD::Pg::db (DBI::db=HASH(0x1c6755c)~0x1d918e8)
dbd_db_commit
    <- commit= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 571
    >> STORE       DISPATCH (DBI::db=HASH(0x1d918e8) rc2/1 @3 g0 ima418 pid#648) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 574
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d918e8)~INNER 'AutoCommit' 1)
dbd_db_STORE
dbd_db_STORE: switch AutoCommit to on: commit
    <- STORE= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 574
    >> FETCH       DISPATCH (DBI::db=HASH(0x1d918e8) rc2/1 @2 g0 ima404 pid#648) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 574
    -> FETCH for DBD::Pg::db (DBI::db=HASH(0x1d918e8)~INNER 'AutoCommit')
dbd_db_FETCH
    <- FETCH= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 574
648: Checking for DB handle.
    >> ping        DISPATCH (DBI::db=HASH(0x1c6755c) rc14/1 @1 g0 ima405 pid#648) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1657 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> ping for DBD::Pg::db (DBI::db=HASH(0x1c6755c)~0x1d918e8)
dbd_db_ping
before PQexec
result: 31071792
status: 0
PQclear
    <- ping= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 1657 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655

    >> STORE       DISPATCH (DBI::db=HASH(0x1d918e8) rc2/1 @3 g0 ima418 pid#648) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d918e8)~INNER 'AutoCommit' 0)
dbd_db_STORE
dbd_db_STORE: switch AutoCommit to off: begin
    <- STORE= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    >> FETCH       DISPATCH (DBI::db=HASH(0x1d918e8) rc2/1 @2 g0 ima404 pid#648) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    -> FETCH for DBD::Pg::db (DBI::db=HASH(0x1d918e8)~INNER 'AutoCommit')
dbd_db_FETCH
    <- FETCH= '' at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    >> commit      DISPATCH (DBI::db=HASH(0x1c6755c) rc14/1 @1 g0 imac81 pid#648) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 571
    -> commit for DBD::Pg::db (DBI::db=HASH(0x1c6755c)~0x1d918e8)
dbd_db_commit
    <- commit= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 571
    >> STORE       DISPATCH (DBI::db=HASH(0x1d918e8) rc2/1 @3 g0 ima418 pid#648) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 574
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1d918e8)~INNER 'AutoCommit' 1)
dbd_db_STORE
dbd_db_STORE: switch AutoCommit to on: commit
    <- STORE= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 574
    >> FETCH       DISPATCH (DBI::db=HASH(0x1d918e8) rc2/1 @2 g0 ima404 pid#648) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 574
    -> FETCH for DBD::Pg::db (DBI::db=HASH(0x1d918e8)~INNER 'AutoCommit')
dbd_db_FETCH
    <- FETCH= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 574
646: Checking for DB handle.
    >> ping        DISPATCH (DBI::db=HASH(0x1c64aa0) rc14/1 @1 g0 ima405 pid#646) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1657 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> ping for DBD::Pg::db (DBI::db=HASH(0x1c64aa0)~0x9aafe4)
dbd_db_ping
before PQexec



##############################################################################
# This is where the hang happened. I hit cancel in the browser after a
# minute, and the rest of the file represents the fallout.
##############################################################################



result: 31066624
status: 7
PQclear
    <- ping= undef at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 1657 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
646: No handle, connecting.
    -> DBI->connect(DBI:Pg:dbname=sharky, castellan, ****, HASH(0x4157c4))
    >> connect     DISPATCH (DBI::dr=HASH(0x5f94a0) rc2/4 @5 g0 ima1 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 582 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> connect for DBD::Pg::dr (DBI::dr=HASH(0x5f94a0)~0x1d915d0 'dbname=sharky' 
'castellan' **** HASH(0x9ab7a0))
    New DBI::db (for DBD::Pg::db, parent=DBI::dr=HASH(0x1d915d0), id=)
    dbih_setup_handle(DBI::db=HASH(0x9ab0e0)=>DBI::db=HASH(0x9ab788), DBD::Pg::db, 
9ab0ec, Null!)
    dbih_make_com(DBI::dr=HASH(0x1d915d0), 1c67cf0, DBD::Pg::db, 120, 0) thr#0
    dbih_setup_attrib(DBI::db=HASH(0x9ab788), Err, DBI::dr=HASH(0x1d915d0)) 
SCALAR(0x9ab110) (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x9ab788), State, DBI::dr=HASH(0x1d915d0)) 
SCALAR(0x9ab0f8) (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x9ab788), Errstr, DBI::dr=HASH(0x1d915d0)) 
SCALAR(0x9ab104) (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x9ab788), TraceLevel, DBI::dr=HASH(0x1d915d0)) 0 
(already defined)
    dbih_setup_attrib(DBI::db=HASH(0x9ab788), FetchHashKeyName, 
DBI::dr=HASH(0x1d915d0)) 'NAME' (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x9ab788), HandleError, DBI::dr=HASH(0x1d915d0)) 
undef (not defined)
pg_db_login
pg_db_login: conn_str = >dbname=sharky user=castellan password=nalletsac<
    <- connect= DBI::db=HASH(0x9ab0e0) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 582 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x9ab788) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x9ab788)~INNER 'RaiseError' 1)
dbd_db_STORE
    STORE DBI::db=HASH(0x9ab788) 'RaiseError' => 1
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x9ab788) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x9ab788)~INNER 'PrintError' 0)
dbd_db_STORE
    STORE DBI::db=HASH(0x9ab788) 'PrintError' => 0
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x9ab788) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x9ab788)~INNER 'AutoCommit' 1)
dbd_db_STORE
dbd_db_STORE: initialize AutoCommit to on
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x9ab788) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x9ab788)~INNER 'LongTruncOk' 0)
dbd_db_STORE
    STORE DBI::db=HASH(0x9ab788) 'LongTruncOk' => 0
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x9ab788) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x9ab788)~INNER 'ChopBlanks' 1)
dbd_db_STORE
    STORE DBI::db=HASH(0x9ab788) 'ChopBlanks' => 1
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x9ab788) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x9ab788)~INNER 'LongReadLen' 32768)
dbd_db_STORE
    STORE DBI::db=HASH(0x9ab788) 'LongReadLen' => 32768
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x9ab788) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x9ab788)~INNER 'Username' 'castellan')
dbd_db_STORE
    STORE DBI::db=HASH(0x9ab788) 'Username' => 'castellan'
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x9ab788) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x9ab788)~INNER 'ShowErrorStatement' 1)
dbd_db_STORE
    STORE DBI::db=HASH(0x9ab788) 'ShowErrorStatement' => 1
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    <- connect= DBI::db=HASH(0x9ab0e0)
    >> STORE       DISPATCH (DBI::db=HASH(0x9ab788) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 639 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1659
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x9ab788)~INNER 'dbi_connect_closure' 
CODE(0x9ab38c))
dbd_db_STORE
    STORE DBI::db=HASH(0x9ab788) 'dbi_connect_closure' => CODE(0x9ab38c)
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 639 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1659
    >> DESTROY     DISPATCH (DBI::db=HASH(0x1c64aa0) rc1/1 @1 g0 ima4 pid#646) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1663
    <> DESTROY ignored for outer handle DBI::db=HASH(0x1c64aa0) (inner 
DBI::db=HASH(0x9aafe4))
    >> DESTROY     DISPATCH (DBI::db=HASH(0x9aafe4) rc1/1 @1 g0 ima4 pid#646) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1663
    -> DESTROY for DBD::Pg::db (DBI::db=HASH(0x9aafe4)~INNER)
dbd_db_disconnect
dbd_db_destroy
    <- DESTROY= undef at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 1663
    DESTROY (dbih_clearcom) (dbh 0x1c64aa0 0x1d8c560, com 0x1d8d0b0, imp DBD::Pg::db):
       FLAGS 0x22d1: COMSET Warn ChopBlanks RaiseError ShowErrorStatement AutoCommit 
       PARENT DBI::dr=HASH(0x1d915d0)
       KIDS 0 (0 Active)
       IMP_DATA undef
       LongReadLen 32768
    dbih_clearcom 0x1c64aa0 (com 0x1d8d0b0, type 2) done.


    >> STORE       DISPATCH (DBI::db=HASH(0x9ab788) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x9ab788)~INNER 'AutoCommit' 0)
dbd_db_STORE
dbd_db_STORE: switch AutoCommit to off: begin
    <- STORE= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    >> FETCH       DISPATCH (DBI::db=HASH(0x9ab788) rc2/1 @2 g0 ima404 pid#646) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    -> FETCH for DBD::Pg::db (DBI::db=HASH(0x9ab788)~INNER 'AutoCommit')
dbd_db_FETCH
    <- FETCH= '' at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    >> commit      DISPATCH (DBI::db=HASH(0x9ab0e0) rc14/1 @1 g0 imac81 pid#646) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 571
    -> commit for DBD::Pg::db (DBI::db=HASH(0x9ab0e0)~0x9ab788)
dbd_db_commit
FATAL:  Socket command type H unknown
server closed the connection unexpectedly error -1 recorded: server closed the 
connection unexpectedly
begin failed error -1 recorded: begin failed
    !! ERROR: -1 'begin failed'
    <- commit= '' at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 571
    >> rollback    DISPATCH (DBI::db=HASH(0x9ab0e0) rc14/1 @1 g0 imac81 pid#646) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 960
    -> rollback for DBD::Pg::db (DBI::db=HASH(0x9ab0e0)~0x9ab788)
dbd_db_rollback
rollback failed error -1 recorded: rollback failed
    !! ERROR: -1 'rollback failed'
    <- rollback= '' at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 960
[Thu Aug 14 04:31:13 2003] [error] [client 127.0.0.1] Unable to commit transactions: 
DBD::Pg::db commit failed: begin failed at /usr/local/bricolage/lib/Bric/Util/DBI.pm 
line 571.

[/usr/local/bricolage/lib/Bric/Util/DBI.pm:572]
[/usr/local/bricolage/lib/Bric/App/Handler.pm:251]

In addition, the database rollback failed: Unable to rollback transactions: 
DBD::Pg::db rollback failed: rollback failed at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 960.

[/usr/local/bricolage/lib/Bric/Util/DBI.pm:961]
[/usr/local/bricolage/lib/Bric/App/Handler.pm:284]
[/usr/local/bricolage/lib/Bric/App/Handler.pm:255]


646: Checking for DB handle.
    >> ping        DISPATCH (DBI::db=HASH(0x9ab0e0) rc14/1 @1 g0 ima405 pid#646) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1657 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> ping for DBD::Pg::db (DBI::db=HASH(0x9ab0e0)~0x9ab788)
dbd_db_ping
before PQexec
result: 0
status: -1
PQclear
       error: -1 'rollback failed'
    <- ping= undef at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 1657 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
646: No handle, connecting.
    -> DBI->connect(DBI:Pg:dbname=sharky, castellan, ****, HASH(0x4157c4))
    >> connect     DISPATCH (DBI::dr=HASH(0x5f94a0) rc2/4 @5 g0 ima1 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 582 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> connect for DBD::Pg::dr (DBI::dr=HASH(0x5f94a0)~0x1d915d0 'dbname=sharky' 
'castellan' **** HASH(0x1e17964))
    New DBI::db (for DBD::Pg::db, parent=DBI::dr=HASH(0x1d915d0), id=)
    dbih_setup_handle(DBI::db=HASH(0x9ab86c)=>DBI::db=HASH(0x1c3fe48), DBD::Pg::db, 
9ab878, Null!)
    dbih_make_com(DBI::dr=HASH(0x1d915d0), 1c67cf0, DBD::Pg::db, 120, 0) thr#0
    dbih_setup_attrib(DBI::db=HASH(0x1c3fe48), Err, DBI::dr=HASH(0x1d915d0)) 
SCALAR(0x9ab89c) (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x1c3fe48), State, DBI::dr=HASH(0x1d915d0)) 
SCALAR(0x9ab884) (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x1c3fe48), Errstr, DBI::dr=HASH(0x1d915d0)) 
SCALAR(0x9ab890) (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x1c3fe48), TraceLevel, DBI::dr=HASH(0x1d915d0)) 0 
(already defined)
    dbih_setup_attrib(DBI::db=HASH(0x1c3fe48), FetchHashKeyName, 
DBI::dr=HASH(0x1d915d0)) 'NAME' (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x1c3fe48), HandleError, DBI::dr=HASH(0x1d915d0)) 
undef (not defined)
pg_db_login
pg_db_login: conn_str = >dbname=sharky user=castellan password=nalletsac<
    <- connect= DBI::db=HASH(0x9ab86c) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 582 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1c3fe48) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1c3fe48)~INNER 'RaiseError' 1)
dbd_db_STORE
    STORE DBI::db=HASH(0x1c3fe48) 'RaiseError' => 1
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1c3fe48) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1c3fe48)~INNER 'PrintError' 0)
dbd_db_STORE
    STORE DBI::db=HASH(0x1c3fe48) 'PrintError' => 0
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1c3fe48) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1c3fe48)~INNER 'AutoCommit' 1)
dbd_db_STORE
dbd_db_STORE: initialize AutoCommit to on
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 622 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1c3fe48) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1c3fe48)~INNER 'LongTruncOk' 0)
dbd_db_STORE
    STORE DBI::db=HASH(0x1c3fe48) 'LongTruncOk' => 0
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1c3fe48) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1c3fe48)~INNER 'ChopBlanks' 1)
dbd_db_STORE
    STORE DBI::db=HASH(0x1c3fe48) 'ChopBlanks' => 1
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1c3fe48) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1c3fe48)~INNER 'LongReadLen' 32768)
dbd_db_STORE
    STORE DBI::db=HASH(0x1c3fe48) 'LongReadLen' => 32768
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1c3fe48) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1c3fe48)~INNER 'Username' 'castellan')
dbd_db_STORE
    STORE DBI::db=HASH(0x1c3fe48) 'Username' => 'castellan'
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    >> STORE       DISPATCH (DBI::db=HASH(0x1c3fe48) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1c3fe48)~INNER 'ShowErrorStatement' 1)
dbd_db_STORE
    STORE DBI::db=HASH(0x1c3fe48) 'ShowErrorStatement' => 1
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 625 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1655
    <- connect= DBI::db=HASH(0x9ab86c)
    >> STORE       DISPATCH (DBI::db=HASH(0x1c3fe48) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 639 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1659
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1c3fe48)~INNER 'dbi_connect_closure' 
CODE(0x1da5a74))
dbd_db_STORE
    STORE DBI::db=HASH(0x1c3fe48) 'dbi_connect_closure' => CODE(0x1da5a74)
    <- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/darwin/DBI.pm line 639 via 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1659
    >> DESTROY     DISPATCH (DBI::db=HASH(0x9ab0e0) rc1/1 @1 g0 ima4 pid#646) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1663
    <> DESTROY ignored for outer handle DBI::db=HASH(0x9ab0e0) (inner 
DBI::db=HASH(0x9ab788))
    >> DESTROY     DISPATCH (DBI::db=HASH(0x9ab788) rc1/1 @1 g0 ima4 pid#646) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1663
    -> DESTROY for DBD::Pg::db (DBI::db=HASH(0x9ab788)~INNER)
Issuing rollback() for database handle being DESTROY'd without explicit disconnect() 
at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 1663.
dbd_db_rollback
rollback failed error -1 recorded: rollback failed
dbd_db_disconnect
rollback failed error -1 recorded: rollback failed
dbd_db_destroy
       error: -1 'rollback failed'
    <- DESTROY= undef at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 1663
    DESTROY (dbih_clearcom) (dbh 0x9ab0e0 0x1da1430, com 0x1da1570, imp DBD::Pg::db):
       FLAGS 0x20d1: COMSET Warn ChopBlanks RaiseError ShowErrorStatement 
       PARENT DBI::dr=HASH(0x1d915d0)
       KIDS 0 (0 Active)
       IMP_DATA undef
       LongReadLen 32768
    dbih_clearcom 0x9ab0e0 (com 0x1da1570, type 2) done.


    >> STORE       DISPATCH (DBI::db=HASH(0x1c3fe48) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1c3fe48)~INNER 'AutoCommit' 0)
dbd_db_STORE
dbd_db_STORE: switch AutoCommit to off: begin
    <- STORE= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    >> FETCH       DISPATCH (DBI::db=HASH(0x1c3fe48) rc2/1 @2 g0 ima404 pid#646) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    -> FETCH for DBD::Pg::db (DBI::db=HASH(0x1c3fe48)~INNER 'AutoCommit')
dbd_db_FETCH
    <- FETCH= '' at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 528
    >> commit      DISPATCH (DBI::db=HASH(0x9ab86c) rc14/1 @1 g0 imac81 pid#646) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 571
    -> commit for DBD::Pg::db (DBI::db=HASH(0x9ab86c)~0x1c3fe48)
dbd_db_commit
    <- commit= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 571
    >> STORE       DISPATCH (DBI::db=HASH(0x1c3fe48) rc2/1 @3 g0 ima418 pid#646) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 574
    -> STORE for DBD::Pg::db (DBI::db=HASH(0x1c3fe48)~INNER 'AutoCommit' 1)
dbd_db_STORE
dbd_db_STORE: switch AutoCommit to on: commit
    <- STORE= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 574
    >> FETCH       DISPATCH (DBI::db=HASH(0x1c3fe48) rc2/1 @2 g0 ima404 pid#646) at 
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 574
    -> FETCH for DBD::Pg::db (DBI::db=HASH(0x1c3fe48)~INNER 'AutoCommit')
dbd_db_FETCH
    <- FETCH= 1 at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 574