Database Problems after upgrade to 0.8.7g

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Developers, Moderators

Post Reply
larswars
Posts: 1
Joined: Wed Apr 14, 2010 6:52 am

Database Problems after upgrade to 0.8.7g

Post by larswars »

Hi,
i just upgraded my Cacti (CactiEZ) up to version 0.8.7g. Now my cacti is not polling. It seems to be a problem with the database. Does anybody had the same or similar problems?
Here are some Details from the log file:

10/27/2010 11:24:43 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"replace into settings values('weathermap_render_counter',371)'
10/27/2010 11:24:43 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"replace into settings values('weathermap_last_finish_time','1288196683')'
10/27/2010 11:24:43 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"replace into settings values('weathermap_last_stats','Wed, 27 Oct 2010 11:24:43 CDT: 0 maps were run in 0 seconds with 0 warnings.')'
10/27/2010 11:24:43 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'0', SQL:"select m.*, g.name as groupname from weathermap_maps m,weathermap_groups g where m.group_id=g.id and active='on' order by sortorder,id"
10/27/2010 11:24:43 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"replace into settings values('weathermap_last_start_time','1288196683')'
10/27/2010 11:24:43 AM - 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"
10/27/2010 11:24:43 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('stats_recache','RecacheTime:0.0 HostsRecached:0')'
10/27/2010 11:24:43 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'0', SQL:"SELECT COUNT(*) FROM poller_command"
10/27/2010 11:24:43 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('stats_poller','Time:0.0040 Method:spine Processes:3 Threads:1 Hosts:0 HostsPerProcess:0 DataSources:301 RRDsProcessed:0')'
10/27/2010 11:24:43 AM - SYSTEM STATS: Time:0.0040 Method:spine Processes:3 Threads:1 Hosts:0 HostsPerProcess:0 DataSources:301 RRDsProcessed:0
10/27/2010 11:24:43 AM - 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) "
10/27/2010 11:24:43 AM - 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'"
10/27/2010 11:24:43 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'0', SQL:"REPLACE INTO settings (name,value) VALUES ('date',NOW())'
10/27/2010 11:24:43 AM - 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"

Thank you for some help.
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Re: Database Problems after upgrade to 0.8.7g

Post by gandalf »

It was reported, that lib/database.php of branches/0.8.7 has solved the issue. Due to vacancies, I don't know wether his has already been posted as a patch
R.
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests