--=_1ea93694-7adb-45e2-9635-8cd6abb2ee20 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit few questions: 1. Does /sbin/service postgresql works for you? 2. Which OS are you using? 3. Which version of ovirt-engine? Thanks, Ofer. ----- Original Message -----
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 http://lists.ovirt.org/mailman/listinfo/users
--=_1ea93694-7adb-45e2-9635-8cd6abb2ee20 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit <html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 12pt; color: #000000'>few questions:<div>1. Does /sbin/service postgresql works for you?</div><div>2. Which OS are you using?</div><div>3. Which version of ovirt-engine?</div><div><br></div><div>Thanks,</div><div>Ofer.<br><div><br><hr id="zwchr"><blockquote style="border-left:2px solid rgb(16, 16, 255);margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;">Yes I tried to install that date. And that is from the 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" does not exist<br>STATEMENT: DROP DATABASE engine;<br><br>WARNING: nonstandard use of escape in a string literal at character 46<br>HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.<br> WARNING: column "status" has type "unknown"<br>DETAIL: Proceeding 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 "storage_pool_name" has type "unknown"<br>DETAIL: Proceeding with relation creation 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="gmail_quote">2012/3/11 Yair Zaslavsky <span dir="ltr"><<a href="mailto:yzaslavs@redhat.com" target="_blank">yzaslavs@redhat.com</a>></span><br><blockquote class="gmail_quote" style="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="mailto:yzaslavs@redhat.com" target="_blank">yzaslavs@redhat.com</a> <mailto:<a href="mailto:yzaslavs@redhat.com" target="_blank">yzaslavs@redhat.com</a>>><br> <div><div class="h5">><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 access it using "psql -U<br> > postgres"<br> > >><br> > >> What happens when you type "psql engine postgres" ?<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 tried installing<br> > it today).<br> ><br> > Please notice that on my environment this directory is accessible 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 exist'.<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>_______________________________________________<br>Users mailing list<br>Users@ovirt.org<br>http://lists.ovirt.org/mailman/listinfo/users<br></blockquote><br></div></div></div></body></html> --=_1ea93694-7adb-45e2-9635-8cd6abb2ee20--