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 <[email protected]> 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 <[email protected]> > 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 >> [email protected] >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >> > _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
