- observium - lists.observium.org

Re: [Observium] mysqld: The table 'ports_cbqos' is full - solved, probably
by Fältman, Mikael 20 Feb '16

20 Feb '16

Hi again. Increased innodb_buffer_pool_size and restarted mysqld - solved the problem. Buffer_pool_size has probably nothing to do with this issue but I was also getting warnings about buffer pool is occupied by InnoDB: lock heaps or the adaptive hash index. It is a good thing to sometimes keep a peek into /var/log/mysqld.log file (or where ever it is stored). BR Mikael From: observium [mailto:observium-bounces@observium.org] On Behalf Of Fältman, Mikael Sent: den 18 februari 2016 10:27 To: Observium Network Observation System Subject: [Observium] mysqld: The table 'ports_cbqos' is full Hello. Running: Observium CE 0.16.1.7533 on RedHat 6.4 Keep getting this error msg in /var/log/mysqld.log 160218 10:21:28 [ERROR] /usr/libexec/mysqld: The table 'ports_cbqos' is full What can I do to fix it ? Disk space is available. BR Mikael

3 3

Development questions
by Philipp Griess 19 Feb '16

19 Feb '16

Dear all, I am currently developing a new application agent for Oracle databases and need some guidance on how to implement it properly. My first goal is to get the current and historical usage of each tablespace - a DB consists of multiple tablespaces. This would give a good overview of data growth inside a database. My application agent running on my DB is polling the data via SQL and returning it to observium as comma spaced values. The output looks as follows: CIT;600;596.63 COMPASS;28488;1406.5 COMPASS_IDX;27996;1568.06 CONFIG;1000;959.69 CONTROLLING;600;596.69 CSR;40960;4966 Now I'm almost at my question. All existing application agents I know are rather static, containing only certain fixed (and hard coded) entities. Tablespaces are much like storage in my point of view so I think it would be a good idea to implement them as a new storage-type in the storage table of the observium database. Is this a proper way to do it or do you suggest a different approach? I'd like to be as compatible as possible to future updates and would also contribute my code if anyone needs it. Please let me know your thoughts. Thanks and kind regards, Philipp

1 0

mysqld: The table 'ports_cbqos' is full
by Fältman, Mikael 18 Feb '16

18 Feb '16

Hello. Running: Observium CE 0.16.1.7533 on RedHat 6.4 Keep getting this error msg in /var/log/mysqld.log 160218 10:21:28 [ERROR] /usr/libexec/mysqld: The table 'ports_cbqos' is full What can I do to fix it ? Disk space is available. BR Mikael

1 0

Fwd: Removing Dashboard
by Andres P 18 Feb '16

18 Feb '16

Hi Guys! After do the observium upgrade appears in the frontpage on the left a Dashboard, there is any form to remove it and come back to the old template. Regards Andres

3 3

Unknown Locations in Device > Locations menu
by Jacob Bisby 18 Feb '16

18 Feb '16

Hi All I'm having some trouble with Observium's mapping - we have it configured to build the Location list and geolocation, etc automatically based on the address/location pulled via SNMP. This works for almost every device we have, but there are two devices which show up under Unknown Location, even though Observium has pulled correct and valid address data for them. It does not appear to successfully pull co-ordinates for the address either, as the two devices appear on the map in the middle of the ocean. I have tried switching from the Yahoo API to the Google API (with API key) but this has not changed the behaviour of the issue. Currently on version 0.16.2.7592, we update via SVN once a month and we were having this same issue on 0.16.1.x as-well. Hoping somebody here has seen this issue before and can help me out or point me in the right direction.

2 5

High CPU usage on Observium
by Jose Colin 17 Feb '16

17 Feb '16

Hello Guys i see a lot of php processes running on the server, do you have any idea about this behavior if it needs to change some configuration stuff? top - 23:43:36 up 1:33, 1 user, load average: 19.78, 18.44, 16.29 Tasks: 240 total, 24 running, 216 sleeping, 0 stopped, 0 zombie %Cpu(s): 82.7 us, 16.6 sy, 0.0 ni, 0.0 id, 0.0 wa, 0.0 hi, 0.7 si, 0.0 st KiB Mem: 3945832 total, 2334788 used, 1611044 free, 235988 buffers KiB Swap: 4194300 total, 0 used, 4194300 free. 954876 cached Mem PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 12364 root 20 0 136472 30692 10532 R 4.983 0.778 0:22.10 php 23927 root 20 0 139032 33248 10536 R 4.983 0.843 0:39.62 php 32704 root 20 0 145432 39780 10536 R 4.983 1.008 1:11.48 php 30112 root 20 0 134652 28824 10532 R 3.654 0.730 0:16.65 php 5722 root 20 0 155420 49628 10536 R 3.322 1.258 2:25.48 php 17915 root 20 0 133372 27524 10532 S 3.322 0.698 0:09.60 php 20140 root 20 0 152344 46608 10536 R 3.322 1.181 1:55.92 php 26947 root 20 0 136984 31220 10536 R 3.322 0.791 0:26.82 php 10380 root 20 0 154136 48280 10536 S 2.990 1.224 2:10.99 php 20593 root 20 0 142360 36632 10536 S 2.990 0.928 0:55.83 php 30207 root 20 0 151320 45408 10536 S 2.990 1.151 1:50.79 php 1680 mysql 20 0 979436 141336 7308 S 2.326 3.582 1:15.83 mysqld 17979 root 20 0 143896 38228 10536 R 2.326 0.969 1:06.13 php 530 root 20 0 133884 28112 10532 R 1.993 0.712 0:11.50 php 9628 root 20 0 138520 32664 10536 R 1.993 0.828 0:33.49 php 30062 root 20 0 148504 42712 10536 R 1.661 1.082 1:28.73 php 6361 root 20 0 141088 35480 10536 S 1.329 0.899 0:47.94 php 3407 root 20 0 142616 36804 10536 S 0.997 0.933 1:00.61 php 13068 root 20 0 150040 44220 10536 S 0.997 1.121 1:41.53 php 15851 root 20 0 152600 46744 10536 R 0.997 1.185 2:02.85 php 8427 root 20 0 154648 48844 10536 S 0.664 1.238 2:19.62 php 15440 root 20 0 146456 40572 10536 S 0.664 1.028 1:19.81 php 595 root 20 0 12032 3800 672 S 0.332 0.096 0:14.53 haveged 3474 root 20 0 133116 27260 10532 S 0.332 0.691 0:07.57 php 11900 root 20 0 16100 1692 1108 R 0.332 0.043 0:03.48 top 12576 root 20 0 153112 47328 10536 S 0.332 1.199 2:07.73 php thanks for your attention. Jose

3 5

Missing dBm in Cisco IOS
by chott＠praha1.net 17 Feb '16

17 Feb '16

Hello team, after some upgrade in history now missing SFP dBm in Cisco 3750 platform in Cisco Catalyst 6500 show dBm SFPs [email-header-praha1] Tomas Chott technický ředitel chott(a)praha1.net<mailto:chott@praha1.net> Phone: +420 245 004 005 Mobile: +420 733 123 135 Metropolitní síť Praha 1 z.s.p.o. Jindrisska 18 110 00 Praha 1 Czech Republic www.praha1.net<http://www.praha1.net> [Popis: Facebook]<http://www.facebook.com/praha1net> <http://www.linkedin.com/pub/tomas-chott/49/97a/1aa>

2 2

Device mix-up
by Laz C. Peterson 17 Feb '16

17 Feb '16

So, weird thing happened today … We had a network outage that lasted for maybe 45 minutes that kept Observium from monitoring one site. When Observium resumed its normal monitoring activities, it somehow added a whole bunch of inventory items for a Cisco router to a KVM virtual server. About 10 minutes ago, it deleted all of the Cisco items, and is now back to normal. Has anyone seen anything like this before? Does anyone know what might have caused this? ~ Laz Peterson Paravis, LLC

2 3

Traffic Accounting not updating
by Cameron Murray 16 Feb '16

16 Feb '16

Adam, It appears that our OBS isn't updating the accounting details such as 95%ile. The cron task is identical to the how-to. What command can we run to manually update these figures?

3 6

Purchase observium subscription for multiple years (2-3)
by Arya, Renuka [MED] 16 Feb '16

16 Feb '16

Hi Team, Our subscription for the year 2015 has been expired. Is there a way we can by the subscription for Observium for multiple years (2 or 3 years)? Please let us know. Thanks! Regards Renuka ******************************************************************************** This e-mail is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged and confidential. If the reader of this e-mail message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is prohibited. If you have received this e-mail in error, please notify the sender and destroy all copies of the transmittal. Thank you University of Chicago Medicine and Biological Sciences ********************************************************************************

2 1