Hi, first, I'd like to thank Dr. Schweer for her help in diagnosing this problem. Her advice on how to watch for the Solr queries in the undated /dssolr.log file, and then re-running these queries manually on the search Solr core, really helped narrow the problem. However, it turns out that our problem had nothing to do with Solr at all.
It occurred to me earlier this week that I had neglected to ask an somewhat obvious question of our metadata. So, I asked: select count(*) as total from item where DISCOVERABLE = 0; results: 25,979 Umm... wow. SQL for total number of undiscoverable items in collection 493 (aka handle 10355/7252, aka "Evidence Based Practice, 2008 (MU)"): select count(*) as total from item where DISCOVERABLE = 0 AND OWNING_COLLECTION = 493; results: 121. That's every single item in that collection. My theory at this moment is that, since the old DB upgrades were done by hand, I must have accidentally set the default value for discoverable to 0/false. And all items in the repository at the time of that upgrade (to version 3) were flagged as undiscoverable. Which was a little bomb that waited until our upgrade to 5.3 to go off. I've since done some more digging, and have pretty good evidence that this is indeed the scenario: I simply set the discoverable flag incorrectly to 0, at at time where the value of that field didn't matter. But, it matters now. Oh well, live and learn. I've reset the discoverable field for all items, and have re-indexed everything. All collections that should have content again have content. Phew. That was fun. :-\ --Hardy ________________________________ From: [email protected] [[email protected]] on behalf of Andrea Schweer [[email protected]] Sent: Tuesday, September 15, 2015 9:46 PM To: Pottinger, Hardy J.; [email protected] Subject: Re: [dspace-tech] No results for browse for title browse for collections that have items Hi Hardy, On 16/09/15 14:35, Pottinger, Hardy J. wrote: Hi, we recently upgraded to DSpace 5.3, and have encountered a very disturbing problem. A large number of our collections are showing that they have no content (i.e. "no results for browse"). Have a look at the queries in solr.log (not the date-stamped one). Anything helpful? On a 5.1 1/2 (5.1 with customisations / patches from 5.2), I see: 2015-09-16 14:43:25,242 INFO org.apache.solr.core.SolrCore @ [search] webapp=/solr path=/select params={start=0&q=*:*&wt=javabin&fq=NOT(withdrawn:true)&fq=NOT(discoverable:false)&fq=search.resourcetype:2&fq=read:(g0+OR+g0)&version=2} hits=8469 status=0 QTime=2 2015-09-16 14:43:25,484 INFO org.apache.solr.core.SolrCore @ [search] webapp=/solr path=/select params={sort=bi_sort_1_sort+asc&start=0&q=*:*&wt=javabin&fq=NOT(withdrawn:true)&fq=NOT(discoverable:false)&fq=search.resourcetype:2&fq=read:(g0+OR+g0)&version=2&rows=20} hits=8469 status=0 QTime=122 Looks like the first query figures out how many matches there are, while the second one retrieves the first 20 items sorted by title. I guess from there you might want to just run the solr query directly (via curl or solr admin interface or what have you) to check whether the culprit is the solr data or at a higher level. cheers, Andrea -- Dr Andrea Schweer IRR Technical Specialist, ITS Information Systems The University of Waikato, Hamilton, New Zealand +64-7-837 9120 -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To post to this group, send email to [email protected]<mailto:[email protected]>. Visit this group at http://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
