DEV Community

Discussion on: 🍿What was the most remarkable πŸ¦— bug you have ever had to fix πŸ‘©β€πŸ”§?

shiraazm profile image
Shiraaz Moollatjie

During the start of my 2nd job, there was this one bug at a customer's site where we would generate corrupted sql load files. We used load files because this was a legacy application (VB.NET I think) and sql load files were faster in this use case.

This application ran as a Windows service. Turns out the reason why it generated corrupted load files was that it was running two instances of the service and the one process was overwriting the other process's file data. It took 3 business days and a weekend for me to figure this out since I had no experience with this legacy application and couldn't reproduce anything. Pretty proud that I could debug this VB.NET app as a Java Engineer during that part of my life.