Search

Language:  
Search for:

Available article translations:

MSSQL does not work in a cloned container or after c2v migration.

Article ID: 116218, created on Jun 3, 2013, last review on May 9, 2014

APPLIES TO:
  • Virtuozzo
  • Virtuozzo containers for Windows

Symptoms

MSSQL server does not work after a container is cloned:

Cannot connect to localhost

You can also see the following entries in the event viewer:

SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x29cd2a3a; actual: 0xa83049bb). It occurred during a read of page (1:318) in database ID 1 at offset 0x0000000027c000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf'.  Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

The same symptoms can be observed in a VM after a c2v migration procedure.

Cause

While cloning a container, Security Identifiers are changed on block devices of the container and SIDs are also changed inside SQL master database files.

Resolution

As a workaround, you can move *.mdf and *.ldf files from the source container to the destination VM/container. You can use the following commands to copy the files from the container #111 to the container #112:

C:\>copy "c:\vz\private\111\root\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\*.mdf" "c:\vz\private\112\root\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\" /Y

C:\>copy "c:\vz\private\111\root\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\*.ldf" "c:\vz\private\112\root\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\" /Y

If you migrate a container to a virtual machine, follow these steps:

  1. Mount the virtual machine:

    ~# prlctl mount myvm
    
  2. Find the mountpoint of the proper partition in the output of this command (there can be few, e.g. if the bootloader is on the separate partition):

    ~# prlctl mount myvm --list
    

    (Substitute myvm with the real virtual machine's name.)

  3. Copy *.mdf and *.ldf files from the source container to the directory /vz/mnt/\{ba5d9b48-a68b-4b5f-a5de-195433d1b5fe\}/volume_1/Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\.

    where /vz/mnt/\{ba5d9b48-a68b-4b5f-a5de-195433d1b5fe\}/volume_1/ is the mountpoint of the proper partition which contains the installation of Windows in this VM.

    To copy files from the source Windows system to the server with PSBM 5.0 or PCS 6.0, the tool pscp from the distribution of PuTTY can be used.

    C:\>pscp "c:\vz\private\111\root\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\*.mdf" "c:\vz\private\111\root\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\*.ldf" root@PSBM.NODE:/vz/mnt/\{ba5d9b48-a68b-4b5f-a5de-195433d1b5fe\}/volume_1/Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\
    

    (Replace PSBM.NODE with the appropriate server's hostname or IP address; c:\vz\private\111 with the proper path to the container's private area.)

Search words:

Cannot connect to localhost

can't access MSSQL when migrating the container to VM

SQL Server detected a logical consistency-based I/O error: incorrect checksum




d02f9caf3e11b191a38179103495106f 2897d76d56d2010f4e3a28f864d69223 965b49118115a610e93635d21c5694a8 0dd5b9380c7d4884d77587f3eb0fa8ef

FEEDBACK
Was this article helpful?
Tell us how we may improve it.
Yes No
 
 
 
 
 
 
Server Virtualization
- Odin Cloud Server
- Odin Containers for Windows 6.0
- Odin Virtuozzo Containers
Automation
- Odin Automation
- Odin Automation for Cloud Infrastructure
- Odin Business Automation Standard
- Odin Virtual Automation
- Odin Plesk Panel Suite
- Web Presence Builder
- Odin Plesk Automation
- Odin Small Business Panel
- Value-added Services for Hosters
- Odin Partner Storefront
Services & Resources
- Cloud Acceleration Services
- Professional Services
- Support Services
- Training & Certification