Verbatim name usage data is not written to postgres CLB

16784
Reporter: mdoering
Assignee: mdoering
Type: Bug
Summary: Verbatim name usage data is not written to postgres CLB
Priority: Critical
Resolution: Fixed
Status: Closed
Created: 2015-01-16 22:02:06.667
Updated: 2015-01-20 15:55:07.573
Resolved: 2015-01-20 15:55:07.508
        
Description: During import syncing of neo dbs no verbatim data is written to the raw_usage tables. Needs investigation, code looks good on first glance and usages, extensions & nub_rels do get written

Discovered while debugging indexing http://www.gbif.org/dataset/da38f103-4410-43d1-b716-ea6b1b92bbac]]>
    

Author: mdoering@gbif.org
Created: 2015-01-19 15:13:15.433
Updated: 2015-01-19 15:13:15.433
        
It is working again for that bees checklist at least which Ive just indexed using the latest code:
http://www.gbif.org/species/140786988/verbatim
    

Author: mdoering@gbif.org
Comment: But there are only 716 verbatim records from 8027 name usages in postgres, sth strange still not right. Run locally they all go in, maybe sth todo with the postgres prod setup? On dev also all 8027 records do have verbatim raw_usage records. This looks prod specific
Created: 2015-01-19 15:16:03.164
Updated: 2015-01-19 17:42:33.991

Author: mdoering@gbif.org
Comment: uff, the code does an update of the verbatim record. So in case there was none it doesnt get updated in subsequent indexing. Changed to use delete/insert instead: https://github.com/gbif/checklistbank/commit/a96cec7a7046f48777ffa6c497477b2e123bd140
Created: 2015-01-20 15:54:15.403
Updated: 2015-01-20 15:54:15.403