Ad Widget

Collapse

SQL Deadlocks / Not logged in on Dashboard

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • AWHarvard
    Junior Member
    • Feb 2023
    • 3

    #1

    SQL Deadlocks / Not logged in on Dashboard

    Hi all,

    I've done a new Zabbix Setup with the latest release on Debian 11 and MySQL running in Zabbix native HA mode.
    I face two issues at the moment, not sure what causes these.
    On the currently primarys Dashboard some of the widgets will often (every few minutes) show SQL Deadlocks or "You are not logged in" messages.
    Just waiting or reloading the page will make them disappear for a few minutes until it starts over again.

    SQL Deadlock error:
    Error in query [COMMIT] [Deadlock found when trying to get lock; try restarting transaction] [zabbix.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() → trigger_error() in include/db.inc.php:367]
    Not sure what causes these issue, the MySQL DB server is also the latest release running only that one Zabbix DB on the entire machine.
    Any ideas about that issue? Never faced anything in all my Zabbix setups.​
  • Monck
    Junior Member
    • Nov 2024
    • 2

    #2
    Hi AWHarvard , Did you solve it? I have the same error

    Comment

    Working...