Monitor 2.3.6 Reports tables specified twice
Closed this issue · 4 comments
Hey Guys
I noticed these errors coming when while doing a poller sync
this seems to have shown up after a few devices were deleted
No impact seen to the functionality of Monitor
2020/05/08 14:04:06 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'plugin_monitor_reboot_history' is specified twice, both as a target for 'DELETE' and as a separate source for data
2020/05/08 14:04:06 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'plugin_monitor_uptime' is specified twice, both as a target for 'DELETE' and as a separate source for data
2020/05/08 14:03:10 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'plugin_monitor_reboot_history' is specified twice, both as a target for 'DELETE' and as a separate source for data
2020/05/08 14:03:10 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'plugin_monitor_uptime' is specified twice, both as a target for 'DELETE' and as a separate source for data
2020/05/08 14:02:09 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'plugin_monitor_reboot_history' is specified twice, both as a target for 'DELETE' and as a separate source for data
2020/05/08 14:02:09 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'plugin_monitor_uptime' is specified twice, both as a target for 'DELETE' and as a separate source for data
2020/05/08 14:01:09 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'plugin_monitor_reboot_history' is specified twice, both as a target for 'DELETE' and as a separate source for data
Also got this sql backtrace
2020/05/08 14:34:09 - CMDPHP SQL Backtrace: (/plugins/monitor/poller_monitor.php[87]:monitor_uptime_checker(), /plugins/monitor/poller_monitor.php[200]:db_execute(), /lib/database.php[210]:db_execute_prepared())
The backtraces and errors continued to come in every poll cycle
2020/05/08 14:36:11 - CMDPHP SQL Backtrace: (/plugins/monitor/poller_monitor.php[87]:monitor_uptime_checker(), /plugins/monitor/poller_monitor.php[200]:db_execute(), /lib/database.php[210]:db_execute_prepared())
2020/05/08 14:36:11 - CMDPHP SQL Backtrace: (/plugins/monitor/poller_monitor.php[87]:monitor_uptime_checker(), /plugins/monitor/poller_monitor.php[185]:db_execute(), /lib/database.php[210]:db_execute_prepared())
2020/05/08 14:35:10 - CMDPHP SQL Backtrace: (/plugins/monitor/poller_monitor.php[87]:monitor_uptime_checker(), /plugins/monitor/poller_monitor.php[200]:db_execute(), /lib/database.php[210]:db_execute_prepared())
2020/05/08 14:35:10 - CMDPHP SQL Backtrace: (/plugins/monitor/poller_monitor.php[87]:monitor_uptime_checker(), /plugins/monitor/poller_monitor.php[185]:db_execute(), /lib/database.php[210]:db_execute_prepared())
I disabled uninstalled and reinstalled the plugin errors have stopped now
Issue came up again
This time after a poller sync where some devices were deleted
Errors
2020/07/22 13:42:01 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'plugin_monitor_reboot_history' is specified twice, both as a target for 'DELETE' and as a separate source for data
2020/07/22 13:42:01 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'plugin_monitor_uptime' is specified twice, both as a target for 'DELETE' and as a separate source for data
2020/07/22 13:41:00 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'plugin_monitor_reboot_history' is specified twice, both as a target for 'DELETE' and as a separate source for data
2020/07/22 13:41:00 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'plugin_monitor_uptime' is specified twice, both as a target for 'DELETE' and as a separate source for data
2020/07/22 13:40:01 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'plugin_monitor_reboot_history' is specified twice, both as a target for 'DELETE' and as a separate source for data
2020/07/22 13:40:01 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'plugin_monitor_uptime' is specified twice, both as a target for 'DELETE' and as a separate source for data
2020/07/22 13:39:00 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'plugin_monitor_reboot_history' is specified twice, both as a target for 'DELETE' and as a separate source for data
2020/07/22 13:39:00 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'plugin_monitor_uptime' is specified twice, both as a target for 'DELETE' and as a separate source for data
SQL backtrace
020/07/22 13:43:01 - CMDPHP SQL Backtrace: (/plugins/monitor/poller_monitor.php[87]:monitor_uptime_checker(), /plugins/monitor/poller_monitor.php[200]:db_execute(), /lib/database.php[213]:db_execute_prepared())
2020/07/22 13:43:01 - CMDPHP SQL Backtrace: (/plugins/monitor/poller_monitor.php[87]:monitor_uptime_checker(), /plugins/monitor/poller_monitor.php[185]:db_execute(), /lib/database.php[213]:db_execute_prepared())
2020/07/22 13:42:01 - CMDPHP SQL Backtrace: (/plugins/monitor/poller_monitor.php[87]:monitor_uptime_checker(), /plugins/monitor/poller_monitor.php[200]:db_execute(), /lib/database.php[213]:db_execute_prepared())
2020/07/22 13:42:01 - CMDPHP SQL Backtrace: (/plugins/monitor/poller_monitor.php[87]:monitor_uptime_checker(), /plugins/monitor/poller_monitor.php[185]:db_execute(), /lib/database.php[213]:db_execute_prepared())
2020/07/22 13:41:00 - CMDPHP SQL Backtrace: (/plugins/monitor/poller_monitor.php[87]:monitor_uptime_checker(), /plugins/monitor/poller_monitor.php[200]:db_execute(), /lib/database.php[213]:db_execute_prepared())
2020/07/22 13:41:00 - CMDPHP SQL Backtrace: (/plugins/monitor/poller_monitor.php[87]:monitor_uptime_checker(), /plugins/monitor/poller_monitor.php[185]:db_execute(), /lib/database.php[213]:db_execute_prepared())
2020/07/22 13:40:01 - CMDPHP SQL Backtrace: (/plugins/monitor/poller_monitor.php[87]:monitor_uptime_checker(), /plugins/monitor/poller_monitor.php[200]:db_execute(), /lib/database.php[213]:db_execute_prepared())
Disabled and Uninstalled plugin reinstalled and re-enabled all good now