[Koha-devel] International Confrence KohaCon 2021
FullStack Solutions
libsolisb at gmail.com
Wed Jul 28 02:28:37 CEST 2021
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 at lists.koha-community.org wrote:
>
> Send Koha-devel mailing list submissions to
> koha-devel at 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 at lists.koha-community.org
>
> You can reach the person managing the list at
> koha-devel-owner at 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 at web.de>
> To: koha-devel at 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 at 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 at adminkuhn.ch · W www.adminkuhn.ch
>> _______________________________________________
>> Koha-devel mailing list
>> Koha-devel at 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 at adminkuhn.ch>
> To: koha-devel at 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 at 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 at 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 at adminkuhn.ch · W www.adminkuhn.ch
>>> _______________________________________________
>>> Koha-devel mailing list
>>> Koha-devel at 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 at 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
> *******************************************
More information about the Koha-devel
mailing list