Re: [ovirt-users] ?==?utf-8?q? Error "Did not connect host to storage domain because connection for connectionId is null" in ovirt 4.1
On Mon, Dec 11, 2017 at 11:32 PM, Claude Durocher < claude.duroc...@cptaq.gouv.qc.ca> wrote: > Replying to myself here: I fixed it by running this insert statement in > the postgresql db to restore the missing connection: > > insert into storage_server_connections (id, connection, portal, > storage_type) values ('b3011e5b-552e-4393-a758-ac1e35648ab1', > '/var/ovirt-lun1', '1', '4'); > OK, but the question is why you lost it. > > > > Le Lundi, Décembre 11, 2017 16:29 EST, "Claude Durocher" < > claude.duroc...@cptaq.gouv.qc.ca> a écrit: > > > > > I have a 4.1 ovirt environment. I cannot reactivate a storage domain > (data-master) and I get an error message stating "connection for > connectionId 'b3011e5b-552e-4393-a758-ac1e35648ab1' is null". I also > cannot delete this storage domain as it's a master domain. > > 2017-12-11 15:25:10,971-05 INFO [org.ovirt.engine.core.bll. > storage.domain.ActivateStorageDomainCommand] (default task-22) > [49dfce30-0e2c-43f8-942d-67a2b56b3ef8] Lock Acquired to object > 'EngineLock:{exclusiveLocks='[5662588b-81d2-4da9-b942-8918004770fe=STORAGE]', > sharedLocks=''}' > 2017-12-11 15:25:10,999-05 INFO [org.ovirt.engine.core.bll. > storage.domain.ActivateStorageDomainCommand] > (org.ovirt.thread.pool-6-thread-50) > [49dfce30-0e2c-43f8-942d-67a2b56b3ef8] Running command: > ActivateStorageDomainCommand internal: false. Entities affected : ID: > 5662588b-81d2-4da9-b942-8918004770fe Type: StorageAction group > MANIPULATE_STORAGE_DOMAIN with role type ADMIN > 2017-12-11 15:25:11,002-05 INFO [org.ovirt.engine.core.bll. > storage.domain.ActivateStorageDomainCommand] > (org.ovirt.thread.pool-6-thread-50) > [49dfce30-0e2c-43f8-942d-67a2b56b3ef8] Lock freed to object > 'EngineLock:{exclusiveLocks='[5662588b-81d2-4da9-b942-8918004770fe=STORAGE]', > sharedLocks=''}' > 2017-12-11 15:25:11,002-05 INFO [org.ovirt.engine.core.bll. > storage.domain.ActivateStorageDomainCommand] > (org.ovirt.thread.pool-6-thread-50) > [49dfce30-0e2c-43f8-942d-67a2b56b3ef8] ActivateStorage Domain. Before > Connect all hosts to pool. Time: Mon Dec 11 15:25:11 EST 2017 > 2017-12-11 15:25:11,015-05 WARN [org.ovirt.engine.core.bll. > storage.connection.BaseFsStorageHelper] (org.ovirt.thread.pool-6-thread-43) > [49dfce30-0e2c-43f8-942d-67a2b56b3ef8] Did not connect host > 'e6dbdeb8-4e0e-4589-9121-6d3408c6d7b0' to storage domain > 'ovirt-lg-1-lun1' because connection for connectionId > 'b3011e5b-552e-4393-a758-ac1e35648ab1' is null. > 2017-12-11 15:25:11,016-05 ERROR [org.ovirt.engine.core.bll. > storage.domain.ActivateStorageDomainCommand] > (org.ovirt.thread.pool-6-thread-50) > [49dfce30-0e2c-43f8-942d-67a2b56b3ef8] Cannot connect storage server, > aborting Storage Domain activation. > 2017-12-11 15:25:11,017-05 INFO [org.ovirt.engine.core.bll. > storage.domain.ActivateStorageDomainCommand] > (org.ovirt.thread.pool-6-thread-50) > [49dfce30-0e2c-43f8-942d-67a2b56b3ef8] Command > [id=0fb1fa9d-4002-4fe0-9af2-d30470d5f146]: Compensating > CHANGED_STATUS_ONLY of > org.ovirt.engine.core.common.businessentities.StoragePoolIsoMap; > snapshot: EntityStatusSnapshot:{id='StoragePoolIsoMapId:{ > storagePoolId='a0cc9e2c-6bff-4d5b-803c-0cd62292c269', > storageId='5662588b-81d2-4da9-b942-8918004770fe'}', status='Maintenance'}. > 2017-12-11 15:25:11,023-05 ERROR [org.ovirt.engine.core.dal. > dbbroker.auditloghandling.AuditLogDirector] > (org.ovirt.thread.pool-6-thread-50) > [49dfce30-0e2c-43f8-942d-67a2b56b3ef8] EVENT_ID: > USER_ACTIVATE_STORAGE_DOMAIN_FAILED(967), Correlation ID: > 49dfce30-0e2c-43f8-942d-67a2b56b3ef8, Job ID: > 2d766e2a-4b35-4822-9580-4eb9df2d9c33, > Call Stack: null, Custom ID: null, Custom Event ID: -1, Message: Failed to > activate Storage Domain ovirt-lg-1-lun1 (Data Center ovirt-lg-1) by > admin@internal-authz > > > select id,storage,storage_name,_update_date from storage_domain_static; > id | > storage | storage_name | > _update_date > --+- > ---++--- > > 072fbaa1-08f3-4a40-9f34-a5ca22dd1d74 | ceab03af-7220-4d42-8f5c-9b557f5d29af > | ovirt-image-repository | > b66443f4-d949-4fca-9825-8cb98eae9e14 | e462883f-0be1-4b31-acf1-154dd7accbc1 > | export | > 45807651-8f10-408f-891b-64f1cc577a64 | 452235ea-d8b1-43d1-920f-a16a032e000b > | ovirt-lg-1-iso | 2017-01-20 20:01:00.284097+00 > a1d803b9-fd0b-477f-a874-53d050d4347b | cd8939df-9cdd-49d3-8dc5-3c06d1836399 > | ovirt-lg-1-export | 2017-01-20 20:01:14.70549+00 > b67e7442-f032-4b5c-a4fe-10422650a90b | c6272852-3586-4584-8496-d97c4370c798 > | ovirt-5-iso| 2017-01-20 20:02:08.668034+00 > a561589c-8eb8-4823-9615-92ac4a1ea94e | cacb8801-6826-42cb-9bab-5552175e0329 > | ovirt-lg-2-export | > 646b331a-b68e-4894-807f-bdc8adae15c9 | a592b780-7bd6-4599-ab7e-12c43cb9279d > | ovirt-lg-2-iso | > 3ba53a0b-30be-497c-b4df-8
Re: [ovirt-users] ?==?utf-8?q? Error "Did not connect host to storage domain because connection for connectionId is null" in ovirt 4.1
Replying to myself here: I fixed it by running this insert statement in the postgresql db to restore the missing connection: insert into storage_server_connections (id, connection, portal, storage_type) values ('b3011e5b-552e-4393-a758-ac1e35648ab1', '/var/ovirt-lun1', '1', '4'); Le Lundi, Décembre 11, 2017 16:29 EST, "Claude Durocher" a écrit: I have a 4.1 ovirt environment. I cannot reactivate a storage domain (data-master) and I get an error message stating "connection for connectionId 'b3011e5b-552e-4393-a758-ac1e35648ab1' is null". I also cannot delete this storage domain as it's a master domain. 2017-12-11 15:25:10,971-05 INFO [org.ovirt.engine.core.bll.storage.domain.ActivateStorageDomainCommand] (default task-22) [49dfce30-0e2c-43f8-942d-67a2b56b3ef8] Lock Acquired to object 'EngineLock:{exclusiveLocks='[5662588b-81d2-4da9-b942-8918004770fe=STORAGE]', sharedLocks=''}' 2017-12-11 15:25:10,999-05 INFO [org.ovirt.engine.core.bll.storage.domain.ActivateStorageDomainCommand] (org.ovirt.thread.pool-6-thread-50) [49dfce30-0e2c-43f8-942d-67a2b56b3ef8] Running command: ActivateStorageDomainCommand internal: false. Entities affected : ID: 5662588b-81d2-4da9-b942-8918004770fe Type: StorageAction group MANIPULATE_STORAGE_DOMAIN with role type ADMIN 2017-12-11 15:25:11,002-05 INFO [org.ovirt.engine.core.bll.storage.domain.ActivateStorageDomainCommand] (org.ovirt.thread.pool-6-thread-50) [49dfce30-0e2c-43f8-942d-67a2b56b3ef8] Lock freed to object 'EngineLock:{exclusiveLocks='[5662588b-81d2-4da9-b942-8918004770fe=STORAGE]', sharedLocks=''}' 2017-12-11 15:25:11,002-05 INFO [org.ovirt.engine.core.bll.storage.domain.ActivateStorageDomainCommand] (org.ovirt.thread.pool-6-thread-50) [49dfce30-0e2c-43f8-942d-67a2b56b3ef8] ActivateStorage Domain. Before Connect all hosts to pool. Time: Mon Dec 11 15:25:11 EST 2017 2017-12-11 15:25:11,015-05 WARN [org.ovirt.engine.core.bll.storage.connection.BaseFsStorageHelper] (org.ovirt.thread.pool-6-thread-43) [49dfce30-0e2c-43f8-942d-67a2b56b3ef8] Did not connect host 'e6dbdeb8-4e0e-4589-9121-6d3408c6d7b0' to storage domain 'ovirt-lg-1-lun1' because connection for connectionId 'b3011e5b-552e-4393-a758-ac1e35648ab1' is null. 2017-12-11 15:25:11,016-05 ERROR [org.ovirt.engine.core.bll.storage.domain.ActivateStorageDomainCommand] (org.ovirt.thread.pool-6-thread-50) [49dfce30-0e2c-43f8-942d-67a2b56b3ef8] Cannot connect storage server, aborting Storage Domain activation. 2017-12-11 15:25:11,017-05 INFO [org.ovirt.engine.core.bll.storage.domain.ActivateStorageDomainCommand] (org.ovirt.thread.pool-6-thread-50) [49dfce30-0e2c-43f8-942d-67a2b56b3ef8] Command [id=0fb1fa9d-4002-4fe0-9af2-d30470d5f146]: Compensating CHANGED_STATUS_ONLY of org.ovirt.engine.core.common.businessentities.StoragePoolIsoMap; snapshot: EntityStatusSnapshot:{id='StoragePoolIsoMapId:{storagePoolId='a0cc9e2c-6bff-4d5b-803c-0cd62292c269', storageId='5662588b-81d2-4da9-b942-8918004770fe'}', status='Maintenance'}. 2017-12-11 15:25:11,023-05 ERROR [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector] (org.ovirt.thread.pool-6-thread-50) [49dfce30-0e2c-43f8-942d-67a2b56b3ef8] EVENT_ID: USER_ACTIVATE_STORAGE_DOMAIN_FAILED(967), Correlation ID: 49dfce30-0e2c-43f8-942d-67a2b56b3ef8, Job ID: 2d766e2a-4b35-4822-9580-4eb9df2d9c33, Call Stack: null, Custom ID: null, Custom Event ID: -1, Message: Failed to activate Storage Domain ovirt-lg-1-lun1 (Data Center ovirt-lg-1) by admin@internal-authz select id,storage,storage_name,_update_date from storage_domain_static; id | storage | storage_name | _update_date --+++--- 072fbaa1-08f3-4a40-9f34-a5ca22dd1d74 | ceab03af-7220-4d42-8f5c-9b557f5d29af | ovirt-image-repository | b66443f4-d949-4fca-9825-8cb98eae9e14 | e462883f-0be1-4b31-acf1-154dd7accbc1 | export | 45807651-8f10-408f-891b-64f1cc577a64 | 452235ea-d8b1-43d1-920f-a16a032e000b | ovirt-lg-1-iso | 2017-01-20 20:01:00.284097+00 a1d803b9-fd0b-477f-a874-53d050d4347b | cd8939df-9cdd-49d3-8dc5-3c06d1836399 | ovirt-lg-1-export | 2017-01-20 20:01:14.70549+00 b67e7442-f032-4b5c-a4fe-10422650a90b | c6272852-3586-4584-8496-d97c4370c798 | ovirt-5-iso | 2017-01-20 20:02:08.668034+00 a561589c-8eb8-4823-9615-92ac4a1ea94e | cacb8801-6826-42cb-9bab-5552175e0329 | ovirt-lg-2-export | 646b331a-b68e-4894-807f-bdc8adae15c9 | a592b780-7bd6-4599-ab7e-12c43cb9279d | ovirt-lg-2-iso | 3ba53a0b-30be-497c-b4df-880e6c6f7567 | 8e5236c9-cbc0-4256-abff-7e984abef65a | master | 2017-12-11 02:12:16.499288+00 3efa5ed5-4e17-4daf-9cc0-6819a9cd7aae | 8d19b66d-1c1c-4976-91d2-8d2565db367a | hosted_storage | 2017-12-11 02:12:16.499288+00 18504f40-fb15-4b1e-8ac3-ec0ea