[ZBX-17924] dashboard php errors in "System information" window Created: 2020 Jun 18  Updated: 2024 Apr 10  Resolved: 2020 Jul 28

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 5.0.1
Fix Version/s: 4.0.23rc1, 5.0.3rc1, 5.2.0alpha1, 5.2 (plan)

Type: Problem report Priority: Trivial
Reporter: Tomasz Kłoczko Assignee: Mārtiņš Tālbergs (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Linux, mysql 8.0.18, php 7.4.6

Attachments: PNG File Adnotacja 2020-06-17 235959.png     PNG File Adnotacja 2020-06-22 151217.png     PNG File Adnotacja 2020-06-22 151354.png    
Issue Links:
Causes
caused by ZBXNEXT-5603 Check DB character set and collation ... Closed
Duplicate
Team: Team B
Sprint: Sprint 66 (Jul 2020)
Story Points: 1

 Description   

Steps to reproduce:

  1. Just stat web frontend

Result:

In main dashboard "System information" window are reported php errors:

Undefined index: table_name [zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → make_status_of_zbx() → MysqlDbBackend->checkEncoding() → MysqlDbBackend->checkTablesEncoding() → DBfetchColumn() in include/db.inc.php:846]Undefined index: table_name [zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → make_status_of_zbx() → MysqlDbBackend->checkEncoding() → MysqlDbBackend->checkTablesEncoding() → DBfetchColumn() in include/db.inc.php:846]Undefined index: table_name [zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → make_status_of_zbx() → MysqlDbBackend->checkEncoding() → MysqlDbBackend->checkTablesEncoding() → DBfetchColumn() in include/db.inc.php:846]Undefined index: table_name [zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → make_status_of_zbx() → MysqlDbBackend->checkEncoding() → MysqlDbBackend->checkTablesEncoding() → DBfetchColumn() in include/db.inc.php:846]Undefined index: table_name [zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → make_status_of_zbx() → MysqlDbBackend->checkEncoding() → MysqlDbBackend->checkTablesEncoding() → DBfetchColumn() in include/db.inc.php:846]Undefined index: table_name [zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() 

[..]

→ ZBase->processResponseFinal() → CView->getOutput() → include() → make_status_of_zbx() → MysqlDbBackend->checkEncoding() → MysqlDbBackend->checkTablesEncoding() → DBfetchColumn() in include/db.inc.php:846]

 

See screenshot...
See log file...
See memory dump...
Expected:
See screenshot....
See attached patch file...

 Comments   
Comment by Aigars Kadikis [ 2020 Jun 19 ]

Thank you for reporting this issue. To minimize the scope of the problem do you receive the same outcome while browsing system information from a dedicated section: "Reports" => "System information"?

Comment by Tomasz Kłoczko [ 2020 Jun 22 ]

In dashboard is widget type ""System information". And yes .. Reports ->  "System information" has the same issue.

Comment by Mārtiņš Tālbergs (Inactive) [ 2020 Jul 01 ]

Hi kloczek, I cannot reproduce this error on mysql 8.0.18, php 7.4.6.
Could you please answer few questions to help us out?

  • Is this problem persistent or happens just occasionally?
  • What is the output of 
    mysql> select @@default_authentication_plugin;
  • Output of such query (using the same user used by frontend) 
    SELECT table_name, column_name, character_set_name, collation_name, column_type, privileges FROM information_schema.columns where table_schema='<YOUR-DATABASE-NAME-HERE>';
  • Any other information you might think could be useful.

Much appreciated in advance.

Comment by Tomasz Kłoczko [ 2020 Jul 01 ]

Problem is persistent.

Started after upgrade from 4.8.x.

I'll check database scheme definition later.

Comment by Tomasz Kłoczko [ 2020 Jul 03 ]

Sorry I had no time to chech DB schema in meantime.

So this issue is possoible to catch only on upgrade?

Comment by Mārtiņš Tālbergs (Inactive) [ 2020 Jul 03 ]

FIXED in development branch feature/ZBX-17924-5.0, feature/ZBX-17924-4.0

Comment by Mārtiņš Tālbergs (Inactive) [ 2020 Jul 03 ]

MySQL 8 users encounter this issue when upgrading to 4.0.18rc1 4.4.6rc1 or 5.0.0alpha2 meanwhile using unsupported character set in some table fields.

No such issue observed in MariaDB 15.1 or MySQL 5.7.

Comment by Mārtiņš Tālbergs (Inactive) [ 2020 Jul 15 ]

Available in:

Generated at Sun Apr 20 21:07:47 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.