[rt-users] problem creating ticket - Found no sequence for Tickets
Elliot Finley
efinleywork at efinley.com
Thu Jan 26 17:15:30 EST 2006
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'
More information about the rt-users
mailing list