[ovirt-users] ?==?utf-8?q? Error "Did not connect host to storage domain because connection for connectionId is null" in ovirt 4.1

Claude Durocher claude.durocher at cptaq.gouv.qc.ca
Mon Dec 11 22:32:13 UTC 2017


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" <claude.durocher at 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 at 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-ec0eabdc5619 | SPA1ZX-n7rh-s14h-wuRC-071z-RShH-wmzmqj | storage-1-lun0         | 2017-12-11 02:12:16.499288+00
 730c14db-d4ef-4d0e-9670-419b803fe634 | 7Zxqu3-nVUD-HnN7-w4Xf-TFi7-BKrJ-OzMyRA | storage-3-lun0         | 2017-12-11 02:12:16.499288+00
 190bc841-e6b0-45b8-bfbb-7518735d8592 | y7oM6F-Tx0Y-QWxg-gk9R-Xlfm-Mz9A-fOx5RN | storage-2-lun0         | 2017-12-11 02:12:16.499288+00
 45114ecf-6af5-4cce-81aa-12779ff007ef | MU3vBR-39KZ-UvuD-R4gg-hw1a-iyNu-D0Igvu | storage-2-lun1         | 2017-12-11 02:12:16.499288+00
 0f57345d-e310-4779-a987-2362458debd4 | 60f3afa7-35fb-4ff7-becc-a4a0c9b3884a   | ovirt-5-lun2           | 2017-12-11 02:12:36.638249+00
 d9d03670-4cfd-42d7-b4b7-834a53c3e0d6 | 677a9e5b-f844-49ee-ad1f-989e168187cf   | ovirt-5-lun1           | 2017-12-11 02:12:36.638249+00
 
 5662588b-81d2-4da9-b942-8918004770fe | b3011e5b-552e-4393-a758-ac1e35648ab1   | ovirt-lg-1-lun1        | 2017-12-11 02:12:55.351124+00
 
 07593976-d27b-4ac8-ba19-a77a1f1e5d52 | 677a9e5b-f844-49ee-ad1f-989e168187cf   | ovirt-lg-2-lun1        | 2017-12-11 02:13:12.998165+00
 ca0e59ed-7c9e-45a0-a77c-143f3ad19dff | 6650a140-ba2b-42b9-bb14-5b331f87b60c   | iso                    | 2017-12-11 15:55:53.891326+00
(18 rows)


select id,_update_date from storage_domain_dynamic;
                  id                  |         _update_date          
--------------------------------------+-------------------------------
 072fbaa1-08f3-4a40-9f34-a5ca22dd1d74 |
 b67e7442-f032-4b5c-a4fe-10422650a90b | 2017-12-11 20:45:50.517595+00
 0f57345d-e310-4779-a987-2362458debd4 | 2017-12-11 20:45:50.52089+00
 d9d03670-4cfd-42d7-b4b7-834a53c3e0d6 | 2017-12-11 20:45:50.523789+00
 b66443f4-d949-4fca-9825-8cb98eae9e14 | 2017-12-11 20:45:50.526227+00
 18504f40-fb15-4b1e-8ac3-ec0eabdc5619 | 2017-12-11 20:45:55.743157+00
 3ba53a0b-30be-497c-b4df-880e6c6f7567 | 2017-12-11 20:45:55.745959+00
 3efa5ed5-4e17-4daf-9cc0-6819a9cd7aae | 2017-12-11 20:45:55.748615+00
 ca0e59ed-7c9e-45a0-a77c-143f3ad19dff | 2017-12-11 20:45:55.751164+00
 190bc841-e6b0-45b8-bfbb-7518735d8592 | 2017-12-11 20:45:55.753756+00
 45114ecf-6af5-4cce-81aa-12779ff007ef | 2017-12-11 20:45:55.756197+00
 730c14db-d4ef-4d0e-9670-419b803fe634 | 2017-12-11 20:45:55.75873+00
 07593976-d27b-4ac8-ba19-a77a1f1e5d52 | 2017-12-11 20:45:57.472521+00
 646b331a-b68e-4894-807f-bdc8adae15c9 | 2017-12-11 20:45:57.475366+00
 a561589c-8eb8-4823-9615-92ac4a1ea94e | 2017-12-11 20:45:57.477804+00
 
 5662588b-81d2-4da9-b942-8918004770fe | 2017-12-11 18:56:53.148042+00
 
 45807651-8f10-408f-891b-64f1cc577a64 | 2017-12-11 18:56:08.404201+00
 a1d803b9-fd0b-477f-a874-53d050d4347b | 2017-12-11 18:56:18.64931+00
(18 rows)


select id,connection from storage_server_connections;
                  id                  |                     connection                     
--------------------------------------+----------------------------------------------------
 8e5236c9-cbc0-4256-abff-7e984abef65a | 10.17.77.16:/exports/ovirt-master
 8d19b66d-1c1c-4976-91d2-8d2565db367a | 10.17.77.16:/exports/ovirt-hosted_storage
 6650a140-ba2b-42b9-bb14-5b331f87b60c | 10.17.77.16:/exports/ovirt-iso
 e462883f-0be1-4b31-acf1-154dd7accbc1 | 10.17.77.16:/exports/ovirt-export
 50b9a77a-8f79-47b3-9a48-b2b25ea72087 | 10.17.77.16
 9bfbd44b-7311-4b6e-8c77-c955397c2a66 | 10.17.77.48
 d6c3980a-4774-4350-83d1-206e41848b4a | 10.17.77.17
 3c39707c-a4d2-4221-9a8f-2a0503533387 | 10.17.77.49
 4503e074-10d3-4163-8ada-1826790c437c | 10.17.77.18
 93bf0c70-959c-4b1f-93ff-45d920ef7525 | 10.17.77.50
 677a9e5b-f844-49ee-ad1f-989e168187cf | /var/ovirt-lun1
 c6272852-3586-4584-8496-d97c4370c798 | /var/ovirt-iso
 452235ea-d8b1-43d1-920f-a16a032e000b | /var/ovirt-iso
 cacb8801-6826-42cb-9bab-5552175e0329 | stori-lg.cptaq.local:/mnt/ovirt-lg-2-export/export
 a592b780-7bd6-4599-ab7e-12c43cb9279d | /var/ovirt-iso
 60f3afa7-35fb-4ff7-becc-a4a0c9b3884a | /var/ovirt-lun2
 
 efd9854f-b348-4aa8-871f-1d408d4dd9b1 | /var/ovirt-lun1
 
 cd8939df-9cdd-49d3-8dc5-3c06d1836399 | /var/ovirt-export
 8d9067ac-4eff-4aa8-8d1b-2bd2e268f124 | /var/ovirt-lun1
(19 rows)


select * from storage_pool_iso_map;
              storage_id              |           storage_pool_id            | status
--------------------------------------+--------------------------------------+--------
 45807651-8f10-408f-891b-64f1cc577a64 | a0cc9e2c-6bff-4d5b-803c-0cd62292c269 |      6
 a1d803b9-fd0b-477f-a874-53d050d4347b | a0cc9e2c-6bff-4d5b-803c-0cd62292c269 |      6
 b67e7442-f032-4b5c-a4fe-10422650a90b | e15014b4-3968-42f0-8eef-375bd6c1469a |      3
 0f57345d-e310-4779-a987-2362458debd4 | e15014b4-3968-42f0-8eef-375bd6c1469a |      3
 d9d03670-4cfd-42d7-b4b7-834a53c3e0d6 | e15014b4-3968-42f0-8eef-375bd6c1469a |      3
 b66443f4-d949-4fca-9825-8cb98eae9e14 | e15014b4-3968-42f0-8eef-375bd6c1469a |      3
 
 5662588b-81d2-4da9-b942-8918004770fe | a0cc9e2c-6bff-4d5b-803c-0cd62292c269 |      6
 
 18504f40-fb15-4b1e-8ac3-ec0eabdc5619 | 582dc434-0270-017f-0138-00000000006d |      3
 3ba53a0b-30be-497c-b4df-880e6c6f7567 | 582dc434-0270-017f-0138-00000000006d |      3
 3efa5ed5-4e17-4daf-9cc0-6819a9cd7aae | 582dc434-0270-017f-0138-00000000006d |      3
 190bc841-e6b0-45b8-bfbb-7518735d8592 | 582dc434-0270-017f-0138-00000000006d |      3
 45114ecf-6af5-4cce-81aa-12779ff007ef | 582dc434-0270-017f-0138-00000000006d |      3
 730c14db-d4ef-4d0e-9670-419b803fe634 | 582dc434-0270-017f-0138-00000000006d |      3
 07593976-d27b-4ac8-ba19-a77a1f1e5d52 | a5d7157a-4bf4-436c-b444-a76ee5f7bb12 |      3
 646b331a-b68e-4894-807f-bdc8adae15c9 | a5d7157a-4bf4-436c-b444-a76ee5f7bb12 |      3
 a561589c-8eb8-4823-9615-92ac4a1ea94e | a5d7157a-4bf4-436c-b444-a76ee5f7bb12 |      3
 ca0e59ed-7c9e-45a0-a77c-143f3ad19dff | 582dc434-0270-017f-0138-00000000006d |      3
(17 rows)



 

 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20171211/9e1e76c0/attachment.html>


More information about the Users mailing list