Integrity errors on host table when running multiple workflows against the same MySQL backend

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major
    • 3.1
    • Affects Version/s: 3.1
    • Component/s: None
    • None

      I get many of these when running multiple workflows at the same time, all logging to the same MySQL backend database.

      • wf_uuid : 43ba7161-4848-4f2e-92d8-df9488b79b6f
      • ip : 10.125.6.247
      • exec_job_id : stage_in_remote_Clemson_2
      • hostname : node1505.palmetto.clemson.edu
      • site : Clemson
      • ts : 1308864049.0
      • uname : linux-2.6.18-194.17.1.el5-x86_64
      • host_id : None
      • event : stampede.job_inst.host.info
        : (IntegrityError) (1062, \"Duplicate entry 'Clemson-node1505.palmetto.clemson.edu-10.125.6.247' for key 'UNIQUE_HOST'\") 'INSERT INTO host (site, hostname, ip, uname, total_memory) VALUES (%s, %s, %s, %s, %s)' ('Clemson', 'node1505.palmetto.clemson.edu', '10.125.6.247', 'linux-2.6.18-194.17.1.el5-x86_64', '33734758400')"

            Assignee:
            Fabio Silva
            Reporter:
            Mats Rynge [X] (Inactive)
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: