[rt-users] RT Bug -> was: problem creating ticket - Found no sequence for Tickets
Elliot Finley
efinleywork at efinley.com
Mon Jan 30 12:15:15 EST 2006
Still no response from anyone on this problem. I downgraded Postgres from
8.1.2 to 8.0.6 and all is well again. So it appears that RT doesn't like
Postgres 8.1.2. Can anyone confirm this?
----- Original Message -----
From: "Elliot Finley" <efinleywork at efinley.com>
To: <rt-users at lists.bestpractical.com>
Sent: Saturday, January 28, 2006 7:56 PM
Subject: Fw: [rt-users] problem creating ticket - Found no sequence for
Tickets
> I still haven't found a solution to this problem. It appears it may be
> related to the Postgresql version. Is anyone successfully using RT with
> Postgres 8.1.2?
>
> What is the best way to debug this?
>
> ----- Original Message -----
> From: "Elliot Finley" <efinleywork at efinley.com>
> To: <rt-users at lists.bestpractical.com>
> Sent: Thursday, January 26, 2006 3:15 PM
> Subject: [rt-users] problem creating ticket - Found no sequence for
Tickets
>
>
> > This is on a system that has been in production for quite a while. Any
> help
> > resolving this would be greatly appreciated.
> >
> >
> > Here is the RT debug log:
> > Jan 26 14:59:36 itwiki RT: Converting 'us-ascii' to 'utf-8' for
> text/plain -
> > Jan 26 14:59:36 itwiki RT: Guessed encoding: ascii
> > Jan 26 14:59:36 itwiki RT: Guessed encoding: ascii
> > Jan 26 14:59:36 itwiki RT: Couldn't create a ticket: Internal Error:
Found
> > no sequence for Tickets (/usr/local/rt3/lib/RT/Ticket_Overlay.pm:590)
> > Jan 26 14:59:36 itwiki RT: Ticket could not be created due to an
internal
> > error (/usr/local/rt3/lib/RT/Interface/Email.pm:759)
> > Jan 26 14:59:36 itwiki RT: Create failed: 0 / 0 / Ticket could not be
> > created due to an internal error
> > (/usr/local/rt3/lib/RT/Interface/Email.pm:765)
> >
> > System info is:
> >
> > RT: 3.4.4
> > FreeBSD: 6.0-RELEASE-p1
> > Perl: v5.8.7
> > p5-DBIx-SearchBuilder: 1.38
> > Apache: 2.0.55
> > mod_perl: 2.0.2
> > postgresql-server: 8.1.2
> >
> > following is a cut-n-paste from the 'system information' screen from the
> > running RT:
> >
> > Perl v5.8.7 under freebsd Apache2::Access v2.000002;
> Apache2::Connection
> > v2.000002; Apache2::Const v2.000002; Apache2::Filter v2.000002;
> > Apache2::Log v2.000002; Apache2::Module v2.000002; Apache2::RequestIO
> > v2.000002; Apache2::RequestRec v2.000002; Apache2::RequestUtil
> v2.000002;
> > Apache2::Response v2.000002; Apache2::ServerRec v2.000002;
> > Apache2::ServerUtil v2.000002; Apache2::Status v4.00;
> Apache2::SubRequest
> > v2.000002; Apache2::URI v2.000002; Apache2::Util v2.000002;
Apache::DBI
> > v0.94; Apache::Session v1.6; Apache::Session::Generate::MD5 v2.1;
> > Apache::Session::Lock::Null v1.01; Apache::Session::Postgres v1.01;
> > Apache::Session::Serialize::Base64 v1.00; Apache::Session::Store::DBI
> > v1.02; Apache::Session::Store::Postgres v1.03; APR v0.009000;
> > APR::Brigade v0.009000; APR::Bucket v0.009000; APR::Const v0.009000;
> > APR::Date v0.009000; APR::Pool v0.009000; APR::Table v0.009000;
> APR::URI
> > v0.009000; APR::Util v0.009000; AutoLoader v5.60; base v2.03;
> Benchmark
> > v1.07; bytes v1.02; Cache::Simple::TimedExpiry v0.23; capitalization
> > v0.03; Carp v1.04; CGI v3.15; CGI::Cookie v1.26; CGI::Util v1.5;
> > Class::Container v0.12; Class::Data::Inheritable v0.04;
> Class::ReturnValue
> > v0.53; Clone v0.18; constant v1.05; Cwd v3.15; Data::Dumper
v2.121_04;
> > DBD::Pg v1.43; DBD::Sponge v11.10; DBI v1.50; DBIx::SearchBuilder
> v1.38;
> > DBIx::SearchBuilder::Unique v0.01; Devel::StackTrace v1.12;
> > Devel::StackTraceFrame v0.6; Devel::Symdump v2.04; Digest::base v1.00;
> > Digest::MD5 v2.36; DynaLoader v1.05; Encode v2.10; Encode::Alias
v2.03;
> > Encode::Config v2.00; Encode::Encoding v2.02; Encode::Guess v2.00;
> > Encode::Unicode v2.02; Errno v1.0901; Exception::Class v1.22;
> > Exception::Class::Base v1.2; Exporter v5.58; Exporter::Heavy v5.58;
> Fcntl
> > v1.05; File::Basename v2.73; File::Glob v1.04; File::Path v1.07;
> > File::Spec v3.15; File::Spec::Functions v1.3; File::Spec::Unix v1.5;
> > File::Temp v0.16; FileHandle v2.01; HTML::Entities v1.32; HTML::Mason
> > v1.3101; HTML::Mason::ApacheHandler v1.69; 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.48; HTML::Scrubber v0.08; I18N::LangTags v0.35;
> > I18N::LangTags::Detect v1.03; I18N::LangTags::List v0.35; integer
v1.00;
> > IO v1.21; IO::File v1.11; IO::Handle v1.24; IO::InnerFile v2.110;
> > IO::Lines v2.110; IO::Scalar v2.110; IO::ScalarArray v2.110;
> IO::Seekable
> > v1.09; IO::Wrap v2.110; IO::WrapTie v2.110; IPC::Open2 v1.01;
> IPC::Open3
> > v1.0106; lib v0.5565; List::Util v1.18; locale v1.00;
Locale::Maketext
> > v1.09; Locale::Maketext::Fuzzy v0.02; Locale::Maketext::Lexicon v0.49;
> > Locale::Maketext::Lexicon::Gettext v0.14; Log::Dispatch v2.11;
> > Log::Dispatch::Base v1.09; Log::Dispatch::Output v1.26;
> > Log::Dispatch::Screen v1.17; Log::Dispatch::Syslog v1.18;
Mail::Address
> > v1.67; Mail::Field v1.67; Mail::Field::AddrList v1.67; Mail::Header
> > v1.67; Mail::Internet v1.67; MIME::Base64 v3.07; MIME::Body v5.419;
> > MIME::Decoder v5.419; MIME::Decoder::Base64 v5.419;
> MIME::Decoder::Binary
> > v5.419; MIME::Decoder::NBit v5.419; MIME::Decoder::QuotedPrint v5.419;
> > MIME::Entity v5.419; MIME::Field::ContDisp v5.419;
> MIME::Field::ConTraEnc
> > v5.419; MIME::Field::ContType v5.419; MIME::Field::ParamVal v5.419;
> > MIME::Head v5.419; MIME::Parser v5.419; MIME::QuotedPrint v3.07;
> > MIME::Tools v5.419; MIME::Words v5.419; mod_perl v2.000002; mod_perl2
> > v2.000002; ModPerl::Const v2.000002; Module::Versions::Report v1.02;
> > overload v1.03; Params::Validate v0.78; POSIX v1.08; re v0.04;
> > Regexp::Common v2.120; Regexp::Common::_support v2.101;
> > Regexp::Common::balanced v2.101; Regexp::Common::CC v2.100;
> > Regexp::Common::comment v2.116; Regexp::Common::delimited v2.104;
> > Regexp::Common::lingua v2.105; Regexp::Common::list v2.103;
> > Regexp::Common::net v2.105; Regexp::Common::number v2.108;
> > Regexp::Common::profanity v2.104; Regexp::Common::SEN v2.102;
> > Regexp::Common::URI v2.108; Regexp::Common::URI::fax v2.100;
> > Regexp::Common::URI::file v2.100; Regexp::Common::URI::ftp v2.101;
> > Regexp::Common::URI::gopher v2.100; Regexp::Common::URI::http v2.101;
> > Regexp::Common::URI::news v2.100; Regexp::Common::URI::pop v2.100;
> > Regexp::Common::URI::prospero v2.100; Regexp::Common::URI::RFC1035
> v2.100;
> > Regexp::Common::URI::RFC1738 v2.104; Regexp::Common::URI::RFC1808
v2.100;
> > Regexp::Common::URI::RFC2384 v2.102; Regexp::Common::URI::RFC2396
v2.100;
> > Regexp::Common::URI::RFC2806 v2.100; Regexp::Common::URI::tel v2.100;
> > Regexp::Common::URI::telnet v2.100; Regexp::Common::URI::tv v2.100;
> > Regexp::Common::URI::wais v2.100; Regexp::Common::whitespace v2.103;
> > Regexp::Common::zip v2.112; RT v3.4.4; RT::Interface::Email v1.02;
> > Scalar::Util v1.18; SelectSaver v1.01; Socket v1.77; Storable v2.15;
> > strict v1.03; Symbol v1.06; Sys::Hostname v1.11; Sys::Syslog v0.06;
> > Text::Autoformat v1.13; Text::Quoted v1.8; Text::Reform v1.11;
> Text::Tabs
> > v98.112801; Text::Template v1.44; Text::Wrapper v1.000; Time::HiRes
> > v1.86; Time::JulianDay v2003.1125; Time::Local v1.11; Time::ParseDate
> > v2003.1126; Time::Timezone v2003.0211; URI v1.35; URI::Escape v3.28;
> > URI::URL v5.03; URI::WithBase v2.19; utf8 v1.05; vars v1.01; Want
> v0.09;
> > warnings v1.03; warnings::register v1.00; XSLoader v0.02;
> >
> >
> > RT Variables
> > RT::AmbiguousDayInPast 1
> > RT::BasePath /usr/local/rt3
> > RT::BinPath /usr/local/rt3/bin
> > RT::CORE_CONFIG_FILE /usr/local/rt3/etc/RT_Config.pm
> > RT::CommentAddress RT_CommentAddressNotSet
> > RT::CorrespondAddress RT_CorrespondAddressNotSet
> > RT::DatabaseHost postgres-i.etv.net
> > RT::DatabaseName rt3
> > RT::DatabasePassword Password not printed
> > RT::DatabasePort 5432
> > RT::DatabaseRTHost postgres-i.etv.net
> > RT::DatabaseType Pg
> > RT::DatabaseUser rt_user
> > RT::DateDayBeforeMonth 1
> > RT::DefaultSearchResultFormat '<B><A
> > HREF="/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#', '<B><A
> >
HREF="/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>'
> > RT::EmailOutputEncoding utf-8
> > RT::EtcPath /usr/local/rt3/etc
> > RT::FriendlyFromLineFormat "%s via RT" <%s>
> > RT::FriendlyToLineFormat "%s of etv.net Ticket #%s":;
> > RT::LocalEtcPath /usr/local/rt3/local/etc
> > RT::LocalLexiconPath /usr/local/rt3/local/po
> > RT::LocalPath /usr/local/rt3/local
> > RT::LogDir /usr/local/rt3/var/log
> > RT::LogToFileNamed rt.log
> > RT::LogToScreen error
> > RT::LogToSyslog debug
> > RT::LogoURL /NoAuth/images/bplogo.gif
> > RT::LoopsToRTOwner 1
> > RT::MailCommand sendmailpipe
> > RT::MasonComponentRoot /usr/local/rt3/share/html
> > RT::MasonDataDir /usr/local/rt3/var/mason_data
> > RT::MasonLocalComponentRoot /usr/local/rt3/local/html
> > RT::MasonSessionDir /usr/local/rt3/var/session_data
> > RT::MaxAttachmentSize 10000000
> > RT::MaxInlineBody 13456
> > RT::MessageBoxWidth 72
> > RT::MessageBoxWrap HARD
> > RT::MinimumPasswordLength 5
> > RT::MyRequestsLength 10
> > RT::MyTicketsLength 10
> > RT::Organization rt3.etv.net
> > RT::OwnerEmail efinley at efinley.com
> > RT::ParseNewMessageForTicketCcs 1
> > RT::RTAddressRegexp ^.*?\@rt3.etv.net$
> > RT::RecordOutgoingEmail 1
> > RT::RedistributeAutoGeneratedMessages 1
> > RT::SITE_CONFIG_FILE /usr/local/rt3/etc/RT_SiteConfig.pm
> > RT::SendmailArguments -oi -t
> > RT::SendmailPath /usr/sbin/sendmail
> > RT::Timezone US/Mountain
> > RT::UseFriendlyFromLine 1
> > RT::VERSION 3.4.4
> > RT::VarPath /usr/local/rt3/var
> > RT::WebBaseURL http://rt3.etv.net:80
> > RT::WebFlushDbCacheEveryRequest 1
> > RT::WebImagesURL /NoAuth/images/
> > RT::WebURL http://rt3.etv.net:80/
> > RT::rtname etv.net
> >
> > Perl configuration
> > Summary of my perl5 (revision 5 version 8 subversion 7) configuration:
> > Platform:
> > osname=freebsd, osvers=6.0-release-p1, archname=i386-freebsd-64int
> > uname='freebsd itwiki.etv.net 6.0-release-p1 freebsd 6.0-release-p1
> #0:
> > tue jan 3 21:00:34 mst 2006 root at itwiki.etv.net:usrobjusrsrcsysdebug
i386
> '
> >
> >
> >
> >
> >
>
config_args='-sde -Dprefix=/usr/local -Darchlib=/usr/local/lib/perl5/5.8.7/m
> >
>
ach -Dprivlib=/usr/local/lib/perl5/5.8.7 -Dman3dir=/usr/local/lib/perl5/5.8.
> >
>
7/perl/man/man3 -Dman1dir=/usr/local/man/man1 -Dsitearch=/usr/local/lib/perl
> >
>
5/site_perl/5.8.7/mach -Dsitelib=/usr/local/lib/perl5/site_perl/5.8.7 -Dscri
> >
>
ptdir=/usr/local/bin -Dsiteman3dir=/usr/local/lib/perl5/5.8.7/man/man3 -Dsit
> >
>
eman1dir=/usr/local/man/man1 -Ui_malloc -Ui_iconv -Uinstallusrbinperl -Dcc=c
> >
>
c -Duseshrplib -Dccflags=-DAPPLLIB_EXP="/usr/local/lib/perl5/5.8.7/BSDPAN" -
> >
>
Doptimize=-O2 -fno-strict-aliasing -pipe -Ud_dosuid -Ui_gdbm -Dusethreads=n
> > -Dusemymalloc=y -Duse64bitint'
> > hint=recommended, useposix=true, d_sigaction=define
> > usethreads=undef use5005threads=undef useithreads=undef
> > usemultiplicity=undef
> > useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
> > use64bitint=define use64bitall=undef uselongdouble=undef
> > usemymalloc=y, bincompat5005=undef
> > Compiler:
> > cc='cc', ccflags
> >
>
='-DAPPLLIB_EXP="/usr/local/lib/perl5/5.8.7/BSDPAN" -DHAS_FPSETMASK -DHAS_FL
> > OATINGPOINT_H -fno-strict-aliasing -pipe -I/usr/local/include',
> > optimize='-O2 -fno-strict-aliasing -pipe ',
> >
> >
> >
> >
> >
>
cppflags='-DAPPLLIB_EXP="/usr/local/lib/perl5/5.8.7/BSDPAN" -DHAS_FPSETMASK
> > -DHAS_FLOATINGPOINT_H -fno-strict-aliasing -pipe -I/usr/local/include'
> > ccversion='', gccversion='3.4.4 [FreeBSD] 20050518', gccosandvers=''
> > intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=12345678
> > d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
> > ivtype='long long', ivsize=8, nvtype='double', nvsize=8,
> Off_t='off_t',
> > lseeksize=8
> > alignbytes=4, prototype=define
> > Linker and Libraries:
> > ld='cc', ldflags ='-pthread -Wl,-E -L/usr/local/lib'
> > libpth=/usr/lib /usr/local/lib
> > libs=-lm -lcrypt -lutil
> > perllibs=-lm -lcrypt -lutil
> > libc=, so=so, useshrplib=true, libperl=libperl.so
> > gnulibc_version=''
> > Dynamic Linking:
> > dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef,
> > cdlflags=' -Wl,-R/usr/local/lib/perl5/5.8.7/mach/CORE'
> > cccdlflags='-DPIC -fPIC', lddlflags='-shared -L/usr/local/lib'
> >
> >
> >
> > _______________________________________________
> > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> >
> > Be sure to check out the RT Wiki at http://wiki.bestpractical.com
> >
> > Download a free sample chapter of RT Essentials from O'Reilly Media at
> http://rtbook.bestpractical.com
> >
> > WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
> > San Francisco - Find out more at
> http://bestpractical.com/services/training.html
> >
> >
> > --
> > No virus found in this incoming message.
> > Checked by AVG Free Edition.
> > Version: 7.1.375 / Virus Database: 267.14.22/239 - Release Date:
1/24/2006
> >
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>
> Download a free sample chapter of RT Essentials from O'Reilly Media at
http://rtbook.bestpractical.com
>
> WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
> San Francisco - Find out more at
http://bestpractical.com/services/training.html
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.375 / Virus Database: 267.14.23/243 - Release Date: 1/27/2006
>
More information about the rt-users
mailing list