Question

Photo of Marcus Carpenter

0

SQL Timeout

5

Our prod site is down due to what appears to be a connection timeout with the local db.  We started experiencing this issue just a couple of days ago and I have done just about everything I can think to do.  I have even restored my rockrms host virtual server from a snapshot to a time when it was known to be working, and still no louck.  Which leads me to think there is some external issue.  However, the db and the app is hosted on the same server and the app will not load on that same server.  I am able to sign-in to SSMS with RockUser and access the rock db, perform queries, view tables, etc.  This is my web.ConecctionsString.config:

<?xml version="1.0"?>

<connectionStrings>

 <add name="RockContext" connectionString="Data Source=localhost;Initial Catalog=rock;Connection Timeout=30; User Id=RockUser; password=<mypassword>;MultipleActiveResultSets=true" providerName="System.Data.SqlClient"/>

</connectionStrings>


I have attached RockExceptions.csv for you reference and included a screenshot of the error presented in the web browser.  Thanks for any assistance you can provide to help me troubleshoot.


RockExceptions.csv


Screenshot_29-4-2025_124451_localhost.jpeg

  • Photo of Carl Roske

    0

    Hi, Marcus.

    Did something change with your server that would cause greater resource usage, such as with CPU utilization?  Does your SQL RockUser login / user have sufficient permissions?


  • Photo of Marcus Carpenter

    0

    About a month ago, I increased the VMs system resources because it seemed a bit sluggish.  I increase the number of virtual CPU's from 2 to 4 and RAM from 8GB to 12GB.

  • Photo of Marcus Carpenter

    0

    Hey Carl,

    Thanks for pointing me in the right direction.  It looks like it had nothing to do with the app or DB but the VM guest tools was consuming all the available memory.  After removing the virt-io guest tools and rebooting the server, rockrms is online again.

    Thanks,

    Marcus



  • Photo of Ben Murphy

    0

    Hi Marcus! You'll get a much faster response from the community in the live chat trying the #hosting or #troubleshooting channels here: https://community.rockrms.com/chat

    But with that you can bump up your value from your 30 seconds to 6 minutes or more if needed like this. ConnectionTimeout=360

  • Photo of Marcus Carpenter

    0

    Hey Ben,

    When I initially posted this earlier today, I realized that I mistakenly placed it under #general channel.    I could not find I way to move my post over to the #troubleshooting channel. I understand it was an epic failure on my part. I will make conscious effort to ask my questions under the proper channel in the future. I have also implemented your suggestion to my web.ConnectionsString.config file and hopefully this will not be an issue going forward.  Thank you all for your help and God bless.

    -Marcus