I just did an upgrade from 2.0.11 to 2.0.14 and got this message
during the insertdata step:
% rt2/etc/insertdata 2.0.11
Looking for new objects to add to the database since 2.0.11
Database handle destroyed without explicit disconnect at /usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 267.
Creating ACL…done.
Creating users…done.
Creating groups…done.
Creating queues…done.
Creating ScripActions…11.12.done.
Creating ScripConditions…done.
Creating templates…done.
Creating Scrips…38.39.done.
%
I have latest versions of all perl modules except mason, which I kept
at 1.05.
Vivek Khera wrote:
Database handle destroyed without explicit disconnect at /usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 267.
I have latest versions of all perl modules except mason, which I kept
at 1.05.
Can you expand on “latest versions” with respect to DBIx::SearchBuilder?
Phil Homewood, Systems Janitor, www.SnapGear.com
pdh@snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630
SnapGear - Custom Embedded Solutions and Security Appliances
“PH” == Phil Homewood pdh@snapgear.com writes:
PH> Vivek Khera wrote:
Database handle destroyed without explicit disconnect at /usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 267.
I have latest versions of all perl modules except mason, which I kept
at 1.05.
PH> Can you expand on “latest versions” with respect to DBIx::SearchBuilder?
Whatever CPAN says is the latest…
CPANm DBIx::SearchBuilder
Module id = DBIx::SearchBuilder
CPAN_USERID JESSE (Jesse Vincent jesse+cpan@fsck.com)
CPAN_VERSION 0.61
CPAN_FILE J/JE/JESSE/DBIx-SearchBuilder-0.61.tar.gz
MANPAGE DBIx::SearchBuilder - Perl extension for easy SQL SELECT Statement generation
INST_FILE /usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm
INST_VERSION 0.61
Vivek Khera wrote:
Database handle destroyed without explicit disconnect at /usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 267.
Module id = DBIx::SearchBuilder
CPAN_VERSION 0.61
OK, you’re beyond my ability to debug now. 
It appears that
DBIx::SearchBuilder::Handle::dbh() is being called with a bogus
arg (0 or undef, probably.) More context would be required to
further track this.
Phil Homewood, Systems Janitor, www.SnapGear.com
pdh@snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630
SnapGear - Custom Embedded Solutions and Security Appliances
Phil Homewood wrote:
OK, you’re beyond my ability to debug now. It appears that
DBIx::SearchBuilder::Handle::dbh() is being called with a bogus
arg (0 or undef, probably.) More context would be required to
further track this.
Or not. Try this:
Index: insertdata
RCS file: /cvs/local/rt/tools/insertdata,v
retrieving revision 1.1.1.4
diff -u -r1.1.1.4 insertdata
— insertdata 15 Jul 2002 01:25:46 -0000 1.1.1.4
+++ insertdata 13 Aug 2002 01:14:15 -0000
@@ -95,6 +95,9 @@
#Load etc/config.pm and drop privs
LoadConfig();
+#Disconnect from the DB so we can reconnect using the real API
+$RT::Handle->Disconnect();
#Connect to the database and get RT::SystemUser and RT::Nobody loaded
DBConnect();
Phil Homewood, Systems Janitor, www.SnapGear.com
pdh@snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630
SnapGear - Custom Embedded Solutions and Security Appliances
“PH” == Phil Homewood pdh@snapgear.com writes:
PH> Vivek Khera wrote:
Database handle destroyed without explicit disconnect at /usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 267.
Module id = DBIx::SearchBuilder
CPAN_VERSION 0.61
PH> OK, you’re beyond my ability to debug now. It appears that
PH> DBIx::SearchBuilder::Handle::dbh() is being called with a bogus
PH> arg (0 or undef, probably.) More context would be required to
PH> further track this.
It isn’t a fatal problem… just a warning. I haven’t gotten a chance
to dive into it yet, but it does also show up in my httpd error log.
Just looks to me like a variable going out of scope before being
explicitly destroyed (hey, that’s the error message!)