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
If a site has existed for a couple of years, there’s a good chance that you will find redirect chains …
Continue reading “How to find redirect chains using Screaming Frog”
Every e-commerce owner is turning to Google Shopping to spread the word about their products and services. Google offers these …
Here at CueBlocks, we know 2020 has been an uphill battle for most companies. We’ve worked hard this year to …
Continue reading “CueBlocks Proud to be Listed as a Top Firm on the Clutch 1000!”
One little glitch like a blurred product image or navigation error in a newsletter campaign or excessive view of popup …
Continue reading “Importance Of Quality Assurance In E-commerce”
A presentation on How to make your website search engine friendly by our Co-Founder – Avneet. She presented the topic …
Continue reading “Search Engine Friendly Sites – CueBlocks at BrnoExpatCenter 2020”
Hello! To our CueBlocks Family (from the other side). As you all must know by now, the world is rattled …