On Sun, Feb 2, 2014 at 3:34 PM, Yedidyah Bar David wrote:
----- Original Message -----
From: "Gianluca Cecchi" To: "users" <users@ovirt.org> Sent: Sunday, February 2, 2014 3:56:25 PM Subject: [Users] How to scratch previous versions reports and dwh installation?
Hello, I have some problems, I think they are also due to PosgreSQL access rules changes from f18 to f19. In particular if one has passed from fedora 18 to Fedora 19 and form 3.2 to 3.3 as I did; see https://bugzilla.redhat.com/show_bug.cgi?id=1009335
Right now I have a problem with my AIO installation where trying to upgrade from 3.3.2 to 3.3.3 I got many problems related to RDBMS.
Is this related to dwh/reports?
yes, engine is ok
Is there a way to completely get rid of prevous installtion and reinstall cleanly in 3.3.3 as I did on another system without getting problems.
So you want to delete dwh/reports only or also the engine?
Yes, only dwh/reports. Suppose I don't mind to maintain my previous (3.2.x settings in my case) and I want to start from new data Engine is ok
I tried removing packages: yum remove ovirt-engine-dwh ovirt-engine-reports
and deleting related databases:
drop database ovirt_engine_history; drop database ovirtenginereports;
This might not be enough. Sadly there is currently no cleanup tool for dwh/reports, similar to engine-cleanup for the engine.
For things to delete look at /etc/ovirt*dwh* /etc/ovirt-*reports* /etc/ovirt-engine/*dwh* /etc/ovirt-engine/*reports* /var/lib/ovirt-engine/deployments/*reports*
But then trying to install again packages and runnign setup I get this in log:
2014-01-30 00:37:30::DEBUG::common_utils::446::root:: running sql query on host: localhost, port: 5432, db: ovirt_engine_history, user: engine, query: 'select 1 from history_configuration;'. 2014-01-30 00:37:30::DEBUG::common_utils::907::root:: Executing command --> '/usr/bin/psql --pset=tuples_only=on --set ON_ERROR_STOP=1 --dbname ovirt_engine_history --host localhost --port 5432 --username engine -w -c select 1 from history_configuration;' in working directory '/root' 2014-01-30 00:37:30::DEBUG::common_utils::962::root:: output = 2014-01-30 00:37:30::DEBUG::common_utils::963::root:: stderr = ERROR: relation "history_configuration" does not exist LINE 1: select 1 from history_configuration;
This in itself is not necessarily a problem, unless of course setup failed immediately after that.
The actual problem that cause setup to abort was few lines below: 2014-01-30 00:37:42::DEBUG::common_utils::907::root:: Executing command --> '/usr/share/ovirt-engine-dwh/db-scripts/create_schema.sh -l /var/log/ovirt-engine/ovirt-history-db-install-2014_01_30_00_37_42.log -u engine_history -s localhost -p 5432 -g' in working directory '/root' 2014-01-30 00:37:42::DEBUG::common_utils::962::root:: output = 2014-01-30 00:37:42::DEBUG::common_utils::963::root:: stderr = psql: FATAL: password authentication failed for user "engine_history" FATAL: password authentication failed for user "engine_history" password retrieved from file "/tmp/pgpasss2gOEF.tmp" 2014-01-30 00:37:42::DEBUG::common_utils::964::root:: retcode = 2 2014-01-30 00:37:42::ERROR::decorators::27::root:: Traceback (most recent call last): File "/usr/share/ovirt-engine-dwh/decorators.py", line 20, in wrapped_f output = f(*args) File "/bin/ovirt-engine-dwh-setup", line 160, in createDbSchema envDict={'ENGINE_PGPASS': PGPASS_TEMP}, File "/usr/share/ovirt-engine-dwh/common_utils.py", line 967, in execCmd raise Exception(msg) Exception: Error while trying to create ovirt_engine_history db 2014-01-30 00:37:42::ERROR::ovirt-engine-dwh-setup::691::root:: Exception caught! 2014-01-30 00:37:42::ERROR::ovirt-engine-dwh-setup::692::root:: Traceback (most recent call last): File "/bin/ovirt-engine-dwh-setup", line 623, in main createDbSchema(db_dict) File "/usr/share/ovirt-engine-dwh/decorators.py", line 28, in wrapped_f raise Exception(instance) Exception: Error while trying to create ovirt_engine_history db
Which versions of relevant packages? Can you please post full logs?
I'm using packages from 3.3.3rc so: ovirt-engine-reports-3.3.3-1.fc19.noarch ovirt-engine-dwh-3.3.3-1.fc19.noarch
Can anyone tell if I have to run any other purge operation, suche as any users or table on engine db itself?
IIRC nothing in the engine db itself. Didn't check that, though.
And also what would be the expected configuration of /var/lib/pgsql/data/pg_hba.conf
Manually-edited? On a remote database server? Or local, letting the setup programs edit it for you? Please post it if you have a specific problem that you think might be related.
This is an All-In-One so that engine itself and its database, as the dwh and reports RDBMS are all on the same server I didn't edit anything, but I don't know if passing from f18 to f19 caused postgres yum update phase to change anything itself...
and eventually /var/lib/pgsql/data/postgresql.conf
Only max_connections is edited by setup, to be 150. For a remote database you want to change listen_addresses.
for a fedora 19 system so that a setup for reports and dwh could complete?
In general, on a clean system, with a local database, the setup programs should do what's needed and no manual fixes are needed.
I can try to remove packages and databases and suggested files you wrote again and rerun setup
Do note that, as Yaniv mentioned earlier, 3.3.3 should be used when released. 3.3.3-beta might probably be good enough if you can't wait.
Regards, -- Didi
See my full logs of attempts under /var/log/ovirt-engine here: https://drive.google.com/file/d/0BwoPbcrMv8mvb2lXVFVmTmVTTFE/edit?usp=sharin... and output of sessions of update of engine form 3.3.2 to 3.3.3 here https://drive.google.com/file/d/0BwoPbcrMv8mvMFdqNHk2SUJ1TkU/edit?usp=sharin... Gianluca