CRM-8845 civicrm_import_job_* mysql tables should be cleared if the import is cancelled

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Won't Fix
    • Affects Version/s: 4.0.5
    • Fix Version/s: 4.4.0
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      When using the import tool, after the first step, a table civicrm_import_job is created in the database.
      If you cancel the import, this table still exists in the database, it potentially highly increases the size of the database.

      When common users uses this import tool to keep synchronization with another software, they often cancel their import for many reasons (forgot to export a field or used the wrong file ...) causing the database to blow up.... to a critical point.

      Cancelling should result in a full cleaning of temp datas.

        Attachments

          Activity

          [CRM-8845] civicrm_import_job_* mysql tables should be cleared if the import is cancelled
          Donald A. Lobo added a comment -

          Note that, we currently:

          1. clean up all temp tables during the upgrade

          2. we also cleanup exisiting temp table on a probabilistic basis every time someone runs an import (since sometimes folks dont cancel the import, they just close the browser)

          if you can investigate and submit the patch that would be great

          Donald A. Lobo added a comment -


          Closing issues in batch on 4/16/13 since these issues have not been worked on in a long long time

            People

            • Assignee:
              Donald A. Lobo
              Reporter:
              tonthon

              Dates

              • Created:
                Updated:
                Resolved: