Hi All,
At some stage a wee back, a couple of months ago I think, something broke all the event log bits in Observium. I vaguely remember it breaking after one of the sql updates that took a long time to run on the eventlog table, but I'm not certain about that.
Example images: https://dl.dropboxusercontent.com/u/106803/work/observium1.PNG https://dl.dropboxusercontent.com/u/106803/work/observium2.PNG
Table looks like this: https://dl.dropboxusercontent.com/u/106803/work/eventlog.txt
What might be the best way to fix this up? I'm not worried about any historical data so it's fine if emptying out that DB table is the fix.
Thoughts?
Regards and thanks, Michael.
______________________________________________________ This email is intended only for the person to which it is addressed and may contain confidential or legally privileged material. Any dissemination or other use of or taking of any action in reliance upon the content of this email by persons other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the email from any computer. Opinions and other information in this email that do not relate to the business of my employer are not given nor endorsed by it. Unencrypted email is not secure and may not be authentic. If you have any doubts as to the contents please telephone to confirm. OceanaGold Corporation and its related entities accept no responsibility for changes made to this email or its attachments after transmission from OceanaGold Corporation and its related entities and do not guarantee that this email or attachments are virus or error free.
I had this same problem when updating from (some really old version) to the latest 'stable' which is currently listed as 3763 at http://www.observium.org/stable.php
I confirmed that the schema on my eventlog table matched the schema of a separate, relatively new install of Observium that I had.
In order to fix it, I just upgraded to 4200. After updating to 4200 and running ''./discovery.php -h none'', it then performed db schema updates and things Just Started Working.
-Mark
On Mon, Apr 29, 2013 at 11:20 PM, Michael Davies Michael.Davies@oceanagold.com wrote:
Hi All,
At some stage a wee back, a couple of months ago I think, something broke all the event log bits in Observium. I vaguely remember it breaking after one of the sql updates that took a long time to run on the eventlog table, but I’m not certain about that.
Example images:
https://dl.dropboxusercontent.com/u/106803/work/observium1.PNG
https://dl.dropboxusercontent.com/u/106803/work/observium2.PNG
Table looks like this:
https://dl.dropboxusercontent.com/u/106803/work/eventlog.txt
What might be the best way to fix this up? I’m not worried about any historical data so it’s fine if emptying out that DB table is the fix.
Thoughts?
Regards and thanks,
Michael.
On 4210 here and it's a pretty fresh install, only a few versions back. Your stated fix did bring a few more graphs up though, unless that was just the polling overnight. Perhaps I'll wait a few days longer to see if any other graphs appear. I'm missing a few on the 'queries' and 'innodb' pages too.
Shaun
-----Original Message----- From: observium [mailto:observium-bounces@observium.org] On Behalf Of Mark Price Sent: 22 July 2013 10:44 PM To: Observium Network Observation System Subject: Re: [Observium] Event Logs Broken and Empty
I had this same problem when updating from (some really old version) to the latest 'stable' which is currently listed as 3763 at http://www.observium.org/stable.php
I confirmed that the schema on my eventlog table matched the schema of a separate, relatively new install of Observium that I had.
In order to fix it, I just upgraded to 4200. After updating to 4200 and running ''./discovery.php -h none'', it then performed db schema updates and things Just Started Working.
-Mark
On Mon, Apr 29, 2013 at 11:20 PM, Michael Davies Michael.Davies@oceanagold.com wrote:
Hi All,
At some stage a wee back, a couple of months ago I think, something broke all the event log bits in Observium. I vaguely remember it breaking after one of the sql updates that took a long time to run on the eventlog table, but I'm not certain about that.
Example images:
https://dl.dropboxusercontent.com/u/106803/work/observium1.PNG
https://dl.dropboxusercontent.com/u/106803/work/observium2.PNG
Table looks like this:
https://dl.dropboxusercontent.com/u/106803/work/eventlog.txt
What might be the best way to fix this up? I'm not worried about any historical data so it's fine if emptying out that DB table is the fix.
Thoughts?
Regards and thanks,
Michael.
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
D'oh ignore last mail from me, wrong section - apologies.
-----Original Message----- From: observium [mailto:observium-bounces@observium.org] On Behalf Of Shaun Bradley Sent: 23 July 2013 08:57 AM To: Observium Network Observation System Subject: Re: [Observium] Event Logs Broken and Empty
On 4210 here and it's a pretty fresh install, only a few versions back. Your stated fix did bring a few more graphs up though, unless that was just the polling overnight. Perhaps I'll wait a few days longer to see if any other graphs appear. I'm missing a few on the 'queries' and 'innodb' pages too.
Shaun
-----Original Message----- From: observium [mailto:observium-bounces@observium.org] On Behalf Of Mark Price Sent: 22 July 2013 10:44 PM To: Observium Network Observation System Subject: Re: [Observium] Event Logs Broken and Empty
I had this same problem when updating from (some really old version) to the latest 'stable' which is currently listed as 3763 at http://www.observium.org/stable.php
I confirmed that the schema on my eventlog table matched the schema of a separate, relatively new install of Observium that I had.
In order to fix it, I just upgraded to 4200. After updating to 4200 and running ''./discovery.php -h none'', it then performed db schema updates and things Just Started Working.
-Mark
On Mon, Apr 29, 2013 at 11:20 PM, Michael Davies Michael.Davies@oceanagold.com wrote:
Hi All,
At some stage a wee back, a couple of months ago I think, something broke all the event log bits in Observium. I vaguely remember it breaking after one of the sql updates that took a long time to run on the eventlog table, but I'm not certain about that.
Example images:
https://dl.dropboxusercontent.com/u/106803/work/observium1.PNG
https://dl.dropboxusercontent.com/u/106803/work/observium2.PNG
Table looks like this:
https://dl.dropboxusercontent.com/u/106803/work/eventlog.txt
What might be the best way to fix this up? I'm not worried about any historical data so it's fine if emptying out that DB table is the fix.
Thoughts?
Regards and thanks,
Michael.
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Waiting longer than ~10 minutes won't fix anything more.
It takes ~5 minutes to create all of the RRDs in the first poller run, and ~10 minutes to poll two values to get a delta.
adam.
On 2013-07-23 09:56, Shaun Bradley wrote:
On 4210 here and it's a pretty fresh install, only a few versions back. Your stated fix did bring a few more graphs up though, unless that was just the polling overnight. Perhaps I'll wait a few days longer to see if any other graphs appear. I'm missing a few on the 'queries' and 'innodb' pages too.
Shaun
-----Original Message----- From: observium [mailto:observium-bounces@observium.org] On Behalf Of Mark Price Sent: 22 July 2013 10:44 PM To: Observium Network Observation System Subject: Re: [Observium] Event Logs Broken and Empty
I had this same problem when updating from (some really old version) to the latest 'stable' which is currently listed as 3763 at http://www.observium.org/stable.php
I confirmed that the schema on my eventlog table matched the schema of a separate, relatively new install of Observium that I had.
In order to fix it, I just upgraded to 4200. After updating to 4200 and running ''./discovery.php -h none'', it then performed db schema updates and things Just Started Working.
-Mark
On Mon, Apr 29, 2013 at 11:20 PM, Michael Davies Michael.Davies@oceanagold.com wrote: Hi All,
At some stage a wee back, a couple of months ago I think, something broke all the event log bits in Observium. I vaguely remember it breaking after one of the sql updates that took a long time to run on the eventlog table, but I'm not certain about that.
Example images:
https://dl.dropboxusercontent.com/u/106803/work/observium1.PNG
https://dl.dropboxusercontent.com/u/106803/work/observium2.PNG
Table looks like this:
https://dl.dropboxusercontent.com/u/106803/work/eventlog.txt
What might be the best way to fix this up? I'm not worried about any historical data so it's fine if emptying out that DB table is the fix.
Thoughts?
Regards and thanks,
Michael.
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (4)
-
Adam Armstrong -
Mark Price -
Michael Davies -
Shaun Bradley