Re: [Users] ovirtmgmt vs eth0 config in all-in-one config

2012-12-29 Thread Alon Bar-Lev


- Original Message -
 From: Gianluca Cecchi gianluca.cec...@gmail.com
 To: users users@ovirt.org
 Sent: Saturday, December 29, 2012 2:40:37 AM
 Subject: [Users] ovirtmgmt vs eth0 config in all-in-one config
 
 
 
 
 Hello,
 
 what should be the difference between ovirtmgmt and eth0 in an
 all-in-one config?
 
 
 In my case I have this situation as soon as the server starts, after
 adding the host to local_cluster and reboot
 
 $ diff ifcfg-eth0 ifcfg-ovirtmgmt
 1c1
  DEVICE=eth0
 ---
  DEVICE=ovirtmgmt
 3,4c3,5
  HWADDR=52:54:00:b0:6c:5f
  BRIDGE=ovirtmgmt
 ---
  TYPE=Bridge
  DELAY=0
  BOOTPROTO=none
 
 
 In particular, both config files have lines with the ip/default gw
 
 $ cat ifcfg-eth0
 DEVICE=eth0
 ONBOOT=yes
 HWADDR=52:54:00:b0:6c:5f
 BRIDGE=ovirtmgmt
 NM_CONTROLLED=no
 IPV6INIT=no
 IPADDR0=192.168.122.160
 DNS1=192.168.122.1
 PREFIX0=24
 DEFROUTE=yes
 IPV4_FAILURE_FATAL=no
 GATEWAY0=192.168.122.1
 UUID=09d17057-618e-464a-b38c-e16ab0d72f75
 
 $ cat ifcfg-ovirtmgmt
 DEVICE=ovirtmgmt
 ONBOOT=yes
 TYPE=Bridge
 DELAY=0
 BOOTPROTO=none
 NM_CONTROLLED=no
 IPV6INIT=no
 IPADDR0=192.168.122.160
 DNS1=192.168.122.1
 PREFIX0=24
 DEFROUTE=yes
 IPV4_FAILURE_FATAL=no
 GATEWAY0=192.168.122.1
 UUID=09d17057-618e-464a-b38c-e16ab0d72f75
 
 I think only the bridge should have them correct?
 
 $ ip route list
 169.254.0.0/16 dev ovirtmgmt scope link metric 1003
 192.168.122.0/24 dev ovirtmgmt proto kernel scope link src
 192.168.122.160
 
 
 All returns ok if I manually set it after boot
 # ip route add default via 192.168.122.1

eth0 should not have ip address in this configuration.
Can you please send deploy logs from /var/log/ovirt-engine/host-deploy?

Alon
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [Users] how to update db to manage cpu_threads addition?

2012-12-29 Thread Doron Fediuck


- Original Message -


From: Gianluca Cecchi gianluca.cec...@gmail.com 
To: users users@ovirt.org 
Sent: Saturday, December 29, 2012 3:12:45 AM 
Subject: [Users] how to update db to manage cpu_threads addition? 









Passing from 
ovirt-engine-3.2.0-1.20121217.git1e01c00.fc18.noarch 

to 
ovirt-engine-3.2.0-1.20121227.git00a873e.fc18.noarch 

The engine doesn't start any more 
I see this in server.log 
2012-12-29 01:23:21,496 ERROR [org.jboss.msc.service.fail] (MSC service thread 
1-2) MSC01: Failed to sta 
rt service 
jboss.deployment.subunit.engine.ear.engine-bll.jar.component.InitBackendServicesOnStartupBean
 
.START: org.jboss.msc.service.StartException in service 
jboss.deployment.subunit.engine.ear.engine-bll.ja 
r.component.InitBackendServicesOnStartupBean.START: Failed to start service 
at 
org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1767)
 [jboss 
-msc.jar: 1.0.2.GA ] 
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) 
[rt.jar:1.7.0_09- 
icedtea] 
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) 
[rt.jar:1.7.0_09- 
icedtea] 
at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_09-icedtea] 
Caused by: java.lang.IllegalStateException: JBAS011048: Failed to construct 
component instance 
at 
org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:163)
 
at 
org.jboss.as.ee.component.BasicComponent.createInstance(BasicComponent.java:85) 
at 
org.jboss.as.ejb3.component.singleton.SingletonComponent.getComponentInstance(SingletonComponent.java:116)
 
at 
org.jboss.as.ejb3.component.singleton.SingletonComponent.start(SingletonComponent.java:130)
 
at 
org.jboss.as.ee.component.ComponentStartService.start(ComponentStartService.java:44)
 
at 
org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:181
 
1) [jboss-msc.jar: 1.0.2.GA ] 
at 
org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746)
 [jboss-msc.jar: 1.0.2.GA ] 
... 3 more 
Caused by: javax.ejb.EJBException: 
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad 
SQL grammar [select * from getallfromvds(?, ?)]; nested exception is 
org.postgresql.util.PSQLException: The column name cpu_threads was not found in 
this ResultSet. 

I presume it is this change about cpu_threads column addition in DB: 
http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=commitdiff;h=9a2e7bc6f6dc454d8a049ff22b0f86820b7d4da0
 

or something around it... 

How can I update my db after updating my ovirt-engine rpm? 

I see upgrade.sh in /usr/share/ovirt-engine/dbscripts, provided by the 
ovirt-engine-dbscripts rpm but I don't know how to correctly use it... 

Thanks. 
Gianluca 









Hi Gianluca, 
In development setup we use the upgrade.sh for such situations. 
My suggestion to you is to do a full backup of your DB (engine), so if 
something goes 
wrong you can always revert to the backup. 

Backup to a file called mybackup may be created by: 
- cd to /usr/share/ovirt-engine/dbscripts 
- ./backup.sh -u postgres -f mybackup 

Next, cd to /usr/share/ovirt-engine/dbscripts (if not already there) and run 
the upgrade script. 
If all goes well is should look like this: 
=== 
[doronf@doronf-laptop dbscripts (master)]$ ./upgrade.sh -u postgres 
upgrade script detected a change in Config, View or Stored Procedure... 
Running upgrade sql script upgrade/pre_upgrade/_config.sql ... 
Running upgrade sql script upgrade/pre_upgrade/0010_custom.sql ... 
Running upgrade sql script 
upgrade/pre_upgrade/0020_add_comment_col_to_schema_version.sql ... 
Running upgrade sql script upgrade/03_01_1430_extend_host_mac_address_size.sql 
... 
 

blockquote








/blockquote
Running upgrade sql script upgrade/03_02_0100_add_cpu_thread_columns.sql ... 
. 
Running upgrade sql script 
upgrade/post_upgrade/0010_add_object_column_white_list_table.sql ... 
Done. 
=== 

Just in case you ever wish to use the backupfile, us this procedure: 
- cd to /usr/share/ovirt-engine/dbscripts 
- ./restore.sh -u postgres -f mybackup -r 

Doron 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [Users] how to update db to manage cpu_threads addition?

2012-12-29 Thread Gianluca Cecchi
On Sat, Dec 29, 2012 at 9:45 AM, Doron Fediuck wrote:



 --

 Hi Gianluca,
 In development setup we use the upgrade.sh for such situations.



Hi Doron,
thanks. It seems it worked for updating db structure, but now I get this
kind of error at startup of engine

2012-12-29 10:50:25,433 ERROR [org.jboss.msc.service.fail] (MSC service
thread 1-2) MSC01: Failed to
 start service
jboss.deployment.subunit.engine.ear.engine-bll.jar.component.InitBackendServicesOnSta
rtupBean.START: org.jboss.msc.service.StartException in service
jboss.deployment.subunit.engine.ear.e
ngine-bll.jar.component.InitBackendServicesOnStartupBean.START: Failed to
start service
at
org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1767)
[j
boss-msc.jar:1.0.2.GA]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
[rt.jar:1.7.0
_09-icedtea]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
[rt.jar:1.7.0
_09-icedtea]
at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_09-icedtea]
Caused by: java.lang.IllegalStateException: JBAS011048: Failed to construct
component instance
at
org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:163)
at
org.jboss.as.ee.component.BasicComponent.createInstance(BasicComponent.java:85)
at
org.jboss.as.ejb3.component.singleton.SingletonComponent.getComponentInstance(SingletonComponent.java:116)
at
org.jboss.as.ejb3.component.singleton.SingletonComponent.start(SingletonComponent.java:130)
at
org.jboss.as.ee.component.ComponentStartService.start(ComponentStartService.java:44)
at
org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java
:1811) [jboss-msc.jar:1.0.2.GA]
at
org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746)
[jboss-msc.jar:1.0.2.GA]
... 3 more
Caused by: javax.ejb.EJBException:
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback;
bad SQL grammar [select * from  getallfromvds(?, ?)]; nested exception is
org.postgresql.util.PSQLException: ERROR: permission denied for relation vds
  Where: PL/pgSQL function getallfromvds(uuid,boolean) line 4 at RETURN
QUERY
at
org.jboss.as.ejb3.tx.CMTTxInterceptor.handleExceptionInOurTx(CMTTxInterceptor.java:166)
at
org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:230)
at
org.jboss.as.ejb3.tx.CMTTxInterceptor.requiresNew(CMTTxInterceptor.java:333)
at
org.jboss.as.ejb3.tx.SingletonLifecycleCMTTxInterceptor.processInvocation(SingletonLifecycleCMTTxInterceptor.java:56)
at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
at
org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
at
org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)
at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
at
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
at
org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:161)
... 9 more
Caused by: org.springframework.jdbc.BadSqlGrammarException:
PreparedStatementCallback; bad SQL grammar [select * from  getallfromvds(?,
?)]; nested exception is org.postgresql.util.PSQLException: ERROR:
permission denied for relation vds
  Where: PL/pgSQL function getallfromvds(uuid,boolean) line 4 at RETURN
QUERY
at
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:706)
at
org.ovirt.engine.core.dal.dbbroker.PostgresDbEngineDialect$PostgresSimpleJdbcCall.executeCallInternal(PostgresDbEngineDialect.java:155)
...

Possibly there is a missing grant in update scripts related to the impacted
object vds?
BTW: I executed the upgrade.sh script as root. Donna if this can 

Re: [Users] ovirtmgmt vs eth0 config in all-in-one config

2012-12-29 Thread Gianluca Cecchi
On Sat, Dec 29, 2012 at 9:01 AM, Alon Bar-Lev  wrote:



 eth0 should not have ip address in this configuration.
 Can you please send deploy logs from /var/log/ovirt-engine/host-deploy?

 Alon


This is the timestamp of the files:

[root@f18aio network-scripts]# ll ifcfg*
-rw-rw-r--. 1 root root 248 Dec 18 13:02 ifcfg-eth0
-rw-r--r--. 1 root root 254 Dec  7 22:05 ifcfg-lo
-rw-rw-r--. 1 root root 246 Dec 18 13:02 ifcfg-ovirtmgmt

ANd this is the file related to the timestamp of deploy I think
https://docs.google.com/open?id=0BwoPbcrMv8mvRGdVSVNYa2dXSE0

Let me know if you need more info
Gianluca
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [Users] how to update db to manage cpu_threads addition?

2012-12-29 Thread Doron Fediuck
- Original Message -

 From: Gianluca Cecchi gianluca.cec...@gmail.com
 To: Doron Fediuck dfedi...@redhat.com
 Cc: users users@ovirt.org
 Sent: Saturday, December 29, 2012 12:06:39 PM
 Subject: Re: [Users] how to update db to manage cpu_threads addition?

 On Sat, Dec 29, 2012 at 9:45 AM, Doron Fediuck wrote:

  Hi Gianluca,
 
  In development setup we use the upgrade.sh for such situations.
 

 Hi Doron,

 thanks. It seems it worked for updating db structure, but now I get
 this kind of error at startup of engine

 2012-12-29 10:50:25,433 ERROR [org.jboss.msc.service.fail] (MSC
 service thread 1-2) MSC01: Failed to
 start service
 jboss.deployment.subunit.engine.ear.engine-bll.jar.component.InitBackendServicesOnSta
 rtupBean.START: org.jboss.msc.service.StartException in service
 jboss.deployment.subunit.engine.ear.e
 ngine-bll.jar.component.InitBackendServicesOnStartupBean.START:
 Failed to start service
 at
 org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1767)
 [j
 boss-msc.jar: 1.0.2.GA ]
 at
 java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
 [rt.jar:1.7.0
 _09-icedtea]
 at
 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
 [rt.jar:1.7.0
 _09-icedtea]
 at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_09-icedtea]
 Caused by: java.lang.IllegalStateException: JBAS011048: Failed to
 construct component instance
 at
 org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:163)
 at
 org.jboss.as.ee.component.BasicComponent.createInstance(BasicComponent.java:85)
 at
 org.jboss.as.ejb3.component.singleton.SingletonComponent.getComponentInstance(SingletonComponent.java:116)
 at
 org.jboss.as.ejb3.component.singleton.SingletonComponent.start(SingletonComponent.java:130)
 at
 org.jboss.as.ee.component.ComponentStartService.start(ComponentStartService.java:44)
 at
 org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java
 :1811) [jboss-msc.jar: 1.0.2.GA ]
 at
 org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746)
 [jboss-msc.jar: 1.0.2.GA ]
 ... 3 more
 Caused by: javax.ejb.EJBException:
 org.springframework.jdbc.BadSqlGrammarException:
 PreparedStatementCallback; bad SQL grammar [select * from
 getallfromvds(?, ?)]; nested exception is
 org.postgresql.util.PSQLException: ERROR: permission denied for
 relation vds
 Where: PL/pgSQL function getallfromvds(uuid,boolean) line 4 at RETURN
 QUERY
 at
 org.jboss.as.ejb3.tx.CMTTxInterceptor.handleExceptionInOurTx(CMTTxInterceptor.java:166)
 at
 org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:230)
 at
 org.jboss.as.ejb3.tx.CMTTxInterceptor.requiresNew(CMTTxInterceptor.java:333)
 at
 org.jboss.as.ejb3.tx.SingletonLifecycleCMTTxInterceptor.processInvocation(SingletonLifecycleCMTTxInterceptor.java:56)
 at
 org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
 at
 org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
 at
 org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
 at
 org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)
 at
 org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
 at
 org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
 at
 org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:161)
 ... 9 more
 Caused by: org.springframework.jdbc.BadSqlGrammarException:
 PreparedStatementCallback; bad SQL grammar [select * from
 getallfromvds(?, ?)]; nested exception is
 org.postgresql.util.PSQLException: ERROR: permission denied for
 relation vds
 Where: PL/pgSQL function getallfromvds(uuid,boolean) line 4 at RETURN
 QUERY
 at
 org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)
 at
 org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
 at
 org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
 at
 org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
 at
 org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)
 at
 org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
 at
 org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
 at
 org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:706)
 at
 org.ovirt.engine.core.dal.dbbroker.PostgresDbEngineDialect$PostgresSimpleJdbcCall.executeCallInternal(PostgresDbEngineDialect.java:155)
 ...

 Possibly there is a missing grant in update scripts related to the
 impacted 

Re: [Users] how to update db to manage cpu_threads addition?

2012-12-29 Thread Gianluca Cecchi
On Sat, Dec 29, 2012 at 11:31 AM, Doron Fediuck  wrote:

 Gianluca,
 If you changed your defaults during the installation, then possibly
 grant needed for the user you chose. Otherwise, DB administration
 is done using postgres user, and normal usage is dine via the engine user.

 Try the same with 'engine' db user (or a different one based on your
 installation),
 and see if grant needed to repair it.

 Doron


During setup I didn't change any default for db
I don't remember to be asked about an user named engine...
In any case
[root@f18aio network-scripts]# su - postgres
-bash-4.2$ psql engine engine
Password for user engine:
(the one I chose during setup)
psql (9.2.2)
Type help for help.

engine= select * from vds;
ERROR:  permission denied for relation vds

engine= \d
 public | action_version_map| table| engine
 public | ad_groups | table| engine
...
 public | vds   | view |
postgres
...
 public | vm_statistics | table| engine
...
 public | vms   | view |
postgres
 public | vms_for_disk_view | view |
postgres
 public | vms_with_plug_info| view |
postgres
 public | vms_with_tags | view |
postgres

engine= select count(*) from vm_statistics;
 1

engine= select count(*) from vms;
ERROR:  permission denied for relation vms

Is it correct that all the views are owned by posgres and it seems engine
user has no access to them...?

Gianluca
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [Users] how to update db to manage cpu_threads addition?

2012-12-29 Thread Gianluca Cecchi
On Sat, Dec 29, 2012 at 12:06 PM, Gianluca Cecchi gianluca.cec...@gmail.com
 wrote:


 On Sat, Dec 29, 2012 at 11:31 AM, Doron Fediuck  wrote:

 Gianluca,
 If you changed your defaults during the installation, then possibly
 grant needed for the user you chose. Otherwise, DB administration
 is done using postgres user, and normal usage is dine via the engine user.

 Try the same with 'engine' db user (or a different one based on your
 installation),
 and see if grant needed to repair it.

 Doron


 During setup I didn't change any default for db
 I don't remember to be asked about an user named engine...
 In any case
 [root@f18aio network-scripts]# su - postgres
 -bash-4.2$ psql engine engine
 Password for user engine:
 (the one I chose during setup)
 psql (9.2.2)
 Type help for help.

 engine= select * from vds;

 ERROR:  permission denied for relation vds

 engine= \d
  public | action_version_map| table| engine
  public | ad_groups | table| engine
 ...
  public | vds   | view |
 postgres
 ...
  public | vm_statistics | table| engine
 ...
  public | vms   | view |
 postgres
  public | vms_for_disk_view | view |
 postgres
  public | vms_with_plug_info| view |
 postgres
  public | vms_with_tags | view |
 postgres

 engine= select count(*) from vm_statistics;
  1

 engine= select count(*) from vms;
 ERROR:  permission denied for relation vms

 Is it correct that all the views are owned by posgres and it seems
 engine user has no access to them...?

 Gianluca


As in upgrade.sh script there is first drop and then create of views, in my
opinion in create_views.sql script it should be, after each create or
replace view statement, also the statement such as

ALTER TABLE public.vds OWNER TO engine;

As I find in my backup dump:

-- TOC entry 288 (class 1259 OID 54328)
-- Name: vds; Type: VIEW; Schema: public; Owner: engine
--

CREATE VIEW vds AS
SELECT vds_groups.vds_group_id, vds_groups.name AS vds_group_name,
vds_groups.description AS vds_group_description,
vds_groups.selection_algorithm, vds_static.vds_id, vds_static.vds_name,
vds_static.ip, vds_static.vds_unique_id, vds_static.host_name,
vds_static.port, vds_static.vds_strength, vds_static.server_ssl_enabled,
vds_static.vds_type, vds_static.pm_type, vds_static.pm_user,
vds_static.pm_password, vds_static.pm_port, vds_static.pm_options,
vds_static.pm_enabled, vds_static.vds_spm_priority, vds_dynamic.hooks,
vds_dynamic.status, vds_dynamic.cpu_cores, vds_dynamic.cpu_model,
vds_dynamic.cpu_speed_mh, vds_dynamic.if_total_speed,
vds_dynamic.kvm_enabled, vds_dynamic.physical_mem_mb,
vds_dynamic.pending_vcpus_count, vds_dynamic.pending_vmem_size,
vds_dynamic.mem_commited, vds_dynamic.vm_active, vds_dynamic.vm_count,
vds_dynamic.vm_migrating, vds_dynamic.vms_cores_count,
vds_dynamic.cpu_over_commit_time_stamp, vds_dynamic.net_config_dirty,
vds_groups.high_utilization, vds_groups.low_utilization,
vds_groups.max_vds_memory_over_commit,
vds_groups.cpu_over_commit_duration_minutes, storage_pool.id AS
storage_pool_id, storage_pool.name AS storage_pool_name,
vds_dynamic.reserved_mem, vds_dynamic.guest_overhead,
vds_dynamic.rpm_version, vds_dynamic.software_version,
vds_dynamic.version_name, vds_dynamic.build_name,
vds_dynamic.previous_status, vds_statistics.cpu_idle,
vds_statistics.cpu_load, vds_statistics.cpu_sys, vds_statistics.cpu_user,
vds_statistics.usage_mem_percent, vds_statistics.usage_cpu_percent,
vds_statistics.usage_network_percent, vds_statistics.mem_available,
vds_statistics.mem_shared, vds_statistics.swap_free,
vds_statistics.swap_total, vds_statistics.ksm_cpu_percent,
vds_statistics.ksm_pages, vds_statistics.ksm_state, vds_dynamic.cpu_flags,
vds_groups.cpu_name AS vds_group_cpu_name, vds_dynamic.cpu_sockets,
vds_spm_id_map.vds_spm_id, vds_static.otp_validity, CASE WHEN
(storage_pool.spm_vds_id = vds_static.vds_id) THEN CASE WHEN
(storage_pool.status = 5) THEN 1 ELSE 2 END ELSE 0 END AS spm_status,
vds_dynamic.supported_cluster_levels, vds_dynamic.supported_engines,
vds_groups.compatibility_version AS vds_group_compatibility_version,
vds_dynamic.host_os, vds_dynamic.kvm_version, vds_dynamic.libvirt_version,
vds_dynamic.spice_version, vds_dynamic.kernel_version,
vds_dynamic.iscsi_initiator_name, vds_dynamic.transparent_hugepages_state,
vds_dynamic.anonymous_hugepages, vds_dynamic.non_operational_reason,
vds_static.recoverable, vds_static.sshkeyfingerprint FROM (vds_groups
JOIN vds_static ON ((vds_groups.vds_group_id = vds_static.vds_group_id)))
JOIN vds_dynamic ON ((vds_static.vds_id = vds_dynamic.vds_id))) JOIN
vds_statistics ON ((vds_static.vds_id = vds_statistics.vds_id))) LEFT JOIN
storage_pool ON ((vds_groups.storage_pool_id = storage_pool.id))) LEFT 

Re: [Users] how to update db to manage cpu_threads addition?

2012-12-29 Thread Joop

Gianluca Cecchi wrote:


On Sat, Dec 29, 2012 at 11:31 AM, Doron Fediuck  wrote:

Gianluca,
If you changed your defaults during the installation, then possibly
grant needed for the user you chose. Otherwise, DB administration
is done using postgres user, and normal usage is dine via the
engine user.

Try the same with 'engine' db user (or a different one based on
your installation),
and see if grant needed to repair it.

Correct way to upgrade is to run engine-upgrade and to follow its 
instructions which are normally:

yum update ovirt-engine-setup
followed by:
engine-upgrade
which will install the remaining packages and run the necessary upgrade 
scripts.

That is how I have been upgrading the 3.2 nightlies YMMV.

Joop


___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [Users] how to update db to manage cpu_threads addition?

2012-12-29 Thread Doron Fediuck
- Original Message -

 From: Gianluca Cecchi gianluca.cec...@gmail.com
 To: Doron Fediuck dfedi...@redhat.com
 Cc: users users@ovirt.org
 Sent: Saturday, December 29, 2012 1:20:32 PM
 Subject: Re: [Users] how to update db to manage cpu_threads addition?

 On Sat, Dec 29, 2012 at 12:06 PM, Gianluca Cecchi 
 gianluca.cec...@gmail.com  wrote:

  On Sat, Dec 29, 2012 at 11:31 AM, Doron Fediuck wrote:
 

   Gianluca,
  
 
   If you changed your defaults during the installation, then
   possibly
  
 
   grant needed for the user you chose. Otherwise, DB administration
  
 
   is done using postgres user, and normal usage is dine via the
   engine
   user.
  
 

   Try the same with 'engine' db user (or a different one based on
   your
   installation),
  
 
   and see if grant needed to repair it.
  
 

   Doron
  
 

  During setup I didn't change any default for db
 
  I don't remember to be asked about an user named engine...
 

  In any case
 

  [root@f18aio network-scripts]# su - postgres
 
  -bash-4.2$ psql engine engine
 
  Password for user engine:
 

  (the one I chose during setup)
 

  psql (9.2.2)
 
  Type help for help.
 

  engine= select * from vds;
 

  ERROR: permission denied for relation vds
 

  engine= \d
 
  public | action_version_map | table | engine
 
  public | ad_groups | table | engine
 
  ...
 
  public | vds | view | postgres
 
  ...
 
  public | vm_statistics | table | engine
 
  ...
 
  public | vms | view | postgres
 
  public | vms_for_disk_view | view | postgres
 
  public | vms_with_plug_info | view | postgres
 
  public | vms_with_tags | view | postgres
 

  engine= select count(*) from vm_statistics;
 
  1
 

  engine= select count(*) from vms;
 
  ERROR: permission denied for relation vms
 

  Is it correct that all the views are owned by posgres and it seems
  engine user has no access to them...?
 

  Gianluca
 

 As in upgrade.sh script there is first drop and then create of views,
 in my opinion in create_views.sql script it should be, after each
 create or replace view statement, also the statement such as

 ALTER TABLE public.vds OWNER TO engine;

 As I find in my backup dump:

 -- TOC entry 288 (class 1259 OID 54328)
 -- Name: vds; Type: VIEW; Schema: public; Owner: engine
 --

 CREATE VIEW vds AS
 SELECT vds_groups.vds_group_id, vds_groups.name AS vds_group_name,
 vds_groups.description AS vds_group_description,
 vds_groups.selection_algorithm, vds_static.vds_id,
 vds_static.vds_name, vds_static.ip, vds_static.vds_unique_id,
 vds_static.host_name, vds_static.port, vds_static.vds_strength,
 vds_static.server_ssl_enabled, vds_static.vds_type,
 vds_static.pm_type, vds_static.pm_user, vds_static.pm_password,
 vds_static.pm_port, vds_static.pm_options, vds_static.pm_enabled,
 vds_static.vds_spm_priority, vds_dynamic.hooks, vds_dynamic.status,
 vds_dynamic.cpu_cores, vds_dynamic.cpu_model,
 vds_dynamic.cpu_speed_mh, vds_dynamic.if_total_speed,
 vds_dynamic.kvm_enabled, vds_dynamic.physical_mem_mb,
 vds_dynamic.pending_vcpus_count, vds_dynamic.pending_vmem_size,
 vds_dynamic.mem_commited, vds_dynamic.vm_active,
 vds_dynamic.vm_count, vds_dynamic.vm_migrating,
 vds_dynamic.vms_cores_count, vds_dynamic.cpu_over_commit_time_stamp,
 vds_dynamic.net_config_dirty, vds_groups.high_utilization,
 vds_groups.low_utilization, vds_groups.max_vds_memory_over_commit,
 vds_groups.cpu_over_commit_duration_minutes, storage_pool.id AS
 storage_pool_id, storage_pool.name AS storage_pool_name,
 vds_dynamic.reserved_mem, vds_dynamic.guest_overhead,
 vds_dynamic.rpm_version, vds_dynamic.software_version,
 vds_dynamic.version_name, vds_dynamic.build_name,
 vds_dynamic.previous_status, vds_statistics.cpu_idle,
 vds_statistics.cpu_load, vds_statistics.cpu_sys,
 vds_statistics.cpu_user, vds_statistics.usage_mem_percent,
 vds_statistics.usage_cpu_percent,
 vds_statistics.usage_network_percent, vds_statistics.mem_available,
 vds_statistics.mem_shared, vds_statistics.swap_free,
 vds_statistics.swap_total, vds_statistics.ksm_cpu_percent,
 vds_statistics.ksm_pages, vds_statistics.ksm_state,
 vds_dynamic.cpu_flags, vds_groups.cpu_name AS vds_group_cpu_name,
 vds_dynamic.cpu_sockets, vds_spm_id_map.vds_spm_id,
 vds_static.otp_validity, CASE WHEN (storage_pool.spm_vds_id =
 vds_static.vds_id) THEN CASE WHEN (storage_pool.status = 5) THEN 1
 ELSE 2 END ELSE 0 END AS spm_status,
 vds_dynamic.supported_cluster_levels, vds_dynamic.supported_engines,
 vds_groups.compatibility_version AS vds_group_compatibility_version,
 vds_dynamic.host_os, vds_dynamic.kvm_version,
 vds_dynamic.libvirt_version, vds_dynamic.spice_version,
 vds_dynamic.kernel_version, vds_dynamic.iscsi_initiator_name,
 vds_dynamic.transparent_hugepages_state,
 vds_dynamic.anonymous_hugepages, vds_dynamic.non_operational_reason,
 vds_static.recoverable, vds_static.sshkeyfingerprint FROM
 (vds_groups JOIN vds_static ON ((vds_groups.vds_group_id =
 vds_static.vds_group_id))) JOIN vds_dynamic ON ((vds_static.vds_id =
 

Re: [Users] how to update db to manage cpu_threads addition?

2012-12-29 Thread Gianluca Cecchi
On Sat, Dec 29, 2012 at 3:38 PM, Doron Fediuck wrote:


 --
 Gianluca,
 If not fixed by now, you can revert to the backup you created,
 and then use engine-upgrade. This may pull-in a few more
 updates as needed.


Thanks all, Joop and Doron,
I restored my backup and applied  engine-upgrade and I verified that the
engine db user can now access the vds view and other objects.
I can also open the web admin portal.
I have now the problem that cannot activate the local_host host as it seems
there is a problem with the iso domain (/ISO directory in my case)

in engine.log I have

2012-12-29 17:44:27,791 INFO
[org.ovirt.engine.core.vdsbroker.vdsbroker.ConnectStorageServerVDSCommand]
(QuartzScheduler_Worker-31) [2f1d08
82] FINISH, ConnectStorageServerVDSCommand, return:
{05768b08-b012-4539-a6c1-a63bd68386b1=100}, log id: 1a14fd77
2012-12-29 17:44:27,802 ERROR
[org.ovirt.engine.core.bll.storage.NFSStorageHelper]
(QuartzScheduler_Worker-31) [2f1d0882] The connection wit
h details f18aio:/ISO failed because of error code 100 and error message
is: general exception
2012-12-29 17:44:27,803 INFO
[org.ovirt.engine.core.bll.storage.ConnectHostToStoragePoolServersCommand]
(QuartzScheduler_Worker-31) [2f1d08
82] Host local_host storage connection was failed
2012-12-29 17:44:27,803 INFO
[org.ovirt.engine.core.bll.storage.ConnectHostToStoragePoolServersCommand]
(QuartzScheduler_Worker-31) [2f1d08
82] Failed to connect host local_host to StoragePool local_datacenter Iso
domain/s connections
2012-12-29 17:44:27,836 INFO
[org.ovirt.engine.core.vdsbroker.vdsbroker.ConnectStoragePoolVDSCommand]
(QuartzScheduler_Worker-31) [2f1d0882
] START, ConnectStoragePoolVDSCommand(HostName = local_host, HostId =
6ae6e471-d46b-48f5-8b0f-6f5cc20b251e, storagePoolId = 5f21aa71-a2bd-48
88-9320-9ccc754956e5, vds_spm_id = 1, masterDomainId =
fa71cbcb-97c8-43d7-ace1-44cb343814c0, masterVersion = 1), log id: 4105d340
2012-12-29 17:44:31,102 INFO
[org.ovirt.engine.core.vdsbroker.vdsbroker.ConnectStoragePoolVDSCommand]
(QuartzScheduler_Worker-31) [2f1d0882] FINISH,
ConnectStoragePoolVDSCommand, log id: 4105d340
2012-12-29 17:44:31,168 ERROR
[org.ovirt.engine.core.vdsbroker.irsbroker.IrsBrokerCommand]
(QuartzScheduler_Worker-31) [2f1d0882] Domain
1e0d2036-d410-47ea-9e6e-6b733609db88:ISO was reported with error code 358
2012-12-29 17:44:31,169 ERROR
[org.ovirt.engine.core.bll.InitVdsOnUpCommand] (QuartzScheduler_Worker-31)
[2f1d0882] One of the Storage Domains of host local_host in pool
local_datacenter is problematic


[root@f18aio ovirt-engine]# exportfs -v
/ISO  0.0.0.0/0.0.0.0(rw,wdelay,root_squash,no_subtree_check)

[root@f18aio ovirt-engine]# getenforce
Permissive

Last time I see accessed the /ISO before upgrade in engine.log:
2012-12-21 17:24:45,810 INFO
[org.ovirt.engine.core.bll.IsoDomainListSyncronizer] (pool-3-thread-50)
Finished automatic refresh process for
 ISO file type with success, for storage domain id
1e0d2036-d410-47ea-9e6e-6b733609db88.

My full engine.log here:
https://docs.google.com/open?id=0BwoPbcrMv8mvTEtaRzVOYUNiMDQ

Gianluca
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [Users] ovirtmgmt vs eth0 config in all-in-one config

2012-12-29 Thread Gianluca Cecchi
On Sat, Dec 29, 2012 at 11:18 AM, Gianluca Cecchi wrote:


 On Sat, Dec 29, 2012 at 9:01 AM, Alon Bar-Lev  wrote:



 eth0 should not have ip address in this configuration.
 Can you please send deploy logs from /var/log/ovirt-engine/host-deploy?

 Alon


 This is the timestamp of the files:

 [root@f18aio network-scripts]# ll ifcfg*
 -rw-rw-r--. 1 root root 248 Dec 18 13:02 ifcfg-eth0
 -rw-r--r--. 1 root root 254 Dec  7 22:05 ifcfg-lo
 -rw-rw-r--. 1 root root 246 Dec 18 13:02 ifcfg-ovirtmgmt

 ANd this is the file related to the timestamp of deploy I think
 https://docs.google.com/open?id=0BwoPbcrMv8mvRGdVSVNYa2dXSE0

 Let me know if you need more info
 Gianluca


BTW: after removing ip information from ifcfg-eth0 I still have to manually
run

ip route add default via 192.168.122.1

Now ifcfg-eth0 contains

sys-devices-virtual-net-\x3bvdsmdummy\x3b.deviceloaded active
plugged   /sys/devices/virtual/net/;vdsmdummy;
sys-devices-virtual-net-bond0.deviceloaded active
plugged   /sys/devices/virtual/net/bond0
sys-devices-virtual-net-bond4.deviceloaded active
plugged   /sys/devices/virtual/net/bond4
sys-devices-virtual-net-ovirtmgmt.deviceloaded active
plugged   /sys/devices/virtual/net/ovirtmgmt
sys-module-configfs.device  loaded active
plugged   /sys/module/configfs
sys-subsystem-net-devices-\x3bvdsmdummy\x3b.device  loaded active
plugged   /sys/subsystem/net/devices/;vdsmdummy;
sys-subsystem-net-devices-bond0.device  loaded active
plugged   /sys/subsystem/net/devices/bond0
sys-subsystem-net-devices-bond4.device  loaded active
plugged   /sys/subsystem/net/devices/bond4
sys-subsystem-net-devices-eth0.device   loaded active
plugged   Virtio network device
sys-subsystem-net-devices-ovirtmgmt.device  loaded active
plugged   /sys/subsystem/net/devices/ovirtmgmt
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [Users] ovirtmgmt vs eth0 config in all-in-one config

2012-12-29 Thread Gianluca Cecchi
Sorry... sent for error before finishing..

BTW: after removing ip information from ifcfg-eth0 I still have to manually
run

ip route add default via 192.168.122.1

Now ifcfg-eth0 contains only

DEVICE=eth0
ONBOOT=yes
HWADDR=52:54:00:b0:6c:5f
BRIDGE=ovirtmgmt
NM_CONTROLLED=no
IPV6INIT=no
IPV4_FAILURE_FATAL=no
UUID=09d17057-618e-464a-b38c-e16ab0d72f75

systemctl list-units gives:

sys-devices-virtual-net-\
x3bvdsmdummy\x3b.deviceloaded active plugged
/sys/devices/virtual/net/;vdsmdummy;
sys-devices-virtual-net-bond0.deviceloaded active
plugged   /sys/devices/virtual/net/bond0
sys-devices-virtual-net-bond4.deviceloaded active
plugged   /sys/devices/virtual/net/bond4
sys-devices-virtual-net-ovirtmgmt.deviceloaded active
plugged   /sys/devices/virtual/net/ovirtmgmt
sys-module-configfs.device  loaded active
plugged   /sys/module/configfs
sys-subsystem-net-devices-\x3bvdsmdummy\x3b.device  loaded active
plugged   /sys/subsystem/net/devices/;vdsmdummy;
sys-subsystem-net-devices-bond0.device  loaded active
plugged   /sys/subsystem/net/devices/bond0
sys-subsystem-net-devices-bond4.device  loaded active
plugged   /sys/subsystem/net/devices/bond4
sys-subsystem-net-devices-eth0.device   loaded active
plugged   Virtio network device
sys-subsystem-net-devices-ovirtmgmt.device  loaded active
plugged   /sys/subsystem/net/devices/ovirtmgmt


# ip addr list
1: lo: LOOPBACK,UP,LOWER_UP mtu 16436 qdisc noqueue state UNKNOWN
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
inet6 ::1/128 scope host
   valid_lft forever preferred_lft forever
2: eth0: BROADCAST,MULTICAST,UP,LOWER_UP mtu 1500 qdisc pfifo_fast master
ovirtmgmt state UP qlen 1000
link/ether 52:54:00:b0:6c:5f brd ff:ff:ff:ff:ff:ff
inet6 fe80::5054:ff:feb0:6c5f/64 scope link
   valid_lft forever preferred_lft forever
3: ovirtmgmt: BROADCAST,MULTICAST,UP,LOWER_UP mtu 1500 qdisc noqueue
state UP
link/ether 52:54:00:b0:6c:5f brd ff:ff:ff:ff:ff:ff
inet 192.168.122.160/24 brd 192.168.122.255 scope global ovirtmgmt
inet6 fe80::5054:ff:feb0:6c5f/64 scope link
   valid_lft forever preferred_lft forever
5: ;vdsmdummy;: BROADCAST,MULTICAST mtu 1500 qdisc noop state DOWN
link/ether f2:96:78:d1:69:74 brd ff:ff:ff:ff:ff:ff
6: bond0: NO-CARRIER,BROADCAST,MULTICAST,MASTER,UP mtu 1500 qdisc noqueue
state DOWN
link/ether 00:00:00:00:00:00 brd ff:ff:ff:ff:ff:ff
7: bond4: NO-CARRIER,BROADCAST,MULTICAST,MASTER,UP mtu 1500 qdisc noqueue
state DOWN
link/ether 00:00:00:00:00:00 brd ff:ff:ff:ff:ff:ff

# cat /proc/net/bonding/bond0
Ethernet Channel Bonding Driver: v3.7.1 (April 27, 2011)

Bonding Mode: load balancing (round-robin)
MII Status: down
MII Polling Interval (ms): 0
Up Delay (ms): 0
Down Delay (ms): 0
[root@f18aio network-scripts]# cat /proc/net/bonding/bond4
Ethernet Channel Bonding Driver: v3.7.1 (April 27, 2011)

Bonding Mode: load balancing (round-robin)
MII Status: down
MII Polling Interval (ms): 0
Up Delay (ms): 0
Down Delay (ms): 0

Don't know from where the bond0 and bond4 arrives and the ;vdsmdummy too..
and their configuration files...

Gianluca
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [Users] ovirtmgmt vs eth0 config in all-in-one config

2012-12-29 Thread Gianluca Cecchi
In the mean time I found that the problem was

GATEWAY0=192.168.122.1

in ifcfg-ovirtmgmt

While it should be
GATEWAY=192.168.122.1

in fact the index is not kept in count for GATEWAY filed
Now with this line and also

NOZEROCONF=yes

I keep ok at boot with
$ ip route list
default via 192.168.122.1 dev ovirtmgmt
192.168.122.0/24 dev ovirtmgmt  proto kernel  scope link  src
192.168.122.160

without manual intervention

Gianluca
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [Users] how to update db to manage cpu_threads addition?

2012-12-29 Thread Doron Fediuck
- Original Message -

 From: Gianluca Cecchi gianluca.cec...@gmail.com
 To: Doron Fediuck dfedi...@redhat.com
 Cc: users users@ovirt.org
 Sent: Saturday, December 29, 2012 6:56:32 PM
 Subject: Re: [Users] how to update db to manage cpu_threads addition?

 On Sat, Dec 29, 2012 at 3:38 PM, Doron Fediuck wrote:

  Gianluca,
 
  If not fixed by now, you can revert to the backup you created,
 
  and then use engine-upgrade. This may pull-in a few more
 
  updates as needed.
 

 Thanks all, Joop and Doron,

 I restored my backup and applied engine-upgrade and I verified that
 the engine db user can now access the vds view and other
 objects.

 I can also open the web admin portal.

 I have now the problem that cannot activate the local_host host as it
 seems there is a problem with the iso domain (/ISO directory in my
 case)

 in engine.log I have

 2012-12-29 17:44:27,791 INFO
 [org.ovirt.engine.core.vdsbroker.vdsbroker.ConnectStorageServerVDSCommand]
 (QuartzScheduler_Worker-31) [2f1d08
 82] FINISH, ConnectStorageServerVDSCommand, return:
 {05768b08-b012-4539-a6c1-a63bd68386b1=100}, log id: 1a14fd77
 2012-12-29 17:44:27,802 ERROR
 [org.ovirt.engine.core.bll.storage.NFSStorageHelper]
 (QuartzScheduler_Worker-31) [2f1d0882] The connection wit
 h details f18aio:/ISO failed because of error code 100 and error
 message is: general exception
 2012-12-29 17:44:27,803 INFO
 [org.ovirt.engine.core.bll.storage.ConnectHostToStoragePoolServersCommand]
 (QuartzScheduler_Worker-31) [2f1d08
 82] Host local_host storage connection was failed
 2012-12-29 17:44:27,803 INFO
 [org.ovirt.engine.core.bll.storage.ConnectHostToStoragePoolServersCommand]
 (QuartzScheduler_Worker-31) [2f1d08
 82] Failed to connect host local_host to StoragePool local_datacenter
 Iso domain/s connections
 2012-12-29 17:44:27,836 INFO
 [org.ovirt.engine.core.vdsbroker.vdsbroker.ConnectStoragePoolVDSCommand]
 (QuartzScheduler_Worker-31) [2f1d0882
 ] START, ConnectStoragePoolVDSCommand(HostName = local_host, HostId =
 6ae6e471-d46b-48f5-8b0f-6f5cc20b251e, storagePoolId =
 5f21aa71-a2bd-48
 88-9320-9ccc754956e5, vds_spm_id = 1, masterDomainId =
 fa71cbcb-97c8-43d7-ace1-44cb343814c0, masterVersion = 1), log id:
 4105d340
 2012-12-29 17:44:31,102 INFO
 [org.ovirt.engine.core.vdsbroker.vdsbroker.ConnectStoragePoolVDSCommand]
 (QuartzScheduler_Worker-31) [2f1d0882] FINISH,
 ConnectStoragePoolVDSCommand, log id: 4105d340
 2012-12-29 17:44:31,168 ERROR
 [org.ovirt.engine.core.vdsbroker.irsbroker.IrsBrokerCommand]
 (QuartzScheduler_Worker-31) [2f1d0882] Domain
 1e0d2036-d410-47ea-9e6e-6b733609db88:ISO was reported with error
 code 358
 2012-12-29 17:44:31,169 ERROR
 [org.ovirt.engine.core.bll.InitVdsOnUpCommand]
 (QuartzScheduler_Worker-31) [2f1d0882] One of the Storage Domains of
 host local_host in pool local_datacenter is problematic

 [root@f18aio ovirt-engine]# exportfs -v
 /ISO 0.0.0.0/0.0.0.0(rw,wdelay,root_squash,no_subtree_check)

 [root@f18aio ovirt-engine]# getenforce
 Permissive

 Last time I see accessed the /ISO before upgrade in engine.log:
 2012-12-21 17:24:45,810 INFO
 [org.ovirt.engine.core.bll.IsoDomainListSyncronizer]
 (pool-3-thread-50) Finished automatic refresh process for
 ISO file type with success, for storage domain id
 1e0d2036-d410-47ea-9e6e-6b733609db88.

 My full engine.log here:
 https://docs.google.com/open?id=0BwoPbcrMv8mvTEtaRzVOYUNiMDQ

 Gianluca

Gianluca, 
Please provide the vdsm log as well. 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [Users] how to update db to manage cpu_threads addition?

2012-12-29 Thread Gianluca Cecchi
On Sat, Dec 29, 2012 at 6:39 PM, Doron Fediuck  wrote:



 Gianluca,
 Please provide the vdsm log as well.


here it is
https://docs.google.com/open?id=0BwoPbcrMv8mvZEtTSTdnd3BFUmc

Why inability to connect to ISO domains prevents my host to become
operational?
Shouldn't it be a warning and not a cause for non operational state?
Gianluca
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [Users] how to update db to manage cpu_threads addition?

2012-12-29 Thread Gianluca Cecchi
On Sat, Dec 29, 2012 at 6:58 PM, Gianluca Cecchi  wrote:


 On Sat, Dec 29, 2012 at 6:39 PM, Doron Fediuck  wrote:



 Gianluca,
 Please provide the vdsm log as well.


 here it is
 https://docs.google.com/open?id=0BwoPbcrMv8mvZEtTSTdnd3BFUmc

 Why inability to connect to ISO domains prevents my host to become
 operational?
 Shouldn't it be a warning and not a cause for non operational state?
 Gianluca


It seems I solved
I had in fact a doubt because I had an incorrect duplication for ISO
definition
See for more information the thread containing this:
http://lists.ovirt.org/pipermail/users/2012-December/011260.html
and its referred image:
https://docs.google.com/open?id=0BwoPbcrMv8mvd0tzMl9mM0NrZkU

I initially had a fear to drop the inexistent ISO so I left it there
Probably after update for some reason it created problems.
So now I destroyed it and reboot the server and now it came again to its
life activating both data domain and iso domain.

It remains my doubt about a problem with an ISO domain causing problems for
the host itself to become operatioal...
Is it by design?

Gianluca
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [Users] ovirtmgmt vs eth0 config in all-in-one config

2012-12-29 Thread Alon Bar-Lev


- Original Message -
 From: Gianluca Cecchi gianluca.cec...@gmail.com
 To: Alon Bar-Lev alo...@redhat.com
 Cc: users users@ovirt.org
 Sent: Saturday, December 29, 2012 7:36:00 PM
 Subject: Re: [Users] ovirtmgmt vs eth0 config in all-in-one config
 
 
 
 
 
 
 In the mean time I found that the problem was
 
 
 GATEWAY0=192.168.122.1
 

But I see that you had GATEWAY0 in your original ifcfg file...
Can you explain more of your setup before you tried to deploy?

---
DEVICE=eth0
BOOTPROTO=none
ONBOOT=yes
UUID=09d17057-618e-464a-b38c-e16ab0d72f75
TYPE=Ethernet
IPADDR0=192.168.122.160
PREFIX0=24
GATEWAY0=192.168.122.1
DNS1=192.168.122.1
DEFROUTE=yes
IPV4_FAILURE_FATAL=no
IPV6INIT=no
NAME=System eth0
HWADDR=52:54:00:B0:6C:5F
---

 in ifcfg-ovirtmgmt
 
 
 While it should be
 
 GATEWAY=192.168.122.1
 
 
 in fact the index is not kept in count for GATEWAY filed
 
 Now with this line and also
 
 
 NOZEROCONF=yes
 
 
 I keep ok at boot with
 $ ip route list
 default via 192.168.122.1 dev ovirtmgmt
 192.168.122.0/24 dev ovirtmgmt proto kernel scope link src
 192.168.122.160
 
 
 without manual intervention
 
 
 Gianluca
 
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [Users] ovirtmgmt vs eth0 config in all-in-one config

2012-12-29 Thread Gianluca Cecchi
Perhaps when I first installed f18, it got those entries and was configured
with network manager and then I only put
NM_CONTROLLED=no
Without changing accordingly its entries...
I have to check default f18 config during install...
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [Users] ovirtmgmt vs eth0 config in all-in-one config

2012-12-29 Thread Alon Bar-Lev


- Original Message -
 From: Gianluca Cecchi gianluca.cec...@gmail.com
 To: Alon Bar-Lev alo...@redhat.com
 Cc: users users@ovirt.org
 Sent: Saturday, December 29, 2012 9:48:07 PM
 Subject: Re: [Users] ovirtmgmt vs eth0 config in all-in-one config
 
 
 
 Perhaps when I first installed f18, it got those entries and was
 configured with network manager and then I only put
 NM_CONTROLLED=no
 Without changing accordingly its entries...
 I have to check default f18 config during install...

Default fedora 18 comes without any ifcfg file.
Network manager is in charge, for the good and for the wrose.
In this case the host deploy will take the most basic settings out of network 
manager as if these were in ifcfg file.

Regards,
Alon 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [Users] ISO domain questions (was: how to update db to manage cpu_threads addition?)

2012-12-29 Thread Doron Fediuck
- Original Message -

 From: Gianluca Cecchi gianluca.cec...@gmail.com
 To: Doron Fediuck dfedi...@redhat.com
 Cc: users users@ovirt.org
 Sent: Saturday, December 29, 2012 8:12:10 PM
 Subject: Re: [Users] how to update db to manage cpu_threads addition?

 On Sat, Dec 29, 2012 at 6:58 PM, Gianluca Cecchi wrote:

  On Sat, Dec 29, 2012 at 6:39 PM, Doron Fediuck wrote:
 

   Gianluca,
  
 
   Please provide the vdsm log as well.
  
 

  here it is
 
  https://docs.google.com/open?id=0BwoPbcrMv8mvZEtTSTdnd3BFUmc
 

  Why inability to connect to ISO domains prevents my host to become
  operational?
 

  Shouldn't it be a warning and not a cause for non operational
  state?
 

  Gianluca
 

 It seems I solved

 I had in fact a doubt because I had an incorrect duplication for ISO
 definition

 See for more information the thread containing this:
 http://lists.ovirt.org/pipermail/users/2012-December/011260.html

 and its referred image:
 https://docs.google.com/open?id=0BwoPbcrMv8mvd0tzMl9mM0NrZkU

 I initially had a fear to drop the inexistent ISO so I left it there

 Probably after update for some reason it created problems.

 So now I destroyed it and reboot the server and now it came again to
 its life activating both data domain and iso domain.

 It remains my doubt about a problem with an ISO domain causing
 problems for the host itself to become operatioal...

 Is it by design?

 Gianluca

Gianluca, 
It seems that you're using an all-in-one setup. 
In which case you cannot have more than one ISO domain on the same host. 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users