[Koha] Install fails: 19.11 on fresh Debian 9: table $SITE.zebraqueue doesn't exist

Wed Mar 11 04:54:31 NZDT 2020

I tried the steps you suggested:

> # sudo su
> mysql -uroot -p [Enter the MySQL Root password]
> drop database koha_library;
> create database koha_library;
> quit;
>
> # sudo koha-upgrade-schema library

This resulted in a large number of error messages returned on the command
line, about tables not existing. The koha-upgrade-schema program assumes
that tables already exist.

  --Dwight

On Mon, Mar 9, 2020 at 11:32 AM Alvaro Cornejo <cornejo.alvaro at gmail.com>
wrote:

> Hi
>
> Both possibilities you refer end on the same. database is not
> ready/complete for the next processes to take place. Therefore I guess
> there is actually a race condition.
>
> Have you tried to manually create the DB?
>
> # sudo su
> mysql -uroot -p [Enter the MySQL Root password]
> drop database koha_library;
> create database koha_library;
> quit;
>
> # sudo koha-upgrade-schema library
>
> BTW, I'm not aware that calling "opac" to your instance might cause a
> problem, but I guess since "opac" is a sort of keyword in the system, I'll
> avoid using that word as my instance.
>
> Hope that helps
>
> Alvaro
>
>
>
> |----------------------------------------------------------------------------------------|
> *7* Switch off as you go / Apaga lo que no usas /  Débranchez au fur et à
> mesure.
>  *q *Recycle always / Recicla siempre / Recyclez toujours
>  P Print only if absolutely necessary / Imprime solo si es necesario /
> Imprimez seulement si nécessaire
>
>
> Le lun. 9 mars 2020 à 00:09, Dwight Tuinstra <dwight.tuinstra at gmail.com>
> a écrit :
>
>> Hello all --
>>
>> I'm volunteering some IT consulting at a small research library in Oaxaca,
>> Mexico, that wishes to use koha. To start the project I'm trying to
>> install
>> a test instance of koha 19.11 on a fresh install of Debian 9, which the
>> documentation suggests is one of the preferred platforms.
>>
>> I've carefully followed the wiki document "Koha on Debian" (
>> https://wiki.koha-community.org/wiki/Koha_on_Debian), performing all
>> steps
>> in the order indicated. So far I found one (known but unfixed)
>> documentation bug and applied the workaround -- one needs to add a
>> backports repository -- but this time I'm running up against something
>> that
>> isn't so easy.
>>
>> The problem manifests as the web UI seeming to hang after going through
>> all
>> the configuration screens and 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.
>>
>> 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/opac (I'm calling my instance
>> "opac") begins to fill up with error messages. The first few are:
>>
>> DBD::mysql::db do failed: Table 'koha_opac.systempreferences' doesn't
>> exist
>> [for Statement "
>>             SELECT * FROM systempreferences WHERE 1 = 0 "] at
>> /usr/share/koha/lib/Koha/Database.pm line 114.
>> DBD::mysql::st execute failed: Table 'koha_opac.systempreferences' doesn't
>> exist [for Statement "SELECT `me`.`variable`, `me`.`value`,
>> `me`.`options`,
>> `me`.`explanation`, `me`.`type` FROM `systempreferences` `me` WHERE (
>> `me`.`variable` = ? )" with ParamValues: 0='casauthentication'] at
>> /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836.
>> DBD::mysql::st execute failed: Table 'koha_opac.systempreferences' doesn't
>> exist [for Statement "SELECT `me`.`variable`, `me`.`value`,
>> `me`.`options`,
>> `me`.`explanation`, `me`.`type` FROM `systempreferences` `me` WHERE (
>> `me`.`variable` = ? )" with ParamValues: 0='caslogout'] at
>> /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836.
>> DBD::mysql::st execute failed: Table 'koha_opac.systempreferences' doesn't
>> exist [for Statement "SELECT `me`.`variable`, `me`.`value`,
>> `me`.`options`,
>> `me`.`explanation`, `me`.`type` FROM `systempreferences` `me` WHERE (
>> `me`.`variable` = ? )" with ParamValues: 0='casserverurl'] at
>> /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836.
>> DBD::mysql::db selectall_arrayref failed: Table
>> 'koha_opac.marc_subfield_structure' doesn't exist [for Statement "
>>         SELECT *
>>         FROM marc_subfield_structure
>>         WHERE frameworkcode = ?
>>         AND kohafield > ''
>>         ORDER BY frameworkcode,tagfield,tagsubfield
>>     "] at /usr/share/koha/lib/C4/Biblio.pm line 1013.
>> DBD::mysql::st execute failed: Table 'koha_opac.zebraqueue' doesn't exist
>> [for Statement "SELECT COUNT(*) FROM zebraqueue WHERE done = 0;"] at
>> /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 324.
>> DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() [for
>> Statement "SELECT COUNT(*) FROM zebraqueue WHERE done = 0;"] at
>> /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 325.
>>
>> After this, the log continues to grow with the last two lines constantly
>> added over and over. Curiously, though, this seems to stop 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/opac/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.
>>
>> 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: mariadb, on same host as koha
>> - During WebUI installer:
>>     - All Perl dependencies installed and OK
>>     - All DB settings look reasonable, connection established, and
>> database
>> koha_opac exists and can be accessed
>>
>> Please help! I've spent hours upon hours doing the installation over and
>> over, making sure everything is clean and updated, and all changes and
>> actions are exactly as the documentation requests. I've kept configuration
>> changes to the minimum required by the documentation in order to avoid
>> complications. What do I need to do to get koha installed?
>>
>>   --Dwight (Memo)
>> _______________________________________________
>>
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>