Really annoying when it happens, although I've always found it possible to click ok in the alert box, and hammer ctrl+w(to close the tab) and it usually works. Sometimes it takes a bunch of ok->ctrl+w combinations before it takes, but it works. Good with a real fix for it though.

I just hope it will make the basic auth username/password-boxes tab-modal as well.