--=_9a4efeb6-df2f-4207-8180-b1f3b1ff9a79 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit It's probably a bug in the EL support (systemd vs. sysV init scripts). iirc, this was already fixed in master. What about trying to build rpms from git (master branch)? ----- Original Message -----
1. yes. 2. CentOS 6.2. 3. 3.0.0_0001. Basically I took the ovirt-engine-3.0.0_0001-1.6.fc16.src.rpm and rebuilt it for CentOS 6.2.
If this don't work I'm going to try the RPMS at http://www.dreyou.org/ovirt/ which is also built for EL6. But it feels kind of strange that it can't create the DB.
2012/3/12 Ofer Schreiber < oschreib@redhat.com >
few questions:
1. Does /sbin/service postgresql works for you?
2. Which OS are you using?
3. Which version of ovirt-engine?
Thanks,
Ofer.
Yes I tried to install that date. And that is from the beginning of the file.
I have a log from Friday as well.
# cat postgresql-Fri.log
LOG: database system was shut down at 2012-03-09 15:43:14 CET
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
ERROR: database "engine" does not exist
STATEMENT: DROP DATABASE engine;
WARNING: nonstandard use of escape in a string literal at character 46
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
WARNING: column "status" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
WARNING: column "owner" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
WARNING: column "storage_pool_id" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
WARNING: column "storage_pool_name" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
Also I just ran a engine-cleanup and check what was added to todays log.
Then I did a engine-setup. All it did was that it added one line "FATAL: database "engine" does not exist" to the log.
/Raboo
2012/3/11 Yair Zaslavsky < yzaslavs@redhat.com >
On 03/11/2012 09:32 PM, Elias Abacioglu wrote:
2012/3/11 Yair Zaslavsky < yzaslavs@redhat.com <mailto: yzaslavs@redhat.com >>
On 03/11/2012 05:48 PM, Elias Abacioglu wrote:
Den den 11 mars 2012 16:40:06 skrev Yair Zaslavsky:
> On 03/11/2012 05:24 PM, Elias Abacioglu wrote:
>> Hi,
>>
>> I can postgresql is running and I can access it using >> "psql >> -U
postgres"
>
> What happens when you type "psql engine postgres" ?
psql: FATAL: database "engine" does not exist
Ok, postgres service is up, but something went wrong in the creation.
Can you please provide the postgres log?
It should be located at
/var/lib/pgsql/data/pg_log/postgresql-Sun.log (if you tried installing
it today).
Please notice that on my environment this directory is accessible from
root (and not my regular user).
Here is the log from yesterday.
LOG: received fast shutdown request
LOG: aborting any active transactions
LOG: autovacuum launcher shutting down
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2012-03-10 12:44:46 CET
LOG: autovacuum launcher started
LOG: database system is ready to accept connections
FATAL: database "engine" does not exist
FATAL: database "engine" does not exist
FATAL: database "engine" does not exist
FATAL: database "engine" does not exist
FATAL: database "engine" does not exist
FATAL: database "engine" does not exist
FATAL: database "engine" does not exist
FATAL: database "engine" does not exist
LOG: received fast shutdown request
LOG: aborting any active transactions
LOG: autovacuum launcher shutting down
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2012-03-10 14:29:30 CET
LOG: autovacuum launcher started
LOG: database system is ready to accept connections
FATAL: database "engine" does not exist
FATAL: database "engine" does not exist
FATAL: database "engine" does not exist
Also it contains many more 'FATAL: database "engine" does not exist'.
Almost 70.000.
Thanks for the log,
Is this the date when you installed? Are these the first entries you
have in the log?
_______________________________________________
Users mailing list
Users@ovirt.org
--=_9a4efeb6-df2f-4207-8180-b1f3b1ff9a79 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <html><head><style type=3D'text/css'>p { margin: 0; }</style></head><body><= div style=3D'font-family: Times New Roman; font-size: 12pt; color: #000000'=
It's probably a bug in the EL support (systemd vs. sysV init scripts).<div= iirc, this was already fixed in master.</div><div><br></div><div>What abou= t trying to build rpms from git (master branch)? <br><div><div><br><hr= id=3D"zwchr"><blockquote style=3D"border-left:2px solid rgb(16, 16, 255);m= argin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:no= rmal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:= 12pt;">1. yes.<br>2. CentOS 6.2.<br>3. 3.0.0_0001. Basically I took the ovi= rt-engine-3.0.0_0001-1.6.fc16.src.rpm and rebuilt it for CentOS 6.2.<br><br= If this don't work I'm going to try the RPMS at <a href=3D"http://www.drey= ou.org/ovirt/" target=3D"_blank">http://www.dreyou.org/ovirt/</a> which is = also built for EL6.<br> But it feels kind of strange that it can't create the DB.<br><br><br><div c= lass=3D"gmail_quote">2012/3/12 Ofer Schreiber <span dir=3D"ltr"><<a href= =3D"mailto:oschreib@redhat.com" target=3D"_blank">oschreib@redhat.com</a>&g= t;</span><br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;b= order-left:1px #ccc solid;padding-left:1ex"> <div><div style=3D"font-size:12pt;font-family:Times New Roman">few question= s:<div>1. Does /sbin/service postgresql works for you?</div><div>2. Which O= S are you using?</div><div>3. Which version of ovirt-engine?</div><div><br>=
</div><div>Thanks,</div><div>Ofer.<br><div><br><hr><blockquote style=3D"pad= ding-left:5px;font-size:12pt;font-style:normal;margin-left:5px;font-family:= Helvetica,Arial,sans-serif;text-decoration:none;font-weight:normal;border-l= eft:2px solid rgb(16,16,255)"> <div><div class=3D"h5">Yes I tried to install that date. And that is from t= he beginning of the file.<br><br>I have a log from Friday as well.<br><br>#= cat postgresql-Fri.log<br>LOG: database system was shut down at 2012= -03-09 15:43:14 CET<br> LOG: database system is ready to accept connections<br> LOG: autovacuum launcher started<br>ERROR: database "engine" do= es not exist<br>STATEMENT: DROP DATABASE engine;<br><br>WARNING: = ; nonstandard use of escape in a string literal at character 46<br>HINT:&nb= sp; Use the escape string syntax for escapes, e.g., E'\r\n'.<br> WARNING: column "status" has type "unknown"<br>DETAIL: Proceedi= ng with relation creation anyway.<br>WARNING: column "owner" has type= "unknown"<br>DETAIL: Proceeding with relation creation anyway.<br> WARNING: column "storage_pool_id" has type "unknown"<br>DETAIL: = Proceeding with relation creation anyway.<br>WARNING: column "storag= e_pool_name" has type "unknown"<br>DETAIL: Proceeding with relation c= reation anyway.<br> <br><br>Also I just ran a engine-cleanup and check what was added to todays= log.<br>Then I did a engine-setup. All it did was that it added one line "= FATAL: database "engine" does not exist" to the log.<br> <br>/Raboo<br><br><div class=3D"gmail_quote">2012/3/11 Yair Zaslavsky <span= dir=3D"ltr"><<a href=3D"mailto:yzaslavs@redhat.com" target=3D"_blank">y= zaslavs@redhat.com</a>></span><br><blockquote class=3D"gmail_quote" styl= e=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> On 03/11/2012 09:32 PM, Elias Abacioglu wrote:<br> ><br> > 2012/3/11 Yair Zaslavsky <<a href=3D"mailto:yzaslavs@redhat.com" ta= rget=3D"_blank">yzaslavs@redhat.com</a> <mailto:<a href=3D"mailto:yzasla= vs@redhat.com" target=3D"_blank">yzaslavs@redhat.com</a>>><br> <div><div>><br> > On 03/11/2012 05:48 PM, Elias Abacioglu wrote:<br> > > Den den 11 mars 2012 16:40:06 skrev Yair Zaslavsky:= <br> > >> On 03/11/2012 05:24 PM, Elias Abacioglu wrote:<= br> > >>> Hi,<br> > >>><br> > >>> I can postgresql is running and I can acces= s it using "psql -U<br> > postgres"<br> > >><br> > >> What happens when you type "psql engine postgre= s" ?<br> > > psql: FATAL: database "engine" does not exist= <br> > Ok, postgres service is up, but something went wrong in = the creation.<br> ><br> > Can you please provide the postgres log?<br> > It should be located at<br> ><br> > /var/lib/pgsql/data/pg_log/postgresql-Sun.log (if you tr= ied installing<br> > it today).<br> ><br> > Please notice that on my environment this directory is a= ccessible from<br> > root (and not my regular user).<br> ><br> ><br> > Here is the log from yesterday.<br> ><br> > LOG: received fast shutdown request<br> > LOG: aborting any active transactions<br> > LOG: autovacuum launcher shutting down<br> > LOG: shutting down<br> > LOG: database system is shut down<br> > LOG: database system was shut down at 2012-03-10 12:44:46 CET<br=
> LOG: autovacuum launcher started<br> > LOG: database system is ready to accept connections<br> > FATAL: database "engine" does not exist<br> > FATAL: database "engine" does not exist<br> > FATAL: database "engine" does not exist<br> > FATAL: database "engine" does not exist<br> > FATAL: database "engine" does not exist<br> > FATAL: database "engine" does not exist<br> > FATAL: database "engine" does not exist<br> > FATAL: database "engine" does not exist<br> > LOG: received fast shutdown request<br> > LOG: aborting any active transactions<br> > LOG: autovacuum launcher shutting down<br> > LOG: shutting down<br> > LOG: database system is shut down<br> > LOG: database system was shut down at 2012-03-10 14:29:30 CET<br=
> LOG: autovacuum launcher started<br> > LOG: database system is ready to accept connections<br> > FATAL: database "engine" does not exist<br> > FATAL: database "engine" does not exist<br> > FATAL: database "engine" does not exist<br> ><br> ><br> > Also it contains many more 'FATAL: database "engine" does not ex= ist'.<br> > Almost 70.000.<br> <br> </div></div>Thanks for the log,<br> Is this the date when you installed? Are these the first entries you<br> have in the log?<br> <br> <br> </blockquote></div><br> <br></div></div><div class=3D"im">_________________________________________= ______<br>Users mailing list<br><a href=3D"mailto:Users@ovirt.org" target= =3D"_blank">Users@ovirt.org</a><br><a href=3D"http://lists.ovirt.org/mailma= n/listinfo/users" target=3D"_blank">http://lists.ovirt.org/mailman/listinfo= /users</a><br> </div></blockquote><br></div></div></div></div></blockquote></div><br> </blockquote><br></div></div></div></div></body></html> --=_9a4efeb6-df2f-4207-8180-b1f3b1ff9a79--