Azure Table Storage Unable to connect - Error on increasing load

I am using Windows Aure Website ( Reserved Instance) and doing the Inserts to an Azure table via http. ( Yes http).  When i was doing load testing, foud the below error.  It was like  2 hits / seconds... Not sure what is the reason?


Any thoughts? SDK issue? 

HTTP_Request2_ConnectionException</b>: Unable to connect to tcp://innovativetxtstorage.table.core.windows.net:80. Error: php_network_getaddresses: getaddrinfo failed: No such host is known.  

C:\DWASFiles\Sites\innovativetxt\VirtualDirectory0\site\wwwroot\vendor\pear-pear.php.net\HTTP_Request2\HTTP\Request2\Adapter\Socket.php  on  line 324

>HTTP_Request2_SocketWrapper->__construct('tcp://innovative&hellip;', 10, Array)</td><td>C:\DWASFiles\Sites\innovative in C:\DWASFiles\Sites\innovativetxt\VirtualDirectory0\site\wwwroot\vendor\pear-pear.php.net\HTTP_Request2\HTTP\Request2\SocketWrapper.php on line 116


  • Edited by Haque20 Thursday, July 25, 2013 2:49 PM
July 25th, 2013 2:49pm

HI

I'm not a PHP dev.

But I think the problem is the path should be

"HTTP://innovativetxtstorage.table.core.windows.net:80"

Not

"tcp://innovativetxtstorage.table.core.windows.net:80"

Free Windows Admin Tool Kit Click here and download it now
July 26th, 2013 3:31am

Hi,

  >> When i was doing load testing, foud the below error.

In order for me to better understand the issue please confirm whether it works fine in general, but fails when it has a high load. From my experience, Standard (reserved) instances would not have any bandwidth limitations, I'd like to know whether you can see the same issue if you do load test on a local website.

  >> It was like  2 hits / seconds... Not sure what is the reason?

From your statement, I am not sure if you are inserting a single entity during 1 hit (so 2 requests are made to table storage in 1 second), or if you are creating a lot of requests during 1 hit, it would be better if you have retry policy, Network is natually unstable, thus a retry policy is needed, if a requet fails, wait for a few seconds, and try again. Based on my understanding, the table storage client library will automatically implement retry policy, unless you disable it. Please check whether the data are correctly saved to table storage, if so, the intermediate errors could be ignored.

Best Regards,

Ming Xu 

July 26th, 2013 8:08am

Here is further information ...

In normal circumstance with 30 Hits per Minute to our our API.... It works fine.  After that latency is too high that it gives time out. See the Attached Report..

 All I am doing is reading the Azure table to verify user Loginand Password...   ( Reading Same Entity Again and Again)

See teh Performance Test Report here... http://www.innovativetxt.com/BlitzPerformanceTest.pdf

My customer cannot send us more than 30 request per seconds.. we feel ourself in trouble by complains every day.

We are on reserved Instance Website URL is http://www.innovativetxt.com   and we feel like latency is killing us. 

1. Is it because of Aure Storage? Cannot handel load of that much?


I
s it bec

( I have already turend of Tanggling, TCP 100 etc all tips implemented )

See the below error message from Log file.

[03-Aug-2013 09:37:01 UTC] PHP Fatal error:  Uncaught <table style="border: 1px" cellspacing="0">
<tr><td colspan="3" style="background: #ff9999"> <b>HTTP_Request2_ConnectionException</b>: Unable to connect to tcp://innovativetxtstorage.table.core.windows.net:80. Error: php_network_getaddresses: getaddrinfo failed: No such host is known.  in <b>C:\DWASFiles\Sites\innovativetxt\VirtualDirectory0\site\wwwroot\vendor\pear-pear.php.net\HTTP_Request2\HTTP\Request2\Adapter\Socket.php</b> on line <b>324</b></td></tr>
<tr><td colspan="3" style="background-color: #aaaaaa; text-align: center; font-weight: bold;">Exception trace</td></tr>
<tr><td style="text-align: center; background: #cccccc; width:20px; font-weight: bold;">#</td><td style="text-align: center; background: #cccccc; font-weight: bold;">Function</td><td style="text-align: center; background: #cccccc; font-weight: bold;">Location</td></tr>
<tr><td style="text-align: center;">0</td><td>HTTP_Request2_SocketWrapper->__construct('tcp://innovative&hellip;', 10, Array)</td><td>C:\DWASFiles\Sites\innovative in C:\DWASFiles\Sites\innovativetxt\VirtualDirectory0\site\wwwroot\vendor\pear-pear.php.net\HTTP_Request2\HTTP\Request2\SocketWrapper.php on line 116


  • Edited by Haque20 Saturday, August 03, 2013 10:04 AM
Free Windows Admin Tool Kit Click here and download it now
August 3rd, 2013 9:56am

Hi,

Thank you for your feedback. For now, I am trying to involve someone familiar with this topic to further look at this issue. There might be some time delay. Appreciate your patience.

Best Regards,

Ming Xu

August 5th, 2013 2:27pm

Hi Haque,

I am from Microsoft Azure Support team and would like to work directly with you on this issue.

Could you please drop me an email on sshri@live.com to proceed with further troubleshooting?

Looking forward to hear from you.

Thanks,

Shashank Shrivastava

Support Escalation Engineer
Azure Application Platform
(Azure | Antares | ASP.NET | IIS)

Free Windows Admin Tool Kit Click here and download it now
August 11th, 2013 11:54am


Hi Haque,

I am from Microsoft Azure Support team and would like to work directly with you on this issue.

Could you please drop me an email on sshri@live.com to proceed with further troubleshooting?

Looking forward to hear from you.

Thanks,

Shashank Shrivastava

Support Escalation Engineer
Azure Application Platform
(Azure | Antares | ASP.NET | IIS)

August 15th, 2013 1:58am

I met your problem too.

I use china azure(mooncake), its connection string is different from global azure.

it's like this :

$connectionString = 'BlobEndpoint=http://[account name].blob.core.chinacloudapi.cn/;QueueEndpoint=http://[account name].queue.core.chinacloudapi.cn/;TableEndpoint=http://[account name].table.core.chinacloudapi.cn/;AccountName=[account name];AccountKey=*****

then my problem fixed, I'm not sure this is useful for you.

Free Windows Admin Tool Kit Click here and download it now
March 17th, 2015 11:24pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics