[rt-users] Wait, what?

Thu May 3 19:19:06 EDT 2012

I'm seeing this on my console

[Thu May  3 23:06:29 2012] [warning]: DBD::Pg::st execute failed: ERROR:
 relation "tickets" does not exist
LINE 1: SELECT main.* FROM Tickets main  WHERE (main.Status != 'dele...
                           ^ at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509.
(/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
[Thu May  3 23:06:29 2012] [warning]: RT::Handle=HASH(0x848de00) couldn't
execute the query 'SELECT main.* FROM Tickets main  WHERE (main.Status !=
'deleted') AND (main.Queue = '4' AND  ( main.Status = 'new' OR main.Status
= 'open' OR main.Status = 'stalled' ) ) AND (main.EffectiveId = main.id)
AND (main.Type = 'ticket')  ORDER BY main.id ASC  LIMIT 1000' at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x848de00)',
'SELECT main.* FROM Tickets main  WHERE (main.Status != \'dele...') called
at /usr/share/perl5/DBIx/SearchBuilder.pm line 235
DBIx::SearchBuilder::_DoSearch('RT::Tickets=HASH(0x84808b0)') called at
/opt/rt4/sbin/../lib/RT/SearchBuilder.pm line 320
RT::SearchBuilder::_DoSearch('RT::Tickets=HASH(0x84808b0)') called at
/opt/rt4/sbin/../lib/RT/Tickets.pm line 2955
RT::Tickets::_DoSearch('RT::Tickets=HASH(0x84808b0)') called at
/usr/share/perl5/DBIx/SearchBuilder.pm line 503
DBIx::SearchBuilder::Next('RT::Tickets=HASH(0x84808b0)') called at
/opt/rt4/sbin/../lib/RT/Tickets.pm line 2927
RT::Tickets::Next('RT::Tickets=HASH(0x84808b0)') called at
/opt/rt4/sbin/../lib/RT/Tickets.pm line 2910
RT::Tickets::ItemsArrayRefWindow('RT::Tickets=HASH(0x84808b0)', 1000)
called at /opt/rt4/sbin/../lib/RT/Tickets.pm line 3441
RT::Tickets::_BuildItemMap('RT::Tickets=HASH(0x84808b0)') called at
/opt/rt4/sbin/../lib/RT/Tickets.pm line 3482
RT::Tickets::ItemMap('RT::Tickets=HASH(0x84808b0)') called at
/opt/rt4/share/html/Ticket/Display.html line 223
HTML::Mason::Commands::__ANON__('id', 19) called at
/usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x73ccba8)',
'id', 19) called at /usr/share/perl5/HTML/Mason/Request.pm line 1302
eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'id', 19) called at
/usr/share/perl5/HTML/Mason/Request.pm line 955
HTML::Mason::Request::call_next('RT::Interface::Web::Request=HASH(0x7a0f408)')
called at /opt/rt4/share/html/Ticket/autohandler line 19
HTML::Mason::Commands::__ANON__('id', 19) called at
/usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7724e60)',
'id', 19) called at /usr/share/perl5/HTML/Mason/Request.pm line 1302
eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'id', 19) called at
/opt/rt4/sbin/../lib/RT/Interface/Web.pm line 548
RT::Interface::Web::ShowRequestedPage('HASH(0x7b76c60)') called at
/opt/rt4/sbin/../lib/RT/Interface/Web.pm line 295
RT::Interface::Web::HandleRequest('HASH(0x7b76c60)') called at
/opt/rt4/share/html/autohandler line 53
HTML::Mason::Commands::__ANON__('id', 19) called at
/usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x717e1c8)',
'id', 19) called at /usr/share/perl5/HTML/Mason/Request.pm line 1297
eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'id', 19) called at
/usr/share/perl5/HTML/Mason/Request.pm line 481
eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 481
eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 433
HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x7a0f408)')
called at /usr/share/perl5/HTML/Mason/PSGIHandler.pm line 85
eval {...} called at /usr/share/perl5/HTML/Mason/PSGIHandler.pm line 85
HTML::Mason::Request::PSGI::exec('RT::Interface::Web::Request=HASH(0x7a0f408)')
called at /usr/share/perl5/HTML/Mason/Interp.pm line 342
HTML::Mason::Interp::exec(undef, undef, 'id', 19) called at
/usr/share/perl5/HTML/Mason/PSGIHandler.pm line 48
eval {...} called at /usr/share/perl5/HTML/Mason/PSGIHandler.pm line 48
HTML::Mason::PSGIHandler::invoke_mason('HTML::Mason::PSGIHandler::Streamy=HASH(0x3ab53f0)',
'HTML::Mason::FakeApache=HASH(0x7b34bd8)', 'HASH(0x84b04e8)') called at
/usr/share/perl5/HTML/Mason/PSGIHandler/Streamy.pm line 52
HTML::Mason::PSGIHandler::Streamy::__ANON__('CODE(0x84922a8)') called at
/opt/rt4/sbin/../lib/RT/Interface/Web/Handler.pm line 255
RT::Interface::Web::Handler::__ANON__('CODE(0x84922a8)') called at
/usr/share/perl5/Plack/Util.pm line 315
Plack::Util::__ANON__('CODE(0x84d5b38)') called at
/usr/share/perl5/Plack/Util.pm line 315
Plack::Util::__ANON__('CODE(0x84923b0)') called at
/usr/share/perl5/HTTP/Server/PSGI.pm line 185
HTTP::Server::PSGI::handle_connection('HTTP::Server::PSGI=HASH(0x3abc398)',
'HASH(0x7b5b450)', 'IO::Socket::INET=GLOB(0x8491ff0)', 'CODE(0x6f7e418)')
called at /usr/share/perl5/HTTP/Server/PSGI.pm line 134
HTTP::Server::PSGI::accept_loop('HTTP::Server::PSGI=HASH(0x3abc398)',
'CODE(0x3ab96e0)') called at /usr/share/perl5/HTTP/Server/PSGI.pm line 62
HTTP::Server::PSGI::run('HTTP::Server::PSGI=HASH(0x3abc398)',
'CODE(0x3ab96e0)') called at
/usr/share/perl5/Plack/Handler/HTTP/Server/PSGI.pm line 14
Plack::Handler::HTTP::Server::PSGI::run('Plack::Handler::Standalone=HASH(0x6f7e898)',
'CODE(0x3ab96e0)') called at /usr/share/perl5/Plack/Loader.pm line 87
Plack::Loader::run('Plack::Loader=HASH(0x3abc248)',
'Plack::Handler::Standalone=HASH(0x6f7e898)') called at
/usr/share/perl5/Plack/Runner.pm line 263
Plack::Runner::run('Plack::Runner=HASH(0x68961d0)', 'CODE(0x3ab96e0)')
called at /opt/rt4/sbin/rt-server line 231
eval {...} called at /opt/rt4/sbin/rt-server line 231
(/usr/share/perl/5.12/Carp.pm:65)

I configured my server in devel mode:
./configure --enable-devel-mode --with-my-user-group --with-db-type=Pg
--with-web-handler=standalone,fastcgi
and I'm running it stand-alone:
/opt/rt4/sbin/rt-server --server Standalone --port 8080 &

I can't think of any reason why it would think the table "tickets" doesn't
exist, because of course it does.  When I paste the query into pgsql it
founds 4 tickets.  I'm also not seeing anything unexpected on the web form.

-- 
http://www.linkedin.com/in/paultomblin
http://careers.stackoverflow.com/ptomblin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120503/903382e5/attachment.htm>