none
Azure Table Storage, How to avoid connection error (I tried retry)

    Question

  • I asked this question at StackOverflow but cannot get proper answer

    http://stackoverflow.com/questions/9859286/azure-table-storage-how-to-avoid-connection-error-i-tried-retry

    To be clear, I have lots of quires so got lots of errors, in less than 1% but still  annoying

    I got lots of errors like No connection could be made because the target machine actively refused it 70.37.127.112:443 (fyi, I tried :80 as well)

    So I add Microsoft.Practices.TransientFaultHandling to retry.

    But still, lots of errors (even after retry)

    I like to know:

    1st, since Azure is a distributed service, why am I always reach 70.37.127.112 ( I access storage by simple original DefaultEndpointsProtocol=https;AccountName=storage_account;....., then use tableContext.CreateQuery<datatype>("table_name"); ). I noticed all my tables (even in different Storage account) all hit 70.37.127.112. My question, is there a way to change it?

    2nd, how to eliminate the error above totally?

    error details

     System . Net . WebException :   Unable  to connect to the remote server  --->   System . Net . Sockets . SocketException :   No  connection could be made because the target machine actively refused it  70.37 . 127.112 : 443 
       at System . Net . Sockets . Socket . DoConnect ( EndPoint endPointSnapshot , SocketAddress socketAddress )
       at System . Net . ServicePoint . ConnectSocketInternal ( Boolean connectFailure , Socket s4 , Socket s6 , Socket & socket , IPAddress & address , ConnectSocketState state , IAsyncResult asyncResult , Int32 timeout , Exception & exception )
        --- End of inner exception stack trace ---
       at System . Net . HttpWebRequest . GetResponse ()
       at System . Data . Services . Client . QueryResult . Execute ()
       at System . Data . Services . Client . DataServiceRequest . Execute [ TElement ]( DataServiceContext context , QueryComponents queryComponents )
       at System . Data . Services . Client . DataServiceQuery ` 1.Execute ()
       at System . Data . Services . Client . DataServiceQuery ` 1.GetEnumerator ()
       at System . Linq . Enumerable . ToList [ TSource ]( IEnumerable ` 1 source )
       at Microsoft . Practices . TransientFaultHandling . RetryPolicy .<> c__DisplayClass1 .< ExecuteAction > b__0 ()
       at Microsoft . Practices . TransientFaultHandling . RetryPolicy . ExecuteAction [ TResult ]( Func ` 1 func )

    Sunday, March 25, 2012 1:18 PM

Answers

All replies