This is an automated email from the ASF dual-hosted git repository.

rawlin pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/trafficcontrol.git


The following commit(s) were added to refs/heads/master by this push:
     new 32d6e1854a Fix Internal Server Error in (#6935)
32d6e1854a is described below

commit 32d6e1854a986aa1a16256f45c9e9dc415caa673
Author: Srijeet Chatterjee <[email protected]>
AuthorDate: Wed Jun 29 12:11:20 2022 -0600

    Fix Internal Server Error in (#6935)
---
 CHANGELOG.md                                           | 1 +
 traffic_ops/traffic_ops_golang/dbhelpers/db_helpers.go | 2 +-
 2 files changed, 2 insertions(+), 1 deletion(-)

diff --git a/CHANGELOG.md b/CHANGELOG.md
index b401e7b424..3834cb1efd 100644
--- a/CHANGELOG.md
+++ b/CHANGELOG.md
@@ -60,6 +60,7 @@ The format is based on [Keep a 
Changelog](http://keepachangelog.com/en/1.0.0/).
 - [#6712](https://github.com/apache/trafficcontrol/issues/6712) - Fixed error 
when loading the Traffic Vault schema from `create_tables.sql` more than once.
 - [#6834](https://github.com/apache/trafficcontrol/issues/6834) - In API 4.0, 
fixed `GET` for `/servers` to display all profiles irrespective of the index 
position. Also, replaced query param `profileId` with `profileName`.
 - [#6299](https://github.com/apache/trafficcontrol/issues/6299) User 
representations don't match
+- [#6896](https://github.com/apache/trafficcontrol/issues/6896) Fixed the 
`POST api/cachegroups/id/queue_updates` endpoint so that it doesn't give an 
internal server error anymore.
 - [#6933](https://github.com/apache/trafficcontrol/issues/6933) Fixed 
tc-health-client to handle credentials files with special characters in 
variables
 - [#6776](https://github.com/apache/trafficcontrol/issues/6776) User 
properties only required sometimes
 
diff --git a/traffic_ops/traffic_ops_golang/dbhelpers/db_helpers.go 
b/traffic_ops/traffic_ops_golang/dbhelpers/db_helpers.go
index d4c34ef63b..3e0b508390 100644
--- a/traffic_ops/traffic_ops_golang/dbhelpers/db_helpers.go
+++ b/traffic_ops/traffic_ops_golang/dbhelpers/db_helpers.go
@@ -1921,7 +1921,7 @@ UPDATE public.server
 SET config_update_time = config_apply_time
 WHERE server.cachegroup = $1
 AND server.cdn_id = $2
-RETURNING (SELECT s.host_name FROM "server" s WHERE s.id = server_id);`
+RETURNING server.host_name;`
        rows, err := tx.Query(q, cgID, cdnID)
        if err != nil {
                return nil, fmt.Errorf("querying queue updates: %w", err)

Reply via email to