Re: [VuFind-Tech] first_indexed / last_indexed not updating - Solr core and MySQL change_tracker mismatch

[Leila G. <lm...@ag...>]

Thanks for the explanation Demian. That helps a lot, and simplifies a lot
of my code.


So if I understand this correctly, the last_indexed field in the
change_tracker table only gets updated if there is a change in the record
(either in the ID (as in a new record), core name, or in the last
transaction date which is generally carried in MARC field 005) that differs
from the corresponding fields in the change_tracker table. This makes
sense, but I just wanted to check to be sure.



Thanks for further clarifying this.


- Leila



*From:* Demian Katz [mailto:dem...@vi...]
*Sent:* Monday, December 11, 2017 1:45 PM
*To:* Leila Gonzales; vufind-tech
*Subject:* RE: [VuFind-Tech] first_indexed / last_indexed not updating -
Solr core and MySQL change_tracker mismatch



Leila,



The getFirstIndexed and getLastIndexed routines accept an additional
parameter containing a core name. If it is not provided (which is the
default situation), they default to “biblio.” So it sounds like you may
need to adjust your marc_local.properties to add the missing core parameter
for your custom cores and then reindex in order to solve the problem.



Note that doing this will cause all of the change tracking data to be
reset. If you have a way of identifying the IDs in the database and
adjusting the core name prior to reindexing, that might help you retain
some of the data, at least.



Does that make any sense? Please let me know if you have questions or
problems – I’m not sure that this is something that has been used very much
(and it’s obviously not particularly well-documented), so if you run into
trouble, please let me know and I’ll help investigate!



- Demian



*From:* Leila Gonzales [mailto:lm...@ag... <lm...@ag...>]
*Sent:* Monday, December 11, 2017 4:39 PM
*To:* vufind-tech <vuf...@li...>
*Subject:* [VuFind-Tech] first_indexed / last_indexed not updating - Solr
core and MySQL change_tracker mismatch



Hi all,


We’re running a multi-instance setup of VuFind and I noticed that when I
clear a Solr core index and reload the entire database, the last_indexed
field for the records in the database are not updating. I’m trying to
troubleshoot why this may be, and one thing I noticed was that the “core”
column in the MySQL change_tracker database is not the same as the Solr
core name. So for instance, the Solr core name is “mycore1”, but the “core”
column in the corresponding MySQL change_tracker table is “biblio”.



Would there be any problems if I cleared the Solr index again (removing the
index and spell* directories), and then deleted all the contents from the
corresponding change_tracker table prior to reloading the Solr index again?



Thanks for your guidance on this.


-Leila