Problem Tools, Reports Postgres 3.8.2

Postgres: 8.3.6
RT 3.8.2
CentOS 4

My graphing isn’t working under Tools>Reports.

Any ideas?

Cheers,
Kristian

/var/log/message

Mar 12 10:50:27 ghole postgres[11326]: [2-1] ERROR: function
lower(timestamp without time zone) does not exist at character 315
Mar 12 10:50:27 ghole postgres[11326]: [2-2] HINT: No function
matches the given name and argument types. You might need to add
explicit type casts.
Mar 12 10:50:27 ghole postgres[11326]: [2-3] STATEMENT: SELECT
COUNT(main.id) AS id, Users_2.Name AS col1 FROM ( SELECT DISTINCT
main.id FROM Tickets main LEFT JOIN Users
Mar 12 10:50:27 ghole postgres[11326]: [2-4] Users_2 ON ( Users_2.id
= main.Owner ) LEFT JOIN Users Users_1 ON ( Users_1.id = main.Owner )
WHERE (LOWER(main.Status) !=
Mar 12 10:50:27 ghole postgres[11326]: [2-5] ‘deleted’) AND
(LOWER(main.Status) = ‘resolved’ AND main.Queue = ‘1’ AND
LOWER(main.Resolved) > ‘2009-01-01 00:00:00’) AND
Mar 12 10:50:27 ghole postgres[11326]: [2-6] (LOWER(main.Type) =
‘ticket’) AND (main.EffectiveId = main.id) ) distinctquery, Tickets
main WHERE (main.id =
Mar 12 10:50:27 ghole postgres[11326]: [2-7] distinctquery.id) GROUP
BY Users_1.Name
Mar 12 10:50:28 ghole postgres[11327]: [2-1] ERROR: function
lower(timestamp without time zone) does not exist at character 265
Mar 12 10:50:28 ghole postgres[11327]: [2-2] HINT: No function
matches the given name and argument types. You might need to add
explicit type casts.
Mar 12 10:50:28 ghole postgres[11327]: [2-3] STATEMENT: SELECT
COUNT(DISTINCT main.id) FROM Tickets main LEFT JOIN Users Users_2 ON
( Users_2.id = main.Owner ) LEFT JOIN
Mar 12 10:50:28 ghole postgres[11327]: [2-4] Users Users_1 ON (
Users_1.id = main.Owner ) WHERE (LOWER(main.Status) != ‘deleted’) AND
(LOWER(main.Status) = ‘resolved’ AND
Mar 12 10:50:28 ghole postgres[11327]: [2-5] main.Queue = ‘1’ AND
LOWER(main.Resolved) > ‘2009-01-01 00:00:00’) AND (LOWER(main.Type) =
‘ticket’) AND (main.EffectiveId =
Mar 12 10:50:28 ghole postgres[11327]: [2-6] main.id)

/rt.log

HINT: No function matches the given name and argument types. You
might need to add explicit type casts. at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505.
(/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505)
[Thu Mar 12 10:50:27 2009] [warning]: RT::Handle=HASH(0xaa0d998)
couldn’t execute the query 'SELECT COUNT(main.id) AS id, Users_2.Name
AS col1 FROM ( SELECT DISTINCT main.id FROM Tickets main LEFT JOIN
Users Users_2 ON ( Users_2.id = main.Owner ) LEFT JOIN Users Users_1
ON ( Users_1.id = main.Owner ) WHERE (LOWER(main.Status) !=
‘deleted’) AND (LOWER(main.Status) = ‘resolved’ AND main.Queue = '1’
AND LOWER(main.Resolved) > ‘2009-01-01 00:00:00’) AND
(LOWER(main.Type) = ‘ticket’) AND (main.EffectiveId = main.id) )
distinctquery, Tickets main WHERE (main.id = distinctquery.id) GROUP
BY Users_1.Name ’ at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0xaa0d998)’,
‘SELECT COUNT(main.id) AS id, Users_2.Name AS col1 FROM ( SELE…’)
called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line
238
DBIx::SearchBuilder::_DoSearch(‘RT::Report::Tickets=HASH(0xb166a58)’)
called at /disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Tickets_Overlay.pm
line 2672
RT::tickets::_DoSearch(‘RT::Report::Tickets=HASH(0xb166a58)’)
called at /disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Report/Tickets.pm
line 152
RT::Report::tickets::_DoSearch(‘RT::Report::Tickets=HASH(0xb166a58)’)
called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line
498
DBIx::SearchBuilder::Next(‘RT::Report::Tickets=HASH(0xb166a58)’)
called at /disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Report/Tickets.pm
line 236
RT::Report::tickets::Next(‘RT::Report::Tickets=HASH(0xb166a58)’)
called at /disk1/web/vhost/rt.local/rt/share/html/Search/Elements/Chart
line 71
HTML::Mason::Commands::ANON(‘Query’, ‘Status =
‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xb169ca0)’,
‘Query’, ‘Status = ‘resolved’ AND Queue = ‘Systems’ AND Resolved >
…’, ‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1278
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘Query’, ‘Status
= ‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/disk1/web/vhost/rt.local/rt/share/html/Tools/Reports/ResolvedByDates.html
line 83
HTML::Mason::Commands::ANON(‘ResolvedBefore’, ‘’,
‘ResolvedAfter’, ‘01/01/2009’, ‘Queue’, ‘Systems’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xaf6cc00)’,
‘ResolvedBefore’, ‘’, ‘ResolvedAfter’, ‘01/01/2009’, ‘Queue’,
‘Systems’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1278
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’,
‘ResolvedBefore’, ‘’, ‘ResolvedAfter’, ‘01/01/2009’, ‘Queue’,
‘Systems’, …) called at
/disk1/web/vhost/rt.local/rt/local/html/autohandler line 311
HTML::Mason::Commands::ANON(‘ResolvedBefore’, ‘’,
‘ResolvedAfter’, ‘01/01/2009’, ‘Queue’, ‘Systems’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xaf70ec4)’,
‘ResolvedBefore’, ‘’, ‘ResolvedAfter’, ‘01/01/2009’, ‘Queue’,
‘Systems’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1273
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’,
‘ResolvedBefore’, ‘’, ‘ResolvedAfter’, ‘01/01/2009’, ‘Queue’,
‘Systems’, …) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 467
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 467
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 419
HTML::Mason::Request::exec(‘RT::Interface::Web::Request=HASH(0xad7ed30)’)
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 168
HTML::Mason::Request::ApacheHandler::exec(‘RT::Interface::Web::Request=HASH(0xad7ed30)’)
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 825
HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(0x9078598)’,
‘Apache2::RequestRec=SCALAR(0xa9c66f0)’) called at
/disk1/web/vhost/rt.local/rt/bin/webmux.pl line 149
eval {…} called at /disk1/web/vhost/rt.local/rt/bin/webmux.pl line 149
RT::Mason::handler(‘Apache2::RequestRec=SCALAR(0xa9c66f0)’)
called at -e line 0
eval {…} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272)
[Thu Mar 12 10:50:28 2009] [debug]: RT’s GnuPG libraries couldn’t
successfully read your configured GnuPG home directory
(/disk1/web/vhost/rt.local/rt/var/data/gpg). PGP support has been
disabled (/disk1/web/vhost/rt.local/rt/bin/…/local/lib/RT/Config.pm:339)
[Thu Mar 12 10:50:28 2009] [debug]: RT::Date used Time::ParseDate to
make ‘2009-01-01 00:00:00’ 1230768000
(/disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Date.pm:209)
[Thu Mar 12 10:50:28 2009] [warning]: DBD::Pg::st execute failed:
ERROR: function lower(timestamp without time zone) does not exist
LINE 1: …ain.Status) = ‘resolved’ AND main.Queue = ‘1’ AND LOWER(main…
^
HINT: No function matches the given name and argument types. You
might need to add explicit type casts. at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505.
(/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505)
[Thu Mar 12 10:50:28 2009] [warning]: RT::Handle=HASH(0xaa0c4d0)
couldn’t execute the query 'SELECT COUNT(DISTINCT main.id) FROM
Tickets main LEFT JOIN Users Users_2 ON ( Users_2.id = main.Owner )
LEFT JOIN Users Users_1 ON ( Users_1.id = main.Owner ) WHERE
(LOWER(main.Status) != ‘deleted’) AND (LOWER(main.Status) = 'resolved’
AND main.Queue = ‘1’ AND LOWER(main.Resolved) > ‘2009-01-01 00:00:00’)
AND (LOWER(main.Type) = ‘ticket’) AND (main.EffectiveId = main.id) '
at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line
518
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0xaa0c4d0)’,
‘SELECT COUNT(DISTINCT main.id) FROM Tickets main LEFT JOIN Us…’)
called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line
294
DBIx::SearchBuilder::_DoCount(‘RT::Report::Tickets=HASH(0xb0db1dc)’)
called at /disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Tickets_Overlay.pm
line 2678
RT::tickets::_DoCount(‘RT::Report::Tickets=HASH(0xb0db1dc)’)
called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line
1380
DBIx::SearchBuilder::Count(‘RT::Report::Tickets=HASH(0xb0db1dc)’)
called at /disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Tickets_Overlay.pm
line 2597
RT::tickets::Count(‘RT::Report::Tickets=HASH(0xb0db1dc)’)
called at /disk1/web/vhost/rt.local/rt/share/html/Search/Chart line 93
HTML::Mason::Commands::ANON(‘Query’, ‘Status =
‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xafb1350)’,
‘Query’, ‘Status = ‘resolved’ AND Queue = ‘Systems’ AND Resolved >
…’, ‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1278
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’, ‘Query’,
‘Status = ‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/disk1/web/vhost/rt.local/rt/local/html/autohandler line 311
HTML::Mason::Commands::ANON(‘Query’, ‘Status =
‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xafd2ef4)’,
‘Query’, ‘Status = ‘resolved’ AND Queue = ‘Systems’ AND Resolved >
…’, ‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1273
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’, ‘Query’,
‘Status = ‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 467
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 467
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 419
HTML::Mason::Request::exec(‘RT::Interface::Web::Request=HASH(0xaf4d518)’)
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 168
HTML::Mason::Request::ApacheHandler::exec(‘RT::Interface::Web::Request=HASH(0xaf4d518)’)
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 825
HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(0x9078598)’,
‘Apache2::RequestRec=SCALAR(0xa9c66d8)’) called at
/disk1/web/vhost/rt.local/rt/bin/webmux.pl line 149
eval {…} called at /disk1/web/vhost/rt.local/rt/bin/webmux.pl line 149
RT::Mason::handler(‘Apache2::RequestRec=SCALAR(0xa9c66d8)’)
called at -e line 0
eval {…} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272)

Postgres: 8.3.6
RT 3.8.2
CentOS 4

My graphing isn’t working under Tools>Reports.

Any ideas?

Cheers,
Kristian

/var/log/message

Mar 12 10:50:27 ghole postgres[11326]: [2-1] ERROR: function
lower(timestamp without time zone) does not exist at character 315
Mar 12 10:50:27 ghole postgres[11326]: [2-2] HINT: No function
matches the given name and argument types. You might need to add
explicit type casts.
Mar 12 10:50:27 ghole postgres[11326]: [2-3] STATEMENT: SELECT
COUNT(main.id) AS id, Users_2.Name AS col1 FROM ( SELECT DISTINCT
main.id FROM Tickets main LEFT JOIN Users
Mar 12 10:50:27 ghole postgres[11326]: [2-4] Users_2 ON ( Users_2.id
= main.Owner ) LEFT JOIN Users Users_1 ON ( Users_1.id = main.Owner )
WHERE (LOWER(main.Status) !=
Mar 12 10:50:27 ghole postgres[11326]: [2-5] ‘deleted’) AND
(LOWER(main.Status) = ‘resolved’ AND main.Queue = ‘1’ AND
LOWER(main.Resolved) > ‘2009-01-01 00:00:00’) AND
Mar 12 10:50:27 ghole postgres[11326]: [2-6] (LOWER(main.Type) =
‘ticket’) AND (main.EffectiveId = main.id) ) distinctquery, Tickets
main WHERE (main.id =
Mar 12 10:50:27 ghole postgres[11326]: [2-7] distinctquery.id) GROUP
BY Users_1.Name
Mar 12 10:50:28 ghole postgres[11327]: [2-1] ERROR: function
lower(timestamp without time zone) does not exist at character 265
Mar 12 10:50:28 ghole postgres[11327]: [2-2] HINT: No function
matches the given name and argument types. You might need to add
explicit type casts.
Mar 12 10:50:28 ghole postgres[11327]: [2-3] STATEMENT: SELECT
COUNT(DISTINCT main.id) FROM Tickets main LEFT JOIN Users Users_2 ON
( Users_2.id = main.Owner ) LEFT JOIN
Mar 12 10:50:28 ghole postgres[11327]: [2-4] Users Users_1 ON (
Users_1.id = main.Owner ) WHERE (LOWER(main.Status) != ‘deleted’) AND
(LOWER(main.Status) = ‘resolved’ AND
Mar 12 10:50:28 ghole postgres[11327]: [2-5] main.Queue = ‘1’ AND
LOWER(main.Resolved) > ‘2009-01-01 00:00:00’) AND (LOWER(main.Type) =
‘ticket’) AND (main.EffectiveId =
Mar 12 10:50:28 ghole postgres[11327]: [2-6] main.id)

/rt.log

HINT: No function matches the given name and argument types. You
might need to add explicit type casts. at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505.
(/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505)
[Thu Mar 12 10:50:27 2009] [warning]: RT::Handle=HASH(0xaa0d998)
couldn’t execute the query 'SELECT COUNT(main.id) AS id, Users_2.Name
AS col1 FROM ( SELECT DISTINCT main.id FROM Tickets main LEFT JOIN
Users Users_2 ON ( Users_2.id = main.Owner ) LEFT JOIN Users Users_1
ON ( Users_1.id = main.Owner ) WHERE (LOWER(main.Status) !=
‘deleted’) AND (LOWER(main.Status) = ‘resolved’ AND main.Queue = '1’
AND LOWER(main.Resolved) > ‘2009-01-01 00:00:00’) AND
(LOWER(main.Type) = ‘ticket’) AND (main.EffectiveId = main.id) )
distinctquery, Tickets main WHERE (main.id = distinctquery.id) GROUP
BY Users_1.Name ’ at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0xaa0d998)’,
‘SELECT COUNT(main.id) AS id, Users_2.Name AS col1 FROM ( SELE…’)
called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line
238
DBIx::SearchBuilder::_DoSearch(‘RT::Report::Tickets=HASH(0xb166a58)’)
called at /disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Tickets_Overlay.pm
line 2672
RT::tickets::_DoSearch(‘RT::Report::Tickets=HASH(0xb166a58)’)
called at /disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Report/Tickets.pm
line 152
RT::Report::tickets::_DoSearch(‘RT::Report::Tickets=HASH(0xb166a58)’)
called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line
498
DBIx::SearchBuilder::Next(‘RT::Report::Tickets=HASH(0xb166a58)’)
called at /disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Report/Tickets.pm
line 236
RT::Report::tickets::Next(‘RT::Report::Tickets=HASH(0xb166a58)’)
called at /disk1/web/vhost/rt.local/rt/share/html/Search/Elements/Chart
line 71
HTML::Mason::Commands::ANON(‘Query’, ‘Status =
‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xb169ca0)’,
‘Query’, ‘Status = ‘resolved’ AND Queue = ‘Systems’ AND Resolved >
…’, ‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1278
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘Query’, ‘Status
= ‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/disk1/web/vhost/rt.local/rt/share/html/Tools/Reports/ResolvedByDates.html
line 83
HTML::Mason::Commands::ANON(‘ResolvedBefore’, ‘’,
‘ResolvedAfter’, ‘01/01/2009’, ‘Queue’, ‘Systems’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xaf6cc00)’,
‘ResolvedBefore’, ‘’, ‘ResolvedAfter’, ‘01/01/2009’, ‘Queue’,
‘Systems’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1278
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’,
‘ResolvedBefore’, ‘’, ‘ResolvedAfter’, ‘01/01/2009’, ‘Queue’,
‘Systems’, …) called at
/disk1/web/vhost/rt.local/rt/local/html/autohandler line 311
HTML::Mason::Commands::ANON(‘ResolvedBefore’, ‘’,
‘ResolvedAfter’, ‘01/01/2009’, ‘Queue’, ‘Systems’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xaf70ec4)’,
‘ResolvedBefore’, ‘’, ‘ResolvedAfter’, ‘01/01/2009’, ‘Queue’,
‘Systems’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1273
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’,
‘ResolvedBefore’, ‘’, ‘ResolvedAfter’, ‘01/01/2009’, ‘Queue’,
‘Systems’, …) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 467
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 467
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 419
HTML::Mason::Request::exec(‘RT::Interface::Web::Request=HASH(0xad7ed30)’)
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 168
HTML::Mason::Request::ApacheHandler::exec(‘RT::Interface::Web::Request=HASH(0xad7ed30)’)
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 825
HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(0x9078598)’,
‘Apache2::RequestRec=SCALAR(0xa9c66f0)’) called at
/disk1/web/vhost/rt.local/rt/bin/webmux.pl line 149
eval {…} called at /disk1/web/vhost/rt.local/rt/bin/webmux.pl line 149
RT::Mason::handler(‘Apache2::RequestRec=SCALAR(0xa9c66f0)’)
called at -e line 0
eval {…} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272)
[Thu Mar 12 10:50:28 2009] [debug]: RT’s GnuPG libraries couldn’t
successfully read your configured GnuPG home directory
(/disk1/web/vhost/rt.local/rt/var/data/gpg). PGP support has been
disabled (/disk1/web/vhost/rt.local/rt/bin/…/local/lib/RT/Config.pm:339)
[Thu Mar 12 10:50:28 2009] [debug]: RT::Date used Time::ParseDate to
make ‘2009-01-01 00:00:00’ 1230768000
(/disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Date.pm:209)
[Thu Mar 12 10:50:28 2009] [warning]: DBD::Pg::st execute failed:
ERROR: function lower(timestamp without time zone) does not exist
LINE 1: …ain.Status) = ‘resolved’ AND main.Queue = ‘1’ AND LOWER(main…
^
HINT: No function matches the given name and argument types. You
might need to add explicit type casts. at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505.
(/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505)
[Thu Mar 12 10:50:28 2009] [warning]: RT::Handle=HASH(0xaa0c4d0)
couldn’t execute the query 'SELECT COUNT(DISTINCT main.id) FROM
Tickets main LEFT JOIN Users Users_2 ON ( Users_2.id = main.Owner )
LEFT JOIN Users Users_1 ON ( Users_1.id = main.Owner ) WHERE
(LOWER(main.Status) != ‘deleted’) AND (LOWER(main.Status) = 'resolved’
AND main.Queue = ‘1’ AND LOWER(main.Resolved) > ‘2009-01-01 00:00:00’)
AND (LOWER(main.Type) = ‘ticket’) AND (main.EffectiveId = main.id) '
at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line
518
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0xaa0c4d0)’,
‘SELECT COUNT(DISTINCT main.id) FROM Tickets main LEFT JOIN Us…’)
called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line
294
DBIx::SearchBuilder::_DoCount(‘RT::Report::Tickets=HASH(0xb0db1dc)’)
called at /disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Tickets_Overlay.pm
line 2678
RT::tickets::_DoCount(‘RT::Report::Tickets=HASH(0xb0db1dc)’)
called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line
1380
DBIx::SearchBuilder::Count(‘RT::Report::Tickets=HASH(0xb0db1dc)’)
called at /disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Tickets_Overlay.pm
line 2597
RT::tickets::Count(‘RT::Report::Tickets=HASH(0xb0db1dc)’)
called at /disk1/web/vhost/rt.local/rt/share/html/Search/Chart line 93
HTML::Mason::Commands::ANON(‘Query’, ‘Status =
‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xafb1350)’,
‘Query’, ‘Status = ‘resolved’ AND Queue = ‘Systems’ AND Resolved >
…’, ‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1278
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’, ‘Query’,
‘Status = ‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/disk1/web/vhost/rt.local/rt/local/html/autohandler line 311
HTML::Mason::Commands::ANON(‘Query’, ‘Status =
‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xafd2ef4)’,
‘Query’, ‘Status = ‘resolved’ AND Queue = ‘Systems’ AND Resolved >
…’, ‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1273
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’, ‘Query’,
‘Status = ‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 467
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 467
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 419
HTML::Mason::Request::exec(‘RT::Interface::Web::Request=HASH(0xaf4d518)’)
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 168
HTML::Mason::Request::ApacheHandler::exec(‘RT::Interface::Web::Request=HASH(0xaf4d518)’)
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 825
HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(0x9078598)’,
‘Apache2::RequestRec=SCALAR(0xa9c66d8)’) called at
/disk1/web/vhost/rt.local/rt/bin/webmux.pl line 149
eval {…} called at /disk1/web/vhost/rt.local/rt/bin/webmux.pl line 149
RT::Mason::handler(‘Apache2::RequestRec=SCALAR(0xa9c66d8)’)
called at -e line 0
eval {…} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272)


Kristian,

I reported this bug and it has been fixed in CVS and should appear
in 3.8.3. Here is a diff of my patched version of lib/RT/Report/Tickets.pm.
Make a copy of that file to local/lib/RT/Report/Tickets.pm and apply this
patch.

Cheers,
Ken

— lib/RT/Report/Tickets.pm 2009-01-21 13:12:22.000000000 -0600
+++ local/lib/RT/Report/Tickets.pm 2009-02-03 11:06:35.000000000 -0600
@@ -169,13 +169,16 @@
if ($field =~ /^(.*)(Daily|Monthly|Annually)$/) {
my ($field, $grouping) = ($1, $2);
if ( $grouping =~ /Daily/ ) {

  •        $args{'FUNCTION'} = "SUBSTR($field,1,10)";
    

+# $args{‘FUNCTION’} = “SUBSTR($field,1,10)”;

  •        $args{'FUNCTION'} = "SUBSTR(${field}::text,1,10)";
       }
       elsif ( $grouping =~ /Monthly/ ) {
    
  •        $args{'FUNCTION'} = "SUBSTR($field,1,7)";
    

+# $args{‘FUNCTION’} = “SUBSTR($field,1,7)”;

  •        $args{'FUNCTION'} = "SUBSTR(${field}::text,1,7)";
       }
       elsif ( $grouping =~ /Annually/ ) {
    
  •        $args{'FUNCTION'} = "SUBSTR($field,1,4)";
    

+# $args{‘FUNCTION’} = “SUBSTR($field,1,4)”;

  •        $args{'FUNCTION'} = "SUBSTR(${field}::text,1,4)";
       }
    
    } elsif ( $field =~ /^(?:CF|CustomField).{(.)}$/ ) { #XXX: use CFDecipher method
    my $cf_name = $1;
    @@ -190,24 +193,25 @@
    } elsif ( $field =~ /^(?:(Owner|Creator|LastUpdatedBy))(?:.(.
    ))?$/ ) {
    my $type = $1 || ‘’;
    my $column = $2 || ‘Name’;
  •    my $u_alias = $self->Join(
    
  •        TYPE   => 'LEFT',
    
  •        ALIAS1 => 'main',
    
  •        FIELD1 => $type,
    
  •        TABLE2 => 'Users',
    
  •        FIELD2 => 'id',
    
  •    );
    
  • my $u_alias = $self->{“sql_report${type}users${column}”}
  •   ||= $self->Join(
    
  •   TYPE => 'LEFT',
    
  •   ALIAS1 => 'main',
    
  •       FIELD1 => $type,
    
  •   TABLE2 => 'Users',
    
  •   FIELD2 => 'id',
    
  • );
    @args{qw(ALIAS FIELD)} = ($u_alias, $column);
    } elsif ( $field =~ /^(?:Watcher|(Requestor|Cc|AdminCc))(?:.(.*))?$/ ) {
    my $type = $1 || ‘’;
    my $column = $2 || ‘Name’;
  •    if ( my $u_alias = $self->{"_sql_report_watcher_users_alias_$type"} ) {
    
  •        @args{qw(ALIAS FIELD)} = ($u_alias, $column);
    
  •    } else {
    
  •        my ($g_alias, $gm_alias, $u_alias) = $self->_WatcherJoin( $type );
    
  •        @args{qw(ALIAS FIELD)} = ($u_alias, $column);
    
  • my $u_alias = $self->{“sql_report_watcher_users_alias$type”};
  • unless ( $u_alias ) {
  •   my ($g_alias, $gm_alias);
    
  •   ($g_alias, $gm_alias, $u_alias) = $self->_WatcherJoin( $type );
           $self->{"_sql_report_watcher_users_alias_$type"} = $u_alias;
       }
    
  • @args{qw(ALIAS FIELD)} = ($u_alias, $column);
    }
    return %args;
    }

Unfortunately I’d already tried those. I did however get excellent
results from your full text search wiki page though.

Mar 12 12:48:19 ghole postgres[13129]: [2-1] ERROR: function
lower(timestamp without time zone) does not exist at character 259
Mar 12 12:48:19 ghole postgres[13129]: [2-2] HINT: No function
matches the given name and argument types. You might need to add
explicit type casts.
Mar 12 12:48:19 ghole postgres[13129]: [2-3] STATEMENT: SELECT
COUNT(main.id) AS id, Users_1.Name AS col1 FROM ( SELECT DISTINCT
main.id FROM Tickets main LEFT JOIN Users
Mar 12 12:48:19 ghole postgres[13129]: [2-4] Users_1 ON ( Users_1.id
= main.Owner ) WHERE (LOWER(main.Status) != ‘deleted’) AND
(LOWER(main.Status) = ‘resolved’ AND
Mar 12 12:48:19 ghole postgres[13129]: [2-5] main.Queue = ‘1’ AND
lower(main.Resolved) > ‘2008-01-01 00:00:00’) AND (LOWER(main.Type) =
‘ticket’) AND (main.EffectiveId =
Mar 12 12:48:19 ghole postgres[13129]: [2-6] main.id) )
distinctquery, Tickets main WHERE (main.id = distinctquery.id) GROUP
BY Users_1.Name
Mar 12 12:48:20 ghole postgres[13130]: [2-1] ERROR: function
lower(timestamp without time zone) does not exist at character 209
Mar 12 12:48:20 ghole postgres[13130]: [2-2] HINT: No function
matches the given name and argument types. You might need to add
explicit type casts.
Mar 12 12:48:20 ghole postgres[13130]: [2-3] STATEMENT: SELECT
COUNT(DISTINCT main.id) FROM Tickets main LEFT JOIN Users Users_1 ON
( Users_1.id = main.Owner ) WHERE
Mar 12 12:48:20 ghole postgres[13130]: [2-4] (LOWER(main.Status) !=
‘deleted’) AND (LOWER(main.Status) = ‘resolved’ AND main.Queue = '1’
AND lower(main.Resolved) >
Mar 12 12:48:20 ghole postgres[13130]: [2-5] ‘2008-01-01 00:00:00’)
AND (LOWER(main.Type) = ‘ticket’) AND (main.EffectiveId = main.id)

[Thu Mar 12 12:48:19 2009] [debug]: RT::Date used Time::ParseDate to
make ‘01/01/2008’ 1199145600
(/disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Date.pm:209)
[Thu Mar 12 12:48:19 2009] [debug]: RT::Date used Time::ParseDate to
make ‘2008-01-01 00:00:00’ 1199145600
(/disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Date.pm:209)
[Thu Mar 12 12:48:19 2009] [warning]: DBD::Pg::st execute failed:
ERROR: function lower(timestamp without time zone) does not exist
LINE 1: …ain.Status) = ‘resolved’ AND main.Queue = ‘1’ AND lower(main…
^
HINT: No function matches the given name and argument types. You
might need to add explicit type casts. at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505.
(/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505)
[Thu Mar 12 12:48:19 2009] [warning]: RT::Handle=HASH(0xa4a0600)
couldn’t execute the query 'SELECT COUNT(main.id) AS id, Users_1.Name
AS col1 FROM ( SELECT DISTINCT main.id FROM Tickets main LEFT JOIN
Users Users_1 ON ( Users_1.id = main.Owner ) WHERE
(LOWER(main.Status) != ‘deleted’) AND (LOWER(main.Status) = 'resolved’
AND main.Queue = ‘1’ AND lower(main.Resolved) > ‘2008-01-01 00:00:00’)
AND (LOWER(main.Type) = ‘ticket’) AND (main.EffectiveId = main.id) )
distinctquery, Tickets main WHERE (main.id = distinctquery.id) GROUP
BY Users_1.Name ’ at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0xa4a0600)’,
‘SELECT COUNT(main.id) AS id, Users_1.Name AS col1 FROM ( SELE…’)
called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line
238
DBIx::SearchBuilder::_DoSearch(‘RT::Report::Tickets=HASH(0xabf9988)’)
called at /disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Tickets_Overlay.pm
line 2672
RT::tickets::_DoSearch(‘RT::Report::Tickets=HASH(0xabf9988)’)
called at /disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Report/Tickets.pm
line 152
RT::Report::tickets::_DoSearch(‘RT::Report::Tickets=HASH(0xabf9988)’)
called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line
498
DBIx::SearchBuilder::Next(‘RT::Report::Tickets=HASH(0xabf9988)’)
called at /disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Report/Tickets.pm
line 253
RT::Report::tickets::Next(‘RT::Report::Tickets=HASH(0xabf9988)’)
called at /disk1/web/vhost/rt.local/rt/share/html/Search/Elements/Chart
line 71
HTML::Mason::Commands::ANON(‘Query’, ‘Status =
‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xabfcbd0)’,
‘Query’, ‘Status = ‘resolved’ AND Queue = ‘Systems’ AND Resolved >
…’, ‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1278
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘Query’, ‘Status
= ‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/disk1/web/vhost/rt.local/rt/share/html/Tools/Reports/ResolvedByDates.html
line 83
HTML::Mason::Commands::ANON(‘ResolvedBefore’, ‘’,
‘ResolvedAfter’, ‘01/01/2008’, ‘Queue’, ‘Systems’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xa9ff810)’,
‘ResolvedBefore’, ‘’, ‘ResolvedAfter’, ‘01/01/2008’, ‘Queue’,
‘Systems’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1278
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’,
‘ResolvedBefore’, ‘’, ‘ResolvedAfter’, ‘01/01/2008’, ‘Queue’,
‘Systems’, …) called at
/disk1/web/vhost/rt.local/rt/local/html/autohandler line 311
HTML::Mason::Commands::ANON(‘ResolvedBefore’, ‘’,
‘ResolvedAfter’, ‘01/01/2008’, ‘Queue’, ‘Systems’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xaa03c7c)’,
‘ResolvedBefore’, ‘’, ‘ResolvedAfter’, ‘01/01/2008’, ‘Queue’,
‘Systems’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1273
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’,
‘ResolvedBefore’, ‘’, ‘ResolvedAfter’, ‘01/01/2008’, ‘Queue’,
‘Systems’, …) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 467
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 467
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 419
HTML::Mason::Request::exec(‘RT::Interface::Web::Request=HASH(0xa811938)’)
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 168
HTML::Mason::Request::ApacheHandler::exec(‘RT::Interface::Web::Request=HASH(0xa811938)’)
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 825
HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(0x9030968)’,
‘Apache2::RequestRec=SCALAR(0xa4591b0)’) called at
/disk1/web/vhost/rt.local/rt/bin/webmux.pl line 149
eval {…} called at /disk1/web/vhost/rt.local/rt/bin/webmux.pl line 149
RT::Mason::handler(‘Apache2::RequestRec=SCALAR(0xa4591b0)’)
called at -e line 0
eval {…} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272)
[Thu Mar 12 12:48:19 2009] [debug]: RT’s GnuPG libraries couldn’t
successfully read your configured GnuPG home directory
(/disk1/web/vhost/rt.local/rt/var/data/gpg). PGP support has been
disabled (/disk1/web/vhost/rt.local/rt/bin/…/local/lib/RT/Config.pm:339)
[Thu Mar 12 12:48:20 2009] [debug]: RT::Date used Time::ParseDate to
make ‘2008-01-01 00:00:00’ 1199145600
(/disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Date.pm:209)
[Thu Mar 12 12:48:20 2009] [warning]: DBD::Pg::st execute failed:
ERROR: function lower(timestamp without time zone) does not exist
LINE 1: …ain.Status) = ‘resolved’ AND main.Queue = ‘1’ AND lower(main…
^
HINT: No function matches the given name and argument types. You
might need to add explicit type casts. at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505.
(/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505)
[Thu Mar 12 12:48:20 2009] [warning]: RT::Handle=HASH(0xa49f128)
couldn’t execute the query 'SELECT COUNT(DISTINCT main.id) FROM
Tickets main LEFT JOIN Users Users_1 ON ( Users_1.id = main.Owner )
WHERE (LOWER(main.Status) != ‘deleted’) AND (LOWER(main.Status) =
‘resolved’ AND main.Queue = ‘1’ AND lower(main.Resolved) > ‘2008-01-01
00:00:00’) AND (LOWER(main.Type) = ‘ticket’) AND (main.EffectiveId =
main.id) ’ at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm
line 518
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0xa49f128)’,
‘SELECT COUNT(DISTINCT main.id) FROM Tickets main LEFT JOIN Us…’)
called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line
294
DBIx::SearchBuilder::_DoCount(‘RT::Report::Tickets=HASH(0xab6e00c)’)
called at /disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Tickets_Overlay.pm
line 2678
RT::tickets::_DoCount(‘RT::Report::Tickets=HASH(0xab6e00c)’)
called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line
1380
DBIx::SearchBuilder::Count(‘RT::Report::Tickets=HASH(0xab6e00c)’)
called at /disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Tickets_Overlay.pm
line 2597
RT::tickets::Count(‘RT::Report::Tickets=HASH(0xab6e00c)’)
called at /disk1/web/vhost/rt.local/rt/share/html/Search/Chart line 93
HTML::Mason::Commands::ANON(‘Query’, ‘Status =
‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xaa43f08)’,
‘Query’, ‘Status = ‘resolved’ AND Queue = ‘Systems’ AND Resolved >
…’, ‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1278
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’, ‘Query’,
‘Status = ‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/disk1/web/vhost/rt.local/rt/local/html/autohandler line 311
HTML::Mason::Commands::ANON(‘Query’, ‘Status =
‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xaa65bec)’,
‘Query’, ‘Status = ‘resolved’ AND Queue = ‘Systems’ AND Resolved >
…’, ‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1273
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’, ‘Query’,
‘Status = ‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 467
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 467
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 419
HTML::Mason::Request::exec(‘RT::Interface::Web::Request=HASH(0xa9e00d8)’)
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 168
HTML::Mason::Request::ApacheHandler::exec(‘RT::Interface::Web::Request=HASH(0xa9e00d8)’)
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 825
HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(0x9030968)’,
‘Apache2::RequestRec=SCALAR(0xa459198)’) called at
/disk1/web/vhost/rt.local/rt/bin/webmux.pl line 149
eval {…} called at /disk1/web/vhost/rt.local/rt/bin/webmux.pl line 149
RT::Mason::handler(‘Apache2::RequestRec=SCALAR(0xa459198)’)
called at -e line 0
eval {…} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272)

It looks like the problem is caused by trying to change the
case of a timestamp, which is nonsensical. Could you send me
a sample advanced search input that I could try with my setup
and queues to see if I can reproduce the problem locally?
You could also define a lower() function that does nothing
(ack, cough, cough,… I will deny I ever suggested it…).

Cheers,
KenOn Thu, Mar 12, 2009 at 12:55:48PM +0000, Kristian Davies wrote:

Unfortunately I’d already tried those. I did however get excellent
results from your full text search wiki page though.

Mar 12 12:48:19 ghole postgres[13129]: [2-1] ERROR: function
lower(timestamp without time zone) does not exist at character 259
Mar 12 12:48:19 ghole postgres[13129]: [2-2] HINT: No function
matches the given name and argument types. You might need to add
explicit type casts.
Mar 12 12:48:19 ghole postgres[13129]: [2-3] STATEMENT: SELECT
COUNT(main.id) AS id, Users_1.Name AS col1 FROM ( SELECT DISTINCT
main.id FROM Tickets main LEFT JOIN Users
Mar 12 12:48:19 ghole postgres[13129]: [2-4] Users_1 ON ( Users_1.id
= main.Owner ) WHERE (LOWER(main.Status) != ‘deleted’) AND
(LOWER(main.Status) = ‘resolved’ AND
Mar 12 12:48:19 ghole postgres[13129]: [2-5] main.Queue = ‘1’ AND
lower(main.Resolved) > ‘2008-01-01 00:00:00’) AND (LOWER(main.Type) =
‘ticket’) AND (main.EffectiveId =
Mar 12 12:48:19 ghole postgres[13129]: [2-6] main.id) )
distinctquery, Tickets main WHERE (main.id = distinctquery.id) GROUP
BY Users_1.Name
Mar 12 12:48:20 ghole postgres[13130]: [2-1] ERROR: function
lower(timestamp without time zone) does not exist at character 209
Mar 12 12:48:20 ghole postgres[13130]: [2-2] HINT: No function
matches the given name and argument types. You might need to add
explicit type casts.
Mar 12 12:48:20 ghole postgres[13130]: [2-3] STATEMENT: SELECT
COUNT(DISTINCT main.id) FROM Tickets main LEFT JOIN Users Users_1 ON
( Users_1.id = main.Owner ) WHERE
Mar 12 12:48:20 ghole postgres[13130]: [2-4] (LOWER(main.Status) !=
‘deleted’) AND (LOWER(main.Status) = ‘resolved’ AND main.Queue = '1’
AND lower(main.Resolved) >
Mar 12 12:48:20 ghole postgres[13130]: [2-5] ‘2008-01-01 00:00:00’)
AND (LOWER(main.Type) = ‘ticket’) AND (main.EffectiveId = main.id)

[Thu Mar 12 12:48:19 2009] [debug]: RT::Date used Time::ParseDate to
make ‘01/01/2008’ 1199145600
(/disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Date.pm:209)
[Thu Mar 12 12:48:19 2009] [debug]: RT::Date used Time::ParseDate to
make ‘2008-01-01 00:00:00’ 1199145600
(/disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Date.pm:209)
[Thu Mar 12 12:48:19 2009] [warning]: DBD::Pg::st execute failed:
ERROR: function lower(timestamp without time zone) does not exist
LINE 1: …ain.Status) = ‘resolved’ AND main.Queue = ‘1’ AND lower(main…
^
HINT: No function matches the given name and argument types. You
might need to add explicit type casts. at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505.
(/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505)
[Thu Mar 12 12:48:19 2009] [warning]: RT::Handle=HASH(0xa4a0600)
couldn’t execute the query 'SELECT COUNT(main.id) AS id, Users_1.Name
AS col1 FROM ( SELECT DISTINCT main.id FROM Tickets main LEFT JOIN
Users Users_1 ON ( Users_1.id = main.Owner ) WHERE
(LOWER(main.Status) != ‘deleted’) AND (LOWER(main.Status) = 'resolved’
AND main.Queue = ‘1’ AND lower(main.Resolved) > ‘2008-01-01 00:00:00’)
AND (LOWER(main.Type) = ‘ticket’) AND (main.EffectiveId = main.id) )
distinctquery, Tickets main WHERE (main.id = distinctquery.id) GROUP
BY Users_1.Name ’ at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0xa4a0600)’,
‘SELECT COUNT(main.id) AS id, Users_1.Name AS col1 FROM ( SELE…’)
called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line
238
DBIx::SearchBuilder::_DoSearch(‘RT::Report::Tickets=HASH(0xabf9988)’)
called at /disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Tickets_Overlay.pm
line 2672
RT::tickets::_DoSearch(‘RT::Report::Tickets=HASH(0xabf9988)’)
called at /disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Report/Tickets.pm
line 152
RT::Report::tickets::_DoSearch(‘RT::Report::Tickets=HASH(0xabf9988)’)
called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line
498
DBIx::SearchBuilder::Next(‘RT::Report::Tickets=HASH(0xabf9988)’)
called at /disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Report/Tickets.pm
line 253
RT::Report::tickets::Next(‘RT::Report::Tickets=HASH(0xabf9988)’)
called at /disk1/web/vhost/rt.local/rt/share/html/Search/Elements/Chart
line 71
HTML::Mason::Commands::ANON(‘Query’, ‘Status =
‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xabfcbd0)’,
‘Query’, ‘Status = ‘resolved’ AND Queue = ‘Systems’ AND Resolved >
…’, ‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1278
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘Query’, ‘Status
= ‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/disk1/web/vhost/rt.local/rt/share/html/Tools/Reports/ResolvedByDates.html
line 83
HTML::Mason::Commands::ANON(‘ResolvedBefore’, ‘’,
‘ResolvedAfter’, ‘01/01/2008’, ‘Queue’, ‘Systems’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xa9ff810)’,
‘ResolvedBefore’, ‘’, ‘ResolvedAfter’, ‘01/01/2008’, ‘Queue’,
‘Systems’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1278
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’,
‘ResolvedBefore’, ‘’, ‘ResolvedAfter’, ‘01/01/2008’, ‘Queue’,
‘Systems’, …) called at
/disk1/web/vhost/rt.local/rt/local/html/autohandler line 311
HTML::Mason::Commands::ANON(‘ResolvedBefore’, ‘’,
‘ResolvedAfter’, ‘01/01/2008’, ‘Queue’, ‘Systems’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xaa03c7c)’,
‘ResolvedBefore’, ‘’, ‘ResolvedAfter’, ‘01/01/2008’, ‘Queue’,
‘Systems’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1273
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’,
‘ResolvedBefore’, ‘’, ‘ResolvedAfter’, ‘01/01/2008’, ‘Queue’,
‘Systems’, …) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 467
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 467
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 419
HTML::Mason::Request::exec(‘RT::Interface::Web::Request=HASH(0xa811938)’)
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 168
HTML::Mason::Request::ApacheHandler::exec(‘RT::Interface::Web::Request=HASH(0xa811938)’)
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 825
HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(0x9030968)’,
‘Apache2::RequestRec=SCALAR(0xa4591b0)’) called at
/disk1/web/vhost/rt.local/rt/bin/webmux.pl line 149
eval {…} called at /disk1/web/vhost/rt.local/rt/bin/webmux.pl line 149
RT::Mason::handler(‘Apache2::RequestRec=SCALAR(0xa4591b0)’)
called at -e line 0
eval {…} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272)
[Thu Mar 12 12:48:19 2009] [debug]: RT’s GnuPG libraries couldn’t
successfully read your configured GnuPG home directory
(/disk1/web/vhost/rt.local/rt/var/data/gpg). PGP support has been
disabled (/disk1/web/vhost/rt.local/rt/bin/…/local/lib/RT/Config.pm:339)
[Thu Mar 12 12:48:20 2009] [debug]: RT::Date used Time::ParseDate to
make ‘2008-01-01 00:00:00’ 1199145600
(/disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Date.pm:209)
[Thu Mar 12 12:48:20 2009] [warning]: DBD::Pg::st execute failed:
ERROR: function lower(timestamp without time zone) does not exist
LINE 1: …ain.Status) = ‘resolved’ AND main.Queue = ‘1’ AND lower(main…
^
HINT: No function matches the given name and argument types. You
might need to add explicit type casts. at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505.
(/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505)
[Thu Mar 12 12:48:20 2009] [warning]: RT::Handle=HASH(0xa49f128)
couldn’t execute the query 'SELECT COUNT(DISTINCT main.id) FROM
Tickets main LEFT JOIN Users Users_1 ON ( Users_1.id = main.Owner )
WHERE (LOWER(main.Status) != ‘deleted’) AND (LOWER(main.Status) =
‘resolved’ AND main.Queue = ‘1’ AND lower(main.Resolved) > ‘2008-01-01
00:00:00’) AND (LOWER(main.Type) = ‘ticket’) AND (main.EffectiveId =
main.id) ’ at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm
line 518
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0xa49f128)’,
‘SELECT COUNT(DISTINCT main.id) FROM Tickets main LEFT JOIN Us…’)
called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line
294
DBIx::SearchBuilder::_DoCount(‘RT::Report::Tickets=HASH(0xab6e00c)’)
called at /disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Tickets_Overlay.pm
line 2678
RT::tickets::_DoCount(‘RT::Report::Tickets=HASH(0xab6e00c)’)
called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line
1380
DBIx::SearchBuilder::Count(‘RT::Report::Tickets=HASH(0xab6e00c)’)
called at /disk1/web/vhost/rt.local/rt/bin/…/lib/RT/Tickets_Overlay.pm
line 2597
RT::tickets::Count(‘RT::Report::Tickets=HASH(0xab6e00c)’)
called at /disk1/web/vhost/rt.local/rt/share/html/Search/Chart line 93
HTML::Mason::Commands::ANON(‘Query’, ‘Status =
‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xaa43f08)’,
‘Query’, ‘Status = ‘resolved’ AND Queue = ‘Systems’ AND Resolved >
…’, ‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1278
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’, ‘Query’,
‘Status = ‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/disk1/web/vhost/rt.local/rt/local/html/autohandler line 311
HTML::Mason::Commands::ANON(‘Query’, ‘Status =
‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xaa65bec)’,
‘Query’, ‘Status = ‘resolved’ AND Queue = ‘Systems’ AND Resolved >
…’, ‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1273
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’, ‘Query’,
‘Status = ‘resolved’ AND Queue = ‘Systems’ AND Resolved > …’,
‘PrimaryGroupBy’, ‘Owner’) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 467
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 467
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 419
HTML::Mason::Request::exec(‘RT::Interface::Web::Request=HASH(0xa9e00d8)’)
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 168
HTML::Mason::Request::ApacheHandler::exec(‘RT::Interface::Web::Request=HASH(0xa9e00d8)’)
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 825
HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(0x9030968)’,
‘Apache2::RequestRec=SCALAR(0xa459198)’) called at
/disk1/web/vhost/rt.local/rt/bin/webmux.pl line 149
eval {…} called at /disk1/web/vhost/rt.local/rt/bin/webmux.pl line 149
RT::Mason::handler(‘Apache2::RequestRec=SCALAR(0xa459198)’)
called at -e line 0
eval {…} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272)

Kristian,

I think the problem is in SearchBuilder/Handle.pm in the function
_MakeClauseCaseInsensitive. It looks like it only skips the lower()
for integer values. I think that you can replace the if test with
something like:

if ($value !~ /^[\d:- ]+$/) { # don’t downcase integer values or timestamps

I do not have a sample query to test with, but if this works
please let me know so I can log a bug report against DBIx::SearchBuilder.

Thanks,
Ken

Kristian,

I think the problem is in SearchBuilder/Handle.pm in the function
_MakeClauseCaseInsensitive. It looks like it only skips the lower()
for integer values. I think that you can replace the if test with
something like:

if ($value !~ /^[\d:- ]+$/) { # don’t downcase integer values or timestamps

Oops, that should read:

if ($value !~ /^[-\d: ]+$/) { # don’t downcase integer values or timestamps

because when including a dash (’-’) in the character list it must
come first.

Sorry,
Ken

Kristian,

I think the problem is in SearchBuilder/Handle.pm in the function
_MakeClauseCaseInsensitive. It looks like it only skips the lower()
for integer values. I think that you can replace the if test with
something like:

if ($value !~ /^[\d:- ]+$/) { # don’t downcase integer values or timestamps

Oops, that should read:

if ($value !~ /^[-\d: ]+$/) { # don’t downcase integer values or timestamps

Excellent. I changed this line in Handle.pm and Pg.pm and it now works again.

I wonder if upgrading postgres ( 8.1.9-1.el4s1.1 -> 8.3.6-1PGDG.rhel4)
or perl (5.8.8-4.el4s1 -> 5.8.8-6.el4s1_3) could have caused this, as
I managed to get it working before without code tweaks.

Many thanks Ken!

My next project is to convert this back to mysql eventually (82k
tickets). A task I’m not looking forward to.

Cheers,
Kristian

Kristian,

I think the problem is in SearchBuilder/Handle.pm in the function
_MakeClauseCaseInsensitive. It looks like it only skips the lower()
for integer values. I think that you can replace the if test with
something like:

if ($value !~ /^[\d:- ]+$/) { # don’t downcase integer values or timestamps

Oops, that should read:

if ($value !~ /^[-\d: ]+$/) { # don’t downcase integer values or timestamps

Excellent. I changed this line in Handle.pm and Pg.pm and it now works again.

I wonder if upgrading postgres ( 8.1.9-1.el4s1.1 -> 8.3.6-1PGDG.rhel4)
or perl (5.8.8-4.el4s1 -> 5.8.8-6.el4s1_3) could have caused this, as
I managed to get it working before without code tweaks.

Many thanks Ken!

My next project is to convert this back to mysql eventually (82k
tickets). A task I’m not looking forward to.

Cheers,
Kristian

Kristian,

It does sound like something is missing because I am running
PostgreSQL 8.3.5 and did not have to make these changes. I do have
a question, why are you converting your RT instance to MySQL? Is
there a particular problem you are trying to address?

Just wondering?
Ken

It does sound like something is missing because I am running
PostgreSQL 8.3.5 and did not have to make these changes. I do have
a question, why are you converting your RT instance to MySQL? Is
there a particular problem you are trying to address?

No technical reason, we are a essentially a mysql house and we have
two services which are based on Postgre, one of which is RT. RT was
originally converted from MySQL when we where investigating our
flavour of choice and the decision has long since been made.

-Kristian

It does sound like something is missing because I am running
PostgreSQL 8.3.5 and did not have to make these changes. I do have
a question, why are you converting your RT instance to MySQL? Is
there a particular problem you are trying to address?

No technical reason, we are a essentially a mysql house and we have
two services which are based on Postgre, one of which is RT. RT was
originally converted from MySQL when we where investigating our
flavour of choice and the decision has long since been made.

-Kristian

Thank you for the information. I was hoping that it was something
like that. Stick with your areas of expertise to reduce support
costs. We are more the other way here with more PostgreSQL than
MySQL. What is your plan to provide redundancy/business continuity
for your RT instance and what does MySQL for handling full-text
searching? We are trying to evaluate possible options for some
new MySQL instances and any feedback would be appreciated.

Regards,
Ken

Thank you for the information. I was hoping that it was something
like that. Stick with your areas of expertise to reduce support
costs. We are more the other way here with more PostgreSQL than
MySQL. What is your plan to provide redundancy/business continuity
for your RT instance and what does MySQL for handling full-text
searching? We are trying to evaluate possible options for some
new MySQL instances and any feedback would be appreciated.

Redundancy at the moment is just dump/restore of the database and
having mirrored disks. When we go MySQL we may add master/slave
replication, which we use for most of our smaller databases.

-Kristian