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

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

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

--- Comment #2 from David Cook <dcook at prosentient.com.au> ---
At the moment, I can only reproduce this on Ubuntu 22.04 Koha 22.11 and not
Debian 11 Koha master...

It looks like Ubuntu 22.04 is using MySQL client libraries and Debian is using
MariaDB client libraries, so that might be related.

Overall, the Koha code doesn't look that different, so I imagine it's coming
from a lower level. 

In fact... the info here seems to suggest that MySQL and MariaDB client
libraries have had some SIGPIPE issues over time...
https://github.com/perl5-dbi/DBD-MariaDB/pull/196
https://jira.mariadb.org/browse/CONC-591

But if that's the case then MySQL should be ignoring the SIGPIPE as well...

Looking at the Ubuntu patches for the MySQL library, it no longer reconnects on
its own... so I'm guessing the SIGPIPE is actually happening at a higher level
after all in the Ubuntu 22.04 example. 

And I'd guess that the MariaDB client is actually handling reconnections before
the DBIx::Class code. 

I'll have a look at master-jammy in koha-testing-docker which should help
confirm this theory...

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