[Koha-bugs] [Bug 24845] New: Web-based installer consistently fails while creating database tables.
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Mar 11 07:29:42 CET 2020
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24845
Bug ID: 24845
Summary: Web-based installer consistently fails while creating
database tables.
Change sponsored?: ---
Product: Koha
Version: 19.11
Hardware: All
OS: All
Status: NEW
Severity: major
Priority: P5 - low
Component: Installation and upgrade (web-based installer)
Assignee: koha-bugs at lists.koha-community.org
Reporter: dwight.tuinstra at gmail.com
QA Contact: testopia at bugs.koha-community.org
CC: gmcharlt at gmail.com
Created attachment 100504
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=100504&action=edit
indexer-output.log, showing table-doesn't exist errors before web installer is
run.
Installation by following the wiki document "Koha on Debian" fails.
I am able to successfully get through the preliminary steps leading up to the
web-based installer, and the first handful of screens in that installer. The
problem occurs after clicking on the button to create the database
tables. After several minutes of no activity, the brower reports
"'Gateway Timeout' The gateway did not receive a timely response from the
upstream server or application." At this point, table creation in mysql/mariadb
stops, after a varying number of tables (around 160 to 180) have been created.
There are two possible causes that I've been able to see so far:
POSSIBILITY 1:
There is an indexer problem that occurs even before the point where the web
installer is run. The file /var/log/koha/biblioteca/indexer-output.log begins
to fill up with error messages -- see attached files. After this, the log
continues to grow with the last two lines constantly added over and over.
Curiously, though, this stops about the time that the web installer is run.
POSSIBILITY 2:
The creation of database tables takes so long that the browser or installer
times out, or race conditions arise. I watched table creation in another
window as the web installer was running. Table creation seemed to go slow
(roughly a table every second) even though there was plenty of free memory,
free disk space (with low disk activity), and the CPUs were over 95% idle.
Table creation stopped at 162 tables, at almost the exact same moment that
the browser gave the timeout message, so I'm not sure if that's all the
tables or if there are supposed to be more.
What's odd here is that the web installer writes a good number of messages
to /var/log/koha/biblioteca/intranet-error.log, each saying that one of these
database tables do not exist: language_descriptions,
language_subtag_registry, or systempreferences. However, all of these
tables *do* exist in the database when one examines it later, which
suggests a race condition.
This problem is perfectly repeatable -- I've gone so far as to script the
manual steps from the wiki documentation to ensure all steps are done, and done
as specified.
This problem is preventing Koha from being installed and used.
OTHER INFO:
- Virtualization: VirtualBox 5.2.34_Ubuntu r133883, 2 i7 CPUs,
pre-allocated fixed disk (32Gb), 2GB RAM
- Debian version: 4.9.0-12-686-pae #1 SMP Debian 4.9.210-1 (2020-01-20) i686
- Koha version: 19.11
- Following: stable
- Database: mysql Ver 15.1 Distrib 10.1.44-MariaDB, for debian-linux-gnu
(i686) using readline 5.2
- During WebUI installer:
- All Perl dependencies installed and OK
- All DB settings look reasonable, connection established, and database
exists and can be accessed
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
More information about the Koha-bugs
mailing list