.net - What does "A severe error occurred on the current command. The results, if any, should be discarded." SQL Azure error mean? -

.net - What does "A severe error occurred on the current command. The results, if any, should be discarded." SQL Azure error mean? -

once in while code encounters

system.data.sqlclient.sqlexception service has encountered error processing request. please seek again. error code 40540. severe error occurred on current command. results, if any, should discarded. class 20 number 40197

that happens rarely, goes away in min or 2 , can't reliably reproduce it. error code can number other 40540.

i've googled bit , looks it's triggered bugs in sql server , reproducible.

i have 2 options - retry query or treat fatal , break hard. i'd prefer have improve understanding problem , whether i'm safe retrying query.

do retry query when error occurs?

a quick google search gave me this.

the service has encountered error processing request. please seek again. error code %d. receive error, when service downwards due software or hardware upgrades, hardware failures, or other failover problems. reconnecting sql database server automatically connect healthy re-create of database. may see error codes 40143 , 40166 embedded within message of error 40540. error codes 40143 , 40166 provide additional info kind of failover occurred. not modify application grab error codes 40143 , 40166. application should grab 40540 , seek reconnecting sql database until resources available , connection established again.

you can visit here more information. says your application should grab 40540 , seek reconnecting sql database until resources available , connection established again.

though on personal note suggest not utilize sql azure throttles , can't command resources allocated you. did install sql server on azure vm , utilize in application.

hope helps you.

.net sql-server-2008 azure sql-azure