Cacti

I worked around the issue by disabling the database disconnect/reconnect in poller.php. This is fine for my installation and fully resolves the issue. I still don't understand the underlying cause, even though initial debugging was pointing to an issue with db_connect_real. When it tried to re-conne...

I have also opened a question about this issue on ServerFault: http://serverfault.com/questions/403566 ... ses/403736
The "analysis" might be better documented over there.

When I find the source of the issue, I'll post it.

So, I enabled logging in mysqld as it seemed logical to see what queries are actually being performed. And, to my surprise, there aren't any queries being performed when the error happens. This is what I see at the end of my log: 485 Query select value from `cacti`.`settings` where name='log_verbosi...

I can't help but feel like there is an issue with the database abstraction (at least that's what it looks like right now). To determine why db_fetch_cell would not return the correct number of finished processes, I extended poller.php further: while (1) { $finished_processes = db_fetch_cell("SE...

That is an indicator that the setting originated from php.ini. On Debian the CLI version of the php.ini (/etc/php/cli/php.ini) defaults to setting -1 as the memory_limit. This is the cause of this error.

Well, something is definitely broken here. I tried to execute several different SQL queries against the database (at the location where I determined the failure), and they always return empty result sets. Which makes no sense at all. Some research into the "Maximum runtime exceeded" messag...

After looking further, the source seems to be within db_fetch_cell if (($query) || ($db_conn->ErrorNo() == 1032)) { if (!$query->EOF) { if ($col_name != '') { $column = $query->fields[$col_name]; }else{ $column = $query->fields[0]; } $query->close(); return($column); } }else if (($db_conn->ErrorNo()...

I installed Cacti on a fresh Debian server yesterday (from the official APT repository). I configured a few more data sources for the local system and created graphs for it. Sadly, no values are being graphed. So I started debugging and quickly spotted this in my cacti.log: POLLER: Poller[0] Maximum...