Occ search for Germany returns no records

13819
Reporter: mdoering
Assignee: fmendez
Type: Feedback
Summary: Occ search for Germany returns no records
Description: But it shows 6 million sth matches
Resolution: CantReproduce
Status: Closed
Created: 2013-09-10 18:10:56.334
Updated: 2013-09-26 15:13:19.004
Resolved: 2013-09-26 15:13:18.973
        
    

Author: fmendez@gbif.org
Created: 2013-09-11 10:14:01.361
Updated: 2013-09-11 10:14:01.361
        
Seems that some occurrence records were deleted in HBase, unfortunately there's a issue related to dataset lookups (Tim and Oliver are working on that), once hbase is ready we will rebuild the Solr Index.
If you use the link http://portaldev.gbif.org/occurrence/search?COUNTRY=DE&offset=60, you can see that at that page the records are available in both side Solr and HBase.

In the occurrence-ws.log file there are several warnings about this issue:
DEBUG [2013-09-11 10:08:02,078+0200] [http-bio-8080-exec-5] org.gbif.occurrence.ws.resources.OccurrenceSearchResource: Exceuting query, parameters {COUNTRY=[DE]}, limit 20, offset 60
DEBUG [2013-09-11 10:08:02,287+0200] [http-bio-8080-exec-5] org.gbif.occurrencestore.persistence.OccurrencePersistenceServiceImpl: Couldn't find occurrence for key [694883027], returning null
WARN  [2013-09-11 10:08:02,287+0200] [http-bio-8080-exec-5] org.gbif.occurrencestore.search.OccurrenceSearchImpl: Occurrence 694883027 not found in store, but present in solr
DEBUG [2013-09-11 10:08:02,288+0200] [http-bio-8080-exec-5] org.gbif.occurrencestore.persistence.OccurrencePersistenceServiceImpl: Couldn't find occurrence for key [694883031], returning null
WARN  [2013-09-11 10:08:02,288+0200] [http-bio-8080-exec-5] org.gbif.occurrencestore.search.OccurrenceSearchImpl: Occurrence 694883031 not found in store, but present in solr
DEBUG [2013-09-11 10:08:02,289+0200] [http-bio-8080-exec-5] org.gbif.occurrencestore.persistence.OccurrencePersistenceServiceImpl: Couldn't find occurrence for key [694883041], returning null
WARN  [2013-09-11 10:08:02,289+0200] [http-bio-8080-exec-5] org.gbif.occurrencestore.search.OccurrenceSearchImpl: Occurrence 694883041 not found in store, but present in solr
DEBUG [2013-09-11 10:08:02,290+0200] [http-bio-8080-exec-5] org.gbif.occurrencestore.persistence.OccurrencePersistenceServiceImpl: Couldn't find occurrence for key [694883043], returning null
WARN  [2013-09-11 10:08:02,290+0200] [http-bio-8080-exec-5] org.gbif.occurrencestore.search.OccurrenceSearchImpl: Occurrence 694883043 not found in store, but present in solr
DEBUG [2013-09-11 10:08:02,291+0200] [http-bio-8080-exec-5] org.gbif.occurrencestore.persistence.OccurrencePersistenceServiceImpl: Couldn't find occurrence for key [694883046], returning null
WARN  [2013-09-11 10:08:02,291+0200] [http-bio-8080-exec-5] org.gbif.occurrencestore.search.OccurrenceSearchImpl: Occurrence 694883046 not found in store, but present in solr
DEBUG [2013-09-11 10:08:02,292+0200] [http-bio-8080-exec-5] org.gbif.occurrencestore.persistence.OccurrencePersistenceServiceImpl: Couldn't find occurrence for key [694883050], returning null
WARN  [2013-09-11 10:08:02,292+0200] [http-bio-8080-exec-5] org.gbif.occurrencestore.search.OccurrenceSearchImpl: Occurrence 694883050 not found in store, but present in solr
DEBUG [2013-09-11 10:08:02,293+0200] [http-bio-8080-exec-5] org.gbif.occurrencestore.persistence.OccurrencePersistenceServiceImpl: Couldn't find occurrence for key [694883161], returning null
WARN  [2013-09-11 10:08:02,294+0200] [http-bio-8080-exec-5] org.gbif.occurrencestore.search.OccurrenceSearchImpl: Occurrence 694883161 not found in store, but present in solr
DEBUG [2013-09-11 10:08:02,295+0200] [http-bio-8080-exec-5] org.gbif.occurrencestore.persistence.OccurrencePersistenceServiceImpl: Couldn't find occurrence for key [694883164], returning null
WARN  [2013-09-11 10:08:02,295+0200] [http-bio-8080-exec-5] org.gbif.occurrencestore.search.OccurrenceSearchImpl: Occurrence 694883164 not found in store, but present in solr
DEBUG [2013-09-11 10:08:02,296+0200] [http-bio-8080-exec-5] org.gbif.occurrencestore.persistence.OccurrencePersistenceServiceImpl: Couldn't find occurrence for key [694883165], returning null
WARN  [2013-09-11 10:08:02,296+0200] [http-bio-8080-exec-5] org.gbif.occurrencestore.search.OccurrenceSearchImpl: Occurrence 694883165 not found in store, but present in solr