[Users] engine-setup fails in database creation

[Ofer Schreiber]

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 at redhat.com >

> > On 03/11/2012 09:32 PM, Elias Abacioglu wrote:
> 
> > >
> 
> > > 2012/3/11 Yair Zaslavsky < yzaslavs at redhat.com <mailto:
> > > yzaslavs at 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 at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20120312/21baefcb/attachment-0001.html>