Connection issue to database
Resolved
Jan 11 at 01:16pm WIB
Status: Resolved
Summary: All our Integration API, Wallet API down due to bugs
Impact: All request through Integration API, Delivery order and Merchant link experience timeout
Trigger: A condition in the source code open a connection but fail to close it after the condition ended.
Root cause:
We had schedule release this morning at 12am - 3am. After the release all test was done and no major issue detected. But when the real traffic coming around 7am the team get alerted of login and timeout issue. The initial suspect was the networking issue but team alerted that many connection to database fail. Normally that happen when we have large unexpected traffic. But no big traffic identified by the team.
In Parallel, another team spotted many connection to database has been opened but not close. The team then focus on identifying the code those created the issue and found the connection leak happen on certain condition only. The code was rectified and deployed to production.
Lesson learned:
Engineering team updated the Sinful Script to the team so it does not repeat again.
Affected services
Updated
Jan 11 at 11:29am WIB
We've resolved the issue, all service are up.
Affected services
Updated
Jan 11 at 10:47am WIB
Issue has been resolved. The team is monitoring the fixes. This ticket will still be open for update
Affected services
Updated
Jan 11 at 10:36am WIB
Update: the root cause is from client application opening database transaction but failed to closed it, resulting in new database connection timed out and affecting the bridge and order API. Currently we're deploying the fix to resolve this issue.
Affected services
Updated
Jan 11 at 10:24am WIB
There is a possible memory leak on the core system deployed this morning causing connection issue to our database. The team is working on the issue.
Affected services
Updated
Jan 11 at 10:06am WIB
Issue has been identified. There are connection issue from our core system to database on some of the instance.
Affected services
Updated
Jan 11 at 07:59am WIB
Dashboard is up and running
Affected services
Created
Jan 11 at 07:52am WIB
There maybe a case where user cannot login to Wallet apps, web, AVBO and Dashboard as our Auth system is having a problem at the moment
Affected services