Skip to content

Instantly share code, notes, and snippets.

View akrzos's full-sized avatar

Alex akrzos

  • Red Hat
  • Raleigh
View GitHub Profile
#!/bin/sh
if [ ! $# == 1 ]; then
echo "Usage: ./reset-capsule.sh /home/backup/<backup-directory>"
echo "Backup Directories available: " `ls /home/backup`
echo "Example: ./reset-db.sh /home/backup/last-clean"
exit
fi
export BDIR=$1
echo "Restoring from: $BDIR"
not patched:
[----] I, [2015-08-24T14:19:09.099044 #60348:34d988] INFO -- : MIQ(EmsRefresh.update_relats) Updating Folders To Folders relationships.
[----] I, [2015-08-24T14:19:09.127224 #60348:34d988] INFO -- : MIQ(EmsRefresh.update_relats) Updating Folders To Clusters relationships.
[----] I, [2015-08-24T14:19:09.322603 #60348:34d988] INFO -- : MIQ(EmsRefresh.update_relats) Updating Folders To Hosts relationships.
[----] I, [2015-08-24T14:19:09.322742 #60348:34d988] INFO -- : MIQ(EmsRefresh.update_relats) Updating Folders To Vms relationships.
[----] I, [2015-08-24T14:23:08.946463 #60348:34d988] INFO -- : MIQ(EmsRefresh.update_relats) Updating Clusters To Resource Pools relationships.
[----] I, [2015-08-24T14:23:09.154707 #60348:34d988] INFO -- : MIQ(EmsRefresh.update_relats) Updating Hosts To Resource Pools relationships.
[----] I, [2015-08-24T14:23:09.154853 #60348:34d988] INFO -- : MIQ(EmsRefresh.update_relats) Updating Resource Pools To Resource Pools relationships.
[----] I, [2015-08-24T14:23:10
@akrzos
akrzos / network-environment.yaml
Created September 9, 2015 14:28
OSP7 network-environment.yaml
resource_registry:
OS::TripleO::BlockStorage::Net::SoftwareConfig: /home/stack/nic-configs/cinder-storage.yaml
OS::TripleO::Compute::Net::SoftwareConfig: /home/stack/nic-configs/compute.yaml
OS::TripleO::Controller::Net::SoftwareConfig: /home/stack/nic-configs/controller.yaml
OS::TripleO::ObjectStorage::Net::SoftwareConfig: /home/stack/nic-configs/swift-storage.yaml
OS::TripleO::CephStorage::Net::SoftwareConfig: /home/stack/nic-configs/ceph-storage.yaml
parameters:
# Only needed for --plan --> Controller-1::NeutronExternalNetworkBridge: "br-ex"
NeutronExternalNetworkBridge: "br-ex"
Zone | Server Name | Status | ID | PID | SPID | URL | Started On | Last Heartbeat | Active Roles
---------+-------------+---------+---------------+-------+-------+-------------------------+----------------------+----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
default | EVM | started | 1000000000001 | 63457 | 63463 | druby://127.0.0.1:44538 | 2015-09-09T02:42:49Z | 2015-09-15T19:18:59Z | automate:database_operations:database_owner:ems_inventory:ems_metrics_collector:ems_metrics_coordinator:ems_metrics_processor:ems_operations:event:notifier:reporting:scheduler:smartproxy:smartstate:user_interface:web_services
Worker Type | Status | ID | PID | SPID | Queue Name / URL | Started On | Last Heartb
[----] I, [2015-09-17T14:41:29.245572 #6937:3b7b378] INFO -- : MiqVimUpdate.addObject (10.12.20.68_administrator@vsphere.local): Adding object VirtualMachine: vm-3027
[----] I, [2015-09-17T14:41:29.247588 #6937:3b7b378] INFO -- : MiqVimUpdate.addObject (10.12.20.68_administrator@vsphere.local): VirtualMachine: vm-3028
[----] I, [2015-09-17T14:41:29.247651 #6937:3b7b378] INFO -- : MiqVimUpdate.addObject (10.12.20.68_administrator@vsphere.local): Adding object VirtualMachine: vm-3028
[----] I, [2015-09-17T14:41:33.042019 #6937:3b7b378] INFO -- : MiqVimUpdate.addObject (10.12.20.68_administrator@vsphere.local): VirtualMachine: vm-3022
[----] I, [2015-09-17T14:41:33.042916 #6937:3b7b378] INFO -- : MiqVimUpdate.addObject (10.12.20.68_administrator@vsphere.local): Adding object VirtualMachine: vm-3022
[----] I, [2015-09-17T14:41:33.050567 #6937:3b7b378] INFO -- : MiqVimUpdate.addObject (10.12.20.68_administrator@vsphere.local): VirtualMachine: vm-3023
> SELECT mean(value) FROM "cpu_value" WHERE "host" = 'CF-R0001-DB-PerfcInfluxTest' AND "type_instance" = 'system' AND "type" = 'percent' AND time > now() - 24h GROUP BY time(30m)
name: cpu_value
---------------
time mean
2015-09-20T18:00:00Z
2015-09-20T18:30:00Z 0.8126914151529918
2015-09-20T19:00:00Z 0.8705530986370552
2015-09-20T19:30:00Z 0.7827519744763393
2015-09-20T20:00:00Z 1.0137894459287633
2015-09-20T20:30:00Z 0.6979515840218791
#!/bin/bash
task_file=$1
test_name=$2
echo "task_file: ${task_file}"
echo "test_name: ${test_name}"
#echo "Sleep 5 Before"
#sleep 5
echo "Before Rally task start."
[root@localhost vmdb]# bundle exec bin/rails r akrzos.rb | sort -nr
81370 /opt/rh/cfme-gemset/gems/memoist-0.11.0/lib/memoist.rb:22 T_STRING String
78557 /opt/rh/cfme-gemset/gems/memoist-0.11.0/lib/memoist.rb:6 T_STRING String
74082 /opt/rh/cfme-gemset/gems/activerecord-4.2.4/lib/active_record/attribute.rb:54 T_ARRAY Array
73229 /opt/rh/cfme-gemset/gems/activerecord-4.2.4/lib/active_record/relation/query_methods.rb:66 T_ARRAY Array
58999 /opt/rh/cfme-gemset/gems/memoist-0.11.0/lib/memoist.rb:14 T_STRING String
54316 /opt/rh/cfme-gemset/gems/activerecord-4.2.4/lib/active_record/connection_adapters/postgresql_adapter.rb:438 T_ARRAY Array
51628 /opt/rh/cfme-gemset/gems/activemodel-4.2.4/lib/active_model/attribute_methods.rb:383 T_NODE
39332 /opt/rh/cfme-gemset/gems/memoist-0.11.0/lib/memoist.rb:14 T_ARRAY Array
37525 /opt/rh/cfme-gemset/gems/activerecord-4.2.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:168 T_STRING String
[root@localhost vmdb]# bundle exec bin/rails c
Loading production environment (Rails 4.2.4)
irb(main):001:0> mrss_start = MiqProcess.processInfo()[:memory_usage]
=> 175747072
irb(main):002:0> GC.stat
=> {:count=>65, :heap_allocated_pages=>2284, :heap_sorted_length=>2293, :heap_allocatable_pages=>0, :heap_available_slots=>930949, :heap_live_slots=>893888, :heap_free_slots=>37061, :heap_final_slots=>0, :heap_marked_slots=>357292, :heap_swept_slots=>355709, :heap_eden_pages=>2284, :heap_tomb_pages=>0, :total_allocated_pages=>2728, :total_freed_pages=>444, :total_allocated_objects=>6976853, :total_freed_objects=>6082965, :malloc_increase_bytes=>1649152, :malloc_increase_bytes_limit=>16777216, :minor_gc_count=>1, :major_gc_count=>64, :remembered_wb_unprotected_objects=>18453, :remembered_wb_unprotected_objects_limit=>19520, :old_objects=>322586, :old_objects_limit=>476797, :oldmalloc_increase_bytes=>1649600, :oldmalloc_increase_bytes_limit=>16777216}
irb(main):003:0> e = ExtManagementSystem.find_by_name('vmware-sm
#!/bin/bash
echo "date, worker_type, pid, rss(KiB), virt(KiB)"
while :
do
#for pid in `ps afx | grep -E "[Ww]orker.rb|[Ee]vm_server|[Rr]ails" | awk '{print $1}'`; do
IFS='
'
for worker_pid in `psql -t -q -d vmdb_production -c 'select pid,type from miq_workers'`; do
t_ref=`date -u`