[Koha] Indexing not working after upgrade
Suresh Kumar Tejomurtula
tejoskumar at gmail.com
Thu Jul 12 02:05:12 NZST 2018
Hi
Thank you for the reply. Data is available in biblio and biblioitems.
But, biblio_metadata table is empty.
The same SQL dump is working fine upto 16.11 and 17.05 onwards this error.
Regards
T Suresh Kumar
On Wed 11 Jul, 2018, 19:22 Hugo Agud, <hagud at orex.es> wrote:
> Hi
>
> I think there are separate errors...
>
> club_enrollment is fixed with manual corrections.
> on bug 17135 It not related with zebra index
>
> errors retreiving biblio, please checkif the data is in biblio,
> biblioitems and biblio_metada -->, once the info is there check the Koha
> framework, for a testing purpouses move all records framework to default
> and try to reindex again
>
> I guess you know how to assing all records to default framework right?
>
> reindex again
>
> 2018-07-11 15:40 GMT+02:00 Suresh Kumar Tejomurtula <tejoskumar at gmail.com>
> :
>
>> Dear all,
>>
>> Could any one help me on how to solve the below issue with my database:
>>
>>
>> --------------------------------------------------------------------------------------------------------------
>>
>> I installed koha 17.11 in a fresh PC as per the instructions at -
>> https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages and
>> successfully installed. When I try to index it is working after creating
>> few test records.
>>
>> Iam able to import data from koha version 16.05(Installed on 14.04 ubuntu
>> and with mysql) to 17.11(16.04 ubuntu and mariadb) and issue / returns
>> etc...are working and during installation the following warnings / errors
>> i
>> noticed during import / upgrade.
>>
>> -----
>>
>> Attempting upgrade to 16.06.00.028 (Bug 17135) ...
>> DBD::mysql::st execute failed: Unknown column 'me.no_auto_renewal_after'
>> in
>> 'field list' [for Statement "SELECT `me`.`categorycode`, `me`.`itemtype`,
>> `me`.`restrictedtype`, `me`.`rentaldiscount`, `me`.`reservecharge`,
>> `me`.`fine`, `me`.`finedays`, `me`.`maxsuspensiondays`,
>> `me`.`firstremind`,
>> `me`.`chargeperiod`, `me`.`chargeperiod_charge_at`, `me`.`accountsent`,
>> `me`.`chargename`, `me`.`maxissueqty`, `me`.`maxonsiteissueqty`,
>> `me`.`issuelength`, `me`.`lengthunit`, `me`.`hardduedate`,
>> `me`.`hardduedatecompare`, `me`.`renewalsallowed`, `me`.`renewalperiod`,
>> `me`.`norenewalbefore`, `me`.`auto_renew`, `me`.`no_auto_renewal_after`,
>> `me`.`no_auto_renewal_after_hard_limit`, `me`.`reservesallowed`,
>> `me`.`holds_per_record`, `me`.`branchcode`, `me`.`overduefinescap`,
>> `me`.`cap_fine_to_replacement_price`, `me`.`onshelfholds`,
>> `me`.`opacitemholds`, `me`.`article_requests` FROM `issuingrules` `me`
>> WHERE ( ( `branchcode` IN ( ?, ? ) AND `categorycode` IN ( ?, ? ) AND
>> `itemtype` IN ( ?, ? ) ) ) ORDER BY `branchcode` DESC, `categorycode`
>> DESC,
>> `itemtype` DESC LIMIT ?" with ParamValues: 0='IC-ARDC', 1='*', 2='PT',
>> 3='*', 4='BK', 5='*', 6=1] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm
>> line 1834.
>> DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column
>> 'me.no_auto_renewal_after' in 'field list' at
>> /usr/share/koha/lib/Koha/Objects.pm
>> line 191
>> Upgrade to 16.06.00.028 done (Bug 17135 - Fine for the previous overdue
>> may
>> get overwritten by the next one)
>> WARNING: There is a possibility (= just a possibility, it's configuration
>> dependent etc.) that - due to regression introduced by Bug 15675 - some
>> old
>> fine records for overdued items (items which got renewed 1+ time while
>> being overdue) may have been overwritten in your production 16.05+
>> database. See Bugzilla reports for Bug 14390 and Bug 17135 for more
>> details.
>> WARNING: Please note that this upgrade does not try to recover such
>> overwitten old fine records (if any) - it's just an follow-up for Bug
>> 14390, its sole purpose is preventing eventual further-on overwrites from
>> happening in the future. Optional recovery of the overwritten fines
>> (again,
>> if any) is like, totally outside of the scope of this particular upgrade!
>> Upgrade to 16.06.00.029 done (Bug 14707 - Change UsageStatsCountry from
>> free text to a dropdown list)
>>
>> --------------------------------------------------------------------
>>
>> Upgrade to 16.06.00.038 done (Bug 14874 - Add ability to search for
>> patrons
>> by date of birth from checkout and patron quick searches)
>> item-level_itypes set but no itype defined for item (201671) at
>> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
>> line
>> 13447.
>> item-level_itypes set but no itype defined for item (39020) at
>> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
>> line
>> 13447.
>> item-level_itypes set but no itype defined for item (90632) at
>> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
>> line
>> 13447.
>> item-level_itypes set but no itype defined for item (1967) at
>> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
>> line
>> 13447.
>> Upgrade to 16.06.00.039 done (Bug 14598: itemtype is not set on statistics
>> by C4::Circulation::AddReturn)
>>
>> -------------------------
>> U
>> pgrade to 16.12.00.003 done (Bug 17486 - Remove 'Mozilla Persona' as an
>> authentication method)
>> DBD::mysql::db do failed: Duplicate entry '700-marcxml-CHANGEME' for key
>> 'biblio_metadata_uniq_key' [for Statement "
>> INSERT INTO biblio_metadata ( biblionumber, format, marcflavour,
>> metadata ) SELECT biblionumber, 'marcxml', 'CHANGEME', marcxml FROM
>> biblioitems;
>> "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updat
>> edatabase.pl line 13819.
>> DBD::mysql::db do failed: Cannot add or update a child row: a foreign key
>> constraint fails (`koha_library`.`deletedbiblio_metadata`, CONSTRAINT
>> `deletedbiblio_metadata_fk_1` FOREIGN KEY (`biblionumber`) REFERENCES
>> `deletedbiblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE) [for
>> Statement "
>> INSERT INTO deletedbiblio_metadata ( biblionumber, format,
>> marcflavour, metadata ) SELECT biblionumber, 'marcxml', 'CHANGEME',
>> marcxml
>> FROM deletedbiblioitems;
>> "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updat
>> edatabase.pl line 13822.
>> Upgrade to 16.12.00.004 done (Bug 17196 - Move marcxml out of the
>> biblioitems table)
>>
>> -----------------------------------------------------------------
>>
>> Upgrade to 16.12.00.026 done (Bug 18427 - Add a primary key to
>> serialitems)
>> DBD::mysql::db do failed: Invalid default value for 'date_created' [for
>> Statement "
>> CREATE TABLE IF NOT EXISTS club_enrollments (
>> id int(11) NOT NULL AUTO_INCREMENT,
>> club_id int(11) NOT NULL,
>> borrowernumber int(11) NOT NULL,
>> date_enrolled timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
>> date_canceled timestamp NULL DEFAULT NULL,
>> date_created timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
>> date_updated timestamp NULL DEFAULT NULL,
>> branchcode varchar(10) NULL DEFAULT NULL,
>> PRIMARY KEY (id),
>> KEY club_id (club_id),
>> KEY borrowernumber (borrowernumber),
>> KEY branchcode (branchcode),
>> CONSTRAINT club_enrollments_ibfk_1 FOREIGN KEY (club_id)
>> REFERENCES clubs (id) ON DELETE CASCADE ON UPDATE CASCADE,
>> CONSTRAINT club_enrollments_ibfk_2 FOREIGN KEY (borrowernumber)
>> REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE,
>> CONSTRAINT club_enrollments_ibfk_3 FOREIGN KEY (branchcode)
>> REFERENCES branches (branchcode) ON DELETE SET NULL ON UPDATE CASCADE
>> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
>> "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updat
>> edatabase.pl line 14194.
>> DBD::mysql::db do failed: Can't create table
>> `koha_library`.`club_enrollment_fields`
>> (errno: 150 "Foreign key constraint is incorrectly formed") [for
>> Statement "
>> CREATE TABLE IF NOT EXISTS club_enrollment_fields (
>> id int(11) NOT NULL AUTO_INCREMENT,
>> club_enrollment_id int(11) NOT NULL,
>> club_template_enrollment_field_id int(11) NOT NULL,
>> `value` text NOT NULL,
>> PRIMARY KEY (id),
>> KEY club_enrollment_id (club_enrollment_id),
>> KEY club_template_enrollment_field_id (club_template_enrollment_
>> field_id),
>> CONSTRAINT club_enrollment_fields_ibfk_1 FOREIGN KEY
>> (club_enrollment_id) REFERENCES club_enrollments (id) ON DELETE CASCADE ON
>> UPDATE CASCADE,
>> CONSTRAINT club_enrollment_fields_ibfk_2 FOREIGN KEY
>> (club_template_enrollment_field_id) REFERENCES
>> club_template_enrollment_fields
>> (id) ON DELETE CASCADE ON UPDATE CASCADE
>> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
>> "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updat
>> edatabase.pl line 14227.
>> Upgrade to 16.12.00.027 done (Bug 12461 - Add patron clubs feature)
>>
>>
>> ---------------------------------------------
>>
>> During upgrade Club_enrollments table was not added.
>> So I added the table manually using the above mysql statement in the
>> error.
>> Then I was able to go to do transactions in koha.
>>
>> --------------------------------
>>
>> Then after running the below command iam getting the below error and
>> indexing not working.
>>
>> ----------------------------------------------
>>
>> sudo su
>> sudo koha-rebuild-zebra -b -f -v library
>>
>> ----------------------------------------------
>>
>> Zebra configuration information
>>
>> ================================
>>
>> Zebra biblio directory = /var/lib/koha/library/biblios
>> Zebra authorities directory = /var/lib/koha/library/authorities
>> Koha directory = /usr/share/koha/intranet/cgi-bin
>> Lockfile = /var/lock/koha/library/rebuild/rebuild..LCK
>> BIBLIONUMBER in : 999$c
>> BIBLIOITEMNUMBER in : 999$d
>> ================================
>>
>> skipping authorities
>>
>> ====================
>>
>> exporting biblio
>>
>> ====================
>>
>> 1error retrieving biblio 1 at /usr/share/koha/bin/migration_tools/
>> rebuild_zebra.pl line 683
>> .
>>
>> .
>> .
>> error retrieving biblio 303876 at /usr/share/koha/bin/migration_tools/
>> rebuild_zebra.pl line 683.
>> ....
>>
>> Records exported: 0
>> ====================
>> REINDEXING zebra
>> ====================
>> ====================
>> CLEANING
>> ====================
>> Zebra configuration information
>> ================================
>> Zebra biblio directory = /var/lib/koha/library/biblios
>> Zebra authorities directory = /var/lib/koha/library/authorities
>> Koha directory = /usr/share/koha/intranet/cgi-bin
>> Lockfile = /var/lock/koha/library/rebuild/rebuild..LCK
>> BIBLIONUMBER in : 999$c
>> BIBLIOITEMNUMBER in : 999$d
>> ================================
>> ====================
>> exporting authority
>> ====================
>> 1............
>> Records exported: 13
>> ====================
>> REINDEXING zebra
>> ====================
>> skipping biblios
>> ====================
>> CLEANING
>> ====================
>>
>> After this i installed koha 16.05 in 16.04 ubuntu, imported the data into
>> the installation and then from that i tried to port it to 17.11
>> installation and still the same iam getting the same error. Could any one
>> help me on how to resolve this.
>>
>> Thanks in advance.
>>
>>
>>
>> --
>> Regards
>> T. Suresh Kumar
>> _______________________________________________
>> Koha mailing list http://koha-community.org
>> Koha at lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>
>
> --
>
> *Hugo Agud - Orex Digital *
>
> *www.orex.es <http://www.orex.es>*
>
>
> <http://www.orex.es/> [image: www.orex.es/koha]
> <http://www.orex.es/koha> [image: www.orex.es/vufind]
> <http://www.orex.es/vufind>
>
>
> Director
>
> Avda Josep Tarradelles, 134 (Centro de Negocios Infanta) 08029 - Barcelona
> - Tel: 933 856 138 hagud at orex.es · http://www.orex.es/
>
>
>
> No imprima este mensaje a no ser que sea necesario. Una tonelada de papel
> implica la tala de 15 árboles y el consumo de 250.000 litros de agua.
>
>
>
> Aviso de confidencialidad
> Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO
> RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni
> está autorizado a recibirlo por el remitente), no está autorizado a
> copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este
> mensaje
> por error, por favor, notifíquenoslo inmediatamente y bórrelo de su
> sistema.
>
>
More information about the Koha
mailing list