SICSR-16616
| [SICSR-16616] SICS Naming Service - hanging sessions | |
|---|---|
| Product Line: | P&C |
| Component/s: | Database Setup |
| Affects Version/s: | SICS 4.7 SSP16 |
| Fix Version/s: | SICS 20.1 |
| Customer: | Sirius International Insurance Corporation |
| External Issue ID: | SCR-264 |
Problem:
DBAs found that SICS Naming leaves ghost / hanging database sessions. These sessions occupy memory in tempdb and SQL server version store fills up as long as these sessions exists. If the sessions are open forever they ultimately cause a disk full error.
Solution:
Wrap all transactions in try-finally structures where the 'finally' block will do a rollback of the transaction if necessary (i.e. if the commit of the transaction failed for some reason).