Dear All, Hopefully you all will be fine and good health. I am pleased to inform you that the International Confrence Kohacon2021 website is up Now. Kindly visit for further details I.e. Registration, proposal submissions, date of Confrence and others. Regards Sher Afzal Khan President Koha Pakistan Country Ambassador DSpace Sent from my iPhone

On 26-Jul-2021, at 3:00 PM, koha-devel-request@lists.koha-community.org wrote:

Send Koha-devel mailing list submissions to koha-devel@lists.koha-community.org

To subscribe or unsubscribe via the World Wide Web, visit https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel or, via email, send a message with subject or body 'help' to koha-devel-request@lists.koha-community.org

You can reach the person managing the list at koha-devel-owner@lists.koha-community.org

When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha-devel digest..."

Today's Topics:

1. Re: Update from Koha 19.11 to 21.05 terminating because "Row size too large" (Katrin Fischer) 2. Re: Update from Koha 19.11 to 21.05 terminating because "Row size too large" (Michael Kuhn)

----------------------------------------------------------------------

Message: 1 Date: Sun, 25 Jul 2021 12:31:51 +0200 From: Katrin Fischer <katrin.fischer.83@web.de> To: koha-devel@lists.koha-community.org Subject: Re: [Koha-devel] Update from Koha 19.11 to 21.05 terminating because "Row size too large" Message-ID: <2bc7f482-ecef-ff7f-6b88-284ae283b715@web.de> Content-Type: text/plain; charset="utf-8"; Format="flowed"

Hi Michael,

I found another bug about the row size issue:

*Bug 28267* <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267> - Koha-common package upgrade problem from 20.05.xx to 20.11.04-1

I think filing a bug is always a good first step as we seem to run into this issue more and more.

Katrin

...

On 12.07.21 21:29, Michael Kuhn wrote: Hi

Today I updated our host from Debian GNU/Linux 9 with Koha 19.11.00 first to Debian GNU/Linux 10, then to Koha 21.05.01. When running "apt-get install koha-common" the process terminated showing the following messages:

### BEGIN #########################

Upgrade to 19.12.00.052 done [18:30:04]: Bug 21443 - Add ability to exclude holidays when calculating rentals fees by time period {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs [for Statement "ALTER TABLE borrowers ADD COLUMN autorenew_checkouts TINYINT(1) NOT NULL DEFAULT 1 AFTER anonymized"] at /usr/share/perl5/DBIx/Class/Schema.pm line 1118. DBIx::Class::Schema::throw_exception(Koha::Schema=HASH(0x30abec0), "DBI Exception: DBD::mysql::db do failed: Row size too large. "...) called at /usr/share/perl5/DBIx/Class/Storage.pm line 113 DBIx::Class::Storage::throw_exception(DBIx::Class::Storage::DBI::mysql=HASH(0x3aa549c), "DBI Exception: DBD::mysql::db do failed: Row size too large. "...) called at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1501 DBIx::Class::Storage::DBI::__ANON__("DBD::mysql::db do failed: Row size too large. The maximum row"..., DBI::db=HASH(0x3ee6314), undef) called at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 21313

dpkg: error processing package koha-common (--configure): installed koha-common package post-installation script subprocess returned error exit status 11 Processing triggers for systemd (241-7~deb10u7) ... Errors were encountered while processing: koha-common E: Sub-process /usr/bin/dpkg returned an error code (1) Script done, file is /tmp/apt-get_install_koha-common_20210712.txt

### END #########################

This looks a lot like https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24986 (Maximum row size reached soon for borrowers and deletedborrowers) or https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267 (Koha-common package upgrade problem from 20.05.xx to 20.11.04-1) but it's not exactly the same.

According to https://mariadb.com/kb/en/troubleshooting-row-size-too-large-errors-with-inn... I ran the described script "rowsize.sh" which showed me the following 7 tables with row size too large.

aqbooksellers biblioitems borrower_modifications borrowers deletedbiblioitems deletedborrowers z3950servers

One solution seems to be to alter the row format of these tables from "Compact" to "Dynamic" so I did that for all seven tables.

ALTER TABLE aqbooksellers ROW_FORMAT=DYNAMIC; etc

After running "apt-get install koha-common" again, the process continued with

Upgrade to 19.12.00.053 done [19:19:28]: Bug 24476 - Allow patrons to opt-out of autorenewal

and ran to the end.

Upgrade to 21.05.01.003 done [19:19:38]: Koha 21.05.01 release Error: the selected language is already installed. Try --update if you want to re-install it. ERROR: an error was found when updating 'de-DE' translations. Please manually run 'koha-translate --update de-DE'. Run man koha-translate for more options.

Except of the error regarding the "selected language" which I have described in another e-mail to koha-devel, everything seems to work fine.

Still I'm asking myself if I should open another bug report about "Row size too large" since the problem does not to be solved by Bug 24986 ("Pushed to master for 20.11") or the pending Bug 28267.

Also I'm not sure what consequences the changed row format "Dynamic" for these 7 tables might have.

Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : https://www.koha-community.org/ git : https://git.koha-community.org/ bugs : https://bugs.koha-community.org/