Postgres Users: DBIx::SearchBuilder 1.00_06

RT Developers
1

I’ve just uploaded DBIx::SearchBuilder 1.00_06 to CPAN. This release
includes additional query-builder enhancements for PostgreSQL (and
Oracle). One heavy test site reports a significant performance
improvement across the board. I’d love to hear how folks do with this
release.

Best,
Jesse
2

I’ve just uploaded DBIx::SearchBuilder 1.00_06 to CPAN. This release
includes additional query-builder enhancements for PostgreSQL (and
Oracle). One heavy test site reports a significant performance
improvement across the board. I’d love to hear how folks do with this
release.

After installing the package RT barfs (HTTP error 500) and I get this
error in the log file:

[Wed Jun 23 13:45:22 2004] [error] Can’t locate object method “new”
via package “RT::Handle” at /opt/RT/lib/RT.pm line 147.\n

That looks somewhat surprising. in your lib/RT/Handle.pm, can you
alter the code at the beginning to read:

eval “use DBIx::SearchBuilder::Handle::$RT::DatabaseType;
@ISA= qw(DBIx::SearchBuilder::Handle::$RT::DatabaseType);”;

if ($@) {
die “Unable to load DBIx::SearchBuilder database handle for
‘$RT::DatabaseType’.”.
“\n”.
“Perhaps you’ve picked an invalid database type or spelled it
incorrectly.”.
“\n”. $@;
}

and then retest. That will get us a better error message.

3
  • Jussi Hamalainen:

After installing the package RT barfs (HTTP error 500) and I get this
error in the log file:

[Wed Jun 23 13:45:22 2004] [error] Can’t locate object method “new”
via package “RT::Handle” at /opt/RT/lib/RT.pm line 147.\n

Reinstalling version 0.99 fixes the problem. I’m using Perl 5.8.4.

Newer DBIx::SearchBuilder versions require the Want Perl module from
CPAN.

Current mail filters: many dial-up/DSL/cable modem hosts, and the
following domains: bigpond.com, di-ve.com, fuorissimo.com, hotmail.com,
jumpy.it, libero.it, netscape.net, postino.it, simplesnet.pt, spymac.com,
tiscali.co.uk, tiscali.cz, tiscali.it, voila.fr, yahoo.com.

4
  • Jesse Vincent:

[Wed Jun 23 13:45:22 2004] [error] Can’t locate object method “new”
via package “RT::Handle” at /opt/RT/lib/RT.pm line 147.\n

That looks somewhat surprising.

Well, actually no. If DBIx::SearchBuilder fails to load some of the
database-specific code, it tends to fail silently, without printing a
proper error message.

I learnt that the hard way when I had to look a foreign system for two
hours before I noticed that the permissions on some of the Perl files
were wrong (so that they weren’t readable for the web server process).

5

That looks somewhat surprising.

Well, actually no. If DBIx::SearchBuilder fails to load some of the
database-specific code, it tends to fail silently, without printing a
proper error message.

Right. That’s something we’ve already fixed for 3.2.

6

I’ve just uploaded DBIx::SearchBuilder 1.00_06 to CPAN. This release
includes additional query-builder enhancements for PostgreSQL (and
Oracle). One heavy test site reports a significant performance
improvement across the board. I’d love to hear how folks do with this
release.

It’s definitely faster for me in every way, excellent work!

Tested on RT 3.0.11, PostgreSQL 7.3.4

7
  • Jesse Vincent:

I’ve just uploaded DBIx::SearchBuilder 1.00_06 to CPAN. This release
includes additional query-builder enhancements for PostgreSQL (and
Oracle). One heavy test site reports a significant performance
improvement across the board. I’d love to hear how folks do with this
release.

The UTF-8 issue has been fixed (we had a similar bugfix in place for
quite some time). Performance with RT 3.0.11 has improved noticeably
(I think, I failed to do before/after benchmarks).

Debian folks, beware: there’s a new dependency on libwant-perl (not
yet in Debian, I might upload it later this week if nobody else does).

Current mail filters: many dial-up/DSL/cable modem hosts, and the
following domains: bigpond.com, di-ve.com, fuorissimo.com, hotmail.com,
jumpy.it, libero.it, netscape.net, postino.it, simplesnet.pt, spymac.com,
tiscali.co.uk, tiscali.cz, tiscali.it, voila.fr, yahoo.com.

8

I’ve just uploaded DBIx::SearchBuilder 1.00_06 to CPAN. This release
includes additional query-builder enhancements for PostgreSQL (and
Oracle). One heavy test site reports a significant performance
improvement across the board. I’d love to hear how folks do with this
release.

After installing the package RT barfs (HTTP error 500) and I get this
error in the log file:

[Wed Jun 23 13:45:22 2004] [error] Can’t locate object method “new”
via package “RT::Handle” at /opt/RT/lib/RT.pm line 147.\n

Reinstalling version 0.99 fixes the problem. I’m using Perl 5.8.4.

-=[ Count Zero / TBH - Jussi H�m�l�inen - email count@theblah.fi ]=-

9

What is this Want.pm?

Ok, this is where I go hit myself in the head with a baseball bat. I
pulled the Want-module from CPAN and DBIx::SearchBuilder 1.00_06
works like a charm now. Seems a whole lot faster, too.

Thanks, Jesse!

-=[ Count Zero / TBH - Jussi H�m�l�inen - email count@theblah.fi ]=-

10

That looks somewhat surprising. in your lib/RT/Handle.pm, can you
alter the code at the beginning to read:

eval “use DBIx::SearchBuilder::Handle::$RT::DatabaseType;
@ISA= qw(DBIx::SearchBuilder::Handle::$RT::DatabaseType);”;

if ($@) {
die “Unable to load DBIx::SearchBuilder database handle for
‘$RT::DatabaseType’.”.
“\n”.
“Perhaps you’ve picked an invalid database type or spelled it
incorrectly.”.
“\n”. $@;
}

I finally got around to testing this. Looks like I’m missing a perl
module or something:

[Thu Jul 8 08:05:55 2004] [error] Unable to load DBIx::SearchBuilder
database handle for’Pg’.\nPerhaps you’ve picked an invalid database
type or spelled itincorrectly.\nCan’t locate Want.pm in @INC (@INC
contains: /opt/RT/local/lib /opt/RT/lib
/opt/lang/lib/perl5/5.8.4/i686-linux /opt/lang/lib/perl5/5.8.4
/opt/lang/lib/perl5/site_perl/5.8.4/i686-linux
/opt/lang/lib/perl5/site_perl/5.8.4 /opt/lang/lib/perl5/site_perl .
/opt/apache/ /opt/apache/lib/perl) at
/opt/lang/lib/perl5/site_perl/5.8.4/DBIx/SearchBuilder/Handle/Pg.pm
line 9.\nBEGIN failed–compilation aborted at
/opt/lang/lib/perl5/site_perl/5.8.4/DBIx/SearchBuilder/Handle/Pg.pm
line 9.\nCompilation failed in require at (eval 354) line 1.\nBEGIN
failed–compilation aborted at (eval 354) line 1.\nCompilation failed
in require at /opt/RT/lib/RT.pm line 145.\n

What is this Want.pm?

-=[ Count Zero / TBH - Jussi H�m�l�inen - email count@theblah.fi ]=-