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

Wed Mar 11 05:06:06 NZDT 2020

Hi

Sorry, after deleting the koha db you should run "koha-create" not
koha-upgrade-scheme this will create all tables for the version you are
running.

Check command info to see the parameters you need. (
https://wiki.koha-community.org/wiki/Commands_provided_by_the_Debian_packages#koha-create
)

You might also need to enable the newly created instance with "koha-enable
library" where library is the name of your instance.

Regards,

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 mar. 10 mars 2020 à 10:55, Dwight Tuinstra <dwight.tuinstra at gmail.com> a
écrit :

> 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
>>>
>>