[Koha] Error in Koha 22.05?

Tue Jul 5 23:10:07 NZST 2022

root at dev-bib:~# apt upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
The following packages were automatically installed and are no longer 
required:
   libcrypt-openssl-bignum-perl libcrypt-openssl-random-perl 
libcrypt-openssl-rsa-perl libdata-validate-domain-perl 
libdata-validate-ip-perl libdbd-sqlite2-perl libmath-base85-perl
   libnet-domain-tld-perl libnet-ipv6addr-perl libnetaddr-ip-perl 
libnetwork-ipv4addr-perl libtext-markdown-perl
Use 'apt autoremove' to remove them.
The following NEW packages will be installed:
   libauth-googleauth-perl libconvert-base32-perl libcrypt-cbc-perl 
libcrypt-rijndael-perl libdbd-sqlite3-perl libio-socket-ip-perl 
libmath-random-mt-perl
The following packages have been kept back:
   libmojolicious-perl
The following packages will be upgraded:
   koha-common libjson-validator-perl libmojo-jwt-perl 
libmojolicious-plugin-openapi-perl libtemplate-plugin-gettext-perl
5 upgraded, 7 newly installed, 0 to remove and 1 not upgraded.
Need to get 46.1 MB of archives.
After this operation, 17.0 MB of additional disk space will be used.
Do you want to continue? [Y/n] Y
Get:1 http://archive.ubuntu.com/ubuntu focal/universe amd64 
libconvert-base32-perl all 0.06-1 [6546 B]
Get:2 http://archive.ubuntu.com/ubuntu focal/universe amd64 
libmath-random-mt-perl amd64 1.17-1build5 [13.1 kB]
Get:3 http://archive.ubuntu.com/ubuntu focal/universe amd64 
libcrypt-rijndael-perl amd64 1.14-1build1 [17.3 kB]
Get:4 http://archive.ubuntu.com/ubuntu focal/universe amd64 
libcrypt-cbc-perl all 2.33-2 [23.5 kB]
Get:5 http://archive.ubuntu.com/ubuntu focal/universe amd64 
libdbd-sqlite3-perl amd64 1.64-1build1 [154 kB]
Get:6 http://debian.koha-community.org/koha 22.05/main amd64 
libauth-googleauth-perl all 1.03-1 [13.1 kB]
Get:7 http://debian.koha-community.org/koha 22.05/main amd64 
libjson-validator-perl all 5.99+really5.08-koha1 [98.2 kB]
Get:8 http://debian.koha-community.org/koha 22.05/main amd64 
libmojo-jwt-perl all 0.09-1-koha1 [12.1 kB]
Get:9 http://debian.koha-community.org/koha 22.05/main amd64 
libmojolicious-plugin-openapi-perl all 5.99+really5.05-koha1 [67.4 kB]
Get:10 http://debian.koha-community.org/koha 22.05/main amd64 
libtemplate-plugin-gettext-perl all 0.6-1~koha2 [22.8 kB]
Get:11 http://debian.koha-community.org/koha 22.05/main amd64 
koha-common all 22.05.02-1 [45.6 MB]
Get:12 http://debian.koha-community.org/koha 22.05/main amd64 
libio-socket-ip-perl all 0.41-1 [30.5 kB]
Fetched 46.1 MB in 1min 59s (386 kB/s)
Preconfiguring packages ...
Selecting previously unselected package libconvert-base32-perl.
(Reading database ... 92638 files and directories currently installed.)
Preparing to unpack .../00-libconvert-base32-perl_0.06-1_all.deb ...
Unpacking libconvert-base32-perl (0.06-1) ...
Selecting previously unselected package libmath-random-mt-perl.
Preparing to unpack .../01-libmath-random-mt-perl_1.17-1build5_amd64.deb ...
Unpacking libmath-random-mt-perl (1.17-1build5) ...
Selecting previously unselected package libauth-googleauth-perl.
Preparing to unpack .../02-libauth-googleauth-perl_1.03-1_all.deb ...
Unpacking libauth-googleauth-perl (1.03-1) ...
Selecting previously unselected package libcrypt-rijndael-perl.
Preparing to unpack .../03-libcrypt-rijndael-perl_1.14-1build1_amd64.deb ...
Unpacking libcrypt-rijndael-perl (1.14-1build1) ...
Selecting previously unselected package libcrypt-cbc-perl.
Preparing to unpack .../04-libcrypt-cbc-perl_2.33-2_all.deb ...
Unpacking libcrypt-cbc-perl (2.33-2) ...
Selecting previously unselected package libdbd-sqlite3-perl:amd64.
Preparing to unpack .../05-libdbd-sqlite3-perl_1.64-1build1_amd64.deb ...
Unpacking libdbd-sqlite3-perl:amd64 (1.64-1build1) ...
Preparing to unpack 
.../06-libjson-validator-perl_5.99+really5.08-koha1_all.deb ...
Unpacking libjson-validator-perl (5.99+really5.08-koha1) over 
(5.99+really3.14-koha1) ...
Preparing to unpack .../07-libmojo-jwt-perl_0.09-1-koha1_all.deb ...
Unpacking libmojo-jwt-perl (0.09-1-koha1) over (0.08-1) ...
Preparing to unpack 
.../08-libmojolicious-plugin-openapi-perl_5.99+really5.05-koha1_all.deb ...
Unpacking libmojolicious-plugin-openapi-perl (5.99+really5.05-koha1) 
over (5.99+really2.16-koha1) ...
Preparing to unpack 
.../09-libtemplate-plugin-gettext-perl_0.6-1~koha2_all.deb ...
Unpacking libtemplate-plugin-gettext-perl (0.6-1~koha2) over 
(0.6-1~koha1) ...
Preparing to unpack .../10-koha-common_22.05.02-1_all.deb ...
Unpacking koha-common (22.05.02-1) over (21.11.09-3) ...
Selecting previously unselected package libio-socket-ip-perl.
Preparing to unpack .../11-libio-socket-ip-perl_0.41-1_all.deb ...
Unpacking libio-socket-ip-perl (0.41-1) ...
Setting up libio-socket-ip-perl (0.41-1) ...
Setting up libcrypt-rijndael-perl (1.14-1build1) ...
Setting up libjson-validator-perl (5.99+really5.08-koha1) ...
Setting up libmath-random-mt-perl (1.17-1build5) ...
Setting up libcrypt-cbc-perl (2.33-2) ...
Setting up libmojolicious-plugin-openapi-perl (5.99+really5.05-koha1) ...
Setting up libdbd-sqlite3-perl:amd64 (1.64-1build1) ...
Setting up libtemplate-plugin-gettext-perl (0.6-1~koha2) ...
Setting up libmojo-jwt-perl (0.09-1-koha1) ...
Setting up libconvert-base32-perl (0.06-1) ...
Setting up libauth-googleauth-perl (1.03-1) ...
Setting up koha-common (22.05.02-1) ...
Installing new version of config file /etc/cron.daily/koha-common ...
Installing new version of config file /etc/init.d/koha-common ...
Installing new version of config file /etc/koha/SIPconfig.xml ...
Installing new version of config file /etc/koha/koha-conf-site.xml.in ...
Installing new version of config file 
/etc/koha/zebradb/marc_defs/marc21/biblios/biblio-zebra-indexdefs.xsl ...
Upgrading database schema for dev-bib
Upgrade to 21.12.00.000  [07:52:52]: Increase DBRev for 21.12
     📜 All that is gold does not glitter,
     📜 Not all those who wander are lost;
     📜 The old that is strong does not wither,
     📜 Deep roots are not reached by the frost.
Upgrade to 21.12.00.001  [07:52:52]: Bug 29586 - Add Hold Reminder 
messaging preference if missing
Upgrade to 21.12.00.002  [07:52:53]: Bug 13188 - Allow configuration of 
required fields when a patron is editing their information via the OPAC
     Added new system preference 'PatronSelfModificationMandatoryField' 
with value ''
Upgrade to 21.12.00.003  [07:52:53]: Bug 29457 - Fee Cancellation 
records the wrong manager_id
     WARNING: You may have some incorrect manager_id's recorded against 
account cancellation lines, please see bugzilla for details.
     NOTE: You may already have this bugfix applied at an earlier upgrade.
Upgrade to 21.12.00.004  [07:52:53]: Bug 26296 - Replace comma with pipe 
in OPACSuggestion field preferences
Upgrade to 21.12.00.005  [07:52:53]: Bug 29778 - Delete orphan 
additional contents
Upgrade to 21.12.00.006  [07:52:53]: Bug 29557 - Add 
auto_account_expired to AUTO_RENEWALS notice
     Please update your AUTO_RENEWALS notice manually if you have 
changed or translated it
Upgrade to 21.12.00.007  [07:52:53]: Bug 20076 - Add system preference 
EmailOverduesNoEmail
Upgrade to 21.12.00.008  [07:52:53]: Bug 29495 - Drop issue_id 
constraint from return_claims table
Upgrade to 21.12.00.009  [07:52:54]: Bug 29336 - Resize authorised value 
category fields to 32 chars
Upgrade to 21.12.00.010  [07:52:55]: Bug 21729 - Add new column 
reserves.patron_expiration_date
Upgrade to 21.12.00.011  [07:52:55]: Bug 27946 - Add article request fees
Upgrade to 21.12.00.012  [07:52:55]: Bug 24220 - Move OpacMoreSearches 
to additional contents
     No OpacMoreSearches preference found. Value was empty or update has 
already been run.
Upgrade to 21.12.00.013  [07:52:56]: Bug 29605 - Resync DB structure for 
existing installations
     Ensure NOT NULL on account_offsets.type
     Ensure additional_contents.code is VARCHAR(100)
     Ensure additional_contents.lang is VARCHAR(50)
     Ensure NOT NULL on search_marc_map.marc_type
     Ensure branchtransfers.cancellation_reason enum values are uppercase
Upgrade to 21.12.00.014  [07:52:56]: Bug 29596 - Add Yiddish language
Upgrade to 21.12.00.015  [07:52:56]: Bug 29943 - Fix typo in 
NOTIFY_MANAGER notice
Upgrade to 21.12.00.016  [07:52:58]: Bug 30060 - Update user_permissions 
to add primary key and remove null option from code column
     Removed any duplicate rows
     Added a primary key on user_permissions on borrowernumber, 
module_bit, code
Upgrade to 21.12.00.017  [07:52:58]: Bug 30128 - Change 
language_subtag_registry.description to varchar(255)
Upgrade to 21.12.00.018  [07:52:58]: Bug 19532 - Add Recalls
Upgrade to 21.12.00.019  [07:52:58]: Bug 27812 - Remove the ability to 
transmit a patron's plain text password over email
     The notice template ACCTDETAILS no longer has access to the 
patron's plain text password. Please update the language of your 
ACCTDETAILS as needed.
Upgrade to 21.12.00.020  [07:52:58]: Bug 24221 - Move OpacMySummaryNote 
to additional contents
     No OpacMySummaryNote preference found. Value was empty or update 
has already been run.
Upgrade to 21.12.00.021  [07:52:58]: Bug 30063 - Fix 
DefaultPatronSearchFields order
Upgrade to 21.12.00.022  [07:52:58]: Bug 11083 - Add syspref 
AuthorityXSLTResultsDisplay
Upgrade to 21.12.00.023  [07:52:58]: Bug 20517 - Add SIP2SortBinMapping 
system preference
Upgrade to 21.12.00.024  [07:52:58]: Bug 20398 - Add system preference 
StaffHighlightedWords
Upgrade to 21.12.00.025  [07:52:58]: Bug 29990 - Add new system 
preference ShowHeadingUse
Upgrade to 21.12.00.026  [07:52:58]: Bug 17018 - Split 
AdvancedSearchTypes for staff and OPAC
Upgrade to 21.12.00.027  [07:52:59]: Bug 26346 - Add 
allow_change_from_staff to virtualshelves table
Upgrade to 21.12.00.028  [07:52:59]: Bug 16258 - A preference to 
enabled/disable edifact
Upgrade to 21.12.00.029  [07:52:59]: Bug 30130 - A standard to edi_account
Upgrade to 21.12.00.030  [07:52:59]: Bug 30135 - Add EdifactLSQ mapping 
system preference
Upgrade to 21.12.00.031  [07:52:59]: Bug 30481 - DB schema sync for 
deleteditems
Upgrade to 21.12.00.032  [07:52:59]: Bug 30498 - Correct enum 
search_field.type
Upgrade to 21.12.00.033  [07:52:59]: Bug 27783 - Add background_jobs.queue
     Added background_jobs.queue
Upgrade to 21.12.00.034  [07:52:59]: Bug 30237 - Replace ACCDETAILS 
notice with WELCOME notice
Upgrade to 21.12.00.035  [07:52:59]: Bug 30226 - Add the system 
preference AllowSetAutomaticRenewal
Upgrade to 21.12.00.036  [07:53:00]: Bug 28786 - Add syspref 
TwoFactorAuthentication, fields secret and auth_method
Upgrade to 21.12.00.037  [07:53:00]: Bug 27253 - Fix definition of 
borrowers.updated_on and deletedborrowers.updated_on
     Updated all NULL values of borrowers.updated_on to 
GREATEST(date_renewed, dateenrolled, lastseen): 0 rows updated
     Updated all NULL values of borrowers.updated_on to 
GREATEST(date_renewed, dateenrolled, lastseen): 0 rows updated
     Fixed definition of borrowers.updated_on
     Fixed definition of deletedborrowers.updated_on
Upgrade to 21.12.00.038  [07:53:00]: Bug 29648 - Move NumSavedReports to 
table settings and allow tables_settings.default_display_length to be NULL
     NumSavedReports value '20' moved to table settings
Upgrade to 21.12.00.039  [07:53:00]: Bug 29092 - Add timestamp to 
account-fines table column settings
Upgrade to 21.12.00.040  [07:53:00]: Bug 30565 - Update table 
stockrotationrotas
Upgrade to 21.12.00.041  [07:53:00]: Bug 30449 - Check 
borrower_attribute_types FK constraint
Upgrade to 21.12.00.042  [07:53:00]: Bug 30572 - Adjust 
search_marc_to_field.sort
Upgrade to 21.12.00.043  [07:53:00]: Bug 30108 - Add preference 
OPACMandatoryHoldDates
Upgrade to 21.12.00.044  [07:53:00]: Bug 29894 - Add 2FA (de)enabling 
notices
Upgrade to 21.12.00.045  [07:53:00]: Bug 14242 - Add 
OPACSuggestionAutoFill system preference
Upgrade to 21.12.00.046  [07:53:00]: Bug 22785 - Add chosen column to 
import_record_matches
     chosen column added to import_record_matches
Upgrade to 21.12.00.047  [07:53:00]: Bug 28138 - Add system preference 
RequirePaymentType
Upgrade to 21.12.00.048  [07:53:01]: Bug 30291 - Renaming recalls table 
columns
Upgrade to 21.12.00.049  [07:53:01]: Bug 30563 - Add system preference 
RequireCashRegister
Upgrade to 21.12.00.050  [07:53:01]: Bug 29924 - Add password expiration
     Added password_expiry_days to categories
     Added password_expiration_date field to borrowers
     Added password_expiration_date field to borrowers
Upgrade to 21.12.00.051  [07:53:01]: Bug 29925 - Add password reset option
Upgrade to 21.12.00.052  [07:53:01]: Bug 30290 - Modify AR notices, 
include TOC line
Upgrade to 21.12.00.053  [07:53:01]: Bug 30611 - Add 
STAFF_PASSWORD_RESET notice
Upgrade to 21.12.00.054  [07:53:02]: Bug 23352 - Adding new column 
'subscription.ccode'
Upgrade to 21.12.00.055  [07:53:02]: Bug 13412 - Add 
GenerateAuthorityField667 and GenerateAuthorityField670 system preferences
Upgrade to 21.12.00.056  [07:53:02]: Bug 30728 - Allow opting out of 
real-time holds queue updating possible
Upgrade to 21.12.00.057  [07:53:02]: Bug 30852 - Add index to 
article_requests.debit_id
Upgrade to 22.05.00.000  [07:53:02]: Koha 22.05.00 release
Upgrade to 22.05.00.001  [07:53:02]: Bug 23659 - Add 
DefaultHoldPickupLocation syspref
     Added DefaultHoldPickupLocation syspref
Upgrade to 22.05.02.000  [07:53:02]: Koha 22.05.02 release
DEV atomic update 
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/bug_30899.pl 
[07:53:02]: Bug 30899 - Check borrower_attribute_types FK constraint 
(30449 follow-up)

Connection to the memcached servers '__MEMCACHED_SERVERS__' failed. Are 
the unix socket permissions set properly? Is the host reachable?
If you ignore this warning, you will face performance issues
Updated the es-ES translations.
Enabling plugins on node rabbit at dev-bib:
rabbitmq_stomp
The following plugins have been configured:
   rabbitmq_stomp
Applying plugin configuration to rabbit at dev-bib...
Plugin configuration unchanged.
Failed to enable unit: Unit 
/run/systemd/generator.late/koha-common.service is transient or generated.
Processing triggers for man-db (2.9.1-1) ...
Processing triggers for systemd (245.4-4ubuntu3.17) ...

=============================================

root at dev-bib:~# mysqlcheck -p koha_test borrowers
Enter password:
koha_test.borrowers
Warning  : InnoDB: The B-tree of index PRIMARY is corrupted.
Warning  : InnoDB: Index 'cardnumber' contains 1594 entries, should be 
18446744073709551615.
Warning  : InnoDB: Index 'userid' contains 1594 entries, should be 
18446744073709551615.
Warning  : InnoDB: Index 'categorycode' contains 1594 entries, should be 
18446744073709551615.
Warning  : InnoDB: Index 'branchcode' contains 1594 entries, should be 
18446744073709551615.
Warning  : InnoDB: Index 'surname_idx' contains 1594 entries, should be 
18446744073709551615.
Warning  : InnoDB: Index 'firstname_idx' contains 1594 entries, should 
be 18446744073709551615.
Warning  : InnoDB: Index 'othernames_idx' contains 1594 entries, should 
be 18446744073709551615.
Warning  : InnoDB: Index 'sms_provider_id' contains 1594 entries, should 
be 18446744073709551615.
error    : Corrupt
root at dev-bib:~# mysqlcheck -p koha_test deletedborrowers
Enter password:
koha_test.deletedborrowers
Warning  : InnoDB: The B-tree of index GEN_CLUST_INDEX is corrupted.
Warning  : InnoDB: Index 'borrowernumber' contains 200 entries, should 
be 18446744073709551615.
Warning  : InnoDB: Index 'cardnumber' contains 200 entries, should be 
18446744073709551615.
Warning  : InnoDB: Index 'sms_provider_id' contains 200 entries, should 
be 18446744073709551615.
error    : Corrupt
root at dev-bib:~#

Fernando A. Martinez

On 5/7/22 08:04, Fernando A. Martinez wrote:
> Hi,
>
> The update completes without errors (log attached). Then I can't log 
> into the system. (mysqlcheck log attached) Regards
>
> Fernando A. Martinez
>
> On 5/7/22 07:33, Katrin Fischer wrote:
>> Hi,
>>
>> could you please post more information about the issue? What error
>> message are you seeing? Can you access the tables with SQL?
>>
>> Is this the error maybe: DBI Exception: DBD::mysql::db do failed: Row
>> size too large.
>>
>> Then have a look at: *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
>>
>> Hope this helps,
>>
>> Katrin
>>
>> On 05.07.22 12:21, Fernando A. Martinez wrote:
>>> Hi,
>>>
>>> I have the same problem. Corrupted tables: borrowers and
>>> deletedborrowers. Update: Koha 22.05.02 over Koha 21.11.09 Ubuntu
>>> 20.04 LTS MySQL version 8.0.29
>>>
>>> Regards
>>>
>>> Fernando A. Martinez
>>>
>>> On 5/7/22 04:35, Dr. Eberhard Pietzsch wrote:
>>>> Hello,
>>>>
>>>> I would like to point out a bug in Koha after the update to 22.05.
>>>>
>>>> Koha is also included in the package management of Ubuntu 22.04 LTS
>>>> and can be updated together with Ubuntu. I had skipped the short time
>>>> preceding Koha update because of errors. However, the current update
>>>> to 22.05 apparently also contains bugs:
>>>>
>>>> The structure of the borrowers table seems to have been changed
>>>> compared to previous versions. Existing user data are not correctly
>>>> loaded into the new structured table with the update, so that no
>>>> login, e.g. as superlibrarian, is possible anymore.
>>>>
>>>> Possibly this phenomenon is caused by the skipped update to the
>>>> previous version?
>>>>
>>>> Many greetings
>>>> Eberhard Pietzsch
>>>> _______________________________________________
>>>>
>>>> Koha mailing listhttp://koha-community.org
>>>> Koha at lists.katipo.co.nz
>>>> Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
>>> _______________________________________________
>>>
>>> Koha mailing list http://koha-community.org
>>> Koha at lists.katipo.co.nz
>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>> _______________________________________________
>>
>> Koha mailing list http://koha-community.org
>> Koha at lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha