Bug 33472 - Error 500 when many items attached to bib record
Summary: Error 500 when many items attached to bib record
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: OPAC (show other bugs)
Version: 22.11
Hardware: All All
: P5 - low normal (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-04-09 21:04 UTC by David Roberts
Modified: 2024-01-23 08:51 UTC (History)
5 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description David Roberts 2023-04-09 21:04:01 UTC
We have a customer that has bibliographic records with several hundred items attached to each. When searching for these records, an error 500 is displayed instead. Lowering OpacMaxItemsToDisplay from 750 to 75 enables the records to display, although now when you click on the link to view all physical records an error 500 is still generated.
Comment 1 Jonathan Druart 2023-05-09 07:01:46 UTC
What is the error you have in Koha logs?
Comment 2 David Roberts 2024-01-23 03:18:17 UTC
I can't see a great deal in the logs that is meaningful:

[2024/01/23 03:06:39] [WARN] item-level_itypes set but no itemtype set for item (121386) at /usr/share/koha/lib/Koha/Schema/Result/Item.pm line 979.


Template process failed: undef error - The method Koha::Serial::Item->serialseq                                                                              is not covered by tests!

Trace begun at /usr/share/koha/lib/Koha/Object.pm line 900
Koha::Object::AUTOLOAD('Koha::Serial::Item=HASH(0x5640d6589300)') called at /usr                                                                             /share/koha/opac/htdocs/opac-tmpl/bootstrap/en/modules/opac-detail.tt line 1340
eval {...} at /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/en/modules/opac-de                                                                             tail.tt line 1340
eval {...} at /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/en/modules/opac-de                                                                             tail.tt line 1429
eval {...} at /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/en/modules/opac-de                                                                             tail.tt line 1183
Template::Provider::__ANON__('Template::Context=HASH(0x5640da2017b0)') called at                                                                              /usr/lib/x86_64-linux-gnu/perl5/5.32/Template/Context.pm line 348
eval {...} at /usr/lib/x86_64-linux-gnu/perl5/5.32/Template/Context.pm line 321
Template::Context::process('Template::Context=HASH(0x5640da2017b0)', 'items_tabl                                                                             e', 'HASH(0x5640db784748)', 'localize me!') called at /usr/lib/x86_64-linux-gnu/                                                                             perl5/5.32/Template/Context.pm line 409
Template::Context::include('Template::Context=HASH(0x5640da2017b0)', 'items_tabl                                                                             e', 'HASH(0x5640db784748)') called at /usr/share/koha/opac/htdocs/opac-tmpl/boot                                                                             strap/en/modules/opac-detail.tt line 534
eval {...} at /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/en/modules/opac-de                                                                             tail.tt line 18
Template::Provider::__ANON__('Template::Context=HASH(0x5640da2017b0)') called at                                                                              /usr/lib/x86_64-linux-gnu/perl5/5.32/Template/Document.pm line 163
eval {...} at /usr/lib/x86_64-linux-gnu/perl5/5.32/Template/Document.pm line 161
Template::Document::process('Template::Document=HASH(0x5640db7180f0)', 'Template                                                                             ::Context=HASH(0x5640da2017b0)') called at /usr/lib/x86_64-linux-gnu/perl5/5.32/                                                                             Template/Context.pm line 351
eval {...} at /usr/lib/x86_64-linux-gnu/perl5/5.32/Template/Context.pm line 321
Template::Context::process('Template::Context=HASH(0x5640da2017b0)', 'Template::                                                                             Document=HASH(0x5640db7180f0)') called at /usr/lib/x86_64-linux-gnu/perl5/5.32/T                                                                             emplate/Service.pm line 94
eval {...} at /usr/lib/x86_64-linux-gnu/perl5/5.32/Template/Service.pm line 91
Template::Service::process('Template::Service=HASH(0x5640db9c2ce8)', '/usr/share                                                                             /koha/opac/htdocs/opac-tmpl/bootstrap/en/modules/opac-detail.tt', 'HASH(0x5640db                                                                             691e88)') called at /usr/lib/x86_64-linux-gnu/perl5/5.32/Template.pm line 66
Template::process('Template=HASH(0x5640da4e43f8)', '/usr/share/koha/opac/htdocs/                                                                             opac-tmpl/bootstrap/en/modules/opac-detail.tt', 'HASH(0x5640db691e88)', 'SCALAR(                                                                             0x5640d28a6088)') called at /usr/share/koha/lib/C4/Templates.pm line 127
C4::Templates::output('C4::Templates=HASH(0x5640db9bff98)') called at /usr/share                                                                             /koha/opac/cgi-bin/opac/opac-detail.pl line 1249
eval {...} at /usr/share/koha/opac/cgi-bin/opac/opac-detail.pl line 2
CGI::Compile::ROOT::usr_share_koha_opac_cgi_2dbin_opac_opac_2ddetail_2epl::__ANO                                                                             N__('CGI::Compile=HASH(0x5640ce960da8)', '', '/usr/share/koha/opac/cgi-bin/opac/                                                                             opac-detail.pl', '/usr/share/koha/opac/cgi-bin/opac', 'ARRAY(0x5640d626ff58)') c                                                                             alled at /usr/share/perl5/CGI/Compile.pm line 151
CGI::Compile::ROOT::usr_share_koha_opac_cgi_2dbin_opac_opac_2ddetail_2epl::opac_                                                                             2ddetail_2epl at /usr/share/perl5/CGI/Emulate/PSGI.pm line 30
CGI::Emulate::PSGI::__ANON__('HASH(0x5640d632d640)') called at /usr/share/perl5/                                                                             Plack/App/WrapCGI.pm line 95
Plack::App::WrapCGI::call('Plack::App::WrapCGI=HASH(0x5640d61b13f0)', 'HASH(0x56                                                                             40d632d640)') called at /usr/share/perl5/Plack/Component.pm line 50
Plack::Component::__ANON__('HASH(0x5640d632d640)') called at /usr/share/perl5/Pl                                                                             ack/App/CGIBin.pm line 50
Plack::App::CGIBin::serve_path('Plack::App::CGIBin=HASH(0x5640ce719e20)', 'HASH(                                                                             0x5640d632d640)', '/usr/share/koha/opac/cgi-bin/opac/opac-detail.pl') called at                                                                              /usr/share/perl5/Plack/App/File.pm line 34
Plack::App::File::call('Plack::App::CGIBin=HASH(0x5640ce719e20)', 'HASH(0x5640d6                                                                             32d640)') called at /usr/share/perl5/Plack/Component.pm line 50
Plack::Component::__ANON__('HASH(0x5640d632d640)') called at /usr/share/perl5/Pl                                                                             ack/Middleware/LogWarn.pm line 22
Plack::Middleware::LogWarn::call('Plack::Middleware::LogWarn=HASH(0x5640d63584c8                                                                             )', 'HASH(0x5640d632d640)') called at /usr/share/perl5/Plack/Component.pm line 5                                                                             0
Plack::Component::__ANON__('HASH(0x5640d632d640)') called at /usr/share/perl5/Pl                                                                             ack/Middleware/Log4perl.pm line 30
Plack::Middleware::Log4perl::call('Plack::Middleware::Log4perl=HASH(0x5640d63614                                                                             00)', 'HASH(0x5640d632d640)') called at /usr/share/perl5/Plack/Component.pm line                                                                              50
Plack::Component::__ANON__('HASH(0x5640d632d640)') called at /usr/share/perl5/Pl                                                                             ack/Middleware/HTTPExceptions.pm line 20
Plack::Middleware::HTTPExceptions::try {...}  at /usr/share/perl5/Try/Tiny.pm li                                                                             ne 100
eval {...} at /usr/share/perl5/Try/Tiny.pm line 93
Try::Tiny::try('CODE(0x5640da464628)', 'Try::Tiny::Catch=REF(0x5640db9bfc38)') c                                                                             alled at /usr/share/perl5/Plack/Middleware/HTTPExceptions.pm line 23
Plack::Middleware::HTTPExceptions::call('Plack::Middleware::HTTPExceptions=HASH(                                                                             0x5640d6361610)', 'HASH(0x5640d632d640)') called at /usr/share/perl5/Plack/Compo                                                                             nent.pm line 50
Plack::Component::__ANON__('HASH(0x5640d632d640)') called at /usr/share/perl5/Pl                                                                             ack/Middleware/ErrorDocument.pm line 15
Plack::Middleware::ErrorDocument::call('Plack::Middleware::ErrorDocument=HASH(0x                                                                             5640d6377150)', 'HASH(0x5640d632d640)') called at /usr/share/perl5/Plack/Compone                                                                             nt.pm line 50
Plack::Component::__ANON__('HASH(0x5640d632d640)') called at /usr/share/perl5/Pl                                                                             ack/App/URLMap.pm line 71
Plack::App::URLMap::call('Plack::App::URLMap=HASH(0x5640d4f251e0)', 'HASH(0x5640                                                                             d632d640)') called at /usr/share/perl5/Plack/Component.pm line 50
Plack::Component::__ANON__('HASH(0x5640d632d640)') called at /usr/share/koha/lib                                                                             /Koha/Middleware/RealIP.pm line 64
Koha::Middleware::RealIP::call('Koha::Middleware::RealIP=HASH(0x5640d6360e30)',                                                                              'HASH(0x5640d632d640)') called at /usr/share/perl5/Plack/Component.pm line 50
Plack::Component::__ANON__('HASH(0x5640d632d640)') called at /usr/share/koha/lib                                                                             /Koha/Middleware/SetEnv.pm line 105
Koha::Middleware::SetEnv::call('Koha::Middleware::SetEnv=HASH(0x5640d634f8c0)',                                                                              'HASH(0x5640d62a79d8)') called at /usr/share/perl5/Plack/Component.pm line 50
Plack::Component::__ANON__('HASH(0x5640d62a79d8)') called at /usr/share/perl5/Pl                                                                             ack/Middleware/Static.pm line 18
Plack::Middleware::Static::call('Plack::Middleware::Static=HASH(0x5640d63646f8)'                                                                             , 'HASH(0x5640d62a79d8)') called at /usr/share/perl5/Plack/Component.pm line 50
Plack::Component::__ANON__('HASH(0x5640d62a79d8)') called at /usr/share/perl5/Pl                                                                             ack/Middleware/ReverseProxy.pm line 68
Plack::Middleware::ReverseProxy::call('Plack::Middleware::ReverseProxy=HASH(0x56                                                                             40d634f5c0)', 'HASH(0x5640d62a79d8)') called at /usr/share/perl5/Plack/Component                                                                             .pm line 50
Plack::Component::__ANON__('HASH(0x5640d62a79d8)') called at /usr/share/perl5/Pl                                                                             ack/Middleware/AccessLog.pm line 27
Plack::Middleware::AccessLog::call('Plack::Middleware::AccessLog=HASH(0x5640ce72                                                                             b370)', 'HASH(0x5640d62a79d8)') called at /usr/share/perl5/Plack/Component.pm li                                                                             ne 50
Plack::Component::__ANON__('HASH(0x5640d62a79d8)') called at /usr/share/perl5/Pl                                                                             ack/Util.pm line 145
eval {...} at /usr/share/perl5/Plack/Util.pm line 145
Plack::Util::run_app('CODE(0x5640ce72b328)', 'HASH(0x5640d62a79d8)') called at /                                                                             usr/share/perl5/Starman/Server.pm line 195
Starman::Server::dispatch_request('Starman::Server=HASH(0x5640ce133e80)', 'HASH(                                                                             0x5640d62a79d8)') called at /usr/share/perl5/Starman/Server.pm line 298
Starman::Server::process_request('Starman::Server=HASH(0x5640ce133e80)', 'Net::S                                                                             erver::Proto::UNIX=GLOB(0x5640da2413d8)') called at /usr/share/perl5/Net/Server.                                                                             pm line 72
Net::Server::run_client_connection('Starman::Server=HASH(0x5640ce133e80)') calle                                                                             d at /usr/share/perl5/Net/Server/PreFork.pm line 225
eval {...} at /usr/share/perl5/Net/Server/PreFork.pm line 225
Net::Server::PreFork::run_child('Starman::Server=HASH(0x5640ce133e80)') called a                                                                             t /usr/share/perl5/Net/Server/PreFork.pm line 183
Net::Server::PreFork::run_n_children('Starman::Server=HASH(0x5640ce133e80)', 1)                                                                              called at /usr/share/perl5/Net/Server/PreFork.pm line 373
Net::Server::PreFork::coordinate_children('Starman::Server=HASH(0x5640ce133e80)'                                                                             ) called at /usr/share/perl5/Net/Server/PreFork.pm line 327
Net::Server::PreFork::run_parent('Starman::Server=HASH(0x5640ce133e80)') called                                                                              at /usr/share/perl5/Starman/Server.pm line 164
Starman::Server::run_parent('Starman::Server=HASH(0x5640ce133e80)') called at /u                                                                             sr/share/perl5/Net/Server/PreFork.pm line 109
Net::Server::PreFork::loop('Starman::Server=HASH(0x5640ce133e80)') called at /us                                                                             r/share/perl5/Net/Server.pm line 58
Net::Server::run('Starman::Server=HASH(0x5640ce133e80)', 'port', 'ARRAY(0x5640ce                                                                             6c4750)', 'host', '*', 'proto', 'tcp', 'serialize', 'none', 'min_servers', 6, 'm                                                                             in_spare_servers', 5, 'max_spare_servers', 5, 'max_servers', 6, 'max_requests',                                                                              50, 'user', 'kfc-koha', 'group', 'kfc-koha', 'listen', 1024, 'check_for_waiting'                                                                             , 1, 'no_client_stdout', 1, 'log_file', '/var/log/koha/kfc/plack-error.log', 'pi                                                                             d_file', '/var/run/koha/kfc/plack.pid', 'setsid', 1, 'background', 1) called at                                                                              /usr/share/perl5/Starman/Server.pm line 106
Starman::Server::run('Starman::Server=HASH(0x5640ce133e80)', 'CODE(0x5640ce133d6                                                                             0)', 'HASH(0x5640ce133b08)') called at /usr/share/perl5/Plack/Handler/Starman.pm                                                                              line 25
Plack::Handler::Starman::run('Plack::Handler::Starman=HASH(0x5640ce133d78)', 'CO                                                                             DE(0x5640ce133d60)') called at /usr/share/perl5/Plack/Loader/Delayed.pm line 20
Plack::Loader::Delayed::run('Plack::Loader::Delayed=HASH(0x5640cdf84120)', 'Plac                                                                             k::Handler::Starman=HASH(0x5640ce133d78)') called at /usr/share/perl5/Plack/Runn                                                                             er.pm line 279
Plack::Runner::run('Plack::Runner=HASH(0x5640cdf1e088)') called at /bin/starman                                                                              line 38

There are 78 items attached to this bib record, all of which have item types associates, together with a valid 942 subfield c.
Comment 3 Katrin Fischer 2024-01-23 08:51:12 UTC
The meaningful is right at the beginning:

"[2024/01/23 03:06:39] [WARN] item-level_itypes set but no itemtype set for item (121386) at /usr/share/koha/lib/Koha/Schema/Result/Item.pm line 979."

You should double check the item with this itemnumber = 121386.