•  
      request #28850 consistency is not guaranteed in tracker report query when a field is deleted
    Infos
    #28850
    Marie Ange Garnier (marieange)
    2022-10-11 12:04
    2022-09-20 17:41
    30411
    Details
    consistency is not guaranteed in tracker report query when a field is deleted

    When a field is removed, then sql errors might occur

    for each part of sql building query we should ensure that field is effectively used

    [13-Sep-2022 08:50:00] WARNING: [pool tuleap] child 37178 said into stderr: "NOTICE: PHP message: PHP Notice:  Error encountered while retrieving data ==>  SELECT a.id AS id, c.id AS changeset_id , R2_37554.value AS `user_defined_date_de_fin_estime` FROM tracker_artifact AS a INNER JOIN tracker_changeset AS c ON (c.artifact_id = a.id) LEFT JOIN ( tracker_changeset_value AS R1_37554"
    [13-Sep-2022 08:50:00] WARNING: [pool tuleap] child 37178 said into stderr: "                    INNER JOIN tracker_changeset_value_date AS R2_37554 ON (R2_37554.changeset_value_id = R1_37554.id)"
    [13-Sep-2022 08:50:00] WARNING: [pool tuleap] child 37178 said into stderr: "                ) ON (R1_37554.changeset_id = c.id AND R1_37554.field_id = 37554 ) WHERE c.id IN (1)  GROUP BY id  ORDER BY `user_defined_title` ASC @@ /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php at line 119 in /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php on line 220"
    
    Trackers
    Empty
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Marie Ange Garnier (marieange)
    Closed
    2022-10-11
    Attachments
    Empty
    References

    Follow-ups

    User avatar

    gerrit #26766 (consistency is not guaranteed in tracker report query when a field is deleted) integrated in Tuleap 14.0.99.37

    I confirm it generates a 502 on project dashboards but not on personal dashboards 🤷

    User avatar
    • Summary
      -consistency is not guaranteed in tracker report query 
      +consistency is not guaranteed in tracker report query when a field is deleted 
    User avatar
    • Original Submission
      Something went wrong, the follow up content couldn't be loaded
      Only formatting have been changed, you should switch to markup to see the changes