Uploaded image for project: 'Network Controller'
  1. Network Controller
  2. SDNC-343

DB liveness probe generates unnecessary logs

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Medium Medium
    • Montreal Release
    • None
    • None
    • None

      Currently the liveness probe for the MySQL instances uses a simple "mysqladmin ping" command.  This works, but because it doesn't include a password, in causes logs to be generated on all the mysql containers every time it's executed:

      $ kubectl logs devel-sdnc-db-0 sdnc-db -n onap
      2018-06-14T19:51:40.774797Z 103989 [Note] Access denied for user 'root'@'localhost' (using password: NO)
      2018-06-14T19:51:50.788236Z 103991 [Note] Access denied for user 'root'@'localhost' (using password: NO)
      2018-06-14T19:52:00.770945Z 103993 [Note] Access denied for user 'root'@'localhost' (using password: NO)
      2018-06-14T19:52:10.784275Z 103995 [Note] Access denied for user 'root'@'localhost' (using password: NO)
      2018-06-14T19:52:20.775057Z 103997 [Note] Access denied for user 'root'@'localhost' (using password: NO)
      2018-06-14T19:52:30.778865Z 103999 [Note] Access denied for user 'root'@'localhost' (using password: NO)
      2018-06-14T19:52:40.784963Z 104001 [Note] Access denied for user 'root'@'localhost' (using password: NO)
      2018-06-14T19:52:50.771771Z 104003 [Note] Access denied for user 'root'@'localhost' (using password: NO)
      2018-06-14T19:53:00.778772Z 104005 [Note] Access denied for user 'root'@'localhost' (using password: NO)
      2018-06-14T19:53:10.771761Z 104007 [Note] Access denied for user 'root'@'localhost' (using password: NO)
      2018-06-14T19:53:20.783283Z 104009 [Note] Access denied for user 'root'@'localhost' (using password: NO)
      

       

      It is noted and understood that MySQL will be replaced by a Galera cluster in the Casablanca release.  This task seeks to ensure that the liveness probe for Galera does not have this same kind of flaw.

       

       

            djtimoney Dan Timoney
            jmac jmac
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: