Attachment 673304 Details for Bug 892278 – logs

logs

rhevm-dwh-setup-2013_01_06_11_41_07.log (text/x-log), 10.17 KB, created by Kiril Nesenko on 2013-01-06 09:50:45 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kiril Nesenko

Created: 2013-01-06 09:50:45 UTC

Size: 10.17 KB

patch

obsolete

>2013-01-06 11:41:07::DEBUG::ovirt-engine-dwh-setup::225::root:: starting main()
>2013-01-06 11:41:07::DEBUG::common_utils::415::root:: found existing pgpass file, fetching DB host value
>2013-01-06 11:41:07::DEBUG::common_utils::415::root:: found existing pgpass file, fetching DB port value
>2013-01-06 11:41:07::DEBUG::common_utils::415::root:: found existing pgpass file, fetching DB admin value
>2013-01-06 11:41:07::DEBUG::common_utils::415::root:: found existing pgpass file, fetching DB admin value
>2013-01-06 11:41:07::DEBUG::common_utils::448::root:: getting DB password for postgres
>2013-01-06 11:41:07::DEBUG::common_utils::457::root:: found password for username postgres
>2013-01-06 11:41:07::DEBUG::common_utils::58::root:: getting vdc option MinimalETLVersion
>2013-01-06 11:41:07::DEBUG::common_utils::512::root:: Executing command --> '['/usr/bin/engine-config', '-g', 'MinimalETLVersion', '--cver=general', '-p', '/usr/share/ovirt-engine/conf/engine-config-install.properties']'
>2013-01-06 11:41:07::DEBUG::common_utils::551::root:: output = 3.2.0
>
>2013-01-06 11:41:07::DEBUG::common_utils::552::root:: stderr = 
>2013-01-06 11:41:07::DEBUG::common_utils::553::root:: retcode = 0
>2013-01-06 11:41:07::DEBUG::common_utils::61::root:: Value of MinimalETLVersion is 3.2.0
>
>2013-01-06 11:41:07::DEBUG::common_utils::512::root:: Executing command --> '['rpm', '-q', '--queryformat', '%{VERSION}-%{RELEASE}', 'rhevm-dwh']'
>2013-01-06 11:41:07::DEBUG::common_utils::551::root:: output = 3.2.0-2.el6ev
>2013-01-06 11:41:07::DEBUG::common_utils::552::root:: stderr = 
>2013-01-06 11:41:07::DEBUG::common_utils::553::root:: retcode = 0
>2013-01-06 11:41:07::DEBUG::common_utils::347::root:: setting regex (\d+\.\d+)\.(\d+)\-(\d+) againts 3.2.0-2.el6ev
>2013-01-06 11:41:07::DEBUG::common_utils::352::root:: found version, 3.2
>2013-01-06 11:41:07::DEBUG::common_utils::354::root:: found minorVersion 0
>2013-01-06 11:41:07::DEBUG::common_utils::356::root:: found release 2
>2013-01-06 11:41:07::DEBUG::common_utils::347::root:: setting regex (\d+\.\d+)\.(\d+)\-(\d+) againts 3.2.0-0
>2013-01-06 11:41:07::DEBUG::common_utils::352::root:: found version, 3.2
>2013-01-06 11:41:07::DEBUG::common_utils::354::root:: found minorVersion 0
>2013-01-06 11:41:07::DEBUG::common_utils::356::root:: found release 0
>2013-01-06 11:41:07::DEBUG::common_utils::234::root:: checking ovirt-engine service
>2013-01-06 11:41:07::DEBUG::common_utils::222::root:: checking the status of ovirt-engine
>2013-01-06 11:41:07::DEBUG::common_utils::512::root:: Executing command --> '['service', 'ovirt-engine', 'status']'
>2013-01-06 11:41:08::DEBUG::common_utils::551::root:: output = The engine process 3793 is running.
>
>2013-01-06 11:41:08::DEBUG::common_utils::552::root:: stderr = 
>2013-01-06 11:41:08::DEBUG::common_utils::553::root:: retcode = 0
>2013-01-06 11:41:08::DEBUG::common_utils::236::root:: ovirt-engine is up and running
>2013-01-06 11:41:08::DEBUG::common_utils::185::root:: asking user: Would you like to stop the ovirt-engine service? (yes|no): 
>2013-01-06 11:41:09::DEBUG::common_utils::189::root:: user answered: yes
>2013-01-06 11:41:09::DEBUG::decorators::18::root:: running stopEngineService
>2013-01-06 11:41:09::DEBUG::common_utils::248::root:: Stopping ovirt-engine
>2013-01-06 11:41:09::DEBUG::common_utils::512::root:: Executing command --> '['service', 'ovirt-engine', 'stop']'
>2013-01-06 11:41:10::DEBUG::common_utils::551::root:: output = Stopping engine-service:[60G [  [0;32mOK[0;39m  ]
>
>2013-01-06 11:41:10::DEBUG::common_utils::552::root:: stderr = 
>2013-01-06 11:41:10::DEBUG::common_utils::553::root:: retcode = 0
>2013-01-06 11:41:10::DEBUG::common_utils::296::root:: Stopping ovirt-engine-dwhd
>2013-01-06 11:41:10::DEBUG::common_utils::512::root:: Executing command --> '['service', 'ovirt-engine-dwhd', 'stop']'
>2013-01-06 11:41:10::DEBUG::common_utils::551::root:: output = Stopping ovirt-engine-dwhd: [FAILED]
>oVirt ETL Service is currently not running
>
>2013-01-06 11:41:10::DEBUG::common_utils::552::root:: stderr = 
>2013-01-06 11:41:10::DEBUG::common_utils::553::root:: retcode = 0
>2013-01-06 11:41:10::DEBUG::decorators::18::root:: running setDbPass
>2013-01-06 11:41:10::DEBUG::ovirt-engine-dwh-setup::117::root:: Setting DB pass
>2013-01-06 11:41:10::DEBUG::ovirt-engine-dwh-setup::118::root:: editing etl db connectivity file
>2013-01-06 11:41:10::DEBUG::ovirt-engine-dwh-setup::159::root:: reading /etc/sysconfig/ovirt-engine
>2013-01-06 11:41:10::DEBUG::ovirt-engine-dwh-setup::176::root:: Secure web port is: 443
>2013-01-06 11:41:10::DEBUG::ovirt-engine-dwh-setup::180::root:: Host's FQDN: vm-17-111.eng.lab.tlv.redhat.com
>2013-01-06 11:41:10::DEBUG::common_utils::512::root:: Executing command --> '['rpm', '-q', '--queryformat', '%{VERSION}-%{RELEASE}', 'rhevm-dwh']'
>2013-01-06 11:41:10::DEBUG::common_utils::551::root:: output = 3.2.0-2.el6ev
>2013-01-06 11:41:10::DEBUG::common_utils::552::root:: stderr = 
>2013-01-06 11:41:10::DEBUG::common_utils::553::root:: retcode = 0
>2013-01-06 11:41:10::DEBUG::common_utils::347::root:: setting regex (\d+\.\d+)\.(\d+)\-(\d+) againts 3.2.0-2.el6ev
>2013-01-06 11:41:10::DEBUG::common_utils::352::root:: found version, 3.2
>2013-01-06 11:41:10::DEBUG::common_utils::354::root:: found minorVersion 0
>2013-01-06 11:41:10::DEBUG::common_utils::356::root:: found release 2
>2013-01-06 11:41:10::DEBUG::ovirt-engine-dwh-setup::212::root:: Setting etlVersion
>2013-01-06 11:41:10::DEBUG::ovirt-engine-dwh-setup::213::root:: editing etl connectivity file
>2013-01-06 11:41:10::DEBUG::ovirt-engine-dwh-setup::43::root:: checking if ovirt_engine_history db already exists
>2013-01-06 11:41:10::DEBUG::common_utils::204::root:: running sql query on host: localhost, port: 5432, db: ovirt_engine_history, user: postgres, query: 'select 1'.
>2013-01-06 11:41:10::DEBUG::common_utils::512::root:: Executing command --> '['/usr/bin/psql', '--pset=tuples_only=on', '--set', 'ON_ERROR_STOP=1', '--dbname', 'ovirt_engine_history', '--host', 'localhost', '--port', '5432', '--username', 'postgres', '-c', 'select 1']'
>2013-01-06 11:41:10::DEBUG::common_utils::551::root:: output =         1
>
>
>2013-01-06 11:41:10::DEBUG::common_utils::552::root:: stderr = 
>2013-01-06 11:41:10::DEBUG::common_utils::553::root:: retcode = 0
>2013-01-06 11:41:10::DEBUG::decorators::18::root:: running upgradeDB
>2013-01-06 11:41:10::DEBUG::ovirt-engine-dwh-setup::82::root:: upgrading ovirt_engine_history db
>2013-01-06 11:41:10::DEBUG::ovirt-engine-dwh-setup::84::root:: ovirt engine history db upgrade is logged at /var/log/ovirt-engine/ovirt-history-db-upgrade-2013_01_06_11_41_10.log
>2013-01-06 11:41:10::DEBUG::common_utils::512::root:: Executing command --> '['/usr/share/ovirt-engine-dwh/db-scripts/upgrade.sh', '-s', 'localhost', '-p', '5432', '-u', 'postgres', '-d', 'ovirt_engine_history', '-l', '/var/log/ovirt-engine/ovirt-history-db-upgrade-2013_01_06_11_41_10.log']'
>2013-01-06 11:41:11::DEBUG::common_utils::551::root:: output = Skipping upgrade script upgrade/03_00_0020_add_single_aggregate_variable.sql, already installed by  03000020
>Skipping upgrade script upgrade/03_00_0030_add_index_on_biz_entities.sql, already installed by  03000030
>Skipping upgrade script upgrade/03_00_0040_add_disks_info.sql, already installed by  03000040
>Skipping upgrade script upgrade/03_00_0050_add_reports_enum_values.sql, already installed by  03000050
>Skipping upgrade script upgrade/03_00_0060_add_usb_policy_enum_values.sql, already installed by  03000060
>Skipping upgrade script upgrade/03_00_0070_change_last_hourly_init_datetime.sql, already installed by  03000070
>Skipping upgrade script upgrade/03_00_0080_changed_daily_tables_time_column_to_date.sql, already installed by  03000080
>Skipping upgrade script upgrade/03_00_0090_added_host_cpu_config_values.sql, already installed by  03000090
>Skipping upgrade script upgrade/03_00_0100_added_new_periods_enums.sql, already installed by  03000100
>Skipping upgrade script upgrade/03_00_0110_added_vm_disks_config.sql, already installed by  03000110
>Skipping upgrade script upgrade/03_00_0120_added_vm_device_table.sql, already installed by  03000120
>Skipping upgrade script upgrade/03_00_0130_remove_unused_columns.sql, already installed by  03000130
>Skipping upgrade script upgrade/03_00_0140_rename_fqdn_host_column.sql, already installed by  03000140
>Skipping upgrade script upgrade/03_00_0150_extend_host_mac_address_size.sql, already installed by  03000150
>Skipping upgrade script upgrade/03_00_0160_extend_enum_value_length.sql, already installed by  03000160
>Skipping upgrade script upgrade/03_00_0170_add_localized_enum_values.sql, already installed by  03000170
>Skipping upgrade script upgrade/03_02_0010_add_vm_users_usage_tables.sql, already installed by  03020010
>Skipping upgrade script upgrade/03_02_0020_add_storage_domain_status_columns.sql, already installed by  03020020
>Running  upgrade sql script upgrade/pre_upgrade/add_comment_col_to_schema_version.sql ...
>Running  upgrade sql script upgrade/pre_upgrade/set_etl_minimal_version.sql ...
>Running  upgrade sql script upgrade/03_02_0030_drop_auto_suspend_column.sql ...
>
>2013-01-06 11:41:11::DEBUG::common_utils::552::root:: stderr = psql:upgrade/03_02_0030_drop_auto_suspend_column.sql:1: ERROR:  syntax error at or near "EXISTS"
>LINE 1: ALTER TABLE vm_configuration DROP COLUMN IF EXISTS auto_susp...
>                                                    ^
>
>2013-01-06 11:41:11::DEBUG::common_utils::553::root:: retcode = 3
>2013-01-06 11:41:11::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 "/usr/bin/ovirt-engine-dwh-setup", line 98, in upgradeDB
>    output, rc = utils.execCmd(cmdList=cmd, failOnError=True, msg="Error while trying to upgrade %s DB" % DB_NAME)
>  File "/usr/share/ovirt-engine-dwh/common_utils.py", line 556, in execCmd
>    raise Exception(msg)
>Exception: Error while trying to upgrade ovirt_engine_history DB
>
>2013-01-06 11:41:11::ERROR::ovirt-engine-dwh-setup::267::root:: Exception caught!
>2013-01-06 11:41:11::ERROR::ovirt-engine-dwh-setup::268::root:: Traceback (most recent call last):
>  File "/usr/bin/ovirt-engine-dwh-setup", line 249, in main
>    upgradeDB(db_dict)
>  File "/usr/share/ovirt-engine-dwh/decorators.py", line 28, in wrapped_f
>    raise Exception(instance)
>Exception: Error while trying to upgrade ovirt_engine_history DB
>

Actions: View

Attachments on bug 892278: 673304