poller sql errors

[sov2000]

I'm new to cacti but was able to get it up and running quite easily ... However, I get kinda random error that halts data collection.

07/23/2007 01:44:56 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "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) LIMIT 10000"
07/23/2007 01:44:56 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select poller_id,end_time from poller_time where poller_id = 0"

This is what I get in the log file over and over with interval of just one second. PS shows poller running and killing it and starting manually seems to getting things back to normal. I can also run the queries from mysql console without errors but one of them returns empty set.

Just wondering if it's a known issue or if I'm screwing something up.

OpenBSD 4.0

mysqld Ver 5.0.22 on i386 (OpenBSD port: mysql-server-5.0.22)

Cacti Version 0.8.6j

PHP 5.1.4 (cli) (built: Sep 1 2006 02:10:39)
Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies

NET-SNMP Support => enabled
NET-SNMP Version => 5.1.3

RRDtool 1.0.49

thanks for looking ...

[gandalf]

You're running cacti 0.8.6j? Please make sure to have all patches installed: http://www.cacti.net/download_patches.php
Reinhard

[sov2000]

thanks for the reply ... I've patched snmpwalk issue after the fact ... the rest do not seem to be relevant to my issue at all but I will patch the rest anyway.

[sov2000]

Actually, I think the problem is MySQL and not Cacti. After performing certain task in Cacti (not sure what) mysql freaks out and stop working partially or all together. If I try to login from mysql console this is what I get ...

ERROR 2013 (HY000): Lost connection to MySQL server during query

Does anyone know what this error might mean ... so far I am not able to find definitive answer but I'll keep searching.

[gandalf]

Try to set max_connection limit to sth like 500 instead of default=100. Restart MySQL and httpd afterwards
Reinhard