[Users] engine-setup fails in database creation

[Elias Abacioglu]

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/ae26555f/attachment-0001.html>