Prado\Exceptions\TDbException

Description

TDbCommand failed to execute the SQL statement "DELETE FROM _cache WHERE itemkey=:key": SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction

Source File

${PradoFramework}/Data/TDbCommand.php (194)

0183:     {
0184:         try {
0185:             // Do not trace because it will remain even in Performance mode
0186:             // Prado::trace('Execute Command: '.$this->getDebugStatementText(), 'Prado\Data');
0187:             if ($this->_statement instanceof PDOStatement) {
0188:                 $this->_statement->execute();
0189:                 return $this->_statement->rowCount();
0190:             } else {
0191:                 return $this->getConnection()->getPdoInstance()->exec($this->getText());
0192:             }
0193:         } catch (Exception $e) {
0194: throw new TDbException('dbcommand_execute_failed', $e->getMessage(), $this->getDebugStatementText());
0195: } 0196: } 0197: 0198: /** 0199: * @return string prepared SQL text for debugging purposes. 0200: */ 0201: public function getDebugStatementText() 0202: { 0203: //if(Prado::getApplication()->getMode() === TApplicationMode::Debug) 0204: return $this->_statement instanceof PDOStatement ? 0205: $this->_statement->queryString 0206: : $this->getText();

Stack Trace

#0 ${PradoFramework}/Caching/TDbCache.php(552): Prado\Data\TDbCommand->execute()
#1 ${PradoFramework}/Caching/TDbCache.php(495): Prado\Caching\TDbCache->deleteValue('c5d7a2d0c34152a...')
#2 ${PradoFramework}/Caching/TCache.php(155): Prado\Caching\TDbCache->setValue('c5d7a2d0c34152a...', Array, 0)
#3 ${DocumentRoot}/protected/pages/product.php(260): Prado\Caching\TCache->set('loadCategoryOpt...', '\n              ...')
#4 ${DocumentRoot}/protected/pages/product.php(25): product->loadCategoryOption()
#5 ${PradoFramework}/Web/UI/TControl.php(1375): product->onLoad(NULL)
#6 ${PradoFramework}/Web/UI/TPage.php(241): Prado\Web\UI\TControl->loadRecursive()
#7 ${PradoFramework}/Web/UI/TPage.php(221): Prado\Web\UI\TPage->processNormalRequest(Object(Prado\Web\UI\THtmlWriter))
#8 ${PradoFramework}/Web/Services/TPageService.php(547): Prado\Web\UI\TPage->run(Object(Prado\Web\UI\THtmlWriter))
#9 ${PradoFramework}/Web/Services/TPageService.php(465): Prado\Web\Services\TPageService->runPage(Object(product), Array)
#10 ${PradoFramework}/TApplication.php(1245): Prado\Web\Services\TPageService->run()
#11 ${PradoFramework}/TApplication.php(386): Prado\TApplication->runService()
#12 ${DocumentRoot}/index.php(23): Prado\TApplication->run()
#13 {main}
2024-11-24 08:21 Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips mod_fcgid/2.3.9 PHP/7.2.17 PRADO/4.2.1