This is an automated email from the ASF dual-hosted git repository.
ocket8888 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 0a30f458ac Fix Internal Server Error when GETting sslkey_expirations
endpoint (#7294)
0a30f458ac is described below
commit 0a30f458ac0ff2ca4e653cae01b81cb39aa5a06e
Author: Srijeet Chatterjee <[email protected]>
AuthorDate: Fri Jan 20 00:34:13 2023 -0700
Fix Internal Server Error when GETting sslkey_expirations endpoint (#7294)
* Fix ISE when GETting sslkeys_expirations endpoint
* code review
* removing changelog
---
.../traffic_ops_golang/trafficvault/backends/postgres/postgres.go | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git
a/traffic_ops/traffic_ops_golang/trafficvault/backends/postgres/postgres.go
b/traffic_ops/traffic_ops_golang/trafficvault/backends/postgres/postgres.go
index f537a8ad55..b1bdc1b394 100644
--- a/traffic_ops/traffic_ops_golang/trafficvault/backends/postgres/postgres.go
+++ b/traffic_ops/traffic_ops_golang/trafficvault/backends/postgres/postgres.go
@@ -180,7 +180,7 @@ func (p *Postgres) GetExpirationInformation(tx *sql.Tx, ctx
context.Context, day
fedMap[fedString] = true
}
- inactiveQuery := "SELECT xml_id FROM deliveryservice WHERE NOT active"
+ inactiveQuery := "SELECT xml_id FROM deliveryservice WHERE active =
'INACTIVE' OR active = 'PRIMED'"
iaRows, err := tx.Query(inactiveQuery)
if err != nil {
return []tc.SSLKeyExpirationInformation{}, err
