Bug #5796
closed
[API] search index on collections fails sometimes. Make it not fail by removing file_names column.
Added by Radhika Chippada about 9 years ago.
Updated about 9 years ago.
Assigned To:
Radhika Chippada
Description
ERROR: index row size 2768 exceeds maximum 2712 for index "collections_search_index"
- Description updated (diff)
- Category set to API
- Status changed from New to In Progress
- Assigned To set to Radhika Chippada
- Target version changed from Bug Triage to 2015-04-29 sprint
Added a new migration script that drops and recreates search index on collections table without the file_names column included in it.
Comments on 2b39eaf.
Can you please write the down migration? It'll be the same as the up migration, except it'll have "file_names" in the array of columns again. Having down migrations when possible is handy for development and debugging.
I'm a little curious why the order of the arvados_sdk_version and state columns is swapping in the jobs table (I know these sorts of noop edits bug Tom), but this is urgent enough that I'm guessing nobody cares for this merge.
Thanks.
Added down migration with file_names in it.
Not sure why the column order is being updated. Instead of manually changing it, I left it as is. If it results in write wars in the future migrations, we can override this update.
- Status changed from In Progress to Resolved
- % Done changed from 0 to 100
Applied in changeset arvados|commit:f095b4447de612fd1cd7bee5f9121df76cd65434.
Also available in: Atom
PDF
Updated by Radhika Chippada 
Updated by