Uploaded image for project: 'translate5'
  1. translate5
  2. TRANSLATE-4555

Segment can not be saved due TM usage log errors

Details

    • Critical
    • The usage of TMs with penalties led to non savable segments in some circumstances.

    Description

      problem

       

      [19-Mar-2025 15:12:51 Europe/Vienna] ERROR Zend_Db_Statement_Exception: E9999 - SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'sourceLang' cannot be null, query was: INSERT INTO LEK_languageresources_usage_log_sum (langageResourceId, langageReso
urceName, langageResourceType, sourceLang, targetLang, customerId, yearAndMonth, totalCharacters)  
                VALUES (?,?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE totalCharacters=totalCharacters+?;

  in core /var/www/instances-local/instance-1000/vendor/shardj/zf1-future/library/Zend/Db/Statement/Pdo.php (235)  


  Trace:  
    #0 /var/www/instances-local/instance-1000/vendor/shardj/zf1-future/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute()
    #1 /var/www/instances-local/instance-1000/vendor/shardj/zf1-future/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute()
    #2 /var/www/instances-local/instance-1000/vendor/shardj/zf1-future/library/Zend/Db/Adapter/Pdo/Abstract.php(267): Zend_Db_Adapter_Abstract->query()
    #3 /var/www/instances-local/instance-1000/application/modules/editor/Models/LanguageResources/UsageSumLogger.php(146): Zend_Db_Adapter_Pdo_Abstract->query()
    #4 /var/www/instances-local/instance-1000/application/modules/editor/Models/LanguageResources/UsageSumLogger.php(125): editor_Models_LanguageResources_UsageSumLogger->updateInsertTotalCharacters()
    #5 /var/www/instances-local/instance-1000/application/modules/editor/Models/LanguageResources/UsageLogger.php(112): editor_Models_LanguageResources_UsageSumLogger->updateSumTable()
    #6 /var/www/instances-local/instance-1000/application/modules/editor/Models/LanguageResources/UsageLogger.php(102): editor_Models_LanguageResources_UsageLogger->updateSumTable()
    #7 /var/www/instances-local/instance-1000/application/modules/editor/Services/UsageLogerTrait.php(132): editor_Models_LanguageResources_UsageLogger->save()
    #8 /var/www/instances-local/instance-1000/application/modules/editor/Services/Connector.php(332): editor_Services_Connector_Abstract->logAdapterUsage()
    #9 /var/www/instances-local/instance-1000/application/modules/editor/Models/Segment/Updater.php(361): editor_Services_Connector->__call()
    #10 /var/www/instances-local/instance-1000/application/modules/editor/Models/Segment/Updater.php(295): editor_Models_Segment_Updater->logAdapterUsageOnSegmentEdit()
    #11 /var/www/instances-local/instance-1000/application/modules/editor/Models/Segment/Updater.php(176): editor_Models_Segment_Updater->updateMatchRateType()
    #12 /var/www/instances-local/instance-1000/application/modules/editor/Models/Segment/Updater.php(93): editor_Models_Segment_Updater->beforeSegmentUpdate()
    #13 /var/www/instances-local/instance-1000/application/modules/editor/Controllers/SegmentController.php(339): editor_Models_Segment_Updater->update()
    #14 /var/www/instances-local/instance-1000/vendor/shardj/zf1-future/library/Zend/Controller/Action.php(522): Editor_SegmentController->putAction()
    #15 /var/www/instances-local/instance-1000/library/ZfExtended/Controllers/AAARestController.php(351): Zend_Controller_Action->dispatch()
    #16 /var/www/instances-local/instance-1000/vendor/shardj/zf1-future/library/Zend/Controller/Dispatcher/Standard.php(308): ZfExtended_RestController->dispatch()
    #17 /var/www/instances-local/instance-1000/vendor/shardj/zf1-future/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch()
    #18 /var/www/instances-local/instance-1000/vendor/shardj/zf1-future/library/Zend/Application/Bootstrap/Bootstrap.php(106): Zend_Controller_Front->dispatch()
    #19 /var/www/instances-local/instance-1000/vendor/shardj/zf1-future/library/Zend/Application.php(400): Zend_Application_Bootstrap_Bootstrap->run()
    #20 /var/www/instances-local/instance-1000/library/ZfExtended/Application.php(75): Zend_Application->run()
    #21 /var/www/instances-local/instance-1000/library/ZfExtended/BaseIndex.php(171): ZfExtended_Application->run()
    #22 /var/www/instances-local/instance-1000/public/index.php(35): ZfExtended_BaseIndex->startApplication()
    #23 {main}

 Previous Exception:  


ERROR PDOException: E9999 - SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'sourceLang' cannot be null

  in core /var/www/instances-local/instance-1000/vendor/shardj/zf1-future/library/Zend/Db/Statement/Pdo.php (228)  
  Trace:  
    #0 /var/www/instances-local/instance-1000/vendor/shardj/zf1-future/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute()
    #1 /var/www/instances-local/instance-1000/vendor/shardj/zf1-future/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute()
    #2 /var/www/instances-local/instance-1000/vendor/shardj/zf1-future/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute()
    #3 /var/www/instances-local/instance-1000/vendor/shardj/zf1-future/library/Zend/Db/Adapter/Pdo/Abstract.php(267): Zend_Db_Adapter_Abstract->query()
    #4 /var/www/instances-local/instance-1000/application/modules/editor/Models/LanguageResources/UsageSumLogger.php(146): Zend_Db_Adapter_Pdo_Abstract->query()
    #5 /var/www/instances-local/instance-1000/application/modules/editor/Models/LanguageResources/UsageSumLogger.php(125): editor_Models_LanguageResources_UsageSumLogger->updateInsertTotalCharacters()
    #6 /var/www/instances-local/instance-1000/application/modules/editor/Models/LanguageResources/UsageLogger.php(112): editor_Models_LanguageResources_UsageSumLogger->updateSumTable()
    #7 /var/www/instances-local/instance-1000/application/modules/editor/Models/LanguageResources/UsageLogger.php(102): editor_Models_LanguageResources_UsageLogger->updateSumTable()
    #8 /var/www/instances-local/instance-1000/application/modules/editor/Services/UsageLogerTrait.php(132): editor_Models_LanguageResources_UsageLogger->save()
    #9 /var/www/instances-local/instance-1000/application/modules/editor/Services/Connector.php(332): editor_Services_Connector_Abstract->logAdapterUsage()
    #10 /var/www/instances-local/instance-1000/application/modules/editor/Models/Segment/Updater.php(361): editor_Services_Connector->__call()
    #11 /var/www/instances-local/instance-1000/application/modules/editor/Models/Segment/Updater.php(295): editor_Models_Segment_Updater->logAdapterUsageOnSegmentEdit()
    #12 /var/www/instances-local/instance-1000/application/modules/editor/Models/Segment/Updater.php(176): editor_Models_Segment_Updater->updateMatchRateType()
    #13 /var/www/instances-local/instance-1000/application/modules/editor/Models/Segment/Updater.php(93): editor_Models_Segment_Updater->beforeSegmentUpdate()
    #14 /var/www/instances-local/instance-1000/application/modules/editor/Controllers/SegmentController.php(339): editor_Models_Segment_Updater->update()
    #15 /var/www/instances-local/instance-1000/vendor/shardj/zf1-future/library/Zend/Controller/Action.php(522): Editor_SegmentController->putAction()
    #16 /var/www/instances-local/instance-1000/library/ZfExtended/Controllers/AAARestController.php(351): Zend_Controller_Action->dispatch()
    #17 /var/www/instances-local/instance-1000/vendor/shardj/zf1-future/library/Zend/Controller/Dispatcher/Standard.php(308): ZfExtended_RestController->dispatch()
    #18 /var/www/instances-local/instance-1000/vendor/shardj/zf1-future/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch()
    #19 /var/www/instances-local/instance-1000/vendor/shardj/zf1-future/library/Zend/Application/Bootstrap/Bootstrap.php(106): Zend_Controller_Front->dispatch()
    #20 /var/www/instances-local/instance-1000/vendor/shardj/zf1-future/library/Zend/Application.php(400): Zend_Application_Bootstrap_Bootstrap->run()
    #21 /var/www/instances-local/instance-1000/library/ZfExtended/Application.php(75): Zend_Application->run()
    #22 /var/www/instances-local/instance-1000/library/ZfExtended/BaseIndex.php(171): ZfExtended_Application->run()
    #23 /var/www/instances-local/instance-1000/public/index.php(35): ZfExtended_BaseIndex->startApplication()
    #24 {main}

       

       
       
       
       

       

      Attachments

        Activity

          People

            tlauria Thomas Lauria
            tlauria Thomas Lauria
            Sanya Mikhliaiev
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: