search

USGCRP / gcis

Global Change Information System
https://data.globalchange.gov
Other
20 stars 16 forks source link

Reports with Regions are throwing a 500 error #534

Closed lomky closed 5 years ago

lomky commented 7 years ago

Specific reports giving 500 errors on GET.

Example:

https://data.globalchange.gov/report/ccsp-2003planupdate-2008

Log:

[Mon Jun 12 16:09:37 2017] [debug] GET "/report/ccsp-2003planupdate-2008"
[Mon Jun 12 16:09:37 2017] [debug] Routing to controller "Tuba::Report" and action "show"
[Mon Jun 12 16:09:37 2017] [debug] Rendering template "report/object.html.ep"
[Mon Jun 12 16:09:37 2017] [debug] Rendering template "edit_buttons.html.ep"
[Mon Jun 12 16:09:37 2017] [debug] Rendering template "h/thumbnail.html.ep"
[Mon Jun 12 16:09:37 2017] [debug] Rendering template "h/contributors.html.ep"
[Mon Jun 12 16:09:37 2017] [error] Can't locate object method "regions" via package "Tuba::DB::Object::Report" at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Rose/DB/Object.pm line 1657.
        Rose::DB::Object::AUTOLOAD(Tuba::DB::Object::Report=HASH(0x9c85fd0)) called at template report/object.html.ep line 18
        Mojo::Template::Sandbox::2be7e20ed08cdc41ddd6583023813d1a::__ANON__(1, "region", "list_report_regions") called at template report/object.html.ep line 54
        Mojo::Template::Sandbox::2be7e20ed08cdc41ddd6583023813d1a::__ANON__(Tuba::Report=HASH(0x9c4fdf0)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojo/Template.pm line 109
        eval {...} called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojo/Template.pm line 109
        Mojo::Template::interpret(Mojo::Template=HASH(0x9c8b228), Tuba::Report=HASH(0x9c4fdf0)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojo/Template.pm line 232
        Mojo::Template::render(Mojo::Template=HASH(0x9c8b228), "% layout 'default',\x{a}%  title => \$report->identifier.' - '.\$re"..., Tuba::Report=HASH(0x9c4fdf0)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojo/Template.pm line 244
        Mojo::Template::render_file(Mojo::Template=HASH(0x9c8b228), "/opt/perl5/common/libs/perl-5.20.1\@gcis/lib/perl5/auto/share/"..., Tuba::Report=HASH(0x9c4fdf0)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojolicious/Plugin/EPLRenderer.pm line 39
        Mojolicious::Plugin::EPLRenderer::_epl(Mojolicious::Renderer=HASH(0x3698100), Tuba::Report=HASH(0x9c4fdf0), SCALAR(0x9bf1320), HASH(0x9be6218)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojolicious/Plugin/EPRenderer.pm line 50
        Mojolicious::Plugin::EPRenderer::__ANON__(Mojolicious::Renderer=HASH(0x3698100), Tuba::Report=HASH(0x9c4fdf0), SCALAR(0x9bf1320), HASH(0x9be6218)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojolicious/Renderer.pm line 229
        Mojolicious::Renderer::_render_template(Mojolicious::Renderer=HASH(0x3698100), Tuba::Report=HASH(0x9c4fdf0), SCALAR(0x9bf1320), HASH(0x9be6218)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojolicious/Renderer.pm line 134
        Mojolicious::Renderer::render(Mojolicious::Renderer=HASH(0x3698100), Tuba::Report=HASH(0x9c4fdf0), HASH(0x9c8b270)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojolicious/Controller.pm line 172
        Mojolicious::Controller::render(Tuba::Report=HASH(0x9c4fdf0), "report/object", "mojo.maybe", 1) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojolicious/Controller.pm line 188
        Mojolicious::Controller::render_maybe(Tuba::Report=HASH(0x9c4fdf0), "report/object") called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Tuba/Controller.pm line 278
        Tuba::Controller::__ANON__(Tuba::Report=HASH(0x9c4fdf0)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojolicious/Controller.pm line 244
        Mojolicious::Controller::respond_to(Tuba::Report=HASH(0x9c4fdf0), "yaml", CODE(0x9c342c0), "json", CODE(0x9c85be0), "ttl", CODE(0x9c7f960), "thtml", CODE(0x9c85ef8), ...) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Tuba/Controller.pm line 301
        Tuba::Controller::show(Tuba::Report=HASH(0x9c4fdf0)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Tuba/Report.pm line 66
        Tuba::Report::show(Tuba::Report=HASH(0x9c4fdf0)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojolicious.pm line 120
        Mojolicious::__ANON__(undef, Tuba::Report=HASH(0x9c4fdf0), CODE(0x82e78b8), 1) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojolicious/Plugins.pm line 21
        Mojolicious::Plugins::__ANON__() called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojolicious/Plugins.pm line 24
        Mojolicious::Plugins::emit_chain(Mojolicious::Plugins=HASH(0x3d173a8), "around_action", Tuba::Report=HASH(0x9c4fdf0), CODE(0x82e78b8), 1) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojolicious/Routes.pm line 93
        Mojolicious::Routes::_action(Tuba=HASH(0x3698280), Tuba::Report=HASH(0x9c4fdf0), CODE(0x82e78b8), 1) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojolicious/Routes.pm line 172
        Mojolicious::Routes::_controller(Mojolicious::Routes=HASH(0x413f078), Mojolicious::Controller=HASH(0x98bf158), HASH(0x9c7b490), 1) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojolicious/Routes.pm line 36
        Mojolicious::Routes::continue(Mojolicious::Routes=HASH(0x413f078), Mojolicious::Controller=HASH(0x98bf158)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojolicious/Routes.pm line 44
        Mojolicious::Routes::dispatch(Mojolicious::Routes=HASH(0x413f078), Mojolicious::Controller=HASH(0x98bf158)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojolicious.pm line 111
        Mojolicious::dispatch(Tuba=HASH(0x3698280), Mojolicious::Controller=HASH(0x98bf158)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojolicious.pm line 121
        Mojolicious::__ANON__(undef, Mojolicious::Controller=HASH(0x98bf158)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojolicious/Plugins.pm line 21
        Mojolicious::Plugins::__ANON__() called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojolicious.pm line 197
        eval {...} called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojolicious.pm line 197
        Mojolicious::_exception(CODE(0x9c44540), Mojolicious::Controller=HASH(0x98bf158)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojolicious/Plugins.pm line 21
        Mojolicious::Plugins::__ANON__() called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojolicious/Plugins.pm line 24
        Mojolicious::Plugins::emit_chain(Mojolicious::Plugins=HASH(0x3d173a8), "around_dispatch", Mojolicious::Controller=HASH(0x98bf158)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojolicious.pm line 127
        Mojolicious::handler(Tuba=HASH(0x3698280), Mojo::Transaction::HTTP=HASH(0x9c25880)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojo/Server.pm line 68
        Mojo::Server::__ANON__(Mojo::Server::Prefork=HASH(0x28a0e10), Mojo::Transaction::HTTP=HASH(0x9c25880)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojo/EventEmitter.pm line 15
        Mojo::EventEmitter::emit(Mojo::Server::Prefork=HASH(0x28a0e10), "request", Mojo::Transaction::HTTP=HASH(0x9c25880)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojo/Server/Daemon.pm line 90
        Mojo::Server::Daemon::__ANON__(Mojo::Transaction::HTTP=HASH(0x9c25880)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojo/EventEmitter.pm line 15
        Mojo::EventEmitter::emit(Mojo::Transaction::HTTP=HASH(0x9c25880), "request") called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojo/Transaction/HTTP.pm line 65
        Mojo::Transaction::HTTP::server_read(Mojo::Transaction::HTTP=HASH(0x9c25880), "GET /report/ccsp-2003planupdate-2008 HTTP/1.0\x{d}\x{a}Host: data-sta"...) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojo/Server/Daemon.pm line 195
        Mojo::Server::Daemon::_read(Mojo::Server::Prefork=HASH(0x28a0e10), "8527c177f7b6027584f5deced3371feb", "GET /report/ccsp-2003planupdate-2008 HTTP/1.0\x{d}\x{a}Host: data-sta"...) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojo/Server/Daemon.pm line 175
        Mojo::Server::Daemon::__ANON__(Mojo::IOLoop::Stream=HASH(0x9c66c90)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojo/EventEmitter.pm line 15
        Mojo::EventEmitter::emit(Mojo::IOLoop::Stream=HASH(0x9c66c90), "read", "GET /report/ccsp-2003planupdate-2008 HTTP/1.0\x{d}\x{a}Host: data-sta"...) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojo/IOLoop/Stream.pm line 97
        Mojo::IOLoop::Stream::_read(Mojo::IOLoop::Stream=HASH(0x9c66c90)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojo/IOLoop/Stream.pm line 48
        Mojo::IOLoop::Stream::__ANON__(Mojo::Reactor::Poll=HASH(0x32688f0)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojo/Reactor/Poll.pm line 130
        eval {...} called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojo/Reactor/Poll.pm line 130
        Mojo::Reactor::Poll::_try(Mojo::Reactor::Poll=HASH(0x32688f0), "I/O watcher", CODE(0x9c1a290), 0) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojo/Reactor/Poll.pm line 51
        Mojo::Reactor::Poll::one_tick(Mojo::Reactor::Poll=HASH(0x32688f0)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojo/Reactor/Poll.pm line 92
        Mojo::Reactor::Poll::start(Mojo::Reactor::Poll=HASH(0x32688f0)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojo/IOLoop.pm line 134
        Mojo::IOLoop::start(Mojo::IOLoop=HASH(0x2d705d0)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojo/Server/Prefork.pm line 167
        Mojo::Server::Prefork::_spawn(Mojo::Server::Prefork=HASH(0x28a0e10)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojo/Server/Prefork.pm line 102
        Mojo::Server::Prefork::_manage(Mojo::Server::Prefork=HASH(0x28a0e10)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojo/Server/Prefork.pm line 92
        Mojo::Server::Prefork::run(Mojo::Server::Prefork=HASH(0x28a0e10)) called at /opt/perl5/common/libs/perl-5.20.1@gcis/lib/perl5/Mojo/Server/Hypnotoad.pm line 77
        Mojo::Server::Hypnotoad::run(Mojo::Server::Hypnotoad=HASH(0x2711900), "/opt/perl5/common/libs/perl-5.20.1\@gcis/bin/tuba") called at /opt/perl5/common/libs/perl-5.20.1@gcis/bin/hypnotoad line 24
19:   require Mojolicious::Command;
20:   die Mojolicious::Command->new->extract_usage;
21: }
22:
23: require Mojo::Server::Hypnotoad;
24: Mojo::Server::Hypnotoad->new->run($app);
25:
26: =encoding utf8
27:
28: =head1 NAME
29:

[Mon Jun 12 16:09:37 2017] [debug] Rendering template "exception.production.html.ep"
[Mon Jun 12 16:09:37 2017] [debug] Rendering template "layouts/default.html.ep"
[Mon Jun 12 16:09:37 2017] [debug] Rendering template "menu.html.ep"
[Mon Jun 12 16:09:37 2017] [debug] 500 Internal Server Error (0.108725s, 9.198/s)
lomky commented 6 years ago

the URL is bad from from /region page as well