DX Unified Infrastructure Management

  • Private Community

  • 1.  False ODBC Connect Service and Database down Errors in System Status

    Broadcom Employee
    Posted Aug 27, 2013 03:15 PM

    You may notice after a System Reboot or a recycling of services on one or all of your RA servers that you get persistent messages in the "Administration->System Status" page like below:

    The ODBC Connect Service's current state is Stopped.
    Database is down

    This often times causes alarm that something serious may be wrong with the system.

    This error seems to persist for a while after a recycling of services or a reboot in some cases, but should clear within a few hours or so if not right away.

    Many clients see this on the weekends when Microsoft Update cause a system reboot.

    The best thing to do is verify "NetQos Mysql51" service is started on all servers.

    Also that after about 15 minutes after the system is rebooted that the RA data is still updating.

    If you can verify both of the above, you will most likely just need to wait for the "System Status" messages to clear on their own.



  • 2.  RE: False ODBC Connect Service and Database down Errors in System Status

    Posted Aug 27, 2013 04:59 PM
    Or you can restart the watchdog service to get it to check again immediately. If the problem still shows up after a watchdog restart, then it's a real problem (as opposed to a false alarm). It's possible that when the system starts up the watchdog makes its first check before the other services are online. In that case, it will report a false positive until the next check (15 minutes by default or next watchdog restart).


  • 3.  RE: False ODBC Connect Service and Database down Errors in System Status

    Broadcom Employee
    Posted Aug 27, 2013 05:18 PM
    Yes, recycling the watchdog usually will clear up any false messages in the system status, but I have seen many cases where the ODBC message does not clear for a few hours, even with a recycle of the Watchdog.

    The key is to make sure you are still collecting and displaying new data, and that all services are actually up.


  • 4.  RE: False ODBC Connect Service and Database down Errors in System Status

    Broadcom Employee
    Posted Aug 27, 2013 05:32 PM
      |   view attached
    For the System check the Watchdog service is actually controlled by the setting in the Administration->Watchdog Settings page whic is set to 60 minutes by default so you may have to wait a little longer for that next system check.


  • 5.  RE: False ODBC Connect Service and Database down Errors in System Status

    Posted Aug 28, 2013 09:34 AM
    Yep, usually one of the first things i change when installing NFA is to change the watchdog interval to 15 minutes (like it used to be years ago).


  • 6.  RE: False ODBC Connect Service and Database down Errors in System Status

    Broadcom Employee
    Posted Sep 12, 2013 02:54 PM
    I actually just found an issue setting the Watchdog "System Check Interval" in the NFA 9.1.3 gui, it doesn't seem to update the correct database table.

    You can force this change if needed with the query below run on the NFA console, followed by a recycle of the NFA Watchdog service.

    mysql -P3308 reporter


    update parameter_descriptions set defaultvalue=5 where parameter='watchdogSystemCheck';

    christopher_walsh wrote:

    For the System check the Watchdog service is actually controlled by the setting in the Administration->Watchdog Settings page whic is set to 60 minutes by default so you may have to wait a little longer for that next system check.


  • 7.  RE: False ODBC Connect Service and Database down Errors in System Status

    Posted Sep 12, 2013 03:49 PM
    Once again, better to run in one line to avoid accidentally messing up other tables in the database: 
    mysql -P 3308 -D reporter -e "update parameter_descriptions set defaultvalue=5 where parameter='watchdogSystemCheck';"


  • 8.  RE: False ODBC Connect Service and Database down Errors in System Status

    Broadcom Employee
    Posted Sep 12, 2013 04:10 PM
    Sure its a matter of preference