Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: fts 3.4.7
    • Fix Version/s: fts 3.6.0
    • Component/s: MySQL
    • Security Level: Public Data (This ticket is visible to anyone on the internet and will be indexed by search engines)
    • Labels:
      None

      Description

      getFilesForStaging

       SELECT f.source_surl, f.job_id, f.file_id, j.copy_pin_lifetime, j.bring_online,
         j.user_dn, j.cred_id, j.source_space_token 
       FROM t_file f, t_job j 
       WHERE f.job_id = j.job_id 
         AND (j.BRING_ONLINE >= 0 OR j.COPY_PIN_LIFETIME >= 0) 
         AND f.start_time IS NULL AND f.file_state = 'STAGING'
         AND (f.hashed_id >= :hStart AND f.hashed_id <= :hEnd) 
         AND f.source_se = :source_se 
         AND j.user_dn = :user_dn 
         AND j.vo_name = :vo_name 
         AND f.vo_name = j.vo_name 
         AND f.job_finished IS NULL 
         AND NOT EXISTS ( 
             SELECT 
                 1 FROM t_file f1 
             WHERE 
                 f1.source_surl = f.source_surl AND f1.file_state='STARTED' 
                 AND f1.vo_name = f.vo_name AND f1.job_finished IS NULL 
                 AND f1.source_se = f.source_se
         ) 
        LIMIT :limit
      

      When this query clashes with a backup, the db chokes

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                aalvarez Alejandro Alvarez Ayllon
                Reporter:
                aalvarez Alejandro Alvarez Ayllon
                Component Watchers:
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Actual Start: