ADO pipeline fails to write Schema Snapshot for one database

dbriskin

I have an SCA project that we are deploying using Azure DevOps pipeline to multiple target databases.  It's been working fine, but today it started failing for one database with the following error:##[warning]RedGate.Versioning.Engines.Interaction.BuildAndRelease.Deployment.SchemaSnapshotDeploymentException: Error writing schema snapshot to database: An error occurred during script deployment. Output from SQL Server follows.The error from Azure SQL Database is "The elastic pool has reached its storage limit." which makes no sense because this pool has more than enough storage (150GB free out of 500GB) and the database it tiny (150MB out of 10GB allocated).

I'm checking the database itself, and it looks like the changes were actually deployed, but the dbo.__SchemaSnapshot table is empty.

Not sure how to proceed, and could use some advice.

Jon_Kirkwood

Updating this post with some findings that were conducted directly on a support ticket

It looks like an Azure issue: https://stackoverflow.com/questions/52496146/azure-sql-server-error-the-elastic-pool-has-reached-its-storage-limit-the-sto

Elastic storage allocates the full size of the dB allocation on storage and is trying to allocate 512GB to a 500GB allocation. Increasing elastic size to 512GB+ should resolve this issue in the short term.

dbriskin

Thank you Jon.  We increased the elastic pool size to 600GB and it resolved the problem.