[Bug 28301] New: Add ability to force re-run of a particular DB update
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28301 Bug ID: 28301 Summary: Add ability to force re-run of a particular DB update Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Installation and upgrade (command-line installer) Assignee: koha-bugs@lists.koha-community.org Reporter: nick@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org When there are errors in the updates it would be nice to have a way to execute a single DB update easily -- 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=28301 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch complexity|--- |Trivial patch Status|NEW |Needs Signoff -- 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=28301 --- Comment #1 from Nick Clemens <nick@bywatersolutions.com> --- Created attachment 120689 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=120689&action=edit Bug 28301: Add forced run of particular DB update This patch adds a --forcedversion option to the updatedatabase script in order to allow testing of a particular update To test: 1 - Apply patch 2 - Pick a DB update that will fail if rerun 3 - perl /kohadevbox/koha/installer/data/mysql/updatedatabase.pl --forcedversion="3.21.00.041" 4 - Confirm it ran, you should get an error :-) 5 - Check the version system preference, confirm it is unchanged SELECT value FROM systempreference WHERE variable='Version'; -- 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=28301 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart+koha@gmail. | |com Assignee|koha-bugs@lists.koha-commun |nick@bywatersolutions.com |ity.org | -- 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=28301 --- Comment #2 from Jonathan Druart <jonathan.druart+koha@gmail.com> --- Can you rebase it on top of bug 25078 please? If it can wait I can do it when it's pushed to master. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28301 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook@prosentient.com.au -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28301 Fridolin Somers <fridolin.somers@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |fridolin.somers@biblibre.co | |m --- Comment #3 from Fridolin Somers <fridolin.somers@biblibre.com> --- Very interesting. Needs rewrite since bug 25078 right ? -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28301 --- Comment #4 from Jonathan Druart <jonathan.druart+koha@gmail.com> --- I think it's actually no longer needed with bug 25078. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28301 --- Comment #5 from Fridolin Somers <fridolin.somers@biblibre.com> --- (In reply to Jonathan Druart from comment #4)
I think it's actually no longer needed with bug 25078.
But how do you run a particular DBRev perl file ? -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28301 --- Comment #6 from Jonathan Druart <jonathan.druart+koha@gmail.com> --- (In reply to Fridolin Somers from comment #5)
(In reply to Jonathan Druart from comment #4)
I think it's actually no longer needed with bug 25078.
But how do you run a particular DBRev perl file ?
What would be the use case? Now the update process stops when an error happens. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28301 --- Comment #7 from Fridolin Somers <fridolin.somers@biblibre.com> --- For example checking that it can be run several times. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28301 --- Comment #8 from Jonathan Druart <jonathan.druart+koha@gmail.com> --- (In reply to Fridolin Somers from comment #7)
For example checking that it can be run several times.
It should be done when it's still an atomic update :) Once it's in dbrev, such test should have been done already. I am not against the idea, but I don't understand what it will bring us. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28301 --- Comment #9 from Fridolin Somers <fridolin.somers@biblibre.com> --- (In reply to Jonathan Druart from comment #8)
It should be done when it's still an atomic update :) Ahhhh correct
-- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28301 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |david@davidnind.com --- Comment #10 from David Nind <david@davidnind.com> --- Is this bug still relevant (from the comments)? If it is, I will have a go at testing... -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28301 Jonathan Druart <jonathan.druart+koha@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |RESOLVED Resolution|--- |INVALID --- Comment #11 from Jonathan Druart <jonathan.druart+koha@gmail.com> --- I don't think so. Nick, please reopen if you disagree. -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org