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

2010-09-22 Thread sean finney
hi teodor, thanks for looking into this! On Wed, Sep 22, 2010 at 02:58:28AM +0300, Teodor MICU wrote: I've been able to reproduce the problem. So far the problem will appear any time I'll activate 'spine' poller. One weird thing is that both CMDPHP and SPINE are present in the cacti.log as if

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

2010-09-22 Thread Teodor MICU
Hi, On Tue, Sep 21, 2010 at 11:56 PM, sean finney sean...@debian.org wrote: some ideas/questions off the top of my head:  * did you get any sql upgrade errors after the package was updated? There were no sql upgrade scripts from 0.8.7e-4 to 0.8.7g-1. The upgrade says clearly that there are no

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

2010-09-22 Thread Teodor MICU
Hi, On Wed, Sep 22, 2010 at 9:23 AM, sean finney sean...@debian.org wrote: do you get the same problems if you also upgrade spine from the lenny version to the squeeze version (0.8.7e-2)?  i wouldn't be surprised that the poller from lenny is designed for different sql/schema and thus might

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

2010-09-22 Thread Teodor MICU
On Wed, Sep 22, 2010 at 10:57 AM, Teodor MICU mteo...@gmail.com wrote: On Tue, Sep 21, 2010 at 11:56 PM, sean finney sean...@debian.org wrote: some ideas/questions off the top of my head:  * did you get any sql upgrade errors after the package was updated? There were no sql upgrade scripts

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

2010-09-22 Thread Teodor MICU
Hi, On Wed, Sep 22, 2010 at 10:57 AM, Teodor MICU mteo...@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

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

2010-09-22 Thread Teodor MICU
[really attaching the SQL select queries] mysql use cacti; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql SELECT id FROM host WHERE disabled = '' ORDER BY id; ++ | id | ++ | 1 | |

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

2010-09-22 Thread Teodor MICU
Hi, On Wed, Sep 22, 2010 at 12:00 PM, Stephane Dudzinski steph...@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                          

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

2010-09-22 Thread Stephane Dudzinski
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

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

2010-09-22 Thread Stephane Dudzinski
On Wed, 2010-09-22 at 12:09 +0300, Teodor MICU wrote: This was not purged, so I guess you are running Debian 5.0 (lenny). no, -- System Information: Debian Release: squeeze/sid APT prefers testing APT policy: (500, 'testing') Architecture: amd64 (x86_64) We don't use cacti-spine, I

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

2010-09-22 Thread Stephane Dudzinski
On Wed, 2010-09-22 at 12:09 +0300, Teodor MICU wrote: Hi, On Wed, Sep 22, 2010 at 12:00 PM, Stephane Dudzinski steph...@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

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

2010-09-22 Thread Teodor MICU
Hi, On Wed, Sep 22, 2010 at 4:48 PM, Stephane Dudzinski steph...@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

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

2010-09-22 Thread Stephane Dudzinski
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

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

2010-09-22 Thread sean finney
hiya, i'll group two replies together here. On Wed, Sep 22, 2010 at 10:57:10AM +0300, Teodor MICU wrote:  * does the schema seem correct (i.e. a disabled column in the host table)? I don't know anything related to a 'schema', so probably not the issue. If you can tell me what to check,

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

2010-09-21 Thread Teodor MICU
retitle 531546 empty graphs due to 'A DB Exec Failed' Poller[0] ERROR quit Hi, It seems that this old problem has an impact on 'squeeze' too. After upgrading from v0.8.7e-4 to 0.8.7g-1 all the graphs were with NaN from this point forward. The error message in cacti.log was like in the attached

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

2010-09-21 Thread sean finney
hi, On Tue, Sep 21, 2010 at 11:02:37PM +0300, Teodor MICU wrote: I'll probably attempt a new upgrade soon, do you have any recommendations? some ideas/questions off the top of my head: * did you get any sql upgrade errors after the package was updated? * does the schema seem correct (i.e. a

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

2010-09-21 Thread Teodor MICU
Hi again, On Tue, Sep 21, 2010 at 11:02 PM, Teodor MICU mteo...@gmail.com wrote: It seems that this old problem has an impact on 'squeeze' too. After upgrading from v0.8.7e-4 to 0.8.7g-1 all the graphs were with NaN from this point forward. I've been able to reproduce the problem. So far the