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