[Bug 30946] New: Error koha-upgrade-schema
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30946 Bug ID: 30946 Summary: Error koha-upgrade-schema Change sponsored?: --- Product: Koha Version: 22.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs@lists.koha-community.org Reporter: vbovictor@gmail.com QA Contact: testopia@bugs.koha-community.org $koha-upgrade-schema library Upgrading database schema for bibliotecateste 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 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30946 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|enhancement |critical Summary|Error koha-upgrade-schema |Error in database update | |21.12.00.048 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30946 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |30291 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30291 [Bug 30291] Rename recalls.* column names -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30946 --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> ---
From which version did you update from?
-- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30946 --- Comment #2 from victor <vbovictor@gmail.com> --- (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 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30946 --- Comment #3 from victor <vbovictor@gmail.com> --- (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 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30946 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=29333 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30946 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also|https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=29333 | -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30946 --- Comment #4 from victor <vbovictor@gmail.com> --- 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 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30946 --- Comment #5 from victor <vbovictor@gmail.com> --- 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; -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30946 Jonathan Druart <jonathan.druart+koha@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart+koha@gmail. | |com --- Comment #6 from Jonathan Druart <jonathan.druart+koha@gmail.com> --- Cannot recreate on 10.5.16-MariaDB-1 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30946 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |nick@bywatersolutions.com --- Comment #7 from Nick Clemens <nick@bywatersolutions.com> --- Cannot recreate on Server version: 5.5.5-10.4.25-MariaDB-1:10.4.25+maria~focal mariadb.org binary distribution -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30946 --- Comment #8 from Nick Clemens <nick@bywatersolutions.com> --- https://jira.mariadb.org/browse/MDEV-22775 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30946 --- Comment #9 from victor <vbovictor@gmail.com> --- (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? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30946 Fridolin Somers <fridolin.somers@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |fridolin.somers@biblibre.co | |m --- Comment #10 from Fridolin Somers <fridolin.somers@biblibre.com> --- (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. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30946 --- Comment #11 from victor <vbovictor@gmail.com> --- (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? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30946 --- Comment #12 from victor <vbovictor@gmail.com> --- (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
-- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30946 --- Comment #13 from victor <vbovictor@gmail.com> --- (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? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30946 --- Comment #14 from Fridolin Somers <fridolin.somers@biblibre.com> --- (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 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30946 Jonathan Druart <jonathan.druart+koha@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |INVALID --- Comment #15 from Jonathan Druart <jonathan.druart+koha@gmail.com> --- Update your system and it should fix the problem. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org