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