Monthly Archives: September 2018

Sail Internet review

Leave a reply

As the very first few guys installed Sail wireless internet service, I got way faster upload speed around 200Mbit/s, Download is around 300Mbit/s, still a lot faster than Comcast currently I have, especially considering the cost and no cap.

It took about an hour for the guy getting antenna&pole installed on rooftop. Ethernet cable goes from existing vent into the attic,  the guy from Sail helped me wire the cable into my central panel where I have hub for Ethernet cables going to other floors and rooms.

So it’s painless to switch from Comcast cable to Sail, simply unplug cable from cable modem and plugin the new ethernet cable from the POE adapter, which supplies power to the antenna on rooftop.

Not sure if there is any management interface/UI for end user to tell wireless status like signal strength etc.

The major drawback is network delay is way higher,  greater than 20ms, comparing to comcast cable which is usually bellow 10ms. It may not be best option for online gamers, or delay sensitive application. Personally download & upload speed are my priority, so no big deal.

Overall installation experience is very smooth, highly recommend if it’s available in your location.

I will see how things will go as more people start adopting Sail wireless service. I would assume the bandwidth is shared. So far so good..

Nova Placement ApI / NoValidHost

Leave a reply

To find the gap when placement api db out of sync or keep receiving NoValidHost  error. There is great chance resources in placement db is out of track.   One change in nova scheduler is a memory.disk.cpu filters are there any more, instead nova scheduler ask placement api for a list HV candidates by flavor first, then nova scheduler continues the filtering like compute_filter etc…

DB query to get basic capacity details:

select p.uuid, p.name hypervisor_hostname,
(select i.total from inventories i where p.id=i.resource_provider_id and i.resource_class_id=0) vcpus,
(select sum(used) from allocations a where a.resource_provider_id=p.id and a.resource_class_id=0) vcpus_used,
(select i.total from inventories i where p.id=i.resource_provider_id and i.resource_class_id=1) memory_mb,
(select sum(used) from allocations a where a.resource_provider_id=p.id and a.resource_class_id=1) memory_mb_used,
(select i.total from inventories i where p.id=i.resource_provider_id and i.resource_class_id=2) local_gb,
(select sum(used) from allocations a where a.resource_provider_id=p.id and a.resource_class_id=2) local_gb_used,
(select count(id) from allocations a where a.resource_provider_id=p.id and a.resource_class_id=2) running_vms
from resource_providers p order by p.name;

 

 

combine nova db + placement

assume running this query in placement api db and  nova cellx db name is nova_cell_1

select x.hypervisor_hostname, x.vcpus p_vcpus, y.vcpus n_vcpus, x.vcpus_used p_vcpus_used,y.vcpus_used n_vcpus_used, x.memory_mb p_memory_mb, y.memory_mb n_memory_mb, x.memory_mb_used p_memory_mb_used, y.memory_mb_used n_memory_mb_used, x.local_gb p_local_gb, y.local_gb n_local_gb, x.local_gb_used p_local_gb_used, y.local_gb_used n_local_gb_used, x.running_vms p_running_vms, y.running_vms n_running_vms from
(select p.name hypervisor_hostname,
(select i.total from inventories i where p.id=i.resource_provider_id and i.resource_class_id=0) vcpus,
(select sum(used) from allocations a where a.resource_provider_id=p.id and a.resource_class_id=0) vcpus_used,
(select i.total from inventories i where p.id=i.resource_provider_id and i.resource_class_id=1) memory_mb,
(select sum(used) from allocations a where a.resource_provider_id=p.id and a.resource_class_id=1) memory_mb_used,
(select i.total from inventories i where p.id=i.resource_provider_id and i.resource_class_id=2) local_gb,
(select sum(used) from allocations a where a.resource_provider_id=p.id and a.resource_class_id=2) local_gb_used,
(select count(id) from allocations a where a.resource_provider_id=p.id and a.resource_class_id=2) running_vms
from resource_providers p) x
join
(select hypervisor_hostname, vcpus, vcpus_used, memory_mb, memory_mb_used, local_gb, local_gb_used, running_vms from nova_cell_1.compute_nodes where deleted=0 ) y
on x.hypervisor_hostname=y.hypervisor_hostname
order by x.hypervisor_hostname;

 

Any utility to rebuild db?

Hackintosh 8700k z370n rx580 10.13.6

2 Replies

hardware list

Motherboard : Gigabyte Z370N Wifi ITX

CPU:  Intel i7-8700K

CPU Fan: Le Grand Macho RT

Memory: CORSAIR – Vengeance LPX 32GB (2PK x 16GB) 2.6 GHz DDR4 (certified compatible with  z370n)

WIFI+Bluetooth board:  Broadcom BCM94352Z DW1560 6XRYC 802.11 AC 867 Mbps Bluetooth 4.0

Graphics : Sapphire NITRO+ Radeon RX 580 8GD5

PSU: CORSAIR RMx Series RM550x

Case: Fractal Design Define Nano S Black Silent Mini ITX Mini Tower

Keyboard: Apple magic keysboard & touchpad 2

Disk: XPG SX8200 PCIe NVMe Gen3x4 M.2 2280 480GB SSD (ASX8200NP-480GT-C) w/ Black XPG Heatsink

OS:  High Sierra 10.13.6

Replace wifi module on motherboard with DW1560 .

installed 10.13.6 without rx580  following guide at  https://hackintosher.com/builds/gigabyte-z370n-wifi-itx-hackintosh-guide-4k-htpc-build/  (system id 18.1 , with internal graphics )

After a successful install changed to 18.3 before shutdown

quoted:

“If using a dedicated Nvidia or AMD graphics card change ig-platform-id to 0x59120003 and use iMac 18,2/iMac 18,3”

disable internal graphics and change initial graphics to pcie-1  in BIOS

shutdown

(Do not try to boot into OS before everything competes. It will not work.)

install rx580  card

connect monitor to hdmi or DP, both working fine for me.

boot up

RX580 worked OOB, not patch applied. (make sure antenna is installed, otherwise connection will be very flaky even very close)

Before ordering parts please make sure:

  1. case is tall enough to hold the fan
  2. 8700 or 8700K both are ok,  depending on how much cheaper …
  3. no need for standalone graphics card if not playing game… Not sure how much it helps for video editing