General error: 2013 Lost connection to MySQL server during query in Magento

Question

when I search any product in top search I get error in Magento.I searched lot in stack over flow and Magento stack exchange but all that solution is not worked in my case.

for ex : if I search "dell laptop" and hit enter it go to error page and error is below.

a:5:{i:0;s:494:" SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query, query was: INSERT INTO catalogsearch_result SELECT 2992 AS query_id, s.product_id, MATCH (s.data_index) AGAINST (:query IN BOOLEAN MODE) AS relevance FROM catalogsearch_fulltext AS sINNER JOIN catalog_product_entity AS e ON e.entity_id = s.product_id WHERE (s.store_id = 1) AND (MATCH (s.data_index) AGAINST (:query IN BOOLEAN MODE)) ON DUPLICATE KEY UPDATE relevance = VALUES(relevance) ";i:1;s:4001:"`

I also truncate all log tables but it's also not working in my case.

so if you guys have any other solution please share with me.

Answer 1

I have solved this issue at my end successfully :)

1. First you delete locks folder under var directory: var/locks
2. make sure 777 permission is var/locks and all files under locks directory.
3. Take a backup of your database & delete catalog_product_flat_1, catalog_product_flat_2 or if there is another one.
4. execute following code:

php indexer.php --reindex catalogsearch_fulltext This will reindex your Catalog Search Index or if you want to update all of the indexes run:

php indexer.php reindexall