Tuleap Community Edition development and releases are no longer public. You have until September 30th to download packages and sources in Tuleap project. You can contact the team if you need further assistance.

    •  
      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
    30434
    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
    Referenced by request #28850

    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