You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafficcontrol.apache.org by GitBox <gi...@apache.org> on 2023/01/18 17:37:49 UTC

[GitHub] [trafficcontrol] srijeet0406 commented on a diff in pull request #7294: Fix Internal Server Error when GETting sslkeys_expirations endpoint

srijeet0406 commented on code in PR #7294:
URL: https://github.com/apache/trafficcontrol/pull/7294#discussion_r1073857066


##########
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'"

Review Comment:
   You're right. It should be INACTIVE OR PRIMED. I've changed it.



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@trafficcontrol.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org