Build is stuck with message Starting SQL Server 2014 Express

Nick's Avatar

Nick

13 Nov, 2015 07:56 PM

I am running builds matrix and each build requires mssql server to be installed.

Quite often one or several builds within matrix are getting stuck with the message "Starting SQL Server 2014 Express". Probability of failing for one particular build is low, but with matrix it becomes quite high - may be 10%-20% percent of builds are have this problem.

  1. Support Staff 1 Posted by Feodor Fitsner on 13 Nov, 2015 08:04 PM

    Feodor Fitsner's Avatar

    Will take a look.

    - Feodor

  2. Support Staff 2 Posted by Feodor Fitsner on 13 Nov, 2015 09:51 PM

    Feodor Fitsner's Avatar

    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.

    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.

    Would you like to be moved there and give it a try?

  3. 3 Posted by Nick on 14 Nov, 2015 01:47 AM

    Nick's Avatar

    Hi Feodor, thanks for support.

    Yes, we would like to try. Is there a cost difference?

  4. Support Staff 4 Posted by Feodor Fitsner on 14 Nov, 2015 02:08 AM

    Feodor Fitsner's Avatar

    No, there is no cost difference.

    Before switching your account I have two questions:

    1. Do you have any firewalls set on your environment that require persistent well-known IP from build workers?

    2. What's the largest artifact you upload during the build?

    - Feodor

  5. 5 Posted by Nick on 16 Nov, 2015 06:05 PM

    Nick's Avatar

    Hi Feodor,
    > Do you have any firewalls set on your environment that require persistent well-known IP from build workers?
    Yes, we do.
    > What's the largest artifact you upload during the build?
    My project publishes 15mb.

    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.

    Thank you.

  6. Support Staff 6 Posted by Feodor Fitsner on 16 Nov, 2015 06:07 PM

    Feodor Fitsner's Avatar

    Hi Nick,

    It's not possible to switch a project, but account only.

    Create a new account (or you probably have a personal one) and I'll switch it to that environment.

  7. 7 Posted by Nick on 16 Nov, 2015 11:31 PM

    Nick's Avatar

    Hi Feodor,

    I have a few updates:
    1) Our largest artifact is 800mb.
    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?

    Thank you

  8. Support Staff 8 Posted by Feodor Fitsner on 17 Nov, 2015 12:29 AM

    Feodor Fitsner's Avatar

    Sounds good. Let me know when you are ready to switch.

    This communication channel is quite good, but feel free to use email ([email blocked]) or Skype (feodor.fitsner).

  9. 9 Posted by Nick on 30 Nov, 2015 04:18 PM

    Nick's Avatar

    Thank you Feodor, now it is much better!

  10. Ilya Finkelshteyn closed this discussion on 25 Aug, 2018 02:02 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac