ovirt_engine_history=> SELECT schemaname,relname,n_live_tup
ovirt_engine_history-> FROM pg_stat_user_tables
ovirt_engine_history-> ORDER BY n_live_tup DESC;
schemaname | relname | n_live_tup
------------+-----------------------------------+------------
public | vm_interface_samples_history | 14825449
public | vm_disks_usage_samples_history | 3317022
public | vm_samples_history | 2008714
public | vm_interface_hourly_history | 1911237
Archit Sharma arcolife
arcolife
/ sar-index.cfg.example
Created
August 8, 2017 09:46
sarjitsu backend conf sample (standalone runs)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [ElasticSearch] | |
| host = 0.0.0.0 | |
| port = 9200 | |
| [Settings] | |
| index_prefix = sarjitsu | |
| index_version = 1 | |
| bulk_action_count = 2000 | |
| number_of_shards = 5 | |
| number_of_replicas = 1 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| sarjitsu api 465a6dd113ae 4 weeks ago 851.6 MB | |
| sarjitsu proxy 6f6b6beade38 4 weeks ago 674 MB | |
| sarjitsu backend 5844b1162ebe 4 weeks ago 865.7 MB | |
| sarjitsu grafana d5556e843baa 4 weeks ago 905.5 MB | |
| sarjitsu metricstore_official 8a1d7ea224d6 4 weeks ago 306.7 MB | |
| sarjitsu elasticsearch c3a70b68e495 4 weeks ago 930.5 MB | |
| docker.io/redis <none> 9d8fa9aa0e5b 10 days ago 27.48 MB | |
| docker.io/fedora 25 c904f9bc02af 8 weeks ago 496.1 MB |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2017-08-03 11:20:57|ETL Service Stopped | |
| 2017-08-03 11:20:59|ETL Service Started | |
| ovirtEngineDbDriverClass|org.postgresql.Driver | |
| ovirtEngineHistoryDbJdbcConnection|jdbc:postgresql://localhost:5432/ovirt_engine_history?sslfactory=org.postgresql.ssl.NonValidatingFactory | |
| hoursToKeepDaily|0 | |
| hoursToKeepHourly|720 | |
| ovirtEngineDbPassword|********************** | |
| runDeleteTime|3 | |
| ovirtEngineDbJdbcConnection|jdbc:postgresql://localhost:5432/engine?sslfactory=org.postgresql.ssl.NonValidatingFactory | |
| runInterleave|20 |
arcolife
/ engine.log
Last active
August 3, 2017 08:32
less engine.log | egrep '715d7551-4ad6-4377-8773-84da59373dfd|CF-CM-OPS-LONG-RUN-58017' --color
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2017-08-03 04:23:43,315 INFO [org.ovirt.engine.core.bll.RunVmCommand] (ajp-/127.0.0.1:8702-13) [468f0ec5] | |
| Lock Acquired to object EngineLock [exclusiveLocks= key: 715d7551-4ad6-4377-8773-84da59373dfd value: VM | |
| 2017-08-03 04:23:43,400 INFO [org.ovirt.engine.core.vdsbroker.IsVmDuringInitiatingVDSCommand] (ajp-/127.0.0.1:8702-13) | |
| [468f0ec5] START, IsVmDuringInitiatingVDSCommand( vmId = 715d7551-4ad6-4377-8773-84da59373dfd), log id: 416ba226 | |
| 2017-08-03 04:23:43,502 INFO [org.ovirt.engine.core.bll.RunVmCommand] (org.ovirt.thread.pool-7-thread-31) [468f0ec5] | |
| Running command: RunVmCommand internal: false. Entities affected : ID: 715d7551-4ad6-4377-8773-84da59373dfd | |
| Type: VMAction group VM_BASIC_OPERATIONS with role type USER |
arcolife
/ ovirt-engine-dwhd.log
Last active
August 3, 2017 07:16
ovirt-engine-dwhd stats empty in RHVM 4.0
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2017-07-23 03:43:40|CKSf0Y|2NTdHI|sGWpKH|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1 | |
| Exception in component tJDBCOutput_6 | |
| org.postgresql.util.PSQLException: ERROR: integer out of range | |
| at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) | |
| at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) | |
| at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) | |
| at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) | |
| at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) | |
| at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363) | |
| at ovirt_engine_dwh.statisticssync_4_0.StatisticsSync.tJDBCInput_12Process(StatisticsSync.java:11378) |
arcolife
/ gist:4a7070414d4385ebe750f1fda3ad5e09
Last active
July 31, 2017 07:05
cloudforms vmdb attributes
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| psql -d vmdb_production | |
| */ | |
| select state,count(*) from containers group by state; | |
| /* state | count | |
| ---------+------- | |
| running | 297 | |
| (1 row) */ |
If you can launch hawkular,
https://github.com/openshift/origin-metrics/blob/master/docs/hawkular_metrics.adoc
tangentially related: https://docs.openshift.com/container-platform/3.5/rest_api/openshift_v1.html
If using Raspberry Pi and concerned about launching hawkular (per se, extra pod resource contraints):
Get the pid..
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| links: | |
| • https://adsm.org/lists/html/Amanda-Users/2006-07/msg00512.html | |
| • http://thegeekdiary.com/centos-rhel-converting-an-existing-root-filesystem-to-lvm-partition/ | |
| • http://www.linuxweblog.com/blogs/sandip/20071007/convert-root-filesystem-lvm | |
| • http://www.tldp.org/HOWTO/LVM-HOWTO/upgraderoottolvm.html | |
| • http://www.ivarch.com/blogs/oss/2007/01/resize-a-live-root-fs-a-howto.shtml | |
| • https://access.redhat.com/solutions/880203#comments | |
| • https://access.redhat.com/discussions/2158911 | |
| • https://www.linux-toys.com/?p=14 | |
| • |