Inedo Community Forums Forums
    • Recent
    • Tags
    • Popular
    • Login

    Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.

    If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!

    ProGet V5.3.17 Excessive Database Connections

    Scheduled Pinned Locked Moved Support
    2 Posts 2 Posters 13 Views 1 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • S Offline
      scroak_6473
      last edited by

      Hey Guys,

      We're running ProGet v5.3.17 (.Net 5) in a docker container and it is creating excessive database connections to our Microsoft Database Server (external to docker).

      We had an alert from the DB server that at one point it was over 100 sperate TCP connections coming from our single ProGet Container

      Doing a "netstat -a" on the container currently shows over 17 connections:

      83ea9ebb-4e11-44cb-802b-b9e0379a180f-image.png

      Any ideas why so many? This has only been an issue since we moved to the .Net 5 version of ProGet.

      Thanks

      Simon

      1 Reply Last reply Reply Quote 0
      • atrippA Offline
        atripp inedo-engineer
        last edited by

        hi Simon,

        The default connection pool size for .NET's SQL Server connection is 100, so that behavior wouldn't be unexpected if there were a lot of requests to ProGet (very common in a package restore) and the database driver wasn't responding fast enough for whatever reason (also very common... too many network requests coming in, too many network requests going out, slow database server, etc.).

        The .NET Runtime will eventually close those connections, and they will then be terminated by the TCP stack shortly after (minutes?).

        Alana

        1 Reply Last reply Reply Quote 0

        Hello! It looks like you're interested in this conversation, but you don't have an account yet.

        Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

        With your input, this post could be even better 💗

        Register Login
        • 1 / 1
        • First post
          Last post
        Inedo Website Home • Support Home • Code of Conduct • Forums Guide • Documentation