root@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@dev-bib:
rabbitmq_stomp
The following plugins have been configured:
rabbitmq_stomp
Applying plugin configuration to rabbit@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@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@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@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
[email protected]
Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
