Hi Janos,
> my advice is to send the error message to the sphinx developers as they > recommended. I guess this is a sphinx issue, and I hope that they shall find > a solution. I have submitted a bug with sphinx. > Perhaps you need to show sphinx.conf to the sphinx developers (don't forget > to mask the passwords). Done. > From the point of view of piler, please check whether you have any rows in the > sph_* tables with id=0 (sphinx doesn't like it), ie. > select * from sph_index where id=0; > select * from sph_counter where id=0; These look ok, they don't return any results. Also I upgrade from 0.1.20 to 0.1.21, and now I get a different error: -sh-3.2$ /usr/bin/indexer --merge main1 delta1 --merge-dst-range deleted 0 0 --rotate Sphinx 2.0.5-release (r3308) Copyright (c) 2001-2012, Andrew Aksyonoff Copyright (c) 2008-2012, Sphinx Technologies Inc (http://sphinxsearch.com) using config file '/etc/sphinx/sphinx.conf'... merging index 'delta1' into index 'main1'... read 12.8 of 12.8 MB, 100.0% done FATAL: failed to merge index 'delta1' into index 'main1': attribute count mismatch (me=/var/piler/sphinx/main1, in=/var/piler/sphinx/delta1, myattrs=5, inattrs=6) Cheers John.
