App Volumes and SQL failover

[nevgeo01]

Hi

We have an environment in which App volumes stops working when a SQL failover is initiated. When reverted back to the primary server we have the app volume server up and running.

App volumes version: 2.12

SQL version 2014 always on configured

Please advise

Error trace in App volumes manager logs

ODBC::Error: 42000 (1105) [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'dbo.delayed_jobs'.'PK__delayed___3213E83FC2730EDB' in database 'AppVolumes' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting auto growth on for existing files in the filegroup.

[nevgeo01]

The SQl 2014 used is SQl 2014 12.0.2000.8(RTM and not SP1)

Please Advise.

[techguy129]

If you verified that space isn't an issue based on the error you posted:

A common issue with AAG is that the local account SIDs don't match between availability group sql instances. Please check that the local account SIDs match. https://blog.sqlauthority.com/2015/04/18/sql-server-create-login-with-sid-way-to-synchronize-logins-...