4 ms·
I haven't ever hurt myself with my own code, but I have done the reverse. I work on COVID research, and one of the programs I maintain involves pulling the data
by rcthompson 5y ago
I haven't ever hurt myself with my own code, but I have done the reverse. I work on COVID research, and one of the programs I maintain involves pulling the data on all our the COVID patients and vaccine recipients enrolled in our study. One day, it was my turn to get the vaccine, and I also volunteered to enroll in the study myself. However, they were unable to find a vein to take a blood sample, so my enrollment was cancelled. After I received the vaccine, I went back to my home office and continued working on my program, which immediately crashed.
I drilled down on the offending database record, looking in the demographic data to see if something was wrong. After staring at it for a few moments, I realized that the demographic data looked... familiar. And then it hit me: my own enrollment record from that day had been left in an inconsistent state in the database that my program was pulling the study data from, due to the failure to collect a blood sample. This resulted in my program crashing on the inconsistent data. So I had to add a special case to my program to handle my own failed study enrollment from earlier that same day.