Skip to main content

SQL Mirroring issues with Acronis/VMware snapshot

Beginner
Posts: 2
Comments: 5

We are currently experience an issue with sql server mirroring during a vmware snapshot creation where we are seeing an error in the sql server error logs "The mirroring connection to "TCP://<server>:" has timed out for database <dbname> after 120 without a response. Check the service and network connections"

Running a sql server trace (on the non witness test server) shows at the time of the snapshot:

 

Error: 64

Eventclass:  Database mirroring connection

TextData : The connection was closed by the remote end, or an error occurred while receiving data: ‘64(The specified network name is no lo

 

Then the snapshot completes.

 

Then every 90 seconds:

 

Error:  -1

Eventclass: Database Mirroring Connection

Textdata: The connection has been idle for over 90 seconds

 

Then at the end of the timeout period :

 

State: 6

Eventclass: Database Mirroring State change

Textdata: DBM: Syncronized Principle without Witness -> DBM: Connection with mirror lost

SPID:18

 

State: 2

Eventclass: Database Mirroring State change

Textdata: DBM: Connection with Mirror Lost -> DBM: Synchronized Principle without Witness

SPID:18

 

State: 12

Eventclass: Database Mirroring State change

Textdata: DBM: Connection Principle without witness -> DBM: Principle Running Exposed

SPID:18

 

State:13

Eventclass: Database Mirroring State change

Textdata: DBM: Principle Running Exposed -> DBM: Synchronizing Principle

SPID:18

 

 

 

 

Beginner
Posts: 2
Comments: 5

Top

This is causing intermitent Mirror fail over and an error record appearing on both the primary and mirror server.

Where it does not fail over the database will reconnect after the timeout period.

This error is occurring regardless of the timeout setting and I have tried and tested with various ranges between 30 seconds to 30 minutes. 

The snapshot process is taking under ten seconds to complete with the vm freeze only takeing 1-3 seconds.

We are running sql server 2014 SP 1 standard with the latest updates and I can also recreate the issue of the error message timeout on sql server 2012 with no witness.

The OS is windows server 2012 R2 Standard on both

VMWare version for sql server 2012 test 5.0.0, VMWare version for sql server 2014 live 5.5.0

We can recreate the error by taking a manual vmware snapshot through vshpere and issue can occur regardless of whether application aware quiescing is on or off.

It is like the snapshot creation kills the mirroring link and it cannot get it back regardless of the timeout setting.

We have no other issues with the mirroring or timeouts apart from these timeout messages during the snapshot creation with it sometimes failing over to the mirror.

There is very little load on the database.

Can anyone assist?

Beginner
Posts: 2
Comments: 5

Top

*

Beginner
Posts: 2
Comments: 5

Top

anyone?