[solved] Upgrade from 0.8.7f to 0.8.7g - Errors

MrBr · Post by **MrBr** » Mon Aug 09, 2010 9:51 am

Hi all
I've successfully upgraded my cacti from 0.8.7f to 0.8.7g however there are some issues appeared:

1) While installing html_output.patch patch I've received an error message

patching file lib/html_form.php
patching file lib/data_query.php
patching file data_sources.php
Hunk #1 succeeded at 911 (offset 12 lines).
Hunk #2 FAILED at 1322.
1 out of 2 hunks FAILED -- saving rejects to file data_sources.php.rej
patching file graphs.php
Hunk #1 succeeded at 1327 (offset 10 lines).

2) While importing pa.sql following error appeared

ERROR 1050 (42S01) at line 5: Table 'plugin_config' already exists

3) Following SQL errors started to appear in log file

08/09/2010 05:49:33 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', SQL:"SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'poller_bottom' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'poller_bottom' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"
08/09/2010 05:49:33 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q "/var/www/cacti/poller_export.php"]
08/09/2010 05:49:33 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('stats_recache','RecacheTime:0.0 HostsRecached:0')'
08/09/2010 05:49:33 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'0', SQL:"SELECT COUNT(*) FROM poller_command"
08/09/2010 05:49:33 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('stats_poller','Time:0.0034 Method:cmd.php Processes:40 Threads:N/A Hosts:0 HostsPerProcess:0 DataSources:296 RRDsProcessed:0')'
08/09/2010 05:49:33 PM - SYSTEM STATS: Time:0.0034 Method:cmd.php Processes:40 Threads:N/A Hosts:0 HostsPerProcess:0 DataSources:296 RRDsProcessed:0
08/09/2010 05:49:33 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', SQL:"select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) "
08/09/2010 05:49:33 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'0', SQL:"SELECT count(*) FROM poller_time WHERE poller_id=0 AND end_time>'0000-00-00 00:00:00'"
08/09/2010 05:49:33 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('date',NOW())'
08/09/2010 05:49:33 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', SQL:"SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'poller_command_args' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'poller_command_args' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"
08/09/2010 05:49:33 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', SQL:"SELECT local_data_id, rrd_name FROM poller_output"
08/09/2010 05:49:33 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"TRUNCATE TABLE poller_time'
08/09/2010 05:49:33 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'0', SQL:"SELECT count(*) FROM poller_time WHERE end_time='0000-00-00 00:00:00'"
08/09/2010 05:49:33 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('path_webroot','/var/www/cacti')'
08/09/2010 05:49:33 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', SQL:"SELECT id FROM host WHERE disabled = '' ORDER BY id"
08/09/2010 05:49:33 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', SQL:"SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'poller_top' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'poller_top' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

Most disturbing is the SQL error, what does it means? How will it effect the graphs if any?

Thanks

BSOD2600 · Post by **BSOD2600** » Mon Aug 09, 2010 12:09 pm

1) How was your cacti installed... manually or via a package? IF the latter, it's possible the package maintainer borked up the files. I'd recommend manually downloading/installing the cacti files.

2) You don't reinstall pa.sql once it's already installed.

3) cacti technical support page show any errors? Looks like your mysql tables are missing/broken.

MrBr · Post by **MrBr** » Tue Aug 10, 2010 7:05 am

1) Cacti been installed manually
2) Thanks, good to know. There is no mentioning of this fact in any manual
3) No errors on tech support page, in MySQL Table Information "Check Status" is OK for all tables

venquessa · Post by **venquessa** » Tue Aug 10, 2010 8:34 am

Same here.

Installed CentOS today.
Installed Cacti.
Verified Cacti was running.
Added a host.
Added some graphs.
WOOHOO, pretty graphs working.

Went to lunch, came back
Graphs have stopped logging any thing and 100s of the exact same errors as the OP.

I modified nothing over lunch I was no where near the box.

"Error: '0'" Is 0 not success?

EDIT: Further, if I log into the DB the queries it is complaining about execute fine.

Paul

venquessa · Post by **venquessa** » Tue Aug 10, 2010 9:54 am

Well, it started working again, on it's own.

At least it has the decency to fix itself after it broke itself.

Post by **TheWitness** » Tue Aug 10, 2010 1:41 pm

The SQL Errors were related to a glibc issue on RHEL5. It was seen in many other OS' as well and has been patched across the globe by many distro maintainers.

TheWitness

MrBr · Post by **MrBr** » Tue Aug 10, 2010 3:59 pm

The SQL Errors were related to a glibc issue on RHEL5

Can you be a little more specific? Is there any way to overcome this? System upgrade?

Post by **TheWitness** » Tue Aug 10, 2010 4:02 pm

We have a new lib/database.php that was being tracked by Gandalf that is a workaround for the issue. Please PM him this ticket. Don't recall if he committed it yet.

TheWitness

MrBr · Post by **MrBr** » Tue Aug 10, 2010 4:14 pm

Thanks. Sent him PM.
Does this issue causes any problems beside error messages in the log file?

Post by **TheWitness** » Tue Aug 10, 2010 4:45 pm

Yes but another workaround is to backoff the lib/database.php to the e version.

ThrWitness

Post by **gandalf** » Wed Aug 11, 2010 1:31 pm

MrBr wrote:Thanks. Sent him PM.
Does this issue causes any problems beside error messages in the log file?

As pm'ed back, please download from SVN/branches/087
R.

Post by **TheWitness** » Wed Aug 11, 2010 5:07 pm

I just confirmed the wonky behavior of Cacti on RHEL4. The most up-to-date lib/database.php will correct the behavior (confirmed that too).

TheWitness

MrBr · Post by **MrBr** » Thu Aug 12, 2010 5:00 am

Problem solved by using latest version of lib/database.php Revision 6095
OS: CentOS release 5.5
Thanks guys

And what about the first problem I've mentioned, the html_output.patch issue?

Post by **TheWitness** » Thu Aug 12, 2010 7:46 am

That looks more PIA related. There will be a PIA 2.9 released likely this weekend and the PIA 2.9beta1 is already published.

[solved] Upgrade from 0.8.7f to 0.8.7g - Errors

[solved] Upgrade from 0.8.7f to 0.8.7g - Errors

Who is online