8:58 a.m.
Hi Ahmad,
I did the following:
1. Storage -> Storage Domains
2 Click the existing Storage Domain and click "Manage Domain"
and then I see next to the LUN which is already part of the SD the "Add"
button
I do not want to click add since it may destroy the existing SD or the content of the
LUNs.
In the Engine Log I see the following:
020-07-14 09:57:45,131+02 WARN
[org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector]
(EE-ManagedThreadFactory-engine-Thread-20) [277145f2] EVENT_ID:
STORAGE_DOMAINS_COULD_NOT_BE_SYNCED(1,046), Storage domains with IDs
[6b82f31b-fa2a-406b-832d-64d9666e1bcc] could not be synchronized. To synchronize them,
please move them to maintenance and then activate.
Thanks a lot
On Tue, 2020-07-14 at 16:07 +0300, Ahmad Khiet wrote:
Hi Arsène Gschwind,
it's really strange that you see "Add" on a LUN that already has been added
to the database.
to verify the steps you did make at first,
1- Storage -> Storage Domains
2- New Domain - [ select iSCSI ]
3- click on "+" on the iscsi target, then you see the "Add" button is
available
4- after clicking add and ok, then this error will be shown in the logs
is that right?
can you also attach vdsm log?
On Tue, Jul 14, 2020 at 1:15 PM Arsène Gschwind
<arsene.gschwind@unibas.ch<mailto:arsene.gschwind@unibas.ch>> wrote:
Hello all,
I've checked all my multipath configuration and everything seems korrekt.
Is there a way to correct this, may be in the DB?
I really need some help, thanks a lot.
Arsène
On Tue, 2020-07-14 at 00:29 +0000, Arsène Gschwind wrote:
HI,
I'm having a strange behavior with a SD. When trying to manage the SD I see they
"Add" button for the LUN which should already be the one use for that SD.
In the Logs I see the following:
2020-07-13 17:48:07,292+02 ERROR
[org.ovirt.engine.core.dal.dbbroker.BatchProcedureExecutionConnectionCallback]
(EE-ManagedThreadFactory-engine-Thread-95) [51091853] Can't execute batch: Batch entry
0 select * from public.insertluns(CAST ('repl_HanaLogs_osd_01' AS varchar),CAST
('DPUtaW-Q5zp-aZos-HriP-5Z0v-hiWO-w7rmwG' AS varchar),CAST
('4TCXZ7-R1l1-xkdU-u0vx-S3n4-JWcE-qksPd1' AS varchar),CAST
('SHUAWEI_XSG1_2102350RMG10HC0000200035' AS varchar),CAST (7 AS int4),CAST
('HUAWEI' AS varchar),CAST ('XSG1' AS varchar),CAST (2548 AS int4),CAST
(268435456 AS int8)) as result was aborted: ERROR: duplicate key value violates unique
constraint "pk_luns"
Detail: Key (lun_id)=(repl_HanaLogs_osd_01) already exists.
Where: SQL statement "INSERT INTO LUNs (
LUN_id,
physical_volume_id,
volume_group_id,
serial,
lun_mapping,
vendor_id,
product_id,
device_size,
discard_max_size
)
VALUES (
v_LUN_id,
v_physical_volume_id,
v_volume_group_id,
v_serial,
v_lun_mapping,
v_vendor_id,
v_product_id,
v_device_size,
v_discard_max_size
)"
PL/pgSQL function insertluns(character varying,character varying,character
varying,character varying,integer,character varying,character varying,integer,bigint) line
3 at SQL statement Call getNextException to see other errors in the batch.
2020-07-13 17:48:07,292+02 ERROR
[org.ovirt.engine.core.dal.dbbroker.BatchProcedureExecutionConnectionCallback]
(EE-ManagedThreadFactory-engine-Thread-95) [51091853] Can't execute batch. Next
exception is: ERROR: duplicate key value violates unique constraint "pk_luns"
Detail: Key (lun_id)=(repl_HanaLogs_osd_01) already exists.
Where: SQL statement "INSERT INTO LUNs (
LUN_id,
physical_volume_id,
volume_group_id,
serial,
lun_mapping,
vendor_id,
product_id,
device_size,
discard_max_size
)
VALUES (
v_LUN_id,
v_physical_volume_id,
v_volume_group_id,
v_serial,
v_lun_mapping,
v_vendor_id,
v_product_id,
v_device_size,
v_discard_max_size
)"
PL/pgSQL function insertluns(character varying,character varying,character
varying,character varying,integer,character varying,character varying,integer,bigint) line
3 at SQL statement
2020-07-13 17:48:07,293+02 INFO
[org.ovirt.engine.core.utils.transaction.TransactionSupport]
(EE-ManagedThreadFactory-engine-Thread-95) [51091853] transaction rolled back
2020-07-13 17:48:07,293+02 ERROR
[org.ovirt.engine.core.bll.storage.domain.SyncLunsInfoForBlockStorageDomainCommand]
(EE-ManagedThreadFactory-engine-Thread-95) [51091853] Command
'org.ovirt.engine.core.bll.storage.domain.SyncLunsInfoForBlockStorageDomainCommand'
failed: ConnectionCallback; ]; ERROR: duplicate key value violates unique constraint
"pk_luns"
Detail: Key (lun_id)=(repl_HanaLogs_osd_01) already exists.
Where: SQL statement "INSERT INTO LUNs (
LUN_id,
physical_volume_id,
volume_group_id,
serial,
lun_mapping,
vendor_id,
product_id,
device_size,
discard_max_size
)
VALUES (
v_LUN_id,
v_physical_volume_id,
v_volume_group_id,
v_serial,
v_lun_mapping,
v_vendor_id,
v_product_id,
v_device_size,
v_discard_max_size
)"
It looks like the engine will add a LUN to an SD and it already exist...
Any Idea how to resolve that problem?
Thanks a lot
--
Arsène Gschwind
<arsene.gschwind@unibas.ch<mailto:arsene.gschwind@unibas.ch>>
Universitaet Basel
_______________________________________________
Users mailing list --
<mailto:users@ovirt.org>
users(a)ovirt.org
To unsubscribe send an email to
<mailto:users-leave@ovirt.org>
users-leave(a)ovirt.org
Privacy Statement:
<https://www.ovirt.org/privacy-policy.html>
https://www.ovirt.org/privacy-policy.html
oVirt Code of Conduct:
<https://www.ovirt.org/community/about/community-guidelines/>
https://www.ovirt.org/community/about/community-guidelines/
List Archives:
<https://lists.ovirt.org/archives/list/users@ovirt.org/message/2YE7ZX53W4W...
https://lists.ovirt.org/archives/list/users@ovirt.org/message/2YE7ZX53W4W...
--
Arsène Gschwind
<arsene.gschwind@unibas.ch<mailto:arsene.gschwind@unibas.ch>>
Universitaet Basel
_______________________________________________
Users mailing list -- users@ovirt.org<mailto:users@ovirt.org>
To unsubscribe send an email to
users-leave@ovirt.org<mailto:users-leave@ovirt.org>
Privacy Statement: https://www.ovirt.org/privacy-policy.html
oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/
List Archives:
https://lists.ovirt.org/archives/list/users@ovirt.org/message/4UNSPGYZPYR...
--
Arsène Gschwind
Fa. Sapify AG im Auftrag der universitaet Basel
IT Services
Klinelbergstr. 70 | CH-4056 Basel | Switzerland
Tel: +41 79 449 25 63 | http://its.unibas.ch
ITS-ServiceDesk: support-its@unibas.ch<mailto:support-its@unibas.ch> | +41 61 267 14
11