Fw: [rt-users] problem creating ticket - Found no sequence for Tickets

Elliot Finley efinleywork at efinley.com
Sat Jan 28 21:56:34 EST 2006


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
>




More information about the rt-users mailing list