initial indexing of a repository fails (postgres)
|Reported by:||anonymous||Owned by:||ejucovy|
I just installed MultiRepoSearchPlugin and after following the instructions I got to the following error:
omega# trac-admin /var/trac/tcsnp multireposearch reindex_all Repo DOES need reindexing Fetching content at development/tcsnp/Makefile.PL ... ... OperationalError: index row size 7280 exceeds btree maximum, 2713 HINT: Values larger than 1/3 of a buffer page cannot be indexed. Consider a function index of an MD5 hash of the value, or use full text indexing.
Upon further investigation, it seems this is a pretty common error in PostgreSQL, when trying to index a large TEXT column with a btree-type index:
Is this related to the way that MultiRepoSearchPlugin stores data in the schema? (e.g. can it be changed to make it work in Postgres?)
Or maybe you can use full text indexing (instead of btree-indexing) to achieve the same?