none
Azure Table Storage Unable to connect - Error on increasing load

    Question

  • 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
    Thursday, July 25, 2013 2:49 PM

All replies

  • 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"


    Please mark post as answered if it helped!

    Friday, July 26, 2013 3:31 AM
  • 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 


    Ming Xu
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Friday, July 26, 2013 8:08 AM
    Moderator
  • 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
    Saturday, August 03, 2013 9:56 AM
  • 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


    Ming Xu
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Monday, August 05, 2013 2:27 PM
    Moderator
  • 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)

    Sunday, August 11, 2013 11:54 AM

  • 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)

    • Proposed as answer by _Shashank.S Thursday, August 15, 2013 1:58 AM
    Thursday, August 15, 2013 1:58 AM
  • 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.

    Wednesday, March 18, 2015 3:20 AM