Bug#531546: empty graphs due to 'A DB Exec Failed' Poller[0] ERROR

Teodor MICU

unread,

Sep 22, 2010, 5:00:02 AM9/22/10

to

[really attaching the SQL select queries]

cacti-sql-select-queries.txt

Teodor MICU

unread,

Sep 22, 2010, 5:00:02 AM9/22/10

to

Hi,

On Wed, Sep 22, 2010 at 10:57 AM, Teodor MICU <mte...@gmail.com> wrote:
> Yes, with 'cmd.php' I get the graphs but still at every 5 minutes
> there are SQL errors reported (see attached).

Ok, the last test reveals that with 'cmd.php' used directly after
upgrade the same SQL errors will appear after the first 5 minutes
cycle (see attached file). See that the 'select' queries in the
database are good with some notes:
- there is a missing " in the log at 11:35:34 regarding SQL:"REPLACE INTO;
- I've executed only the 'select' queries.

Another problem seems that 'cmp.php' poller is executes more than 60
seconds which leads to overlapping:
09/22/2010 11:35:01 AM - POLLER: Poller[0] WARNING: There are '1'
detected as overrunning a polling process, please investigate
Shall I open a new bug report for this?

I'll revert to 0.8.7e-4 and test a fresh 'cacti=0.8.7g-1' install on a
virtual machine.

Thanks

cacti-cmdphp-err2.log

Stephane Dudzinski

unread,

Sep 22, 2010, 5:30:02 AM9/22/10

to

> > There were no sql upgrade scripts from 0.8.7e-4 to 0.8.7g-1. The
> > upgrade says clearly that there are no scripts to run.

We did upgrade a box from Lenny to Squeeze and it indeed kept all its
graphs this time, this is what we are currently using:

ii rrdtool 1.4.3-1
ii cacti 0.8.7e-4
rc cacti-spine 0.8.7a-2.3

We don't use cacti-spine, I have set up the following:
Under General:
RRDTool 1.3.x (no option for 1.4.x)
Uner Poller:
cmd.php
Ping and SNMP
UDP Ping

Your mileage may vary.

Cheers,
Steph

signature.asc

Stephane Dudzinski

unread,

Sep 22, 2010, 10:00:02 AM9/22/10

to

On Wed, 2010-09-22 at 12:09 +0300, Teodor MICU wrote:
> Hi,
>

> On Wed, Sep 22, 2010 at 12:00 PM, Stephane Dudzinski
> <step...@cp.dias.ie> wrote:
> > We did upgrade a box from Lenny to Squeeze and it indeed kept all its
> > graphs this time, this is what we are currently using:
> >
> > ii rrdtool 1.4.3-1
> > ii cacti 0.8.7e-4
>

> Ok, this is the last cacti version that works for me too (actually all
> have worked fine except the last one v0.8.7g). I guess rrdtool=1.4.x
> you have it from backports or you run Debian 6.0?

I have just upgraded to 0.8.7g-1, backed up the DB before doing so then
did the web interface upgrade steps, it said there was no SQL upgrade.
And it is still happily graphing.

So I am guessing your problem is probably with cacti-spine (that I am
not using). Different bug if you ask me.

Cheers,
Steph

--
Stephane Dudzinski - IT Manager
DIAS - http://www.dias.ie -
Phone : VoIP +353-1-4406656 x 335

signature.asc

Teodor MICU

unread,

Sep 22, 2010, 12:10:01 PM9/22/10

to

Hi,

On Wed, Sep 22, 2010 at 4:48 PM, Stephane Dudzinski <step...@cp.dias.ie> wrote:
> I have just upgraded to 0.8.7g-1, backed up the DB before doing so then
> did the web interface upgrade steps, it said there was no SQL upgrade.
> And it is still happily graphing.
>
> So I am guessing your problem is probably with cacti-spine (that I am
> not using). Different bug if you ask me.

Yes, it was working for me too (happily graphing) if I used 'cmd.php'
which you also use. But also, check the 'cacti.log' file for SQL
errors.

Thanks

--
To UNSUBSCRIBE, email to debian-bugs-...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listm...@lists.debian.org

Stephane Dudzinski

unread,

Sep 22, 2010, 12:10:01 PM9/22/10

to

On Wed, 2010-09-22 at 18:57 +0300, Teodor MICU wrote:
> Yes, it was working for me too (happily graphing) if I used 'cmd.php'
> which you also use. But also, check the 'cacti.log' file for SQL
> errors.

I get no error on my side. Just to add to this, my install was a fresh
install of Lenny from last April which I upgraded to Squeeze about a
month ago.

signature.asc