Summary: | Error in database update 21.12.00.048 | ||
---|---|---|---|
Product: | Koha | Reporter: | victor <vbovictor> |
Component: | Architecture, internals, and plumbing | Assignee: | Bugs List <koha-bugs> |
Status: | CLOSED INVALID | QA Contact: | Testopia <testopia> |
Severity: | critical | ||
Priority: | P5 - low | CC: | fridolin.somers, jonathan.druart, nick |
Version: | 22.05 | ||
Hardware: | All | ||
OS: | All | ||
Change sponsored?: | --- | Patch complexity: | --- |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: | ||
Circulation function: | |||
Bug Depends on: | 30291 | ||
Bug Blocks: |
Description
victor
2022-06-10 23:29:30 UTC
From which version did you update from? (In reply to Katrin Fischer from comment #1) > From which version did you update from? Ubuntu 20.04.4 LTS mysql Ver 15.1 Distrib 10.4.14-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 Koha 22.05 (In reply to victor from comment #2) > (In reply to Katrin Fischer from comment #1) > > From which version did you update from? > > Ubuntu 20.04.4 LTS > > mysql Ver 15.1 Distrib 10.4.14-MariaDB, for debian-linux-gnu (x86_64) using > readline 5.2 > > Koha 22.05 Koha 21.11 upgrade to 22.05 In addition to presenting an error when trying to restart the bases. Upgrade to 21.12.00.048 [20:27:10]: Bug 30291 - Renaming recalls table columns ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot drop index 'borrowernumber': needed in a foreign key constraint at /usr/share/koha/lib/C4/Installer.pm line 739 The interfaces are returning to the installation screen. https://mydomain/cgi-bin/koha/installer/install.pl?step=1&op=updatestructure In Ubuntu 20.04.4 LTS mysql Ver 15.1 Distrib 10.4.14-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 Koha 22.05 Installation with multiple instances apparent solution mysql >USE database; mysql >SET foreign_key_checks = 0; mysql > ALTER TABLE recalls CHANGE COLUMN borrowernumber patron_id int(11) NOT NULL DEFAULT 0; Cannot recreate on 10.5.16-MariaDB-1 Cannot recreate on Server version: 5.5.5-10.4.25-MariaDB-1:10.4.25+maria~focal mariadb.org binary distribution (In reply to Jonathan Druart from comment #6) > Cannot recreate on 10.5.16-MariaDB-1 Sorry but I did not understand, There's no solution for the version of the bank I'm using? (In reply to victor from comment #4) > > In Ubuntu 20.04.4 LTS > > mysql Ver 15.1 Distrib 10.4.14-MariaDB, for debian-linux-gnu (x86_64) using > readline 5.2 > Hi, We have servers with Ubuntu 20.04 Focal and MariaDB 10.4. Can't reproduce. I see Ubuntu package is on MariaDB 10.3 : https://packages.ubuntu.com/search?suite=focal-updates&searchon=names&keywords=mariadb-server We install mariaDB with its repo : deb [arch=amd64,arm64] https://downloads.mariadb.com/MariaDB/mariadb-10.4/repo/ubuntu focal main And we hace 10.4.25-MariaDB. How did you install MariaDB ? 10.4.14 is quite late. (In reply to Fridolin Somers from comment #10) > (In reply to victor from comment #4) > > > > In Ubuntu 20.04.4 LTS > > > > mysql Ver 15.1 Distrib 10.4.14-MariaDB, for debian-linux-gnu (x86_64) using > > readline 5.2 > > > > Hi, > > We have servers with Ubuntu 20.04 Focal and MariaDB 10.4. > Can't reproduce. > > I see Ubuntu package is on MariaDB 10.3 : > https://packages.ubuntu.com/search?suite=focal- > updates&searchon=names&keywords=mariadb-server > > We install mariaDB with its repo : > deb [arch=amd64,arm64] > https://downloads.mariadb.com/MariaDB/mariadb-10.4/repo/ubuntu focal main > And we hace 10.4.25-MariaDB. > > How did you install MariaDB ? 10.4.14 is quite late. So should I upgrade to version 10.4.25-MariaDB? Could this cause any problems with koha installations? And that should solve my problem? (In reply to victor from comment #11) > (In reply to Fridolin Somers from comment #10) > > (In reply to victor from comment #4) > > > > > > In Ubuntu 20.04.4 LTS > > > > > > mysql Ver 15.1 Distrib 10.4.14-MariaDB, for debian-linux-gnu (x86_64) using > > > readline 5.2 > > > > > > > Hi, > > > > We have servers with Ubuntu 20.04 Focal and MariaDB 10.4. > > Can't reproduce. > > > > I see Ubuntu package is on MariaDB 10.3 : > > https://packages.ubuntu.com/search?suite=focal- > > updates&searchon=names&keywords=mariadb-server > > > > We install mariaDB with its repo : > > deb [arch=amd64,arm64] > > https://downloads.mariadb.com/MariaDB/mariadb-10.4/repo/ubuntu focal main > > And we hace 10.4.25-MariaDB. > > > > How did you install MariaDB ? 10.4.14 is quite late. > > Install with sudo apt install mariadb-server Not really I believe it is not in the repo (In reply to victor from comment #12) > (In reply to victor from comment #11) > > (In reply to Fridolin Somers from comment #10) > > > (In reply to victor from comment #4) > > > > > > > > In Ubuntu 20.04.4 LTS > > > > > > > > mysql Ver 15.1 Distrib 10.4.14-MariaDB, for debian-linux-gnu (x86_64) using > > > > readline 5.2 > > > > > > > > > > Hi, > > > > > > We have servers with Ubuntu 20.04 Focal and MariaDB 10.4. > > > Can't reproduce. > > > > > > I see Ubuntu package is on MariaDB 10.3 : > > > https://packages.ubuntu.com/search?suite=focal- > > > updates&searchon=names&keywords=mariadb-server > > > > > > We install mariaDB with its repo : > > > deb [arch=amd64,arm64] > > > https://downloads.mariadb.com/MariaDB/mariadb-10.4/repo/ubuntu focal main > > > And we hace 10.4.25-MariaDB. > > > > > > How did you install MariaDB ? 10.4.14 is quite late. > > > > Install with sudo apt install mariadb-server > Not really I believe it is not in the repo Does koha 22.05 with Ubuntu 20.04 and 10.4.25-MariaDB work correctly? (In reply to victor from comment #11) > > So should I upgrade to version 10.4.25-MariaDB? > Could this cause any problems with koha installations? > And that should solve my problem? I hope so. What says : apt-cache policy mariadb-server Update your system and it should fix the problem. |