Peace, after zabbix database grew and hogged all the space on the server i deleted the 2 largest tables, history and trends
now in the problems page i get :
<output class="msg-bad" role="contentinfo" aria-label="Error message"><div class="msg-details"><ul class="list-dashed"><li>Error in query [SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='43547' AND h.clock>1684674338] [Table 'zabbix.history_uint' doesn't exist] [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CPartial->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getItemMacros() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() → trigger_error() in include/db.inc.php:248]</li><li>Error in query [SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='43695' AND h.clock>1684674338] [Table 'zabbix.history_uint' doesn't exist] [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CPartial->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getItemMacros() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() → trigger_error() in include/db.inc.php:248]</li><li>Error in query [SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='44007' AND h.clock>1684674338] [Table 'zabbix.history_uint' doesn't exist] [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CPartial->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getItemMacros() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() → trigger_error() in include/db.inc.php:248]</li><li>Error in query [SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='44985' AND h.clock>1684674338] [Table 'zabbix.history_uint' doesn't exist] [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CPartial->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getItemMacros() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() → trigger_error() in include/db.inc.php:248]</li><li>Error in query [SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='47341' AND h.clock>1684674338] [Table 'zabbix.history_uint' doesn't exist] [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CPartial->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getItemMacros() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() → trigger_error() in include/db.inc.php:248]</li><li>Error in query [SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='51690' AND h.clock>1684674338] [Table 'zabbix.history_uint' doesn't exist] [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CPartial->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getItemMacros() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() → trigger_error() in include/db.inc.php:248]</li><li>Error in query [SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='63466' AND h.clock>1684674338] [Table 'zabbix.history_uint' doesn't exist] [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CPartial->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getItemMacros() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() → trigger_error() in include/db.inc.php:248]</li></ul></div><button type="button" class="overlay-close-btn" onclick="jQuery(this).closest('.msg-bad').remove();" title="Close"></button></output>
now in the problems page i get :
<output class="msg-bad" role="contentinfo" aria-label="Error message"><div class="msg-details"><ul class="list-dashed"><li>Error in query [SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='43547' AND h.clock>1684674338] [Table 'zabbix.history_uint' doesn't exist] [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CPartial->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getItemMacros() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() → trigger_error() in include/db.inc.php:248]</li><li>Error in query [SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='43695' AND h.clock>1684674338] [Table 'zabbix.history_uint' doesn't exist] [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CPartial->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getItemMacros() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() → trigger_error() in include/db.inc.php:248]</li><li>Error in query [SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='44007' AND h.clock>1684674338] [Table 'zabbix.history_uint' doesn't exist] [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CPartial->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getItemMacros() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() → trigger_error() in include/db.inc.php:248]</li><li>Error in query [SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='44985' AND h.clock>1684674338] [Table 'zabbix.history_uint' doesn't exist] [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CPartial->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getItemMacros() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() → trigger_error() in include/db.inc.php:248]</li><li>Error in query [SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='47341' AND h.clock>1684674338] [Table 'zabbix.history_uint' doesn't exist] [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CPartial->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getItemMacros() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() → trigger_error() in include/db.inc.php:248]</li><li>Error in query [SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='51690' AND h.clock>1684674338] [Table 'zabbix.history_uint' doesn't exist] [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CPartial->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getItemMacros() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() → trigger_error() in include/db.inc.php:248]</li><li>Error in query [SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='63466' AND h.clock>1684674338] [Table 'zabbix.history_uint' doesn't exist] [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CPartial->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getItemMacros() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() → trigger_error() in include/db.inc.php:248]</li></ul></div><button type="button" class="overlay-close-btn" onclick="jQuery(this).closest('.msg-bad').remove();" title="Close"></button></output>
Comment