From yzaslavs at redhat.com Thu Feb 28 00:09:58 2013 Content-Type: multipart/mixed; boundary="===============8956443589412565779==" MIME-Version: 1.0 From: Yair Zaslavsky To: users at ovirt.org Subject: Re: [Users] create database error Date: Thu, 28 Feb 2013 00:09:51 -0500 Message-ID: <645518754.9756769.1362028191780.JavaMail.root@redhat.com> In-Reply-To: 5b018627.15962.13d1ef30c58.Coremail.bigclouds@163.com --===============8956443589412565779== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable ------=3D_Part_9756768_2009910352.1362028191779 Content-Type: text/plain; charset=3Dutf-8 Content-Transfer-Encoding: 7bit I assume you're working on a development environment. = Which commit hash are you rebased on ? = I am rebased against 753a1d001ee2bcf4a639ad6582bef22169b15fa9 = In addition, can you please provide the version of postgrsql that you're us= ing, and what operating system (what Linux distro) you're using, and also a= ttach = create_db.sh.log = Thanks = Yair = ----- Original Message ----- > From: "bigclouds" > To: users(a)ovirt.org > Sent: Thursday, February 28, 2013 5:57:57 AM > Subject: [Users] create database error > ./create_db_devel.sh -u postgres > Running upgrade sql script > upgrade/03_01_1450_add_timestamp_to_async_tasks_and_compensation.sql > ... > Running upgrade sql script > upgrade/03_01_1460_add_storage_pool_id_and_task_type_to_async_tasks.sql > ... > Running upgrade sql script upgrade/03_01_1470_add_smartcard.sql ... > Running upgrade sql script > upgrade/03_01_1480_change_nfs_version_to_string.sql ... > Running upgrade sql script > upgrade/03_01_1490_gluster_refresh_event_map.sql ... > Running upgrade sql script > upgrade/03_01_1500_drop_hypervisor_type.sql ... > Running upgrade sql script upgrade/03_01_1510_drop_operation_mode.sql > ... > Running upgrade sql script > upgrade/03_01_1520_add_fk_vm_interface_vm_static_template.sql ... > Running upgrade sql script > upgrade/03_01_1530_configure_disk_storage_action_group_changes.sql > ... > Skipping upgrade script upgrade/03_01_1540_add_sma rtcard.sql, > already installed by 03011470 > for upgrade/03_02_0010_delete_action_version_map.sql l > : No such file or directory > Failed to create database engine > _______________________________________________ > Users mailing list > Users(a)ovirt.org > http://lists.ovirt.org/mailman/listinfo/users ------=3D_Part_9756768_2009910352.1362028191779 Content-Type: text/html; charset=3Dutf-8 Content-Transfer-Encoding: quoted-printable <=3D div style=3D3D'font-family: times new roman,new york,times,serif; font-size= : =3D 12pt; color: #000000'>I assume you're working on a development environment.= =3D

Which commit hash are you rebased on ?
I am rebased agai= =3D nst 753a1d001ee2bcf4a639ad6582bef22169b15fa9

= =3D In addition, can you please provide the version of postgrsql that you're us= =3D ing, and what operating system (what Linux distro) you're using, and also a= =3D ttach
create_db.sh.log

Thanks
= =3D
Yair


From: "bi= =3D gclouds" <bigclouds(a)163.com>
To: users(a)ovirt.org
= Sent=3D : Thursday, February 28, 2013 5:57:57 AM
Subject: [Users] cre= =3D ate database error

./create_db_devel.sh -u postgres
Running  upgrade sql script upgrade/03_01_1450_a= =3D dd_timestamp_to_async_tasks_and_compensation.sql ...
Running &nbs= =3D p;upgrade sql script upgrade/03_01_1460_add_storage_pool_id_and_task_type_t= =3D o_async_tasks.sql ...
Running  upgrade sql script upgrade/03= =3D _01_1470_add_smartcard.sql ...
Running  upgrade sql script u= =3D pgrade/03_01_1480_change_nfs_version_to_string.sql ...
Running &n= =3D bsp;upgrade sql script upgrade/03_01_1490_gluster_refresh_event_map.sql ...= =3D
Running  upgrade sql script upgrade/03_01_1500_drop_hypervi= =3D sor_type.sql ...
Running  upgrade sql script upgrade/03_01_1= =3D 510_drop_operation_mode.sql ...
Running  upgrade sql script = =3D upgrade/03_01_1520_add_fk_vm_interface_vm_static_template.sql ...
Running  upgrade sql script upgrade/03_01_1530_configure_disk_storage= =3D _action_group_changes.sql ...
Skipping upgrade script upgrade/03_= =3D 01_1540_add_sma rtcard.sql, already installed by  03011470
 for upgrad= =3D e/03_02_0010_delete_action_version_map.sql l
: No such file or di= =3D rectory
Failed to create database engine

=
_______________________________________________
Users mailing lis= =3D t
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
=
------=3D_Part_9756768_2009910352.1362028191779-- --===============8956443589412565779== Content-Type: multipart/alternative MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.bin" LS0tLS0tPV9QYXJ0Xzk3NTY3NjhfMjAwOTkxMDM1Mi4xMzYyMDI4MTkxNzc5CkNvbnRlbnQtVHlw ZTogdGV4dC9wbGFpbjsgY2hhcnNldD11dGYtOApDb250ZW50LVRyYW5zZmVyLUVuY29kaW5nOiA3 Yml0CgpJIGFzc3VtZSB5b3UncmUgd29ya2luZyBvbiBhIGRldmVsb3BtZW50IGVudmlyb25tZW50 LiAKCldoaWNoIGNvbW1pdCBoYXNoIGFyZSB5b3UgcmViYXNlZCBvbiA/IApJIGFtIHJlYmFzZWQg YWdhaW5zdCA3NTNhMWQwMDFlZTJiY2Y0YTYzOWFkNjU4MmJlZjIyMTY5YjE1ZmE5IAoKSW4gYWRk aXRpb24sIGNhbiB5b3UgcGxlYXNlIHByb3ZpZGUgdGhlIHZlcnNpb24gb2YgcG9zdGdyc3FsIHRo YXQgeW91J3JlIHVzaW5nLCBhbmQgd2hhdCBvcGVyYXRpbmcgc3lzdGVtICh3aGF0IExpbnV4IGRp c3RybykgeW91J3JlIHVzaW5nLCBhbmQgYWxzbyBhdHRhY2ggCmNyZWF0ZV9kYi5zaC5sb2cgCgpU aGFua3MgCgpZYWlyIAoKLS0tLS0gT3JpZ2luYWwgTWVzc2FnZSAtLS0tLQoKPiBGcm9tOiAiYmln Y2xvdWRzIiA8YmlnY2xvdWRzQDE2My5jb20+Cj4gVG86IHVzZXJzQG92aXJ0Lm9yZwo+IFNlbnQ6 IFRodXJzZGF5LCBGZWJydWFyeSAyOCwgMjAxMyA1OjU3OjU3IEFNCj4gU3ViamVjdDogW1VzZXJz XSBjcmVhdGUgZGF0YWJhc2UgZXJyb3IKCj4gLi9jcmVhdGVfZGJfZGV2ZWwuc2ggLXUgcG9zdGdy ZXMKCj4gUnVubmluZyB1cGdyYWRlIHNxbCBzY3JpcHQKPiB1cGdyYWRlLzAzXzAxXzE0NTBfYWRk X3RpbWVzdGFtcF90b19hc3luY190YXNrc19hbmRfY29tcGVuc2F0aW9uLnNxbAo+IC4uLgo+IFJ1 bm5pbmcgdXBncmFkZSBzcWwgc2NyaXB0Cj4gdXBncmFkZS8wM18wMV8xNDYwX2FkZF9zdG9yYWdl X3Bvb2xfaWRfYW5kX3Rhc2tfdHlwZV90b19hc3luY190YXNrcy5zcWwKPiAuLi4KPiBSdW5uaW5n IHVwZ3JhZGUgc3FsIHNjcmlwdCB1cGdyYWRlLzAzXzAxXzE0NzBfYWRkX3NtYXJ0Y2FyZC5zcWwg Li4uCj4gUnVubmluZyB1cGdyYWRlIHNxbCBzY3JpcHQKPiB1cGdyYWRlLzAzXzAxXzE0ODBfY2hh bmdlX25mc192ZXJzaW9uX3RvX3N0cmluZy5zcWwgLi4uCj4gUnVubmluZyB1cGdyYWRlIHNxbCBz Y3JpcHQKPiB1cGdyYWRlLzAzXzAxXzE0OTBfZ2x1c3Rlcl9yZWZyZXNoX2V2ZW50X21hcC5zcWwg Li4uCj4gUnVubmluZyB1cGdyYWRlIHNxbCBzY3JpcHQKPiB1cGdyYWRlLzAzXzAxXzE1MDBfZHJv cF9oeXBlcnZpc29yX3R5cGUuc3FsIC4uLgo+IFJ1bm5pbmcgdXBncmFkZSBzcWwgc2NyaXB0IHVw Z3JhZGUvMDNfMDFfMTUxMF9kcm9wX29wZXJhdGlvbl9tb2RlLnNxbAo+IC4uLgo+IFJ1bm5pbmcg dXBncmFkZSBzcWwgc2NyaXB0Cj4gdXBncmFkZS8wM18wMV8xNTIwX2FkZF9ma192bV9pbnRlcmZh Y2Vfdm1fc3RhdGljX3RlbXBsYXRlLnNxbCAuLi4KPiBSdW5uaW5nIHVwZ3JhZGUgc3FsIHNjcmlw dAo+IHVwZ3JhZGUvMDNfMDFfMTUzMF9jb25maWd1cmVfZGlza19zdG9yYWdlX2FjdGlvbl9ncm91 cF9jaGFuZ2VzLnNxbAo+IC4uLgo+IFNraXBwaW5nIHVwZ3JhZGUgc2NyaXB0IHVwZ3JhZGUvMDNf MDFfMTU0MF9hZGRfc21hIHJ0Y2FyZC5zcWwsCj4gYWxyZWFkeSBpbnN0YWxsZWQgYnkgMDMwMTE0 NzAKPiBmb3IgdXBncmFkZS8wM18wMl8wMDEwX2RlbGV0ZV9hY3Rpb25fdmVyc2lvbl9tYXAuc3Fs IGwKPiA6IE5vIHN1Y2ggZmlsZSBvciBkaXJlY3RvcnkKPiBGYWlsZWQgdG8gY3JlYXRlIGRhdGFi YXNlIGVuZ2luZQoKPiBfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fXwo+IFVzZXJzIG1haWxpbmcgbGlzdAo+IFVzZXJzQG92aXJ0Lm9yZwo+IGh0dHA6Ly9saXN0 cy5vdmlydC5vcmcvbWFpbG1hbi9saXN0aW5mby91c2VycwoKLS0tLS0tPV9QYXJ0Xzk3NTY3Njhf MjAwOTkxMDM1Mi4xMzYyMDI4MTkxNzc5CkNvbnRlbnQtVHlwZTogdGV4dC9odG1sOyBjaGFyc2V0 PXV0Zi04CkNvbnRlbnQtVHJhbnNmZXItRW5jb2Rpbmc6IHF1b3RlZC1wcmludGFibGUKCjxodG1s PjxoZWFkPjxzdHlsZSB0eXBlPTNEJ3RleHQvY3NzJz5wIHsgbWFyZ2luOiAwOyB9PC9zdHlsZT48 L2hlYWQ+PGJvZHk+PD0KZGl2IHN0eWxlPTNEJ2ZvbnQtZmFtaWx5OiB0aW1lcyBuZXcgcm9tYW4s bmV3IHlvcmssdGltZXMsc2VyaWY7IGZvbnQtc2l6ZTogPQoxMnB0OyBjb2xvcjogIzAwMDAwMCc+ SSBhc3N1bWUgeW91J3JlIHdvcmtpbmcgb24gYSBkZXZlbG9wbWVudCBlbnZpcm9ubWVudC49Cjxk aXY+PGJyPldoaWNoIGNvbW1pdCBoYXNoIGFyZSB5b3UgcmViYXNlZCBvbiA/PC9kaXY+PGRpdj5J IGFtIHJlYmFzZWQgYWdhaT0KbnN0Jm5ic3A7NzUzYTFkMDAxZWUyYmNmNGE2MzlhZDY1ODJiZWYy MjE2OWIxNWZhOTwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+PQpJbiBhZGRpdGlvbiwgY2FuIHlv dSBwbGVhc2UgcHJvdmlkZSB0aGUgdmVyc2lvbiBvZiBwb3N0Z3JzcWwgdGhhdCB5b3UncmUgdXM9 CmluZywgYW5kIHdoYXQgb3BlcmF0aW5nIHN5c3RlbSAod2hhdCBMaW51eCBkaXN0cm8pIHlvdSdy ZSB1c2luZywgYW5kIGFsc28gYT0KdHRhY2g8L2Rpdj48ZGl2PmNyZWF0ZV9kYi5zaC5sb2c8L2Rp dj48ZGl2Pjxicj48L2Rpdj48ZGl2PlRoYW5rczwvZGl2PjxkaXY+PQo8YnI+PC9kaXY+PGRpdj5Z YWlyPC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj48YnI+PGhyIGlkPTNEInp3Y2hyIj48YmxvY2tx dW89CnRlIHN0eWxlPTNEImJvcmRlci1sZWZ0OjJweCBzb2xpZCByZ2IoMTYsIDE2LCAyNTUpO21h cmdpbi1sZWZ0OjVweDtwYWRkaW5nLT0KbGVmdDo1cHg7Y29sb3I6IzAwMDtmb250LXdlaWdodDpu b3JtYWw7Zm9udC1zdHlsZTpub3JtYWw7dGV4dC1kZWNvcmF0aW9uOm5vPQpuZTtmb250LWZhbWls eTpIZWx2ZXRpY2EsQXJpYWwsc2Fucy1zZXJpZjtmb250LXNpemU6MTJwdDsiPjxiPkZyb206IDwv Yj4iYmk9CmdjbG91ZHMiICZsdDtiaWdjbG91ZHNAMTYzLmNvbSZndDs8YnI+PGI+VG86IDwvYj51 c2Vyc0BvdmlydC5vcmc8YnI+PGI+U2VudD0KOiA8L2I+VGh1cnNkYXksIEZlYnJ1YXJ5IDI4LCAy MDEzIDU6NTc6NTcgQU08YnI+PGI+U3ViamVjdDogPC9iPltVc2Vyc10gY3JlPQphdGUgZGF0YWJh c2UgZXJyb3I8YnI+PGJyPjxkaXYgc3R5bGU9M0QibGluZS1oZWlnaHQ6MS43O2NvbG9yOiMwMDAw MDA7Zm9udC09CnNpemU6MTRweDtmb250LWZhbWlseTphcmlhbCI+PGRpdj48cHJlPi4vY3JlYXRl X2RiX2RldmVsLnNoIC11IHBvc3RncmVzCjwvcHJlPjwvZGl2PjxkaXY+PGRpdj5SdW5uaW5nICZu YnNwO3VwZ3JhZGUgc3FsIHNjcmlwdCB1cGdyYWRlLzAzXzAxXzE0NTBfYT0KZGRfdGltZXN0YW1w X3RvX2FzeW5jX3Rhc2tzX2FuZF9jb21wZW5zYXRpb24uc3FsIC4uLjwvZGl2PjxkaXY+UnVubmlu ZyAmbmJzPQpwO3VwZ3JhZGUgc3FsIHNjcmlwdCB1cGdyYWRlLzAzXzAxXzE0NjBfYWRkX3N0b3Jh Z2VfcG9vbF9pZF9hbmRfdGFza190eXBlX3Q9Cm9fYXN5bmNfdGFza3Muc3FsIC4uLjwvZGl2Pjxk aXY+UnVubmluZyAmbmJzcDt1cGdyYWRlIHNxbCBzY3JpcHQgdXBncmFkZS8wMz0KXzAxXzE0NzBf YWRkX3NtYXJ0Y2FyZC5zcWwgLi4uPC9kaXY+PGRpdj5SdW5uaW5nICZuYnNwO3VwZ3JhZGUgc3Fs IHNjcmlwdCB1PQpwZ3JhZGUvMDNfMDFfMTQ4MF9jaGFuZ2VfbmZzX3ZlcnNpb25fdG9fc3RyaW5n LnNxbCAuLi48L2Rpdj48ZGl2PlJ1bm5pbmcgJm49CmJzcDt1cGdyYWRlIHNxbCBzY3JpcHQgdXBn cmFkZS8wM18wMV8xNDkwX2dsdXN0ZXJfcmVmcmVzaF9ldmVudF9tYXAuc3FsIC4uLj0KPC9kaXY+ PGRpdj5SdW5uaW5nICZuYnNwO3VwZ3JhZGUgc3FsIHNjcmlwdCB1cGdyYWRlLzAzXzAxXzE1MDBf ZHJvcF9oeXBlcnZpPQpzb3JfdHlwZS5zcWwgLi4uPC9kaXY+PGRpdj5SdW5uaW5nICZuYnNwO3Vw Z3JhZGUgc3FsIHNjcmlwdCB1cGdyYWRlLzAzXzAxXzE9CjUxMF9kcm9wX29wZXJhdGlvbl9tb2Rl LnNxbCAuLi48L2Rpdj48ZGl2PlJ1bm5pbmcgJm5ic3A7dXBncmFkZSBzcWwgc2NyaXB0ID0KdXBn cmFkZS8wM18wMV8xNTIwX2FkZF9ma192bV9pbnRlcmZhY2Vfdm1fc3RhdGljX3RlbXBsYXRlLnNx bCAuLi48L2Rpdj48ZGl2PQo+UnVubmluZyAmbmJzcDt1cGdyYWRlIHNxbCBzY3JpcHQgdXBncmFk ZS8wM18wMV8xNTMwX2NvbmZpZ3VyZV9kaXNrX3N0b3JhZ2U9Cl9hY3Rpb25fZ3JvdXBfY2hhbmdl cy5zcWwgLi4uPC9kaXY+PGRpdj5Ta2lwcGluZyB1cGdyYWRlIHNjcmlwdCB1cGdyYWRlLzAzXz0K MDFfMTU0MF9hZGRfc21hCiBydGNhcmQuc3FsLCBhbHJlYWR5IGluc3RhbGxlZCBieSAmbmJzcDsw MzAxMTQ3MDwvZGl2PjxkaXY+Jm5ic3A7Zm9yIHVwZ3JhZD0KZS8wM18wMl8wMDEwX2RlbGV0ZV9h Y3Rpb25fdmVyc2lvbl9tYXAuc3FsIGw8L2Rpdj48ZGl2PjogTm8gc3VjaCBmaWxlIG9yIGRpPQpy ZWN0b3J5PC9kaXY+PGRpdj5GYWlsZWQgdG8gY3JlYXRlIGRhdGFiYXNlIGVuZ2luZTwvZGl2Pjwv ZGl2PjwvZGl2Pjxicj48YnI9Cj48c3BhbiB0aXRsZT0zRCJuZXRlYXNlZm9vdGVyIj48c3BhbiBp ZD0zRCJuZXRlYXNlX21haWxfZm9vdGVyIj48L3NwYW4+PC9zcD0KYW4+PGJyPl9fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fPGJyPlVzZXJzIG1haWxpbmcgbGlz PQp0PGJyPlVzZXJzQG92aXJ0Lm9yZzxicj5odHRwOi8vbGlzdHMub3ZpcnQub3JnL21haWxtYW4v bGlzdGluZm8vdXNlcnM8YnI+PC89CmJsb2NrcXVvdGU+PGJyPjwvZGl2PjwvZGl2PjwvYm9keT48 L2h0bWw+Ci0tLS0tLT1fUGFydF85NzU2NzY4XzIwMDk5MTAzNTIuMTM2MjAyODE5MTc3OS0tCg== --===============8956443589412565779==--