[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