Volume placement failure isolation and reporting

A computing device comprising:

• a memory containing machine readable medium comprising machine executable code having stored thereon instructions for performing a method of isolating a failure to provide a location for placing a volume in a plurality of storage systems in response to a request that comprises requested volume parameters for placing the volume;
• and
• a processor coupled to the memory, the processor configured to execute the machine executable code to cause the processor to:
• receive a trigger to replay a first query that is an optimized query to identify a location to place the volume in response to a first result of the optimized query from a database being empty, the optimized query including a plurality of queries according to the requested volume parameters;
• send, in response to the trigger, a second query of the plurality of queries to the database as part of the replay of the first query, the second query comprising one query deconstructed from the plurality of queries and providing a first network hierarchy level of filtering of possible locations to place the volume according to the requested volume parameters;
• receive a second result from the database in response to the second query the second result comprising a filtered list of possible locations at the first network hierarchy level to place the volume;
• send a combination of the second query and a third query deconstructed from the plurality of queries to the database as part of the replay of the optimized query, the third query providing a second network hierarchy level of filtering to the filtered list of possible locations at the first network hierarchy level and according to the requested volume parameters;
• receive a third result from the database in response to the combination of the second query and the third query, the third result being empty of possible locations to place the volume and comprising a log of details associated with the combination of the second and third queries;
• determine a cause of the empty third result being empty based at least in part on the third query and the log, including identifying a location in an object hierarchy of the database corresponding to the second network hierarchy level;
• and
• respond to the request to place the volume with an indication of the failure to place the volume according to the requested volume parameters, the indication being based on the cause of the third result being empty.

A non-transitory machine-readable medium having stored thereon instructions for performing a method of isolating a failure to provide a location for placing a volume in a plurality of storage systems in response to a request that comprises requested volume parameters for placing the volume, which when executed by at least one machine, causes the at least one machine to:

• send a first query that comprises an optimized query to a database in response to the request, the optimized query including a plurality of queries according to the requested volume parameters;
• send a second query to the database in response to receiving a first empty result from the database, the second query comprising one query deconstructed from the plurality of queries and providing a first network hierarchy level of filtering of possible locations to place the volume according to the requested volume parameters;
• send a combination of the second query and a third query deconstructed from the plurality of queries to the database in response to receiving a filtered list of possible locations from the database responsive to the second query, the third query providing a second network hierarchy level of filtering to the filtered list of possible locations at the first network hierarchy level and according to the requested volume parameters;
• respond to the request for the location to place the volume with an error indicating a reason for failing to provide the location in response to receiving a third result from the database responsive to the combination of the second query and the third query, and according to the requested volume parameters;
• and
• automatically modify the request for the location to place the volume based on the reason for failing to provide the location in response to the error.