tags:

views:

19

answers:

0
Q: 

Sphinx search: failed to unpack mysqlcompress column

I have compiled sphinx 0.9.9 for debian x64.

When I try to index using unpack_mysqlcompress, I get this error: "WARNING: failed to unpack column 'page_text', error=-5"

The 'page_text' field is around 5Kb, and unpack_mysqlcompress_maxsize is set to 64M, yet the zlib manual says error -5 indicates Z_BUF_ERROR. Also if mysql does the decompression using UNCOMPRESS(), it works fine.

Any ideas why sphinx is generating this error?

related questions

Which search technology to use with ASP.NET?
Best text search engine for integrating with custom web app?
In-house full-text search engine for source code and SQL scripts
How to implement in-process full text search engine
What are the full-text search tools you can use in SQL Server?
Make SQL Server index small numbers
How do I compare phrases for similarity?
How to do hit-highlighting of results from a SQL Server full-text query
LinqToSql and full text search - can it be done?
What are some Search Servers out there?
When should you use full-text indexing?
SQL Server Freetext match - how do I sort by relevance
Upgrade database from SQL Server 2000 to 2005 -- and rebuild full-text indexes?
How do I do full-text searching in Ruby on Rails?
SQL Server Full-Text Search: Hung processes with MSSEARCH wait type
MS SQL FTI - searching on "n*" returns numbers
Searching subversion history (full text)
How to implement a "related" degree measure algorithm?
Best full text search alternative to ms sql, c++ solution
How do you full-text search multiple criteria on left-joined tables in SQL Server?
Can you perform an AND search of keywords using FREETEXT() on SQL Server 2005?
SQL Server Full Text Searching
How to enable Full-text Indexing in SQL Server 2005 Express?
How do you get leading wildcard full-text searches to work in SQL Server?
Why doesn't SQL Full Text Indexing return results for words containing #?