MySQL Problem - table poller_ouput

arkand · Post by **arkand** » Wed Jan 12, 2005 7:05 am

Hi !

When cacti is in use abaout 2 weeks, graphs no updating.

I use strace ( in linux ) to find this problem.

I use MySQL Administrator and MySQL Control Center to see the cacti database, and see that table poller_output not updating

I use strace ( in linux ) to find this problem.

The problem fix with empty the table poller_ouput.

This is a problem of mysql ?

Post by **rony** » Wed Jan 12, 2005 8:37 am

Maybe, but not typically...

Try deleting all the rows in poller_output, this may fix your issue.

arkand · Post by **arkand** » Wed Jan 12, 2005 9:54 am

This is the forth time that i empty the table.

Each 2 or 3 weeks, when arrive at work , i see the principal graphs and i see
that graph no updating.

After use Mysql administrador and look that the table poller_output , not updating and empty the table.

Is rare.

Any idea for fix that ?

Sorry for my English.

royce · Post by **royce** » Fri Jan 21, 2005 6:18 am

mysql> select count(*) from poller_output;
+----------+
| count(*) |
+----------+
| 9785768 |
+----------+
1 row in set (0.00 sec)

Seems that I have the same problem.

royce · Post by **royce** » Fri Jan 21, 2005 6:27 am

Well, lets se if

mysql> TRUNCATE TABLE poller_output;
Query OK, 0 rows affected (0.41 sec)

helps ...

chicago · Post by **chicago** » Thu Sep 01, 2005 10:38 am

I have the same issue

TRUNCATE TABLE poller_output;

will fix the problem but It comes back in a few hours

royce · Post by **royce** » Thu Sep 01, 2005 3:18 pm

TRUNCATE TABLE and regenerate your poller-cache.

/Christofer

jrichardson · Post by **jrichardson** » Thu Nov 10, 2005 3:40 pm

Was this issue every resolved or identified? If so, in what version is this fixed?

Post by **rony** » Thu Nov 10, 2005 3:53 pm

A crashed poller can cause this problem....

His exact issue, no, but more importantly, what is your issue?

jrichardson · Post by **jrichardson** » Thu Nov 10, 2005 4:13 pm

rony wrote:A crashed poller can cause this problem....

His exact issue, no, but more importantly, what is your issue?

To be honest, I dont know for sure 100%... After about a 7-10 days of running without issues, my cacti stops updating the RRD files (it polls fine) I get tons (> 500,000) items in my poller_output table that I must "truncate" before things start working again.

I have a sneaky feeling that php was running out of memory, it was configured via the php.ini file to use only 8M, I've since increased it to 64M to see if the issue goes away.

I'm also looking into upgrading my cacti version from 0.8.6c to 0.8.6g. I was really curious if this had been resolved and in what version so I could take a look at it in the code.

Thanks,

Post by **rony** » Thu Nov 10, 2005 4:39 pm

That upgrade would be a very good idea, not only for security fixes, but features as well.

Remember to run a check/repair on your database before you upgrade.

jrichardson · Post by **jrichardson** » Thu Nov 10, 2005 4:45 pm

I'm not so worried about the security features, it's running in a pretty secure internal only env, I just want it to not stop updating after running for days.

pestilence · Post by **pestilence** » Thu Nov 10, 2005 5:37 pm

jrichardson wrote:I'm not so worried about the security features, it's running in a pretty secure internal only env, I just want it to not stop updating after running for days.

A quick hack would be to create a shell script that would truncate the table every now and then untill the issue is resolved.

Post by **rony** » Thu Nov 10, 2005 6:21 pm

I still suggest you upgrade, security issue or not.

Because, to be honest, it's probably an issue that has been resolved in later versions.

jrichardson · Post by **jrichardson** » Thu Nov 10, 2005 6:32 pm

I am upgrading

And I'm not really happy with "quick hacks". I *think* i may have fixed it by increasing the php can allocate, we'll see. If not, we'll see after the upgrade.

Cacti

MySQL Problem - table poller_ouput

MySQL Problem - table poller_ouput

Who is online