A new request with request id 16911 has been created by koha-devel-request@lists.koha-community.org. Short info on the request is :
Title : Koha-devel Digest, Vol 188, Issue 15
Category :
Description : 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-innodb/
> 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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20210725/968c4f64/attachment-0001.htm>
------------------------------
Message: 2
Date: Sun, 25 Jul 2021 15:24:28 +0200
From: Michael Kuhn <mik@adminkuhn.ch>
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: <027b5124-c458-c726-6456-96ca4c0af1da@adminkuhn.ch>
Content-Type: text/plain; charset=utf-8; format=flowed
Hi Katrin
> 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.
I mentioned that bug 28267 at the end of my message.
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
> 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-innodb/
>> 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/
------------------------------
Subject: Digest Footer
_______________________________________________
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/
------------------------------
End of Koha-devel Digest, Vol 188, Issue 15
*******************************************
NOTE: You are receiving this mail because, the Requester/Technician wanted you to get notified on this request creation.