Registry index rejects large vocab synonym lists

nih-cfde / cfde-deriva

Collaboration point for miscellaneous CFDE-deriva scripts

Other

2 stars 3 forks source link

Registry index rejects large vocab synonym lists #298

Closed karlcz closed 2 years ago

karlcz commented 2 years ago

Trying to record vocab usage for a submission with large synonym lists, for example a compound in recent LINCS submissions, hits an implementation limit and fails.

To remove this limit, we need to drop btree indexes that were unfortunately created on the registry vocab tables.

karlcz commented 2 years ago

@ACharbonneau I think this is a blocker for the upcoming release

karlcz commented 2 years ago

A fix for this has been pushed and also manually applied to the app-dev registry. It was tested with a (still in progress) submission rebuild which has passed the stage where it failed before.