I had a strange mood dwarf that asked for, in order: Metal bars, cut gems, plant cloth, wood, rough gems, rough green glass, rough clear glass.
Short version: It seems to be possible that a strange mood rough gem demand that happens to grab a piece of rough glass can break a strange mood.
Possibly relevant information: I happened to save the game after he'd collected metal bars and cut gems. I didn't have any plant cloth at the time, but I sent my herbalist to gather to find some rope reeds. In the meantime I built the glass industry buildings and made both rough clear glass and rough green glass. Eventually I made some plant cloth. The strange mood dwarf collected it, then gathered a log, and then he picked up the rough clear glass and then the rough green glass, then became stuck again. Ok, I thought, "I guess the rough gems demand just picked up the nearest gem, which happened to be the clear glass", so I made another rough clear glass to satisfy his final request - but he didn't move to pick it up, even though it was not tasked or forbidden. I then mined several other rough gems, thinking I had somehow skipped over the rough gem request, but he wouldn't move for any of them.
I decided to close the program and reload from my save because I suspected there was a bug involved. This time I decided I would wait until the strange mood dwarf had gathered everything besides the two pieces of glass before I actually made the rough glass. This time after collecting the wood he moved on to his rough gem request and retrieved the nearest gem, which happened to be a wood opal. I then created both pieces of rough glass, which he then collected. He then began construction normally. There were plenty of wood opals available in the first scenario, so I think something funny was clearly involved.