Details
-
Bug
-
Resolution: Fixed
-
None
-
Critical
-
-
Description
Problem
Since the enabling of zend "default meta data cache", some mysql table info are cached by zend for fast table loading (ex. describe table query).
If segment materialized view exist , we get the table info from the zend cache . And since the segment materialized view can be removed and recreated, the zend db cache for the removed or recreated tables is not updated.
Error stack trace:
[02-Jul-2020 14:02:51 Europe/Vienna] ERROR Zend_Db_Statement_Exception: E9999 - SQLSTATE[42S02]: Base table or view not found: 1146 Table 'translate5.LEK_segment_view_8e07d852fcb3dc67219282d017c9d973' doesn't exist, query was: SELECT `LEK_segment_view_8e07d852fcb3dc67219282d017c9d973`.*, count(*) AS `cnt` FROM `LEK_segment_view_8e07d852fcb3dc67219282d017c9d973` WHERE (`taskGuid`='{d1360990-251e-49d4-b025-689a06329c9d}') LIMIT 1 in core /var/www/zend/zf1-php7.3/library/Zend/Db/Statement/Pdo.php (235) User: manager (Project Manager) ({e6828cdf-2ee0-4a25-af0a-92e6f060e9eb}) Request: GET /editor/task?_dc=1593691370649&page=1&start=0&limit=20&sort=%5B%7B%22property%22%3A%22id%22%2C%22direction%22%3A%22DESC%22%7D%5D Trace: #0 /var/www/zend/zf1-php7.3/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array) #1 /var/www/zend/zf1-php7.3/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #2 /var/www/zend/zf1-php7.3/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `LEK_seg...', Array) #3 /var/www/zend/zf1-php7.3/library/Zend/Db/Table/Abstract.php(1581): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Table_Select)) #4 /var/www/zend/zf1-php7.3/library/Zend/Db/Table/Abstract.php(1443): Zend_Db_Table_Abstract->_fetch(Object(Zend_Db_Table_Select)) #5 /var/www/translate5/application/modules/editor/Models/Segment.php(1683): Zend_Db_Table_Abstract->fetchRow(Object(Zend_Db_Table_Select)) #6 /var/www/translate5/application/modules/editor/Models/TaskUserAssoc.php(612): editor_Models_Segment->getTotalSegmentsCount('{d1360990-251e-...') #7 /var/www/translate5/application/modules/editor/Models/TaskUserAssoc.php(592): editor_Models_TaskUserAssoc->getAllNotAssignedSegmentsByRole('{d1360990-251e-...', 'translator') #8 /var/www/translate5/application/modules/editor/Controllers/TaskController.php(416): editor_Models_TaskUserAssoc->getAllNotAssignedSegments('{d1360990-251e-...') #9 /var/www/translate5/application/modules/editor/Controllers/TaskController.php(404): editor_TaskController->addMissingSegmentrangesToResult(Array) #10 /var/www/translate5/application/modules/editor/Controllers/TaskController.php(249): editor_TaskController->loadAllForTaskOverview() #11 /var/www/zend/zf1-php7.3/library/Zend/Controller/Action.php(516): editor_TaskController->indexAction() #12 /var/www/translate5/library/ZfExtended/Controllers/AAARestController.php(287): Zend_Controller_Action->dispatch('indexAction') #13 /var/www/zend/zf1-php7.3/library/Zend/Controller/Dispatcher/Standard.php(308): ZfExtended_RestController->dispatch('indexAction') #14 /var/www/zend/zf1-php7.3/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(REST_Controller_Request_Http), Object(Zend_Controller_Response_Http)) #15 /var/www/zend/zf1-php7.3/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch() #16 /var/www/zend/zf1-php7.3/library/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run() #17 /var/www/translate5/library/ZfExtended/Application.php(47): Zend_Application->run() #18 /var/www/translate5/library/ZfExtended/BaseIndex.php(149): ZfExtended_Application->run() #19 /var/www/translate5/public/index.php(35): ZfExtended_BaseIndex->startApplication() #20 {main}