Journal #249 – Work was both good and bad, learnt something new

When I went office this morning, I was feeling tired and irritable. That’s even after I started coffee and waited for the caffeine to kick in. So that was definitely not caffeine-deprivation.

So I went through my morning feeling pretty angsty and went about doing my task. I did try my best to control my emotions from going out of control.

In hindsight, I suspect it was actually depression masquerading as irritation as described in this article.

At around lunch time, I decided to go for lunch at Ichiban Sushi for some sashimi. After lunch, I continue about converting the existing implementations to use the new web service and fixing any regressions. However, the server backend keep dying caused by overused threads in the application pool, so it wasn’t really productive.

My colleagues did later find out what was causing the IIS threads to be overused and stuck, preventing the server from responding to further requests. It was due to a problem with the way Linq was used to query the database. We didn’t know about deferred and eager execution, at least in the context of database and entity framework. Eager execution only happens under certain scenarios like when you execute “.ToList()”. While deferred execution seems to be the default operation.

So that is one new thing that I learn about at work today.

The second new thing that I learn about was how SoapUI behave when attempting to download WSDL files that has its XMLNS defined and the system running SoapUI do not have any access to the internet. It turns out SoapUI will throw UnknownHostException. One possible solution was to download the WSDl file.