Fog Creek Software
Discussion Board

Firehose mode

For some reason that we can't figure out, our SQL Server occasionally goes into single user mode, and then FogBUGZ won't serve--we get an error message about the server being in "firehose mode."

I mentioned this to Michael briefly in early April, but we were not able to resolve it.  Web searches for this error reference conditions that apparently don't apply.

I was wondering if this is anything you might have run into since then.  Any advice or suggestions?

Chris Dunford
Monday, May 20, 2002

I think this is a result of opening a transaction and then killing the process before the transaction is closed.

I think either or both of these might help:
a) restart IIS -> right click on the computer icon from Internet Services Manager and choose restart, then click "End Now".
b) restart SQL server

Michael Pryor
Monday, May 20, 2002

*  Recent Topics

*  Fog Creek Home