[Users] engine-setup fails in database creation

[Elias Abacioglu]

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?
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20120311/cf72ef4e/attachment-0001.html>