issue_details_raw: DHS-103
This data as json
| key | raw |
|---|---|
| DHS-103 | {"expand":"renderedFields,names,schema,operations,editmeta,changelog,versionedRepresentations","id":"111357","self":"https://traditionasia.atlassian.net/rest/api/3/issue/111357","key":"DHS-103","fields":{"statuscategorychangedate":"2024-11-21T05:53:25.529+0300","issuetype":{"self":"https://traditionasia.atlassian.net/rest/api/3/issuetype/10313","id":"10313","description":"A small, distinct piece of work.","iconUrl":"https://traditionasia.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/11718?size=medium","name":"Task","subtask":false,"avatarId":11718,"entityId":"f8b7c0e2-21aa-496e-930c-f34c1e9668fe","hierarchyLevel":0},"components":[],"timespent":null,"timeoriginalestimate":null,"project":{"self":"https://traditionasia.atlassian.net/rest/api/3/project/11705","id":"11705","key":"DHS","name":"Date and Holiday Services","projectTypeKey":"software","simplified":true,"avatarUrls":{"48x48":"https://traditionasia.atlassian.net/rest/api/3/universal_avatar/view/type/project/avatar/12916","24x24":"https://traditionasia.atlassian.net/rest/api/3/universal_avatar/view/type/project/avatar/12916?size=small","16x16":"https://traditionasia.atlassian.net/rest/api/3/universal_avatar/view/type/project/avatar/12916?size=xsmall","32x32":"https://traditionasia.atlassian.net/rest/api/3/universal_avatar/view/type/project/avatar/12916?size=medium"}},"description":{"type":"doc","version":1,"content":[{"type":"paragraph","content":[{"type":"text","text":"This issue is occurring due to the "},{"type":"text","text":"rds.force_ssl","marks":[{"type":"code"}]},{"type":"text","text":" parameter change on the database."}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"type":"text","text":"The default value of the "},{"type":"text","text":"rds.force_ssl","marks":[{"type":"code"}]},{"type":"text","text":" parameter is "},{"type":"text","text":"1 (on)","marks":[{"type":"strong"}]},{"type":"text","text":" for RDS for PostgreSQL version 15 and later. For RDS for PostgreSQL versions 14 and older, the default value is "},{"type":"text","text":"0 (off)","marks":[{"type":"strong"}]},{"type":"text","text":"."}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"type":"text","text":"Since we upgraded "},{"type":"text","text":"utcfxtestdb","marks":[{"type":"code"}]},{"type":"text","text":" (including dev and uat) to version 16.3, the parameter is now set to "},{"type":"text","text":"1 (on)","marks":[{"type":"strong"}]},{"type":"text","text":"."}]}]}]},{"type":"paragraph","content":[{"type":"text","text":"To resolve this issue, the "},{"type":"text","text":"sslmode","marks":[{"type":"code"}]},{"type":"text","text":" parameter must be included in the database connection string. The required setting should solve the problem."},{"type":"hardBreak"},{"type":"text","text":"Connecting databases with SSL","marks":[{"type":"link","attrs":{"href":"https://traditionasia.atlassian.net/wiki/spaces/ops/pages/3038773260/Connecting+databases+with+SSL"}}]}]},{"type":"paragraph","content":[{"type":"text","text":"Error log:","marks":[{"type":"strong"}]},{"type":"text","text":" "},{"type":"text","text":"no pg_hba.conf entry for host \"10.193.58.208\", user \"holidayserviceuser\", database \"utcfxtestdb\", no encryption","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"type":"text","text":"Kibana logs:","marks":[{"type":"strong"}]},{"type":"text","text":" "},{"type":"text","text":"logs","marks":[{"type":"link","attrs":{"href":"https://vpc-ctc-es6-dev-6fpc67kgyjy3ywqd4sygy3xfra.eu-central-1.es.amazonaws.com/_plugin/kibana/app/kibana#/discover?_g=(refreshInterval:(pause:!t,value:0),time:(from:now-24h,mode:quick,to:now))&_a=(columns:!(log,log_processed.message),filters:!(('$state':(store:appState),meta:(alias:!n,disabled:!f,index:ctc-app-logs,key:kubernetes.namespace_name,negate:!f,params:(query:tfx-test,type:phrase),type:phrase,value:tfx-test),query:(match:(kubernetes.namespace_name:(query:tfx-test,type:phrase))))),index:ctc-app-logs,interval:auto,query:(language:lucene,query:'%22no%20encryption%22'),sort:!('@timestamp',desc))"}}]}]},{"type":"paragraph","content":[{"type":"text","text":"Additionally, the health check does not validate database connectivity, which causes pods to appear healthy even when the service cannot connect to the database. We expect the service to be marked as unhealthy if it cannot establish a connection to the database."},{"type":"hardBreak"},{"type":"hardBreak"},{"type":"text","text":"ArgoCD: "},{"type":"text","text":"utc-holiday-service","marks":[{"type":"link","attrs":{"href":"https://argocd.traditionasia-istanbul.com/applications/utc-holiday-service-test?resource="}}]},{"type":"hardBreak"},{"type":"hardBreak"},{"type":"text","text":"This issue is present in "},{"type":"text","text":"dev","marks":[{"type":"strong"}]},{"type":"text","text":", "},{"type":"text","text":"test","marks":[{"type":"strong"}]},{"type":"text","text":", and "},{"type":"text","text":"uat","marks":[{"type":"strong"}]},{"type":"text","text":" environments."}]}]},"fixVersions":[],"aggregatetimespent":null,"statusCategory":{"self":"https://traditionasia.atlassian.net/rest/api/3/statuscategory/3","id":3,"key":"done","colorName":"green","name":"Done"},"resolution":{"self":"https://traditionasia.atlassian.net/rest/api/3/resolution/10000","id":"10000","description":"Work has been completed on this issue.","name":"Done"},"customfield_11642":null,"timetracking":{},"security":null,"attachment":[],"aggregatetimeestimate":null,"resolutiondate":"2024-11-21T05:53:25.525+0300","workratio":-1,"summary":"Database Connectivity Issues Due to SSL Parameter Change and Health Check Validation - utc-holiday-service","issuerestriction":{"issuerestrictions":{},"shouldDisplay":true},"watches":{"self":"https://traditionasia.atlassian.net/rest/api/3/issue/DHS-103/watchers","watchCount":1,"isWatching":false},"lastViewed":null,"creator":{"self":"https://traditionasia.atlassian.net/rest/api/3/user?accountId=63933fcafde064eda2f305ee","accountId":"63933fcafde064eda2f305ee","emailAddress":"noyan.yesilkaya@traditionasia.com","avatarUrls":{"48x48":"https://secure.gravatar.com/avatar/f05f898c7e93193a519583b3ada8a9dc?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FNY-0.png","24x24":"https://secure.gravatar.com/avatar/f05f898c7e93193a519583b3ada8a9dc?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FNY-0.png","16x16":"https://secure.gravatar.com/avatar/f05f898c7e93193a519583b3ada8a9dc?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FNY-0.png","32x32":"https://secure.gravatar.com/avatar/f05f898c7e93193a519583b3ada8a9dc?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FNY-0.png"},"displayName":"Noyan Yeşilkaya","active":true,"timeZone":"Europe/Minsk","accountType":"atlassian"},"subtasks":[{"id":"111372","key":"DHS-104","self":"https://traditionasia.atlassian.net/rest/api/3/issue/111372","fields":{"summary":"Update database connection string","status":{"self":"https://traditionasia.atlassian.net/rest/api/3/status/10512","description":"","iconUrl":"https://traditionasia.atlassian.net/","name":"Done","id":"10512","statusCategory":{"self":"https://traditionasia.atlassian.net/rest/api/3/statuscategory/3","id":3,"key":"done","colorName":"green","name":"Done"}},"priority":{"self":"https://traditionasia.atlassian.net/rest/api/3/priority/3","iconUrl":"https://traditionasia.atlassian.net/images/icons/priorities/major_new.svg","name":"3. Medium","id":"3"},"issuetype":{"self":"https://traditionasia.atlassian.net/rest/api/3/issuetype/10315","id":"10315","description":"Subtasks track small pieces of work that are part of a larger task.","iconUrl":"https://traditionasia.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/11716?size=medium","name":"Subtask","subtask":true,"avatarId":11716,"entityId":"78aefbc5-bf66-49e0-9812-5b48a5bbefab","hierarchyLevel":-1}}},{"id":"111373","key":"DHS-105","self":"https://traditionasia.atlassian.net/rest/api/3/issue/111373","fields":{"summary":"Update health check process","status":{"self":"https://traditionasia.atlassian.net/rest/api/3/status/10512","description":"","iconUrl":"https://traditionasia.atlassian.net/","name":"Done","id":"10512","statusCategory":{"self":"https://traditionasia.atlassian.net/rest/api/3/statuscategory/3","id":3,"key":"done","colorName":"green","name":"Done"}},"priority":{"self":"https://traditionasia.atlassian.net/rest/api/3/priority/3","iconUrl":"https://traditionasia.atlassian.net/images/icons/priorities/major_new.svg","name":"3. Medium","id":"3"},"issuetype":{"self":"https://traditionasia.atlassian.net/rest/api/3/issuetype/10315","id":"10315","description":"Subtasks track small pieces of work that are part of a larger task.","iconUrl":"https://traditionasia.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/11716?size=medium","name":"Subtask","subtask":true,"avatarId":11716,"entityId":"78aefbc5-bf66-49e0-9812-5b48a5bbefab","hierarchyLevel":-1}}}],"created":"2024-11-20T11:29:40.835+0300","customfield_11110":"1|hzqxp3:","reporter":{"self":"https://traditionasia.atlassian.net/rest/api/3/user?accountId=63933fcafde064eda2f305ee","accountId":"63933fcafde064eda2f305ee","emailAddress":"noyan.yesilkaya@traditionasia.com","avatarUrls":{"48x48":"https://secure.gravatar.com/avatar/f05f898c7e93193a519583b3ada8a9dc?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FNY-0.png","24x24":"https://secure.gravatar.com/avatar/f05f898c7e93193a519583b3ada8a9dc?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FNY-0.png","16x16":"https://secure.gravatar.com/avatar/f05f898c7e93193a519583b3ada8a9dc?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FNY-0.png","32x32":"https://secure.gravatar.com/avatar/f05f898c7e93193a519583b3ada8a9dc?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FNY-0.png"},"displayName":"Noyan Yeşilkaya","active":true,"timeZone":"Europe/Minsk","accountType":"atlassian"},"aggregateprogress":{"progress":0,"total":0},"priority":{"self":"https://traditionasia.atlassian.net/rest/api/3/priority/3","iconUrl":"https://traditionasia.atlassian.net/images/icons/priorities/major_new.svg","name":"3. Medium","id":"3"},"labels":[],"customfield_11016":null,"environment":null,"customfield_11602":null,"timeestimate":null,"aggregatetimeoriginalestimate":null,"versions":[],"duedate":null,"progress":{"progress":0,"total":0},"issuelinks":[],"votes":{"self":"https://traditionasia.atlassian.net/rest/api/3/issue/DHS-103/votes","votes":0,"hasVoted":false},"comment":{"comments":[],"self":"https://traditionasia.atlassian.net/rest/api/3/issue/111357/comment","maxResults":0,"total":0,"startAt":0},"assignee":null,"worklog":{"startAt":0,"maxResults":20,"total":0,"worklogs":[]},"updated":"2024-11-21T05:53:25.528+0300","status":{"self":"https://traditionasia.atlassian.net/rest/api/3/status/10512","description":"","iconUrl":"https://traditionasia.atlassian.net/","name":"Done","id":"10512","statusCategory":{"self":"https://traditionasia.atlassian.net/rest/api/3/statuscategory/3","id":3,"key":"done","colorName":"green","name":"Done"}}}} |