[Rt-devel] bug on chart ? on RT3.8 postrgresql 8.3

jul jul-rt at julbox.net
Wed Mar 11 20:43:35 EDT 2009


Hello everyone,

New to the list, (should lurk before post, I know)

after having installed rt3.8 from
deb http://debian.etc.gen.nz etch rt
with a postgresql 8.3
with a rt 3.8 version I have when trying to graph data based on time the
following error in my log

Mar 11 18:29:03 XXXXXXX RT: RT::Handle=HASH(0x3204970) couldn't execute
the query 'SELECT COUNT(main.id) AS id, SUBSTR(LastUpdated,1,10) AS
lastupdateddaily FROM Tickets main  WHERE (main.Status != 'deleted') AND
(main.id > '0') AND (main.Type = 'ticket') AND (main.EffectiveId =
main.id)  GROUP BY SUBSTR(LastUpdated,1,10) ' at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 518
^IDBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x3204970)',
'SELECT COUNT(main.id) AS id, SUBSTR(LastUpdated,1,10) AS last...') called
at /usr/share/perl5/DBIx/SearchBuilder.pm line 238
^IDBIx::SearchBuilder::_DoSearch('RT::Report::Tickets=HASH(0x5811660)')
called at /usr/share/request-tracker3.8/lib/RT/Report/Tickets.pm line 164
^IRT::Report::Tickets::_DoSearch('RT::Report::Tickets=HASH(0x5811660)')
called at /usr/share/perl5/DBIx/SearchBuilder.pm line 498
^IDBIx::SearchBuilder::Next('RT::Report::Tickets=HASH(0x5811660)') called
at /usr/share/request-tracker3.8/lib/RT/Report/Tickets.pm line 228
^IRT::Report::Tickets::Next('

So I opened pgsql to find that

SELECT count(main.id) AS id, substr( CAST ( LastUpdated AS TEXT ) , 1 ,10
)  AS lastupdateddaily FROM Tickets main  WHERE (main.Status != 'deleted')
AND (main.id > '0') AND (main.Type = 'ticket') AND (main.EffectiveId =
main.id)  GROUP BY substr( CAST ( LastUpdated AS TEXT ) , 1 ,10 )

Worked better.

Is this an old bug or a current one ? How can I patch my rt so that the
cast is included ?



Here come sys config from RT page :

Perl v5.10.0 under linux
  Apache::Session v1.86;
  Apache::Session::Generate::MD5 v2.1;
  Apache::Session::Lock::Null v1.01;
  Apache::Session::Postgres v1.01;
  Apache::Session::Serialize::Base64 v1.01;
  Apache::Session::Store::DBI v1.02;
  Apache::Session::Store::Postgres v1.03;
  AutoLoader v5.63;
  base v2.13;
  bytes v1.03;
  Cache::Simple::TimedExpiry v0.27;
  Carp v1.08;
  CGI v3.29;
  CGI::Cookie v1.28;
  CGI::Util v1.5_01;
  Class::Container v0.12;
  Class::Data::Inheritable v0.08;
  Class::Inspector v1.23;
  Class::ReturnValue v0.55;
  Clone v0.28;
  constant v1.13;
  Cwd v3.2701;
  Data::Dumper v2.121_14;
  Date::Format v2.22;
  Date::Parse v2.27;
  DateTime v0.42;
  DateTime::Locale v0.35;
  DateTime::Set v0.25;
  DateTime::TimeZone v0.7701;
  DateTime::TimeZone::Floating v0.01;
  DateTime::TimeZone::Local v0.01;
  DateTime::TimeZone::OffsetOnly v0.02;
  DateTime::TimeZone::UTC v0.01;
  DBD::Pg v2.8.2;
  DBI v1.605;
  DBIx::SearchBuilder v1.53;
  DBIx::SearchBuilder::Union v0;
  DBIx::SearchBuilder::Unique v0.01;
  Devel::StackTrace v1.1901;
  Devel::StackTraceFrame v1.1901;
  Digest::base v1.00;
  Digest::MD5 v2.36_01;
  DynaLoader v1.08;
  Email::Address v1.889;
  Encode v2.23;
  Encode::Alias v2.07;
  Encode::Config v2.04;
  Encode::Encoding v2.05;
  Errno v1.1;
  Exception::Class v1.24;
  Exception::Class::Base v1.2;
  Exporter v5.62;
  Exporter::Heavy v5.62;
  Fcntl v1.06;
  File::Basename v2.76;
  File::Glob v1.06;
  File::Path v2.04;
  File::ShareDir v0.05;
  File::Spec v3.2701;
  File::Spec::Unix v3.2701;
  File::Temp v0.18;
  FileHandle v2.01;
  GD v2.39;
  GD::Graph v1.44;
  GD::Graph::colour v1.10;
  GD::Graph::Data v1.22;
  GD::Graph::Error v1.8;
  GD::Graph::pie v1.21;
  GD::Graph::utils v1.7;
  GD::Image v2.27;
  GD::Text v0.86;
  GD::Text::Align v1.18;
  GraphViz v2.03;
  HTML::Element v3.23;
  HTML::Entities v1.35;
  HTML::Formatter v2.04;
  HTML::FormatText v2.04;
  HTML::Mason v1.36;
  HTML::Mason::CGIHandler v1.00;
  HTML::Mason::Exception v1.1;
  HTML::Mason::Exception::Abort v1.1;
  HTML::Mason::Exception::Compilation v1.1;
  HTML::Mason::Exception::Compilation::IncompatibleCompiler v1.1;
  HTML::Mason::Exception::Compiler v1.1;
  HTML::Mason::Exception::Decline v1.1;
  HTML::Mason::Exception::Params v1.1;
  HTML::Mason::Exception::Syntax v1.1;
  HTML::Mason::Exception::System v1.1;
  HTML::Mason::Exception::TopLevelNotFound v1.1;
  HTML::Mason::Exception::VirtualMethod v1.1;
  HTML::Mason::Exceptions v1.43;
  HTML::Parser v3.56;
  HTML::Scrubber v0.08;
  HTML::Tagset v3.20;
  HTML::TreeBuilder v3.23;
  I18N::LangTags v0.35;
  integer v1.00;
  IO v1.23_01;
  IO::File v1.14;
  IO::Handle v1.27;
  IO::InnerFile v2.110;
  IO::Lines v2.110;
  IO::ScalarArray v2.110;
  IO::Seekable v1.1;
  IO::WrapTie v2.110;
  IPC::Open2 v1.02;
  IPC::Open3 v1.02;
  IPC::Run v0.80;
  List::Util v1.19;
  Locale::Maketext v1.12;
  Locale::Maketext::Fuzzy v0.02;
  Locale::Maketext::Lexicon v0.66;
  Locale::Maketext::Lexicon::Gettext v0.16;
  Log::Dispatch v2.18;
  Log::Dispatch::Base v1.09;
  Log::Dispatch::Output v1.26;
  Log::Dispatch::Screen v1.17;
  Log::Dispatch::Syslog v1.18;
  Mail::Address v2.03;
  Mail::Field v2.03;
  Mail::Field::AddrList v2.03;
  Mail::Field::Date v2.03;
  Mail::Field::Generic v2.03;
  Mail::Header v2.03;
  Mail::Internet v2.03;
  Mail::Mailer v2.03;
  Mail::Util v2.03;
  MIME::Base64 v3.07_01;
  MIME::Body v5.426;
  MIME::Decoder v5.426;
  MIME::Entity v5.426;
  MIME::Field::ContDisp v5.426;
  MIME::Field::ConTraEnc v5.426;
  MIME::Field::ContType v5.426;
  MIME::Field::ParamVal v5.426;
  MIME::Head v5.426;
  MIME::Parser v5.426;
  MIME::QuotedPrint v3.07;
  MIME::Tools v5.426;
  MIME::Words v5.426;
  Module::Versions::Report v1.05;
  overload v1.06;
  Params::Util v0.30;
  Params::Validate v0.91;
  POSIX v1.13;
  re v0.08;
  Regexp::Common v2.122;
  Regexp::Common::delimited v2.106;
  RT v3.8.1;
  RT::Extension::Timeline v0.03;
  RT::Interface::Email v2;
  RT::Interface::Web::Request v0.30;
  RTx::Calendar v0.06;
  RTx::EmailCompletion v0.05;
  Scalar::Util v1.19;
  SelectSaver v1.01;
  Set::Infinite v0.61;
  Socket v1.80;
  Storable v2.18;
  strict v1.04;
  Symbol v1.06;
  Sys::Syslog v0.22;
  Text::Template v1.44;
  Text::Wrapper v1.02;
  Tie::Hash v1.02;
  Time::HiRes v1.9711;
  Time::JulianDay v2003.1125;
  Time::Local v1.18;
  Time::ParseDate v2006.0814;
  Time::Timezone v2006.0814;
  Time::Zone v2.22;
  UNIVERSAL v1.04;
  UNIVERSAL::require v0.11;
  URI v1.35;
  URI::Escape v3.28;
  utf8 v1.07;
  vars v1.01;
  version v0.74;
  Want v0.18;
  warnings v1.06;
  warnings::register v1.01;
  XSLoader v0.08;

RT Config
ActiveStatus 	new, open, stalled
Active_MakeClicky
AmbiguousDayInFuture 	0
AmbiguousDayInPast 	0
AutoLogoff 	0
CanonicalizeOnCreate 	0
CanonicalizeRedirectURLs 	0
CommentAddress 	rt-comment at ftth-sfr.net
CorrespondAddress 	rt at ftth-sfr.net
CustomFieldValuesSources
DashboardAddress
DashboardSubject 	%s Dashboard: %s
DatabaseHost 	localhost
DatabaseName 	rt3
DatabasePassword 	Password not printed
DatabasePort
DatabaseRTHost 	localhost
DatabaseType 	Pg
DatabaseUser 	rt_user
DateDayBeforeMonth 	1
DateTimeFormat 	DefaultFormat
DefaultSearchResultFormat 	'<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
'<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__Subject__</a></B>/TITLE:Subject',
Status, QueueName, OwnerName, Priority, '__NEWLINE__', '',
'<small>__Requestors__</small>', '<small>__CreatedRelative__</small>',
'<small>__ToldRelative__</small>',
'<small>__LastUpdatedRelative__</small>', '<small>__TimeLeft__</small>'
DefaultSummaryRows 	10
DevelMode 	0
EmailCompletionUnprivileged 	everybody
EmailFrequency 	Individual messages
EmailInputEncodings 	utf-8, iso-8859-1, us-ascii
EmailOutputEncoding 	utf-8
EnableReminders 	1
ExtractSubjectTagMatch 	Regexp
ExtractSubjectTagNoMatch 	Regexp
ForwardFromUser 	0
FriendlyFromLineFormat 	"%s via RT" <%s>
FriendlyToLineFormat 	"%s of rt.ftth-sfr.net Ticket #%s":;
GnuPG 	Enable, 0, AllowEncryptDataInDB, 0, OutgoingMessagesFormat, RFC
GnuPGOptions 	homedir, /var/cache/request-tracker3.8/data/gpg
HomepageComponents 	QuickCreate, Quicksearch, MyAdminQueues,
MySupportQueues, MyReminders, RefreshHomepage, Dashboards
InactiveStatus 	resolved, rejected, deleted
LexiconLanguages 	*
LinkTransactionsRun1Scrip 	0
LogDir 	/var/log/request-tracker3.8
LogStackTraces
LogToFileNamed 	rt.log
LogToScreen 	info
LogToSyslog 	info
LogToSyslogConf
LogoURL 	/rt/NoAuth/images/sfr.jpg
LoopsToRTOwner 	1
MailCommand 	sendmailpipe
MailParams
MasonParameters
MaxAttachmentSize 	10000000
MaxInlineBody 	12000
MessageBoxHeight 	15
MessageBoxRichText 	1
MessageBoxWidth 	72
MessageBoxWrap 	HARD
MinimumPasswordLength 	5
NetServerOptions
NotifyActor 	0
OldestTransactionsFirst 	1
Organization 	ftth-sfr.net
OwnerEmail 	root
PlainTextPre 	0
Plugins 	RTx::Calendar, RTx::EmailCompletion, RT::Extension::Timeline
PreviewScripMessages 	0
RTAddressRegexp 	^rt\@example.com$
RecordOutgoingEmail 	1
RedistributeAutoGeneratedMessages 	privileged
SMTPDebug 	0
SelfServiceRegex 	Regexp
SendmailArguments 	-oi -t
SendmailBounceArguments 	-f "<>"
SendmailPath 	/usr/sbin/sendmail
ShowBccHeader 	0
ShowTransactionImages 	1
ShowUnreadMessageNotifications 	1
StandaloneMaxServers 	1
StandaloneMaxSpareServers 	0
StandaloneMinServers 	1
StandaloneMinSpareServers 	0
StrictLinkACL 	1
Timezone 	CET
UseFriendlyFromLine 	1
UseFriendlyToLine 	0
UseTransactionBatch 	0
UsernameFormat 	concise
WebBaseURL 	http://rt.ftth-sfr.net
WebDefaultStylesheet 	web2
WebDomain 	localhost
WebFlushDbCacheEveryRequest 	1
WebImagesURL 	/rt/NoAuth/images/
WebNoAuthRegex 	Regexp
WebPath 	/rt
WebPort 	80
WebSecureCookies 	0
WebURL 	http://rt.ftth-sfr.net/rt/
WikiImplicitLinks 	0
rtname 	rt.ftth-sfr.net
RT Variables
RT::BasePath 	/usr/share/request-tracker3.8
RT::BinPath 	/usr/bin
RT::EtcPath 	/etc/request-tracker3.8
RT::LocalEtcPath 	/usr/local/share/request-tracker3.8/etc
RT::LocalLexiconPath 	/usr/local/share/request-tracker3.8/po
RT::LocalLibPath 	/usr/local/share/request-tracker3.8/lib
RT::LocalPath 	/usr/local/share/request-tracker3.8
RT::LocalPluginPath 	/usr/local/share/request-tracker3.8/plugins
RT::MasonComponentRoot 	/usr/share/request-tracker3.8/html
RT::MasonDataDir 	/var/cache/request-tracker3.8/mason_data
RT::MasonLocalComponentRoot 	/usr/local/share/request-tracker3.8/html
RT::MasonSessionDir 	/var/cache/request-tracker3.8/session_data
RT::SbinPath 	/usr/sbin
RT::VERSION 	3.8.1
RT::VarPath 	/var/cache/request-tracker3.8
Perl configuration

Summary of my perl5 (revision 5 version 10 subversion 0) configuration:
  Platform:
    osname=linux, osvers=2.6.24-16-server,
archname=x86_64-linux-gnu-thread-multi
    uname='linux yellow 2.6.24-16-server #1 smp thu apr 10 13:15:38 utc
2008 x86_64 gnulinux '
    config_args='-Dusethreads -Duselargefiles -Dccflags=-DDEBIAN
-Dcccdlflags=-fPIC -Darchname=x86_64-linux-gnu -Dprefix=/usr
-Dprivlib=/usr/share/perl/5.10 -Darchlib=/usr/lib/perl/5.10
-Dvendorprefix=/usr -Dvendorlib=/usr/share/perl5
-Dvendorarch=/usr/lib/perl5 -Dsiteprefix=/usr/local
-Dsitelib=/usr/local/share/perl/5.10.0
-Dsitearch=/usr/local/lib/perl/5.10.0 -Dman1dir=/usr/share/man/man1
-Dman3dir=/usr/share/man/man3 -Dsiteman1dir=/usr/local/man/man1
-Dsiteman3dir=/usr/local/man/man3 -Dman1ext=1 -Dman3ext=3perl
-Dpager=/usr/bin/sensible-pager -Uafs -Ud_csh -Ud_ualarm -Uusesfio -Uusenm
-DDEBUGGING=-g -Doptimize=-O2 -Duseshrplib
-Dlibperl=libperl.so.5.10.0 -Dd_dosuid -des'
    hint=recommended, useposix=true, d_sigaction=define
    useithreads=define, usemultiplicity=define
    useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef
use64bitint=define, use64bitall=define, uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
  Compiler:
    cc='cc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DDEBIAN
-fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64',
    optimize='-O2 -g',
    cppflags='-D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fno-strict-aliasing
-pipe -I/usr/local/include'
    ccversion='', gccversion='4.3.2', gccosandvers=''
    intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
    alignbytes=8, prototype=define
  Linker and Libraries:
    ld='cc', ldflags =' -L/usr/local/lib'
    libpth=/usr/local/lib /lib /usr/lib /lib64 /usr/lib64
    libs=-lgdbm -lgdbm_compat -ldb -ldl -lm -lpthread -lc -lcrypt
    perllibs=-ldl -lm -lpthread -lc -lcrypt
    libc=/lib/libc-2.8.90.so, so=so, useshrplib=true,
libperl=libperl.so.5.10.0
    gnulibc_version='2.8.90'
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
cccdlflags='-fPIC', lddlflags='-shared -O2 -g -L/usr/local/lib'



Perl Include Paths (@INC)

/usr/local/share/request-tracker3.8/lib
/usr/share/request-tracker3.8/lib
/etc/perl
/usr/local/lib/perl/5.10.0
/usr/local/share/perl/5.10.0
/usr/lib/perl5
/usr/share/perl5
/usr/lib/perl/5.10
/usr/share/perl/5.10
/usr/local/lib/site_perl
.


-- 
Julien Tayon // digital craftsman // making things simpler (when possible)

Truth will out this morning.  (Which may really mess things up.)






-- 
Julien Tayon // digital craftsman // making things simpler (when possible)

Martin was probably ripping them off.  That's some family, isn't it?
Incest, prostitution, fanaticism, software.
		-- Charles Willeford, "Miami Blues"




More information about the Rt-devel mailing list