Majoru Oakheart
Adventurer
Yeah. I tried that once already. This is the second blow up from this player. Our Sunday group used to be ran by me. I ran an adventure that had a murder mystery in it. I didn't write the adventure, it was by wotc. Either way, the adventure doesn't give you enough information to solve the mystery at the beginning of the adventure. You can guess but some of the clues that can prove it simply aren't available. The the adventure distracts the pcs by giving them a more pressing problem to deal with. The player in question refused to give up on the murder mystery. He insisted that there must be an answer and he was going to talk to every npc they had spoken to again and again until he rolled high enough insight checks to figure out which one was lying. He was going to break into everyone's houses if he needed to until he found a real clue. The rest of the party tried to convince him to put that aside for now since goblins were attacking a nearby town but he refused saying that it was obvious they must have missed something or made a bad roll because they were MEANT to solve this puzzle and he was going to do it.If you decide to talk about the situation with the player as others have suggested (I support this suggestion, if only to get it off your chest) it might help to explain that failure is one way to advance the game and that it doesn't mean that he has 'lost' at D&D.
I had to step out of character and say "sorry, I didn't write the adventure but as written it is nearly impossible to solve this murder without getting some of the information you find out later in the adventure. So, you didn't miss anything, you just aren't supposed to solve that murder right now. Sometimes you don't always succeed at something immediately and need to wait for more information."
This made him so pissed off that he threatened to stop playing the game on the spot because "how could an author write something so stupid? They give us a problem and they don't expect us to solve it?"
Given his propensity to complain about the difficulty of every encounter as well as complaining every time I set a DC higher than 10 and now his threatening to leave the game because he couldn't immediately win, I lost my temper and told him that if that was going to be his attitude that I wasn't running a game any more. I spent hours preparing and adventure only to hear constant complaining. I'd play but I wasn't running any more. That's when his gf took over DMing.