<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body>A new request with request id 16911 has been created by koha-devel-request@lists.koha-community.org. Short info on the request is : <br><br>Title : Koha-devel Digest, Vol 188, Issue 15<br>Category : <br>Description : <div>Send Koha-devel mailing list submissions to<br> koha-devel@lists.koha-community.org<br><br>To subscribe or unsubscribe via the World Wide Web, visit<br> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>or, via email, send a message with subject or body 'help' to<br> koha-devel-request@lists.koha-community.org<br><br>You can reach the person managing the list at<br> koha-devel-owner@lists.koha-community.org<br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of Koha-devel digest..."<br><br><br>Today's Topics:<br><br> 1. Re: Update from Koha 19.11 to 21.05 terminating because "Row<br> size too large" (Katrin Fischer)<br> 2. Re: Update from Koha 19.11 to 21.05 terminating because "Row<br> size too large" (Michael Kuhn)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Sun, 25 Jul 2021 12:31:51 +0200<br>From: Katrin Fischer <katrin.fischer.83@web.de><br>To: koha-devel@lists.koha-community.org<br>Subject: Re: [Koha-devel] Update from Koha 19.11 to 21.05 terminating<br> because "Row size too large"<br>Message-ID: <2bc7f482-ecef-ff7f-6b88-284ae283b715@web.de><br>Content-Type: text/plain; charset="utf-8"; Format="flowed"<br><br>Hi Michael,<br><br>I found another bug about the row size issue:<br><br>*Bug 28267*<br><https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267> -<br>Koha-common package upgrade problem from 20.05.xx to 20.11.04-1<br><br>I think filing a bug is always a good first step as we seem to run into<br>this issue more and more.<br><br>Katrin<br><br>On 12.07.21 21:29, Michael Kuhn wrote:<br>> Hi<br>><br>> Today I updated our host from Debian GNU/Linux 9 with Koha 19.11.00<br>> first to Debian GNU/Linux 10, then to Koha 21.05.01. When running<br>> "apt-get install koha-common" the process terminated showing the<br>> following messages:<br>><br>> ### BEGIN #########################<br>><br>> Upgrade to 19.12.00.052 done [18:30:04]: Bug 21443 - Add ability to<br>> exclude holidays when calculating rentals fees by time period<br>> {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Row size too<br>> large. The maximum row size for the used table type, not counting<br>> BLOBs, is 8126. This includes storage overhead, check the manual. You<br>> have to change some columns to TEXT or BLOBs [for Statement "ALTER<br>> TABLE borrowers ADD COLUMN autorenew_checkouts TINYINT(1) NOT NULL<br>> DEFAULT 1 AFTER anonymized"] at /usr/share/perl5/DBIx/Class/Schema.pm<br>> line 1118.<br>> DBIx::Class::Schema::throw_exception(Koha::Schema=HASH(0x30abec0),<br>> "DBI Exception: DBD::mysql::db do failed: Row size too large. "...)<br>> called at /usr/share/perl5/DBIx/Class/Storage.pm line 113<br>> DBIx::Class::Storage::throw_exception(DBIx::Class::Storage::DBI::mysql=HASH(0x3aa549c),<br>> "DBI Exception: DBD::mysql::db do failed: Row size too large. "...)<br>> called at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1501<br>> DBIx::Class::Storage::DBI::__ANON__("DBD::mysql::db do failed: Row<br>> size too large. The maximum row"..., DBI::db=HASH(0x3ee6314), undef)<br>> called at<br>> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl<br>> line 21313<br>><br>> dpkg: error processing package koha-common (--configure):<br>> installed koha-common package post-installation script subprocess<br>> returned error exit status 11<br>> Processing triggers for systemd (241-7~deb10u7) ...<br>> Errors were encountered while processing:<br>> koha-common<br>> E: Sub-process /usr/bin/dpkg returned an error code (1)<br>> Script done, file is /tmp/apt-get_install_koha-common_20210712.txt<br>><br>> ### END #########################<br>><br>> This looks a lot like<br>> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24986<br>> (Maximum row size reached soon for borrowers and deletedborrowers) or<br>> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267<br>> (Koha-common package upgrade problem from 20.05.xx to 20.11.04-1) but<br>> it's not exactly the same.<br>><br>> According to<br>> https://mariadb.com/kb/en/troubleshooting-row-size-too-large-errors-with-innodb/<br>> I ran the described script "rowsize.sh" which showed me the following<br>> 7 tables with row size too large.<br>><br>> aqbooksellers<br>> biblioitems<br>> borrower_modifications<br>> borrowers<br>> deletedbiblioitems<br>> deletedborrowers<br>> z3950servers<br>><br>> One solution seems to be to alter the row format of these tables from<br>> "Compact" to "Dynamic" so I did that for all seven tables.<br>><br>> ALTER TABLE aqbooksellers ROW_FORMAT=DYNAMIC;<br>> etc<br>><br>> After running "apt-get install koha-common" again, the process<br>> continued with<br>><br>> Upgrade to 19.12.00.053 done [19:19:28]: Bug 24476 - Allow patrons to<br>> opt-out of autorenewal<br>><br>> and ran to the end.<br>><br>> Upgrade to 21.05.01.003 done [19:19:38]: Koha 21.05.01 release<br>> Error: the selected language is already installed. Try --update if<br>> you want to re-install it.<br>> ERROR: an error was found when updating 'de-DE' translations. Please<br>> manually<br>> run 'koha-translate --update de-DE'. Run man koha-translate for more<br>> options.<br>><br>> Except of the error regarding the "selected language" which I have<br>> described in another e-mail to koha-devel, everything seems to work fine.<br>><br>> Still I'm asking myself if I should open another bug report about "Row<br>> size too large" since the problem does not to be solved by Bug 24986<br>> ("Pushed to master for 20.11") or the pending Bug 28267.<br>><br>> Also I'm not sure what consequences the changed row format "Dynamic"<br>> for these 7 tables might have.<br>><br>> Best wishes: Michael<br>> --<br>> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis<br>> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz<br>> T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch<br>> _______________________________________________<br>> Koha-devel mailing list<br>> Koha-devel@lists.koha-community.org<br>> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>> website : https://www.koha-community.org/<br>> git : https://git.koha-community.org/<br>> bugs : https://bugs.koha-community.org/<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20210725/968c4f64/attachment-0001.htm><br><br>------------------------------<br><br>Message: 2<br>Date: Sun, 25 Jul 2021 15:24:28 +0200<br>From: Michael Kuhn <mik@adminkuhn.ch><br>To: koha-devel@lists.koha-community.org<br>Subject: Re: [Koha-devel] Update from Koha 19.11 to 21.05 terminating<br> because "Row size too large"<br>Message-ID: <027b5124-c458-c726-6456-96ca4c0af1da@adminkuhn.ch><br>Content-Type: text/plain; charset=utf-8; format=flowed<br><br>Hi Katrin<br><br> > I found another bug about the row size issue:<br> ><br> > *Bug 28267*<br> > <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267> -<br> > Koha-common package upgrade problem from 20.05.xx to 20.11.04-1<br> ><br> > I think filing a bug is always a good first step as we seem to run<br> > into this issue more and more.<br><br>I mentioned that bug 28267 at the end of my message.<br><br>Best wishes: Michael<br>-- <br>Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis<br>Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz<br>T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch<br><br><br>> On 12.07.21 21:29, Michael Kuhn wrote:<br>>> Hi<br>>><br>>> Today I updated our host from Debian GNU/Linux 9 with Koha 19.11.00 <br>>> first to Debian GNU/Linux 10, then to Koha 21.05.01. When running <br>>> "apt-get install koha-common" the process terminated showing the <br>>> following messages:<br>>><br>>> ### BEGIN #########################<br>>><br>>> Upgrade to 19.12.00.052 done [18:30:04]: Bug 21443 - Add ability to <br>>> exclude holidays when calculating rentals fees by time period<br>>> {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Row size too <br>>> large. The maximum row size for the used table type, not counting <br>>> BLOBs, is 8126. This includes storage overhead, check the manual. You <br>>> have to change some columns to TEXT or BLOBs [for Statement "ALTER <br>>> TABLE borrowers ADD COLUMN autorenew_checkouts TINYINT(1) NOT NULL <br>>> DEFAULT 1 AFTER anonymized"] at /usr/share/perl5/DBIx/Class/Schema.pm <br>>> line 1118.<br>>> DBIx::Class::Schema::throw_exception(Koha::Schema=HASH(0x30abec0), <br>>> "DBI Exception: DBD::mysql::db do failed: Row size too large. "...) <br>>> called at /usr/share/perl5/DBIx/Class/Storage.pm line 113<br>>> DBIx::Class::Storage::throw_exception(DBIx::Class::Storage::DBI::mysql=HASH(0x3aa549c), <br>>> "DBI Exception: DBD::mysql::db do failed: Row size too large. "...) <br>>> called at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1501<br>>> DBIx::Class::Storage::DBI::__ANON__("DBD::mysql::db do failed: Row <br>>> size too large. The maximum row"..., DBI::db=HASH(0x3ee6314), undef) <br>>> called at <br>>> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line <br>>> 21313<br>>><br>>> dpkg: error processing package koha-common (--configure):<br>>> installed koha-common package post-installation script subprocess <br>>> returned error exit status 11<br>>> Processing triggers for systemd (241-7~deb10u7) ...<br>>> Errors were encountered while processing:<br>>> koha-common<br>>> E: Sub-process /usr/bin/dpkg returned an error code (1)<br>>> Script done, file is /tmp/apt-get_install_koha-common_20210712.txt<br>>><br>>> ### END #########################<br>>><br>>> This looks a lot like <br>>> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24986 <br>>> (Maximum row size reached soon for borrowers and deletedborrowers) or <br>>> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267 <br>>> (Koha-common package upgrade problem from 20.05.xx to 20.11.04-1) but <br>>> it's not exactly the same.<br>>><br>>> According to <br>>> https://mariadb.com/kb/en/troubleshooting-row-size-too-large-errors-with-innodb/ <br>>> I ran the described script "rowsize.sh" which showed me the following <br>>> 7 tables with row size too large.<br>>><br>>> aqbooksellers<br>>> biblioitems<br>>> borrower_modifications<br>>> borrowers<br>>> deletedbiblioitems<br>>> deletedborrowers<br>>> z3950servers<br>>><br>>> One solution seems to be to alter the row format of these tables from <br>>> "Compact" to "Dynamic" so I did that for all seven tables.<br>>><br>>> ALTER TABLE aqbooksellers ROW_FORMAT=DYNAMIC;<br>>> etc<br>>><br>>> After running "apt-get install koha-common" again, the process <br>>> continued with<br>>><br>>> Upgrade to 19.12.00.053 done [19:19:28]: Bug 24476 - Allow patrons to <br>>> opt-out of autorenewal<br>>><br>>> and ran to the end.<br>>><br>>> Upgrade to 21.05.01.003 done [19:19:38]: Koha 21.05.01 release<br>>> Error: the selected language is already installed. Try --update if <br>>> you want to re-install it.<br>>> ERROR: an error was found when updating 'de-DE' translations. Please <br>>> manually<br>>> run 'koha-translate --update de-DE'. Run man koha-translate for more <br>>> options.<br>>><br>>> Except of the error regarding the "selected language" which I have <br>>> described in another e-mail to koha-devel, everything seems to work fine.<br>>><br>>> Still I'm asking myself if I should open another bug report about "Row <br>>> size too large" since the problem does not to be solved by Bug 24986 <br>>> ("Pushed to master for 20.11") or the pending Bug 28267.<br>>><br>>> Also I'm not sure what consequences the changed row format "Dynamic" <br>>> for these 7 tables might have.<br>>><br>>> Best wishes: Michael<br>>> -- <br>>> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis<br>>> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz<br>>> T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch<br>>> _______________________________________________<br>>> Koha-devel mailing list<br>>> Koha-devel@lists.koha-community.org<br>>> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>>> website : https://www.koha-community.org/<br>>> git : https://git.koha-community.org/<br>>> bugs : https://bugs.koha-community.org/<br><br><br><br><br>------------------------------<br><br>Subject: Digest Footer<br><br>_______________________________________________<br>Koha-devel mailing list<br>Koha-devel@lists.koha-community.org<br>https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>website : https://www.koha-community.org/<br>git : https://git.koha-community.org/<br>bugs : https://bugs.koha-community.org/<br><br><br>------------------------------<br><br>End of Koha-devel Digest, Vol 188, Issue 15<br>*******************************************<br></div><br><br>NOTE: You are receiving this mail because, the Requester/Technician wanted you to get notified on this request creation.<br></body></html>