------=_Part_3235556_619001005.1395257716060 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Didi, can you take a look?=20 Yaniv=20 ----- Original Message -----
From: "Gabi C" <gabicr@gmail.com> To: users@ovirt.org Sent: Tuesday, March 18, 2014 12:29:41 PM Subject: [Users] ovirt-engine-dwh-setup fails
Hello!
ovirt-image-uploader-3.3.3-1.fc19.noarch ovirt-engine-dbscripts-3.3.4-1.fc19.noarch ovirt-host-deploy-1.1.3-1.fc19.noarch ovirt-engine-webadmin-portal-3.3.4-1.fc19.noarch ovirt-host-deploy-offline-1.1.3-1.fc19.noarch ovirt-engine-setup-3.3.4-1.fc19.noarch ovirt-engine-backend-3.3.4-1.fc19.noarch ovirt-host-deploy-java-1.1.3-1.fc19.noarch ovirt-engine-3.3.4-1.fc19.noarch ovirt-engine-dwh-3.3.4-1.fc19.noarch ovirt-engine-reports-3.3.4-1.fc19.noarch ovirt-engine-restapi-3.3.4-1.fc19.noarch ovirt-log-collector-3.3.4-1.fc19.noarch ovirt-iso-uploader-3.3.3-1.fc19.noarch ovirt-engine-lib-3.3.4-1.fc19.noarch ovirt-engine-tools-3.3.4-1.fc19.noarch ovirt-release-fedora-10.0.1-3.noarch ovirt-engine-cli-3.3.0.6-1.fc19.noarch ovirt-engine-websocket-proxy-3.3.4-1.fc19.noarch ovirt-engine-sdk-python-3.3.3.1-1.fc19.noarch ovirt-release-11.0.2-1.noarch ovirt-engine-userportal-3.3.4-1.fc19.noarch
Trying to run ovirt-engine-dwh-setup I get
Stopping ovirt-engine... [ DONE ] Error encountered while installing ovirt-engine-dwh, please consult the l= og file: ........
logfile follows
more /var/log/ovirt-engine/ovirt-engine-dwh-setup-2014_03_17_14_59_39.log 2014-03-17 14:59:39::DEBUG::ovirt-engine-dwh-setup::430::root:: starting main() 2014-03-17 14:59:39::DEBUG::common_utils::451::root:: running sql query o= n host: localhost, port: 5432, db: engine, user: engine, query: 'copy ( select option_value from vdc_options where option_name like 'MinimalETLVersion' ) to stdout with csv header;'. 2014-03-17 14:59:39::DEBUG::common_utils::912::root:: Executing command -= -> '/usr/bin/psql --pset=3Dtuples_only=3Don --set ON_ERROR_STOP=3D1 --dbname= engine --host localhost --port 5432 --username engine -w -c copy ( select option_value from vdc_options where option_name like 'MinimalETLVersion' ) to stdout with csv header;' in working directory '/var/lib/pgsql/data' 2014-03-17 14:59:39::DEBUG::common_utils::967::root:: output =3D option_v= alue 3.3.0
2014-03-17 14:59:39::DEBUG::common_utils::968::root:: stderr =3D 2014-03-17 14:59:39::DEBUG::common_utils::969::root:: retcode =3D 0 2014-03-17 14:59:39::DEBUG::common_utils::153::root:: Value of MinimalETLVersion is 3.3.0 2014-03-17 14:59:39::DEBUG::common_utils::912::root:: Executing command -= -> 'rpm -q --queryformat %{VERSION}-%{RELEASE} ovirt-engine-dwh' in working directory '/var/lib/pgsql/data' 2014-03-17 14:59:39::DEBUG::common_utils::967::root:: output =3D 3.3.4-1.= fc19 2014-03-17 14:59:39::DEBUG::common_utils::968::root:: stderr =3D 2014-03-17 14:59:39::DEBUG::common_utils::969::root:: retcode =3D 0 2014-03-17 14:59:39::DEBUG::common_utils::617::root:: setting regex (\d+\.\d+)\.(\d+)\-(\d+) againts 3.3.4-1.fc19 2014-03-17 14:59:39::DEBUG::common_utils::622::root:: found version, 3.3 2014-03-17 14:59:39::DEBUG::common_utils::624::root:: found minorVersion = 4 2014-03-17 14:59:39::DEBUG::common_utils::626::root:: found release 1 2014-03-17 14:59:39::DEBUG::common_utils::617::root:: setting regex (\d+\.\d+)\.(\d+)\-(\d+) againts 3.3.0-0 2014-03-17 14:59:39::DEBUG::common_utils::622::root:: found version, 3.3 2014-03-17 14:59:39::DEBUG::common_utils::624::root:: found minorVersion = 0 2014-03-17 14:59:39::DEBUG::common_utils::626::root:: found release 0 2014-03-17 14:59:39::DEBUG::common_utils::491::root:: checking ovirt-engi= ne service 2014-03-17 14:59:39::DEBUG::common_utils::482::root:: checking the status= of ovirt-engine 2014-03-17 14:59:39::DEBUG::common_utils::260::root:: getting status for ovirt-engine 2014-03-17 14:59:39::DEBUG::common_utils::277::root:: executing action ovirt-engine on service status 2014-03-17 14:59:39::DEBUG::common_utils::912::root:: Executing command -= -> '/sbin/service ovirt-engine status' in working directory '/var/lib/pgsql/data' 2014-03-17 14:59:39::DEBUG::common_utils::967::root:: output =3D ovirt-engine.service - oVirt Engine Loaded: loaded (/usr/lib/systemd/system/ovirt-engine.service; enabled) Active: inactive (dead) since Mon 2014-03-17 14:58:56 EET; 43s ago Main PID: 5794 (code=3Dexited, status=3D0/SUCCESS) CGroup: name=3Dsystemd:/system/ovirt-engine.service
Mar 17 14:52:31 vpo-rhevm.stfd.ro systemd[1]: Started oVirt Engine. Mar 17 14:52:32 vpo-rhevm.stfd.ro ovirt-engine.py[5794]: 2014-03-17 14:52:32,340 ovirt-engine: WARNING _setupEngineApps:176 Application directory '/usr/share/ovirt-engine/ovirt-engine-report s.war' does not exist, it will be ignored Mar 17 14:58:55 vpo-rhevm.stfd.ro systemd[1]: Stopping oVirt Engine... Mar 17 14:58:56 vpo-rhevm.stfd.ro systemd[1]: Stopped oVirt Engine.
2014-03-17 14:59:39::DEBUG::common_utils::968::root:: stderr =3D Redirect= ing to /bin/systemctl status ovirt-engine.service
2014-03-17 14:59:39::DEBUG::common_utils::969::root:: retcode =3D 3 2014-03-17 14:59:39::DEBUG::common_utils::590::root:: Stopping ovirt-engine-dwhd 2014-03-17 14:59:39::DEBUG::common_utils::581::root:: checking the status= of dwhd 2014-03-17 14:59:39::DEBUG::common_utils::260::root:: getting status for ovirt-engine-dwhd 2014-03-17 14:59:39::DEBUG::common_utils::277::root:: executing action ovirt-engine-dwhd on service status 2014-03-17 14:59:39::DEBUG::common_utils::912::root:: Executing command -= -> '/sbin/service ovirt-engine-dwhd status' in working directory '/var/lib/pgsql/data' 2014-03-17 14:59:40::DEBUG::common_utils::967::root:: output =3D /etc/init.d/ovirt-engine-dwhd is stopped
2014-03-17 14:59:40::DEBUG::common_utils::968::root:: stderr =3D 2014-03-17 14:59:40::DEBUG::common_utils::969::root:: retcode =3D 1 2014-03-17 14:59:40::DEBUG::common_utils::912::root:: Executing command -= -> 'rpm -q --queryformat %{VERSION}-%{RELEASE} ovirt-engine-dwh' in working directory '/var/lib/pgsql/data' 2014-03-17 14:59:40::DEBUG::common_utils::967::root:: output =3D 3.3.4-1.= fc19 2014-03-17 14:59:40::DEBUG::common_utils::968::root:: stderr =3D 2014-03-17 14:59:40::DEBUG::common_utils::969::root:: retcode =3D 0 2014-03-17 14:59:40::DEBUG::common_utils::617::root:: setting regex (\d+\.\d+)\.(\d+)\-(\d+) againts 3.3.4-1.fc19 2014-03-17 14:59:40::DEBUG::common_utils::622::root:: found version, 3.3 2014-03-17 14:59:40::DEBUG::common_utils::624::root:: found minorVersion = 4 2014-03-17 14:59:40::DEBUG::common_utils::626::root:: found release 1 2014-03-17 14:59:40::DEBUG::ovirt-engine-dwh-setup::391::root:: Setting etlVersion 2014-03-17 14:59:40::DEBUG::ovirt-engine-dwh-setup::392::root:: editing e= tl connectivity file 2014-03-17 14:59:40::DEBUG::common_utils::912::root:: Executing command -= -> '/sbin/ip addr' in working directory '/var/lib/pgsql/data' 2014-03-17 14:59:40::DEBUG::common_utils::967::root:: output =3D 1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group defaul= t link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00 inet 127.0.0.1/8 scope host lo valid_lft forever preferred_lft forever inet6 ::1/128 scope host valid_lft forever preferred_lft forever 2: bond0: <NO-CARRIER,BROADCAST,MULTICAST,MASTER,UP> mtu 1500 qdisc noque= ue state DOWN group default link/ether c2:71:02:2b:9b:01 brd ff:ff:ff:ff:ff:ff 3: ens32: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast sta= te UP group default qlen 1000 link/ether 00:0c:29:7f:5b:4b brd ff:ff:ff:ff:ff:ff inet 10.125.1.171/24 brd 10.125.1.255 scope global ens32 valid_lft forever preferred_lft forever inet6 fe80::20c:29ff:fe7f:5b4b/64 scope link valid_lft forever preferred_lft forever 4: ;vdsmdummy;: <BROADCAST,MULTICAST> mtu 1500 qdisc noop state DOWN grou= p default link/ether 72:06:8c:05:e3:a3 brd ff:ff:ff:ff:ff:ff
2014-03-17 14:59:40::DEBUG::common_utils::968::root:: stderr =3D 2014-03-17 14:59:40::DEBUG::common_utils::969::root:: retcode =3D 0 2014-03-17 14:59:40::DEBUG::common_utils::755::root:: Found IP Address: 10.125.1.171 2014-03-17 14:59:40::DEBUG::common_utils::1406::root:: Updating pghba postgres use 2014-03-17 14:59:40::DEBUG::common_utils::529::root:: checking the status= of postgresql 2014-03-17 14:59:40::DEBUG::common_utils::260::root:: getting status for postgresql 2014-03-17 14:59:40::DEBUG::common_utils::277::root:: executing action postgresql on service status 2014-03-17 14:59:40::DEBUG::common_utils::912::root:: Executing command -= -> '/sbin/service postgresql status' in working directory '/var/lib/pgsql/da= ta' 2014-03-17 14:59:40::DEBUG::common_utils::967::root:: output =3D postgresql.service - PostgreSQL database server Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled) Active: active (running) since Mon 2014-03-17 14:59:32 EET; 8s ago Process: 6503 ExecStop=3D/usr/bin/pg_ctl stop -D ${PGDATA} -s -m fast (code=3Dexited, status=3D0/SUCCESS) Process: 6514 ExecStart=3D/usr/bin/pg_ctl start -D ${PGDATA} -s -o -p ${P= GPORT} -w -t 300 (code=3Dexited, status=3D0/SUCCESS) Process: 6507 ExecStartPre=3D/usr/bin/postgresql-check-db-dir ${PGDATA} (code=3Dexited, status=3D0/SUCCESS) Main PID: 6517 (postgres) CGroup: name=3Dsystemd:/system/postgresql.service =E2=94=9C=E2=94=806517 /usr/bin/postgres -D /var/lib/pgsql/data -p 5432 =E2=94=9C=E2=94=806518 postgres: logger process =E2=94=9C=E2=94=806520 postgres: checkpointer process =E2=94=9C=E2=94=806521 postgres: writer process =E2=94=9C=E2=94=806522 postgres: wal writer process =E2=94=9C=E2=94=806523 postgres: autovacuum launcher process =E2=94=94=E2=94=806524 postgres: stats collector process
Mar 17 14:59:31 vpo-rhevm.stfd.ro systemd[1]: Starting PostgreSQL databas= e server... Mar 17 14:59:32 vpo-rhevm.stfd.ro systemd[1]: Started PostgreSQL database server.
2014-03-17 14:59:40::DEBUG::common_utils::968::root:: stderr =3D Redirect= ing to /bin/systemctl status postgresql.service
2014-03-17 14:59:40::DEBUG::common_utils::969::root:: retcode =3D 0 2014-03-17 14:59:40::DEBUG::common_utils::573::root:: stopping postgresql 2014-03-17 14:59:40::DEBUG::common_utils::226::root:: stopping postgresql 2014-03-17 14:59:40::DEBUG::common_utils::277::root:: executing action postgresql on service stop 2014-03-17 14:59:40::DEBUG::common_utils::912::root:: Executing command -= -> '/sbin/service postgresql stop' in working directory '/var/lib/pgsql/data= ' 2014-03-17 14:59:41::DEBUG::common_utils::967::root:: output =3D 2014-03-17 14:59:41::DEBUG::common_utils::968::root:: stderr =3D Redirect= ing to /bin/systemctl stop postgresql.service
2014-03-17 14:59:41::DEBUG::common_utils::969::root:: retcode =3D 0 2014-03-17 14:59:41::DEBUG::common_utils::529::root:: checking the status= of postgresql 2014-03-17 14:59:41::DEBUG::common_utils::260::root:: getting status for postgresql 2014-03-17 14:59:41::DEBUG::common_utils::277::root:: executing action postgresql on service status 2014-03-17 14:59:41::DEBUG::common_utils::912::root:: Executing command -= -> '/sbin/service postgresql status' in working directory '/var/lib/pgsql/da= ta' 2014-03-17 14:59:41::DEBUG::common_utils::967::root:: output =3D postgresql.service - PostgreSQL database server Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled) Active: inactive (dead) since Mon 2014-03-17 14:59:41 EET; 119ms ago Process: 6567 ExecStop=3D/usr/bin/pg_ctl stop -D ${PGDATA} -s -m fast (code=3Dexited, status=3D0/SUCCESS) Process: 6514 ExecStart=3D/usr/bin/pg_ctl start -D ${PGDATA} -s -o -p ${P= GPORT} -w -t 300 (code=3Dexited, status=3D0/SUCCESS) Process: 6507 ExecStartPre=3D/usr/bin/postgresql-check-db-dir ${PGDATA} (code=3Dexited, status=3D0/SUCCESS) Main PID: 6517 (code=3Dexited, status=3D0/SUCCESS) CGroup: name=3Dsystemd:/system/postgresql.service
Mar 17 14:59:31 vpo-rhevm.stfd.ro systemd[1]: Starting PostgreSQL databas= e server... Mar 17 14:59:32 vpo-rhevm.stfd.ro systemd[1]: Started PostgreSQL database server. Mar 17 14:59:40 vpo-rhevm.stfd.ro systemd[1]: Stopping PostgreSQL databas= e server... Mar 17 14:59:41 vpo-rhevm.stfd.ro systemd[1]: Stopped PostgreSQL database server.
2014-03-17 14:59:41::DEBUG::common_utils::968::root:: stderr =3D Redirect= ing to /bin/systemctl status postgresql.service
2014-03-17 14:59:41::DEBUG::common_utils::969::root:: retcode =3D 3 2014-03-17 14:59:41::DEBUG::common_utils::568::root:: starting postgresql 2014-03-17 14:59:41::DEBUG::common_utils::216::root:: starting postgresql 2014-03-17 14:59:41::DEBUG::common_utils::277::root:: executing action postgresql on service start 2014-03-17 14:59:41::DEBUG::common_utils::912::root:: Executing command -= -> '/sbin/service postgresql start' in working directory '/var/lib/pgsql/dat= a' 2014-03-17 14:59:42::DEBUG::common_utils::967::root:: output =3D 2014-03-17 14:59:43::DEBUG::common_utils::968::root:: stderr =3D Redirect= ing to /bin/systemctl start postgresql.service
2014-03-17 14:59:43::DEBUG::common_utils::969::root:: retcode =3D 0 2014-03-17 14:59:43::DEBUG::common_utils::1460::root:: starting runPostgresSuQuery database: template1 query: "select 1;" 2014-03-17 14:59:43::DEBUG::common_utils::912::root:: Executing command -= -> '/bin/su -l postgres -c /usr/bin/psql -U postgres -d template1 -tA -c "select 1;"' in working directory '/var/lib/ pgsql/data' 2014-03-17 14:59:43::DEBUG::common_utils::967::root:: output =3D 2014-03-17 14:59:43::DEBUG::common_utils::968::root:: stderr =3D Password= for user postgres: psql: fe_sendauth: no password supplied
2014-03-17 14:59:43::DEBUG::common_utils::969::root:: retcode =3D 2 2014-03-17 14:59:45::DEBUG::common_utils::1460::root:: starting runPostgresSuQuery database: template1 query: "select 1;" 2014-03-17 14:59:45::DEBUG::common_utils::912::root:: Executing command -= -> '/bin/su -l postgres -c /usr/bin/psql -U postgres -d template1 -tA -c "select 1;"' in working directory '/var/lib/ pgsql/data' 2014-03-17 14:59:45::DEBUG::common_utils::967::root:: output =3D 2014-03-17 14:59:45::DEBUG::common_utils::968::root:: stderr =3D Password= for user postgres: psql: fe_sendauth: no password supplied
2014-03-17 14:59:45::DEBUG::common_utils::969::root:: retcode =3D 2 2014-03-17 14:59:47::DEBUG::common_utils::1460::root:: starting runPostgresSuQuery database: template1 query: "select 1;" 2014-03-17 14:59:47::DEBUG::common_utils::912::root:: Executing command -= -> '/bin/su -l postgres -c /usr/bin/psql -U postgres -d template1 -tA -c "select 1;"' in working directory '/var/lib/ pgsql/data' 2014-03-17 14:59:47::DEBUG::common_utils::967::root:: output =3D 2014-03-17 14:59:47::DEBUG::common_utils::968::root:: stderr =3D Password= for user postgres: psql: fe_sendauth: no password supplied
2014-03-17 14:59:47::DEBUG::common_utils::969::root:: retcode =3D 2 2014-03-17 14:59:49::DEBUG::common_utils::1460::root:: starting runPostgresSuQuery database: template1 query: "select 1;" 2014-03-17 14:59:49::DEBUG::common_utils::912::root:: Executing command -= -> '/bin/su -l postgres -c /usr/bin/psql -U postgres -d template1 -tA -c "select 1;"' in working directory '/var/lib/ pgsql/data' 2014-03-17 14:59:49::DEBUG::common_utils::967::root:: output =3D 2014-03-17 14:59:49::DEBUG::common_utils::968::root:: stderr =3D Password= for user postgres: psql: fe_sendauth: no password supplied
2014-03-17 14:59:49::DEBUG::common_utils::969::root:: retcode =3D 2 2014-03-17 14:59:51::DEBUG::common_utils::1460::root:: starting runPostgresSuQuery database: template1 query: "select 1;" 2014-03-17 14:59:51::DEBUG::common_utils::912::root:: Executing command -= -> '/bin/su -l postgres -c /usr/bin/psql -U postgres -d template1 -tA -c "select 1;"' in working directory '/var/lib/ pgsql/data' 2014-03-17 14:59:52::DEBUG::common_utils::967::root:: output =3D 2014-03-17 14:59:52::DEBUG::common_utils::968::root:: stderr =3D Password= for user postgres: psql: fe_sendauth: no password supplied
2014-03-17 14:59:52::DEBUG::common_utils::969::root:: retcode =3D 2 2014-03-17 14:59:54::ERROR::ovirt-engine-dwh-setup::716::root:: Exception caught! 2014-03-17 14:59:54::ERROR::ovirt-engine-dwh-setup::717::root:: Traceback (most recent call last): File "/usr/bin/ovirt-engine-dwh-setup", line 474, in main pg_updated =3D utils.configHbaIdent() File "/usr/share/ovirt-engine-dwh/common_utils.py", line 1431, in configHbaIdent restartPostgres(newval=3D=3D'md5') File "/usr/share/ovirt-engine-dwh/common_utils.py", line 887, in restartPostgres startPostgres() File "/usr/share/ovirt-engine-dwh/common_utils.py", line 556, in startPostgres 'Error: postgresql service couldn\'t be started. Stopping.' RuntimeError: Error: postgresql service couldn't be started. Stopping.
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
<br></div><div>Yaniv</div><div><br></div><hr id=3D"zwchr"><blockquote styl= e=3D"border-left:2px solid #1010FF;margin-left:5px;padding-left:5px;color:#= 000;font-weight:normal;font-style:normal;text-decoration:none;font-family:H= elvetica,Arial,sans-serif;font-size:12pt;"><b>From: </b>"Gabi C" <gabicr= @gmail.com><br><b>To: </b>users@ovirt.org<br><b>Sent: </b>Tuesday, March= 18, 2014 12:29:41 PM<br><b>Subject: </b>[Users] ovirt-engine-dwh-setup fai= ls<br><div><br></div><div dir=3D"ltr"><div>Hello!<br><div><br></div></div><=
2014-03-17 14:59:39::DEBUG::common_utils::624::root:: found minorVersion 4= <br>2014-03-17 14:59:39::DEBUG::common_utils::626::root:: found release 1<b= r> 2014-03-17 14:59:39::DEBUG::common_utils::617::root:: setting regex (\d+\.\= d+)\.(\d+)\-(\d+) againts 3.3.0-0<br>2014-03-17 14:59:39::DEBUG::common_uti= ls::622::root:: found version, 3.3<br>2014-03-17 14:59:39::DEBUG::common_ut= ils::624::root:: found minorVersion 0<br> 2014-03-17 14:59:39::DEBUG::common_utils::626::root:: found release 0<br>20= 14-03-17 14:59:39::DEBUG::common_utils::491::root:: checking ovirt-engine s= ervice<br>2014-03-17 14:59:39::DEBUG::common_utils::482::root:: checking th= e status of ovirt-engine<br> 2014-03-17 14:59:39::DEBUG::common_utils::260::root:: getting status for ov= irt-engine<br>2014-03-17 14:59:39::DEBUG::common_utils::277::root:: executi= ng action ovirt-engine on service status<br>2014-03-17 14:59:39::DEBUG::com= mon_utils::912::root:: Executing command --> '/sbin/service ovirt-engine= status' in working directory '/var/lib/pgsql/data'<br> 2014-03-17 14:59:39::DEBUG::common_utils::967::root:: output =3D ovirt-engi= ne.service - oVirt Engine<br> Loaded: loaded (/usr/lib/systemd/= system/ovirt-engine.service; enabled)<br> Active: inactive (dea= d) since Mon 2014-03-17 14:58:56 EET; 43s ago<br> Main PID: 5794 (code=3Dexited, status=3D0/SUCCESS)<br> CG= roup: name=3Dsystemd:/system/ovirt-engine.service<br><div><br></div>Mar 17 = 14:52:31 <a href=3D"http://vpo-rhevm.stfd.ro" target=3D"_blank">vpo-rhevm.s= tfd.ro</a> systemd[1]: Started oVirt Engine.<br> Mar 17 14:52:32 <a href=3D"http://vpo-rhevm.stfd.ro" target=3D"_blank">vpo-= rhevm.stfd.ro</a> ovirt-engine.py[5794]: 2014-03-17 14:52:32,340 ovirt-engi= ne: WARNING _setupEngineApps:176 Application directory '/usr/share/ovirt-en= gine/ovirt-engine-report<br> s.war' does not exist, it will be ignored<br>Mar 17 14:58:55 <a href=3D"htt=
2014-03-17 14:59:39::DEBUG::common_utils::969::root:: retcode =3D 3<br>201= 4-03-17 14:59:39::DEBUG::common_utils::590::root:: Stopping ovirt-engine-dw= hd<br> 2014-03-17 14:59:39::DEBUG::common_utils::581::root:: checking the status o= f dwhd<br>2014-03-17 14:59:39::DEBUG::common_utils::260::root:: getting sta= tus for ovirt-engine-dwhd<br>2014-03-17 14:59:39::DEBUG::common_utils::277:= :root:: executing action ovirt-engine-dwhd on service status<br> 2014-03-17 14:59:39::DEBUG::common_utils::912::root:: Executing command --&= gt; '/sbin/service ovirt-engine-dwhd status' in working directory '/var/lib= /pgsql/data'<br>2014-03-17 14:59:40::DEBUG::common_utils::967::root:: outpu= t =3D /etc/init.d/ovirt-engine-dwhd is stopped<br> <br>2014-03-17 14:59:40::DEBUG::common_utils::968::root:: stderr =3D <br>20= 14-03-17 14:59:40::DEBUG::common_utils::969::root:: retcode =3D 1<br>2014-0= 3-17 14:59:40::DEBUG::common_utils::912::root:: Executing command --> 'r=
2014-03-17 14:59:40::DEBUG::common_utils::624::root:: found minorVersion 4= <br>2014-03-17 14:59:40::DEBUG::common_utils::626::root:: found release 1<b= r> 2014-03-17 14:59:40::DEBUG::ovirt-engine-dwh-setup::391::root:: Setting etl= Version<br>2014-03-17 14:59:40::DEBUG::ovirt-engine-dwh-setup::392::root:: = editing etl connectivity file<br>2014-03-17 14:59:40::DEBUG::common_utils::= 912::root:: Executing command --> '/sbin/ip addr' in working directory '= /var/lib/pgsql/data'<br> 2014-03-17 14:59:40::DEBUG::common_utils::967::root:: output =3D 1: lo: <= ;LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group defau= lt <br> link/loopback 00:00:00:00:00:00 brd 00:00:00:00:0= 0:00<br> inet <a href=3D"http://127.0.0.1/8" target=3D"_b= lank">127.0.0.1/8</a> scope host lo<br> valid_lft forever preferred_lft foreve= r<br> inet6 ::1/128 scope host <br> &nbs=
------=_Part_3235556_619001005.1395257716060 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <html><body><div style=3D"font-family: Arial; font-size: 10pt; color: #0000= 00"><div>Didi, can you take a look?</div><div><br></div><div><br></div><div= div><div>ovirt-image-uploader-3.3.3-1.fc19.noarch<br>ovirt-engine-dbscripts= -3.3.4-1.fc19.noarch<br>ovirt-host-deploy-1.1.3-1.fc19.noarch<br>ovirt-engi= ne-webadmin-portal-3.3.4-1.fc19.noarch<br> ovirt-host-deploy-offline-1.1.3-1.fc19.noarch<br>ovirt-engine-setup-3.3.4-1= .fc19.noarch<br>ovirt-engine-backend-3.3.4-1.fc19.noarch<br>ovirt-host-depl= oy-java-1.1.3-1.fc19.noarch<br>ovirt-engine-3.3.4-1.fc19.noarch<br>ovirt-en= gine-dwh-3.3.4-1.fc19.noarch<br> ovirt-engine-reports-3.3.4-1.fc19.noarch<br>ovirt-engine-restapi-3.3.4-1.fc= 19.noarch<br>ovirt-log-collector-3.3.4-1.fc19.noarch<br>ovirt-iso-uploader-= 3.3.3-1.fc19.noarch<br>ovirt-engine-lib-3.3.4-1.fc19.noarch<br>ovirt-engine= -tools-3.3.4-1.fc19.noarch<br> ovirt-release-fedora-10.0.1-3.noarch<br>ovirt-engine-cli-3.3.0.6-1.fc19.noa= rch<br>ovirt-engine-websocket-proxy-3.3.4-1.fc19.noarch<br>ovirt-engine-sdk= -python-3.3.3.1-1.fc19.noarch<br>ovirt-release-11.0.2-1.noarch<br>ovirt-eng= ine-userportal-3.3.4-1.fc19.noarch<br> <br></div><div>Trying to run ovirt-engine-dwh-setup I get <br><div><br></di= v>Stopping ovirt-engine... &= nbsp; &nbs= p; [ DONE ]<br>Error encoun= tered while installing ovirt-engine-dwh, please consult the log file: .....= ...<br> <br></div><div>logfile follows<br></div><div><br>more /var/log/ovirt-engine= /ovirt-engine-dwh-setup-2014_03_17_14_59_39.log<br>2014-03-17 14:59:39::DEB= UG::ovirt-engine-dwh-setup::430::root:: starting main()<br>2014-03-17 14:59= :39::DEBUG::common_utils::451::root:: running sql query on host: localhost,= port: 5432, db: engine, user: engine, query: 'copy (<br> select option_value from vdc_opt= ions<br> where option_name like '= MinimalETLVersion'<br> ) to stdout with csv header;'.<br>= 2014-03-17 14:59:39::DEBUG::common_utils::912::root:: Executing command --&= gt; '/usr/bin/psql --pset=3Dtuples_only=3Don --set ON_ERROR_STOP=3D1 --dbna= me engine --host localhost --port 5432 --username<br> engine -w -c copy (<br> sel= ect option_value from vdc_options<br> &n= bsp; where option_name like 'MinimalETLVersion'<br> ) to = stdout with csv header;' in working directory '/var/lib/pgsql/data'<br> 2014-03-17 14:59:39::DEBUG::common_utils::967::root:: output =3D option_val= ue<br>3.3.0<br><div><br></div>2014-03-17 14:59:39::DEBUG::common_utils::968= ::root:: stderr =3D <br>2014-03-17 14:59:39::DEBUG::common_utils::969::root= :: retcode =3D 0<br> 2014-03-17 14:59:39::DEBUG::common_utils::153::root:: Value of MinimalETLVe= rsion is 3.3.0<br>2014-03-17 14:59:39::DEBUG::common_utils::912::root:: Exe= cuting command --> 'rpm -q --queryformat %{VERSION}-%{RELEASE} ovirt-eng= ine-dwh' in working directory '/var/lib/pgsql/data'<br> 2014-03-17 14:59:39::DEBUG::common_utils::967::root:: output =3D 3.3.4-1.fc= 19<br>2014-03-17 14:59:39::DEBUG::common_utils::968::root:: stderr =3D <br>= 2014-03-17 14:59:39::DEBUG::common_utils::969::root:: retcode =3D 0<br>2014= -03-17 14:59:39::DEBUG::common_utils::617::root:: setting regex (\d+\.\d+)\= .(\d+)\-(\d+) againts 3.3.4-1.fc19<br> 2014-03-17 14:59:39::DEBUG::common_utils::622::root:: found version, 3.3<br= p://vpo-rhevm.stfd.ro" target=3D"_blank">vpo-rhevm.stfd.ro</a> systemd[1]: = Stopping oVirt Engine...<br>Mar 17 14:58:56 <a href=3D"http://vpo-rhevm.stf= d.ro" target=3D"_blank">vpo-rhevm.stfd.ro</a> systemd[1]: Stopped oVirt Eng= ine.<br> <br>2014-03-17 14:59:39::DEBUG::common_utils::968::root:: stderr =3D Redire= cting to /bin/systemctl status ovirt-engine.service<br><div><br></div= pm -q --queryformat %{VERSION}-%{RELEASE} ovirt-engine-dwh' in working dire= ctory '/var/lib/pgsql/data'<br> 2014-03-17 14:59:40::DEBUG::common_utils::967::root:: output =3D 3.3.4-1.fc= 19<br>2014-03-17 14:59:40::DEBUG::common_utils::968::root:: stderr =3D <br>= 2014-03-17 14:59:40::DEBUG::common_utils::969::root:: retcode =3D 0<br>2014= -03-17 14:59:40::DEBUG::common_utils::617::root:: setting regex (\d+\.\d+)\= .(\d+)\-(\d+) againts 3.3.4-1.fc19<br> 2014-03-17 14:59:40::DEBUG::common_utils::622::root:: found version, 3.3<br= p; valid_lft forever preferred_lft forever<br>2: bond0: <NO-= CARRIER,BROADCAST,MULTICAST,MASTER,UP> mtu 1500 qdisc noqueue state DOWN= group default <br> link/ether c2:71:02:2b:9b:01 brd ff:ff:ff:ff:ff:ff<br>3:= ens32: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast s= tate UP group default qlen 1000<br> link/ether 00:0c:29:7= f:5b:4b brd ff:ff:ff:ff:ff:ff<br> inet <a href=3D"http://10.125.1.171/24" target=3D"_blank= ">10.125.1.171/24</a> brd 10.125.1.255 scope global ens32<br> &n= bsp; valid_lft forever preferred_lft forever<br> &nb= sp; inet6 fe80::20c:29ff:fe7f:5b4b/64 scope link <br> &nbs= p; valid_lft forever preferred_lft forever<br> 4: ;vdsmdummy;: <BROADCAST,MULTICAST> mtu 1500 qdisc noop state DOWN = group default <br> link/ether 72:06:8c:05:e3:a3 brd ff:ff= :ff:ff:ff:ff<br><div><br></div>2014-03-17 14:59:40::DEBUG::common_utils::96= 8::root:: stderr =3D <br> 2014-03-17 14:59:40::DEBUG::common_utils::969::root:: retcode =3D 0<br>2014= -03-17 14:59:40::DEBUG::common_utils::755::root:: Found IP Address: 10.125.= 1.171<br>2014-03-17 14:59:40::DEBUG::common_utils::1406::root:: Updating pg= hba postgres use<br> 2014-03-17 14:59:40::DEBUG::common_utils::529::root:: checking the status o= f postgresql<br>2014-03-17 14:59:40::DEBUG::common_utils::260::root:: getti= ng status for postgresql<br>2014-03-17 14:59:40::DEBUG::common_utils::277::= root:: executing action postgresql on service status<br> 2014-03-17 14:59:40::DEBUG::common_utils::912::root:: Executing command --&= gt; '/sbin/service postgresql status' in working directory '/var/lib/pgsql/= data'<br>2014-03-17 14:59:40::DEBUG::common_utils::967::root:: output =3D p= ostgresql.service - PostgreSQL database server<br> Loaded: loaded (/usr/lib/systemd/system/postgresql.service; en= abled)<br> Active: active (running) since Mon 2014-03-17 14:59:= 32 EET; 8s ago<br> Process: 6503 ExecStop=3D/usr/bin/pg_ctl stop -D $= {PGDATA} -s -m fast (code=3Dexited, status=3D0/SUCCESS)<br> Process: 6514 ExecStart=3D/usr/bin/pg_ctl start -D ${PGDATA} -s -o -= p ${PGPORT} -w -t 300 (code=3Dexited, status=3D0/SUCCESS)<br> Process= : 6507 ExecStartPre=3D/usr/bin/postgresql-check-db-dir ${PGDATA} (code=3Dex= ited, status=3D0/SUCCESS)<br> Main PID: 6517 (postgres)<br> CGroup: name=3Dsystemd:/sys= tem/postgresql.service<br> &= nbsp; =E2=94=9C=E2=94=806517 /usr/bin/postgres -D /var/lib/pgsql/data= -p 5432<br> = =E2=94=9C=E2=94=806518 postgres: logger process &nbs= p; &= nbsp; <br> =E2=94=9C=E2= =94=806520 postgres: checkpointer process &nbs= p; <br>&n= bsp; =E2=94=9C=E2=94= =806521 postgres: writer process &= nbsp; &nbs= p; <br> &n= bsp; =E2=94=9C=E2=94=806522 postgres: wal writer process &= nbsp; &nbs= p; <br> &n= bsp; =E2=94=9C=E2=94=806523 postgres: autovacuum launcher proce= ss <br> =E2=94=94=E2= =94=806524 postgres: stats collector process &= nbsp; <br><div><br></div>Ma= r 17 14:59:31 <a href=3D"http://vpo-rhevm.stfd.ro" target=3D"_blank">vpo-rh= evm.stfd.ro</a> systemd[1]: Starting PostgreSQL database server...<br>Mar 1= 7 14:59:32 <a href=3D"http://vpo-rhevm.stfd.ro" target=3D"_blank">vpo-rhevm= .stfd.ro</a> systemd[1]: Started PostgreSQL database server.<br> <br>2014-03-17 14:59:40::DEBUG::common_utils::968::root:: stderr =3D Redire= cting to /bin/systemctl status postgresql.service<br><div><br></div>2= 014-03-17 14:59:40::DEBUG::common_utils::969::root:: retcode =3D 0<br>2014-= 03-17 14:59:40::DEBUG::common_utils::573::root:: stopping postgresql<br> 2014-03-17 14:59:40::DEBUG::common_utils::226::root:: stopping postgresql<b= r>2014-03-17 14:59:40::DEBUG::common_utils::277::root:: executing action po= stgresql on service stop<br>2014-03-17 14:59:40::DEBUG::common_utils::912::= root:: Executing command --> '/sbin/service postgresql stop' in working = directory '/var/lib/pgsql/data'<br> 2014-03-17 14:59:41::DEBUG::common_utils::967::root:: output =3D <br>2014-0= 3-17 14:59:41::DEBUG::common_utils::968::root:: stderr =3D Redirecting to /= bin/systemctl stop postgresql.service<br><div><br></div>2014-03-17 14= :59:41::DEBUG::common_utils::969::root:: retcode =3D 0<br> 2014-03-17 14:59:41::DEBUG::common_utils::529::root:: checking the status o= f postgresql<br>2014-03-17 14:59:41::DEBUG::common_utils::260::root:: getti= ng status for postgresql<br>2014-03-17 14:59:41::DEBUG::common_utils::277::= root:: executing action postgresql on service status<br> 2014-03-17 14:59:41::DEBUG::common_utils::912::root:: Executing command --&= gt; '/sbin/service postgresql status' in working directory '/var/lib/pgsql/= data'<br>2014-03-17 14:59:41::DEBUG::common_utils::967::root:: output =3D p= ostgresql.service - PostgreSQL database server<br> Loaded: loaded (/usr/lib/systemd/system/postgresql.service; en= abled)<br> Active: inactive (dead) since Mon 2014-03-17 14:59:4= 1 EET; 119ms ago<br> Process: 6567 ExecStop=3D/usr/bin/pg_ctl stop -D= ${PGDATA} -s -m fast (code=3Dexited, status=3D0/SUCCESS)<br> Process: 6514 ExecStart=3D/usr/bin/pg_ctl start -D ${PGDATA} -s -o -= p ${PGPORT} -w -t 300 (code=3Dexited, status=3D0/SUCCESS)<br> Process= : 6507 ExecStartPre=3D/usr/bin/postgresql-check-db-dir ${PGDATA} (code=3Dex= ited, status=3D0/SUCCESS)<br> Main PID: 6517 (code=3Dexited, status=3D0/SUCCESS)<br> CG= roup: name=3Dsystemd:/system/postgresql.service<br><div><br></div>Mar 17 14= :59:31 <a href=3D"http://vpo-rhevm.stfd.ro" target=3D"_blank">vpo-rhevm.stf= d.ro</a> systemd[1]: Starting PostgreSQL database server...<br> Mar 17 14:59:32 <a href=3D"http://vpo-rhevm.stfd.ro" target=3D"_blank">vpo-= rhevm.stfd.ro</a> systemd[1]: Started PostgreSQL database server.<br>Mar 17= 14:59:40 <a href=3D"http://vpo-rhevm.stfd.ro" target=3D"_blank">vpo-rhevm.= stfd.ro</a> systemd[1]: Stopping PostgreSQL database server...<br> Mar 17 14:59:41 <a href=3D"http://vpo-rhevm.stfd.ro" target=3D"_blank">vpo-= rhevm.stfd.ro</a> systemd[1]: Stopped PostgreSQL database server.<br><div><= br></div>2014-03-17 14:59:41::DEBUG::common_utils::968::root:: stderr =3D R= edirecting to /bin/systemctl status postgresql.service<br> <br>2014-03-17 14:59:41::DEBUG::common_utils::969::root:: retcode =3D 3<br>= 2014-03-17 14:59:41::DEBUG::common_utils::568::root:: starting postgresql<b= r>2014-03-17 14:59:41::DEBUG::common_utils::216::root:: starting postgresql= <br> 2014-03-17 14:59:41::DEBUG::common_utils::277::root:: executing action post= gresql on service start<br>2014-03-17 14:59:41::DEBUG::common_utils::912::r= oot:: Executing command --> '/sbin/service postgresql start' in working = directory '/var/lib/pgsql/data'<br> 2014-03-17 14:59:42::DEBUG::common_utils::967::root:: output =3D <br>2014-0= 3-17 14:59:43::DEBUG::common_utils::968::root:: stderr =3D Redirecting to /= bin/systemctl start postgresql.service<br><div><br></div>2014-03-17 1= 4:59:43::DEBUG::common_utils::969::root:: retcode =3D 0<br> 2014-03-17 14:59:43::DEBUG::common_utils::1460::root:: starting runPostgres= SuQuery database: template1 query: "select 1;"<br>2014-03-17 14:59:43::DEBU= G::common_utils::912::root:: Executing command --> '/bin/su -l postgres = -c /usr/bin/psql -U postgres -d template1 -tA -c "select 1;"' in working di= rectory '/var/lib/<br> pgsql/data'<br>2014-03-17 14:59:43::DEBUG::common_utils::967::root:: output= =3D <br>2014-03-17 14:59:43::DEBUG::common_utils::968::root:: stderr =3D P= assword for user postgres: <br>psql: fe_sendauth: no password supplied<br> <br>2014-03-17 14:59:43::DEBUG::common_utils::969::root:: retcode =3D 2<br>= 2014-03-17 14:59:45::DEBUG::common_utils::1460::root:: starting runPostgres= SuQuery database: template1 query: "select 1;"<br>2014-03-17 14:59:45::DEBU= G::common_utils::912::root:: Executing command --> '/bin/su -l postgres = -c /usr/bin/psql -U postgres -d template1 -tA -c "select 1;"' in working di= rectory '/var/lib/<br> pgsql/data'<br>2014-03-17 14:59:45::DEBUG::common_utils::967::root:: output= =3D <br>2014-03-17 14:59:45::DEBUG::common_utils::968::root:: stderr =3D P= assword for user postgres: <br>psql: fe_sendauth: no password supplied<br> <br>2014-03-17 14:59:45::DEBUG::common_utils::969::root:: retcode =3D 2<br>= 2014-03-17 14:59:47::DEBUG::common_utils::1460::root:: starting runPostgres= SuQuery database: template1 query: "select 1;"<br>2014-03-17 14:59:47::DEBU= G::common_utils::912::root:: Executing command --> '/bin/su -l postgres = -c /usr/bin/psql -U postgres -d template1 -tA -c "select 1;"' in working di= rectory '/var/lib/<br> pgsql/data'<br>2014-03-17 14:59:47::DEBUG::common_utils::967::root:: output= =3D <br>2014-03-17 14:59:47::DEBUG::common_utils::968::root:: stderr =3D P= assword for user postgres: <br>psql: fe_sendauth: no password supplied<br> <br>2014-03-17 14:59:47::DEBUG::common_utils::969::root:: retcode =3D 2<br>= 2014-03-17 14:59:49::DEBUG::common_utils::1460::root:: starting runPostgres= SuQuery database: template1 query: "select 1;"<br>2014-03-17 14:59:49::DEBU= G::common_utils::912::root:: Executing command --> '/bin/su -l postgres = -c /usr/bin/psql -U postgres -d template1 -tA -c "select 1;"' in working di= rectory '/var/lib/<br> pgsql/data'<br>2014-03-17 14:59:49::DEBUG::common_utils::967::root:: output= =3D <br>2014-03-17 14:59:49::DEBUG::common_utils::968::root:: stderr =3D P= assword for user postgres: <br>psql: fe_sendauth: no password supplied<br> <br>2014-03-17 14:59:49::DEBUG::common_utils::969::root:: retcode =3D 2<br>= 2014-03-17 14:59:51::DEBUG::common_utils::1460::root:: starting runPostgres= SuQuery database: template1 query: "select 1;"<br>2014-03-17 14:59:51::DEBU= G::common_utils::912::root:: Executing command --> '/bin/su -l postgres = -c /usr/bin/psql -U postgres -d template1 -tA -c "select 1;"' in working di= rectory '/var/lib/<br> pgsql/data'<br>2014-03-17 14:59:52::DEBUG::common_utils::967::root:: output= =3D <br>2014-03-17 14:59:52::DEBUG::common_utils::968::root:: stderr =3D P= assword for user postgres: <br>psql: fe_sendauth: no password supplied<br> <br>2014-03-17 14:59:52::DEBUG::common_utils::969::root:: retcode =3D 2<br>= 2014-03-17 14:59:54::ERROR::ovirt-engine-dwh-setup::716::root:: Exception c= aught!<br>2014-03-17 14:59:54::ERROR::ovirt-engine-dwh-setup::717::root:: T= raceback (most recent call last):<br> File "/usr/bin/ovirt-engine-dwh-setup", line 474, in main<br> &= nbsp; pg_updated =3D utils.configHbaIdent()<br> File "/usr/shar= e/ovirt-engine-dwh/common_utils.py", line 1431, in configHbaIdent<br> = restartPostgres(newval=3D=3D'md5')<br> File "/usr/share/ovirt-engine-dwh/common_utils.py", line 887, in res= tartPostgres<br> startPostgres()<br> File "/usr/sha= re/ovirt-engine-dwh/common_utils.py", line 556, in startPostgres<br> &= nbsp; 'Error: postgresql service couldn\'t be started. Stopping.'<br> RuntimeError: Error: postgresql service couldn't be started. Stopping.<br><= div><br></div></div></div></div> <br>_______________________________________________<br>Users mailing list<b= r>Users@ovirt.org<br>http://lists.ovirt.org/mailman/listinfo/users<br></blo= ckquote><div><br></div></div></body></html> ------=_Part_3235556_619001005.1395257716060--