Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-24136

Error message in Frontend is not helpful

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Won't fix
    • Icon: Major Major
    • None
    • 5.0.42, 6.0.26, 6.0.28, 6.4.11, 6.4.13, 7.0.0beta3
    • Frontend (F)
    • Support backlog

      Steps to reproduce:

      1. Open frontend, get the message:
      2. "let the game begin" (c) John Kramer

      Result:
      https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/ui/include/classes/db/DB.php#133

      Expected:

      Source code has better error description than the user error:

      		/*
      		 * Detect either the query is executable at all? If query is valid and schema is correct but query still cannot
      		 * be executed, then there is a good chance that previous transaction has left row level lock unreleased or it
      		 * is still running. In such a case execution must be stopped, otherwise it will call self::refreshIds method.
      		 */
      

      Add additional logging which can print database error in PHP error log, for example, add before https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/ui/include/classes/db/DB.php#132:

      error_log('mysqli_error: '.mysqli_error($DB['DB']));
      

      For the end user it will be helpful to see:

      • failed query - since it gives information to work with
      • information why the query was failed - locks, timeouts

            averza Andrejs Verza
            edgar.akhmetshin Edgar Akhmetshin
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: