[Users] engine-setup fails in database creation

[Ofer Schreiber]

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 at 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 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/9d1ed4c9/attachment-0001.html>