One example, which I heard about in Dan Carlin's Hardcore History podcast (disclaimer, he's not a historian and sometimes prefers good story telling to historical accuracy and uncertainty), is from the siege of Münster (Germany, not Ireland) in 1534.
The story goes that the Prince-Bishop leading the siege planned to attack at sunrise on the morning of the 26th May. But the previous afternoon some of the soldiers were drinking heavily, and as the sun was going down they mistook the sunset for the sunrise, and thought they were going to miss out on their share of the loot in the pillaging of the city. So they charged the city walls. This precipitated a chain reaction that dragged the rest of the attacking army in to the fray in the darkness add the sun went down. The disorganised, impromptu (and accidental) attack, with the added confusion of darkness, was a total failure.
Consequently, rather than successfully storming the city on the 26th May, the siege dragged on for another few months.
(Spoiler alert: it didn't end well for the Münster Anabaptist rebellion).
A source for this can be found in "A History of the Münster Anabaptist" by Friedrich Reck-Malleczewen, although there are probably earlier sources that he uses if you speak German (very little in English on this). See page 62, which you can find online at google book