[Koha-bugs] [Bug 26596] New: koha-upgrade-schema should check version before calling updatedatabase.pl

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Fri Oct 2 03:04:49 CEST 2020


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26596

            Bug ID: 26596
           Summary: koha-upgrade-schema should check version before
                    calling updatedatabase.pl
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Architecture, internals, and plumbing
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: dcook at prosentient.com.au
        QA Contact: testopia at bugs.koha-community.org

At the moment, koha-upgrade-schema indiscriminately runs updatedatabase.pl,
regardless of whether or not the Koha instance actually requires a database
upgrade.

I've noted that running koha-upgrade-schema against a large number of instances
(e.g. 50 instances) takes a couple of minutes. Jonathan has noted doing an
upgrade will take 1.5 seconds, so 1.5 x 50 = would be 1.25 minutes. 

Jonathan and I agreed via email that koha-upgrade-schema should do a check
similar to C4::Auth::_version_check but without using the ORM via
C4::Context->preference() to avoid the overhead of loading the DBIC schema. 

In theory, koha-upgrade-schema should be able to spin through 50 instances in a
fraction of a second, if none of them need database upgrades.

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.


More information about the Koha-bugs mailing list