We welcome any suitable alternatives to the solution being discussed here.
We are using Solr in our latest Magento EE project. While running the periodic index updates using Magento’s native CLI indexer (shell/indexer.php) we realized that there was suddenly no data being sent to Solr. Routine test on Solr’s side didn’t reveal any issues; the server was up and running and Magento (Admin > System > Catalog > Catalog Search > Test connection) was showing successful connection.
Analyzing Magento’s and Solr’s logs didn’t provide any clues on what might be happening except it turned out that the indexing process hung right after the index cleanup. Since there was no recent change in the code or server settings the logical conclusion was the database. Tracing Magento code starting from shell/indexer.php took us all the way down to lib/Zend/Db/Statement/Pdo.php:
public function _execute(array $params = null) { try { if ($params !== null) { return $this->_stmt->execute($params); } else { return $this->_stmt->execute(); } } catch (PDOException $e) { #require_once 'Zend/Db/Statement/Exception.php'; throw new Zend_Db_Statement_Exception($e->getMessage(), (int) $e->getCode(), $e); } }
The problem emerged at line 5 where PDO::execute() method is called from $this->_stmt PDO object. As per PHP documentation this function returns true/false but in this case it just did nothing. It turned out that there was a deadlock on one of the tables that prevented execute() from retrieving data and passing it to Solr.
Have you faced a similar issue? What was your solution for that?
Software used:
MagentoEE-1.10.1.1
Solr-3.3.0
Introduction CueBlocks Technologies is an eCommerce design, development, and marketing agency with extensive experience working on Magento, Shopify, Woo Commerce, …
Continue reading “CueBlocks Delivers Exceptional eCcommerce Design & ROI: GoodFirms”
Shopify 1.0 vs 2.0 E-stores around the globe prefer Shopify due to its many features. 29th June 2021 brought one …
Continue reading “The New Shopify version 2.0 – An Update To Look Into”
Google Discover is a curated content feed inside the Google app. The app has more than 800 million monthly active …
Continue reading “How to Optimize & Track Google Discover in Google Analytics”
Colours of Rangoli, Flowers, Lord Ganesha and Women of CB lighting diyas Diyas for enlightenment, spectrum of colour emitting harmony …
Continue reading “Sparking The Joy Within: Diwali 2022 at CueBlocks”
I am sharing this post to announce a happy news with all of you – We have a new WORKSPACE! …
At CueBlocks, we love fresh beginnings! That’s why we’re proud to display our work on Top Design Firms, a new …
Continue reading “CueBlocks Proud to be Featured on Top Design Firms!”