Mink Machine

Firehoses in SQL Server

While modifying rows manually in a database with Enterprise Manager in SQL Server 2000, one may get this exciting error message: "Transaction cannot start while in firehose mode"

Firehose error message Clear as mud.

Even though this is better than “Error=47”, I think it would be nice with a bit more information since I assume that not all database workers are fluent with the firehose technique. The workaround to the problem is to scroll to the very last row, and then back to make the edit. No kidding.

The reason for the error is this: When the table rows are displayed, they use something called a firehose cursor. This is really a misguiding name, since it’s not a cursor but rather a method to quickly move data to the requesting client. Firehose sends the requested data to an output buffer, and once that buffer is full, it waits for the client to get the data so the buffer can be filled again.

Since the records are only locked for the time it takes to transfer to the buffer, it will boost concurrency and performance. Without any more technical details, this gives that only the displayed rows are being processed. The rest of the rows are stuck in the network buffer, preventing the transaction from being completed. By scrolling to the end, the rest of the rows are processed and the transaction can be completed. Clear as mud.

2 comments

  • avatar
    19 Apr, 2006

    Error message of the week: We have changed mail server at work and the migration process has beem automated, when you log in a special script is run automatically. When I log in nowadays, the log in process is halted and the following error message is shown: “The users mailbox has not been migrated or the profile update has already been run.”

  • avatar
    19 Apr, 2006

    Hilarious! A great way to get rid of all those unanswered mails.

Post a comment

Your email address will not be published. Required fields are marked *

Featured stories

Aliens in Nevada and New Mexico

Aliens in Nevada and New Mexico

"We turned around and went down another dirt road, past countless Joshua trees until our car was covered in dirt and we finally arrived at the Front Gate of Area 51."
Memories of Skye

Memories of Skye

"The countryside is charming and some places even have coffee."
Alone in Kyoto

Alone in Kyoto

"I tried my best to sneak across the building, but the floor revealed me each time. I suppose I would make a lousy ninja."
Greetings from Moldova

Greetings from Moldova

"But Chisinau is an unexpected gem in the wilderness. Even though Moldova is one of the poorest countries in Europe, the capital has its fair share of impressive buildings and post-Soviet architecture."
Having champagne in Champagne

Having champagne in Champagne

"We roamed the damp and chilly tunnels and stumbled upon a large barrel delivered by Napoleon himself."
New Years Eve in Sydney

New Years Eve in Sydney

"Opera House is seen in front of the massive fireworks in the harbor area, celebrating the 75th anniversary of the Harbour Bridge."

Instagram

Seville
Venice
Fever Ray
Rome
Basel
Kuala Lumpur