Wrong records count on country page

16121
Reporter: feedback bot
Type: Bug
Summary: Wrong records count on country page
Priority: Major
Resolution: Fixed
Status: Closed
Created: 2014-07-15 11:48:22.302
Updated: 2015-03-06 14:58:29.252
Resolved: 2015-03-06 14:58:29.228
        
        
Description: Country Page occurrences count is mis calculated!
Data from Belgium shows 9.377.191 records but if you click on this number, you see the real occurrence count of 6.202.528 records.
FYI, the difference is close to the size of Florabank dataset
http://www.gbif.org/dataset/271c444f-f8d8-4986-b748-e7367755c0c1

]]>
    

Author: mdoering@gbif.org
Comment: This is the cubes fault: http://api.gbif.org/v1/occurrence/count?publishingCountry=BE
Created: 2014-07-16 16:00:26.253
Updated: 2014-07-16 16:00:26.253

Author: omeyn@gbif.org
Comment: Testing shows that under ideal conditions cube rebuild and realtime cube updates are working fine. This error looks to be a failure during deletions where presumably some kind of contention issue is causing hbase updates to fail. We know it's not rabbit/messaging because the solr index is getting the deletions and processing them fine (solr count matches hive query).
Created: 2014-07-23 09:21:36.702
Updated: 2014-07-23 09:32:12.074

Author: bko@gbif.org
Comment: I can see this is fixed. Isn't it? Data from Belgium is 7,773,710 records on http://www.gbif.org/country/BE/summary. And when you click the link, here (http://www.gbif.org/occurrence/search?publishingCountry=BE) you see 7,703,710 records.
Created: 2015-03-06 14:52:27.822
Updated: 2015-03-06 14:52:27.822