[Koha-bugs] [Bug 35111] Background jobs worker crashes on SIGPIPE when database connection lost in Ubuntu 22.04

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35111

--- Comment #14 from David Cook <dcook at prosentient.com.au> ---
Here's a stacktrace from koha-testing-docker using "master-jammy" image. I
added a SIGPIPE handler and used the test plan from Comment 3:

PIPE at /kohadevbox/koha/misc/workers/background_jobs_worker.pl line 58.
        main::__ANON__("PIPE") called at
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 932
        eval {...} called at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line
932
       
DBIx::Class::Storage::DBI::connected(DBIx::Class::Storage::DBI::mysql=HASH(0x561f24b1f1a8))
called at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 850
       
DBIx::Class::Storage::DBI::__ANON__(DBIx::Class::Storage::BlockRunner=HASH(0x561f24d28dc8))
called at /usr/share/perl5/DBIx/Class/Storage/BlockRunner.pm line 190
        DBIx::Class::Storage::BlockRunner::__ANON__() called at
/usr/share/perl5/Context/Preserve.pm line 38
        Context::Preserve::preserve_context(CODE(0x561f24954d50), "replace",
CODE(0x561f24954cf0)) called at
/usr/share/perl5/DBIx/Class/Storage/BlockRunner.pm line 213
       
DBIx::Class::Storage::BlockRunner::_run(DBIx::Class::Storage::BlockRunner=HASH(0x561f24d28dc8),
CODE(0x561f24959310)) called at
/usr/share/perl5/DBIx/Class/Storage/BlockRunner.pm line 105
       
DBIx::Class::Storage::BlockRunner::run(DBIx::Class::Storage::BlockRunner=HASH(0x561f24d28dc8),
CODE(0x561f24959310)) called at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line
856
        DBIx::Class::Storage::DBI::dbh_do(undef, undef, "SELECT `me`.`id`,
`me`.`status`, `me`.`progress`, `me`.`size`"..., ARRAY(0x561f24e56b40),
ARRAY(0x561f26b72b08)) called at /usr/share/perl5/DBIx/Class/Storage/DBI.pm
line 1939
       
DBIx::Class::Storage::DBI::_execute(DBIx::Class::Storage::DBI::mysql=HASH(0x561f24b1f1a8),
"select", ARRAY(0x561f26a3c390), ARRAY(0x561f24e56a08), HASH(0x561f24959328),
HASH(0x561f26b93218)) called at /usr/share/perl5/DBIx/Class/
Storage/DBI.pm line 2584
       
DBIx::Class::Storage::DBI::_select(DBIx::Class::Storage::DBI::mysql=HASH(0x561f24b1f1a8),
ARRAY(0x561f26a3c390), ARRAY(0x561f24e56a08), HASH(0x561f24959328),
HASH(0x561f24e56b58)) called at /usr/share/perl5/DBIx/Class/Storage/DBI
/Cursor.pm line 125
       
DBIx::Class::Storage::DBI::Cursor::next(DBIx::Class::Storage::DBI::Cursor=HASH(0x561f26b93290))
called at /usr/share/perl5/DBIx/Class/ResultSet.pm line 1329
       
DBIx::Class::ResultSet::_construct_results(DBIx::Class::ResultSet=HASH(0x561f24958500))
called at /usr/share/perl5/DBIx/Class/ResultSet.pm line 1242
       
DBIx::Class::ResultSet::next(DBIx::Class::ResultSet=HASH(0x561f24958500))
called at /kohadevbox/koha/Koha/Objects.pm line 317
        Koha::Objects::next(Koha::BackgroundJobs=HASH(0x561f26ec69d8)) called
at /kohadevbox/koha/misc/workers/background_jobs_worker.pl line 137

vi ./misc/workers/background_jobs_worker.pl

137         my $job = Koha::BackgroundJobs->search( { id => $args->{job_id},
status => 'new' } )->next;

-- 
You are receiving this mail because:
You are watching all bug changes.