Bug #5796
closed
[API] search index on collections fails sometimes. Make it not fail by removing file_names column.
Description
ERROR: index row size 2768 exceeds maximum 2712 for index "collections_search_index"
Updated by Radhika Chippada about 9 years ago
- 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
Updated by Radhika Chippada about 9 years ago
Added a new migration script that drops and recreates search index on collections table without the file_names column included in it.
Updated by Brett Smith about 9 years ago
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.
Updated by Radhika Chippada about 9 years ago
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.
Updated by Radhika Chippada about 9 years ago
- Status changed from In Progress to Resolved
- % Done changed from 0 to 100
Applied in changeset arvados|commit:f095b4447de612fd1cd7bee5f9121df76cd65434.