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

Backoffice - lock and wait for xxx seconds a lot of times every day

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: High High
    • 4.7.0alpha1
    • 2011.10, 4.5.0, 4.6.0beta1, 4.6.0
    • Legacy > Clustering
    • None
    • eZ Publish 4.5
      eZ DFS cluster mode
      Filer under FreeBSD (contains all NFS files)

    Description

      Hi,

      We have a problem with eZ publish backoffice. 5 to 10 times a day, the backoffice freeze for about 60 seconds.

      The http request to the backoffice is waiting for xxx seconds and, ended up working.

      This error seems to log in this file : wwwroot/var/log/error.log

      ------------------------

      [ Oct 19 2011 11:00:21 ] [127.0.0.1] eZImageManager::createImageAlias:
      Failed creating the referenced alias reference, cannot create alias small
      [ Oct 19 2011 11:00:39 ] [127.0.0.1] _endCacheGeneration( var/plain_site/cache/template-block/4/2/2/4222742554.cache ):
      Failed to execute SQL for function:
      1062: Duplicate entry '1149a5231755f585477d3f0aae1fb38b' for key 'PRIMARY'
      [ Oct 19 2011 11:00:39 ] [127.0.0.1] _endCacheGeneration( var/plain_site/cache/template-block/4/2/2/4222742554.cache ):
      An error occured creating the metadata entry for var/plain_site/cache/template-block/4/2/2/4222742554.cache
      [ Oct 19 2011 11:00:44 ] [127.0.0.1] _endCacheGeneration( var/plain_site/cache/template-block/4/2/2/4222742554.cache ):
      Failed to execute SQL for function:
      1062: Duplicate entry '1149a5231755f585477d3f0aae1fb38b' for key 'PRIMARY'
      [ Oct 19 2011 11:00:44 ] [127.0.0.1] _endCacheGeneration( var/plain_site/cache/template-block/4/2/2/4222742554.cache ):
      An error occured creating the metadata entry for var/plain_site/cache/template-block/4/2/2/4222742554.cache
      [ Oct 19 2011 11:00:45 ] [127.0.0.1] eZContentObject::fetch:
      Object not found ()
      

      ------------------------

      [ oct. 19 2011 11:14:18 ] [] _deleteByDirList(Array, var/plain_site/cache/content, 3/4/7/9/347918-):
      Failed to execute SQL for function:
      1213: Deadlock found when trying to get lock; try restarting transaction
      [ oct. 19 2011 11:14:18 ] [] eZDFSFileHandlerMySQLiBackend::_deleteByDirListInner:
      Failed to delete files in dir: 'var/plain_site/cache/content/administrer/3/4/7/9/347918-%'
      [ oct. 19 2011 11:14:18 ] [] eZDBInterface::commit:
      No transaction in progress, cannot commit
      [ oct. 19 2011 11:14:18 ] [] eZDBInterface::commit:
      No transaction in progress, cannot commit
      [ oct. 19 2011 11:14:18 ] [] eZDBInterface::commit:
      No transaction in progress, cannot commit
      [ oct. 19 2011 11:14:18 ] [] eZDBInterface::commit:
      No transaction in progress, cannot commit
      [ Oct 19 2011 11:14:19 ] [127.0.0.1] _endCacheGeneration( var/plain_site/cache/template-block/4/7/0/470053430.cache ):
      Failed to execute SQL for function:
      1213: Deadlock found when trying to get lock; try restarting transaction
      [ Oct 19 2011 11:14:19 ] [127.0.0.1] _endCacheGeneration( var/plain_site/cache/template-block/4/7/0/470053430.cache ):
      An error occured creating the metadata entry for var/plain_site/cache/template-block/4/7/0/470053430.cache
      

      --------------------------------

      [ Oct 19 2011 11:19:36 ] [127.0.0.1] _endCacheGeneration( var/plain_site/cache/template-block/3/0/6/3067621245.cache ):
      Failed to execute SQL for function:
      1213: Deadlock found when trying to get lock; try restarting transaction
      [ Oct 19 2011 11:19:36 ] [127.0.0.1] _endCacheGeneration( var/plain_site/cache/template-block/3/0/6/3067621245.cache ):
      An error occured creating the metadata entry for var/plain_site/cache/template-block/3/0/6/3067621245.cache
      [ Oct 19 2011 11:20:24 ] [127.0.0.1] eZContentObject::fetch:
      Object not found ()
      

      ------------------------

      Is it a eZ DFS cluster issue ? How can we solve it ?

      Attachments

        Activity

          People

            jv@ez.no jv@ez.no
            rc@ez.no rc@ez.no
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: