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

Async pub: old processes are filling up the database

    XMLWordPrintable

    Details

      Description

      the async script fills up the ezpublishingqueueprocesses table with rows such as:

      created ezcontentobject_version_id finished pid started status
      1398330367 2225 1398330370 0 1398330367 2

      these rows represent finished processes, yet they keep filling up the table, with examples of 1 million rows in production servers.

      eventually they cause slow queries and performance slowness while running the cronjob.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            paulo.bras@ez.no Paulo Bras (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 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 - 15 minutes
                15m