Re: [ovirt-users] Template Size different in dashboard and storage...

2014-09-09 Thread Sven Kieske
You want to use ls -lsh or even ls -lash

keep in mind these are sparse files.

for more information on this topic read the man page for ls
or google for "ls and sparse files"

HTH

On 08/09/14 05:37, Punit Dambiwal wrote:
> I have made one Centos template from one of my running virtual
> machine...The virtual size of this template is 1GB and the actual size is
> below 1GBfrom the portal dashboard it whowing correctly but if i check
> it through command line...it shows different size ??
> 
> [root@compute1 32199374-4096-4973-9b6a-150e22eb7216]# ls -lh
> total 742M
> -rw-rw 8 vdsm kvm  11G Sep  4 16:46 ff576789-e946-4bda-94f6-a354b43ab531
> -rw-rw 8 vdsm kvm 1.0M Sep  3 13:07
> ff576789-e946-4bda-94f6-a354b43ab531.lease
> -rw-r--r-- 8 vdsm kvm  278 Sep  3 13:07
> ff576789-e946-4bda-94f6-a354b43ab531.meta
> [root@compute1 32199374-4096-4973-9b6a-150e22eb7216]#

-- 
Mit freundlichen Grüßen / Regards

Sven Kieske

Systemadministrator
Mittwald CM Service GmbH & Co. KG
Königsberger Straße 6
32339 Espelkamp
T: +49-5772-293-100
F: +49-5772-293-333
https://www.mittwald.de
Geschäftsführer: Robert Meyer
St.Nr.: 331/5721/1033, USt-IdNr.: DE814773217, HRA 6640, AG Bad Oeynhausen
Komplementärin: Robert Meyer Verwaltungs GmbH, HRB 13260, AG Bad Oeynhausen
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Template Size different in dashboard and storage...

2014-09-09 Thread Prasad Mukhedkar


On 09/08/2014 08:41 PM, Punit Dambiwal wrote:

Hi Prasad,

Yes..I am running Ovirt 3.4 but still didn't find the scripts on the 
location :-


---
[root@cloud-mgmt dbscripts]# sh engine-psql.sh -c "select vm_name, 
image_group_id,image_guid from vm_device, vm_static,images where 
vm_name in('CentOS') and vm_device.type='disk' and 
vm_device.device='disk' and vm_device.vm_id=vm_static.vm_guid and 
images.image_group_id=vm_device.device_id order by vm_name ;"

sh: engine-psql.sh: No such file or directory
[root@cloud-mgmt dbscripts]# pwd
/usr/share/ovirt-engine/dbscripts
[root@cloud-mgmt dbscripts]#
---

Thanks,
Punit




Punit,

 Create that script manually, Refer : 
https://www.mail-archive.com/users@ovirt.org/msg20467.html

or you can simply run ;

#source /etc/ovirt-engine/engine.conf.d/10-setup-database.conf

#PGPASSWORD=$ENGINE_DB_PASSWORD psql -U postgres -d engine -c  "select vm_name, 
image_group_id,image_guid from vm_device,
vm_static,images where vm_name in('CentOS') and vm_device.type='disk'
and vm_device.device='disk' and vm_device.vm_id=vm_static.vm_guid and
images.image_group_id=vm_device.device_id order by vm_name ;"

Thanks,
Prasad Mukhedkar

On Mon, Sep 8, 2014 at 4:44 PM, Prasad Mukhedkar > wrote:



On 09/08/2014 01:53 PM, Punit Dambiwal wrote:

I didn't find this script "engine-psql.sh" in my engine
server,would you mind to let me know the exact path for this
script file...

If you're on 3.4, You will fine the above script at
/usr/share/ovirt-engine/dbscripts location on your ovirt engine
system.

 |Secondly yes i am referring the Template CentOS...every details
i provide you in the previous mail is correct...

show us "qemu-img info" output.






___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Template Size different in dashboard and storage...

2014-09-08 Thread Punit Dambiwal
Hi Prasad,

Yes..I am running Ovirt 3.4 but still didn't find the scripts on the
location :-

---
[root@cloud-mgmt dbscripts]# sh engine-psql.sh -c "select vm_name,
image_group_id,image_guid from vm_device, vm_static,images where vm_name
in('CentOS') and vm_device.type='disk' and vm_device.device='disk' and
vm_device.vm_id=vm_static.vm_guid and
images.image_group_id=vm_device.device_id order by vm_name ;"
sh: engine-psql.sh: No such file or directory
[root@cloud-mgmt dbscripts]# pwd
/usr/share/ovirt-engine/dbscripts
[root@cloud-mgmt dbscripts]#
---

Thanks,
Punit


On Mon, Sep 8, 2014 at 4:44 PM, Prasad Mukhedkar 
wrote:

>
> On 09/08/2014 01:53 PM, Punit Dambiwal wrote:
>
>> I didn't find this script "engine-psql.sh" in my engine server,would you
>> mind to let me know the exact path for this script file...
>>
> If you're on 3.4, You will fine the above script at
> /usr/share/ovirt-engine/dbscripts location on your ovirt engine system.
>
>  |Secondly yes i am referring the Template CentOS...every details i
> provide you in the previous mail is correct...
>
> show us "qemu-img info" output.
>
>
>
>
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Template Size different in dashboard and storage...

2014-09-08 Thread Prasad Mukhedkar


On 09/08/2014 01:53 PM, Punit Dambiwal wrote:
I didn't find this script "engine-psql.sh" in my engine server,would 
you mind to let me know the exact path for this script file...
If you're on 3.4, You will fine the above script at 
/usr/share/ovirt-engine/dbscripts location on your ovirt engine system.


 |Secondly yes i am referring the Template CentOS...every details i 
provide you in the previous mail is correct...


show us "qemu-img info" output.



___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users