[Bug 21273] New: After upgrade from 17.11.08 to 18.05.02 intra not working, Software error: Template process failed
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21273 Bug ID: 21273 Summary: After upgrade from 17.11.08 to 18.05.02 intra not working, Software error: Template process failed Change sponsored?: --- Product: Koha Version: 18.05 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: elias.dehler@thulb.uni-jena.de QA Contact: testopia@bugs.koha-community.org Created attachment 78177 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=78177&action=edit Screenshot phpmyadmin After upgrading from 17.11.08 to 18.05.02 we get the following software error on the intra: Software error: Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_koha.branches' doesn't exist in engine at /usr/share/koha/lib/Koha/Objects.pm line 269 Users can't login on the OPAC and a search from the opac throws the following error: DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_koha.branches' doesn't exist in engine at /usr/share/koha/lib/Koha/Objects.pm line 129 It seems like there went something wrong during the upgrade process. With phpmyadmin we can see that the table 'koha_koha.branches' is still there but the collation is shown as in-use. If we try to select this table we get the following error: #1932 - Table 'koha_koha.branches' doesn't exist in engine The same error occurs on three other tables: borrower_attribute_types categories currency -- 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=21273 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@bugs.koha-c | |ommunity.org --- Comment #1 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- If it happens on your test system I would replay the upgrade. You can also try REPAIR TABLE `table_name` -- 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=21273 --- Comment #2 from Elias <elias.dehler@thulb.uni-jena.de> --- Just tested it with the 18.05.03 update. The upgrade went fine, but after a server restart the same issues occur. REPAIR TABLE fails with message that the table doesn't exist in the engine -- 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=21273 Michael Oehrlich <michael.oehrlich@thulb.uni-jena.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |michael.oehrlich@thulb.uni- | |jena.de --- Comment #3 from Michael Oehrlich <michael.oehrlich@thulb.uni-jena.de> --- Updated the MariaDB Version to 10.2.17-MariaDB-10.2.17+maria~xenial Than it works. Probably the update script should check this. See attachment. -- 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=21273 --- Comment #4 from Michael Oehrlich <michael.oehrlich@thulb.uni-jena.de> --- Created attachment 78330 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=78330&action=edit Alter Table not working -- 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=21273 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |18336 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18336 [Bug 18336] Add support for Unicode supplementary characters -- 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=21273 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|enhancement |major CC| |tomascohen@gmail.com Version|18.05 |master -- 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=21273 --- Comment #5 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- (In reply to Michael Oehrlich from comment #3)
Updated the MariaDB Version to 10.2.17-MariaDB-10.2.17+maria~xenial Than it works. Probably the update script should check this. See attachment.
Which version did you have before? -- 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=21273 --- Comment #6 from Michael Oehrlich <michael.oehrlich@thulb.uni-jena.de> --- (In reply to Jonathan Druart from comment #5)
(In reply to Michael Oehrlich from comment #3)
Updated the MariaDB Version to 10.2.17-MariaDB-10.2.17+maria~xenial Than it works. Probably the update script should check this. See attachment.
Which version did you have before?
10.0.36 https://packages.ubuntu.com/de/xenial/mariadb-server Last stable version from package manager. The update is only possible if we are using an additional mirror. -- 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=21273 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de --- Comment #7 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Hi Michael, were you able to solve the problem? Is there a chance that you have additional indexes or similar or some other changes to standard? -- 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=21273 --- Comment #8 from Michael Oehrlich <michael.oehrlich@thulb.uni-jena.de> --- (In reply to Katrin Fischer from comment #7)
Hi Michael, were you able to solve the problem? Is there a chance that you have additional indexes or similar or some other changes to standard?
At the moment on Ubuntu 16.04.05 it is not possible to get an official release upgrade from mariadb. On Ubuntu 18 it's "10.1.34-MariaDB-0ubuntu0.18.04.1". Out of the box that doesn't work. You just need another release package from another source. It would be okay to do that, but you just need a check or a warning and a stop of the upgrade process from koha-common if you not have a mariadb version that can handle this emojis in its index. -- 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=21273 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=21273 --- Comment #9 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- (In reply to Michael Oehrlich from comment #4)
Created attachment 78330 [details] Alter Table not working
On this screenshot: "Index column size too large. The maximum column size is 767 bytes. at /usr/share/perl5/DBIx/RunSQL.pm line 273." (To help searching this issue) -- 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=21273 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=21496 -- 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=21273 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |martin.renvoize@ptfs-europe | |.com --- Comment #10 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- I can confirm this is also the case with 10.1.26 martin@mr-dev$ sudo apt-cache show mariadb-common Package: mariadb-common Source: mariadb-10.1 Version: 10.1.26-0+deb9u1 Installed-Size: 70 Maintainer: Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org> Architecture: all Depends: mysql-common (>= 5.6.25) Description-en: MariaDB common metapackage MariaDB is a fast, stable and true multi-user, multi-threaded SQL database server. SQL (Structured Query Language) is the most popular database query language in the world. The main goals of MariaDB are speed, robustness and ease of use. Description-md5: a8bf2c1aebcb16934e54a7cb04adbfb4 Multi-Arch: foreign Homepage: https://mariadb.org/ Tag: protocol::db:mysql, role::app-data, role::metapackage, works-with::db Section: database Priority: optional Filename: pool/main/m/mariadb-10.1/mariadb-common_10.1.26-0+deb9u1_all.deb Size: 27258 MD5sum: 0e84745e82042355606e8f0e3a2f3fba SHA256: 284fd5170a4c84651f54f15211ac209022473e38ce978f77b9e1e2518d276154 -- 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=21273 --- Comment #11 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- A complete drop and restors of the database from a backup worked for me.. no package update required.. I tihnk it may be to do with some file permissions getting mis-set during mariadb server upgrade? -- 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=21273 --- Comment #12 from Michael Oehrlich <michael.oehrlich@thulb.uni-jena.de> --- (In reply to Martin Renvoize from comment #11)
A complete drop and restors of the database from a backup worked for me.. no package update required.. I tihnk it may be to do with some file permissions getting mis-set during mariadb server upgrade?
No did not work for us. Only an instance up to 10.2 from MariaDB did work. -- 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=21273 Owen Leonard <oleonard@myacpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |INVALID --- Comment #13 from Owen Leonard <oleonard@myacpl.org> --- It sounds like this was more of a support issue and has been resolved. -- 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