tag:help.appveyor.com,2012-11-13:/discussions/problems/3576-build-is-stuck-with-message-starting-sql-server-2014-expressAppVeyor: Discussion 2018-10-19T08:17:35Ztag:help.appveyor.com,2012-11-13:Comment/384593652015-11-13T20:04:47Z2015-11-13T20:04:47ZBuild is stuck with message Starting SQL Server 2014 Express<div><p>Will take a look.</p>
<ul>
<li>Feodor</li>
</ul></div>Feodor Fitsnertag:help.appveyor.com,2012-11-13:Comment/384593652015-11-13T21:51:24Z2015-11-13T21:51:24ZBuild is stuck with message Starting SQL Server 2014 Express<div><p>It could be that build was running on more loaded Hyper-V host.
Sometimes due to a higher than usual load server gets busy and I/O
becomes a bottle neck. Looks like SQL hits that bottleneck.</p>
<p>We have a new environment in place which is based on Google
Compute Engine. We are migrating OSS project to there and it's also
used as a reserve for paid accounts. VMs there are pretty fast (2
vcores, 7 GB of RAM and 150 GB SSD) and have consistent
performance. However, there is delay on build start between 1-2 min
required to provision build worker VM.</p>
<p>Would you like to be moved there and give it a try?</p></div>Feodor Fitsnertag:help.appveyor.com,2012-11-13:Comment/384593652015-11-14T01:47:19Z2015-11-14T01:47:23ZBuild is stuck with message Starting SQL Server 2014 Express<div><p>Hi Feodor, thanks for support.</p>
<p>Yes, we would like to try. Is there a cost difference?</p></div>Nicktag:help.appveyor.com,2012-11-13:Comment/384593652015-11-14T02:08:46Z2015-11-14T02:08:46ZBuild is stuck with message Starting SQL Server 2014 Express<div><p>No, there is no cost difference.</p>
<p>Before switching your account I have two questions:</p>
<ol>
<li>
<p>Do you have any firewalls set on your environment that require
persistent well-known IP from build workers?</p>
</li>
<li>
<p>What's the largest artifact you upload during the build?</p>
</li>
</ol>
<ul>
<li>Feodor</li>
</ul></div>Feodor Fitsnertag:help.appveyor.com,2012-11-13:Comment/384593652015-11-16T18:05:41Z2015-11-16T18:05:42ZBuild is stuck with message Starting SQL Server 2014 Express<div><p>Hi Feodor,</p>
<blockquote>
<p>Do you have any firewalls set on your environment that require
persistent well-known IP from build workers? Yes, we do.<br>
What's the largest artifact you upload during the build? My project
publishes 15mb.</p>
</blockquote>
<p>By the way is it possible to test this switch only on a single
project first? Otherwise I will have to coordinate with other
project teams before trying to switch whole account.</p>
<p>Thank you.</p></div>Nicktag:help.appveyor.com,2012-11-13:Comment/384593652015-11-16T18:07:37Z2015-11-16T18:07:37ZBuild is stuck with message Starting SQL Server 2014 Express<div><p>Hi Nick,</p>
<p>It's not possible to switch a project, but account only.</p>
<p>Create a new account (or you probably have a personal one) and
I'll switch it to that environment.</p></div>Feodor Fitsnertag:help.appveyor.com,2012-11-13:Comment/384593652015-11-16T23:31:56Z2015-11-16T23:31:57ZBuild is stuck with message Starting SQL Server 2014 Express<div><p>Hi Feodor,</p>
<p>I have a few updates:<br>
1) Our largest artifact is 800mb.<br>
2)We would like to try to change account, but ideally we want to
rollback quickly if something goes wrong. May be forum is not the
best way to communicate on that, could you please share your
email/IM account?</p>
<p>Thank you</p></div>Nicktag:help.appveyor.com,2012-11-13:Comment/384593652015-11-17T00:29:14Z2015-11-17T00:29:14ZBuild is stuck with message Starting SQL Server 2014 Express<div><p>Sounds good. Let me know when you are ready to switch.</p>
<p>This communication channel is quite good, but feel free to use
email (<a href="mailto:team@appveyor.com">team@appveyor.com</a>) or
Skype (feodor.fitsner).</p></div>Feodor Fitsnertag:help.appveyor.com,2012-11-13:Comment/384593652015-11-30T16:18:07Z2015-11-30T16:18:10ZBuild is stuck with message Starting SQL Server 2014 Express<div><p>Thank you Feodor, now it is much better!</p></div>Nick