Indexing not working after upgrade

11 Jul 2018

      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

Suresh Kumar Tejomurtula

Hugo Agud

Suresh Kumar Tejomurtula

Alvaro Cornejo

Suresh Kumar Tejomurtula

tags

participants (3)