Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-22913

Removing version image aliases causes MySQL timeouts due to extremely high amount of queries.

    Details

    • Sprint:
      Castor Core S2

      Description

      For content objects with multiple image attributes, multiple translations, and multiple versions,
      each time a version is removed it will perform a very large ammount of queries related to removal of image aliases.

      Sample case:
      An object with 20 image attributes, in 20 translations will have 400 image attributes per version, 8000 total.

      When removing an object version, the image attributes will be removed, which will cause the imagealiashandler to remove
      the aliases.
      For each attribute, for each alias, it will query every single of the existing aliases (8000) in order to re-add it to the table if necessary.

      This causes many thousands of queries for each version, which will in turn cause a timeout, for example, when publishing new content.

      For reference, the eZImageFile::appendFilepath() function seems responsible for 90%+ of the queries/time to remove an object version.

      Steps to reproduce:
      • Setup 10 languages
      • Create a class with 5 image attributes, untranslatable.
      • Create a new object of that class in default language, upload image files
      • Now add a new version for each language, based on the default 'eng-GB'
        ( activating debug redirection is recommended )
      • create a copy of the object.
      • on the copied object, start to edit a new version

      Result:
      As the new version (11) will go above the default version history limit, old versions will be removed, and a large number of sql queries will be generated

      1. ez_sql_debug_output.rar
        801 kB
        Nuno Oliveira
      2. ezimagealiashandler.php.rej
        3 kB
        Pedro Resende
      3. ezimagealiashandler.php.rej
        17 kB
        Pedro Resende
      4. ezimagealiashandler.php.rej.47
        9 kB
        Pedro Resende
      5. ezp-22913-4.7_custom.patch
        15 kB
        Yannick Roger
      6. ezp-22913-5.0_custom.patch
        15 kB
        Yannick Roger
      7. ezp-22913-5.0_custom-v2.patch
        13 kB
        Gunnstein Lye

        Issue Links

          Activity

          Hide
          Bertrand Dunogier added a comment -

          Pull-request https://github.com/ezsystems/ezpublish-legacy/pull/982 (re-take of Joao's with a refactoring).

          Show
          Bertrand Dunogier added a comment - Pull-request https://github.com/ezsystems/ezpublish-legacy/pull/982 (re-take of Joao's with a refactoring).
          Hide
          Bertrand Dunogier added a comment -

          Merged to ezsystems/ezpublish-legacy master@3cfa5f89.

          Show
          Bertrand Dunogier added a comment - Merged to ezsystems/ezpublish-legacy master@3cfa5f89 .
          Hide
          Paulo Nunes (Inactive) added a comment - - edited

          In Master, apparently the fix seems to solve the problem.

          On an eZ Publish 5.2, however, following the steps decribed by João in the description of this issue, with SP's and after applying the patch provided, when i try to edit the created object, i have the following fatal error:

          503 Service UnavailableFatal error: The web server did not finish its request
          

          In apache log, i have

          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP Fatal error:  Call to undefined method eZImageFile::fetchListByFilepath() in /var/www/html/ezp52/ezpublish5/ezpublish_legacy/kernel/classes/datatypes/ezimage/ezimagealiashandler.php on line 750, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP Stack trace:, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP   1. {main}() /var/www/html/ezp52/ezpublish5/web/index.php:0, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP   2. eZ\\Bundle\\EzPublishCoreBundle\\HttpCache->handle() /var/www/html/ezp52/ezpublish5/web/index.php:64, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP   3. Symfony\\Component\\HttpKernel\\HttpCache\\HttpCache->handle() /var/www/html/ezp52/ezpublish5/vendor/ezsystems/ezpublish-kernel/eZ/Bundle/EzPublishCoreBundle/HttpCache.php:36, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP   4. Symfony\\Component\\HttpKernel\\HttpCache\\HttpCache->lookup() /var/www/html/ezp52/ezpublish5/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpCache/HttpCache.php:194, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP   5. Symfony\\Component\\HttpKernel\\HttpCache\\HttpCache->fetch() /var/www/html/ezp52/ezpublish5/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpCache/HttpCache.php:330, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP   6. Symfony\\Bundle\\FrameworkBundle\\HttpCache\\HttpCache->forward() /var/www/html/ezp52/ezpublish5/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpCache/HttpCache.php:430, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP   7. Symfony\\Component\\HttpKernel\\HttpCache\\HttpCache->forward() /var/www/html/ezp52/ezpublish5/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/HttpCache/HttpCache.php:60, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP   8. eZ\\Bundle\\EzPublishCoreBundle\\Kernel->handle() /var/www/html/ezp52/ezpublish5/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpCache/HttpCache.php:473, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP   9. Symfony\\Component\\HttpKernel\\Kernel->handle() /var/www/html/ezp52/ezpublish5/vendor/ezsystems/ezpublish-kernel/eZ/Bundle/EzPublishCoreBundle/Kernel.php:62, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP  10. Symfony\\Component\\HttpKernel\\DependencyInjection\\ContainerAwareHttpKernel->handle() /var/www/html/ezp52/ezpublish5/ezpublish/bootstrap.php.cache:2249, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP  11. Symfony\\Component\\HttpKernel\\HttpKernel->handle() /var/www/html/ezp52/ezpublish5/ezpublish/bootstrap.php.cache:2947, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP  12. Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw() /var/www/html/ezp52/ezpublish5/ezpublish/bootstrap.php.cache:2818, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP  13. call_user_func_array() /var/www/html/ezp52/ezpublish5/ezpublish/bootstrap.php.cache:2844, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP  14. eZ\\Bundle\\EzPublishLegacyBundle\\Controller\\LegacyKernelController->indexAction() /var/www/html/ezp52/ezpublish5/ezpublish/bootstrap.php.cache:2844, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP  15. eZ\\Publish\\Core\\MVC\\Legacy\\Kernel->run() /var/www/html/ezp52/ezpublish5/vendor/ezsystems/ezpublish-kernel/eZ/Bundle/EzPublishLegacyBundle/Controller/LegacyKernelController.php:109, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP  16. ezpKernel->run() /var/www/html/ezp52/ezpublish5/vendor/ezsystems/ezpublish-kernel/eZ/Publish/Core/MVC/Legacy/Kernel.php:117, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP  17. ezpKernelWeb->run() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/kernel/private/classes/ezpkernel.php:53, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP  18. ezpKernelWeb->dispatchLoop() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/kernel/private/classes/ezpkernelweb.php:318, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP  19. eZModule->run() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/kernel/private/classes/ezpkernelweb.php:788, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP  20. eZProcess::run() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/lib/ezutils/classes/ezmodule.php:1789, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP  21. eZProcess->runFile() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/lib/ezutils/classes/ezprocess.php:21, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP  22. include() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/lib/ezutils/classes/ezprocess.php:46, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP  23. eZContentObject->createNewVersionIn() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/kernel/content/edit.php:474, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP  24. eZContentObject->createNewVersion() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/kernel/classes/ezcontentobject.php:1312, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP  25. eZContentObjectVersion->removeThis() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/kernel/classes/ezcontentobject.php:1356, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP  26. eZContentObjectAttribute->removeThis() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/kernel/classes/ezcontentobjectversion.php:910, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP  27. eZImageType->deleteStoredObjectAttribute() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/kernel/classes/ezcontentobjectattribute.php:901, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP  28. eZImageAliasHandler->removeAliases() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/kernel/classes/datatypes/ezimage/ezimagetype.php:186, referer: http://ezp52.paulo/ezdemo_site_admin/
          [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP  29. eZImageAliasHandler->removeAliasFile() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/kernel/classes/datatypes/ezimage/ezimagealiashandler.php:727, referer: http://ezp52.paulo/ezdemo_site_admin/
          
          

          Steps of what i have done:

          • As a normal costumer would do, fetched Ezpublish 5.2 from support.ez.no/downloads
          • Installed an ezdemo without content package, with English (eng-GB) as default language and 9 other languages
          • Installed all 5.2 service packs and ezdemo sp
          • Create a class with 5 image attributes, untranslatable.
          • Create a new object of that class in default language and uploaded image files
          • Added a new version for each language, based on the default 'eng-GB'
          • Created a copy of the object.
          • Applied the patch stable-5.2.
          • Edited a new version on the copied object
          • Published the new version

          It was on last step when the fatal error happened.
          If i remove the patch stable-5.2, the fatal error no longer happen.

          Show
          Paulo Nunes (Inactive) added a comment - - edited In Master, apparently the fix seems to solve the problem. On an eZ Publish 5.2, however, following the steps decribed by João in the description of this issue, with SP's and after applying the patch provided, when i try to edit the created object, i have the following fatal error: 503 Service UnavailableFatal error: The web server did not finish its request In apache log, i have [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP Fatal error: Call to undefined method eZImageFile::fetchListByFilepath() in /var/www/html/ezp52/ezpublish5/ezpublish_legacy/kernel/classes/datatypes/ezimage/ezimagealiashandler.php on line 750, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP Stack trace:, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 1. {main}() /var/www/html/ezp52/ezpublish5/web/index.php:0, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 2. eZ\\Bundle\\EzPublishCoreBundle\\HttpCache->handle() /var/www/html/ezp52/ezpublish5/web/index.php:64, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 3. Symfony\\Component\\HttpKernel\\HttpCache\\HttpCache->handle() /var/www/html/ezp52/ezpublish5/vendor/ezsystems/ezpublish-kernel/eZ/Bundle/EzPublishCoreBundle/HttpCache.php:36, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 4. Symfony\\Component\\HttpKernel\\HttpCache\\HttpCache->lookup() /var/www/html/ezp52/ezpublish5/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpCache/HttpCache.php:194, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 5. Symfony\\Component\\HttpKernel\\HttpCache\\HttpCache->fetch() /var/www/html/ezp52/ezpublish5/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpCache/HttpCache.php:330, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 6. Symfony\\Bundle\\FrameworkBundle\\HttpCache\\HttpCache->forward() /var/www/html/ezp52/ezpublish5/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpCache/HttpCache.php:430, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 7. Symfony\\Component\\HttpKernel\\HttpCache\\HttpCache->forward() /var/www/html/ezp52/ezpublish5/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/HttpCache/HttpCache.php:60, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 8. eZ\\Bundle\\EzPublishCoreBundle\\Kernel->handle() /var/www/html/ezp52/ezpublish5/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpCache/HttpCache.php:473, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 9. Symfony\\Component\\HttpKernel\\Kernel->handle() /var/www/html/ezp52/ezpublish5/vendor/ezsystems/ezpublish-kernel/eZ/Bundle/EzPublishCoreBundle/Kernel.php:62, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 10. Symfony\\Component\\HttpKernel\\DependencyInjection\\ContainerAwareHttpKernel->handle() /var/www/html/ezp52/ezpublish5/ezpublish/bootstrap.php.cache:2249, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 11. Symfony\\Component\\HttpKernel\\HttpKernel->handle() /var/www/html/ezp52/ezpublish5/ezpublish/bootstrap.php.cache:2947, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 12. Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw() /var/www/html/ezp52/ezpublish5/ezpublish/bootstrap.php.cache:2818, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 13. call_user_func_array() /var/www/html/ezp52/ezpublish5/ezpublish/bootstrap.php.cache:2844, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 14. eZ\\Bundle\\EzPublishLegacyBundle\\Controller\\LegacyKernelController->indexAction() /var/www/html/ezp52/ezpublish5/ezpublish/bootstrap.php.cache:2844, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 15. eZ\\Publish\\Core\\MVC\\Legacy\\Kernel->run() /var/www/html/ezp52/ezpublish5/vendor/ezsystems/ezpublish-kernel/eZ/Bundle/EzPublishLegacyBundle/Controller/LegacyKernelController.php:109, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 16. ezpKernel->run() /var/www/html/ezp52/ezpublish5/vendor/ezsystems/ezpublish-kernel/eZ/Publish/Core/MVC/Legacy/Kernel.php:117, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 17. ezpKernelWeb->run() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/kernel/private/classes/ezpkernel.php:53, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 18. ezpKernelWeb->dispatchLoop() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/kernel/private/classes/ezpkernelweb.php:318, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 19. eZModule->run() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/kernel/private/classes/ezpkernelweb.php:788, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 20. eZProcess::run() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/lib/ezutils/classes/ezmodule.php:1789, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 21. eZProcess->runFile() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/lib/ezutils/classes/ezprocess.php:21, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 22. include() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/lib/ezutils/classes/ezprocess.php:46, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 23. eZContentObject->createNewVersionIn() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/kernel/content/edit.php:474, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 24. eZContentObject->createNewVersion() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/kernel/classes/ezcontentobject.php:1312, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 25. eZContentObjectVersion->removeThis() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/kernel/classes/ezcontentobject.php:1356, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 26. eZContentObjectAttribute->removeThis() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/kernel/classes/ezcontentobjectversion.php:910, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 27. eZImageType->deleteStoredObjectAttribute() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/kernel/classes/ezcontentobjectattribute.php:901, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 28. eZImageAliasHandler->removeAliases() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/kernel/classes/datatypes/ezimage/ezimagetype.php:186, referer: http://ezp52.paulo/ezdemo_site_admin/ [Thu Jun 12 11:17:59 2014] [error] [client 192.168.2.69] PHP 29. eZImageAliasHandler->removeAliasFile() /var/www/html/ezp52/ezpublish5/ezpublish_legacy/kernel/classes/datatypes/ezimage/ezimagealiashandler.php:727, referer: http://ezp52.paulo/ezdemo_site_admin/ Steps of what i have done: As a normal costumer would do, fetched Ezpublish 5.2 from support.ez.no/downloads Installed an ezdemo without content package, with English (eng-GB) as default language and 9 other languages Installed all 5.2 service packs and ezdemo sp Create a class with 5 image attributes, untranslatable. Create a new object of that class in default language and uploaded image files Added a new version for each language, based on the default 'eng-GB' Created a copy of the object. Applied the patch stable-5.2 . Edited a new version on the copied object Published the new version It was on last step when the fatal error happened. If i remove the patch stable-5.2 , the fatal error no longer happen.
          Hide
          Paulo Nunes (Inactive) added a comment -

          QA Approved.

          On ezpublish 5.2, the issue was not very expressive. On master and 5.3, the "Total runtime" passed from around 9 second to 0.7 second. The number of Mysqli_queries also dropped from around 4000 to 400.

          Show
          Paulo Nunes (Inactive) added a comment - QA Approved. On ezpublish 5.2, the issue was not very expressive. On master and 5.3, the "Total runtime" passed from around 9 second to 0.7 second. The number of Mysqli_queries also dropped from around 4000 to 400.
          Hide
          Pedro Resende (Inactive) added a comment -

          Tested and approved by Q.A

          On ezpublish 5.0 and 5.1, the issue was not very expressive.
          On the provided 4.7 db the number of queries

          Show
          Pedro Resende (Inactive) added a comment - Tested and approved by Q.A On ezpublish 5.0 and 5.1, the issue was not very expressive. On the provided 4.7 db the number of queries
          Hide
          Nuno Oliveira (Inactive) added a comment -

          @team,

          According to customer, the 4.7 backport introduces a regression, where the alternative text field of an image attribute is not updated unless the file field is updated, too. I was able to verify this, and am now re-opening this issue, so that this is fixed.

          Steps to reproduce:

          1. Prepare a clean, fully patched installation of eZ Publish 4.7;
          2. On the admin interface, go to "Media library" and create an image. Add a name, file and alternative image text, and publish;
          3. Edit image, change alternative text, and publish;
          4. Re-edit image, and verify that alternative text was changed;

          5. Install 4.7 patch backport;
          6. Repeat steps 1-4. Alternative text is no longer updated unless you also update the file.

          Show
          Nuno Oliveira (Inactive) added a comment - @team, According to customer, the 4.7 backport introduces a regression, where the alternative text field of an image attribute is not updated unless the file field is updated, too. I was able to verify this, and am now re-opening this issue, so that this is fixed. Steps to reproduce: 1. Prepare a clean, fully patched installation of eZ Publish 4.7; 2. On the admin interface, go to "Media library" and create an image. Add a name, file and alternative image text, and publish; 3. Edit image, change alternative text, and publish; 4. Re-edit image, and verify that alternative text was changed; 5. Install 4.7 patch backport; 6. Repeat steps 1-4. Alternative text is no longer updated unless you also update the file.
          Hide
          Nuno Oliveira (Inactive) added a comment -
          Show
          Nuno Oliveira (Inactive) added a comment - Please refer to https://jira.ez.no/browse/EZP-23207 .
          Hide
          Pedro Resende (Inactive) added a comment -

          Tested and approved by Q.A.

          Show
          Pedro Resende (Inactive) added a comment - Tested and approved by Q.A.

            People

            • Assignee:
              Unassigned
              Reporter:
              Joao Inacio (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 3 days, 5 hours, 25 minutes
                3d 5h 25m

                  Agile