search

avivasolutionsnl / sitecore-docker

Dockerized Sitecore 9 XP0 & XC
33 stars 24 forks source link

Mssql error in persist databases #100

Closed Barsonax closed 5 years ago

Barsonax commented 5 years ago

The persist database script sometimes gives this error:

╬══════════════
║ DemoMssql
╬═════

> "C:\Program Files\Docker\Docker\Resources\bin\docker-compose.exe" up -d mssql
Recreating mercurydemoweb_mssql_1 ... 

?[1A?[2K
Recreating mercurydemoweb_mssql_1 ... ?[32mdone?[0m
?[1B
> "C:\Program Files\Docker\Docker\Resources\bin\docker.exe" exec --interactive --tty mercurydemoweb_mssql_1 powershell C:\Persist-Databases.ps1
?[2J?[?25l?[m?[H

?[H?]0;C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe ?[?25h ?[H?]0;Administrator: C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe ?[?25l### Detaching 'SitecoreCommerce9_Global'...?[?25h?[?25l?[H#
?[?25h?[?25l### Moving 'C:\data\SitecoreCommerce9_Global_Primary.mdf' and 'C:\data\SitecoreC
ommerce9_Global_Primary.ldf' to 'c:/install/'?[35X?[35C?[3;46H?[?25h?[?25l?[H#?[4;1H?[?25h?[?25l?[91mMove-Item : The process cannot access the file because it is being used by ?[m?[?25h?[?25l?[91m
another process.?[m?[64X?[64C?[91m
At C:\Persist-Databases.ps1:22 char:5?[m?[43X?[43C?[91m
+     Move-Item $mdfPath -Destination $InstallPath -Force?[m?[23X?[23C?[91m
+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~?[m?[23X?[23C?[91m
    + CategoryInfo          : WriteError: (C:\install\Site...bal_Primary.mdf:F ?[m ?[91m
   ileInfo) [Move-Item], IOException?[m?[44X?[44C?[91m
    + FullyQualifiedErrorId : MoveFileInfoItemIOError,Microsoft.PowerShell.Com ?[m ?[91m
   mands.MoveItemCommand?[m?[56X?[56C?[91m
 ?[m?[79X?[79C?[91m
Move-Item : The process cannot access the file because it is being used by ?[m     ?[91m
another process.?[m?[64X?[64C?[91m
At C:\Persist-Databases.ps1:23 char:5?[m?[43X?[43C?[91m
+     Move-Item $ldfPath -Destination $InstallPath -Force?[m?[23X?[23C?[91m
+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~?[m?[23X?[23C?[91m
    + CategoryInfo          : WriteError: (C:\install\Site...bal_Primary.ldf:F ?[m ?[91m
   ileInfo) [Move-Item], IOException?[m?[44X?[44C?[91m
    + FullyQualifiedErrorId : MoveFileInfoItemIOError,Microsoft.PowerShell.Com ?[m
?[?25h?[?25l?[91m   mands.MoveItemCommand?[m?[32X?[32C?[91m
 ?[m?[55X?[55C
### Detaching 'SitecoreCommerce9_SharedEnvironments'...
?[?25h?[?25l### Moving 'C:\data\SitecoreCommerce9_SharedEnvironments_Primary.mdf' and 'C:\d?[?25h?[?25l
ta\SitecoreCommerce9_SharedEnvironments_Primary.ldf' to 'c:/install/'?[11X?[11C?[25;70H?[?25h?[?25l?[H#?[25;70H?[?25h?[?25l
?[80X?[80C
?[?25h?[?25l### Detaching 'Sitecore_Core'...?[?25h?[?25l?[Ho?[25;33H?[?25h?[?25l
?[80X?[80C
?[?25h?[?25l### Moving 'C:\data\Sitecore_Core_Primary.mdf' and 'C:\data\Sitecore_Core_Prima?[?25h?[?25l
y.ldf' to 'c:/install/'?[57X?[57C?[25;24H?[?25h?[?25l?[91m?[Ha?[25;24H?[?25h?[?25l?[m
?[80X?[80C
?[?25h?[?25l### Detaching 'Sitecore_Exm.master'...?[?25h?[?25l?[91m?[HA?[25;39H?[?25h?[?25l?[m
?[80X?[80C
?[?25h?[?25l### Moving 'C:\data\Sitecore_Exm.master_Primary.mdf' and 'C:\data\Sitecore_Exm.?[?25h?[?25l
aster_Primary.ldf' to 'c:/install/'?[45X?[45C?[25;36H?[?25h?[?25l?[91m?[H+?[25;36H?[?25h?[?25l?[m
?[80X?[80C
?[?25h?[?25l### Detaching 'Sitecore_Experienceforms'...?[?25h?[?25l?[91m?[H ?[25;44H?[?25h?[?25l?[m
?[80X?[80C
?[?25h?[?25l### Moving 'C:\data\Sitecore_Experienceforms_Primary.mdf' and 'C:\data\Sitecore?[?25h?[?25l
Experienceforms_Primary.ldf' to 'c:/install/'?[35X?[35C?[25;46H?[?25h?[?25l?[91m?[H ?[25;46H?[?25h?[?25l?[m
?[80X?[80C
?[?25h?[?25l### Detaching 'Sitecore_Marketingautomation'...?[?25h?[?25l?[91m?[H ?[25;48H?[?25h?[?25l?[m
?[80X?[80C
?[?25h?[?25l### Moving 'C:\data\Sitecore_Marketingautomation_Primary.mdf' and 'C:\data\Site?[?25h?[?25l
ore_Marketingautomation_Primary.ldf' to 'c:/install/'?[27X?[27C?[25;54H?[?25h?[?25l?[91m?[HM?[25;54H?[?25h?[?25l?[m
?[80X?[80C
?[?25h?[?25l### Detaching 'Sitecore_Master'...?[?25h?[?25l?[91m?[Ha?[25;35H?[?25h?[?25l?[m
?[80X?[80C
?[?25h?[?25l### Moving 'C:\data\Sitecore_Master_Primary.mdf' and 'C:\data\Sitecore_Master_P?[?25h?[?25l
imary.ldf' to 'c:/install/'?[53X?[53C?[25;28H?[?25h?[?25l?[91m?[H+?[25;28H?[?25h?[?25l?[m
?[80X?[80C
?[?25h?[?25l### Detaching 'Sitecore_Messaging'...?[?25h?[?25l?[91m?[H+?[25;38H?[?25h?[?25l?[m
?[80X?[80C
?[?25h?[?25l### Moving 'C:\data\Sitecore_Messaging_Primary.mdf' and 'C:\data\Sitecore_Messa?[?25h?[?25l
ing_Primary.ldf' to 'c:/install/'?[47X?[47C?[25;34H?[?25h?[?25l?[91m?[H ?[25;34H?[?25h?[?25l?[m
?[80X?[80C
?[?25h?[?25l### Detaching 'Sitecore_Processing.pools'...?[?25h?[?25l?[91m?[H ?[25;45H?[?25h?[?25l?[m
?[80X?[80C
?[?25h?[?25l### Moving 'C:\data\Sitecore_Processing.pools_Primary.mdf' and 'C:\data\Sitecor?[?25h?[?25l
_Processing.pools_Primary.ldf' to 'c:/install/'?[33X?[33C?[25;48H?[?25h?[?25l?[91m?[H ?[25;48H?[?25h?[?25l?[m
?[80X?[80C
?[?25h?[?25l### Detaching 'Sitecore_Processing.tasks'...?[?25h?[?25l?[H#?[25;45H?[?25h?[?25l
?[80X?[80C
?[?25h?[?25l### Moving 'C:\data\Sitecore_Processing.tasks_Primary.mdf' and 'C:\data\Sitecor?[?25h?[?25l
_Processing.tasks_Primary.ldf' to 'c:/install/'?[33X?[33C?[25;48H?[?25h?[?25l?[Ht?[25;48H?[?25h?[?25l
?[80X?[80C
?[?25h?[?25l### Detaching 'Sitecore_Referencedata'...?[?25h?[?25l?[H#?[25;42H?[?25h?[?25l
?[80X?[80C
?[?25h?[?25l### Moving 'C:\data\Sitecore_Referencedata_Primary.mdf' and 'C:\data\Sitecore_R?[?25h?[?25l
ferencedata_Primary.ldf' to 'c:/install/'?[39X?[39C?[25;42H?[?25h?[?25l?[Hy?[25;42H?[?25h?[?25l
?[80X?[80C
?[?25h?[?25l### Detaching 'Sitecore_Reporting'...?[?25h?[?25l?[H#?[25;38H?[?25h?[?25l
?[80X?[80C
?[?25h?[?25l### Moving 'C:\data\Sitecore_Reporting_Primary.mdf' and 'C:\data\Sitecore_Repor?[?25h?[?25l
ing_Primary.ldf' to 'c:/install/'?[47X?[47C?[25;34H?[?25h?[?25l?[Ha?[25;34H?[?25h?[?25l
?[80X?[80C
?[?25h?[?25l### Detaching 'Sitecore_Sessions'...?[?25h?[?25l?[H#?[25;37H?[?25h?[?25l
?[80X?[80C
?[?25h?[?25l### Moving 'C:\data\Sitecore_Sessions_Primary.mdf' and 'C:\data\Sitecore_Sessio?[?25h?[?25l
s_Primary.ldf' to 'c:/install/'?[49X?[49C?[25;32H?[?25h?[?25l?[HE?[25;32H?[?25h?[?25l
?[80X?[80C
?[?25h?[?25l### Detaching 'Sitecore_Web'...?[?25h?[?25l?[H#?[25;32H?[?25h?[?25l
?[80X?[80C
?[?25h?[?25l### Moving 'C:\data\Sitecore_Web_Primary.mdf' and 'C:\data\Sitecore_Web_Primary?[?25h?[?25l
ldf' to 'c:/install/'?[59X?[59C?[25;22H?[?25h?[?25l?[Ho?[25;22H?[?25h?[?25l
?[80X?[80C
?[?25h?[?25l### Detaching 'Sitecore_Xdb.Collection.Shard0'...?[?25h?[?25l?[H#?[25;50H?[?25h?[?25l
?[80X?[80C
?[?25h?[?25l### Moving 'C:\data\Sitecore_Xdb.Collection.Shard0.mdf' and 'C:\data\Sitecore_X?[?25h?[?25l
b.Collection.Shard0.ldf' to 'c:/install/'?[39X?[39C?[25;42H?[?25h?[?25l?[Hi?[25;42H?[?25h?[?25l
?[80X?[80C
?[?25h?[?25l### Detaching 'Sitecore_Xdb.Collection.Shard1'...?[?25h?[?25l?[H#?[25;50H?[?25h?[?25l
?[80X?[80C
?[?25h?[?25l### Moving 'C:\data\Sitecore_Xdb.Collection.Shard1.mdf' and 'C:\data\Sitecore_X?[?25h?[?25l
b.Collection.Shard1.ldf' to 'c:/install/'?[39X?[39C?[25;42H?[?25h?[?25l?[Hi?[25;42H?[?25h?[?25l
?[80X?[80C
?[?25h?[?25l### Detaching 'Sitecore_Xdb.Collection.ShardMapManager'...?[?25h?[?25l?[H#?[25;59H?[?25h?[?25l
?[80X?[80C
?[?25h?[?25l### Moving 'C:\data\Sitecore_Xdb.Collection.ShardMapManager.mdf' and 'C:\data\S?[?25h?[?25l
tecore_Xdb.Collection.ShardMapManager.ldf' to 'c:/install/'?[21X?[21C?[25;60H?[?25h?[?25l?[H_?[25;60H?[?25h?[?25l
?[80X?[80C
?[?25h?[?25l?[91mSomething went wrong during persisting the databases as c:/data/ is not empty?[m?[?25h?[?25l?[H#?[25;78H?[?25h?[?25l
?[91mAt C:\Persist-Databases.ps1:27 char:5?[m?[43X?[43C?[25;38H?[?25h?[?25l
?[91m+     throw "Something went wrong during persisting the databases as $D ...?[m     ?[25;76H?[?25h?[?25l
?[91m+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~?[m?[9X?[9C?[25;72H?[?25h?[?25l
?[91m    + CategoryInfo          : OperationStopped: (Something went ...a/ is not e ?[m?[?25h?[?25l
?[91m   mpty:String) [], RuntimeException?[m?[44X?[44C?[25;37H?[?25h?[?25l
?[91m    + FullyQualifiedErrorId : Something went wrong during persisting the datab ?[m?[?25h?[?25l
?[91m   ases as c:/data/ is not empty?[m?[48X?[48C?[25;33H?[?25h?[?25l
?[91m ?[m?[79X?[79C?[25;2H?[?25h?[?25l
?[80X?[80C
?[?25h?[H#?[25;1H
> "C:\Program Files\Docker\Docker\Resources\bin\docker-compose.exe" stop mssql
Stopping mercurydemoweb_mssql_1 ...
Barsonax commented 5 years ago

Moved error in boot script to #120

Other error should be fixed in https://github.com/avivasolutionsnl/sitecore-docker/pull/118