locked
All table storage requests timing out from Azure Websites using the PHP SDK RRS feed

  • Question

  • Ever since Friday, all connections to my azure table have timed out -- The query is rather simple 

    Filter = "where partitionid = xxx and (rowId = 'name:xxx' or 'org:xxx')"

    I created a  sample script that all it does is query one row https://github.com/abrutus/osfi/blob/master/test.php and it times out when I run it on the console (site.scm.azurewebsites.net) -- but it doesn't time out when I do it on my local machine. Here's a video of me trying it on my local machine and on the debug console: https://www.dropbox.com/s/v5xth0dvxdbt7kj/error_trace.mov?dl=0

    require_once './vendor/autoload.php';
    use WindowsAzure\Common\ServicesBuilder;
    use WindowsAzure\Table\Models\Entity;
    $conn_string = getenv('CUSTOMCONNSTR_OSFI_CONN_STRING');
    $ts = ServicesBuilder::getInstance()->createTableService($conn_string);
    $test = !empty($argv[1]) ? metaphone($argv[1]) : "ANTRBRTS";
    echo $filter = "PartitionKey eq '$test' and (RowKey eq 'org:$test' or RowKey eq 'name:$test')";
    $result=  $ts->queryEntities("osfi", $filter);
    print_r($result);

    A graph of when the error started occurring can be seen on my website stats (note the spike in server errors on Friday). The website hasn't been updated in a month or more.

    http://brut.us/XPk

    (cross posted from https://social.msdn.microsoft.com/Forums/azure/en-US/26d30c33-bb4b-4f4f-92cf-6f7394bd62d8/all-table-storage-requests-timing-out-from-azure-websites-using-the-php-sdk?forum=windowsazurewebsitespreview)

    Monday, October 27, 2014 5:27 PM

Answers

  • It turns out that on Friday, Microsoft Azure Websites released a buggy version of PHP binaries that have problem with SSL. Disabling SSL on the connection string solves the issue.

    Thanks for the suggestion,

    Andre

    Tuesday, October 28, 2014 2:50 PM

All replies