> 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.
----------------------------------------
DBI Trace.
Script started on Tue Oct 1 08:56:00 2002
T2.(its-dev1)work: perl5.8.0 DBITest
DBI 1.30-nothread dispatch trace level set to 9
Note: perl is running without the recommended perl -w option
install_method DBI::db::errstr , flags 0x4
install_method DBI::db::get_info usage: min 2, max 2, '$info_type', tl 0
, flags 0x201
install_method DBI::db::err , flags 0x4
install_method DBI::db::disconnect usage: min 1, max 1, '', tl 0
, flags 0x401
install_method DBI::db::CLEAR , flags 0x4
install_method DBI::db::state usage: min 1, max 1, '', tl 0
, flags 0x5
install_method DBI::db::_not_impl
install_method DBI::db::selectrow_array usage: min 2, max 0, '$statement [, \%attr
[, @bind_params ] ]', tl 0
, flags 0x1
install_method DBI::db::trace usage: min 1, max 3, '[$trace_level,
[$filename]]', tl 0
, flags 0x5
install_method DBI::db::quote_identifier usage: min 2, max 5, '$name [,
...]', tl 0
, flags 0x431
install_method DBI::db::tables usage: min 1, max 6, '$catalog, $schema, $table,
$type [, \%attr ]', tl 0
, flags 0x201
install_method DBI::db::quote usage: min 2, max 3, '$string [, $data_type ]', tl 0
, flags 0x431
install_method DBI::db::debug usage: min 1, max 2, '[$debug_level]', tl 0
, flags 0x5
install_method DBI::db::begin_work usage: min 1, max 2, '[ \%attr ]', tl 0
, flags 0x401
install_method DBI::db::selectrow_arrayref usage: min 2, max 0, '$statement
[, \%attr [, @bind_params ] ]', tl 0
, flags 0x1
install_method DBI::db::type_info usage: min 1, max 2, '$data_type', tl 0
, flags 0x201
install_method DBI::db::foreign_key_info usage: min 1, max 7, '$pk_catalog,
$pk_schema, $pk_table, $fk_catalog, $fk_schema, $fk_table', tl 0
, flags 0x201
install_method DBI::db::primary_key usage: min 4, max 5, '$catalog, $schema,
$table [, \%attr ]', tl 0
, flags 0x201
install_method DBI::db::DESTROY
install_method DBI::db::event usage: min 2, max 0, '$type, @args', tl 0
, flags 0x5
install_method DBI::db::STORE , flags 0x410
install_method DBI::db::commit usage: min 1, max 1, '', tl 0
, flags 0x481
install_method DBI::db::private_data usage: min 1, max 1, '', tl 0
, flags 0x5
install_method DBI::db::ping usage: min 1, max 1, '', tl 0
, flags 0x405
install_method DBI::db::selectall_arrayref usage: min 2, max 0, '$statement
[, \%attr [, @bind_params ] ]', tl 0
, flags 0x1
install_method DBI::db::type_info_all usage: min 1, max 1, '', tl 0
, flags 0x201
install_method DBI::db::trace_msg usage: min 2, max 3, '$message_text [,
$min_level ]', tl 8
, flags 0x5
install_method DBI::db::do usage: min 2, max 0, '$statement [, \%attr [,
@bind_params ] ]', tl 0
, flags 0x1
install_method DBI::db::selectcol_arrayref usage: min 2, max 0, '$statement
[, \%attr [, @bind_params ] ]', tl 0
, flags 0x1
install_method DBI::db::rows , flags 0x4
install_method DBI::db::prepare_cached usage: min 2, max 4, '$statement [, \%attr
[, $allow_active ] ]', tl 0
, flags 0x1
install_method DBI::db::NEXTKEY , flags 0x4
install_method DBI::db::column_info usage: min 1, max 6, '$catalog, $schema,
$table, $column [, \%attr ]', tl 0
, flags 0x201
install_method DBI::db::rollback usage: min 1, max 1, '', tl 0
, flags 0x481
install_method DBI::db::primary_key_info usage: min 4, max 5, '$catalog,
$schema, $table [, \%attr ]', tl 0
, flags 0x201
install_method DBI::db::table_info usage: min 1, max 6, '$catalog, $schema,
$table, $type [, \%attr ]', tl 0
, flags 0x201
install_method DBI::db::prepare usage: min 2, max 3, '$statement [, \%attr]', tl 0
, flags 0x1
install_method DBI::db::EXISTS , flags 0x4
install_method DBI::db::preparse , flags 0x0
install_method DBI::db::connected , flags 0x100
install_method DBI::db::FETCH , flags 0x404
install_method DBI::db::FIRSTKEY , flags 0x4
install_method DBI::db::selectall_hashref usage: min 3, max 0, '$statement,
$keyfield [, \%attr [, @bind_params ] ]', tl 0
, flags 0x1
install_method DBI::db::set_err , flags 0x0
install_method DBI::db::selectrow_hashref usage: min 2, max 0, '$statement
[, \%attr [, @bind_params ] ]', tl 0
, flags 0x1
install_method DBI::db::func , flags 0x6
install_method DBI::dr::errstr , flags 0x4
install_method DBI::dr::err , flags 0x4
install_method DBI::dr::disconnect_all usage: min 1, max 1, '', tl 0
, flags 0x1
install_method DBI::dr::CLEAR , flags 0x4
install_method DBI::dr::state usage: min 1, max 1, '', tl 0
, flags 0x5
install_method DBI::dr::_not_impl
install_method DBI::dr::trace usage: min 1, max 3, '[$trace_level,
[$filename]]', tl 0
, flags 0x5
install_method DBI::dr::debug usage: min 1, max 2, '[$debug_level]', tl 0
, flags 0x5
install_method DBI::dr::default_user usage: min 3, max 4, '$user, $pass [,
\%attr]', tl 0
, flags 0x1
install_method DBI::dr::DESTROY
install_method DBI::dr::event usage: min 2, max 0, '$type, @args', tl 0
, flags 0x5
install_method DBI::dr::STORE , flags 0x410
install_method DBI::dr::private_data usage: min 1, max 1, '', tl 0
, flags 0x5
install_method DBI::dr::trace_msg usage: min 2, max 3, '$message_text [,
$min_level ]', tl 8
, flags 0x5
install_method DBI::dr::NEXTKEY , flags 0x4
install_method DBI::dr::connect usage: min 1, max 5, '[$db [,$user [,$passwd
[,\%attr]]]]', tl 0
, flags 0x1
install_method DBI::dr::EXISTS , flags 0x4
install_method DBI::dr::FIRSTKEY , flags 0x4
install_method DBI::dr::FETCH , flags 0x404
install_method DBI::dr::data_sources usage: min 1, max 2, '[\%attr]', tl 0
, flags 0x1
install_method DBI::dr::set_err , flags 0x0
install_method DBI::dr::func , flags 0x6
install_method DBI::dr::connect_cached usage: min 1, max 5, '[$db [,$user
[,$passwd [,\%attr]]]]', tl 0
, flags 0x1
install_method DBI::st::errstr , flags 0x4
install_method DBI::st::more_results usage: min 1, max 1, '', tl 0
, flags 0x1
install_method DBI::st::blob_read usage: min 4, max 5, '$field, $offset,
$len [, \$buf [, $bufoffset]]', tl 0
, flags 0x1
install_method DBI::st::bind_param_inout_array usage: min 4, max 5, '$parameter,
\@var, $maxlen, [, \%attr]', tl 0
, flags 0x1
install_method DBI::st::fetchall_hashref usage: min 2, max 2, '', tl 0
, flags 0x1
install_method DBI::st::err , flags 0x4
install_method DBI::st::CLEAR , flags 0x4
install_method DBI::st::state usage: min 1, max 1, '', tl 0
, flags 0x5
install_method DBI::st::_not_impl
install_method DBI::st::trace usage: min 1, max 3, '[$trace_level,
[$filename]]', tl 0
, flags 0x5
install_method DBI::st::_get_fbav
install_method DBI::st::debug usage: min 1, max 2, '[$debug_level]', tl 0
, flags 0x5
install_method DBI::st::fetchrow
install_method DBI::st::_set_fbav , flags 0x0
install_method DBI::st::execute_array usage: min 2, max 0, '\%attribs [,
@args]', tl 0
, flags 0x1
install_method DBI::st::fetch
install_method DBI::st::fetchrow_array
install_method DBI::st::DESTROY
install_method DBI::st::event usage: min 2, max 0, '$type, @args', tl 0
, flags 0x5
install_method DBI::st::STORE , flags 0x410
install_method DBI::st::bind_col usage: min 3, max 4, '$column, \$var [,
\%attr]', tl 0
, flags 0x1
install_method DBI::st::private_data usage: min 1, max 1, '', tl 0
, flags 0x5
install_method DBI::st::fetchrow_arrayref
install_method DBI::st::cancel usage: min 1, max 1, '', tl 0
, flags 0x1
install_method DBI::st::trace_msg usage: min 2, max 3, '$message_text [,
$min_level ]', tl 8
, flags 0x5
install_method DBI::st::finish usage: min 1, max 1, '', tl 0
, flags 0x1
install_method DBI::st::rows , flags 0x4
install_method DBI::st::NEXTKEY , flags 0x4
install_method DBI::st::fetchrow_hashref
install_method DBI::st::dump_results usage: min 1, max 5, '$maxfieldlen,
$linesep, $fieldsep, $filehandle', tl 0
, flags 0x1
install_method DBI::st::bind_param_array usage: min 3, max 4, '$parameter,
$var [, \%attr]', tl 0
, flags 0x1
install_method DBI::st::EXISTS , flags 0x4
install_method DBI::st::FETCH , flags 0x404
install_method DBI::st::FIRSTKEY , flags 0x4
install_method DBI::st::set_err , flags 0x0
install_method DBI::st::execute usage: min 1, max 0, '[@args]', tl 0
, flags 0x41
install_method DBI::st::fetchall_arrayref usage: min 1, max 3, '', tl 0
, flags 0x1
install_method DBI::st::bind_param_inout usage: min 4, max 5, '$parameter,
\$var, $maxlen, [, \%attr]', tl 0
, flags 0x1
install_method DBI::st::bind_columns usage: min 2, max 0, '\$var1 [, \$var2,
...]', tl 0
, flags 0x1
install_method DBI::st::func , flags 0x6
install_method DBI::st::blob_copy_to_file usage: min 3, max 3, '$field,
$filename_or_handleref', tl 0
, flags 0x1
install_method DBI::st::bind_param usage: min 3, max 4, '$parameter, $var [,
\%attr]', tl 0
, flags 0x1
-> DBI->connect(dbi:Ingres:its-admin1::csadminp, dbguest, ****, HASH(0x1400025d0))
-> DBI->install_driver(Ingres) for dec_osf perl=5.008 pid=11150 ruid=100 euid=100
install_driver: DBD::Ingres version 0.34 loaded from
/usr/local/lib/perl5/site_perl/5.8.0/alpha-dec_osf-multi/DBD/Ingres.pm
New DBI::dr (for DBD::Ingres::dr, parent=, id=)
dbih_setup_handle(DBI::dr=HASH(0x14000b7a0)=>DBI::dr=HASH(0x1401114f0),
DBD::Ingres::dr, 0, Null!)
dbih_make_com(Null!, DBD::Ingres::dr, 152) thr#140004000
dbih_setup_attrib(DBI::dr=HASH(0x1401114f0), Err, Null!) SCALAR(0x1401150b0)
(already defined)
dbih_setup_attrib(DBI::dr=HASH(0x1401114f0), State, Null!) SCALAR(0x14000ba60)
(already defined)
dbih_setup_attrib(DBI::dr=HASH(0x1401114f0), Errstr, Null!) SCALAR(0x140115080)
(already defined)
dbih_setup_attrib(DBI::dr=HASH(0x1401114f0), Debug, Null!) 0 (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x1401114f0), FetchHashKeyName, Null!) 'NAME'
(already defined)
<- install_driver= DBI::dr=HASH(0x14000b7a0)
>> connect DISPATCH (DBI::dr=HASH(0x14000b7a0) rc1/3 @5 g0 ima1 pid#11150) at
/usr/local/lib/perl5/site_perl/5.8.0/alpha-dec_osf-multi/DBI.pm line 503 via DBITest
line 2
-> connect for DBD::Ingres::dr (DBI::dr=HASH(0x14000b7a0)~0x1401114f0
'its-admin1::csadminp' 'dbguest' **** HASH(0x140123230))
New DBI::db (for DBD::Ingres::db, parent=DBI::dr=HASH(0x1401114f0), id=)
dbih_setup_handle(DBI::db=HASH(0x1401114a0)=>DBI::db=HASH(0x140111430),
DBD::Ingres::db, 14000b3e0, Null!)
dbih_make_com(DBI::dr=HASH(0x1401114f0), DBD::Ingres::db, 176) thr#140004000
dbih_setup_attrib(DBI::db=HASH(0x140111430), Err, DBI::dr=HASH(0x1401114f0))
SCALAR(0x1401150b0) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x140111430), State, DBI::dr=HASH(0x1401114f0))
SCALAR(0x14000ba60) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x140111430), Errstr, DBI::dr=HASH(0x1401114f0))
SCALAR(0x140115080) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x140111430), Debug, DBI::dr=HASH(0x1401114f0)) 0
(already defined)
dbih_setup_attrib(DBI::db=HASH(0x140111430), FetchHashKeyName,
DBI::dr=HASH(0x1401114f0)) 'NAME' (already defined)
dbih_setup_attrib(DBI::db=HASH(0x140111430), HandleError,
DBI::dr=HASH(0x1401114f0)) undef (not defined)
DBD::Ingres::dbd_db_login: dbname: its-admin1::csadminp
user='dbguest', opt=''
After connect, sqlcode=0, session=1
DBD::Ingres::dbd_db_connect(AUTOCOMMIT=0)
<- connect= DBI::db=HASH(0x1401114a0) at
/usr/local/lib/perl5/site_perl/5.8.0/alpha-dec_osf-multi/DBI.pm line 503 via DBITest
line 2
>> STORE DISPATCH (DBI::db=HASH(0x140111430) rc2/1 @3 g0 ima410 pid#11150)
at /usr/local/lib/perl5/site_perl/5.8.0/alpha-dec_osf-multi/DBI.pm line 545 via
DBITest line 2
-> STORE for DBD::Ingres::db (DBI::db=HASH(0x140111430)~INNER 'PrintError' 1)
STORE DBI::db=HASH(0x140111430) 'PrintError' => 1
<- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/alpha-dec_osf-multi/DBI.pm
line 545 via DBITest line 2
>> STORE DISPATCH (DBI::db=HASH(0x140111430) rc2/1 @3 g0 ima410 pid#11150)
at /usr/local/lib/perl5/site_perl/5.8.0/alpha-dec_osf-multi/DBI.pm line 545 via
DBITest line 2
-> STORE for DBD::Ingres::db (DBI::db=HASH(0x140111430)~INNER 'AutoCommit' 0)
DBD::Ingres::dbd_db_FETCH(TRANSACTION=0)sqlca=0
DBD::Ingres::dbd_db_STORE(AUTOCOMMIT=OFF), sqlcode=0
<- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/alpha-dec_osf-multi/DBI.pm
line 545 via DBITest line 2
<- connect= DBI::db=HASH(0x1401114a0)
-> DBI->connect(dbi:Pg:dbname=netdbase;host=its-dev2.massey.ac.nz, netdbase, ****)
-> DBI->install_driver(Pg) for dec_osf perl=5.008 pid=11150 ruid=100 euid=100
install_driver: DBD::Pg version 1.13 loaded from
/usr/local/lib/perl5/site_perl/5.8.0/alpha-dec_osf-multi/DBD/Pg.pm
New DBI::dr (for DBD::Pg::dr, parent=, id=)
dbih_setup_handle(DBI::dr=HASH(0x1401115b0)=>DBI::dr=HASH(0x140225110),
DBD::Pg::dr, 0, Null!)
dbih_make_com(Null!, DBD::Pg::dr, 152) thr#140004000
dbih_setup_attrib(DBI::dr=HASH(0x140225110), Err, Null!) SCALAR(0x140111cb0)
(already defined)
dbih_setup_attrib(DBI::dr=HASH(0x140225110), State, Null!) SCALAR(0x140111490)
(already defined)
dbih_setup_attrib(DBI::dr=HASH(0x140225110), Errstr, Null!) SCALAR(0x140111ce0)
(already defined)
dbih_setup_attrib(DBI::dr=HASH(0x140225110), Debug, Null!) 0 (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x140225110), FetchHashKeyName, Null!) 'NAME'
(already defined)
<- install_driver= DBI::dr=HASH(0x1401115b0)
>> connect DISPATCH (DBI::dr=HASH(0x1401115b0) rc1/3 @5 g0 ima1 pid#11150) at
/usr/local/lib/perl5/site_perl/5.8.0/alpha-dec_osf-multi/DBI.pm line 503 via DBITest
line 5
-> connect for DBD::Pg::dr (DBI::dr=HASH(0x1401115b0)~0x140225110
'dbname=netdbase;host=its-dev2.massey.ac.nz' 'netdbase' **** HASH(0x14012bc60))
New DBI::db (for DBD::Pg::db, parent=DBI::dr=HASH(0x140225110), id=)
dbih_setup_handle(DBI::db=HASH(0x1402250c0)=>DBI::db=HASH(0x140225050),
DBD::Pg::db, 1401115c0, Null!)
dbih_make_com(DBI::dr=HASH(0x140225110), DBD::Pg::db, 168) thr#140004000
dbih_setup_attrib(DBI::db=HASH(0x140225050), Err, DBI::dr=HASH(0x140225110))
SCALAR(0x140111cb0) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x140225050), State, DBI::dr=HASH(0x140225110))
SCALAR(0x140111490) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x140225050), Errstr, DBI::dr=HASH(0x140225110))
SCALAR(0x140111ce0) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x140225050), Debug, DBI::dr=HASH(0x140225110)) 0
(already defined)
dbih_setup_attrib(DBI::db=HASH(0x140225050), FetchHashKeyName,
DBI::dr=HASH(0x140225110)) 'NAME' (already defined)
dbih_setup_attrib(DBI::db=HASH(0x140225050), HandleError,
DBI::dr=HASH(0x140225110)) undef (not defined)
pg_db_login
pg_db_login: conn_str = >dbname=netdbase host=its-dev2.massey.ac.nz user=netdbase<
<- connect= DBI::db=HASH(0x1402250c0) at
/usr/local/lib/perl5/site_perl/5.8.0/alpha-dec_osf-multi/DBI.pm line 503 via DBITest
line 5
>> STORE DISPATCH (DBI::db=HASH(0x140225050) rc2/1 @3 g0 ima410 pid#11150)
at /usr/local/lib/perl5/site_perl/5.8.0/alpha-dec_osf-multi/DBI.pm line 545 via
DBITest line 5
-> STORE for DBD::Pg::db (DBI::db=HASH(0x140225050)~INNER 'PrintError' 1)
set session_db(1075856384)
E_LQ00BE Attempt to switch to a non-existent session.
STORE DBI::db=HASH(0x140225050) 'PrintError' => 1
<- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/alpha-dec_osf-multi/DBI.pm
line 545 via DBITest line 5
>> STORE DISPATCH (DBI::db=HASH(0x140225050) rc2/1 @3 g0 ima410 pid#11150)
at /usr/local/lib/perl5/site_perl/5.8.0/alpha-dec_osf-multi/DBI.pm line 545 via
DBITest line 5
-> STORE for DBD::Pg::db (DBI::db=HASH(0x140225050)~INNER 'AutoCommit' 1)
DBD::Ingres::dbd_db_FETCH(TRANSACTION=0)sqlca=0
DBD::Ingres::dbd_db_STORE(AUTOCOMMIT=ON), sqlcode=0
<- STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.0/alpha-dec_osf-multi/DBI.pm
line 545 via DBITest line 5
<- connect= DBI::db=HASH(0x1402250c0)
>> prepare DISPATCH (DBI::db=HASH(0x1402250c0) rc1/1 @2 g0 ima1 pid#11150) at
DBITest line 8
-> prepare for DBD::Pg::db (DBI::db=HASH(0x1402250c0)~0x140225050 'select count(*)
from site')
New DBI::st (for DBD::Pg::st, parent=DBI::db=HASH(0x140225050), id=)
dbih_setup_handle(DBI::st=HASH(0x1402251c0)=>DBI::st=HASH(0x1402233e0),
DBD::Pg::st, 1402251d0, Null!)
dbih_make_com(DBI::db=HASH(0x140225050), DBD::Pg::st, 248) thr#140004000
dbih_setup_attrib(DBI::st=HASH(0x1402233e0), Err, DBI::db=HASH(0x140225050))
SCALAR(0x140111cb0) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x1402233e0), State, DBI::db=HASH(0x140225050))
SCALAR(0x140111490) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x1402233e0), Errstr, DBI::db=HASH(0x140225050))
SCALAR(0x140111ce0) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x1402233e0), Debug, DBI::db=HASH(0x140225050)) 0
(already defined)
dbih_setup_attrib(DBI::st=HASH(0x1402233e0), FetchHashKeyName,
DBI::db=HASH(0x140225050)) 'NAME' (already defined)
dbih_setup_attrib(DBI::st=HASH(0x1402233e0), HandleError,
DBI::db=HASH(0x140225050)) undef (not defined)
DBD::Ingres::dbd_st_prepare('select count(*) from site')
Statement = select count(*) from site
Statement = count(*) from site
Statement3 = count(*) from site
gen_st.nam alloc first time returns 0
Name = s0
Name1 =
Name2 = @
DBD::Ingres::dbd_st_prepare stmt('select count(*) from site') name:s0_countfromsite,
sqlda: 1401f4b48
DBD::Ingres:sql_check: sqlcode=-30100 get errtext got errtext: 'E_US0845 Table 'site'
does not exist or is not owned by you.
(Tue Oct 1 08:56:09 2002)', returning
>> DESTROY DISPATCH (DBI::st=HASH(0x1402251c0) rc1/1 @1 g0 ima0 pid#11150) at
DBITest line 8
<> DESTROY ignored for outer handle DBI::st=HASH(0x1402251c0) (inner
DBI::st=HASH(0x1402233e0))
>> DESTROY DISPATCH (DBI::st=HASH(0x1402233e0) rc1/1 @1 g0 ima0 pid#11150) at
DBITest line 8
-> DESTROY for DBD::Pg::st (DBI::st=HASH(0x1402233e0)~INNER)
Statement handle DBI::st=HASH(0x1402233e0) DESTROY ignored - never set up at DBITest
line 8.
<- DESTROY= undef at DBITest line 8
dbih_clearcom (sth 0x1402251c0 0x1401f51b0, com 0x1401f4a80, imp DBD::Pg::st):
FLAGS 0x111: COMSET Warn PrintError
PARENT DBI::db=HASH(0x140225050)
KIDS 0 (0 Active)
IMP_DATA undef
NUM_OF_FIELDS 0
NUM_OF_PARAMS 0
dbih_clearcom 0x1402251c0 (com 0x1401f4a80, type 3) done.
!! ERROR: -30100 'E_US0845 Table 'site' does not exist or is not owned by you.
(Tue Oct 1 08:56:09 2002)'
<- prepare= undef at DBITest line 8
DBD::Pg::db prepare failed: E_US0845 Table 'site' does not exist or is not owned by
you.
(Tue Oct 1 08:56:09 2002) at DBITest line 8.
-> $DBI::errstr (&) FETCH from lasth=HASH
>> DBD::Pg::db::errstr
Prep failedE_US0845 Table 'site' does not exist or is not owned by you.
(Tue Oct 1 08:56:09 2002) at DBITest line 8.
-- DBI::END
>> disconnect_all DISPATCH (DBI::dr=HASH(0x14000b7a0) rc1/3 @1 g0 ima1 pid#11150)
at /usr/local/lib/perl5/site_perl/5.8.0/alpha-dec_osf-multi/DBI.pm line 565 via
DBITest line 0
-> disconnect_all for DBD::Ingres::dr (DBI::dr=HASH(0x14000b7a0)~0x1401114f0)
<- disconnect_all= '' at
/usr/local/lib/perl5/site_perl/5.8.0/alpha-dec_osf-multi/DBI.pm line 565 via DBITest
line 0
>> disconnect_all DISPATCH (DBI::dr=HASH(0x1401115b0) rc1/3 @1 g0 ima1 pid#11150)
at /usr/local/lib/perl5/site_perl/5.8.0/alpha-dec_osf-multi/DBI.pm line 565 via
DBITest line 0
-> disconnect_all for DBD::Pg::dr (DBI::dr=HASH(0x1401115b0)~0x140225110)
<- disconnect_all= '' at
/usr/local/lib/perl5/site_perl/5.8.0/alpha-dec_osf-multi/DBI.pm line 565 via DBITest
line 0
>> DESTROY DISPATCH (DBI::dr=HASH(0x1401115b0) rc1/1 @1 g0 ima0 pid#11150)
during global destruction
<> DESTROY for DBI::dr=HASH(0x1401115b0) ignored (inner handle gone)
>> DESTROY DISPATCH (DBI::db=HASH(0x140111430) rc1/1 @1 g0 ima0 pid#11150)
during global destruction
-> DESTROY for DBD::Ingres::db (DBI::db=HASH(0x140111430)~INNER)
Issuing rollback() for database handle being DESTROY'd without explicit disconnect()
during global destruction.
DBD::Ingres::dbd_db_rollback
set session_db(1)
DBD::Ingres::dbd_db_disconnect
DBD::Ingres::dbd_db_destroy
<- DESTROY= undef during global destruction
dbih_clearcom (dbh 0x1401114a0 0x140022300, com 0x1401e7680, imp DBD::Ingres::db):
FLAGS 0x111: COMSET Warn PrintError
PARENT DBI::dr=HASH(0x1401114f0)
KIDS 0 (0 Active)
IMP_DATA undef
>> DESTROY DISPATCH (DBI::dr=HASH(0x1401114f0) rc1/1 @1 g0 ima0 pid#11150)
during global destruction
-> DESTROY in DBD::_::common for DBD::Ingres::dr (DBI::dr=HASH(0x1401114f0)~INNER)
<- DESTROY= undef during global destruction
dbih_clearcom (drh 0x14000b7a0 0x14004f3e0, com 0x1401e7440, imp DBD::Ingres::dr):
FLAGS 0x215: COMSET Active Warn AutoCommit
PARENT undef
KIDS 1 (1 Active)
IMP_DATA undef
dbih_clearcom 0x14000b7a0 (com 0x1401e7440, type 1) done.
dbih_clearcom 0x1401114a0 (com 0x1401e7680, type 2) done.
>> DESTROY DISPATCH (DBI::dr=HASH(0x140225110) rc1/1 @1 g0 ima0 pid#11150)
during global destruction
-> DESTROY in DBD::_::dr for DBD::Pg::dr (DBI::dr=HASH(0x140225110)~INNER)
<- DESTROY= undef during global destruction
dbih_clearcom (drh 0x1401115b0 0x0, com 0x1402260c0, imp DBD::Pg::dr):
FLAGS 0x215: COMSET Active Warn AutoCommit
PARENT undef
KIDS 1 (1 Active)
IMP_DATA undef
dbih_clearcom 0x1401115b0 (com 0x1402260c0, type 1) done.
>> DESTROY DISPATCH (DBI::db=HASH(0x1402250c0) rc1/1 @1 g0 ima0 pid#11150)
during global destruction
<> DESTROY ignored for outer handle DBI::db=HASH(0x1402250c0) (inner
DBI::db=HASH(0x140225050))
>> DESTROY DISPATCH (DBI::db=HASH(0x140225050) rc1/1 @1 g0 ima0 pid#11150)
during global destruction
-> DESTROY for DBD::Pg::db (DBI::db=HASH(0x140225050)~INNER)
Database handle destroyed without explicit disconnect during global destruction.
DBD::Ingres::dbd_db_disconnect
set session_db(1075856384)
E_LQ00BE Attempt to switch to a non-existent session.
DBD::Ingres::dbd_db_destroy
<- DESTROY= undef during global destruction
dbih_clearcom (dbh 0x1402250c0 0x1401f6650, com 0x140226300, imp DBD::Pg::db):
FLAGS 0x311: COMSET Warn PrintError AutoCommit
PARENT undef
KIDS 0 (0 Active)
IMP_DATA undef
dbih_clearcom 0x1402250c0 (com 0x140226300, type 2) done.
>> DESTROY DISPATCH (DBI::dr=HASH(0x14000b7a0) rc1/1 @1 g0 ima0 pid#11150)
during global destruction
<> DESTROY for DBI::dr=HASH(0x14000b7a0) ignored (inner handle gone)
>> DESTROY DISPATCH (DBI::db=HASH(0x1401114a0) rc1/1 @1 g0 ima0 pid#11150)
during global destruction
<> DESTROY for DBI::db=HASH(0x1401114a0) ignored (inner handle gone)
T2.(its-dev1)work: exit
exit
script done on Tue Oct 1 08:56:11 2002
--
.*. | 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
^^-^^ |------------------------------------------------------------
