[Rt-devel] bug on chart ? on RT3.8 postrgresql 8.3
Ruslan Zakirov
ruslan.zakirov at gmail.com
Thu Mar 12 08:05:50 EDT 2009
http://svn.bestpractical.com/cgi-bin/index.cgi/bps/revision/?rev=18373
On Thu, Mar 12, 2009 at 3:43 AM, jul <jul-rt at julbox.net> wrote:
>
> 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"
>
>
> _______________________________________________
> List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
>
--
Best regards, Ruslan.
More information about the Rt-devel
mailing list