Talk of strange software problems reminded me of the strangest problem one of our projects at work ever ran into, in production. The application was slow on Wednesdays, but only if it rained.
Here's a hint: The database was restarted around midnight every day. This was a long time ago.
The explanation involved a mother with a child that went to some early morning thing on Wednesdays and when it rained, the mother drove the child. Which meant that the mother arrived later at the office than usual. Which meant that she didn't call up her favourite reports first thing in the morning. Which meant that the database didn't cache the execution plans that were "good for everybody" apparently but the ones optimised for some other random dude whose execution plans were lousy. And so the database got off to a bad start on Wednesdays if it rained.
I don't know how they ever figured this one out. What a nightmare. It ended up in our internal Oracle database training for many years. These days, almost everybody uses PostgreSQL.
reshared this
)
Andre Louis
in reply to Drew Mochak • • •Drew Mochak
in reply to Andre Louis • • •